I had this problem with ips - you can use 127.0.0.1, but if you set up a mysql user for Host localhost it doesnt work!
Instead set up a mysql user with the Host being the machines full name. I think this is somthing to with the JDBC driver, as php uses a user with 'localhost'. Daniel. -----Original Message----- From: Brian Brewer [mailto:[EMAIL PROTECTED] Sent: 05 April 2004 16:22 To: James Users List Subject: Re: Problem using db store for the first time Don't use localhost for your connect string - use the boxes local IP or 127.0.0.1 and make sure you have a relevant entry in your database users table. mySql has some problems with resolving localhost. I don't remember the specifics, but I've had similar problems in the past. Brian Brewer J Malcolm wrote: >I've been using file storage until now. I'm attempting to move to db >storage. So this is an initial bringup problem. I'm getting the >following error: > > ERROR 2004-04-01 23:16:02.258 [Phoenix.] (): Component named >"mailstore" failed to pass through the Initialization stage. (Reason: >org.apache.avalon.framework.component.ComponentException: Cannot find or >init repository). > >Here are the relevant blocks in the config file: > > <mailstore> > <repository >class="org.apache.james.mailrepository.JDBCMailRepository"> > <protocols> > <protocol>db</protocol> > </protocols> > <types> > <type>MAIL</type> > </types> > <config> > ><sqlFile>file:///c:/james-2.1.3/apps/james/conf/sqlResources.xml</sqlFil >e> > </config> > </repository> > > <repository >class="org.apache.james.mailrepository.JDBCSpoolRepository"> > <protocols> > <protocol>db</protocol> > </protocols> > <types> > <type>SPOOL</type> > </types> > <config> > ><sqlFile>file:///c:/james-2.1.3/apps/james/conf/sqlResources.xml</sqlFil >e> > </config> > </repository> > > <spoolRepository> > <repository destinationURL="db://maildb/spool/spool" >type="SPOOL"/> > </spoolRepository> > </mailstore> > > <database-connections> > <data-sources> > <data-source name="maildb" >class="org.apache.james.util.mordred.JdbcDataSource"> > <driver>org.gjt.mm.mysql.Driver</driver> > ><dburl>jdbc:mysql://localhost/mail?autoReconnect=true</dburl> > <user>xxxxx</user> > <password>xxxxxxxx</password> > <max>40</max> > </data-source> > </data-sources> > </database-connections> > >======================================================================== >================== > >I created a db named "mail" in mysql. It didn't appear from docs that I >have to create tables or anything. > >I tried renaming the data source and get the same error, which implies >to me it's not even getting that far. But the error message implies >that it is. > >Any ideas where I've gone wrong? Any way to turn on high debug level in >phoenix (debug loglevel in mailstore doesn't yield any additional info). > >One other question... if the url syntax is "db:<datasource>/<table>", >what does "db:/maildb/spool/spool" resolve to? Is there a table created >named "spool/spool" > >Thanks as always. > >Jerry > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
