Upon trying to install lime survey for the first time, I encounter the following error:


Can't connect to LimeSurvey database. Reason: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)


I have successfully installed Drupal and mediawiki on this server and doubt it is a problem with the host.

My friend says that LimeSurvey may be trying to connect through the wrong socket. We can't find which file sets the socket connection.

Any suggestions?

Very many thanks!
Matt

1. Which version do you use?

2. Do you use several different database servers?

3. Please post your database settings you set in config.php.

Thanks for your attention!

1. I just downloaded the latest release 1.70+ Stable

2. I only use one database server, a Strato-hosting MySQL server.

3. // Basic Setup

$databasetype = "mysql"; // ADOdb database driver - valid values are mysql, odbc_mssql or postgres
$databaselocation = "localhost"; // Network location of your Database - for odbc_mssql use the mssql servername, not localhost or IP
$databasename = "db404863"; // The name of the database that we will create
$databaseuser = "u404863"; // The name of a user with rights to create db (or if db already exists, then rights within that db)
$databasepass = "*****"; // Password of db user
$dbprefix = ""; // A global prefix that can be added to all LimeSurvey tables. Use this if you are sharing
// a database with other applications. Suggested prefix is "lime_"

// File Locations
$rooturl = "http://{$_SERVER['HTTP_HOST']}/limesurvey"; //The root web url for your limesurvey installation (without a trailing slash).
$relativeurl = "/limesurvey"; // the url relative to you DocumentRoot where is installed LimeSurvey (without a trailing slash). Usually same as $rooturl without http://{$_SERVER['HTTP_HOST']}. Used by Fcked Filemanager

$rootdir = dirname(__FILE__); // This is the physical disk location for your limesurvey installation. Normally you don't have to touch this setting.
// If you use IIS then you MUST enter the complete rootdir e.g. : $rootDir="C:Inetpubwwwrootlimesurvey"!
// Some IIS installations also require to use forward slashes instead of backslashes, e.g. $rootDir="C:/Inetpub/wwwroot/limesurvey"!
// If you use OS/2 this must be the complete rootdir with FORWARD slashes e.g.: $rootDir="c:/limesurvey";!
// Site Setup
$sitename = "LimeSurvey"; // The official name of the site (appears in the Window title)

$defaultuser = "matt"; // This is the default username when LimeSurvey is installed
$defaultpass = "*****"; // This is the default password for the default user when LimeSurvey is installed

// Email Settings

$siteadminemail = ""; // The default email address of the site administrator
$siteadminbounce = ""; // The default email address used for error notification of sent messages for the site administrator (Return-Path)
$siteadminname = "Matthew Linares"; // The name of the site administrator

?>

This setting is still set to localhost:


If you want to run limesurvey on your Strato server you have to edit this setting. Just compare this to your mediawiki settings.

Thank you again. However, I set my database location to "rdbms.strato.de" which is currently used both by Drupal and a googlemaps API linked database.

With Lime Survey, this just produces:

"Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, This e-mail address is being protected from spam bots, you need JavaScript enabled to view it and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log."

OUCH!

Perhaps you have a moment to give it another shot?!

Thanks.,
Matt

That's quite strange that Drupal runs wins these settings but Limesurvey doesn't. Did you try to contact your server administrator? Maybe the logs can give a hint what went wrong!?

Any progress?

Have you been able to solve your problem? If so, how did you solve it? Any kind of feedback is always appreciated so we know which solution helps best to solve common problems.

Hi
I have a server at home
Windows XP Professional
Xampp with some sites all working

I just unpacked limsurvey 1.7+ and pasted the folder into xampp default directory.
I made the changes as it says in the instructions and i got the same error!
Here it is what changes i made:
________________________________________________________________________
$databasetype = 'mysql'; // ADOdb database driver - valid values are mysql, odbc_mssql or postgres
$databaselocation = 'localhost'; // Network location of your Database - for odbc_mssql use the mssql servername, not localhost or IP
$databasename = 'lime'; // The name of the database that we will create
$databaseuser = 'root'; // The name of a user with rights to create db (or if db already exists, then rights within that db)
$databasepass = '*******'; // Password of db user
$dbprefix = 'jos_'; // A global prefix that can be added to all LimeSurvey tables. Use this if you are sharing
// a database with other applications. Suggested prefix is 'lime_'

// File Locations
$rooturl = "83.132.168.148/limesurvey"; //The root web url for your limesurvey installation (without a trailing slash). The double quotes (" are important.

$rootdir = 'c:xampphtdocslimesurvey'; // This is the physical disk location for your limesurvey installation. Normally you don't have to touch this setting.
// If you use IIS then you MUST enter the complete rootdir e.g. : $rootDir='C:Inetpubwwwrootlimesurvey'!
// Some IIS installations also require to use forward slashes instead of backslashes, e.g. $rootDir='C:/Inetpub/wwwroot/limesurvey'!
// If you use OS/2 this must be the complete rootdir with FORWARD slashes e.g.: $rootDir='c:/limesurvey';!
// Site Setup
$sitename = 'Inquerito ANV'; // The official name of the site (appears in the Window title)

$defaultuser = 'root'; // This is the default username when LimeSurvey is installed
$defaultpass = '*******'; // This is the default password for the default user when LimeSurvey is installed

// Email Settings

$siteadminemail = ' This e-mail address is being protected from spam bots, you need JavaScript enabled to view it '; // The default email address of the site administrator
$siteadminbounce = ' This e-mail address is being protected from spam bots, you need JavaScript enabled to view it '; // The default email address used for error notification of sent messages for the site administrator (Return-Path)
$siteadminname = 'ANV'; // The name of the site administrator
_________________________________________________________________________
I still have the error that could not connect to the Database!

Can you see any error?
Many thanks and sorry for my bad english
Rui Silva
Portugal

Sorry! It's already running! Sorry My mistake and didn't run the install!
Now it's running!

Thanks for your understanding
Best Regards
Rui Silva