P4DTI issue job000473

TitleBugzilla integration doesn't check MySQL server version
Statussuspended
Priorityoptional
Assigned userNick Barnes
OrganizationRavenbrook
DescriptionThe P4DTI only works with particular versions of the MySQL database (later than 3.22.something, and not 3.23.29, see job000171). We only support some vesrions of MySQL (in the AG we say "3.22.19 or later but not 3.23.29"). However, we don't actually check the MySQL version at runtime. We could do something similar to our MySQLdb version checking (see job000413), i.e. check the MySQL version when we start up, and generate a suitable informative, warning, or error message.
Analysis Given a MySQLdb object, we can ask it for the server version as an int or a string:
 >>> db._server_version
 32232
 >>> db._server_info
 '3.22.32-log'
 >>> db.db.get_server_info()
 '3.22.32-log'
How foundinspection
EvidenceI just know.
Observed in1.4.0
Introduced in0.5.0
Created byNick Barnes
Created on2002-03-08 12:46:23
Last modified byNick Barnes
Last modified on2018-07-05 17:27:56
History2002-03-08 NB Created.
       2018-07-05 NB Suspended because the P4DTI is obsolete.