OX Database (IV.3.)

[altariq]

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

[Ben Pahne]

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

http://typo3.open-xchange.com/wiki/index.php?title=Open_Xchange_Installation#III.5._MySQL_database

[altariq]

yes
tried it 2 times

[Ben Pahne]

yes
tried it 2 times

what happens when you just try to open mysql?

& mysql

no host, no password and no username. just a ablank mysql.

[altariq]

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

[altariq]

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)

[Ben Pahne]

then try to give root the access to mysql:

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

btw: what system do you use?

[Carsten Hoeger]

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?

[altariq]

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)

[Daniel Halbe]

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

[altariq]

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

[altariq]

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

[Daniel Halbe]

@altariq

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

Daniel

[altariq]

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

[Carsten Hoeger]

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