Homepage | Products | OX Knowledge Base | Support | Try Now | Contact | Company
OX Logo
Page 1 of 2 12 LastLast
Results 1 to 10 of 15
  1. #1

    Default Problem with Open-Xchange Configuration

    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.

  2. #2
    Join Date
    Feb 2007
    Location
    Germany
    Posts
    3,695

    Default

    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
    Code:
    $ mysql -hlocalhost -uopenexchange -pdb_password
    If this fails, the user has not been created with appropriate permissions
    Code:
    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

  3. #3

    Default

    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?

  4. #4
    Carsten Hoeger is offline Open-Xchange Professional Services
    Join Date
    Mar 2007
    Posts
    703

    Default

    You need to specify the "-a" option.

    If that does not work, please run the command

    Code:
    sh -x /opt/open-xchange/sbin/initconfigdb --configdb-pass secret -a
    and post the output here (your password will be within that output, FYI).
    OXpedia.org - the answer to almost all questions.

  5. #5

    Default

    Here is the output:

    Code:
    + 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

  6. #6
    Carsten Hoeger is offline Open-Xchange Professional Services
    Join Date
    Mar 2007
    Posts
    703

    Default

    Did you use secret as password or did you change the password just in the output?
    OXpedia.org - the answer to almost all questions.

  7. #7
    Carsten Hoeger is offline Open-Xchange Professional Services
    Join Date
    Mar 2007
    Posts
    703

    Default

    Quote Originally Posted by MrBean06 View Post
    Here is the output:

    Code:
    [...]
    + 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.
    OXpedia.org - the answer to almost all questions.

  8. #8

    Default

    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:

    Code:
    Obelix:~ # mysql -h localhost -P 3306 -u openexchange -pdb_password
    and got the error:

    Code:
    ERROR 1045 (28000): Access denied for user 'openexchange'@'localhost' (using password: YES)
    But when I used this way:

    Code:
    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.

  9. #9

    Default

    @Carsten Hoeger

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

  10. #10

    Default

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

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •