Hi all, I'm still having a few problems connecting James to mysql.
The DCB log files are appearing in the bin directory, but I'm getting some
strange error messages like the one below which is searching for a table
which should not exist anyway (mysql calls the table user not users). The
DCB log files are saying the connection is exhausted.
I have a java file which is reading information from the database ok. So the
passwords are fine. I have installed the mm.mysql-2.0.1 driver so this
doesn't seem to be an issue either. I've seen similar problems to this on
the mailing list which suggested editing the run files. So I stuck the path
to the driver there but still no joy. Any ideas?
Thu Sep 27 15:18:26 BST 2001 Opening connection 1:
org.gjt.mm.mysql.jdbc2.Connection@7d5d2a
Thu Sep 27 15:18:26 BST 2001 Opening connection 2:
org.gjt.mm.mysql.jdbc2.Connection@6fa474
Thu Sep 27 15:18:36 BST 2001 -----> Connections (2) Exhausted! Will wait
and try again in loop 1
java.sql.SQLException: General error: Table 'mysql.users' doesn't exist
at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java)
at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
at org.gjt.mm.mysql.Statement.executeQuery(Statement.java)
at org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78)
at
com.workingdogs.town.ConnDefinition.getSchema(ConnDefinition.java:178)
at com.workingdogs.town.TableDataSet.<init>(TableDataSet.java:299)
at com.workingdogs.town.TableDataSet.<init>(TableDataSet.java:280)
at
org.apache.james.userrepository.UsersTownRepository.list(UsersTownRepository
.java:184)
at org.apache.james.James.getLocalUsers(James.java:407)
at
org.apache.james.transport.matchers.RecipientIsLocal.matchRecipient(Recipien
tIsLocal.java:33)
at
org.apache.mailet.GenericRecipientMatcher.match(GenericRecipientMatcher.java
:39)
at
org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:119)
at
org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.java:
166)
at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:142)
at org.apache.avalon.utils.recycle.pool.Worker.run(Worker.java:113)
2001.09.27 03:09:23 265 (ERROR) from UserManager: Problem listing mailboxes.
com.workingdogs.town.DataSetException: Erro
r retrieving primary keys from table Users: General error: Table
'mysql.users' doesn't exist
com.workingdogs.town.DataSetException: Error retrieving primary keys from
table Users: General error: Table 'mysql.users
' doesn't exist
Kieran Mc Nally Msc.
Multimedia/Usability Researcher
Centre for Health Informatics,
Department of Computer Science,
Trinity College Dublin.
Phone 00353 1 6083466
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
