Upgrading but with error at Database configuration

More
7 months 3 weeks ago #151366 by SpongyBob
SpongyBob created the topic: Upgrading but with error at Database configuration
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

Please Log in to join the conversation.

More
7 months 3 weeks ago #151370 by jelo
jelo replied the topic: Upgrading but with error at Database configuration
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?

Please Log in to join the conversation.

More
7 months 3 weeks ago #151782 by SpongyBob
SpongyBob replied the topic: Upgrading but with error at Database configuration
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?

Please Log in to join the conversation.

More
7 months 3 weeks ago #151784 by c_schmitz
c_schmitz replied the topic: Upgrading but with error at Database configuration
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

Please Log in to join the conversation.

More
7 months 3 weeks ago #151786 by jelo
jelo replied the topic: Upgrading but with error at Database configuration

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.

Please Log in to join the conversation.

More
7 months 3 weeks ago #151787 by SpongyBob
SpongyBob replied the topic: Upgrading but with error at Database configuration
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

Please Log in to join the conversation.

More
7 months 3 weeks ago #151788 by jelo
jelo replied the topic: Upgrading but with error at Database configuration
The database LimeSurvey is connecting to, it too old (5.0.77).
Perhaps wrong database server chosen during installation. Nothing we can check.

Please Log in to join the conversation.

More
7 months 3 weeks ago #151789 by c_schmitz
c_schmitz replied the topic: Upgrading but with error at Database configuration
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

Please Log in to join the conversation.

More
7 months 3 weeks ago #151792 by SpongyBob
SpongyBob replied the topic: Upgrading but with error at Database configuration
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.

Please Log in to join the conversation.

More
7 months 3 weeks ago #151793 by jelo
jelo replied the topic: Upgrading but with error at Database configuration

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?

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!