- Posts: 4
- Thank you received: 0
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
- Topic Author
- Offline
- New Member
Less
More
7 years 4 weeks ago #151366
by SpongyBob
Upgrading but with error at Database configuration was created 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
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.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
7 years 4 weeks ago #151370
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on 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?
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 4
- Thank you received: 0
7 years 3 weeks ago #151782
by SpongyBob
Replied by SpongyBob on 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?
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
- Offline
- LimeSurvey GmbH Employee
Less
More
- Posts: 302
- Thank you received: 84
7 years 3 weeks ago #151784
by c_schmitz
Best regards
Carsten Schmitz
LimeSurvey project leader
Replied by c_schmitz on 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.
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.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
7 years 3 weeks ago #151786
by jelo
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
Replied by jelo on 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.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
- SpongyBob
- Topic Author
- Offline
- New Member
Less
More
- Posts: 4
- Thank you received: 0
7 years 3 weeks ago #151787
by SpongyBob
Replied by SpongyBob on 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
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.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
7 years 3 weeks ago #151788
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on 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.
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
- Offline
- LimeSurvey GmbH Employee
Less
More
- Posts: 302
- Thank you received: 84
7 years 3 weeks ago #151789
by c_schmitz
Best regards
Carsten Schmitz
LimeSurvey project leader
Replied by c_schmitz on 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
The topic has been locked.
- SpongyBob
- Topic Author
- Offline
- New Member
Less
More
- Posts: 4
- Thank you received: 0
7 years 3 weeks ago #151792
by SpongyBob
Replied by SpongyBob on 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.
"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.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
7 years 3 weeks ago #151793
by jelo
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
Replied by jelo on topic Upgrading but with error at Database configuration
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.SpongyBob wrote: How can I know if the instance is wrong? It is the same database server as I have in connection string.
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.