topic Connection timed out in Alfresco Archive

Connection timed out

rgauss — Sat, 06 May 2006 01:08:00 GMT

Hope I didn't miss this one in the forums, I did quite a bit of searching.Can't get Tomcat to come up all the way. It doesn't seem to crash or produce a core dump and there's no exceptions in the logs.I've turned up debugging everywhere I can think of, and catalina.out or alfresco.log just stop at:

Re: Connection timed out

rgauss — Mon, 08 May 2006 12:56:04 GMT

OK, I may have lied about 'forever'. Looks like it times out after 45 minutes with:

Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: Connection timed out

STACKTRACE:

java.net.SocketException: Connection timed out
        at java.net.SocketInputStream.socketRead0(Native Method)
        at java.net.SocketInputStream.read(SocketInputStream.java:129)
        at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
        at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
        at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1902)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

But again, I've verified the alfresco user can connect to db over 127.0.0.1, localhost, localhost.localdomain, and the public domain address and IP.

Re: Connection timed out

rgauss — Mon, 08 May 2006 21:38:39 GMT

Since last post I've tried:

Reverting to 3.0 connector
Specifying INNODB and utf8 per this post http://forums.alfresco.com/viewtopic.php?t=667
Other versions of mysql server
Setting the old-passwords flag

What's interesting is that when I pointed repository.properties to a 4.1 mysql server on a totally different server it worked fine which makes me think it's got to do with the mysql server config itself.

In the mysql log I see:

060508 16:22:30       3 Connect     alfresco@localhost on alfresco
                      3 Query       SET NAMES utf8
                      3 Query       SET character_set_results = NULL
                      3 Query       SHOW VARIABLES‍‍‍‍

then nothing further.

When I log in via mysql client as alfresco and run those commands the response seems to come back fine.

Nothing special in /etc/my.cnf:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords
log
default-character-set=utf8 
default-storage-engine=INNODB
    
[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Any thoughts? Any where else I should be looking for debugging info?

Thanks

Re: Connection timed out

rgauss — Wed, 10 May 2006 13:40:17 GMT

Never figured out what the problem was.

Had the host rebuild the box with FC4 and MySQL 4.1, everything seems fine now.

Maybe there was something I was supposed to change in alfresco's config to use MySQL 5.0?