Announcement

Collapse
No announcement yet.

OX Database (IV.3.)

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

  • OX Database (IV.3.)

    Hello there,

    root@schmidt-mg:~# /opt/open-xchange/sbin/oxinstaller --oxdb-pass=mypass --admin-pass=mypass --maildomain mydomain.com
    initializing databaseERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
    done

    I followed all points in the Installhow to and had no errors before

  • #2
    Originally posted by altariq View Post
    Hello there,

    root@schmidt-mg:~# /opt/open-xchange/sbin/oxinstaller --oxdb-pass=mypass --admin-pass=mypass --maildomain mydomain.com
    initializing databaseERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
    done

    I followed all points in the Installhow to and had no errors before
    followed this step? ->

    Comment


    • #3
      yes
      tried it 2 times

      Comment


      • #4
        Originally posted by altariq View Post
        yes
        tried it 2 times
        what happens when you just try to open mysql?

        Code:
        & mysql
        no host, no password and no username. just a ablank mysql.

        Comment


        • #5
          Another problem in the wiki is:

          IV.5.3
          hange /etc/pam.d/imap that it looks like:

          passwd=<pass>

          Password in "<>" or not? Sometimes there is <YOURPASSFROMINSTALL> somtimes YOURPASSFROMINSTALL

          Comment


          • #6
            Before i follow the steps in III.5 it works.
            Than i follow the steps with mysqladmin und grant all on ..
            Now & mysql brings the same output

            initializing databaseERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

            Comment


            • #7
              then try to give root the access to mysql:



              btw: what system do you use?

              Comment


              • #8
                Originally posted by altariq View Post
                Before i follow the steps in III.5 it works.
                Than i follow the steps with mysqladmin und grant all on ..
                Now & mysql brings the same output

                initializing databaseERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
                What mysql Version are you using and what OS and Version?

                What does

                echo "select host,user from mysql.user;" |mysql

                and
                echo "select host,user from mysql.user;" |mysql -u openexchange -pyoursecret

                and

                mysql -V

                say?

                Comment


                • #9
                  Its ubuntu 6.10 Server

                  ill try it now

                  openexchange@schmidt-mg:~$ mysql -V
                  mysql Ver 14.12 Distrib 5.0.24a, for pc-linux-gnu (i486) using readline 5.1



                  echo "select host,user from mysql.user;" |mysql
                  ERROR 1045 (28000): Access denied for user 'openexchange'@'localhost' (using password: NO)


                  @Ben

                  i tried this:

                  Alternatively, on any platform, you can set the new password using the mysql client(but this approach is less secure):

                  1.

                  Stop mysqld and restart it with the --skip-grant-tables --user=root options (Windows users omit the --user=root portion).
                  2.

                  Connect to the mysqld server with this command:

                  shell> mysql -u root

                  3.

                  Issue the following statements in the mysql client:

                  mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd')
                  -> WHERE User='root';
                  mysql> FLUSH PRIVILEGES;

                  Replace “newpwd” with the actual root password that you want to use.
                  4.

                  You should be able to connect using the new password.
                  and got this:

                  root@schmidt-mg:/home/openexchange# /etc/init.d/mysql stop
                  * Stopping MySQL database server mysqld [ ok ]
                  root@schmidt-mg:/home/openexchange# /etc/init.d/mysql start --skip-grant-tables --user=root
                  * Starting MySQL database server mysqld [ ok ]
                  * Checking for corrupt, not cleanly closed and upgrade needing tables.
                  root@schmidt-mg:/home/openexchange# mysql -u root
                  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
                  root@schmidt-mg:/home/openexchange# mysql -u root -p
                  Enter password:
                  Welcome to the MySQL monitor. Commands end with ; or \g.
                  Your MySQL connection id is 7 to server version: 5.0.24a-Debian_9ubuntu1-log

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

                  mysql> UPDATE mysql.user SET Password=PASSWORD('mypass')
                  -> WHERE User='root';
                  Query OK, 1 row affected (0.00 sec)
                  Rows matched: 2 Changed: 1 Warnings: 0

                  mysql> FLUSH PRIVILEGES;
                  Query OK, 0 rows affected (0.00 sec)

                  mysql> Aborted
                  root@schmidt-mg:/home/openexchange# mysql
                  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

                  Last edited by Guest; 03-05-2007, 05:54 PM.

                  Comment


                  • #10
                    This is a bug in our documentation in wiki. I changed the documentation to correct this issue.

                    The oxinstaller only works if mysql rootpassword is not set!

                    So please first do an "mysqladmin password "" -p" Enter the password you set for mysql root to have the mysql root password unset.

                    Then start oxinstaller again.

                    Daniel
                    Last edited by Daniel Halbe; 03-05-2007, 06:41 PM.

                    Comment


                    • #11
                      thanks alot, i will try it tomorrow @work

                      but whats with my password question? sometimes you write the password in those <> (dont know the english word for it) and sometimes not. its confusing me a lot

                      Comment


                      • #12
                        So, ive done the steps in the wiki.
                        Everything works fine but when i try to login i get this error message:

                        Fehlermeldung 503: Service Temporarily unavailable


                        edit:

                        SOLVED:

                        i forgot to restart the groupware

                        thx for help
                        Last edited by Guest; 03-06-2007, 10:06 AM.

                        Comment


                        • #13
                          @altariq

                          So my changes of wiki documentation have solved any problems or did you change parts of the howto?

                          Daniel

                          Comment


                          • #14
                            Your changes solved it.
                            Only problem is that:

                            root@schmidt-mg:/home/openexchange# /opt/open-xchange/sbin/open-xchange-groupware start
                            /opt/open-xchange /home/openexchange


                            and than i cant see the prompt. I have to let the window open because when i close it, groupware stops. The rest works fine but without email, but this you can read in my new thread

                            Comment


                            • #15
                              Originally posted by altariq View Post
                              Your changes solved it.
                              Only problem is that:

                              root@schmidt-mg:/home/openexchange# /opt/open-xchange/sbin/open-xchange-groupware start
                              /opt/open-xchange /home/openexchange


                              and than i cant see the prompt. I have to let the window open because when i close it, groupware stops. The rest works fine but without email, but this you can read in my new thread
                              When you're using debian, simply use the init script

                              /etc/init.d/open-xchange-groupware

                              Comment

                              Working...
                              X