Giulio Troccoli ha scritto:
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?)
Right. There is no import/export tool, yet, unfortunately.
- 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)
Connector/J 5 will work.
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
That jar is ok. The name is not important, just make sure the extension
is jar.
- 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?
Before the data-source there is an XML comment "<!--" and after
</data-source> there is the end of an XML comment "-->". Remove that
comment delimiters.
That dburl is ok for a locally installed mysql.
Often mysql by default does not bind to TCP port but only to unix
socket. YOU will have to change your my.cnf (or the appropriate
configuration file for mysql) to make it listen on tcp port 3306 (search
mysql manual for this).
- 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.
James creates the tables. You only have to create the db.
Stefano
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
