[MacPorts] #44532: Confusion regarding Mysql server went away

[MacPorts]

#44532: Confusion regarding Mysql server went away
----------------------+-----------------------
  Reporter:  jeff@…   |      Owner:  pixilla@…
      Type:  request  |     Status:  new
  Priority:  Normal   |  Milestone:
 Component:  ports    |    Version:  2.3.1
Resolution:           |   Keywords:
      Port:  mysql5   |
----------------------+-----------------------

Comment (by jeff@…):

 I'd like to first resolve this error appearing before upgrading (so that I
 don't end up with the same problem after the effort). I already seem to
 have 5.5 on the system too, thought it's not being used apparently. When I
 run phpinfo() I get the following:

     mysql


     MySQL Support       enabled

     Active Persistent Links     0

     Active Links        0

     Client API version  mysqlnd 5.0.8-dev - 20102224 - $Id:
 731e5b87ba42146a687c29995d2dfd8b4e40b325 $

     Directive   Local Value     Master Value

     mysql.allow_local_infile    On      On

     mysql.allow_persistent      On      On

     mysql.connect_timeout       60      60

     mysql.default_host  no value        no value

     mysql.default_password      no value        no value

     mysql.default_port  no value        no value

     mysql.default_socket        /opt/local/var/run/mysql5/mysqld.sock
 /opt/local/var/run/mysql5/mysqld.sock

     mysql.default_user  no value        no value

     mysql.max_links     Unlimited       Unlimited

     mysql.max_persistent        Unlimited       Unlimited

     mysql.trace_mode    Off     Off



     mysqli


     MysqlI Support      enabled

     Client API library version  mysqlnd 5.0.8-dev - 20102224 - $Id:
 731e5b87ba42146a687c29995d2dfd8b4e40b325 $

     Active Persistent Links     0

     Inactive Persistent Links   0

     Active Links        0


     Directive   Local Value     Master Value

     mysqli.allow_local_infile   On      On

     mysqli.allow_persistent     On      On

     mysqli.default_host no value        no value

     mysqli.default_port 3306    3306

     mysqli.default_pw   no value        no value

     mysqli.default_socket       /opt/local/var/run/mysql5/mysqld.sock
 /opt/local/var/run/mysql5/mysqld.sock

     mysqli.default_user no value        no value

     mysqli.max_links    Unlimited       Unlimited

     mysqli.max_persistent       Unlimited       Unlimited

     mysqli.reconnect    Off     Off



     mysqlnd


     mysqlnd     enabled

     Version     mysqlnd 5.0.8-dev - 20102224 - $Id:
 731e5b87ba42146a687c29995d2dfd8b4e40b325 $

     Compression supported

     SSL supported

     Command buffer size 4096

     Read buffer size    32768

     Read timeout        31536000

     Collecting statistics       Yes

     Collecting memory statistics        Yes

     Tracing     n/a


 This leads me to believe that I'm running mysql 5 and that it's the
 macports one.

 However, when I run mysql client and enter:

     show variables like "%version%";

 I get:

     +-------------------------+------------------------------+

     | Variable_name           | Value                        |

     +-------------------------+------------------------------+

     | innodb_version          | 1.1.8                        |

     | protocol_version        | 10                           |

     | slave_type_conversions  |                              |

     | version                 | 5.5.15                       |

     | version_comment         | MySQL Community Server (GPL) |

     | version_compile_machine | i386                         |

     | version_compile_os      | osx10.6                      |

     +-------------------------+------------------------------+



 Which seems to say 5.5 is running, instead. That said, the settings page
 (OSX 10.8.5) has MySql enabled, and when I disable it by clicking the
 button under Mysql, I no longer have access to it even from the command
 line until I enable it again.

 Also, other than the macports source directories,

     find / -name=my.cnf

 inds only two, one in /opt/local/etc/mysql5 and the other in
 /opt/local/etc/mysql55.

 I edited the one in mysql5 AND mysql55 adding:

     [mysqld]
     max_allowed_packet=100M

 and restarted apache and mysql. there is no new row appearing in phpinfo()
 with that setting, and it didn't make a difference. But I don't know how
 to verify that it's actually present. The problem for me, in general, is
 that I don't know how to verify much of anything in this case.

-- 
Ticket URL: <https://trac.macports.org/ticket/44532#comment:2>
MacPorts <http://www.macports.org/>
Ports system for OS X