Locked out, like so many others, at database config

More
4 years 4 months ago #97385 by viatriskel
viatriskel created the topic: Locked out, like so many others, at database config
OK, Version 2.0 has me beaten. :( I'm an expert user of the "Search" function and this is the first time in ten years I've ever had to post a tech question on a help forum. Yesterday, I came back to LimeSurvey 1.92 after a unplanned break and found all my files and surveys in good working order, but having upgraded my PC since that first installation, I thought I'd also upgrade the software. 24 hours later, I'm still staring at the error: "Connection with database failed. Please check database location, user name and password and try again."

This installation is uploaded to Freehostia (as was v1.92 until I removed it yesterday) with the following SQL info:

Attachment sql_info.JPG not found



Attachment sql_info2.JPG not found



Step 3 of the installation process shows only the LDAP library missing and I don't think I'll need it in the foreseeable future.

Attachment ls_screen1.JPG not found



Then Step 4 gives me :

Attachment ls_screen2.JPG not found



I've tried "localhost", "127.0.0.1", "root" and probably every other combination that's been suggested in the previous pages on this forum, including the hack suggested for the installcontroller.php file (I've got about million limesurvey pages in my history now, can't remember which one it was). Nothing works.

I had no trouble whatsoever loading v1.92 at the time, and the XAMPP version of 2.0 is ticking away on another machine since this morning. I get the feeling I'm missing something very simple here, but WTF is it? :S
Attachments:

Please Log in to join the conversation.

More
4 years 4 months ago #97534 by viatriskel
viatriskel replied the topic: Locked out, like so many others, at database config
Resolved: the problem appears to have been nothing more complex than an unacceptably long database name (complicated in this case by too many attempts creating too many cookie fragments and other débris).

For the benefit of others:
- use the SQL server host name given on the Freehostia MySQL interface (see first image);
- create the database through Freehostia CP first, assigning a *short* prefix ('db' works!) and a password
- in the LS config panel, user name == database name ; password is what you're just chosen
- no need to change default folder permissions

Please Log in to join the conversation.

More
4 years 4 months ago #97543 by DenisChenu
DenisChenu replied the topic: Locked out, like so many others, at database config

viatriskel wrote: For the benefit of others:
- use the SQL server host name given on the Freehostia MySQL interface (see first image);
- create the database through Freehostia CP first, assigning a *short* prefix ('db' works!) and a password
- in the LS config panel, user name == database name ; password is what you're just chosen
- no need to change default folder permissions

Great,

Maybe you can add Freehostia to manual.limesurvey.org/LimeSurvey-compatible_hosting_companies and put some information.

Denis

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!