Install problems..please help!

[durrell]

Trying to install Alfresco Labs 3.1 (most recent stable version) with the following:

CentOS 5.3
JBoss 4.2.2GA
MySQL 5.1.36 Server and Client Community releases
MySQL-connector-java-5.1.7

I have a stable JBoss installation as well as a stable MySQL installation. I created the MySQL DB using the provided script. I believe part of my problem may lie in specifying the wrong JDBC driver in mysql-ds.xml. I will post that file as well. I'm also assuming the errors immediately following the ImageMagick error have to due with the log level set per the advice of the "Deploying Alfresco WAR on JBoss" wiki. I'm not quite sure what is relevant in the log and what isn't, so I pasted it in its entirety to pastebin since it was too long to post here.

My alfresco.log:

http://pastebin.ca/1482669
‍‍‍

mysql-ds.xml file:

<?xml version="1.0" encoding="UTF-8"?>

<!– $Id: mysql-ds.xml 63175 2007-05-21 16:26:06Z rrajesh $ –>
<!–  Datasource config for MySQL using 3.0.9 available from:
http://www.mysql.com/downloads/api-jdbc-stable.html
–>

<datasources>
  <local-tx-datasource>
    <jndi-name>alfresco-datasource</jndi-name>
    <connection-url>jdbc:mysql://localhost:3306/alfresco</connection-url>
    <driver-class>org.gjt.mm.mysql.Driver</driver-class>
    <user-name>alfresco</user-name>
    <password>alfresco</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
    <!– should only be used on drivers after 3.22.1 with "ping" support
    <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
    –>
    <!– sql to call when connection is created
    <new-connection-sql>some arbitrary sql</new-connection-sql>
      –>
    <!– sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers
    <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
      –>

    <!– corresponding type-mapping in the standardjbosscmp-jdbc.xml –>
    <metadata>
       <type-mapping>mySQL</type-mapping>
    </metadata>
  </local-tx-datasource>
</datasources>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Can someone please provide some guidance? My eyes are crossing from these crazy errors.

Thanks in advance.

Darryl

[gronfelt]

The current class name is com.mysql.jdbc.Driver, but org.gjt.mm.mysql.Driver should still be ok too, according to the MySQL documentation.

It seems like Jboss can't find your MySQL-connector, have you made sure that you are using the right jar-file and have you put the file in /jboss/server/default/lib (or otherwise added the location to the CLASSPATH variable)?

[durrell]

Looks like sometimes all you need is a second pair of eyes.

I had the MySQL connector in /usr/local/jboss/lib instead of /jboss/server/default/lib. Whoops.

I'll see if that does anything. Thanks.

[durrell]

Well I went back and made the recommended changes and it didn't change anything. It's pretty obvious I've got a database connection issue somewhere, but I can't figure out what I'm doing wrong.

Most recent alfresco.log:

http://pastebin.ca/1483163

[durrell]

I still haven't been able to get this working.

It's obvious Alfresco is trying to do something, it's just failing to open a connection to MySQL and I don't know why. This seems like it should be a rather easy fix.

Any ideas?

[gronfelt]

Ok, so you have placed the file mysql-connector-java-5.1.7-bin.jar in /jboss/server/default/lib and that didn't work? That's odd.

You might want to try an older version of the connector (like 5.0.8 ). I know it's a longshot, but I've hade similar problems with another java app and that worked for me.

Edit: I just saw in the wiki page on jboss deployment that creating an mysql-ds.xml file is Alfresco 3.2-only, for some reason. Have you tried removing that file from /jboss/server/default/deploy (assuming you put it there in the first place)?