Home
LimeSurvey Forums
Welcome, Guest
Please Login or Register.    Lost Password?
[done] Can't connect to LimeSurvey database (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: [done] Can't connect to LimeSurvey database
#15229
twb01 (User)
Fresh Lemon
Posts: 14
graphgraph
User Offline Click here to see the profile of this user
[done] Can't connect to LimeSurvey database 3 Months, 2 Weeks ago Karma: 0  
Here's what the error returns:
Can't connect to LimeSurvey database. Reason: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Suggestions?
 
Logged Logged  
 
Last Edit: 2008/07/01 11:10 By Mazi.
  The administrator has disabled public write access.
#15230
ElMatador69 (Moderator)
LimeSurvey Team
Posts: 1538
graphgraph
User Offline Click here to see the profile of this user
Re:Install error: Can't connect to LimeSurvey databas 3 Months, 2 Weeks ago Karma: 30  
Did you follow the instructions?
docs.limesurvey.org/tiki-index.php?page=Installation

If yes, at which step to you get this message?
Normally your message is linked with NOT correct settings in config.php
 
Logged Logged  
 
Get in touch with the LimeSurvey Development Team via IRC
If our informations and answers were useful to you, please consider a donation to the LimeSurvey Project!
  The administrator has disabled public write access.
#15231
twb01 (User)
Fresh Lemon
Posts: 14
graphgraph
User Offline Click here to see the profile of this user
Re:Install error: Can't connect to LimeSurvey data 3 Months, 2 Weeks ago Karma: 0  
I get this when I try to run the install script (everything is uploaded to the server and config is done). I wonder if I should go into mysql and manually create the database.
 
Logged Logged  
  The administrator has disabled public write access.
#15251
Mazi (Moderator)
Moderator Lime
Posts: 2775
graph
User Offline Click here to see the profile of this user
Re:Install error: Can't connect to LimeSurvey data 3 Months, 2 Weeks ago Karma: 19  
twb01 wrote:
I wonder if I should go into mysql and manually create the database.
This won't help because limesurvey has to create the necassary tables, too.

Some questions/tasks:
1. Which Limesurvey version and build do you use?
2. Do you have other programms that run with the database without any problems?
3. Please post the settings you set in config.php (no real passwords please).
 
Logged Logged  
 
Beste Grüße/Best regards,
Mazi
______________________
You can support Limesurvey, too!
  The administrator has disabled public write access.
#15293
twb01 (User)
Fresh Lemon
Posts: 14
graphgraph
User Offline Click here to see the profile of this user
Re:Install error: Can't connect to LimeSurvey data 3 Months, 1 Week ago Karma: 0  
1. Using ver. 1.7
2. nothing else is using this particular database
3. My config settings -

<?php
/*
* LimeSurvey
* Copyright (C) 2007 The LimeSurvey Project Team / Carsten Schmitz
* All rights reserved.
* License: GNU/GPL License v2 or later, see LICENSE.php
* LimeSurvey is free software. This version may have been modified pursuant
* to the GNU General Public License, and as distributed it includes or is
* derivative of works licensed under the GNU General Public License or other
* free or open source software licenses.
* See COPYRIGHT.php for copyright notices and details.
*
* $Id: config-defaults.php 4334 2008-02-25 13:21:10Z c_schmitz $
*/


// 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 = "limesurvey"; // The name of the database that we will create
$databaseuser = "********"; // 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 = "lime_"; // 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['SERVER_NAME']}/limesurvey"; //The root web url for your limesurvey installation.
$relativeurl = "/limesurvey"; // the url relative to you DocumentRoot where is installed LimeSurvey. Usually same as $rooturl without http://{$_SERVER['SERVER_NAME']}. 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 = "admin"; // This is the default username when LimeSurvey is installed
$defaultpass = "password"; // This is the default password for the default user when LimeSurvey is installed

?>
 
Logged Logged  
  The administrator has disabled public write access.
#15294
c_schmitz (Admin)
Moderator Lime
Posts: 1319
graphgraph
User Online Now Click here to see the profile of this user
Re:Install error: Can't connect to LimeSurvey data 3 Months, 1 Week ago Karma: 40  
>> I wonder if I should go into mysql and manually create the database.

Mazi wasn't exactly right.
Sure you can create the database manually and let LimeSurvey install the tables.
 
Logged Logged  
 
Best regards

Carsten Schmitz
LimeSurvey Project Leader
  The administrator has disabled public write access.
#15306
Mazi (Moderator)
Moderator Lime
Posts: 2775
graph
User Offline Click here to see the profile of this user
Re:Install error: Can't connect to LimeSurvey data 3 Months, 1 Week ago Karma: 19  
Please contact your server admin and ask for databaselocation and username/password. Check the entries in config.php again.

Furthermore you can search the forum. This error has been reported before and mostly is connected to wrong settings in config.php.
 
Logged Logged  
 
Beste Grüße/Best regards,
Mazi
______________________
You can support Limesurvey, too!
  The administrator has disabled public write access.
#15380
twb01 (User)
Fresh Lemon
Posts: 14
graphgraph
User Offline Click here to see the profile of this user
Re:Install error: Can't connect to LimeSurvey data 3 Months, 1 Week ago Karma: 0  
Thanks, everyone! We have a successful install of Limesurvey. (next I need to customize some settings, including the 'for further assistance' contact email on the default page).
 
Logged Logged  
  The administrator has disabled public write access.
#15416
Mazi (Moderator)
Moderator Lime
Posts: 2775
graph
User Offline Click here to see the profile of this user
Re:Install error: Can't connect to LimeSurvey data 3 Months, 1 Week ago Karma: 19  
You're welcome! If our hints have been helpful and you enjoy LimeSurvey please consider a donation to the team. We do all this in our free time.
 
Logged Logged  
 
Beste Grüße/Best regards,
Mazi
______________________
You can support Limesurvey, too!
  The administrator has disabled public write access.
Go to top