Clinderw
Explorer
- Joined
- Aug 11, 2013
- Messages
- 96
FreeNAS-11.3-U1
Updated ZM to v1.32.3
Alright...I updated ZM on two different iocage jails and after updating I ran into this issue...'Unable to connect to ZM db.SQLSTATE[HY000] [1045] Access denied for user 'zmuser'@'localhost' (using password: YES)'. I've spend 8+ hours trying to reset the password, reinstall mysql or the db...doing a lot of stuff that didn't work.
Then, I saw in the logs the zmuser wasn't the right user...it was now trying to use dbuser...that didn't make sense.
I was about to give up and just start over (again!) but then...I found there are post-install notes in the jail. WHY DIDN'T I KNOW THAT? WHY DIDN'T ANYONE MENTION IT!
In the jails menu...bottom right corner
Click on 'Post Install Notes' (I replaced password with *s)
Holy sh*t that is what I've been looking for! Why did they change the user and password? I don't know...but whatever, this is what I needed.
Go to: iocage/jails/Zoneminder_2020/root/usr/local/etc (replace Zoneminder_2020 with your jail name) and edit the zm.conf file...
Replace the user and password with the one in the post install notes.
Restart the jail.
It should work now.
Hope this saves someone else frustration and time
Updated ZM to v1.32.3
Alright...I updated ZM on two different iocage jails and after updating I ran into this issue...'Unable to connect to ZM db.SQLSTATE[HY000] [1045] Access denied for user 'zmuser'@'localhost' (using password: YES)'. I've spend 8+ hours trying to reset the password, reinstall mysql or the db...doing a lot of stuff that didn't work.
Then, I saw in the logs the zmuser wasn't the right user...it was now trying to use dbuser...that didn't make sense.
I was about to give up and just start over (again!) but then...I found there are post-install notes in the jail. WHY DIDN'T I KNOW THAT? WHY DIDN'T ANYONE MENTION IT!
In the jails menu...bottom right corner
Click on 'Post Install Notes' (I replaced password with *s)
Holy sh*t that is what I've been looking for! Why did they change the user and password? I don't know...but whatever, this is what I needed.
Go to: iocage/jails/Zoneminder_2020/root/usr/local/etc (replace Zoneminder_2020 with your jail name) and edit the zm.conf file...
Replace the user and password with the one in the post install notes.
Restart the jail.
It should work now.
Hope this saves someone else frustration and time