Upgrading but with error at Database configuration

More
1 year 5 months 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 or Create an account to join the conversation.

More
1 year 5 months 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?

Are you a student conducting a survey? If yes, tell me why you use LimeSurvey?
www.limesurvey.org/forum/development/116...y-you-use-limesurvey

Please Log in or Create an account to join the conversation.

More
1 year 5 months 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 or Create an account to join the conversation.

More
1 year 5 months 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 or Create an account to join the conversation.

More
1 year 5 months 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.

Are you a student conducting a survey? If yes, tell me why you use LimeSurvey?
www.limesurvey.org/forum/development/116...y-you-use-limesurvey

Please Log in or Create an account to join the conversation.

More
1 year 5 months 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 or Create an account to join the conversation.

More
1 year 5 months 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.

Are you a student conducting a survey? If yes, tell me why you use LimeSurvey?
www.limesurvey.org/forum/development/116...y-you-use-limesurvey

Please Log in or Create an account to join the conversation.

More
1 year 5 months 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 or Create an account to join the conversation.

More
1 year 5 months 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 or Create an account to join the conversation.

More
1 year 5 months 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?

Are you a student conducting a survey? If yes, tell me why you use LimeSurvey?
www.limesurvey.org/forum/development/116...y-you-use-limesurvey

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!