It sounds to me like you are using mysql 4.1 or greater. You need to
download the connectorj 3.0.9 driver from the mysql site and put it
in your lib directory, then you need to go into your datasource and
switch the driver from org.gjt.mm.mysql to com.mysql.jdbc.Driver
-Cam
On Apr 28, 2005, at 9:05 PM, Kelly wrote:
I am still having a problem getting the database to connect.
This is from\m the default log. It happens when I try to access
the server.
28/04/05 22:04:27 ERROR database-connections.maildb: Error creating
connection: java.sql.SQLException: Cannot connect to MySQL server
on boredomhost.com:3306. Is there a MySQL server running on the
machine/port you are trying to connect to? (java.net.ConnectException)
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.java:514)
at org.apache.james.util.mordred.JdbcDataSource.getConnection
(JdbcDataSource.java:163)
at org.apache.james.transport.mailets.JDBCVirtualUserTable.init
(JDBCVirtualUserTable.java:131)
at org.apache.mailet.GenericMailet.init(GenericMailet.java:129)
at org.apache.james.transport.MailetLoader.getMailet
(MailetLoader.java:60)
at org.apache.james.transport.JamesSpoolManager.initialize
(JamesSpoolManager.java:253)
at
org.apache.avalon.framework.container.ContainerUtil.initialize
(ContainerUtil.java:235)
at
org.apache.excalibur.containerkit.lifecycle.LifecycleHelper.startup
(LifecycleHelper.java:144)
at
org.apache.avalon.phoenix.components.application.DefaultApplication.st
artup(DefaultApplication.java:480)
at
org.apache.avalon.phoenix.components.application.DefaultApplication.do
RunPhase(DefaultApplication.java:428)
at
org.apache.avalon.phoenix.components.application.DefaultApplication.ru
nPhase(DefaultApplication.java:364)
at
org.apache.avalon.phoenix.components.application.DefaultApplication.st
art(DefaultApplication.java:138)
at org.apache.avalon.framework.container.ContainerUtil.start
(ContainerUtil.java:251)
at
org.apache.avalon.phoenix.components.kernel.DefaultKernel.startup
(DefaultKernel.java:178)
at
org.apache.avalon.phoenix.components.kernel.DefaultKernel.addApplicati
on(DefaultKernel.java:254)
at
org.apache.avalon.phoenix.components.deployer.DefaultDeployer.deploy
(DefaultDeployer.java:353)
at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFi
le(DefaultEmbeddor.java:498)
at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFi
le(DefaultEmbeddor.java:491)
at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFi
les(DefaultEmbeddor.java:476)
at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployDe
faultApplications(DefaultEmbeddor.java:466)
at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.execute(
DefaultEmbeddor.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.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.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)
Noel J. Bergman wrote:
OK. What is showing up in the logs? Is this Solaris? Have you done
something like tail -f * in the logs directory, and checked? Have
you
turned on DEBUG for all of the log types?
--- Noel
---------------------------------------------------------------------
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]
