Announcement

Collapse
No announcement yet.

SLES10SP2 OX Hosting

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SLES10SP2 OX Hosting

    Hello Forum,

    I am currently trying to install the latest available Open-Xchange Hosting Edition packages on a SLES 10 SP2. I am able to get through the rpm installs and the first steps of configuration, but with the creation of the first context I hit a fence. With my command:

    # /opt/open-xchange/sbin/createcontext -c 1 -N <domain> -L <domain>,defaultcontext -u oxadmin -d oxadmin -g oxadmin -s oxadmin -p supergeheim -e oxadmin@<domain> -q 1024 -A oxadminmaster -P supergeheim2
    context 1 could not be created:
    Server response:
    Error unmarshaling return; nested exception is:
    java.lang.ClassNotFoundException: com.mysql.jdbc.exceptions.MySQLNonTransientConnect ionException (no security manager: RMI class loader disabled)

    I get this error message. I have tried to switch between sun-java and ibm-java and between 64bit and 32bit, but nothing got me out of this mess.

    My environment is:
    #rpm -qa | grep open =
    open-xchange-configread-6.5.0-7.1
    open-xchange-imap-6.5.0-5.1
    open-xchange-jcharset-1.3.0-7.1
    open-xchange-admin-6.5.0-7.1
    open-xchange-sessiond-6.5.0-7.1
    open-xchange-admin-plugin-hosting-doc-6.5.0-7.1
    open-xchange-common-6.5.0-8.1
    open-xchange-management-6.5.0-7.1
    open-xchange-authentication-database-6.5.0-7.1
    open-xchange-smtp-6.5.0-5.1
    open-xchange-configjump-generic-6.5.0-4.1
    open-xchange-6.5.0-7.1
    open-xchange-gui-6.5.0-4.1
    open-xchange-global-6.5.0-7.1
    open-xchange-monitoring-6.5.0-7.1
    open-xchange-i18n-6.5.0-7.1
    open-xchange-spamhandler-default-6.5.0-7.1
    open-xchange-charset-6.5.0-7.1
    open-xchange-admin-doc-6.5.0-7.1
    open-xchange-settings-extensions-6.5.0-6.1
    open-xchange-admin-plugin-hosting-6.5.0-7.1
    open-xchange-server-6.5.0-7.1
    open-xchange-control-6.5.0-7.1
    open-xchange-cache-6.5.0-5.1
    open-xchange-push-udp-6.5.0-5.1
    open-xchange-admin-client-6.5.0-7.1

    # echo $JAVA_HOME
    /usr/lib64/jvm/java

    # echo $JRE_HOME
    /usr/lib64/jvm/java/jre

    # uname -a
    Linux <servername> 2.6.16.60-0.23-xen #1 SMP Thu May 15 06:38:31 UTC 2008 x86_64 x86_64 x86_64 GNU/Linux

    # rpm -qa | grep java
    java-1_4_2-sun-1.4.2.17-0.2
    java-1_5_0-ibm-devel-32bit-1.5.0_sr7-0.2
    java-1_4_2-sun-alsa-1.4.2.17-0.2
    java-1_5_0-ibm-alsa-32bit-1.5.0_sr7-0.2
    java-1_5_0-ibm-devel-1.5.0_sr7-0.2
    java-1_4_2-sun-plugin-1.4.2.17-0.2
    java-1_5_0-ibm-32bit-1.5.0_sr7-0.2
    javamail-1.3.3_01-14.2
    java-1_5_0-ibm-fonts-1.5.0_sr7-0.2
    java-1_4_2-sun-jdbc-1.4.2.17-0.2
    java-1_5_0-ibm-1.5.0_sr7-0.2

    Can you please give me advise how to move on?

    Thank you and best regards,

    Nico
    catWorkX GmbH
    Last edited by cwx_nho; 06-18-2008, 09:27 AM.

  • #2
    Hi Nico,

    you've installed multiple Java installations on that system - which one is actively used? This issue comes up when using a incompatible Java version as default. OX Hosting Edition requires Java 1.5, i guess Java 1.4.2 is used on your machine.

    Just try "java -version" to find out

    Greetings

    Comment


    • #3
      Hi Martin,

      thank your for your quick answer. I think there is the 1.5 version in use according to the attached output:

      # java -version
      java version "1.5.0"
      Java(TM) 2 Runtime Environment, Standard Edition (build pxa64dev-20080315 (SR7))
      IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 Linux amd64-64 j9vmxa6423-20080315 (JIT enabled)
      J9VM - 20080314_17962_LHdSMr
      JIT - 20080130_0718ifx2_r8
      GC - 200802_08)
      JCL - 20080314

      Any Ideas?

      Best regards,

      Nico

      Comment


      • #4
        Originally posted by cwx_nho View Post
        Hi Martin,

        thank your for your quick answer. I think there is the 1.5 version in use according to the attached output:

        # java -version
        java version "1.5.0"
        Java(TM) 2 Runtime Environment, Standard Edition (build pxa64dev-20080315 (SR7))
        IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 Linux amd64-64 j9vmxa6423-20080315 (JIT enabled)
        J9VM - 20080314_17962_LHdSMr
        JIT - 20080130_0718ifx2_r8
        GC - 200802_08)
        JCL - 20080314

        Any Ideas?

        Best regards,

        Nico
        You must use IBM Java, that for sure. Sun Java on SLES10 is to old.
        Did you see anything in the logs?
        Code:
        /var/log/open-xchange/open-xchange-admin.log*

        Comment


        • #5
          Originally posted by Carsten Hoeger View Post
          You must use IBM Java, that for sure. Sun Java on SLES10 is to old.
          Did you see anything in the logs?
          Code:
          /var/log/open-xchange/open-xchange-admin.log*
          Code:
          Jun 18, 2008 11:33:47 AM com.openexchange.admin.storage.mysqlStorage.OXUtilMySQLStorageCommon createDatabase
          SEVERE: SQL Error
          com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
                  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
                  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
                  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
                  at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2253)
                  at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
                  at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)
                  at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
                  at java.sql.DriverManager.getConnection(DriverManager.java:562)
                  at java.sql.DriverManager.getConnection(DriverManager.java:186)
                  at com.openexchange.admin.tools.AdminCache.getSimpleSqlConnection(AdminCache.java:411)
                  at com.openexchange.admin.storage.mysqlStorage.OXUtilMySQLStorageCommon.createDatabase(OXUtilMySQLStorageCommon.java:90)
                  at com.openexchange.admin.storage.mysqlStorage.OXUtilMySQLStorage.createDatabase(OXUtilMySQLStorage.java:397)
                  at com.openexchange.admin.storage.mysqlStorage.OXContextMySQLStorage.create(OXContextMySQLStorage.java:1120)
                  at com.openexchange.admin.rmi.impl.OXContext.createmaincall(OXContext.java:638)
                  at com.openexchange.admin.rmi.impl.OXContextCommonImpl.createcommon(OXContextCommonImpl.java:135)
                  at com.openexchange.admin.rmi.impl.OXContext.create(OXContext.java:210)
                  at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source)
                  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
                  at java.lang.reflect.Method.invoke(Method.java:618)
                  at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:309)
                  at sun.rmi.transport.Transport$1.run(Transport.java:168)
                  at java.security.AccessController.doPrivileged(AccessController.java:279)
                  at sun.rmi.transport.Transport.serviceCall(Transport.java:164)
                  at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:506)
                  at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.handleRequest(TCPTransport.java:838)
                  at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:912)
                  at java.lang.Thread.run(Thread.java:810)
          Caused by: java.sql.SQLException: Access denied for user 'openexchange'@'localhost' (using password: YES)
                  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
                  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
                  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
                  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
                  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)
                  at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923)
                  at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273)
                  at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2181)
                  ... 23 more
          Jun 18, 2008 11:33:47 AM com.openexchange.admin.storage.mysqlStorage.OXContextMySQLStorage create
          SEVERE: Storage Error
          com.openexchange.admin.rmi.exceptions.StorageException: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
                  at com.openexchange.admin.storage.mysqlStorage.OXUtilMySQLStorageCommon.createDatabase(OXUtilMySQLStorageCommon.java:131)
                  at com.openexchange.admin.storage.mysqlStorage.OXUtilMySQLStorage.createDatabase(OXUtilMySQLStorage.java:397)
                  at com.openexchange.admin.storage.mysqlStorage.OXContextMySQLStorage.create(OXContextMySQLStorage.java:1120)
                  at com.openexchange.admin.rmi.impl.OXContext.createmaincall(OXContext.java:638)
                  at com.openexchange.admin.rmi.impl.OXContextCommonImpl.createcommon(OXContextCommonImpl.java:135)
                  at com.openexchange.admin.rmi.impl.OXContext.create(OXContext.java:210)
                  at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source)
                  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
                  at java.lang.reflect.Method.invoke(Method.java:618)
                  at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:309)
                  at sun.rmi.transport.Transport$1.run(Transport.java:168)
                  at java.security.AccessController.doPrivileged(AccessController.java:279)
                  at sun.rmi.transport.Transport.serviceCall(Transport.java:164)
                  at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:506)
                  at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.handleRequest(TCPTransport.java:838)
                  at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:912)
                  at java.lang.Thread.run(Thread.java:810)
          Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
                  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
                  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
                  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
                  at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2253)
                  at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
                  at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)
                  at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
                  at java.sql.DriverManager.getConnection(DriverManager.java:562)
                  at java.sql.DriverManager.getConnection(DriverManager.java:186)
                  at com.openexchange.admin.tools.AdminCache.getSimpleSqlConnection(AdminCache.java:411)
                  at com.openexchange.admin.storage.mysqlStorage.OXUtilMySQLStorageCommon.createDatabase(OXUtilMySQLStorageCommon.java:90)
                  ... 16 more
          Caused by: java.sql.SQLException: Access denied for user 'openexchange'@'localhost' (using password: YES)
                  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
                  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
                  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
                  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
                  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)
                  at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923)
                  at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273)
                  at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2181)
                  ... 23 more
          Jun 18, 2008 11:33:47 AM com.openexchange.admin.storage.mysqlStorage.OXContextMySQLStorageCommon deleteContextFromConfigDB
          SEVERE: Unable to determine db_schema of context 1
          Jun 18, 2008 11:33:47 AM com.openexchange.admin.rmi.impl.OXContextCommonImpl createcommon
          SEVERE: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
          com.openexchange.admin.rmi.exceptions.StorageException: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
                  at com.openexchange.admin.storage.mysqlStorage.OXUtilMySQLStorageCommon.createDatabase(OXUtilMySQLStorageCommon.java:131)
                  at com.openexchange.admin.storage.mysqlStorage.OXUtilMySQLStorage.createDatabase(OXUtilMySQLStorage.java:397)
                  at com.openexchange.admin.storage.mysqlStorage.OXContextMySQLStorage.create(OXContextMySQLStorage.java:1120)
                  at com.openexchange.admin.rmi.impl.OXContext.createmaincall(OXContext.java:638)
                  at com.openexchange.admin.rmi.impl.OXContextCommonImpl.createcommon(OXContextCommonImpl.java:135)
                  at com.openexchange.admin.rmi.impl.OXContext.create(OXContext.java:210)
                  at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source)
                  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
                  at java.lang.reflect.Method.invoke(Method.java:618)
                  at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:309)
                  at sun.rmi.transport.Transport$1.run(Transport.java:168)
                  at java.security.AccessController.doPrivileged(AccessController.java:279)
                  at sun.rmi.transport.Transport.serviceCall(Transport.java:164)
                  at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:506)
                  at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.handleRequest(TCPTransport.java:838)
                  at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:912)
                  at java.lang.Thread.run(Thread.java:810)
          Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
                  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
                  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
                  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
                  at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2253)
                  at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
                  at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)
                  at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
                  at java.sql.DriverManager.getConnection(DriverManager.java:562)
                  at java.sql.DriverManager.getConnection(DriverManager.java:186)
                  at com.openexchange.admin.tools.AdminCache.getSimpleSqlConnection(AdminCache.java:411)
                  at com.openexchange.admin.storage.mysqlStorage.OXUtilMySQLStorageCommon.createDatabase(OXUtilMySQLStorageCommon.java:90)
                  ... 16 more
          Caused by: java.sql.SQLException: Access denied for user 'openexchange'@'localhost' (using password: YES)
                  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
                  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
                  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
                  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
                  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)
                  at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923)
                  at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273)
                  at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2181)
                  ... 23 more
          Any Ideas?

          Comment


          • #6
            Originally posted by cwx_nho View Post
            Any Ideas?
            Code:
            Caused by: java.sql.SQLException: Access denied for user 'openexchange'@'localhost' (using password: YES)
            try whether you can connect the mysql server using the command
            Code:
            mysql -u openexchange -pYOURCONFIGUREDPASSWD
            See also http://www.open-xchange.com/wiki/ind...osting_Edition

            Of course the command line client should print a different error in that case. I'll open a Bug for this issue.

            Comment


            • #7
              Originally posted by Carsten Hoeger View Post
              Code:
              Caused by: java.sql.SQLException: Access denied for user 'openexchange'@'localhost' (using password: YES)
              try whether you can connect the mysql server using the command
              Code:
              mysql -u openexchange -pYOURCONFIGUREDPASSWD
              See also http://www.open-xchange.com/wiki/ind...osting_Edition

              Of course the command line client should print a different error in that case. I'll open a Bug for this issue.
              Code:
              try whether you can connect the mysql server using the command
              Code:
              
              mysql -u openexchange -pYOURCONFIGUREDPASSWD
              
              See also http://www.open-xchange.com/wiki/ind...osting_Edition
              
              Of course the command line client should print a different error in that case. I'll open a Bug for this issue.
              
              openexchange | *D2CCE72390C74C74DE9FF33C68C4BDF687D2344B
              root         | *D2CCE72390C74C74DE9FF33C68C4BDF687D2344B 
              
              6 rows in set (0.00 sec)
              
              mysql> quit
              Bye
              # mysql -u openexchange -p
              Enter password:
              ERROR 1045 (28000): Access denied for user 'openexchange'@'localhost' (using password: YES)
              # mysql -u root -p
              Enter password:
              Welcome to the MySQL monitor.  Commands end with ; or \g.
              Your MySQL connection id is 72 to server version: 5.0.26
              
              Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
              
              mysql>
              It seems that the login with the same password for root and openexchange fails only for openexchange.

              Ideas?
              Last edited by cwx_nho; 06-18-2008, 02:09 PM.

              Comment


              • #8
                Originally posted by cwx_nho View Post
                [code]

                It seems that the login with the same password for root and openexchange fails only for openexchange.

                Ideas?
                Try to set the password manually using the MySQL GRANT command:

                GRANT ALL PRIVILEGES ON *.* TO 'openexchange'@'localhost' IDENTIFIED BY 'YOURSECRETHERE' WITH GRANT OPTION;

                Comment

                Working...
                X