Actions

Installation FAQ: Difference between revisions

From LimeSurvey Manual

mNo edit summary
No edit summary
(33 intermediate revisions by 4 users not shown)
Line 4: Line 4:
Contents:
Contents:


=During installation= <!--T:2-->
=Installation on your computer= <!--T:125-->


==How can I create a database and a user in mysql with command line access?== <!--T:3-->
<!--T:126-->
LimeSurvey can be installed on your computer with MAMP/XAMPP or any other system. Bear in mind that your computer is not a web server - it's not accessible via web to any other user.
 
<!--T:127-->
In order to make your survey reachable to other users via the web, you need to either:
 
<!--T:128-->
* own a server or a web space from a host provider
* or find a LimeSurvey-specialized host provider
 
<!--T:129-->
{{Alert|An installation on your computer is not done to share your survey on the internet!}}
 
=Starting installation= <!--T:2-->
 
==How can I create a database and a user in MySQL with command-line access?== <!--T:3-->


<!--T:4-->
<!--T:4-->
You have to enter the below commands in your mysql.
You have to enter the commands below in your MySQL:


<!--T:5-->
<!--T:5-->
create database '''<your_database_name>''';
*<code>create database '''<your_database_name>''';</code>


<!--T:6-->
<!--T:6-->
create user '''<your_database_username>''';
*<code>create user '''<your_database_username>''';</code>


<!--T:7-->
<!--T:7-->
create user '''<your_database_username>'''@localhost;
*<code>create user '''<your_database_username>'''@localhost;</code>


