MySQL 5.1 is not supported by installer script checks

[GoogleCodeExporter]

What steps will reproduce the problem?
1. svn checkout trunk
2. visit /smt2/admin/sys/install.php in browser

What is the expected output?
The installation procedure accepting my "at least version 5" MySQL version.

What do you see instead?
Checking MySQL version: Error: Your server has MySQL 5.1.41 installed, but at 
least version 5 is required to handle this system.

What version of the product are you using? On what operating system?
Latest trunk checkout as of just recently. 

Original issue reported on code.google.com by fredrik....@gmail.com on 3 May 2011 at 9:03

[GoogleCodeExporter]

Here is the fix:

Index: functions.php
===================================================================
--- functions.php       (revision 74)
+++ functions.php       (working copy)
@@ -54,7 +54,7 @@
 {
   switch (strtolower($type)) {
     case 'mysql':
-      $ver = mysql_get_server_info();
+      $ver = mysql_get_client_info();
       break;
     case 'php':
       $ver = phpversion();

Original comment by fredrik....@gmail.com on 3 May 2011 at 9:09

[GoogleCodeExporter]

In fact, the file to update should be install-check.php (line 12).
Just for curiosity: after patching functions.php with your working copy, did 
smt2 work?

Original comment by luis.lei...@gmail.com on 3 May 2011 at 9:36

• Changed state: Accepted

[GoogleCodeExporter]

Yep. I had to track down another unrelated issue as well (the gateway.php 
script was stalling without any error displayed or logged - turned out to be a 
networking issue where curl was timing out), but currently smt2 is running fine 
and the tracking and viewing of the tracked data seems to work flawlessly. 
Soooo useful! :)

Original comment by fredrik....@gmail.com on 3 May 2011 at 10:33

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Ah.. Now I see what we are doing, and the fault in my patch above (checking the 
client is _not_ a solution... :P) Should it be:

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
$ver = mysql_get_server_info($link);

...maybe?

My MySQL database is on another host... 

Original comment by fredrik....@gmail.com on 3 May 2011 at 10:37

[GoogleCodeExporter]

Indeed, I added a call to db_connect() when checking the MySQL server info...
Please confirm that it works.

Original comment by luis.lei...@gmail.com on 4 May 2011 at 7:48

• Changed state: Fixed

[GoogleCodeExporter]

Issue 36 has been merged into this issue.

Original comment by luis.lei...@gmail.com on 27 Sep 2011 at 6:05