Announcement

Collapse
No announcement yet.

Problem with Open-Xchange Configuration

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

  • 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
    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

    Comment


    • #3
      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?

      Comment


      • #4
        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).

        Comment


        • #5
          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

          Comment


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

            Comment


            • #7
              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.

              Comment


              • #8
                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.

                Comment


                • #9
                  @Carsten Hoeger

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

                  Comment


                  • #10
                    Aren't there any other solutions for my problem???

                    Comment


                    • #11
                      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.

                      Comment


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

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

                        Comment


                        • #13
                          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.

                          Comment


                          • #14
                            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.

                            Code:
                            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;
                            Last edited by Guest; 05-08-2009, 07:10 PM.

                            Comment


                            • #15
                              initconfigdb --mysql-root-passwd=mysql_root_password --configdb-pass=db_passwd -a

                              Comment

                              Working...
                              X