Egonis

I am trying to get Open-Xchange working on a Gentoo Linux using Sun JDK 1.5.0.11 as per the project's Wiki.
There is an installation script I am trying to run in particular which throws tons of error messages as follows:

BEGIN --- Output from /opt/open-xchange/sbin/oxinstaller ---

initializing database (step 1/2)
done
Configuring services
setting readUrl in /opt/open-xchange/etc/admindaemon/configdb.properties
setting writeUrl in /opt/open-xchange/etc/admindaemon/configdb.properties
setting readProperty.1 in /opt/open-xchange/etc/admindaemon/configdb.properties
setting readProperty.2 in /opt/open-xchange/etc/admindaemon/configdb.properties
setting writeProperty.1 in /opt/open-xchange/etc/admindaemon/configdb.properties
setting writeProperty.2 in /opt/open-xchange/etc/admindaemon/configdb.properties
setting readUrl in /opt/open-xchange/etc/groupware/configdb.properties
setting writeUrl in /opt/open-xchange/etc/groupware/configdb.properties
setting readProperty.1 in /opt/open-xchange/etc/groupware/configdb.properties
setting readProperty.2 in /opt/open-xchange/etc/groupware/configdb.properties
setting writeProperty.1 in /opt/open-xchange/etc/groupware/configdb.properties
setting writeProperty.2 in /opt/open-xchange/etc/groupware/configdb.properties
setting CREATE_HOMEDIRECTORY in /opt/open-xchange/etc/admindaemon/User.properties
setting SetupLink in /opt/open-xchange/etc/groupware/system.properties
(Re)Starting Admin Daemon
done
initializing database (step 2/2)
Server response:
 com.openexchange.admin.exceptions.PoolException: DBP-0001 Category=5 Message=Cannot get connection to config DB. exceptionID=422910378-2
Server response:
 com.openexchange.admin.exceptions.PoolException: DBP-0001 Category=5 Message=Cannot get connection to config DB. exceptionID=422910378-4
Server response:
 com.openexchange.admin.exceptions.PoolException: DBP-0001 Category=5 Message=Cannot get connection to config DB. exceptionID=422910378-6
done
setting up the system
creating certificates
Server response:
 com.openexchange.admin.exceptions.PoolException: DBP-0001 Category=5 Message=Cannot get connection to config DB. exceptionID=422910378-8
usermod: invalid numeric argument 'sasl'
configuring ox admin gui
configuring mail system
using mail.auricnet.ca as FQHN of the mail server
Server response:
 com.openexchange.admin.exceptions.PoolException: DBP-0001 Category=5 Message=Cannot get connection to config DB. exceptionID=422910378-10
done

END   --- Output from /opt/open-xchange/sbin/oxinstaller ---

I have followed the Wiki as per www.open-xchange.com for the Community edition, and the steps regarding MySQL Setup are very short, and have only one mention of errors, and that they can only be traced to issues with MySQL Server itself.

I have used several client programs to access MySQL remotely, and internally with no issue such as MySQL Admin, and the command-line driven mysql-client

I granted access to the openxchange user via 'GRANT ALL PRIVILEGES ON *.* TO 'openxchange'@'localhost' IDENTIFIED BY 'thepassword'; and have also tried using the root account from the oxinstaller configs, nothing makes a difference, even with bogus information such as 'oogabooga.com' as the destination MySQL server.

I am using jdbc-mysql 3.1.13 and the 3.1.13 JAR in the lib path of Open-Xchange to keep things uniform, this is the version which Open-Xchange Wiki asks for.

I tried using a sample MySQL Connection Test program I found, the code follows:

BEGIN --- Test MySQL Connector Code via JDBC ---

package com.stardeveloper.example;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class JdbcExample2 {

  public static void main(String args[]) {
    Connection con = null;

    try {
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      con = DriverManager.getConnection("jdbc:mysql:///test",
        "root", "secret");

      if(!con.isClosed())
        System.out.println("Successfully connected to " +
          "MySQL server using TCP/IP...");

    } catch(Exception e) {
      System.err.println("Exception: " + e.getMessage());
    } finally {
      try {
        if(con != null)
          con.close();
      } catch(SQLException e) {}
    }
  }
}

END   --- Test MySQL Connector Code via JDBC ---

When I execute 'javac JdbcExample2.java' and subsequently run 'java JdbcExample2' I get:

Exception: com.mysql.jdbc.Driver

I am convinced that this is a java configuration issue, as I am a halfwit when it comes to java, having no experience with it at all aside from getting JAR packages running on TomCat.