Using MySQL for inbox repository

[Rhys Hardwick]

Hi all.
I have recently installed James for the first time, and am trying to get 
it to use MySQL as the inbox repository.  James started fine using the 
run.bat file, but whenever an email is to be sent to a local inbox, the 
following error is thrown up by the mail client:

An unknown error has occurred. Subject 'test', Account: 'rhys', Server: 
'127.0.0.1', Protocol: SMTP, Server Response: '451 Error processing 
message: Exception spooling message: Exception caught while storing mail 
Container: java.sql.SQLException: General error: Column 
'repository_name' cannot be null;', Port: 25, Secure(SSL): No, Server 
Error: 451, Error Number: 0x800CCC6A

This is then thrown up in the Console :
java.sql.SQLException: General error: Column 'repository_name' cannot be 
null
       at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
       at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source)
       at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
       at org.gjt.mm.mysql.PreparedStatement.execute(Unknown Source)
       at 
org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository.java:635)
       at 
org.apache.james.mailrepository.JDBCSpoolRepository.store(JDBCSpoolRepository.java:243)
       at org.apache.james.James.sendMail(James.java:499)
       at java.lang.reflect.Method.invoke(Native Method)
       at 
org.apache.avalon.phoenix.components.application.BlockInvocationHandler.invoke(BlockInvoc
ationHandler.java:92)
       at $Proxy9.sendMail(Unknown Source)
       at 
org.apache.james.smtpserver.SMTPHandler.processMail(SMTPHandler.java:1406)
       at 
org.apache.james.smtpserver.SMTPHandler.doDATA(SMTPHandler.java:1253)
       at 
org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java:608)
       at 
org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.java:381)
       at 
org.apache.james.util.connection.ServerConnection$ClientConnectionRunner.run(ServerConnec
tion.java:462)
       at 
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(ExecutableRunnable.jav
a:47)
       at 
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.java:80)

I have used the James documentation pages to set up the config.xml file 
as best I can.  Here are the relevent sections:

<inboxRepository>
        <repository destinationURL="db://maildb/inbox/" type="MAIL"/>
</inboxRepository>
<data-source name="maildb" 
class="org.apache.james.util.mordred.JdbcDataSource">
           <driver>org.gjt.mm.mysql.Driver</driver>
           
<dburl>jdbc:mysql://***.***.***.***/james?autoReconnect=true</dburl>
           <user>*****</user>
           <password>*****</password>
           <max>50</max>
        </data-source>

Is there anything you could suggest to sort this problem?
Rhys
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]