Issue with installing Limesurvey 3(following official instructions and from CLI)

More
8 months 1 week ago #178264 by ashouman
So I am trying to install Limesurvey 3, at first I tried installing it on a remote server, but then I switched to a local server to have better access.

I tried to install limesurvey using two different methods and I ran into an issue in both of them

1. Method 1: Normal installation following the official instructions at: manual.limesurvey.org/Installation_-_LimeSurvey_CE

However, when I try to run the installation script (by going to localhost/limesurvey/admin) I get the following error message

CDbConnection failed to open the DB connection: SQLSTATE[HY000] [1049] Unknown database 'limesurvey'

This happens because the DB was not created. So I created the DB myself with a root user that has all privileges.
However after that I ran into this issue

The table "{{settings_global}}" for active record class "SettingGlobal" cannot be found in the database.

So I created the table manually, yet it runs into the same issue with the following table (and so on).

Given that this is a clean installation (i.e. I am not updating from an older version), it is not clear for me why the installation script fails to create the DB or any of the tables. Isn't supposed to check for them and create a new one if it doesn't exist ? Why does it throw an exception whenever it fails to find those table ? It is a clean installation, the DB and its table are not supposed to exist.

2. Method 2: Install Limesurvey using command line interface (CLI)

at "limesurvey/application/commands" I run the following command
php console.php installfromconfig "C:\wamp64\www\limesurvey\application\config\config.php"

However, I get the following error message
Array
(
[connectionString] => mysql:host=localhost;port=3306;;
[emulatePrepare] => 1
[username] => root
[password] =>
[charset] => utf8mb4
[tablePrefix] => lime_
)
CException: Invalid access data. Check your config.php db access data in C:\wamp64\www\limesurvey\application\commands\InstallFromConfigCommand.php:177


The error message doesn't seem to say much about the origin of the error.
I noticed that the DB name is not there, however, it seems that it was replaced by the line below

$dbConnectArray = preg_replace('/dbname=([^;]*)/', '', $connectionString); (InstallFromConfigCommand.php at line 162)

I commented out but I still got the same error message.


Attached is a screenshot of my config.php

Other Information
PHP => 7.2.10
MySQL => 5.7.23
PhpMyAdmin => 4.8.3
Attachments:

Please Log in or Create an account to join the conversation.

LimeSurvey Partners
More
8 months 1 week ago #178265 by DenisChenu

ashouman wrote: CDbConnection failed to open the DB connection: SQLSTATE[HY000] [1049] Unknown database 'limesurvey'
3

It's happen because you have a config.php file.

You must remove it for 1st installation.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand .
An error happen ? Before make a new topic : remind the Debug mode .
The following user(s) said Thank You: ashouman

Please Log in or Create an account to join the conversation.

More
8 months 1 week ago #178269 by ashouman
You are absolutely right.
Thanks a lot

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!