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 me...@michaeldoherty.freeserve.co.uk on 2002/10/05 14:38:27 UTC

Re: Re: Accessing James POP3 mailbox from a web tool

Thanks for your responses.  The link provided by Stefano below looked remarkably similar so I downloaded v2.0a3 again.  This time it worked like a charm :-)

Next question - is there a GUI for the admin server (port 4555)?  If not, are there any plans to develop one?

Thanks again,
Michael
> 
> From: Stefano Debenedetti <st...@webaccess.mozquito.com>
> Date: Sat 28/Sep/2002 17:44 GMT
> To: James Users List <ja...@jakarta.apache.org>
> CC: michaeldoherty.freeserve.co.uk@pop.pol.net.uk
> Subject: Re: Accessing James POP3 mailbox from a web tool
> 
> I think this may be related to this:
> 
> http://www.mail-archive.com/james-dev@jakarta.apache.org/msg03497.html
> 
> ciao
> ste
> 
> Noel J. Bergman wrote:
> > Michael,
> > 
> > That doesn't look as if James is running properly on your system at all, if
> > it can't find DefaultJamesUser.  What version of James?
> > 
> > You should be able to telnet into your server on the POP3 port, and run the
> > commands manually to test.
> > 
> > 	--- Noel
> > 
> > -----Original Message-----
> > From: michaeldoherty.freeserve.co.uk@pop3.freeserve.com
> > [mailto:michaeldoherty.freeserve.co.uk@pop.pol.net.uk]
> > Sent: Saturday, September 28, 2002 10:04
> > To: james-user@jakarta.apache.org
> > Subject: Accessing James POP3 mailbox from a web tool
> > 
> > 
> > Dear James Users,
> > 
> > I am trying to view a user's mailbox on my James server using the
> > www.mail2web.com tool which can access POP3-enabled mail servers.  However,
> > on submitting an account name and password, the text below appears in the
> > James pop3server.log  (Note: machine name on which James is running =
> > MIKED, James account name = mike2, James account password = password).  Any
> > pointers on how to alleviate this would be greatly appreciated.
> > 
> > Thanks in advance,
> > Michael
> > 
> > ------------------------------------------------------------------
> > 1033220867531 [INFO   ] (pop3server): POP3Server init...
> > 1033220867531 [INFO   ] (pop3server): POP3Listener using plain on port 110
> > 1033220867531 [INFO   ] (pop3server): POP3Server ...init end
> > 1033220888125 [INFO   ] (pop3server): Hello Name is: MIKED
> > 1033220892859 [INFO   ] (pop3server): Connection from 168.144.108.79
> > (168.144.108.79)
> > 1033220894812 [INFO   ] (pop3server): Command received: USER mike2
> > 1033220894953 [INFO   ] (pop3server): Command received: PASS password
> > 1033220894968 [ERROR  ] (pop3server): Exception during connection from
> > 168.144.108.79 (168.144.108.79) : Exception retrieving
> > Userjava.lang.RuntimeException: Exception caught while retrieving an
> > object: java.lang.ClassNotFoundException:
> > org.apache.james.userrepository.DefaultJamesUser
> > java.lang.RuntimeException: Exception retrieving
> > Userjava.lang.RuntimeException: Exception caught while retrieving an
> > object: java.lang.ClassNotFoundException:
> > org.apache.james.userrepository.DefaultJamesUser
> > 	at
> > org.apache.james.userrepository.UsersFileRepository.test(UsersFileRepository
> > .java:221)
> > 	at org.apache.james.pop3server.POP3Handler.doPASS(POP3Handler.java:224)
> > 	at
> > org.apache.james.pop3server.POP3Handler.parseCommand(POP3Handler.java:187)
> > 	at
> > org.apache.james.pop3server.POP3Handler.handleConnection(POP3Handler.java:12
> > 5)
> > 	at
> > org.apache.avalon.cornerstone.blocks.connection.ConnectionRunner.run(Connect
> > ion.java:167)
> > 	at
> > org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Executabl
> > eRunnable.java:47)
> > 	at
> > org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.java:8
> > 6)
> > 1033220896078 [INFO   ] (pop3server): Hello Name is: MIKED
> > 1033220900578 [INFO   ] (pop3server): Connection from 168.144.108.79
> > (168.144.108.79)
> > 1033220900718 [INFO   ] (pop3server): Command received: USER mike2
> > 1033220900859 [INFO   ] (pop3server): Command received: PASS password
> > 1033220900859 [ERROR  ] (pop3server): Exception during connection from
> > 168.144.108.79 (168.144.108.79) : Exception retrieving
> > Userjava.lang.RuntimeException: Exception caught while retrieving an
> > object: java.lang.ClassNotFoundException:
> > org.apache.james.userrepository.DefaultJamesUser
> > java.lang.RuntimeException: Exception retrieving
> > Userjava.lang.RuntimeException: Exception caught while retrieving an
> > object: java.lang.ClassNotFoundException:
> > org.apache.james.userrepository.DefaultJamesUser
> > 	at
> > org.apache.james.userrepository.UsersFileRepository.test(UsersFileRepository
> > .java:221)
> > 	at org.apache.james.pop3server.POP3Handler.doPASS(POP3Handler.java:224)
> > 	at
> > org.apache.james.pop3server.POP3Handler.parseCommand(POP3Handler.java:187)
> > 	at
> > org.apache.james.pop3server.POP3Handler.handleConnection(POP3Handler.java:12
> > 5)
> > 	at
> > org.apache.avalon.cornerstone.blocks.connection.ConnectionRunner.run(Connect
> > ion.java:167)
> > 	at
> > org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Executabl
> > eRunnable.java:47)
> > 	at
> > org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.java:8
> > 6)
> > 
> > --------------------------------------------------------------------
> > mail2web - Check your email from the web at
> > http://mail2web.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>
> > 
> > 
> 
> 
> --
> To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
> 
> 
> 


