mysql fails zm_database_init
Posted: Wed Sep 14, 2011 12:09 am
Totally new install of openSUSE 11.4 and zoneminder 1.24
Second iteration of install to formatted partitions of both of above.
When running zm_database_init, it requests the root password ONCE, then writes the files into /root/...
Then it fails to log into mysql. Yes, it is running.
I can manually log into it with:
mysql -u root =p
mypassword
and then look at databases and tables.
The zoneminder data base is NOT present, and the password written to /root/.my.cnf matches what I entered above to log into mysql.
This was fresh install of openSUSE 11.4, then all updates as of today, setup HTTP with Yast, then zoneminder from the repos in the wiki:
http://www.liquid-co.de/pub/suse/repositories/11.4/ and
http://download.opensuse.org/repositori ... SUSE_11.4/
then
$ rcmysql start
At this point in my first process through, I did
$ mysqladmin -u root password 'mypassword'
When zm_database_init failed as above, I redid the complete install, only this time did not setup the password using mysqladmin, and went to zm_database_init. Same failure.
Both times I could log into mysql with the password that was save in .my.cnf, and both times zm_database_init failed.
I had done this same procedure a couple of weeks ago, same hardware, same versions, etc. and it worked. I then got hit by the login failure loop when I enabled access control.
Second iteration of install to formatted partitions of both of above.
When running zm_database_init, it requests the root password ONCE, then writes the files into /root/...
Then it fails to log into mysql. Yes, it is running.
I can manually log into it with:
mysql -u root =p
mypassword
and then look at databases and tables.
The zoneminder data base is NOT present, and the password written to /root/.my.cnf matches what I entered above to log into mysql.
This was fresh install of openSUSE 11.4, then all updates as of today, setup HTTP with Yast, then zoneminder from the repos in the wiki:
http://www.liquid-co.de/pub/suse/repositories/11.4/ and
http://download.opensuse.org/repositori ... SUSE_11.4/
then
$ rcmysql start
At this point in my first process through, I did
$ mysqladmin -u root password 'mypassword'
When zm_database_init failed as above, I redid the complete install, only this time did not setup the password using mysqladmin, and went to zm_database_init. Same failure.
Both times I could log into mysql with the password that was save in .my.cnf, and both times zm_database_init failed.
I had done this same procedure a couple of weeks ago, same hardware, same versions, etc. and it worked. I then got hit by the login failure loop when I enabled access control.