Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: remote db server

remote db server 2 years 5 months ago #106467

  • rvenkat
  • rvenkat's Avatar
  • Offline
  • Premium Lime
  • Posts: 44
  • Thank you received: 1
  • Karma: 2
We tried to install Limesurvey last week with the Limesurvey application on one server and MySQL on a second (remote) server. Install failed because it was unable to make the connection to the remote server.

Then we went back to a setup that we know works, which is db and Limesurvey on the same server. We were able to install successfully.

For security reasons it would be nice to have the database on a different server, but it appears that is not possible with Limesurvey.

I found an older post on the same topic, which is consistent with my experience.

I just thought I'd share this with the community.
The administrator has disabled public write access.

remote db server 2 years 5 months ago #106475

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9305
  • Thank you received: 1330
  • Karma: 386
Hi,

It's possible with limesurvey, just set the good server name and the good user/name. And open ports on DB server.

Possible problem :
- your DB user have access only by @localhost
- your server don't hear at his public IP, but only on an internal IP (lot of hoster do like this OVH is an example).

Before say it's LimeSurvey, try with SSH:
mysql -u fooUser -p -h YOURHOST
Denis
Assistance on LimeSurvey forum and LimeSurvey core developpement are on my free time (Say thanks ?).
A bug not reported is a bug not corrected. | Please, read the documentation | La doc en français à besoin de vous
Last Edit: 2 years 5 months ago by DenisChenu. Reason: Add more information
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.211 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form