Bug 152644

Summary: [PATCH] www/mod_log_mysql: [enable auto reconnect support]
Product: Ports & Packages Reporter: Oleksii Samorukov <samm>
Component: Individual Port(s)Assignee: Philip M. Gollucci <pgollucci>
Status: Closed FIXED    
Severity: Affects Only Me CC: apache
Priority: Normal    
Version: Latest   
Hardware: Any   
OS: Any   
Attachments:
Description Flags
ap20-mod_log_mysql-1.0_1.patch none

Description Oleksii Samorukov freebsd_committer freebsd_triage 2010-11-28 15:50:09 UTC 
I am using mod_log_mysql on a busy web server and found that sometime i am gettng messages like 
"server gone away". In worst case i am also getting core dump in mysql_real_escape(), probably because 
db object is not valid anymore. After debugging I found that root reason is disconnect timeout - when
child is not active for a long time server closing connection. This small patch enable auto-reconnect 
support, so in this case conection is re-established automatically. I tested it ~4 days and found that 
messages are gone and no more core dumps in the logs. 

Changed files:
- Makefile
- distinfo

New file:
- files/patch-mod_log_mysql.c

Port maintainer (apache@FreeBSD.org) is cc'd.

Generated with FreeBSD Port Tools 0.99
Comment 1 Edwin Groothuis freebsd_committer freebsd_triage 2010-11-28 15:50:16 UTC 
Responsible Changed
From-To: freebsd-ports-bugs->apache

Over to maintainer (via the GNATS Auto Assign Tool)
Comment 2 Philip M. Gollucci freebsd_committer freebsd_triage 2010-12-07 04:15:59 UTC 
Responsible Changed
From-To: apache->pgollucci

I will take it.
Comment 3 dfilter service freebsd_committer freebsd_triage 2010-12-07 21:29:38 UTC 
pgollucci    2010-12-07 21:29:34 UTC

  FreeBSD ports repository

  Modified files:
    www/mod_log_mysql    Makefile distinfo 
  Added files:
    www/mod_log_mysql/files patch-mod_log_mysql.c 
  Log:
  - enable auto-reconnect support
  
  PR:             ports/152644
  Submitted by:   Alex Samorukov <samm@os2.kiev.ua>
  
  Revision  Changes    Path
  1.15      +2 -1      ports/www/mod_log_mysql/Makefile
  1.8       +0 -1      ports/www/mod_log_mysql/distinfo
  1.5       +16 -0     ports/www/mod_log_mysql/files/patch-mod_log_mysql.c (new)
_______________________________________________
cvs-all@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/cvs-all
To unsubscribe, send any mail to "cvs-all-unsubscribe@freebsd.org"
Comment 4 Philip M. Gollucci freebsd_committer freebsd_triage 2010-12-07 21:29:42 UTC 
State Changed
From-To: open->closed

Committed, Thanks!