- Posts: 117
- Thank you received: 9
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
CDbExecption opening database
- paulfiner
- Topic Author
- Offline
- Premium Member
Less
More
6 years 5 months ago #159924
by paulfiner
CDbExecption opening database was created by paulfiner
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
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:
The topic has been locked.
- paulfiner
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 117
- Thank you received: 9
6 years 5 months ago #159928
by paulfiner
Replied by paulfiner on 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
stackoverflow.com/questions/33387879/mys...expired-cant-connect
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
6 years 5 months ago #159958
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on 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 , plugin development .
I don't answer to private message.
The topic has been locked.