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:[EMAIL PROTECTED]]
>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: <mailto:[EMAIL PROTECTED]>
>For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>
>
>--
>To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
>For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>
>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
