Author Topic: Script reset mysql password fails cwp on centos 7  (Read 9060 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Script reset mysql password fails cwp on centos 7
« on: February 17, 2017, 05:31:31 AM »
Installed CWP latest on centos 7, ran cwp update latest.

Ran script to update mysql password, and then login to panel failed with error message, obfuscated and check mysql password etc, so I edited a copy of script to put original password back (which I fortunately had) ran it and then was able to log in normally.

This script worked on my centos 6 previous install on same hardware (and still does) but not on latest centos 7 install with mariadb, there appears to be something in the script that is not operating correctly with this CWP (ver 241), I have tried it out several times and it happens consistently.

Offline
*
Re: Script reset mysql password fails cwp on centos 7
« Reply #1 on: February 26, 2017, 01:21:55 PM »
Problem still exists - fully updated to Ver: 0.9.8.263  :(

Lest there be any confusion that command is:  cd /scripts/ ; sh mysql_pwd_reset
« Last Edit: February 26, 2017, 01:27:48 PM by indigo »

Offline
*****
Re: Script reset mysql password fails cwp on centos 7
« Reply #2 on: February 26, 2017, 02:19:57 PM »
try this script :
https://drop.me/opgOYB

Offline
*
Re: Script reset mysql password fails cwp on centos 7
« Reply #3 on: February 26, 2017, 10:46:42 PM »
try this script :
https://drop.me/opgOYB

Sorry still fails with updated script, on console when run - after line "resetting password" this error : ERROR 2002 (HY000) Cant connect to local MySQL server through socket ' /var/lib/mysql/mysql.sock' (2 "No such file or directory)

and after line "Cleaning up ..."  ERROR! MySQL is running but PID file could not be found.

Im on centos 7 64 bit

NB when I run my modified version of original script to put original password back ( just hard coded password where it was generated randomly thats all ) it give same errors but login then works again - it is very weird !

I checked mysql.sock does exist in that folder.  also on original got "stopping/starting mysqld (via systemctl) OK" so I dont think command to stop and start mysql is where the problem lies..., as I see thats what has been altered in script.
« Last Edit: February 26, 2017, 11:11:37 PM by indigo »