Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Upgrading but with error at Database configuration

  • SpongyBob
  • SpongyBob's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 1 day ago #151366 by SpongyBob
Patching from 2.01xxx to "2.64.2+170324"

Trying to run patch, all is going smoothly until I get this message: The database does not meet the minimum MySQL/MariaDB server version requirement for LimeSurvey (5.5.3).

I verified with DBA that the MySQL DB is: 5.6.29

So, after some research this appears to be due to the "MySQL client server library".

Can I verify this? How do I fix it?

Thanks
The topic has been locked.
More
7 years 1 day ago #151370 by jelo
Isn't it possible that the update routine has a bug?
How did you verified the MySQL version?
What OS and what PHP version is used?

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
  • SpongyBob
  • SpongyBob's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 7 hours ago #151782 by SpongyBob
Its a LAMP install I didn't do. I don't have access to details. I run the update from the web interface and run php to so the db details.
PHP_VERSION: 7.0.17
mysqli_get_server_info: 5.0.77-ns
mysqli_get_client_info: mysqlnd 5.0.12-dev

DBA tells me: mysqld Ver 5.6.29-... Linux on x86_64...
The survey installer error message: The database does not meet the minimum MySQL/MariaDB server version requirement for LimeSurvey (5.5.3).

So I'm stuck, ideas?
The topic has been locked.
  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
7 years 6 hours ago #151784 by c_schmitz
Apply this patch and see what existing DB version is reported by LimeSurvey:

github.com/LimeSurvey/LimeSurvey/commit/...442e737b30e823a5de04

The patch just extends the error message a bit.

Best regards

Carsten Schmitz
LimeSurvey project leader
The following user(s) said Thank You: DenisChenu
The topic has been locked.
More
7 years 6 hours ago #151786 by jelo

SpongyBob wrote: mysqli_get_server_info: 5.0.77-ns
mysqli_get_client_info: mysqlnd 5.0.12-dev
DBA tells me: mysqld Ver 5.6.29-... Linux on x86_64...


What does "DBA tells me" mean? Where exactly did you read "mysqli_get_server_info: 5.0.77-ns" ?
In the LimeSurvey installer? Or somewhere else?

5.0.77-ns and 5.6.29 cannot be valid at the same time. Question is where did you read or get the Mysqld 5.629 from? If the Database-Adminstrator told you this, that might be a human mistake and PHP is accessing a MySQL version 5.0.77. Or there is a misconfiguration and more than one database server is available.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
  • SpongyBob
  • SpongyBob's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 6 hours ago #151787 by SpongyBob
Okay, Added patch (had to add a 4th paren on the end) and got this:

The database does not meet the minimum MySQL/MariaDB server version requirement for LimeSurvey (5.5.3). Found version: 5.0.77-ns
The topic has been locked.
More
7 years 6 hours ago #151788 by jelo
The database LimeSurvey is connecting to, it too old (5.0.77).
Perhaps wrong database server chosen during installation. Nothing we can check.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
7 years 6 hours ago #151789 by c_schmitz
I think you should ask your DBA about that. That is the real MySQL version (5.0.77-ns ). Maybe you are still using an old instance.

Best regards

Carsten Schmitz
LimeSurvey project leader
The topic has been locked.
  • SpongyBob
  • SpongyBob's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 5 hours ago #151792 by SpongyBob
I have and verified the version 3 different ways, I'll just share the last one:

"And just to make doubly sure I logged onto the Database server and checked:
[root@someserver ~]# mysqld -V
mysqld Ver 5.6.29-enterprise-commercial-advanced for Linux on x86_64 (MySQL Enterprise Server - Advanced Edition (Commercial))
[root@someserver ~]# mysql -V
mysql Ver 14.14 Distrib 5.6.29, for Linux (x86_64) using EditLine wrapper"

I understand none of this matters if there's some kind of config error and I am actually seeing the wrong database on the DBA's side. The LimeSurvey clearly sees a different version as we verified. How can I know if the instance is wrong? It is the same database server as I have in connection string.

Thanks for your time, I'll keep researching and checking into the client library as a possible cause... I'll post back what I find.
The topic has been locked.
More
7 years 5 hours ago #151793 by jelo

SpongyBob wrote: How can I know if the instance is wrong? It is the same database server as I have in connection string.

Since you seem to be able to access all kind of servers via command line, wouldn't it be possible to just install a new LimeSurvey version in a different directory or on a different server and try to use the same database server. Check if that is issue-free.

Is the connectionstring containing a hostname or a IP. Is there some kind of cluster or proxy in place?
BTW: What OS is used?

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose