Error: Cannot get connection to database.

[workininthemornin]

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

[Martin Heiland]

Hi,

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

Greetings

[workininthemornin]

Hi,

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

Greetings

# /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:

#!/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.

[workininthemornin]

# /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