Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: "Cdbconnection failed to open the db connection" on step 6 during installation

"Cdbconnection failed to open the db connection" on step 6 during installation 3 years 4 months ago #94683

  • Draikin
  • Draikin's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 6
  • Karma: 0
Hi,

I'm trying to get build 130325 to work on Windows shared hosting (Windows Server 2008, SQL Server 2008 R2). I got as far as step 6 (optional settings) during the installation. The previous steps worked fine, the database was configured properly, but clicking next on step 6 gives me an "Internal server error" and on the next line "Cdbconnection failed to open the db connection". I read something about changing the config.php file manually, but there's none to be found, only the default config files are there. Any help would be appreciated.
The administrator has disabled public write access.

"Cdbconnection failed to open the db connection" on step 6 during installation 3 years 4 months ago #94704

  • tbrice18
  • tbrice18's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 9
  • Karma: 0
I am also working with a Windows Server 2008, SQL Server 2008 R2 and got the very same error. I would also appreciate being pointed in the right direction.
The administrator has disabled public write access.

"Cdbconnection failed to open the db connection" on step 6 during installation 3 years 4 months ago #94811

  • Draikin
  • Draikin's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 6
  • Karma: 0
I now tried installing it using a MySQL database, but I have the exact same problem there. I'm not sure why, is the problem perhaps the missing config.php file?
The administrator has disabled public write access.

"Cdbconnection failed to open the db connection" on step 6 during installation 3 years 4 months ago #94816

  • tbrice18
  • tbrice18's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 9
  • Karma: 0
Check the installation manual, especially the portion about having the correct sqlsvr driver installed. Although I did check that for my installation and it did not solve anything, shot in the dark, may work for you. I have Moodle installed on the same 2008 Windows server with a backend MS SQL database on a Windows 2008 R2 server and there was never any connection issues. Something in the LS code requires those drivers and its not compatible with my system set up.
The administrator has disabled public write access.

"Cdbconnection failed to open the db connection" on step 6 during installation 3 years 4 months ago #94817

  • mdekker
  • mdekker's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 343
  • Thank you received: 68
  • Karma: 38
To get a better error message during install, you can open /application/config/config-sample-mysql.php en scroll to the end. Modify

'debug'=>0,
to
'debug'=>2,

and see if that creates a visible error. If you get an error, please report the detailed message in the Bugtracker.
---
Menno Dekker
The administrator has disabled public write access.

"Cdbconnection failed to open the db connection" on step 6 during installation 3 years 4 months ago #94856

  • Draikin
  • Draikin's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 6
  • Karma: 0
Thanks, I changed the value but unfortunately the error message stays the same. I've tried looking for error logs, but the application/logs doesn't contain any log files.
The administrator has disabled public write access.

"Cdbconnection failed to open the db connection" on step 6 during installation 3 years 4 months ago #95058

  • Draikin
  • Draikin's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 6
  • Karma: 0
I've been looking into the problem, and I'm wondering if PDO drivers possibly explain this problem? I don't know if it would get that far in the installation if those were missing. I've contacted my webhost, they confirmed the problem but no solution for now.
The administrator has disabled public write access.

"Cdbconnection failed to open the db connection" on step 6 during installation 3 years 4 months ago #95179

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5984
  • Thank you received: 368
  • Karma: 260
Missing PDO drivers might cause such problems but I wonder if in such a case the installation would proceed that far at all.

Check if the config.php is created at LimeSurvey\application\config

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

"Cdbconnection failed to open the db connection" on step 6 during installation 3 years 4 months ago #95199

  • Draikin
  • Draikin's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 6
  • Karma: 0
Apparently the PDO drivers are installed so that can't be the cause.
Mazi wrote:
Check if the config.php is created at LimeSurvey\application\config
It's not.
The administrator has disabled public write access.

"Cdbconnection failed to open the db connection" on step 6 during installation 3 years 4 months ago #95204

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5984
  • Thank you received: 368
  • Karma: 260
Hmm, I would assume that at this step the config.php should have been created so when logging in later, the DB connection details can be read from file.
There is a check at the beginning if that folder is writable. Maybe there are still conflicts with restricted rights, e.g. the server not being able to create files?!

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
The following user(s) said Thank You: Draikin

"Cdbconnection failed to open the db connection" on step 6 during installation 3 years 4 months ago #95209

  • Draikin
  • Draikin's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 6
  • Karma: 0
Mazi wrote:
There is a check at the beginning if that folder is writable. Maybe there are still conflicts with restricted rights, e.g. the server not being able to create files?!
Good call, the check indeed said everything was fine, but like you said there was still a problem with the permissions. I think what solved this problem was ultimately giving the Network Service write permissions to the folder.

Unfortunately, while I now completed the installation, it's now crashing with an IIS 7.0 error on the admin page:

HTTP Error 500.0 - CDbException
The page cannot be displayed because an internal server error has occurred.

Module FastCgiModule
Notification ExecuteRequestHandler
Handler PHP_via_FastCGI
Error Code 0x00000000

Requested URL http://.../limesurvey/index.php?r=admin
Physical Path ...\wwwroot\limesurvey\index.php
Logon Method Anonymous
Logon User Anonymous
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.292 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form