<!--T:8-->
<!--T:8-->
set password for '''<your_database_username>''' = PASSWORD(''''<your_database_password>'''');
*<code>set password for '''<your_database_username>''' = PASSWORD(''''<your_database_password>'''');</code>


<!--T:9-->
<!--T:9-->
set password for '''<your_database_username>'''@localhost = PASSWORD(''''<your_database_password>'''');
*<code>set password for '''<your_database_username>'''@localhost = PASSWORD(''''<your_database_password>'''');</code>


<!--T:10-->
<!--T:10-->
grant all on '''<your_database_name>'''.* to ''''<your_database_username>'''';
*<code>grant all on '''<your_database_name>'''.* to ''''<your_database_username>'''';</code>


<!--T:11-->
<!--T:11-->
grant all on '''<your_database_name>'''.* to ''''<your_database_username>''''@'localhost';
*<code>grant all on '''<your_database_name>'''.* to ''''<your_database_username>''''@'localhost';</code>


<!--T:12-->
<!--T:12-->
You have to replace '''<your_database_name>''', '''<your_database_username>''' and '''<your_database_password>''' in above commands with according values.
In terminal, <code>'''<your_database_name>'''</code>, <code>'''<your_database_username>'''</code>, and <code>'''<your_database_password>'''</code> have to be replaced with the according/desired values.


==What if I can't create a database through a script?== <!--T:13-->
==What if I can't create a database through a script?== <!--T:13-->


<!--T:14-->
<!--T:14-->
Normally, the script creates a new database, and then the table structure. However if your server/ISP doesn't give you admin rights to create a new database in MySQL, you will need to contact your server administrator to create the necessary database (or create it yourself). They should create a blank database for you that gives you the appropriate access rights (ie: read/write/create). Start the LimeSurvey installation as usually and it will then create the tables in the existing database.
Normally, the script creates a new database, and then the table structure. However, if your server/ISP doesn't give you admin rights to create a new database in MySQL, you will need to contact your server administrator to get the necessary database created (or create it yourself if you receive the required permissions). The newly created blank database should include the appropriate access rights (i.e.: read/write/create). Then, you should be able start the LimeSurvey installation, which will create the tables within the newly created database.
 
==What is this mbstring (Multibyte String Functions) library?== <!--T:15-->
 
<!--T:16-->
The mbstring library is a PHP library to be able to convert char sets from one language to another.  You need it if you want to run LimeSurvey. To check if it is already installed open the URL
 
<!--T:17-->
 <nowiki>http://<your_server>/<your_limesurvey_directory>/admin/install/phpinfo.php</nowiki>
 
<!--T:18-->
from the web browser. A lot of information will be shown. Search for the string 'mbstring' under the '''Configuration''' section.
 
<!--T:19-->
If you find the mbstring section then all should be well and you can continue on with your LimeSurvey installation!
 
<!--T:20-->
'''If you don't find the mbstring section''' you might have a problem on your hands.
 
<!--T:21-->
There are three possible scenarios:
*If it's your providers server: Ask your provider to activate that extension in PHP or how to activate it - if you have a good administration panel for your server you may be able to activate it yourself.
*If it's your own '''Linux''' server: You may have to re-compile PHP and include the mbstring library. Ask the Linux experts how to do that. In most Linux versions today you can install it using your Linux packet manager.
**If you are using a version of Linux that supports 'yum' (CentOS, RedHat, Fedora):
### Use the terminal (as a super user) and type: '''yum install php-mbstring'''
### Make sure to update /etc/php.ini to update and uncomment the various mbstring params
### Make sure to restart apache after installing it:  '''/etc/init.d/httpd restart'''
*If it's your own '''Windows''' server: Search for php.ini on your system, open it with an editor and search for mbstring. Most probably the line that contains that string is commented out with a semicolon. Remove the semicolon, save and restart your web server.
 
==When I am entering special chars (Chinese, Cyrillic, Greek, Arabic) into my survey, every character is shown as a question mark?== <!--T:22-->
 
<!--T:23-->
This happens if your database itself is not created to use an UTF-8 charset. This can happen when you have to create the database using a provider administration panel. You can fix this problem by executing the following SQL command on your database (using for example phpMyAdmin)
 
<!--T:24-->
ALTER DATABASE `<your_database_name>` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
 
<!--T:25-->
Replace <your_database_name> with the name of your database. '''You need to do this before installing LimeSurvey.'''


==Blank page when accessing the Install page== <!--T:26-->
==Blank page when accessing the install page== <!--T:26-->


<!--T:27-->
<!--T:27-->
The problem is not with the LimeSurvey installation but with the PHP installation.
This problem doesn't occur within the LimeSurvey installation but within the PHP installation.
*Verify you have the MySQL PHP module (php-mysql) installed.
*Verify you have the MySQL PHP module (php-mysql) installed.
*Verify your PHP install is loading the PHP.ini file your are modifying and not parsing other PHP.INI files on your system.
*Verify your PHP install is loading the PHP.ini file your are modifying and not parsing other PHP.INI files on your system.
*Verify the location and permissions of the following setting in your PHP.ini
*Verify the location and permissions of the following setting in your PHP.ini:


<!--T:28-->
<!--T:28-->
Line 91: Line 68:
<!--T:29-->
<!--T:29-->
session.save_path="/temp"</syntaxhighlight>
session.save_path="/temp"</syntaxhighlight>
*Verify your server runs a suitable PHP version (e.g. this "blank page" problem appeared with PHP v4.4 and LimeSurvey v2.00+).
*Verify that your server runs a suitable PHP version.


==Error messages because of non-existing resources== <!--T:30-->
==Error messages due to non-existing resources== <!--T:30-->


<!--T:31-->
<!--T:31-->
Sometimes files are not uploaded correctly or were broken during upload. This leads to several different error messages. Most of them refer to a file or function within a file which can't be found.
Sometimes, files are not uploaded correctly or are broken during the upload process. This leads to several different error messages. Most of them refer to a file or function within a file which can't be found.


<!--T:32-->
<!--T:32-->
'''Solution:''' Re-upload all files using the binary mode of your FTP program.
'''Solution:''' Re-upload all files using the binary mode of your FTP programme.
 
=Requirements page= <!--T:130-->
 
==What is the mbstring (Multibyte String Functions) library?== <!--T:15-->
 
<!--T:16-->
The mbstring library is a PHP library that can convert char sets from one language to another. You need it if you want to run LimeSurvey. To check if it is already installed, open the URL from a web browser:
 
<!--T:132-->
<nowiki>http://<your_server>/<your_limesurvey_directory>/admin/install/phpinfo.php</nowiki>
 
<!--T:18-->
A lot of information will be shown. Search for the string 'mbstring' in the '''Configuration''' section. If you find the mbstring section, then all should be well and you can continue with your LimeSurvey installation!
 
<!--T:20-->
'''If you don't find the mbstring section''', you might have a problem on your hands. There are three possible scenarios:
*If it's your host provider's server, ask for the activation of that extension in PHP or for further information on how you can activate it - if you have a good administration panel for your server, you may be able to activate it yourself
*If it's your own '''Linux''' server, you may have to re-compile PHP and include the mbstring library. Ask the Linux experts how to do that. However, you can install it using your Linux package manager, which is mostly available in all the Linux distributions nowadays
**If you are using a version of Linux that supports 'yum' (CentOS, RedHat, Fedora)...
***...use the terminal (as a super user) and type: '''yum install php-mbstring'''
***...make sure to update /etc/php.ini and uncomment the various mbstring params
***...make sure to restart apache after installing it: '''/etc/init.d/httpd restart'''
*If it's your own '''Windows''' server, search for php.ini on your system, open it with an editor, and search for mbstring. Most probably, the line that contains the string is commented out with a semicolon. Remove the semicolon, save and restart your web server
 
== Stuck at checking file system permissions == <!--T:131-->
If SELinux is activated (primarily on CentOS), then you might get an error that the file system permissions are not correct, even if the list of directories is empty. SELinux prevents writing even though the permissions are for example on 777 or 755. To configure SELinux correctly for your server - check out the [https://wiki.centos.org/HowTos/SELinux SELinux documentation].


=After database creation= <!--T:35-->
=After database creation= <!--T:35-->
Line 106: Line 109:


===Symptoms=== <!--T:37-->
===Symptoms=== <!--T:37-->
* LimeSurvey installed OK, and database was created, but instead of the admin page, you get an empty page
* LimeSurvey is installed correctly and the database was created, but instead of the admin page, you get an empty page
* Web surver log shows "Fatal error: Call to a member function on a non-object in /path/to/limesurvey/admin/login_check.php on line 69"
* Web server log shows ''"Fatal error: Call to a member function on a non-object in /path/to/limesurvey/admin/login_check.php on line 69"''


===Fix=== <!--T:38-->
===Fix=== <!--T:38-->


<!--T:39-->
<!--T:39-->
This is probably an incorrect setting for $rooturl or $rootdir in config.php. In particular, config.php attempts to set $rootdir correctly by calling <nowiki>dirname('''FILE''')</nowiki> and while this usually works, it can be upset when LimeSurvey is installed in a user's home or public_html directory and the home directory is mounted over NFS. Try setting $rootdir manually, and in particular, while your shell or pwd command may show a path like "/disks/hostname/home/username/public_html/limesurvey", try using "/home/username/public_html/limesurvey".
This is probably related to an incorrect setting for <code>$rooturl</code> or <code>$rootdir</code> in config.php. The file config.php attempts to set <code>$rootdir</code> correctly by calling <code><nowiki>dirname('''FILE''')</nowiki></code>. While this usually works, it can be upset when LimeSurvey is installed in a user's home or public_html directory and the home directory is mounted over NFS. To set up the <code>$rootdir</code> manually, (your shell or pwd command may show you a path like /disks/hostname/home/username/public_html/limesurvey), try using /home/username/public_html/limesurvey.


==When accessing admin page, the browser keeps running and will eventually fail to show it== <!--T:40-->
==When accessing the admin page, the browser keeps running and will eventually fail to show it== <!--T:40-->


===Symptoms=== <!--T:41-->
===Symptoms=== <!--T:41-->
* LimeSurvey installed OK and database was created. But when you access the admin page, the browser keeps running and will eventually fail to show the page.
* LimeSurvey is installed correctly and the database was created. However, when you access the admin page, the browser keeps running and will eventually fail to show the page
* When you check the web server access log, its size has become so big (in some cases, more than 2 GB).
* When you check the web server access log, its size has become quite big (in some cases, more than 2 GB)
* Inside the access log, you get this message filling the log.
* Inside the access log, you get this message filling the log:


<!--T:42-->
<!--T:42-->
Warning: fread() [function.fread]: Length parameter must be greater than 0 in /limesurvey/classes/php-gettext/streams.php on line 120
{{Alert|title=Warning|text=''fread() [function.fread]: Length parameter must be greater than 0 in /limesurvey/classes/php-gettext/streams.php on line 120.}}''


<!--T:43-->
<!--T:43-->
''Note:'' line number may be different depending on your LimeSurvey version.
{{Note|The line number may be different depending on your LimeSurvey version.}}


===Fix=== <!--T:44-->
===Fix=== <!--T:44-->


<!--T:45-->
<!--T:45-->
This may be caused by the mbstring.func_overload setting. Check the setting in your php.ini and set as the following.
This may be caused by the mbstring.func_overload setting. Change the following setting in the php.ini file:
 
<syntaxhighlight lang="php" enclose="pre">
<!--T:46-->
mbstring.func_overload = 0
mbstring.func_overload = 0
</syntaxhighlight>


<!--T:47-->
<!--T:47-->
''Note:'' This means no function overloading. See PHP manual for this setting: [http://us3.php.net/manual/en/mbstring.overload.php Function Overloading Feature]
{{Note|This means no function overloading. See the PHP manual for this setting: [http://us3.php.net/manual/en/mbstring.overload.php Function Overloading Feature].}}


==When accessing admin page, the browser reports Fatal error: Call to a member function gT() on a non-object in login_check.php on line 76== <!--T:48-->
==When accessing the admin page, the browser reports Fatal error: Call to a member function gT() on a non-object in login_check.php on line 76== <!--T:48-->


===Symptoms=== <!--T:49-->
===Symptoms=== <!--T:49-->
* LimeSurvey installed OK and database was created. But when rdirected to the admin page, the browser displayed the the listed error.
* LimeSurvey is installed correctly and the database was created. But when redirected to the admin page, the browser displayed the listed error.
* $rootdir and $rooturl are correctly set in config.php.
* <code>$rootdir</code> and <code>$rooturl</code> are correctly set in config.php.
* The disk path name for limesurvey installation directory includes one of the following characters: ()+
* The disk path name for limesurvey installation directory includes one of the following characters: '(',')' or '+'.


<!--T:50-->
<!--T:50-->
''Note:'' Other characters may also induce the same behaviour
{{Alert|title=Attention|text=Other characters may also induce the same behavior.}}


===Fix=== <!--T:51-->
===Fix=== <!--T:51-->


<!--T:52-->
<!--T:52-->
Move / rename the limesurvey installation directory so that pathname does not include either the '''(''' or ''')''' characters
Move/rename the LimeSurvey installation directory so that the path name includes non of the following characters: '(',')' or '+' characters.


=After installation= <!--T:123-->  
=After installation= <!--T:123-->  


<!--T:124-->
<!--T:124-->
For all issues happening after a successful installation please refer to the [[Troubleshooting]] page.
For all the other issues that may occur after a successful installation, please refer to the [[Troubleshooting|troubleshooting page]].


</translate>
</translate>

Revision as of 13:20, 18 October 2017

Other languages:

Contents:

Installation on your computer

LimeSurvey can be installed on your computer with MAMP/XAMPP or any other system. Bear in mind that your computer is not a web server - it's not accessible via web to any other user.

In order to make your survey reachable to other users via the web, you need to either:

  • own a server or a web space from a host provider
  • or find a LimeSurvey-specialized host provider
  An installation on your computer is not done to share your survey on the internet!


Starting installation

How can I create a database and a user in MySQL with command-line access?

You have to enter the commands below in your MySQL:

  • create database <your_database_name>;
  • create user <your_database_username>;
  • create user <your_database_username>@localhost;
  • set password for <your_database_username> = PASSWORD('<your_database_password>');
  • set password for <your_database_username>@localhost = PASSWORD('<your_database_password>');
  • grant all on <your_database_name>.* to '<your_database_username>';
  • grant all on <your_database_name>.* to '<your_database_username>'@'localhost';

In terminal, <your_database_name>, <your_database_username>, and <your_database_password> have to be replaced with the according/desired values.

What if I can't create a database through a script?

Normally, the script creates a new database, and then the table structure. However, if your server/ISP doesn't give you admin rights to create a new database in MySQL, you will need to contact your server administrator to get the necessary database created (or create it yourself if you receive the required permissions). The newly created blank database should include the appropriate access rights (i.e.: read/write/create). Then, you should be able start the LimeSurvey installation, which will create the tables within the newly created database.

Blank page when accessing the install page

This problem doesn't occur within the LimeSurvey installation but within the PHP installation.

  • Verify you have the MySQL PHP module (php-mysql) installed.
  • Verify your PHP install is loading the PHP.ini file your are modifying and not parsing other PHP.INI files on your system.
  • Verify the location and permissions of the following setting in your PHP.ini:
upload_tmp_dir="/temp"

session.save_path="/temp"
  • Verify that your server runs a suitable PHP version.

Error messages due to non-existing resources

Sometimes, files are not uploaded correctly or are broken during the upload process. This leads to several different error messages. Most of them refer to a file or function within a file which can't be found.

Solution: Re-upload all files using the binary mode of your FTP programme.

Requirements page

What is the mbstring (Multibyte String Functions) library?

The mbstring library is a PHP library that can convert char sets from one language to another. You need it if you want to run LimeSurvey. To check if it is already installed, open the URL from a web browser: 

http://<your_server>/<your_limesurvey_directory>/admin/install/phpinfo.php

A lot of information will be shown. Search for the string 'mbstring' in the Configuration section. If you find the mbstring section, then all should be well and you can continue with your LimeSurvey installation!

If you don't find the mbstring section, you might have a problem on your hands. There are three possible scenarios:

  • If it's your host provider's server, ask for the activation of that extension in PHP or for further information on how you can activate it - if you have a good administration panel for your server, you may be able to activate it yourself
  • If it's your own Linux server, you may have to re-compile PHP and include the mbstring library. Ask the Linux experts how to do that. However, you can install it using your Linux package manager, which is mostly available in all the Linux distributions nowadays
    • If you are using a version of Linux that supports 'yum' (CentOS, RedHat, Fedora)...
      • ...use the terminal (as a super user) and type: yum install php-mbstring
      • ...make sure to update /etc/php.ini and uncomment the various mbstring params
      • ...make sure to restart apache after installing it: /etc/init.d/httpd restart
  • If it's your own Windows server, search for php.ini on your system, open it with an editor, and search for mbstring. Most probably, the line that contains the string is commented out with a semicolon. Remove the semicolon, save and restart your web server

Stuck at checking file system permissions

If SELinux is activated (primarily on CentOS), then you might get an error that the file system permissions are not correct, even if the list of directories is empty. SELinux prevents writing even though the permissions are for example on 777 or 755. To configure SELinux correctly for your server - check out the SELinux documentation.

After database creation

Blank page after database creation

Symptoms

  • LimeSurvey is installed correctly and the database was created, but instead of the admin page, you get an empty page
  • Web server log shows "Fatal error: Call to a member function on a non-object in /path/to/limesurvey/admin/login_check.php on line 69"

Fix

This is probably related to an incorrect setting for $rooturl or $rootdir in config.php. The file config.php attempts to set $rootdir correctly by calling dirname('''FILE'''). While this usually works, it can be upset when LimeSurvey is installed in a user's home or public_html directory and the home directory is mounted over NFS. To set up the $rootdir manually, (your shell or pwd command may show you a path like /disks/hostname/home/username/public_html/limesurvey), try using /home/username/public_html/limesurvey.

When accessing the admin page, the browser keeps running and will eventually fail to show it

Symptoms

  • LimeSurvey is installed correctly and the database was created. However, when you access the admin page, the browser keeps running and will eventually fail to show the page
  • When you check the web server access log, its size has become quite big (in some cases, more than 2 GB)
  • Inside the access log, you get this message filling the log:
  Warning : fread() [function.fread]: Length parameter must be greater than 0 in /limesurvey/classes/php-gettext/streams.php on line 120.

The line number may be different depending on your LimeSurvey version.

Fix

This may be caused by the mbstring.func_overload setting. Change the following setting in the php.ini file: 

mbstring.func_overload = 0
This means no function overloading. See the PHP manual for this setting: Function Overloading Feature.

When accessing the admin page, the browser reports Fatal error: Call to a member function gT() on a non-object in login_check.php on line 76

Symptoms

  • LimeSurvey is installed correctly and the database was created. But when redirected to the admin page, the browser displayed the listed error.
  • $rootdir and $rooturl are correctly set in config.php.
  • The disk path name for limesurvey installation directory includes one of the following characters: '(',')' or '+'.
  Attention : Other characters may also induce the same behavior.


Fix

Move/rename the LimeSurvey installation directory so that the path name includes non of the following characters: '(',')' or '+' characters.

After installation

For all the other issues that may occur after a successful installation, please refer to the troubleshooting page.

Retrieved from "http://manual.limesurvey.org/index.php?title=Installation_FAQ&oldid=81662"