You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-user@james.apache.org by Anthony Borrow <ar...@jesuits.net> on 2004/06/18 00:11:39 UTC
Re: Configuring JAMES with MySQL
Many thanks - I knew that it was something simple. I had a couple typos
in my config.xml but now have James working (atleast until I try playing
with something else). Many thanks!
Steve Short wrote:
>Anthony,
>
>Forget about the classpath ! Put the JDBC jar file into the 'lib'
>directory.
>
>Steve
>
>-----Original Message-----
>From: Anthony Borrow [mailto:arborrow@jesuits.net]
>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 (arborrow@jesuits.net)
>
>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: server-user-unsubscribe@james.apache.org
>For additional commands, e-mail: server-user-help@james.apache.org
>
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
>For additional commands, e-mail: server-user-help@james.apache.org
>
>
>
>
--
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: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org