Lighttpd

Maybe this could be a solution...

From the MySQL API manual:
"Note that upon connection, mysql_real_connect() sets the reconnect flag (part of the MYSQL structure) to a value of 1 in versions of the API older than 5.0.3, or 0 in newer versions. A value of 1 for this flag indicates that if a statement cannot be performed because of a lost connection, to try reconnecting to the server before giving up. As of MySQL 5.0.13, you can use the MYSQL_OPT_RECONNECT option to mysql_options() to control reconnection behavior."

I have tested to do this right before mysql_real_connect() in mod_mysql_vhost.c (somewhere around row 255, 1.4.13). It seems to works for me.

my_bool reconnect = 1;

mysql_options(s->mysql, MYSQL_OPT_RECONNECT, &reconnect);

Probably there must be some code to recognize which version of the MySQL library that is in use.

-- patrik

Replying to patrik@medieteknik.se:

I have tested to do this right before mysql_real_connect() in mod_mysql_vhost.c
(somewhere around row 255, 1.4.13). It seems to works for me.

Thanks Patrik, based on your description I created a .diff. Compile tested for now, hopefully works as well as you said:

--- lighttpd-1.4.x/src/mod_mysql_vhost.c.ORIG   2007-05-02 17:50:58.000000000 +0100
+++ lighttpd-1.4.x/src/mod_mysql_vhost.c        2007-05-02 17:52:50.000000000 +0100
@@ -256,2 +256,6 @@ SERVER_FUNC(mod_mysql_vhost_set_defaults

+                       /* http://trac.lighttpd.net/trac/ticket/518 */
+                       my_bool reconnect = 1;
+                       mysql_options(s->mysql, MYSQL_OPT_RECONNECT, &reconnect);
+
                        if (!mysql_real_connect(s->mysql, FOO(hostname), FOO(myuser), FOO(mypass),

-- lists

Hi darix,

the patch works great (we talked in irc). please don't forget to commit it ;)

-- sr