- Open config.xml
- Search for "Example, connecting to a MySQL database"
- It suggests you to download Connector/J from
http://dev.mysql.com/downloads/connector/j/3.1.html
Do it and place the connector jar in the
jamesfolder/apps/james/SAR-INF/lib folder.
- Uncomment the "<data-source name="maildb" part and put there the url
of your mysql, the username and the password.
- 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/.
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.
Stefano
Giulio Troccoli ha scritto:
Hi everybody,
I'm trying to understand how to set up James to use MySQL. At the moment I'm
using a file based repository. I would like to use MySQL becuase it's already
installed (used by another application).
Reading the config.xml file is not really helpful, as it looks like there are
more than one place that need to be configured. I have also search the archive
on this ML but I only found post regarding various problems that people had
using MySQL.
So, is there somewhere a nice HOWTO guide on how to set-up James to use MySQL?
Or I'm really stupid and it's indeed very simple and easy to understand from
the config.xml?
I'm using MySQL 5.0.27, James 2.3.0 on Fedora Core 4.
Thanks
Giulio
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
