Anthony, Forget about the classpath ! Put the JDBC jar file into the 'lib' directory.
Steve -----Original Message----- From: Anthony Borrow [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 8:53 AM To: James Users List Subject: Configuring JAMES with MySQL I am a newbie, especially to Java but I have tried to follow the setup instructions with little luck. I am installing on XP and I am able to get JAMES to run if I use file repositories. I am using c:\j2sdk1.4.2_04 as JAVA_HOME and have JAMES installed to c:\james. I have MySQL up and running with a database named James created. Telnet'ing localhost 3306 shows that the server is listening. For initial testing I am having James login to the database as a "superuser". I suspect the problem I am having is some simple Java configuration deal since I frequently get an "Exception in thread "main" java.lang.NoClassDefFoundError" error. I have CLASSPATH=c:\mysql\mysql-connector-java.jar; Below is my default.log from JAMES - I am unsure what the unknown source message means. Any suggestions or pointers would be helpful. Thanks - Anthony Borrow ([EMAIL PROTECTED]) 17/06/04 10:25:18 DEBUG database-connections.maildb: Loading new driver: org.gjt.mm.mysql.Driver 17/06/04 10:25:18 DEBUG database-connections.maildb: Starting connection pooler 17/06/04 10:25:18 DEBUG database-connections.maildb: driver = org.gjt.mm.mysql.Driver 17/06/04 10:25:18 DEBUG database-connections.maildb: dburl = jdbc:mysql://127.0.0.1/james 17/06/04 10:25:18 DEBUG database-connections.maildb: username = root 17/06/04 10:25:18 DEBUG database-connections.maildb: max connections = 20 17/06/04 10:25:18 INFO database-connections: DataSource maildb ready 17/06/04 10:25:19 ERROR database-connections.maildb: Error creating connection: *java.sql.SQLException: Communication failure during handshake. Is there a server running on 127.0.0.1:3306? at org.gjt.mm.mysql.MysqlIO.init(Unknown Source) at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source) at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown Source) at org.gjt.mm.mysql.Driver.connect(Unknown Source) * at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at org.apache.james.util.mordred.JdbcDataSource.createConn(JdbcDataSource.j ava:540) at org.apache.james.util.mordred.JdbcDataSource.getConnection(JdbcDataSourc e.java:206) at org.apache.james.mailrepository.JDBCMailRepository.initialize(JDBCMailRe pository.java:358) at org.apache.james.core.AvalonMailStore.select(AvalonMailStore.java:350) at org.apache.james.core.AvalonMailStore.initialize(AvalonMailStore.java:17 9) at org.apache.avalon.framework.container.ContainerUtil.initialize(Container Util.java:235) at org.apache.excalibur.containerkit.lifecycle.LifecycleHelper.startup(Life cycleHelper.java:144) at org.apache.avalon.phoenix.components.application.DefaultApplication.star tup(DefaultApplication.java:480) at org.apache.avalon.phoenix.components.application.DefaultApplication.doRu nPhase(DefaultApplication.java:428) at org.apache.avalon.phoenix.components.application.DefaultApplication.runP hase(DefaultApplication.java:364) at org.apache.avalon.phoenix.components.application.DefaultApplication.star t(DefaultApplication.java:138) at org.apache.avalon.framework.container.ContainerUtil.start(ContainerUtil. java:251) at org.apache.avalon.phoenix.components.kernel.DefaultKernel.startup(Defaul tKernel.java:178) at org.apache.avalon.phoenix.components.kernel.DefaultKernel.addApplication (DefaultKernel.java:254) at org.apache.avalon.phoenix.components.deployer.DefaultDeployer.deploy(Def aultDeployer.java:353) at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFile (DefaultEmbeddor.java:498) at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFile (DefaultEmbeddor.java:491) at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFile s(DefaultEmbeddor.java:476) at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployDefa ultApplications(DefaultEmbeddor.java:466) at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.execute(De faultEmbeddor.java:224) at org.apache.avalon.phoenix.frontends.CLIMain.run(CLIMain.java:158) at org.apache.avalon.phoenix.frontends.CLIMain.execute(CLIMain.java:144) at org.apache.avalon.phoenix.frontends.CLIMain.main(CLIMain.java:102) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.avalon.phoenix.launcher.Main.startup(Main.java:94) at org.apache.avalon.phoenix.launcher.Main.main(Main.java:46) -- Anthony R. Borrow, SJ Our Lady of Guadalupe Parish 1321 El Paso Street San Antonio, Texas 78207-5599 (210) 226-4064 (435) 304-2938 (Fax) http://www.arborrow.org/ --------------------------------------------------------------------- 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]
