mysql: driver_error - sr-users - kamailio.org

List overview All Threads
Download

mysql: driver_error

openser db on an external mysql...

Re: [SR-Users] dlg_manage and...

Uri Shacked

5 Feb 2013 5 Feb '13

5:29 a.m.

Hi, I am doing some testing and i have trouble understanding when does the "mysql:driver_error" counter/statistics increase.... I stopped the mysqld process on the DB server and used sqlops. the driver_error did still is on 0. I use version 3.3.2. Thanks, Uri

Attachments:

attachment.html (text/html — 1.6 KB)

Reply

Show replies by date

Daniel-Constantin Mierla

8 Feb 8 Feb

4:34 a.m.

Hello, did you get any error log message in syslog from mysql module? A quick check in the code shows that the counter is incremented on connection errors or fetching results. Cheers, Daniel On 2/5/13 11:29 AM, Uri Shacked wrote:

Hi, I am doing some testing and i have trouble understanding when does the "mysql:driver_error" counter/statistics increase.... I stopped the mysqld process on the DB server and used sqlops. the driver_error did still is on 0. I use version 3.3.2. Thanks, Uri _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- Daniel-Constantin Mierla - http://www.asipto.com http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Kamailio World Conference, April 16-17, 2013, Berlin - http://conference.kamailio.com -

Reply

Uri Shacked

10 Feb 10 Feb

5:11 a.m.

Hi, The Mysql server is not on the same machine. On the kamailio log i get the error - "[ km_dbase.c:122]: driver error on query: Can't connect to MySQL server on......" But the statistics couter does not increase. Thanks, Uri

Hello, did you get any error log message in syslog from mysql module? A quick check in the code shows that the counter is incremented on connection errors or fetching results. Cheers, Daniel

On Tue, Feb 5, 2013 at 12:29 PM, Uri Shacked <ushacked(a)gmail.com> wrote:

Hi, I am doing some testing and i have trouble understanding when does the "mysql:driver_error" counter/statistics increase.... I stopped the mysqld process on the DB server and used sqlops. the driver_error did still is on 0. I use version 3.3.2. Thanks, Uri

Reply

Daniel-Constantin Mierla

11 Feb 11 Feb

5:57 p.m.

Hello, looking in the source, the counter is increased for error codes CR_SERVER_GONE_ERROR and CR_SERVER_LOST. The message printed in the log is for CR_CONNECTION_ERROR, according to http://dev.mysql.com/doc/refman/5.0/en/error-messages-client.html Perhaps the cases to increment have to be extended. Cheers, Daniel On 2/10/13 11:11 AM, Uri Shacked wrote:

Hi, The Mysql server is not on the same machine. On the kamailio log i get the error - "[ km_dbase.c:122]: driver error on query: Can't connect to MySQL server on......" But the statistics couter does not increase. Thanks, Uri

Hello, did you get any error log message in syslog from mysql module? A quick check in the code shows that the counter is incremented on connection errors or fetching results. Cheers, Daniel

On Tue, Feb 5, 2013 at 12:29 PM, Uri Shacked <ushacked(a)gmail.com <mailto:ushacked@gmail.com>> wrote: Hi, I am doing some testing and i have trouble understanding when does the "mysql:driver_error" counter/statistics increase.... I stopped the mysqld process on the DB server and used sqlops. the driver_error did still is on 0. I use version 3.3.2. Thanks, Uri

-- Daniel-Constantin Mierla - http://www.asipto.com http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Kamailio World Conference, April 16-17, 2013, Berlin - http://conference.kamailio.com -

Reply

4351

days inactive

4357

days old

sr-users@lists.kamailio.org

Manage subscription

3 comments

2 participants

tags (0)

participants (2)

Daniel-Constantin Mierla
Uri Shacked