-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Shaun Hofer wrote: > Hi, > I get the following after a call has finished: > > ERROR[6862]:mysql_log: cdr_mysql: Unknown connection error: (2006) > MySQL server has gone away > > Does this error message only appear when asterisk makes a new connection > to mysql, because the old connection was stale (and dropped) ?
Correct. > If so, is there a way to get asterisk to stop reporting this as an error > seeing it seems to write the CDR to database just fine ? In my cdr_addon_mysql.c around line 160 there are the series of statements: case CR_SERVER_LOST: ast_log(LOG_ERROR, "cdr_mysql: Server has gone away. Attempting to reconnect.\n"); break; You can just comment out that line by putting // at the beginning of it. I guess it should really be a debug message at that stage and then an error further down: ast_log(LOG_ERROR, "cdr_mysql: Retried to connect fives times, giving up.\n"); Because it will retry 5 times and the "gone away" message is printed on each of those times but doesn't necessarily indicate any problem (i.e. stale connection). - -- Kind Regards, Matt Riddell Director _______________________________________________ http://www.venturevoip.com (Great new VoIP end to end solution) http://www.venturevoip.com/news.php (Daily Asterisk News - html) http://feeds.venturevoip.com/AsteriskNews (Daily Asterisk News - rss) -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFG1inoDQNt8rg0Kp4RArqhAJ9WfGJ9NvQwtxJn11HGi/FWMQvydwCdEtQ5 5kpz7xZ5FE8UAsii3l24mGQ= =X1h1 -----END PGP SIGNATURE----- _______________________________________________ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
