AnsweredAssumed Answered

Install problems..please help!

Question asked by durrell on Jul 3, 2009
Latest reply on Jul 8, 2009 by gronfelt
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

Outcomes