_______________________________________________________________________
Freeserve AnyTime, only £13.99 per month with one month's FREE trial!
For more information visit http://www.freeserve.com/time/ or call free on 0800 970 8890



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


Re: Accessing James POP3 mailbox from a web tool

Posted by Stefano Debenedetti <st...@webaccess.mozquito.com>.
Hello, I wouldn't mind having that code as we are now starting using 
james to provide XML email accounts to betatesters, for more info please 
see [1]
thanks
ciao
ste

[1] http://radio.weblogs.com/0107886/2002/10/01.html#a48

serwa akoto quarshie wrote:
> One of the developers in my office has developed a GUI for the admin
> interface... that basically mimics the telnet 4555 procedure.
> If you ask nicely I just might send the code to you: >)
> What platform are you running James on any way?
> Tell me how many users do you have using James and does it work???
> Thanx


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


Re: Accessing James POP3 mailbox from a web tool

Posted by simon <si...@sydneybluegum.com>.
Hi,
I have my james user repository in mysql, it automactically created a 
table called users and one called inbox
after i updated config.xml.

 From my tomcat web server i have a mail admin jsp that can read and 
update the users table.

the code need some/a lot more work, it uses onClick and onChange 
javascripts to update info.

If this is what you or any one else is looking  for please let me know 
and i will put some comments in and
send it.

I also have a another jsp that uses the following sql to display info 
about messages from the inbox.

------------------------------------------------------------------------------------------------------
Count of  mail by user in the inbox table ->
select  repository_name,count(*) from inbox group by repository_name;

------------------------------------------------------------------------------------------------------
List of columns including subject which i get from the message_body ->
the subject is not a column in the inbox.

select  last_updated,message_name,repository_name,sender, 
MID(message_body FROM INSTR(message_body,'Subject:')+9 FOR 
LOCATE('\n',message_body, INSTR(message_body,'Subject:')) - 
INSTR(message_body,'Subject:')-8) as Subject from inbox where 
repository_name != 'adam' order by last_updated desc

------------------------------------------------------------------------------------------------------
Display upto 8000 chaacters of the message body for an indivdual message 
using the message_name ->.
select  last_updated,message_name,repository_name,sender, 
MID(message_body FROM INSTR(message_body,'Subject:')+9 FOR 
LOCATE('\n',message_body, INSTR(message_body,'Subject:')) - 
INSTR(message_body,'Subject:')-8) as Subject, substring(message_body, 
instr(message_body,'\n\r\n'),8000) as message_body from inbox where 
repository_name != 'adam' and message_name = '"+msg+"'"



regards
Simon

