Announcement

Collapse
No announcement yet.

Error: Cannot get connection to database.

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

  • Error: Cannot get connection to database.

    After doing a new OX installation, when I try to login I receive the following message: "Error: Cannot get connection to database. (CTX-0005, 254612787-15)" (full trace).

    So I checked configb/application database and I see that in the "SELECT * FROM db_pool;" step I have name=oxdatabase but in the mysql server the only oxdatabase I see is "oxdatabase_5". Is it the normal behaviour?

    OX version: 6.20.0 Rev8 (2011-04-21 12:43:06)
    OS: Debian Squeeze (6.0.2)

    # java -version
    java version "1.6.0_26"
    Java(TM) SE Runtime Environment (build 1.6.0_26-b03)
    Java HotSpot(TM) 64-Bit Server VM (build 20.1-b02, mixed mode)

    Other info:
    dpkg -l
    /opt/open-xchange/sbin/listbundles
    processes running

  • #2
    Hi,

    what does /opt/open-xchange/sbin/listdatabases output? Have you followed the installation guide step by step?

    Greetings

    Comment


    • #3
      Originally posted by Martin Braun View Post
      Hi,

      what does /opt/open-xchange/sbin/listdatabases output? Have you followed the installation guide step by step?

      Greetings
      Code:
      # /opt/open-xchange/sbin/listdatabase 
      databases could not be listed: 
      Server response:
       Authentication failed
      Regarding the installation guide, I've followed the official, using this script:
      Code:
      #!/bin/sh
      
      /opt/open-xchange/sbin/initconfigdb --configdb-pass=blabla -a 
      
      /opt/open-xchange/sbin/oxinstaller --no-license --servername=oxserver --configdb-pass=blabla --master-pass=blabla --ajp-bind-port=localhost 
      
      /etc/init.d/open-xchange-admin restart
      
      sleep 15
      
      /opt/open-xchange/sbin/registerserver -n oxserver -A oxadminmaster -P blabla
      
      /opt/open-xchange/sbin/registerfilestore -A oxadminmaster -P blabla -t file:/var/opt/filestore 
      
      /opt/open-xchange/sbin/registerdatabase -A oxadminmaster -P blabla -n oxdatabase -p blabla -m true 
      
      /etc/init.d/open-xchange-groupware restart
      
      sleep 10
      
      /opt/open-xchange/sbin/createcontext -A oxadminmaster -P blabla -c 1 -u oxadmin -d "Context Admin" -g Admin -s User -p blabla -L defaultcontext -e oxadmin@ox.domain.com -q 1024 --access-combination-name=all
      
      /opt/open-xchange/sbin/createuser -c 1 -A oxadmin -P blabla -u testuser -d "Test User" -g Test -s User -p blabla -e testuser@ox.domain.com --imaplogin testuser --imapserver 127.0.0.1 --smtpserver 127.0.0.1

      I've modified all the passwords to "blabla".

      The sleep command is used for waiting until the service is up and running.

      Comment


      • #4
        Originally posted by workininthemornin View Post
        # /opt/open-xchange/sbin/listdatabase
        databases could not be listed:
        Server response:
        Authentication failed
        Uops, big fail, let's do it fine this time:

        #*/opt/open-xchange/sbin/listdatabase -A oxadminmaster -P blabla
        id name hostname master mid weight maxctx curctx hlimit max inital
        3 oxdatabase localhost true 0 100 1000 1 true 100 0

        Comment

        Working...
        X