Check the config.xml path that you have changed. (it should be /my_james/apps/james/SAR-INF/config.xml)
and, is there any exception message in log files? On 28/05/2008, emailguy <[EMAIL PROTECTED]> wrote: > > > > > Stefano Bagnara-2 wrote: > > > > emailguy ha scritto: > >> 1. I'm trying to use MySQL as the db for James 2.3.1. From the > >> instructions > >> at > >> http://james.apache.org/server/2.3.1/using_database.html > >> > >> I've changed config.xml at this point: > >> > >> <data-source name="maildb" > >> class="org.apache.james.util.dbcp.JdbcDataSource"> > >> <driver>org.gjt.mm.mysql.Driver</driver> > >> <dburl>jdbc:mysql://localhost:3306/jamesemail</dburl> > >> <user>myuser</user> > >> <password>mypassword</password> > >> <poolPreparedStatements>true</poolPreparedStatements> > >> <max>20</max> > >> </data-source> > >> > >> I have also tried > >> <dburl>com.mysql.jdbc.Driver</dburl> > >> > >> After restarting James, I expected tables to be created in the > jamesemail > >> database. Neither of these has caused the tables to be created in my > >> jamesemail database. What is wrong? > >> > >> 2. My other questions is where should these be placed in config.xml? > >> Anywhere not contained by other tags? > >> > >> <spoolRepository> > >> <repository destinationURL="dbfile://maildb/spool/spool" > >> type="SPOOL"/> > >> </spoolRepository> > >> <inboxRepository> > >> <repository destinationURL="db://maildb/inbox/" type="MAIL"/> > >> </inboxRepository> > > > > What does it happen when you restart the db? > > Yes, it should automatically create the tables structure after the > > restart. > > > > Have you placed the mysql jdbc connector/J in your > > <james>/apps/james/SAR-INF/lib folder ? > > > > Stefano > > > > > > > Yes I have placed the jdbc mysql driver into the lib folder. > No tables are created when I restart the db, or James, or both. > > > > > -- > View this message in context: > http://www.nabble.com/James---MySQL-tp17440114p17512182.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] > > -- ~ otomatik oluşturuldu: http://ocetin.net/log