James tables descriptions.
mysql> desc users;
+--------------------+--------------+------+-----+---------+-------+
| Field              | Type         | Null | Key | Default | Extra |
+--------------------+--------------+------+-----+---------+-------+
| username           | varchar(64)  |      | PRI |         |       |
| pwdHash            | varchar(50)  | YES  |     | NULL    |       |
| pwdAlgorithm       | varchar(20)  | YES  |     | NULL    |       |
| useForwarding      | smallint(6)  | YES  |     | NULL    |       |
| forwardDestination | varchar(255) | YES  |     | NULL    |       |
| useAlias           | smallint(6)  | YES  |     | NULL    |       |
| alias              | varchar(255) | YES  |     | NULL    |       |
+--------------------+--------------+------+-----+---------+-------+

mysql> desc inbox;
+-----------------+--------------+------+-----+---------------------+-------+
| Field           | Type         | Null | Key | Default             | 
Extra |
+-----------------+--------------+------+-----+---------------------+-------+
| message_name    | varchar(200) |      | PRI |                     
|       |
| repository_name | varchar(255) |      | PRI |                     
|       |
| message_state   | varchar(30)  |      |     |                     
|       |
| error_message   | varchar(200) | YES  |     | NULL                
|       |
| sender          | varchar(255) | YES  |     | NULL                
|       |
| recipients      | text         |      |     |                     
|       |
| remote_host     | varchar(255) |      |     |                     
|       |
| remote_addr     | varchar(20)  |      |     |                     
|       |
| message_body    | longblob     |      |     |                     
|       |
| last_updated    | datetime     |      |     | 0000-00-00 00:00:00 
|       |
+-----------------+--------------+------+-----+---------------------+-------+




serwa akoto quarshie wrote:

>One of the developers in my office has developed a GUI for the admin
>interface... that basically mimics the telnet 4555 procedure.
>If you ask nicely I just might send the code to you: >)
>What platform are you running James on any way?
>Tell me how many users do you have using James and does it work???
>Thanx
>
>-----Original Message-----
>From: Peter M. Goldstein [mailto:peter_m_goldstein@yahoo.com]
>Sent: Saturday, October 05, 2002 5:33 PM
>To: 'James Users List'
>Subject: RE: Re: Accessing James POP3 mailbox from a web tool
>
>
>Michael,
>  
>
>  
>
>>Thanks for your responses.  The link provided by Stefano below looked
>>remarkably similar so I downloaded v2.0a3 again.  This time it worked
>>    
>>
>like
>  
>
>>a charm :-)
>>
>>Next question - is there a GUI for the admin server (port 4555)?  If
>>    
>>
>not,
>  
>
>>are there any plans to develop one?
>>    
>>
>
>Not yet.  It's one of a number of possible enhancements under discussion
>for the next version.
>
>--Peter
>
>
>
>--
>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>
>
>
>  
>




--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


RE: Re: Accessing James POP3 mailbox from a web tool

Posted by serwa akoto quarshie <se...@rancardsolutions.com>.
One of the developers in my office has developed a GUI for the admin
interface... that basically mimics the telnet 4555 procedure.
If you ask nicely I just might send the code to you: >)
What platform are you running James on any way?
Tell me how many users do you have using James and does it work???
Thanx

-----Original Message-----
From: Peter M. Goldstein [mailto:peter_m_goldstein@yahoo.com]
Sent: Saturday, October 05, 2002 5:33 PM
To: 'James Users List'
Subject: RE: Re: Accessing James POP3 mailbox from a web tool


Michael,

> Thanks for your responses.  The link provided by Stefano below looked
> remarkably similar so I downloaded v2.0a3 again.  This time it worked
like
> a charm :-)
>
> Next question - is there a GUI for the admin server (port 4555)?  If
not,
> are there any plans to develop one?

Not yet.  It's one of a number of possible enhancements under discussion
for the next version.

--Peter



--
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>


RE: Re: Accessing James POP3 mailbox from a web tool

Posted by "Peter M. Goldstein" <pe...@yahoo.com>.

Michael,

> Thanks for your responses.  The link provided by Stefano below looked
> remarkably similar so I downloaded v2.0a3 again.  This time it worked
like
> a charm :-)
> 
> Next question - is there a GUI for the admin server (port 4555)?  If
not,
> are there any plans to develop one?

Not yet.  It's one of a number of possible enhancements under discussion
for the next version.

--Peter



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>