problems installing LS 2.0

More
4 years 10 months ago #86122 by Honame
Honame created the topic: problems installing LS 2.0
Hello,

I am trying to instal LS2.0 on my website hosted on hostmonster. However, when I get to the 4th step I get an error as in the attached file.

I've tried changing "localhost" for alternative host and IP, etc without success.

Any thoughts?

Thanks,

H
Attachments:

Please Log in to join the conversation.

More
4 years 10 months ago #86190 by pmlmedia
pmlmedia replied the topic: problems installing LS 2.0
Don't use a 'root' account as the user for your limeSurvey Database. Set up a new user for your limesurvey database via your website's CPANEL -> look for 'MySQL Databases' and create a specific user for your limesurvey database. You should 'grant all privileges' - hope that helps :)
The following user(s) said Thank You: Honame

Please Log in to join the conversation.

More
4 years 10 months ago #86210 by Honame
Honame replied the topic: problems installing LS 2.0
Thanks for your reply pllmedia. I did as you mentioned and got to next step (see first attached) however when I press create database I get back to step 4 with the error showed in the second attachment without really showing what is wrong.
Any thoughts? and thank you again for your help....
Attachments:

Please Log in to join the conversation.

More
4 years 10 months ago #86213 by Fred01
Fred01 replied the topic: problems installing LS 2.0
I just did a fresh install of LS 2, build 120926 and had the same problem. The installer wouldn't recognize the database server. I had to just edit the config.php file manually. This may be a bug in the latest version?

Please Log in to join the conversation.

More
4 years 10 months ago #86216 by Honame
Honame replied the topic: problems installing LS 2.0
Hi Fred, what changes did you do on the config.php file. I opened it but didn't know what to look for. Did it work for you after that? Thanks!

Please Log in to join the conversation.

More
4 years 10 months ago #86217 by Fred01
Fred01 replied the topic: problems installing LS 2.0
The data source parameters go in application\config\config.php

Here's what the section looks like

'components' => array(
'db' => array(
'connectionString' => 'mysql:host=localhost;port=3306;dbname=yourdatabasename;',
'emulatePrepare' => true,
'username' => 'dbusernamehere',
'password' => 'yourpasswordhere',
'charset' => 'utf8',
'tablePrefix' => 'lime_',
),
The following user(s) said Thank You: Honame

Please Log in to join the conversation.

More
4 years 10 months ago #86219 by Honame
Honame replied the topic: problems installing LS 2.0
Still no success, :( ... I made the suggested changes but keep getting the same error. Any other thoughts?

Please Log in to join the conversation.

More
4 years 10 months ago #86227 by Honame
Honame replied the topic: problems installing LS 2.0
Hey there!

I just got this issue solved. I did as pmlmedia suggested. I didn't get it before because I didn't assign the created user to the created database. Then I did and just worked. Thanks Fred and pmlmedia...

cheers,

H

Please Log in to join the conversation.

More
4 years 10 months ago #86228 by Fred01
Fred01 replied the topic: problems installing LS 2.0
Glad you figured it out.
It's always something

Please Log in to join the conversation.

Did you already participate in our customer survey?

Don't miss your chance for great prices.

Please click here to participate:

Start now

Start now!

Just create your account and start using Limesurvey today.

Register now