Thanks Stefano.
First of all I have to say that I cannot do it right now becuase I have a
user with some emails still waiting to be downloaded (and I guess that if I
change type of repository she's going to loose the emails right?)
- It suggests you to download Connector/J from
http://dev.mysql.com/downloads/connector/j/3.1.html
It does, but should I follow that or download the 5.0 connector as I have
MySQL 5.0.27?
It's not clear whether James requires 3.1 (so I should download 3.1) or it
should be the same as yuor MySQL (and so I should use 5.0)
Do it and place the connector jar in the
jamesfolder/apps/james/SAR-INF/lib folder.
I have downloaed mysql-connector-java-5.0.5.tar.gz which is the lates 5.0,
unzipped and untarred, and it contains few jars. I guess I should use
mysql-connector-java-5.0.5-bin.jar. Is that the jar I need to copy to the
lib folder? Do I have to keep the same name? I was thinking that maybe I
could have a symlink so next time I don't have to change anything in
config.xml
Similar thing if I use mysql-connector-java-3.1.14.tar.gz, which is the
latest 3.1
- Uncomment the "<data-source name="maildb" part and put there the url of
your mysql, the username and the password.
Do you mean in the <dburl> element? Shouldn't the default
jdbc:mysql://127.0.0.1/mail?autoReconnect=true be correct as MySQL is on the
same machine as James?
- Then, in your <James> block you should see an "Alternative inbox
repository definition for DB use." hint. Comment the
<repository destinationURL="file://var/mail/inboxes/" type="MAIL"/>
and uncomment the
<repository destinationURL="db://maildb/inbox/" type="MAIL"/>
The same apply to every configuration where you had a "file://" url. To
use dbs you have to use db://maildb/tablename/.
Another thing I don't understard. Do I have to create the tables or James
does that? What schema will it use? What about permissions? The user I'm
going to use for James does not have permission to create tables, and I
would like to restrict its permissions to only the schema used for James.
I think it should be clear from the config.xml. Please, once you
understand it tell us what comment/description would have helped to find
earlier your way.
As I said, I cannot try it now, but I would like to gather as much
information as possible.
Thanks
Giulio
I choose Polesoft Lockspam to fight spam, and you?
http://www.polesoft.com/refer.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
