Install problems..please help!

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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)?