Home arrow Support arrow Forums
LimeSurvey Forums
Welcome, Guest
Please Login or Register.    Lost Password?
Re:[done] Can't connect to LimeSurvey database. (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: Re:[done] Can't connect to LimeSurvey database.
#16308
ronnie1 (User)
Fresh Lemon
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
[done] Can't connect to LimeSurvey database. 4 Months ago Karma: 0  
Hello,

I have uploaded the files but when i try to run the site as tonnetagro.comlimesurvey/index.php to install the program,

i get this message.

"Can't connect to LimeSurvey database. Reason: Access denied for user 'root'@'srv63.one.com' (using password: NO)" Is my installation missing some folders or files?

And two, in the installation manual, they talk about this folder:

/app/config/sql/dojo.sql
/app/config/sql/feedback.sql
/app/config/sql/question_library.sql


But the above folder with those files doesnot exist in the download. Can some one help me solve this problem or direct me where to find the correct download?

Otherwise your support is always appreciated

Thanks

Ronnie
 
Logged Logged  
 
Last Edit: 2008/07/21 11:57 By Mazi.
  The administrator has disabled public write access.
#16325
Mazi (Moderator)
Moderator Lime
Posts: 3237
graph
User Offline Click here to see the profile of this user
Re:Can't connect to LimeSurvey database. Reason: Acce 4 Months ago Karma: 25  
Regarding the folders: You read the Limesurvey 2 installation instructions. Limesurvey 2 is still indevelopment. You probably use version 1.71 so please check the manual for the right instructions.

Your installation error is connected to wrong database settings. According to the error message your database isn't password protected. Therefore in config.php the setting has to be "$databasepassword = '';"
Another possibility is that the user mentioned hasn't got the right to access the database. Please contact your provider and ask for database username and password.
 
Logged Logged  
 
Best regards,
Mazi
______________________
Need help? I can: set up Limesurvey for you / create your survey / implement additional features / design your template / offer premium support -> Contact.
  The administrator has disabled public write access.
#16335
ronnie1 (User)
Fresh Lemon
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Re:Can't connect to LimeSurvey database. Reason: Acce 4 Months ago Karma: 0  
After upload, what do i do next? because i searched for the installer and failed to see it. I thought that installation is like for joomla were by after upload you just click on install/index.php and then follow steps. Is this different?
 
Logged Logged  
  The administrator has disabled public write access.
#16338
Mazi (Moderator)
Moderator Lime
Posts: 3237
graph
User Offline Click here to see the profile of this user
Re:Can't connect to LimeSurvey database. Reason: Acce 4 Months ago Karma: 25  
Why not reading manual -> installation?

You have to call the installer using www.yourdomain.org/limesurveyinstallfolder/admin/install

It's all explained in thge manual!
 
Logged Logged  
 
Best regards,
Mazi
______________________
Need help? I can: set up Limesurvey for you / create your survey / implement additional features / design your template / offer premium support -> Contact.
  The administrator has disabled public write access.
#16341
ronnie1 (User)
Fresh Lemon
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Re:Can't connect to LimeSurvey database. Reason: Acce 4 Months ago Karma: 0  
I have uploaded the version 1.71 and also tried to edit file config.php but when i tried to run install, i got this message below

"Can't connect to LimeSurvey database. Reason: Access denied for user 'gicug_com '@'srv63.one.com' (using password: YES)"

Now what is the problem?

Otherwise thanks for your continnued support.

Ronnie
 
Logged Logged  
  The administrator has disabled public write access.
#16345
Mazi (Moderator)
Moderator Lime
Posts: 3237
graph
User Offline Click here to see the profile of this user
Re:Can't connect to LimeSurvey database. Reason: Acce 4 Months ago Karma: 25  
Your installation error is connected to wrong database settings. According to the error message your database isn't password protected. Therefore in config.php the setting has to be "$databasepassword = '';"
Another possibility is that the user mentioned hasn't got the right to access the database. Please contact your provider and ask for database username and password.
 
Logged Logged  
 
Best regards,
Mazi
______________________
Need help? I can: set up Limesurvey for you / create your survey / implement additional features / design your template / offer premium support -> Contact.
  The administrator has disabled public write access.
#16351
ronnie1 (User)
Fresh Lemon
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Re:Can't connect to LimeSurvey database. Reason: Acce 4 Months ago Karma: 0  
Hello,

I have tried to change the config.php and put there this code "$databasepassword = '';"

But now am getting the error below;



Parse error: syntax error, unexpected T_VARIABLE in /customers/eisuganda.com/eisuganda.com/httpd.www/survey/config.php on line 37


Otherwise thanks for your replies.

Ronnie
 
Logged Logged  
  The administrator has disabled public write access.
#16355
jcleeland (Admin)
Moderator Lime
Posts: 243
graphgraph
User Offline Click here to see the profile of this user
Re:Can't connect to LimeSurvey database. Reason: Acce 4 Months ago Karma: 7  
Hi,

You've made a typo. Try the line with the semi-colon at the very end and without the double-quotes:

$databasepassword = '';

Jason
 
Logged Logged  
  The administrator has disabled public write access.
#16376
Mazi (Moderator)
Moderator Lime
Posts: 3237
graph
User Offline Click here to see the profile of this user
Re:Can't connect to LimeSurvey database. Reason: Acce 4 Months ago Karma: 25  
Problem solved?

Of not please post the settings you set in config.php (no real passwords please).
 
Logged Logged  
 
Best regards,
Mazi
______________________
Need help? I can: set up Limesurvey for you / create your survey / implement additional features / design your template / offer premium support -> Contact.
  The administrator has disabled public write access.
#16440
ronnie1 (User)
Fresh Lemon
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Re:Can't connect to LimeSurvey database. Reason: Acce 4 Months ago Karma: 0  
Bellow is how the config.php looks like:



<?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 $
*/

/* IMPORTANT NOTICE
* With LimeSurvey v1.70+ the configuration of LimeSurvey was simplified,
* Now config.php only contains the basic required settings.
* Some optional settings are also set by default in config-defaults.php.
* If you want to change an optional parameter, DON'T change values in config-defaults.php!!!
* Just copy the parameter into your config.php-file and adjust the value!
* All settings in config.php overwrite the default values from config-defaults.php
*/


// 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 = "survey"; // The name of the database that we will create
$databaseuser = "eisuganda
"; // The name of a user with rights to create db (or if db already exists, then rights within that db)

$databasepassword = "kampala";
// 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['HTTP_HOST']}/survey"; //The root web url for your limesurvey installation (without a trailing slash).

$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:Inetpubwwwrootsurvey"!
// Some IIS installations also require to use forward slashes instead of backslashes, e.g. $rootDir="C:/Inetpub/wwwroot/survey"!
// If you use OS/2 this must be the complete rootdir with FORWARD slashes e.g.: $rootDir="c:/survey";!
// Site Setup
$sitename = "Gicug.com Survey Project"; // The official name of the site (appears in the Window title)

$defaultuser = "admin"; // This is the default username when LimeSurvey is installed
$defaultpass = "uganda"; // 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 = "Admin"; // The name of the site administrator

?>
 
Logged Logged  
  The administrator has disabled public write access.
Go to top