It looks like its trying to find table users in db mysql, which isn't right .. mysql is the db for permissions etc, you need to create a new db, and in that create a table called "users" for James to use.
If you upgrade to the version in CVS you'll find that the db stuff is greatly improved, James creates its own tables for one thing. Failing that I believe plans are afoot to release a new version "shortly" as opposed to "in the fullness of time", though I'm unclear as to whether this'll be a day or two or a couple of weeks yet. d. > -----Original Message----- > From: kieran Mc Nally [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 27, 2001 4:55 PM > To: [EMAIL PROTECTED] > Subject: database troubles. > > > > 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(UsersTown > Repository > .java:184) > at org.apache.james.James.getLocalUsers(James.java:407) > at > org.apache.james.transport.matchers.RecipientIsLocal.matchRecipien > t(Recipien > tIsLocal.java:33) > at > org.apache.mailet.GenericRecipientMatcher.match(GenericRecipientMa > tcher.java > :39) > at > org.apache.james.transport.LinearProcessor.service(LinearProcessor > .java:119) > at > org.apache.james.transport.JamesSpoolManager.process(JamesSpoolMan > ager.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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
