CDbExecption opening database

More
1 month 3 weeks ago #159924 by paulfiner
paulfiner created the topic: CDbExecption opening database
I have been using V2.5 for several months now without problem but today I tried to access the Admin Panel as usual and was presented with a CDbException page saying failed to open the DB connection.
I set debug mode to 1 in config and now get a more detailed error page, some of which can be seen in the attached.
It is saying that my password has expired and I much change it using a client that supports expired passwords?
I can access the MYSQL database just fine using an external database client so not sure what is going on.
Any help greatly appreciated as I have a survey running right now and not sure if people can still access the survey.

Thanks,
Paul
Attachments:

Please Log in to join the conversation.

More
1 month 3 weeks ago #159928 by paulfiner
paulfiner replied the topic: CDbExecption opening database
I found the problem - it seems that passwords generated in later versions of MySQL have a time limit of approx 360 days. To reset the password follow the instructions in this StackOverflow post:
stackoverflow.com/questions/33387879/mys...expired-cant-connect

Please Log in to join the conversation.

More
1 month 3 weeks ago #159958 by DenisChenu
DenisChenu replied the topic: CDbExecption opening database
Really interesting : stackoverflow.com/a/41552022/2239406

Resetting the password will only solve the problem temporarily. From MySQL 5.7.4 to 5.7.10 (to encourage better security - see MySQL: Password Expiration Policy) the default default_password_lifetime variable value is 360 (1 year-ish). For those versions, if you make no changes to this variable (or to individual user accounts) all passwords expire after 360 days.


Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!