Problem with Open-Xchange Configuration

[MrBean06]

Hi,

I have a problem with open-Xchange configuration.

My system is a SLES 10 SP2 an OX6

I take the quick installation guide for SLES10.

My Problem is this:

SLES:~ # /opt/open-xchange/sbin/initconfigdb --configdb-pass=db_password
ERROR 1045 (28000): Access denied for user 'openexchange'@'localhost' (using password: YES)
initializing configdb from scratch...ERROR 1045 (28000): Access denied for user 'openexchange'@'localhost' (using password: YES)
ERROR

What could I change to remove my fault?

Your answer could be in German, too.

[Martin Heiland]

Hi,

it seems that the installation script for the database is unable to connect to your mysql instance using the given user and password. Did you try to connect via the mysql console like

$ mysql -hlocalhost -uopenexchange -pdb_password

If this fails, the user has not been created with appropriate permissions

GRANT ALL PRIVILEGES ON *.* TO 'openexchange'@'localhost' IDENTIFIED BY 'db_password';

another cause could be, that localhost is not mapped correctly to the lo interface (/etc/hosts file).

Greetings

[MrBean06]

The connect to the mysql console like

$ mysql -hlocalhost -uopenexchange -pdb_password

works correct.

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 37 to server version: 5.0.26

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Could you explain me the second point, what do you mean and what can I do?

[Carsten Hoeger]

You need to specify the "-a" option.

If that does not work, please run the command

sh -x /opt/open-xchange/sbin/initconfigdb --configdb-pass secret -a

and post the output here (your password will be within that output, FYI).

[MrBean06]

Here is the output:

+ OXFUNCTIONS=/opt/open-xchange/etc/oxfunctions.sh
+ ADMINCONF=/opt/open-xchange/etc/admindaemon
+ test -f /opt/open-xchange/etc/oxfunctions.sh
+ . /opt/open-xchange/etc/oxfunctions.sh
++ set +e
++ JAVA_BIN=
++ DEBIAN=1
++ REDHAT=2
++ SUSE=4
++ LSB=8
+ CONFIGDB_USER=openexchange
+ CONFIGDB_USER_LONG=configdb-user
+ CONFIGDB_PASS=
+ CONFIGDB_PASS_LONG=configdb-pass
+ CONFIGDB_HOST=localhost
+ CONFIGDB_HOST_LONG=configdb-host
+ CONFIGDB_PORT=3306
+ CONFIGDB_PORT_LONG=configdb-port
+ CONFIGDB_DBNAME=configdb
+ CONFIGDB_DBNAME_LONG=configdb-dbname
+ CREATEADMIN=
+ DLETETECONFIGDB=
+ MUSTOPTS=CONFIGDB_PASS
+ LONGOPTS='$CONFIGDB_USER_LONG:,$CONFIGDB_PASS_LONG:,$CONFIGDB_HOST_LONG:,$CONFIGDB_PORT_LONG:,$CONFIGDB_DBNAME_LONG:'
+++ eval echo '$CONFIGDB_USER_LONG:,$CONFIGDB_PASS_LONG:,$CONFIGDB_HOST_LONG:,$CONFIGDB_PORT_LONG:,$CONFIGDB_DBNAME_LONG:'
++++ echo configdb-user:,configdb-pass:,configdb-host:,configdb-port:,configdb-dbname:
++ POSIXLY_CORRECT=true
++ getopt -o iap:h --long configdb-user:,configdb-pass:,configdb-host:,configdb-port:,configdb-dbname:,help -- --configdb-pass=secret -a
+ TEMP=' --configdb-pass '\''secret'\'' -a --'
+ eval set -- ' --configdb-pass '\''secret'\'' -a --'
++ set -- --configdb-pass secret -a --
+ true
+ case "$1" in
+ CONFIGDB_PASS=secret
+ shift 2
+ true
+ case "$1" in
+ CREATEADMIN=true
+ shift
+ true
+ case "$1" in
+ shift
+ break
+ for opt in '$MUSTOPTS'
++ eval echo '$CONFIGDB_PASS'
+++ echo secret
+ opt_var=secret
++ eval echo '$CONFIGDB_PASS_LONG'
+++ echo configdb-pass
+ opt_var_long=configdb-pass
++ eval echo '$CONFIGDB_PASS_VALUES'
+++ echo
+ opt_var_values=
+ '[' -z secret ']'
+ '[' -n '' ']'
+ '[' -n true ']'
+ '[' root '!=' root ']'
++ mysql -h localhost -P 3306 -u openexchange -psecret -e 'show databases;' -B
++ grep configdb
ERROR 1045 (28000): Access denied for user 'openexchange'@'localhost' (using password: YES)
+ '[' '' == configdb ']'
+ echo -n 'initializing configdb from scratch...'
initializing configdb from scratch...+ '[' -n true ']'
+ cat
+ mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
+ die
+ test -n ''
+ echo ERROR
ERROR
+ exit 1

[Carsten Hoeger]

Did you use secret as password or did you change the password just in the output?

[Carsten Hoeger]

Here is the output:

[...]
+ mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
+ die
+ test -n ''
+ echo ERROR
ERROR
+ exit 1

There's the error.
root is not allowed to access the mysql database.
If that's the case, the installer does not work.

[MrBean06]

I change the password back to 'db_password' and I have clear all other user in mysql.
Than I tried to login to mysql with the command from bash script:

Obelix:~ # mysql -h localhost -P 3306 -u openexchange -pdb_password

and got the error:

ERROR 1045 (28000): Access denied for user 'openexchange'@'localhost' (using password: YES)

But when I used this way:

Obelix:~ # mysql -u openxchange -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 62 to server version: 5.0.26

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

it works fine.

[MrBean06]

@Carsten Hoeger

it looks so, but I don't know why?

[MrBean06]

Aren't there any other solutions for my problem???

[Martin Heiland]

Of course there is a solution: remove the mysql root users password and set it after the installation has been done. Just like Carsten said.

[MrBean06]

So, now I have found a solution until the next step:

/opt/open-xchange/sbin/initconfigdb --confgdb-user='openxchange' --configdb-pass='db_password'

[ECB]

I am having the same problem. Running Ubuntu 8.04.2 64-bit.

I really want to get this thing going - what is the solution?

Thanks.

[Hobb3s]

I have an answer to this..

The script needs a -p thrown into where it starts the mysql & mysqladmin commands, so that it asks your for your root password to continue.

if [ -n "$CREATEADMIN" ]; then
    cat<<EOF |[B] [FONT="Arial Black"]mysql -p[/FONT] [/B]|| die
drop database if exists \`${CONFIGDB_DBNAME}\`;
GRANT ALL PRIVILEGES ON *.* TO '$CONFIGDB_USER'@'%' IDENTIFIED BY '$CONFIGDB_PASS' WITH GRANT OPTION;

[yanwang800]

initconfigdb --mysql-root-passwd=mysql_root_password --configdb-pass=db_passwd -a