php53-mysql: default_socket should not be /tmp/mysql.sock

[cap10morgan@…]

php5-mysql should set the default_socket in the /opt/local/var/db/php5/mysql.ini file to the default mysql port location so that PHP and MySQL work out of the box together. I've attached a patch to do that.

[cap10morgan@…]

patch to add the 3 default socket settings to mysql.ini

[ryandesign (Ryan Carsten Schmidt)]

That's not a bad idea. Unfortunately the php5extension portgroup does not yet offer the capability for the port to modify its ini file. The ini file is created by the portgroup in the post-destroot phase.

Currently the php5-mysql port just prints a message telling the user to set these php.ini values, if selecting the (default) +mysqlnd variant. If using one of the other methods -- +mysql5 or +mysql4 -- setting these values does not appear to be necessary. I am hopeful that setting these values will no longer be necessary for mysqlnd either, eventually; I thought this was ​a php bug but that bug has been closed so either the bug has been fixed (we should check in php 5.3.1) or it is a different bug report or it is not considered a bug.

[scott@…]

Cc Me!

[scott@…]

Sorry, I just posted this and randomly found this ticket.

Am I wrong in that this is as simple as just putting the compile options to php5 and Mysql5 to share the same socket path for defaults? This to me, would always be better than needing to edit any config file.

[ryandesign (Ryan Carsten Schmidt)]

I do not want to force the user to edit a file. I just have not yet sufficiently investigated how to make that unnecessary.

[scott@…]

Maybe the addition of this line is all that is needed? --with-mysql-sock=/var/run/mysqld/mysqld.sock \

Though it does look like it is in there --with-mysql-sock=${prefix}/var/run/mysql5/mysqld.sock but it is in a variant section

I am sure you understand how to solve this, and knowing it is on your radar is great. If there is anything I can lookup or test, let me know.

[ryandesign (Ryan Carsten Schmidt)]

Replying to scott@…:

Maybe the addition of this line is all that is needed? --with-mysql-sock=/var/run/mysqld/mysqld.sock \

That's possible. I need to test it.

[anddam (Andrea D'Amore)]

Cc Me!

[ryandesign (Ryan Carsten Schmidt)]

Replying to scott@…:

Maybe the addition of this line is all that is needed? --with-mysql-sock=/var/run/mysqld/mysqld.sock

Turns out this does not work for mysqlnd, and ​a PHP bug was filed for this problem.

#21581 is a duplicate of this bug.

[anddam (Andrea D'Amore)]

Replying to ryandesign@…:

Turns out this does not work for mysqlnd, and ​a PHP bug was filed for this problem.

#21581 is a duplicate of this bug.

Seems the PHP bug you mentioned has been fixed, check last comment.

[nerdling (Jeremy Lavergne)]

Cc Me!