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:[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]
--
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]
