Toggle navigation

LimeSurvey Image Guide

Version 2.63.1

Websoft9 LimeSurvey is a pre-configured, ready to run image for running LimeSurvey on Alibaba Cloud.

LimeSurvey is the tool to use for your online surveys.Whether you are conducting simple questionnaires with just a couple of questions or advanced assessments with conditionals and quota management, LimeSurvey has got you covered.LimeSurvey is 100% open source and will always be transparently developed.

Software Version: LimeSurvey20170305
Software directory: /data/wwwroot/default/limesurvey

Basic software environment: Click here
PHP Configuration File: /usr/local/php/etc/php.ini
Virtual host Configuration File directory: /usr/local/apache/conf/vhost
Virtual host Configuration Command: /root/oneinstack/vhost.sh

Database install directory: /usr/local/mysql
Database data directory: /data/mysql
Database Configuration File: /etc/my.cnf

After the installation of Image,please verify it

  • Login on Alibaba Cloud console,get you Internet IP Address
  • Open you Chrome or Firefox on your local PC,visit the http://Internet IP Address/
  • If verify successfully,you can enter the boot page of Websoft9 below
  • If no response from browser,please check the Security Group settings to ensure that port 80 is been allowed

This Image use MySQL for database

#default user/password:root/123456

MySQL User Guide: Click here

Step1. Create a database

1.login in MySQL:

Method 1:Use following URL to open phpMyAdmin page: http://< Public net IP >/phpMyAdmin

Method 2:Use SSH command to login in.

mysql -uroot –p                                #enter mysql console

 #default user/password:root/123456            More MySQL User Guide: Click here

 

2.create a database:

MySQL [(none)]> create database mydbname;

MySQL [(none)]> show databases;

 

3.Create a Database User and grants permissions to the User:

MySQL [(none)]> grant all privileges on mydbname.* to username@'localhost' identified by 'userpassword';

MySQL [(none)]> flush privileges;

MySQL [(none)]> exit;

before2

Step2. Add a virtual host

Use SSH Command to Add a virtual host:

[root@iZbp1i4rjdsy216yq7lgucZ ~]# cd /root/oneinstack
[root@iZbp1i4rjdsy216yq7lgucZ oneinstack]# ./vhost.sh

Step3. Install LimeSurvey

Open your domain name via browser:
1. Please select your preferred language, Click “Start installation”;

2. Click “I accept”;

3. Click “Next”;

4. Fill in your database configuraion , Click “Next”;

5. Click “Populate database”;

6. Set admin accout and site configuration, Click “Next”;

7. LimeSurvey has been installed successfully, You can now log in to LimeSurvey (using your admin account ), Click “Administration “;

8. Fill in your admin account, Click “Log in”;

9. this is the LimeSurvey admin page:

 

Use http://<domain name>/  to go to your index page.

Routine backup (archives) of the database and application setup is essential to ensure failover is smooth.you can use Manual Backup as following steps:

  1. Download the entire LimeSurvey files in you root dictionary by FTP or other tools
  2. Visit http://< Internet IP Address >/phpMyAdmin,login in to the phpMyAdmin Panel
  3. Select you database,then Export
  4. Click “go” button,then download the SQL backup file

Note:You can backup database from the backend interface Configuration->Backup entire database

Before upgrade,please always backup the files and the database of your current installation.

Minor upgrade

You can use these instructions if you are doing a minor upgrade  (for example from 2.00 to 2.01)

  • Backup your files and database (did we already mention that?)
  • Delete all the old files/directory except for
    • /application/config/config.php
    • /upload directory (NOTE: If you have any customized templates sitting under /upload/templates, make sure you refresh those with any changes from the new version. The easiest way to check for such changes is to file-compare your old template with the new version of the default template, and if you see any differences other than your customizations, a refresh is needed.)
  • Copy the new files from the new LimeSurvey package to the existing location.
  • Open the admin page in your browser, e.g. https://www.example.com/limesurvey/admin and check if a database scheme upgrade is necessary.
  • After the upgrade: Clear your browser cache and cookies!

Using ComfortUpdate

The ComfortUpdate tool is a LimeSurvey professional service to update your installation of LimeSurvey easily from your web browser, with just a few mouse clicks – instead of having to perform a manual update.

To use and test ComfortUpdate you will have to register with Limesurvey’s website to receive a free trial key. After that trial key has expired you can either buy one of our premium packages or update your installation manually.

The LimeSurvey ComfortUpdate feature is safe to use even with active surveys. It does not delete or destroy any existing data. However you should keep in mind that this is a beta feature and ensure you have backed up your database and files manually before proceeding.

  • Go to the Global Settings Icon, select the first tab, and click the button for “Updates”
  • The ComfortUpdate screen will display an update link if a new version of LimeSurvey is available. If not click “Check now” to see if a new update is available.
  • If an update is found, LimeSurvey will display a link to allow you to update. Click on this to begin updating.
  • If you have never used ComfortUpdate before or the ComfortUpdate upgrade key is not valid, you will be asked to enter an upgrade key. During the trial period use the default key for free updates.
  • LimeSurvey will now verify your installation directory to check the appropriate permissions are set to allow an update. A list of proposed changes will be displayed.
  • If there are any problems, you must correct them at this point, and then proceed to the next step.
  • The ComfortUpdate will now make a backup of your database (if you use MySQL) and save your old installation files in the /tmp directory. If you use a different database, you should backup your database manually before proceeding.

