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 Kelly <we...@boredomsoftware.com> on 2005/04/29 03:39:22 UTC
Connection refused
I am having a problem with my server connecting via client or via
telnet. (see below)
Anyone have any ideas?
Thanks
Kelly
<processor name="root">
#######If I comment out this mailet I can connect to the server
via telnet or mail client. If I leave it in the code I cannot connect
with either.
########server does not crash either way.
<mailet match="All" class="JDBCVirtualUserTable">
<table>db://maildb/VirtualUserTable</table>
<sqlquery>
select VirtualUserTable.target_address from
VirtualUserTable, VirtualUserTable as VUTDomains where
(VirtualUserTable.user like ? or VirtualUserTable.user
like "\%") and (VirtualUserTable.domain like
? or (VirtualUserTable.domain like "\%" and
VUTDomains.domain like ?)) order by concat
(VirtualUserTable.user,'@',VirtualUserTable.domain) desc
limit 1
</sqlquery>
</mailet>
<!-- People on this list agree to pay a penalty if they send
spam -->
<mailet match="InSpammerBlacklist=1#query.bondedsender.org"
class="ToProcessor">
<processor> transport </processor>
</mailet>
<!-- E-mail legally required not to be spam (see:
http://www.habeas.com) -->
<!--
<mailet match="HasHabeasWarrantMark" class="ToProcessor">
<processor> transport </processor>
</mailet>
-->
<!-- End of White List -->
<!-- Send remaining mails to the transport processor for either
local or remote delivery -->
<mailet match="All" class="ToProcessor">
<processor> transport </processor>
</mailet>
</processor>
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
Re: Connection refused
Posted by Kelly <we...@boredomsoftware.com>.
Logs seem very detailed look normal. Any particular one you want me to
post?
Yes I am running Solaris. I am not sure what 'tail -f *' means. How do
I do it? How do I turn on DEBUG for all log types?
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: 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
Re: Connection refused
Posted by Camron Levanger <ca...@gmail.com>.
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: 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
>
>
Re: Connection refused
Posted by Kelly <we...@boredomsoftware.com>.
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.startup(DefaultApplication.java:480)
at org.apache.avalon.phoenix.components.application.DefaultApplication.doRunPhase(DefaultApplication.java:428)
at org.apache.avalon.phoenix.components.application.DefaultApplication.runPhase(DefaultApplication.java:364)
at org.apache.avalon.phoenix.components.application.DefaultApplication.start(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.addApplication(DefaultKernel.java:254)
at org.apache.avalon.phoenix.components.deployer.DefaultDeployer.deploy(DefaultDeployer.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.deployFiles(DefaultEmbeddor.java:476)
at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployDefaultApplications(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: 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
RE: Connection refused
Posted by "Noel J. Bergman" <no...@devtech.com>.
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: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
Re: Connection refused
Posted by Kelly <we...@boredomsoftware.com>.
I tried it without the SQL string before I put it in. same response.
I am desperate!
Grasping at straws.
Kelly
Noel J. Bergman wrote:
>Why are you passing the SQL string? Just leave it.
>
> --- Noel
>
>---------------------------------------------------------------------
>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
RE: Connection refused
Posted by "Noel J. Bergman" <no...@devtech.com>.
Why are you passing the SQL string? Just leave it.
--- Noel
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org