Page 1 of 1

Password trouble in Zoneminder Mysql 'Your password does not satisfy the current...'

Posted: Fri Aug 19, 2016 5:06 pm
by ZMUbuNewbie
I am having problems with my setting up of Zoneminder.

I have a double, quad-core Dell r710 server. 16gigs of RAM.

Server has 3, 2TB drives set up as RAID 5.

I installed following, by using the Easy Way directions found here:

https://wiki.zoneminder.com/Ubuntu_S...0_the_easy_way

1. Installed Basic Ubuntu 16.04 Server, with OpenSSH Server, and LAMP Server and followed the directions until...

2. 'mysql_secure_installation'. I set up a password.

3. 'apt-get install mysqltuner'. Installed but made no changes.

4. 'apt-get install zoneminder php-gd'. Installed zoneminder. no problems here.

5. 'mysql -uroot -p < /usr/share/zoneminder/db/zm_create.sql'. This is where i get stuck. I get following error when trying to enter password:
"ERROR 1819 (HY000) at line 562: Your password does not satisfy the current policy requirements"

I did begin of install by typing it in (not copy paste). I was very careful not to make mistakes and do not believe i did. I have since figure out how to remotely enter server and am copy pasting commands to avoid any possible errors.

I had changed passwords multiple times. When i create the password, i am given a 100% mark. I have changed the setting to LOW security. Nothing works. Still get this same error line. I am stumped and cannot get any further in install. Any help would be appreciated.

Not sure if this is related, but had many issues with installation of Ubuntu Server. It would boot up to Grub Rescue. I eventually repaired grub with the Grub Boot repair disk. I was then able to start the ZM install until i hit the above password roadblock. When i restarted it the next day, i gave me a basic grub prompt and i could not do anything. I had to run the Grub boot repair disk again. Now It has restarted multiple times no problem.

BTW, i am a novice in linux and learning. So please be as descriptive as possible. Thank you in advance.

Re: Password trouble in Zoneminder Mysql 'Your password does not satisfy the current...'

Posted: Sat Aug 20, 2016 8:13 am
by SteveGilvarry
Sounds like the Password validation plugin in mysql, I believe Mysqltuner probably should be recommended after install. That is my guess for that installed Password Validation for you. You will have to check mysql config for something like this and remove it and restart mysql. The error is coming from the line that sets user admin to password admin.
[mysqld]
plugin-load=validate_password.so

Re: Password trouble in Zoneminder Mysql 'Your password does not satisfy the current...'

Posted: Sat Aug 20, 2016 6:10 pm
by bbunge
The WIKI link you cited does not exist. Use this one:
https://wiki.zoneminder.com/Ubuntu_Serv ... e_easy_way

You set the MySQL password when you install LAMP on Ubuntu and you do not need to change it after that. Yes, you can use mysql_secure_installation but you do not have to change the password. If you switch to Mariadb you will need to set the password.

Sounds like you need to start over with the Ubuntu server install. I would guess that you are using hardware RAID?

bb