Installing mySQL on WinXP is easy. For use with James you need to do several things - this is how I approached it:
1. Download the GUI tools from MySQL for MySQL administration - can help in the beginning 2. Create a MySQL database called "mail" 3. Create a user for James in MySQL and assign it the appropriate rights for the db "mail" (look in James docs). Initially this user should have the right to create tables (I think that right can be removed once James has setup the tables - up to you I guess). 4. Add settings to James config.xml: 4a. data-source - use the defaults, change the user and password to those set in 3. above. My dburl reads "jdbc:mysql://localhost/mail?autoReconnect=true" where "/mail" refers to the db created in 2 above. 4b. user-store : repository - uncomment the example db settings, comment out file repository settings (only 1 repository should be used). 5. Start James from the command line, solve any errors. Once up and running, checkout the mail database in MySQL. The user table should have been created. 6. Connect to James using the telnet admin interface, use help and add/manage users. These will be added to the "user" table in your db. You should be on your way. I setup all repositories to use MySQL, including Bayesian spam filtering. If you're going that way you will need SMTP enabled and a mail client that uses James as the SMTP server so that you can train the filter... Cheers kylepetersen wrote: > > > David Legg wrote: >> >> >> You'll need to have MySQL installed on your server as the filter uses >> that to manage the corpus (the body of email it compares new emails to). >> >> > > Any good noob-proof docs for configuring MySQL to work out of the box, and > can I use it for the Bayesian corpus only? I'm currently using (I guess > obvious since I don't have MySQL installed) file repository as my users' > inbox. > -- View this message in context: http://www.nabble.com/Integrate-Spamassassin-with-James--tp14935936p15047624.html Sent from the James - Users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
