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

More
4 years 6 months ago #94683 by Draikin
Draikin created the topic: "Cdbconnection failed to open the db connection" on step 6 during inst
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.

Please Log in to join the conversation.

More
4 years 6 months ago #94704 by tbrice18
tbrice18 replied the topic: "Cdbconnection failed to open the db connection" on step 6 during inst
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.

Please Log in to join the conversation.

More
4 years 6 months ago #94811 by Draikin
Draikin replied the topic: "Cdbconnection failed to open the db connection" on step 6 during inst
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?

Please Log in to join the conversation.

More
4 years 6 months ago #94816 by tbrice18
tbrice18 replied the topic: "Cdbconnection failed to open the db connection" on step 6 during inst
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.

Please Log in to join the conversation.

More
4 years 6 months ago #94817 by mdekker
mdekker replied the topic: "Cdbconnection failed to open the db connection" on step 6 during inst
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

Please Log in to join the conversation.

More
4 years 6 months ago #94856 by Draikin
Draikin replied the topic: "Cdbconnection failed to open the db connection" on step 6 during inst
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.

Please Log in to join the conversation.

More
4 years 6 months ago #95058 by Draikin
Draikin replied the topic: "Cdbconnection failed to open the db connection" on step 6 during inst
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.

Please Log in to join the conversation.

More
4 years 6 months ago #95179 by Mazi
Mazi replied the topic: "Cdbconnection failed to open the db connection" on step 6 during inst
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)survey-consulting.com'"

Please Log in to join the conversation.

More
4 years 6 months ago #95199 by Draikin
Draikin replied the topic: "Cdbconnection failed to open the db connection" on step 6 during inst
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.

Please Log in to join the conversation.

More
4 years 6 months ago #95204 by Mazi
Mazi replied the topic: "Cdbconnection failed to open the db connection" on step 6 during inst
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)survey-consulting.com'"
The following user(s) said Thank You: Draikin

Please Log in to join the conversation.

More
4 years 6 months ago #95209 by Draikin
Draikin replied the topic: "Cdbconnection failed to open the db connection" on step 6 during inst

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

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now