Welcome, Guest
Username: Password: Remember me

TOPIC: Can't connect to LimeSurvey database. Reason: The server requested authenticatio

Can't connect to LimeSurvey database. Reason: The server requested authenticatio 2 years 3 months ago #77515

  • yotamv
  • yotamv's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 3
  • Karma: 0
Hello all,
While trying to connect to a local MySql all works fine.
While trying to install/connect to a remote MySql (seperate machine) I get the following error message:

Can't connect to LimeSurvey database. Reason: The server requested authentication method umknown to the client

Can someone help me with this issue?
Thanks
The administrator has disabled public write access.

Re: Can't connect to LimeSurvey database. Reason: The server requested authenticatio 2 years 3 months ago #77549

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5300
  • Thank you received: 291
  • Karma: 247
1. Which Limesurvey version do you use?

2. Which database do you try to connect to?

3. Please post the DB settings from config.php (no passwords, please)

4. Please switch on debug mode by adding the following line to your config.php file:
$debug = '1';

Are there any additional errors reported on top of the page?

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re: Can't connect to LimeSurvey database. Reason: The server requested authenticatio 2 years 3 months ago #77572

  • yotamv
  • yotamv's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 3
  • Karma: 0
Hello Mazi, thanks for your reply.
1. I have downloaded limesurvey last week. The version is:
limesurvey192plus-build120311

2. I have 2 MySql servers.
A. local MySql - version: mysql-5.5.21.0, OS: Windows Server 2003 (32bit)
B. remote MySql - version: MYSQL-5.5.20-1, OS: Redhat 2.6 64bit

MySql A is on my dev machine, and I was the one who installed it. MySql B
is on another machine and someone else did the installation.

3. $databaselocation = '10.100.5.175';
$databasename = 'IN_limesurvey';
$databaseuser = 'limesurveyuser';
$databasepass = 'XXXXXXX';
$dbprefix = 'lime_';

4. done - No other errors but this:

Can't connect to LimeSurvey database. Reason: The server requested authentication method umknown to the client

Maybe its related to the 64bit OS and machine?

Thanks!
The administrator has disabled public write access.

Aw: Re: Can't connect to LimeSurvey database. Reason: The server requested authenticatio 2 years 3 months ago #77787

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5300
  • Thank you received: 291
  • Karma: 247
Did you change the database type? I think the DB user will also differ on the systems.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re: Aw: Re: Can't connect to LimeSurvey database. Reason: The server requested authenticatio 2 years 3 months ago #77873

  • yotamv
  • yotamv's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 3
  • Karma: 0
databasetype is 'mysql' for both.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.176 seconds
Donation Image