ComfortUpdate will now update your installation to the latest version, including updating the database for any new changes.

You can select the administrative language preference during login by using the dropdown list as shown below. After a successful login, the LimeSurvey interface will change to the chosen language.  The system will record this preference setting in your profile and make it the default for your next login.

You can reset easily username and password of initial super admin with only FTP access.

  1. Download ResetPasswordController.php
  2. Put this file in ./application/controllers/ directory of your limesurvey installation.
  3. Update your ./application/config/config.php file to add resetusername and resetpassword in the config array.
        'config'=>array(
        // debug: Set this to 1 if you are looking for errors. If you still get no errors after enabling this
        // then please check your error-logs - either in your hosting provider admin panel or in some /logs directory
        // on your webspace.
        // LimeSurvey developers: Set this to 2 to additionally display STRICT PHP error messages and get full access to standard templates
            'debug'=>2,
            'debugsql'=>0, // Set this to 1 to enanble sql logging, only active when debug = 2
            // Update default LimeSurvey config here
            'resetusername'=>'The new user name (login)',
            'resetpassword'=>'The new password',
        )
  4. Go to ResetPassword controller via your browser : can be example.org/index.php/ResetPassword or example.org/index.php?r=ResetPassword.If no error are shown you can log in with the new user name and the new password.

note:Remind to remove this file or the config part after reset are done.

We recommend to always use the time-out option instead of deactivating a survey. If you closed your survey accidentally it is important that you don’t change anything in the survey.

Then, and only then the following steps will work:

  1. Activate your survey again
  2. Go to the “Browse responses for this survey” menu.
  3. Click at the “Import answers from a deactivated survey table” button.
  4. Choose your source table.
  5. Click at the “Import responses” button.

Websoft9 LimeSurvey Image have installed the phpMyadmin

phpMyAdmin install directory: /data/wwwroot/default/phpMyAdmin

Linux

Following is the step for access phpMyadmin

  1. Open Chrome or Firefox on your local PC
  2. visit the http://Internet IP Address/phpMyAdmin,you can enter the login page
  3. select you language,Username:root,Password:123456
  4. Click the button “Go”

Windows

Following is the step for access phpMyadmin

  1. User Remote Desktop Connection of Window to connect to you ECS
  2. Install a Chrome or Firefox browser on you ECS
  3. Open Chrome or Firefox on your ECS
  4. visit the http://localhost or 127.0.0.1/phpMyAdmin,you can enter the login page
  5. select you language,Username:root,Password:123456
  6. Click the button “Go”

When install new extension from back-end it will not successful,may be the permissions of file and folder is not appropriate,you should change it

Web site root permissions to follow:
file 644, folder 755 ,Permissions Users and groups www
If there is a file permissions problem, execute the following three commands:

chown -R www.www /data/wwwroot/default/limesurvey
find /data/wwwroot/default/limesurvey -type d -exec chmod 755 {} \;
find /data/wwwroot/default/limesurvey -type f -exec chmod 644 {} \;

Modify the  /usr/local/php/etc/php.ini file to increase the allowed size for uploads:

; Maximum size of POST data that PHP will accept.
post_max_size = 16M
; Maximum allowed size for uploaded files.
upload_max_filesize = 16M

then,restart the apache

# service httpd restart

The PHP configuration file allows you to configure the modules enabled, the email settings or the size of the upload files. It is located at /usr/local/php/etc/php.ini.

There are some PHP settings that need to be sufficient to install.

e.g The values for PHP.ini below are suggested values only.

  • memory_limit – Minimum: 256M Recommended: 1G or better
  • upload_max_filesize – Minimum: 20M
  • post_max_size – Minimum: 20M
  • max_execution_time: At Least 120 Recommended: 300

After modifying the PHP configuration file, restart both Apache and PHP-FPM for the changes to take effect:

# service httpd restart

If you receive the message “Maximum execution time of 30 seconds exceeded”.You may also like to extend the max_execution_time for PHP and you can modify it by two methods below

Method one: edit your  /usr/local/php/etc/php.ini


; Maximum execution time of each script, in seconds
; http://php.net/max-execution-time
; Note: This directive is hardcoded to 0 for the CLI SAPI
max_execution_time = 90
; Maximum amount of time each script may spend parsing request data. It's a good
; idea to limit this time on productions servers in order to eliminate unexpectedly
; long running scripts.

Method two: edit your .htaccess:


<IfModule mod_php5.c>
php_value max_execution_time 90
</IfModule>