You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-user@james.apache.org by Samuel Sadek <sa...@hotmail.com> on 2002/02/23 02:04:43 UTC
RE: How to make James work with Oracle database?
Danny,
I've followed the suggested instructions below and these are the output I've
got from my POP server:
>what does the content of the message_body field contain? it should >hold a
>complete mail message with all its headers.
Initially I sqlplus'd into my oracle db and executed the following SQL
statements:
SQL> select message_state from inbox;
MESSAGE_STATE
------------------------------
root
root
root
root
root
root
6 rows selected.
SQL> select message_body from inbox;
MESSAGE_BODY
--------------------------------------------------------------------------------
33353332333633353337333433373335333733323336343533323434333533303336333133373334
33353332333633353337333433373335333733323336343533323434333533303336333133373334
33353332333633353337333433373335333733323336343533323434333533303336333133373334
33353332333633353337333433373335333733323336343533323434333533303336333133373334
33353332333633353337333433373335333733323336343533323434333533303336333133373334
33353332333633353337333433373335333733323336343533323434333533303336333133373334
6 rows selected.
Could you please explain to me what root in message_state means and if it
reflects successful mail delivery.
>Does the POP server serve the mail correctly? you could try telnetting >to
>port 110, the commands are
I've telnetted to my POP server and got the following response back:
+OK secemail.dnsalias.com POP3 server (JAMES POP3 Server 2.0a2) ready
which suggests to me that it's up and running.
>USER [username]
logged in as a recipient attempting to read the delivered mail and got the
following response back:
+OK
>PASS [password]
entered valid password for above user and got back:
+OK Welcome monica
>LIST
+OK 6 24000
1 4000
2 4000
3 4000
4 4000
5 4000
6 4000
.
>RETR [number of a message from list]
typed in RETR 3 to yield third message content and got back:
+OK Message follows
33353332333633353337333433373335333733323336343533323434333533303336333133373334
33363338333334313332333033333433333733333336333133363434333733353336333533363433
33343330333733333336333533363333333633353336343433363331333633393336343333323435
33363334333634353337333333363331333634333336333933363331333733333332343533363333
33363436333634343333343533303434333034313335333233363335333633333336333533363339
33373336333633353336333433333431333233303336333633373332333634363336343433323330
33373332333633383336333533363435333633393337333533363434333234353336333233373334
33363339333634353337333433363335333733323336343533363335333733343332343533363333
33363436333634343332333033323338333534323333333133333339333333343332343533333337
33333333333234353333333733333333333234353333333933333333333534343332333933303434
33303431333233303332333033323330333233303332333033323330333233303332333033323330
33323330333633323337333933323330333733333336333533363333333633353336343433363331
33363339333634333332343533363334333634353337333333363331333634333336333933363331
33373333333234353336333333363436333634343332333033323338333434313334333133343434
33343335333533333332333033353333333434343335333433353330333233303335333333363335
33373332333733363336333533373332333233303333333233323435333333303336333133333332
33323339333233303337333733363339333733343336333833323330333533333334343433353334
33353330333233303334333933343334333233303333333233333338333333343330343433303431
33323330333233303332333033323330333233303332333033323330333233303332333033323330
33363336333634363337333233323330333334333336343433363436333634353336333933363333
33363331333433303337333333363335333633333336333533363434333633313336333933363433
33323435333633343336343533373333333633313336343333363339333633313337333333323435
33363333333634363336343433333435333334323330343433303431333233303332333033323330
33323330333233303332333033323330333233303332333033323330333533333336333133373334
33323433333233303333333233333333333233303334333633363335333633323332333033333332
33333330333333303333333233323330333333303333333033333431333333303333333333333431
33333335333333373332333033323432333333303333333033333330333333303330343433303431
33353332333633353336333333363335333633393337333633363335333633343333343133323330
33363336333733323336343633363434333233303336333833363436333733333337333433333332
33333331333333373332343433333333333333393332343433333334333333303332343433333331
33333332333333343332343533363339333634353332343433363331333633343336333433373332
33323435333633323337333433363436333733303336333533363435333733373336343633373332
33363433333633343332343533363333333634363336343433323330333233383335343233333332
33333331333333373332343533333333333333393332343533333334333333303332343533333331
33333332333333343335343433323330333633383336333533363433333634363333343433363436
33373332333633313336343533363337333633353332333933303434333034313330333933363332
33373339333233303337333233363338333633353336343533363339333733353336343433323435
33363332333733343336333933363435333733343336333533373332333634353336333533373334
33323435333633333336343633363434333233303337333733363339333733343336333833323330
33363335333733333336343433373334333733303332333033323338333433353337333833363339
33363434333233303333333333323435333333323333333233323330333233333333333833323339
33303434333034313330333933363339333633343332333033333331333333363336333533353330
33363335333333373332343433333330333333303333333033333335333333383337333033323434
33333330333333303330343433303431333033393336333633363436333733323332333033363434
33363436333634353336333933363333333633313334333033373333333633353336333333363335
33363434333633313336333933363433333234353336333433363435333733333336333133363433
33363339333633313337333333323435333633333336343633363434333334323332333033353333
33363331333733343332343333323330333333323333333333323330333433363336333533363332
33323330333333323333333033333330333333323332333033333330333333303333343133333330
33333332333334313333333333333335333233303332343233333330333333303333333033333330
.
>QUIT
and then quitted pop session from console.
>d.
Can you please tell me if any aspect of oracle config is incorrect, the
message's body is actually stored correctly in the db, and if so, what could
be the cause of my pop3 client not able to receive the message header and
more importantly, the message body?
One point I need to make is I'm able to query the message headers from the
db correctly...
Would appreciate your feedback.
Thanks in advance,
Sam.
>-----Original Message-----
>From: Samuel Sadek [mailto:samuel_sadek@hotmail.com]
>Sent: Friday, February 22, 2002 7:44 PM
>To: james-user@jakarta.apache.org
>Subject: RE: How to make James work with Oracle database?
>
>
>I'm experiencing some major problems with JAMES hooked with Oracle 8.1.7.
>The problem doesn't reside receiving, processing new mail and
>thus storing
>the resulting message in the inbox table in Oracle as I've ran a check on
>the size of the table via "select count(*) from inbox", but
>actually reading
>the new mail off from inbox table using a customised POP mail client
>software using JavaMail. I've used the same client to access
>other POP mail
>with no problems at all, but when I attempt to read from JAMES
>POP server it
>doesn't receive it!!!
>
>Please find below the create SQL clause I've used to create the
>inbox table
>in the first place:
>
><sql name="createTable" db="oracle">
> CREATE TABLE ${table} (
> message_name varchar2 (200) NOT NULL,
> repository_name varchar2 (200) NOT NULL,
> message_state varchar2 (30) NOT NULL ,
> error_message varchar2 (200) NULL ,
> sender varchar2 (200) ,
> recipients varchar2 (1000) NOT NULL ,
> remote_host varchar2 (100) NOT NULL ,
> remote_addr varchar2 (20) NOT NULL ,
> message_body long NOT NULL ,
> last_updated date NOT NULL ,
> PRIMARY KEY (message_name, repository_name)
> )
> TABLESPACE system
></sql>
>
>I'm also aware of Sun's problem with ot reading data off from
>clob so I've
>used a long data type which is standard and should not be the
>cause of the
>problem (althought I'm hoping that's not the case!).
>
>This thread seems to be rather long-winded and pervasive but I would
>appreciate it your comments/feedback on the matter.
>
>Thanks.
>
>Sam.
>
>
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: How to make James work with Oracle database?
Posted by Danny Angus <da...@thought.co.uk>.
long is the wrong datatype ... I dont know what Oracle datatype it should
be, but MySQL has one called LONGTEXT that I use.
d.
> -----Original Message-----
> From: Samuel Sadek [mailto:samuel_sadek@hotmail.com]
> Sent: Saturday, February 23, 2002 1:05 AM
> To: james-user@jakarta.apache.org
> Subject: RE: How to make James work with Oracle database?
>
>
> Danny,
>
> I've followed the suggested instructions below and these are the
> output I've
> got from my POP server:
>
> >what does the content of the message_body field contain? it
> should >hold a
> >complete mail message with all its headers.
>
> Initially I sqlplus'd into my oracle db and executed the following SQL
> statements:
>
> SQL> select message_state from inbox;
>
> MESSAGE_STATE
> ------------------------------
> root
> root
> root
> root
> root
> root
>
> 6 rows selected.
>
> SQL> select message_body from inbox;
>
> MESSAGE_BODY
> ------------------------------------------------------------------
> --------------
> 333533323336333533373334333733353337333233363435333234343335333033
> 36333133373334
>
> 333533323336333533373334333733353337333233363435333234343335333033
> 36333133373334
>
> 333533323336333533373334333733353337333233363435333234343335333033
> 36333133373334
>
> 333533323336333533373334333733353337333233363435333234343335333033
> 36333133373334
>
> 333533323336333533373334333733353337333233363435333234343335333033
> 36333133373334
>
> 333533323336333533373334333733353337333233363435333234343335333033
> 36333133373334
>
> 6 rows selected.
>
> Could you please explain to me what root in message_state means and if it
> reflects successful mail delivery.
>
>
> >Does the POP server serve the mail correctly? you could try
> telnetting >to
> >port 110, the commands are
>
> I've telnetted to my POP server and got the following response back:
>
> +OK secemail.dnsalias.com POP3 server (JAMES POP3 Server 2.0a2) ready
>
> which suggests to me that it's up and running.
>
> >USER [username]
>
> logged in as a recipient attempting to read the delivered mail
> and got the
> following response back:
>
> +OK
>
> >PASS [password]
>
> entered valid password for above user and got back:
>
> +OK Welcome monica
>
> >LIST
>
> +OK 6 24000
> 1 4000
> 2 4000
> 3 4000
> 4 4000
> 5 4000
> 6 4000
> .
>
> >RETR [number of a message from list]
>
> typed in RETR 3 to yield third message content and got back:
>
> +OK Message follows
> 333533323336333533373334333733353337333233363435333234343335333033
> 36333133373334
> 333633383333343133323330333334333337333333363331333634343337333533
> 36333533363433
> 333433303337333333363335333633333336333533363434333633313336333933
> 36343333323435
> 333633343336343533373333333633313336343333363339333633313337333333
> 32343533363333
> 333634363336343433333435333034343330343133353332333633353336333333
> 36333533363339
> 333733363336333533363334333334313332333033363336333733323336343633
> 36343433323330
> 333733323336333833363335333634353336333933373335333634343332343533
> 36333233373334
> 333633393336343533373334333633353337333233363435333633353337333433
> 32343533363333
> 333634363336343433323330333233383335343233333331333333393333333433
> 32343533333337
> 333333333332343533333337333333333332343533333339333333333335343433
> 32333933303434
> 333034313332333033323330333233303332333033323330333233303332333033
> 32333033323330
> 333233303336333233373339333233303337333333363335333633333336333533
> 36343433363331
> 333633393336343333323435333633343336343533373333333633313336343333
> 36333933363331
> 333733333332343533363333333634363336343433323330333233383334343133
> 34333133343434
> 333433353335333333323330333533333334343433353334333533303332333033
> 35333333363335
> 333733323337333633363335333733323332333033333332333234353333333033
> 36333133333332
> 333233393332333033373337333633393337333433363338333233303335333333
> 34343433353334
> 333533303332333033343339333433343332333033333332333333383333333433
> 30343433303431
> 333233303332333033323330333233303332333033323330333233303332333033
> 32333033323330
> 333633363336343633373332333233303333343333363434333634363336343533
> 36333933363333
> 333633313334333033373333333633353336333333363335333634343336333133
> 36333933363433
> 333234353336333433363435333733333336333133363433333633393336333133
> 37333333323435
> 333633333336343633363434333334353333343233303434333034313332333033
> 32333033323330
> 333233303332333033323330333233303332333033323330333233303335333333
> 36333133373334
> 333234333332333033333332333333333332333033343336333633353336333233
> 32333033333332
> 333333303333333033333332333233303333333033333330333334313333333033
> 33333333333431
> 333333353333333733323330333234323333333033333330333333303333333033
> 30343433303431
> 333533323336333533363333333633353336333933373336333633353336333433
> 33343133323330
> 333633363337333233363436333634343332333033363338333634363337333333
> 37333433333332
> 333333313333333733323434333333333333333933323434333333343333333033
> 32343433333331
> 333333323333333433323435333633393336343533323434333633313336333433
> 36333433373332
> 333234353336333233373334333634363337333033363335333634353337333733
> 36343633373332
> 333634333336333433323435333633333336343633363434333233303332333833
> 35343233333332
> 333333313333333733323435333333333333333933323435333333343333333033
> 32343533333331
> 333333323333333433353434333233303336333833363335333634333336343633
> 33343433363436
> 333733323336333133363435333633373336333533323339333034343330343133
> 30333933363332
> 333733393332333033373332333633383336333533363435333633393337333533
> 36343433323435
> 333633323337333433363339333634353337333433363335333733323336343533
> 36333533373334
> 333234353336333333363436333634343332333033373337333633393337333433
> 36333833323330
> 333633353337333333363434333733343337333033323330333233383334333533
> 37333833363339
> 333634343332333033333333333234353333333233333332333233303332333333
> 33333833323339
> 333034343330343133303339333633393336333433323330333333313333333633
> 36333533353330
> 333633353333333733323434333333303333333033333330333333353333333833
> 37333033323434
> 333333303333333033303434333034313330333933363336333634363337333233
> 32333033363434
> 333634363336343533363339333633333336333133343330333733333336333533
> 36333333363335
> 333634343336333133363339333634333332343533363334333634353337333333
> 36333133363433
> 333633393336333133373333333234353336333333363436333634343333343233
> 32333033353333
> 333633313337333433323433333233303333333233333333333233303334333633
> 36333533363332
> 333233303333333233333330333333303333333233323330333333303333333033
> 33343133333330
> 333333323333343133333333333333353332333033323432333333303333333033
> 33333033333330
> .
>
> >QUIT
>
> and then quitted pop session from console.
>
> >d.
>
> Can you please tell me if any aspect of oracle config is incorrect, the
> message's body is actually stored correctly in the db, and if so,
> what could
> be the cause of my pop3 client not able to receive the message header and
> more importantly, the message body?
>
> One point I need to make is I'm able to query the message headers
> from the
> db correctly...
>
> Would appreciate your feedback.
>
> Thanks in advance,
>
> Sam.
>
> >-----Original Message-----
> >From: Samuel Sadek [mailto:samuel_sadek@hotmail.com]
> >Sent: Friday, February 22, 2002 7:44 PM
> >To: james-user@jakarta.apache.org
> >Subject: RE: How to make James work with Oracle database?
> >
> >
> >I'm experiencing some major problems with JAMES hooked with Oracle 8.1.7.
> >The problem doesn't reside receiving, processing new mail and
> >thus storing
> >the resulting message in the inbox table in Oracle as I've ran a check on
> >the size of the table via "select count(*) from inbox", but
> >actually reading
> >the new mail off from inbox table using a customised POP mail client
> >software using JavaMail. I've used the same client to access
> >other POP mail
> >with no problems at all, but when I attempt to read from JAMES
> >POP server it
> >doesn't receive it!!!
> >
> >Please find below the create SQL clause I've used to create the
> >inbox table
> >in the first place:
> >
> ><sql name="createTable" db="oracle">
> > CREATE TABLE ${table} (
> > message_name varchar2 (200) NOT NULL,
> > repository_name varchar2 (200) NOT NULL,
> > message_state varchar2 (30) NOT NULL ,
> > error_message varchar2 (200) NULL ,
> > sender varchar2 (200) ,
> > recipients varchar2 (1000) NOT NULL ,
> > remote_host varchar2 (100) NOT NULL ,
> > remote_addr varchar2 (20) NOT NULL ,
> > message_body long NOT NULL ,
> > last_updated date NOT NULL ,
> > PRIMARY KEY (message_name, repository_name)
> > )
> > TABLESPACE system
> ></sql>
> >
> >I'm also aware of Sun's problem with ot reading data off from
> >clob so I've
> >used a long data type which is standard and should not be the
> >cause of the
> >problem (althought I'm hoping that's not the case!).
> >
> >This thread seems to be rather long-winded and pervasive but I would
> >appreciate it your comments/feedback on the matter.
> >
> >Thanks.
> >
> >Sam.
> >
> >
>
>
> _________________________________________________________________
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>