Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Installer did not create tables

  • jfuchs
  • jfuchs's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 7 months ago #188574 by jfuchs
Installer did not create tables was created by jfuchs
Hi,
i install a new server with limesurvey.

OS: CentOS Linux release 7.6.1810
DB: PostgresSQL 10.10
PHP: 7.3.9
Apache: 2.4.6

I Want to set config.php before starting the Installer, because I manage my stems with puppet.
When I did it so the Installer said:
Code:
throw new CDbException("LimeSurvey table settings_global not found in database");
I also see that there are no tables create in the database.

When I remove the config.php and restart the apache ic can create the database setting and everything works fine.
The config.php looks same as I have create before:
Code:
<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
/*
| 
*/
return array(
    'name' => 'uniVersa LimeSurvey',
    'components' => array(
        'db' => array(
            'connectionString' => 'pgsql:host=localhost;port=5432;user=limesurvey;password=Test123;dbname=limesurvey;',
            'emulatePrepare' => true,
            'username' => 'limesurvey',
            'password' => 'Test123',
            'charset' => 'utf8',
            'tablePrefix' => 'lime_',
        ),
        'urlManager' => array(
            'urlFormat' => 'path',
            'rules' => array(
            // You can add your own rules here
            ),
            'showScriptName' => true,
        ),
 
    ),
        // For security issue : it's better to set runtimePath out of web access
        // Directory must be readable and writable by the webuser
        // 'runtimePath'=>'/var/limesurvey/runtime/'
        // Use the following config variable to set modified optional settings copied from config-defaults.php
    'config'=>array(
        'session' => array (
            'cookieParams' => array(
                'secure' => true, // use SSL for cookies
                'httponly' => true // Cookies may not be used by other protocols - experimental
            ),
        ),
        'debug'=>2,
        'debugsql'=>1, // Set this to 1 to enanble sql logging, only active when debug = 2
    )
);
/* End of file config.php */
/* Location: ./application/config/config.php */
 

Have anyone some idea how i can add the config.php at startup and the installer create the tables without any problems.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 7 months ago #188576 by DenisChenu
Replied by DenisChenu on topic Installer did not create tables

jfuchs wrote: Have anyone some idea how i can add the config.php at startup and the installer create the tables without any problems.

This need to be developped …

We are happy to have pull request (in develop) for this.

Aletranative : manual.limesurvey.org/Installation_using...line_interface_(CLI)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The following user(s) said Thank You: jfuchs
The topic has been locked.
  • jfuchs
  • jfuchs's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 7 months ago #188577 by jfuchs
Replied by jfuchs on topic Installer did not create tables
Thank you for the fast response.
Than I will do that with the cli-tool.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose