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

TOPIC: Moved servers. Now Database hostname is changing.

Moved servers. Now Database hostname is changing. 2 years 1 month ago #111131

  • rydesign
  • rydesign's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 1
  • Karma: 0
We just moved our Limesurvey installation to another server. We changed the database information in the config.php as follows:

'connectionString' => 'mysql:host=dac43118ent201.managed.cln;port=3306;dbname=premiga5_survey2;',

Unfortunately, we get a database error:
CDbConnection failed to open the DB connection: SQLSTATE[28000] [1045] Access denied for user 'premiga5'@'dac43118ent202.managed.cln' (using password: YES)

As you can see, somewhere along the line our host name is being changed from "...ent201" to "...ent202"

Does anyone know what may be changing this value?
Last Edit: 2 years 1 month ago by rydesign. Reason: typo
The administrator has disabled public write access.

Moved servers. Now Database hostname is changing. 2 years 1 month ago #111184

  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 1008
  • Thank you received: 135
  • Karma: 97
dac43118ent202.managed.cln is the server you are connecting from - not the one you are connecting to.
Obviously it is a permission problem of the database user who may not connect.
Best regards

Carsten Schmitz
LimeSurvey project leader
The administrator has disabled public write access.
The following user(s) said Thank You: rydesign
Moderators: ITEd
Time to create page: 0.298 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form