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]
