Welcome, Guest
Username: Password: Remember me

TOPIC: problems installing LS 2.0

problems installing LS 2.0 1 year 9 months ago #86122

  • Honame
  • Honame's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 28
  • Thank you received: 2
  • Karma: 1
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:
The administrator has disabled public write access.

Re: problems installing LS 2.0 1 year 9 months ago #86190

  • pmlmedia
  • pmlmedia's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 9
  • Thank you received: 1
  • Karma: 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 administrator has disabled public write access.
The following user(s) said Thank You: Honame

Re: problems installing LS 2.0 1 year 9 months ago #86210

  • Honame
  • Honame's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 28
  • Thank you received: 2
  • Karma: 1
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:
The administrator has disabled public write access.

Re: problems installing LS 2.0 1 year 9 months ago #86213

  • Fred
  • Fred's Avatar
  • OFFLINE
  • Gold Lime
  • Posts: 163
  • Thank you received: 5
  • Karma: 3
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?
The administrator has disabled public write access.

Re: problems installing LS 2.0 1 year 9 months ago #86216

  • Honame
  • Honame's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 28
  • Thank you received: 2
  • Karma: 1
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!
The administrator has disabled public write access.

Re: problems installing LS 2.0 1 year 9 months ago #86217

  • Fred
  • Fred's Avatar
  • OFFLINE
  • Gold Lime
  • Posts: 163
  • Thank you received: 5
  • Karma: 3
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 administrator has disabled public write access.
The following user(s) said Thank You: Honame

Re: problems installing LS 2.0 1 year 9 months ago #86219

  • Honame
  • Honame's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 28
  • Thank you received: 2
  • Karma: 1
Still no success, :( ... I made the suggested changes but keep getting the same error. Any other thoughts?
The administrator has disabled public write access.

Re: problems installing LS 2.0 1 year 9 months ago #86227

  • Honame
  • Honame's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 28
  • Thank you received: 2
  • Karma: 1
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
The administrator has disabled public write access.

Re: problems installing LS 2.0 1 year 9 months ago #86228

  • Fred
  • Fred's Avatar
  • OFFLINE
  • Gold Lime
  • Posts: 163
  • Thank you received: 5
  • Karma: 3
Glad you figured it out.
It's always something
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.110 seconds
Donation Image