RE: [Asterisk-Users] cdr_mysql
If you are running RH install the mysql-devel rpm. If running debian do a apt-get install mysql-devel That should have everything you need to compile any mysql based code. Erik -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Kim C. CallisSent: Friday, July 18, 2003 4:30 PMTo: [EMAIL PROTECTED]Subject: [Asterisk-Users] cdr_mysql Considering that I had a failure with compiling the latest version of asterisk because of cdr_mysql, I am going to assume that I need to have a copy of the mysql headers on the system in order to compile cdr_mysql.so. Does that sound correct? Kim C. Callis
RE: [Asterisk-Users] cdr_mysql
I'm not running the latest CVS release but found a couple of days ago that CDR's were not being inserted into my MySQL tables, I restarted Asterisk and it worked fine again ... > -Original Message- > From: Tais M. Hansen [mailto:[EMAIL PROTECTED] > Sent: 18 August 2003 18:09 > To: [EMAIL PROTECTED] > Subject: [Asterisk-Users] cdr_mysql > > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi, > > Is cdr_mysql broken in latest CVS? It builds and loads fine > but it doesn't > insert cdrs in the database and there's no debug output at all. > > - -- > Regards, > Tais M. Hansen > ComX Networks > Tel: +45-70257474 > Fax: +45-70257374 > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.2.2 (GNU/Linux) > > iD8DBQE/QPoZ2TEAILET3McRAsEyAKCSZFgFSNvweA9Lh1BW1FJFwTwJNACdFNN3 > tFLJlAxupabP17gRrVL0VJA= > =3k4Y > -END PGP SIGNATURE- > > ___ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > * DISCLAIMER * This message and any attachment are confidential and may be privileged or otherwise protected from disclosure and may include proprietary information. If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system. If you are not the intended recipient you must not copy this message or attachment or disclose the contents to any other person ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql
On Monday 18 August 2003 11:08 am, Tais M. Hansen wrote: > Is cdr_mysql broken in latest CVS? It builds and loads fine but it > doesn't insert cdrs in the database and there's no debug output at > all. No, it should be just fine (works for me!). Turn on debugging output and post what you get. -Tilghman ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 18 August 2003 18:19, Tilghman Lesher wrote: > On Monday 18 August 2003 11:08 am, Tais M. Hansen wrote: > > Is cdr_mysql broken in latest CVS? It builds and loads fine but it > > doesn't insert cdrs in the database and there's no debug output at > > all. > No, it should be just fine (works for me!). Turn on debugging output > and post what you get. There's nothing cdr_mysql related debug output. $ asterisk -vgcdf (loads of output, mostly pri) *CLI> load cdr_mysql.so Loaded /usr/lib/asterisk/modules/cdr_mysql.so => (MySQL CDR Backend) ... That's it. - -- Regards, Tais M. Hansen ComX Networks Tel: +45-70257474 Fax: +45-70257374 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/QQAT2TEAILET3McRAinLAJ9dZiIzQ2bo3btaCuBTuO80btwI6wCeKK7D GyNgQch0t+LKnpHFRpqGCCk= =6nl2 -END PGP SIGNATURE- ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 18 August 2003 18:19, Low, Adam wrote: > I'm not running the latest CVS release but found a couple of days ago that > CDR's were not being inserted into my MySQL tables, I restarted Asterisk > and it worked fine again ... That's not an option. CDR's needs to be 101% reliable in our environment. :( - -- Regards, Tais M. Hansen ComX Networks Tel: +45-70257474 Fax: +45-70257374 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/QQCt2TEAILET3McRArOlAKCVh8duKI4lNlWcQHunpl0RhcqTdACcDqS/ AwNqlpAW+Yua/alCeLfMN0U= =UVNG -END PGP SIGNATURE- ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql
On Monday 18 August 2003 11:34 am, Tais M. Hansen wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Monday 18 August 2003 18:19, Tilghman Lesher wrote: > > On Monday 18 August 2003 11:08 am, Tais M. Hansen wrote: > > > Is cdr_mysql broken in latest CVS? It builds and loads fine but > > > it doesn't insert cdrs in the database and there's no debug > > > output at all. > > > > No, it should be just fine (works for me!). Turn on debugging > > output and post what you get. > > There's nothing cdr_mysql related debug output. > > $ asterisk -vgcdf Turn on debugging in /etc/asterisk/logger.conf -Tilghman ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] cdr_mysql
Did you actually turn on debug output in /etc/asterisk/logger.conf? If not you won't see any debug output anywhere. Also, what does your cdr_mysql.conf look like? Does it have a [global] just before the configuration statements? Compare it to the (updated) cdr_mysql.conf.sample that you got when yuou did your CVS update... Thorsten -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tais M. Hansen Sent: Monday, August 18, 2003 12:34 To: [EMAIL PROTECTED] -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 18 August 2003 18:19, Tilghman Lesher wrote: > On Monday 18 August 2003 11:08 am, Tais M. Hansen wrote: > > Is cdr_mysql broken in latest CVS? It builds and loads fine but it > > doesn't insert cdrs in the database and there's no debug output at > > all. > No, it should be just fine (works for me!). Turn on debugging output > and post what you get. There's nothing cdr_mysql related debug output. $ asterisk -vgcdf (loads of output, mostly pri) *CLI> load cdr_mysql.so Loaded /usr/lib/asterisk/modules/cdr_mysql.so => (MySQL CDR Backend) ... That's it. - -- Regards, Tais M. Hansen ComX Networks Tel: +45-70257474 Fax: +45-70257374 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/QQAT2TEAILET3McRAinLAJ9dZiIzQ2bo3btaCuBTuO80btwI6wCeKK7D GyNgQch0t+LKnpHFRpqGCCk= =6nl2 -END PGP SIGNATURE- ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 18 August 2003 18:58, Thorsten Lockert wrote: > Did you actually turn on debug output in /etc/asterisk/logger.conf? If not > you won't see any debug output anywhere. Ahh... Found it. I let Asterisk put the debug output in a seperate file a while ago. I completely forgot. > Also, what does your cdr_mysql.conf look like? Does it have a [global] > just before the configuration statements? Compare it to the (updated) > cdr_mysql.conf.sample that you got when yuou did your CVS update... It's as it should be I suppose. I'm getting a "Successfully connected to MySQL database." But it still doesn't insert CDRs. - -- Regards, Tais M. Hansen ComX Networks Tel: +45-70257474 Fax: +45-70257374 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/QQu/2TEAILET3McRAvybAJ9DKHIlJJAgqSefMn3XbUF1H/bSAQCggzEk fTN6sWKCpGwCCD9ykqVDdNE= =vB3O -END PGP SIGNATURE- ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 18 August 2003 18:55, Tilghman Lesher wrote: > > There's nothing cdr_mysql related debug output. > > $ asterisk -vgcdf > Turn on debugging in /etc/asterisk/logger.conf Yes. Forgot debug was put into a different file. Sorry. Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 284 (load_module): cdr_mysql: got hostname of localhost Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 285 (load_module): cdr_mysql: got port of 3306 Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 287 (load_module): cdr_mysql: got sock file of /var/run/mysql/mysql.sock Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 288 (load_module): cdr_mysql: got user of asteriskcdr Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 289 (load_module): cdr_mysql: got dbname of asterisk Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 290 (load_module): cdr_mysql: got password of j501MNGfRUQo8sLg Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 298 (load_module): Successfully connected to MySQL database. That's what I found. I've attached a log of a call from init to hangup. Note that I removed pri dchannel debug and hid phone and ipnumbers. - -- Regards, Tais M. Hansen ComX Networks Tel: +45-70257474 Fax: +45-70257374 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/QQ3e2TEAILET3McRAgpKAJ90VNuxjtCZOVugUXqjG9PCOXaTygCfTWw3 tpp9PQJdJDRk6Vm9ZdagzAw= =obWn -END PGP SIGNATURE- Aug 18 19:25:23 DEBUG[360460]: File chan_oh323.c, Line 2176 (init_h323_connection): In init_h323_connection... Aug 18 19:25:23 DEBUG[360460]: File chan_oh323.c, Line 2215 (init_h323_connection): Created new call structure 0 (2436 bytes). Aug 18 19:25:23 DEBUG[360460]: File chan_oh323.c, Line 1560 (copy_call_details): --- CALL DETAILS --- Aug 18 19:25:23 DEBUG[360460]: File chan_oh323.c, Line 1561 (copy_call_details): call_token = ip$x.x.x.x:1178/7454 Aug 18 19:25:23 DEBUG[360460]: File chan_oh323.c, Line 1562 (copy_call_details): call_source_alias = , [x.x.x.x] Aug 18 19:25:23 DEBUG[360460]: File chan_oh323.c, Line 1563 (copy_call_details): call_dest_alias = ip$y.y.y.y:1720 Aug 18 19:25:23 DEBUG[360460]: File chan_oh323.c, Line 1564 (copy_call_details): call_source_e164 = Aug 18 19:25:23 DEBUG[360460]: File chan_oh323.c, Line 1565 (copy_call_details): call_dest_e164 = Aug 18 19:25:23 DEBUG[360460]: File chan_oh323.c, Line 1391 (ast_oh323_new): Context is cxnet-in, extension is . Aug 18 19:25:23 DEBUG[360460]: File chan_oh323.c, Line 1394 (ast_oh323_new): Caller ID is . Aug 18 19:25:23 DEBUG[393230]: File pbx.c, Line 1128 (pbx_extension_helper): Launching 'SetVar' Aug 18 19:25:23 DEBUG[393230]: File pbx.c, Line 1128 (pbx_extension_helper): Launching 'SetVar' Aug 18 19:25:23 DEBUG[393230]: File pbx.c, Line 1128 (pbx_extension_helper): Launching 'Goto' Aug 18 19:25:23 DEBUG[393230]: File pbx.c, Line 1128 (pbx_extension_helper): Launching 'Goto' Aug 18 19:25:23 DEBUG[393230]: File pbx.c, Line 1128 (pbx_extension_helper): Launching 'Goto' Aug 18 19:25:23 DEBUG[393230]: File pbx.c, Line 1128 (pbx_extension_helper): Launching 'Macro' Aug 18 19:25:23 DEBUG[393230]: File pbx.c, Line 1128 (pbx_extension_helper): Launching 'Dial' Aug 18 19:25:23 DEBUG[393230]: File app_dial.c, Line 381 (dial_exec): SIMPLE DIAL (NO URL) Aug 18 19:25:23 DEBUG[393230]: File chan_zap.c, Line 5229 (zt_request): Using channel 1 Aug 18 19:25:23 DEBUG[147466]: File asterisk.c, Line 328 (urg_handler): Urgent handler Aug 18 19:25:23 DEBUG[393230]: File chan_oh323.c, Line 566 (oh323_indicate): H323:7454: Indicating condition 3. Aug 18 19:25:23 DEBUG[360460]: File chan_oh323.c, Line 2231 (init_h323_connection): Channel created and attached. Aug 18 19:25:23 DEBUG[376845]: File chan_oh323.c, Line 1899 (setup_h323_connection): In setup_h323_connection... Aug 18 19:25:23 DEBUG[376845]: File chan_oh323.c, Line 1905 (setup_h323_connection): PLAYER. Aug 18 19:25:23 DEBUG[376845]: File chan_oh323.c, Line 1946 (setup_h323_connection): Request to open an existing channel 0 with no established direction. Aug 18 19:25:23 DEBUG[376845]: File chan_oh323.c, Line 1560 (copy_call_details): --- CALL DETAILS --- Aug 18 19:25:23 DEBUG[376845]: File chan_oh323.c, Line 1561 (copy_call_details): call_token = ip$x.x.x.x:1178/7454 Aug 18 19:25:23 DEBUG[376845]: File chan_oh323.c, Line 1562 (copy_call_details): call_source_alias = , [x.x.x.x] Aug 18 19:25:23 DEBUG[376845]: File chan_oh323.c, Line 1563 (copy_call_details): call_dest_alias = ip$y.y.y.y:1720 Aug 18 19:25:23 DEBUG[376845]: File chan_oh323.c, Line 1564 (copy_call_details): call_source_e164 = Aug 18 19:25:23 DEBUG[376845]: File chan_oh323.c, Line 1565 (copy_call_details): call_dest_e164 = Aug 18 19:25:24 DEBUG[81926]: File chan_zap.c, Line 937 (zt_enable_ec): No echocancellation requested Aug 18 19:25:24 DEBUG[393230]: File chan_oh323.c, Line 566 (oh
Re: [Asterisk-Users] cdr_mysql
On Monday 18 August 2003 12:24 pm, Tais M. Hansen wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Monday 18 August 2003 18:58, Thorsten Lockert wrote: > > Did you actually turn on debug output in > > /etc/asterisk/logger.conf? If not you won't see any debug output > > anywhere. > > Ahh... Found it. I let Asterisk put the debug output in a seperate > file a while ago. I completely forgot. > > > Also, what does your cdr_mysql.conf look like? Does it have a > > [global] just before the configuration statements? Compare it to > > the (updated) cdr_mysql.conf.sample that you got when yuou did > > your CVS update... > > It's as it should be I suppose. I'm getting a "Successfully > connected to MySQL database." But it still doesn't insert CDRs. Please post your debug output (it would actually be better if the debug were intermingled with verbose messages, warnings, and errors, as these are really just different levels of the same gist of messages; debug is just one step more verbose). -Tilghman ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql
On Monday 18 August 2003 12:33 pm, Tais M. Hansen wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Monday 18 August 2003 18:55, Tilghman Lesher wrote: > > > There's nothing cdr_mysql related debug output. > > > $ asterisk -vgcdf > > > > Turn on debugging in /etc/asterisk/logger.conf > > Yes. Forgot debug was put into a different file. Sorry. > > > Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 284 > (load_module): cdr_mysql: got hostname of localhost > Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 285 > (load_module): cdr_mysql: got port of 3306 > Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 287 > (load_module): cdr_mysql: got sock file of > /var/run/mysql/mysql.sock > Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 288 > (load_module): cdr_mysql: got user of asteriskcdr > Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 289 > (load_module): cdr_mysql: got dbname of asterisk > Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 290 > (load_module): cdr_mysql: got password of j501MNGfRUQo8sLg > Aug 18 19:13:39 DEBUG[16384]: File cdr_mysql.c, Line 298 > (load_module): Successfully connected to MySQL database. > > > That's what I found. I've attached a log of a call from init to > hangup. Note that I removed pri dchannel debug and hid phone and > ipnumbers. Looks like mysql_log() is not actually getting called. Try a pure Zap bridged call or an IAX2 call (both of which I've tested) and see if it still doesn't work for you. Are you getting a log from cdr_csv in the log file (i.e. is CDR logging working at all)? -Tilghman ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 18 August 2003 19:47, Tilghman Lesher wrote: > > That's what I found. I've attached a log of a call from init to > > hangup. Note that I removed pri dchannel debug and hid phone and > > ipnumbers. > Looks like mysql_log() is not actually getting called. Try a pure > Zap bridged call or an IAX2 call (both of which I've tested) and see > if it still doesn't work for you. Are you getting a log from cdr_csv > in the log file (i.e. is CDR logging working at all)? Hmm... A zap bridged call created a CDR record. And a zap -> oh323 call also inserts a CDR. Strange. What could cause oh323 initiated calls suddenly not generate CDRs? I'm currently not using cdr_csv's. - -- Regards, Tais M. Hansen ComX Networks Tel: +45-70257474 Fax: +45-70257374 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/QRcQ2TEAILET3McRAv59AJ9ok8iR5+dYWzUZdGJJDBDhbKJKmgCgoqSY YYDF5k/nuhfw7/LskM9FMl0= =jgWD -END PGP SIGNATURE- ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql
Tais M. Hansen wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 18 August 2003 19:47, Tilghman Lesher wrote: That's what I found. I've attached a log of a call from init to hangup. Note that I removed pri dchannel debug and hid phone and ipnumbers. Looks like mysql_log() is not actually getting called. Try a pure Zap bridged call or an IAX2 call (both of which I've tested) and see if it still doesn't work for you. Are you getting a log from cdr_csv in the log file (i.e. is CDR logging working at all)? Hmm... A zap bridged call created a CDR record. And a zap -> oh323 call also inserts a CDR. Strange. What could cause oh323 initiated calls suddenly not generate CDRs? The CDRs are generated by Asterisk. It is not something that is controlled by the channel driver. I'm currently not using cdr_csv's. I do use cdr_csv without problems. Never used the mysql module. Michael. - -- Regards, Tais M. Hansen ComX Networks Tel: +45-70257474 Fax: +45-70257374 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/QRcQ2TEAILET3McRAv59AJ9ok8iR5+dYWzUZdGJJDBDhbKJKmgCgoqSY YYDF5k/nuhfw7/LskM9FMl0= =jgWD -END PGP SIGNATURE- ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql
you can also try setting AMAflag=billing in oh323.conf if it helps. Rgds Manoj K Gupta - Original Message - From: "Tais M. Hansen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 18, 2003 11:42 PM Subject: Re: [Asterisk-Users] cdr_mysql -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 18 August 2003 19:47, Tilghman Lesher wrote: > > That's what I found. I've attached a log of a call from init to > > hangup. Note that I removed pri dchannel debug and hid phone and > > ipnumbers. > Looks like mysql_log() is not actually getting called. Try a pure > Zap bridged call or an IAX2 call (both of which I've tested) and see > if it still doesn't work for you. Are you getting a log from cdr_csv > in the log file (i.e. is CDR logging working at all)? Hmm... A zap bridged call created a CDR record. And a zap -> oh323 call also inserts a CDR. Strange. What could cause oh323 initiated calls suddenly not generate CDRs? I'm currently not using cdr_csv's. - -- Regards, Tais M. Hansen ComX Networks Tel: +45-70257474 Fax: +45-70257374 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/QRcQ2TEAILET3McRAv59AJ9ok8iR5+dYWzUZdGJJDBDhbKJKmgCgoqSY YYDF5k/nuhfw7/LskM9FMl0= =jgWD -END PGP SIGNATURE- ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 21 August 2003 07:02, Manoj K Gupta wrote: > you can also try setting AMAflag=billing in oh323.conf if it helps. Already tried that. Didn't make a difference. I'll test again with the latest oh323 (0.5.5). - -- Regards, Tais M. Hansen ComX Networks Tel: +45-70257474 Fax: +45-70257374 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/RdwD2TEAILET3McRAnuhAKChXRMQE6Z+Gc4WDjv734JrIIHGLwCfQqeU 4BqTSpgKHlAbFZ/XVKNgWIY= =deYU -END PGP SIGNATURE- ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 19 August 2003 19:21, Michael Manousos wrote: > >>Looks like mysql_log() is not actually getting called. Try a pure > >>Zap bridged call or an IAX2 call (both of which I've tested) and see > >>if it still doesn't work for you. Are you getting a log from cdr_csv > >>in the log file (i.e. is CDR logging working at all)? > > Hmm... A zap bridged call created a CDR record. And a zap -> oh323 call > > also inserts a CDR. Strange. What could cause oh323 initiated calls > > suddenly not generate CDRs? > The CDRs are generated by Asterisk. It is not something that > is controlled by the channel driver. Well, whatever was causing this seems to be gone with latest asterisk cvs and oh323 0.5.5. Thanks all. - -- Regards, Tais M. Hansen ComX Networks Tel: +45-70257474 Fax: +45-70257374 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/Rg6z2TEAILET3McRAqv/AJoC9lkKfPy1z/jAuwFPRT6IKbCjogCfSt0W lrCvxLvDj6fYiHZ4PUqWS5o= =P6LH -END PGP SIGNATURE- ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql
On Tue, Jul 05, 2005 at 09:24:13AM +, Sahil Gupta wrote: > Hi, > Something seamless has become rather painful lately: > > A search on google says to use an older release, done that, no help.. any > ideas guys? Tell us something about what you try to build: * asterisk version/cvs date * linux distribution * mysql version: the versions whose include files are in /usr/include/mysql * versions of any other programs in /usr/src -- Tzafrir Cohen | [EMAIL PROTECTED] | VIM is http://tzafrir.org.il | | a Mutt's [EMAIL PROTECTED] | | best ICQ# 16849755 | | friend ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR_MYSQL
How about http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html-chunk/asterisk-DB.html ? jg -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql uncompress
I recommend installing the same version of mysql and mysql-devel and then recompiling the cdr_mysql.c regards Martin On 7 Aug 2003, Johanna Kangas wrote: > Hey, > Have i done something wrong or is there something wrong with latest CVS > and cdr_mysql, cause after checking out latest CVS today, I got warning: > > [cdr_mysql.so]WARNING[1074424544]: File loader.c, Line 226 > (ast_load_resource): /usr/lib/asterisk/modules/cdr_mysql.so: undefined > symbol: uncompress > WARNING[1074424544]: File loader.c, Line 345 (load_modules): Loading > module cdr_mysql.so failed! > > ...And Asterisk won't start. > > Help needed! > > -Johanna > > > ___ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql question: accountcode
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 08 September 2003 11:10, Scott Stingel wrote: > Anyone familiar with the asterisk sources know where I can make a change to > keep this from happening? ie: to allow more characters to be stored here. > I could not see where this is limited in the source code (pbx.c). Line 67 in include/asterisk/cdr.h - -- Regards, Tais M. Hansen ComX Networks Tel: +45-70257474 Fax: +45-70257374 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/XF6N2TEAILET3McRAhztAJwPip5Sb0Xv9QzZe9uzk9XoEBoXGgCcCRjK uHBForE5bJUUVgSPrzRwfS0= =C90c -END PGP SIGNATURE- ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] cdr_mysql question: accountcode
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Tais M. Hansen > Sent: Monday, September 08, 2003 11:49 AM > To: [EMAIL PROTECTED] > Subject: Re: [Asterisk-Users] cdr_mysql question: accountcode > > > On Monday 08 September 2003 11:10, Scott Stingel wrote: > > Anyone familiar with the asterisk sources know where I can > make a change to > > keep this from happening? ie: to allow more characters to > be stored here. > > I could not see where this is limited in the source code (pbx.c). > > Line 67 in include/asterisk/cdr.h > > - -- > Regards, > Tais M. Hansen > ComX Networks > Tel: +45-70257474 > Fax: +45-70257374 of course - would seem obvious! (as I smack myself in the head) Thanks Scott M. Stingel Emerging Voice Technology Inc. Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> URL:www.evtmedia.com <http://www.evtmedia.com> ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql: cannot connect
On Sunday 14 September 2003 20:36, [EMAIL PROTECTED] wrote: > I don't know if I have something screwed up with my MYSQL > installation/Asterisk install or a bad configuration. I have > imported the tables into a MYSQL database residing on localhost. I > have check permissions on the user as well as the password and I have > the same error comin up. I have succesfully connected to the > database remotely and with MYPHPAdmin with the same setting below is > a copy of my cdr_mysql.conf > > [global] > hostname=192.168.2.9 > dbname=asteriskcdr > user=asteriskcdr > password= > port=3306 > sock=/tmp/mysql.sock > > > The error I am getting is: > ERROR[1209214400]: File cdr_mysql.c, Line 71 (mysql_log): cdr_mysql: > cannot connect to database server localhost. Call will not be > logged. Uh, are you sure this is your configuration? It says it's trying to connect to localhost, but you have a non-localhost IP in the hostname field. Try changing that to the word "localhost". Also try from the command line: mysql -uasteriskcdr -h 192.168.2.9 -p asteriskcdr and see if it connects (or denies you). Also, check to see if /tmp/mysql.sock is the connecting sock file and not /var/lib/mysql/run/mysql.sock (which is the case on some distros). > I am also getting this message though it might be unrelated: > WARNING[1142106560]: File chan_sip.c, Line 435 (retrans_pkt): Maximum > retries exceeded on call [EMAIL PROTECTED] > for seqno 102 (Request) Nope, unrelated. -Tilghman ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] cdr_mysql custom fields ?
On Friday 01 May 2009 01:26:25 Kev Szaszvari wrote: > I am using the cdr_mysql addon – I have set userfield = 1 and if i set a > Variable “Userfield” it gets to the database. Everything there is working > as expected. > > My Query is... If i set a custom Variable EG > > exten => s,n,Set(CDR(mycustomvar)=12345) > > and create a column in my table called “mycustomvar” it does not update > the field. > > I am not sure if this is the intended functionality for this function, But > is there any way at all to have custom variables updating in the MySQL > database as we want to add some custom fields that get updated with the > CDR. > > We are running Asterisk 1.4.21.1 That behavior is a new feature starting in the recently released 1.6.1.0. It is not available at all in 1.4, unless you use the cdr_adaptive_odbc backport. -- Tilghman ___ -- 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
RE: [asterisk-users] Cdr_mysql compile question
Nevermind, this was a dumb question :( Thanks, David Ruggles CCNA MCSE (NT) CNA A+ Network EngineerSafe Data, Inc. (910) 285-7200 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Ruggles Sent: Friday, March 09, 2007 1:56 PM To: 'Asterisk Users Mailing List - Non-Commercial Discussion' Subject: [asterisk-users] Cdr_mysql compile question I'm reading voip-info.org http://www.voip-info.org/wiki-Asterisk+cdr+mysql Sorry if this is a dumb question, but: It says I need mysql and mysql-devel to compile cdr_mysql, but I don't want mysql on my asterisk box I want to connect to a remote mysql server. Can I use mysqlclient and mysqlclient-devel? Thanks, David Ruggles CCNA MCSE (NT) CNA A+ Network EngineerSafe Data, Inc. (910) 285-7200 [EMAIL PROTECTED] ___ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] cdr_mysql stopped working
On Mon, Dec 20, 2010 at 5:02 PM, Bryant Zimmerman wrote: > I did an upgrade to the SVN trunk on the 12/9 and when I looked in my mysql > table for CDR's today there are no entries since the update. > I have rebuilt and re-installed and re-started asterisk still no CDR's > flowing to mysql. I did not change any configs. I checked to make sure that > the cdr_mysql option was selected under the make menu options. The module > shows it is there when I do a modules show. I don't get any errors saying it > can't write to the table. My voicemail settings are pulling from the same > server. > > Any ideas on what I could try to fix this or how I could test to see what is > causing it? Rebooting is a good clue. You could check your firewall settings. Firewalls can stop mysql connections. Try manually connecting to the mysql server from the asterisk system and see what happens. -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] cdr_mysql stopped working
You can also enter into the CLI in order to see if you can spot any error regarding cdr_mysql, or 'duplicated value for key...' after hangin up a call. There might be a corruption in the 'cdr' table (I've seen this sometimes). You could try a 'repair table cdr' from the MySQL CLI. Note: Sometimes, corrumptions in myISAM tables not always produce the data to be unaccessible, but just make it impossible to insert new records. David Backeberg wrote: On Mon, Dec 20, 2010 at 5:02 PM, Bryant Zimmerman wrote: I did an upgrade to the SVN trunk on the 12/9 and when I looked in my mysql table for CDR's today there are no entries since the update. I have rebuilt and re-installed and re-started asterisk still no CDR's flowing to mysql. I did not change any configs. I checked to make sure that the cdr_mysql option was selected under the make menu options. The module shows it is there when I do a modules show. I don't get any errors saying it can't write to the table. My voicemail settings are pulling from the same server. Any ideas on what I could try to fix this or how I could test to see what is causing it? Rebooting is a good clue. You could check your firewall settings. Firewalls can stop mysql connections. Try manually connecting to the mysql server from the asterisk system and see what happens. -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- Jose P. Espinal http://www.eSlackware.com IRC: Khratos @ #asterisk / -doc / -bugs -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] cdr_mysql stopped working
David I got the svn trunk again and did a make clean and rebuilt the install and all started to work again. My guess is that it looks like the mysql client code was out of sync with the server version. All is good again. Bryant From: "David Backeberg" Sent: Thursday, December 23, 2010 10:59 AM To: "Asterisk Users Mailing List - Non-Commercial Discussion" Subject: Re: [asterisk-users] cdr_mysql stopped working On Mon, Dec 20, 2010 at 5:02 PM, Bryant Zimmerman wrote: > I did an upgrade to the SVN trunk on the 12/9 and when I looked in my mysql > table for CDR's today there are no entries since the update. > I have rebuilt and re-installed and re-started asterisk still no CDR's > flowing to mysql. I did not change any configs. I checked to make sure that > the cdr_mysql option was selected under the make menu options. The module > shows it is there when I do a modules show. I don't get any errors saying it > can't write to the table. My voicemail settings are pulling from the same > server. > > Any ideas on what I could try to fix this or how I could test to see what is > causing it? Rebooting is a good clue. You could check your firewall settings. Firewalls can stop mysql connections. Try manually connecting to the mysql server from the asterisk system and see what happens. -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] cdr_mysql stopped working
Jose Thanks for your response. It appears that the issue was that the mysql client drivers were updated when I installed some mono updates and I had to recompile asterisk the system was actually writing completely blank entries for every call. Once asterisk was compiled using the newer mysql client lib things started to work again. The moral of the story is if you update anything on the box that may change mysql at all you should do a complete make clean and recompile. Bryant From: "Jose P. Espinal" Sent: Thursday, December 23, 2010 12:19 PM To: "Asterisk Users Mailing List - Non-Commercial Discussion" Subject: Re: [asterisk-users] cdr_mysql stopped working You can also enter into the CLI in order to see if you can spot any error regarding cdr_mysql, or 'duplicated value for key...' after hangin up a call. There might be a corruption in the 'cdr' table (I've seen this sometimes). You could try a 'repair table cdr' from the MySQL CLI. Note: Sometimes, corrumptions in myISAM tables not always produce the data to be unaccessible, but just make it impossible to insert new records. David Backeberg wrote: > On Mon, Dec 20, 2010 at 5:02 PM, Bryant Zimmerman wrote: >> I did an upgrade to the SVN trunk on the 12/9 and when I looked in my mysql >> table for CDR's today there are no entries since the update. >> I have rebuilt and re-installed and re-started asterisk still no CDR's >> flowing to mysql. I did not change any configs. I checked to make sure that >> the cdr_mysql option was selected under the make menu options. The module >> shows it is there when I do a modules show. I don't get any errors saying it >> can't write to the table. My voicemail settings are pulling from the same >> server. >> >> Any ideas on what I could try to fix this or how I could test to see what is >> causing it? > > Rebooting is a good clue. You could check your firewall settings. > Firewalls can stop mysql connections. > > Try manually connecting to the mysql server from the asterisk system > and see what happens. > > -- > _ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > -- Jose P. Espinal http://www.eSlackware.com IRC: Khratos @ #asterisk / -doc / -bugs -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] cdr_mysql Voicemail or VoiceMail2?
Can I use Asterisk with MySQL Voicemail or do I need VoiceMail2? Uriel ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] cdr_mysql Voicemail or VoiceMail2?
You need voicemail2. John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Uriel Carrasquilla Sent: Sunday, October 26, 2003 2:06 PM To: [EMAIL PROTECTED] Subject: RE: [Asterisk-Users] cdr_mysql Voicemail or VoiceMail2? Can I use Asterisk with MySQL Voicemail or do I need VoiceMail2? Uriel ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.516 / Virus Database: 313 - Release Date: 9/1/2003 ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR_MYSQL 1.4 Database Structure
On Wednesday 30 December 2009 10:52:48 Robert Broyles wrote: > So I'm noticing from the docs/ on Asterisk Addons 1.4.10 that the > database structure for cdr_mysql is: > > CREATE TABLE cdr ( > calldate datetime NOT NULL default '-00-00 00:00:00', > clid varchar(80) NOT NULL default '', > src varchar(80) NOT NULL default '', > dst varchar(80) NOT NULL default '', > dcontext varchar(80) NOT NULL default '', > channel varchar(80) NOT NULL default '', > dstchannel varchar(80) NOT NULL default '', > lastapp varchar(80) NOT NULL default '', > lastdata varchar(80) NOT NULL default '', > duration int(11) NOT NULL default '0', > billsec int(11) NOT NULL default '0', > disposition varchar(45) NOT NULL default '', > amaflags int(11) NOT NULL default '0', > accountcode varchar(20) NOT NULL default '', > uniqueid varchar(32) NOT NULL default '', > userfield varchar(255) NOT NULL default '' > ); > > Just curious if anyone has successfully patched cdr_addon_mysql to use > accept the latest cdr fields from 1.4 ... namely: 'start', 'answer', 'end'? > Seems logical that the cdr_mysql addon should be updated to reflect the > current cdr. And for backwards compatibility it can still accept > 'calldate'. The MySQL driver contains all of the same information, albeit in a slightly different form. Calldate is the same as start, calldate plus duration minus billsec is the same as answer, and calldate plus duration is the same as end. Generally, we do not make design changes in the middle of a release cycle, especially given that such changes would break a great many existing systems. Given that there's no security reason why we would need to make such a change, it is out of the question. While you're certainly welcome to make such a change on your own systems, such a change will not be committed in the 1.4 addons. In the 1.6 series and forward, we've changed the mysql driver to scan the table metadata and adapt the queries to the table structure. Therefore, you could, in fact, use 'start', 'answer', and 'end' in the 1.6 series, as you suggested, above, and it would work perfectly well. On the other hand, if you kept the legacy structure, that would work, too. -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com & www.asterisk.org ___ -- 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
Re: [asterisk-users] CDR_MYSQL 1.4 Database Structure
Tilghman Lesher wrote: > On Wednesday 30 December 2009 10:52:48 Robert Broyles wrote: > >> So I'm noticing from the docs/ on Asterisk Addons 1.4.10 that the >> database structure for cdr_mysql is: >> >> CREATE TABLE cdr ( >> calldate datetime NOT NULL default '-00-00 00:00:00', >> clid varchar(80) NOT NULL default '', >> src varchar(80) NOT NULL default '', >> dst varchar(80) NOT NULL default '', >> dcontext varchar(80) NOT NULL default '', >> channel varchar(80) NOT NULL default '', >> dstchannel varchar(80) NOT NULL default '', >> lastapp varchar(80) NOT NULL default '', >> lastdata varchar(80) NOT NULL default '', >> duration int(11) NOT NULL default '0', >> billsec int(11) NOT NULL default '0', >> disposition varchar(45) NOT NULL default '', >> amaflags int(11) NOT NULL default '0', >> accountcode varchar(20) NOT NULL default '', >> uniqueid varchar(32) NOT NULL default '', >> userfield varchar(255) NOT NULL default '' >> ); >> >> Just curious if anyone has successfully patched cdr_addon_mysql to use >> accept the latest cdr fields from 1.4 ... namely: 'start', 'answer', 'end'? >> Seems logical that the cdr_mysql addon should be updated to reflect the >> current cdr. And for backwards compatibility it can still accept >> 'calldate'. >> > > The MySQL driver contains all of the same information, albeit in a slightly > different form. Calldate is the same as start, calldate plus duration minus > billsec is the same as answer, and calldate plus duration is the same as end. > > Generally, we do not make design changes in the middle of a release cycle, > especially given that such changes would break a great many existing systems. > Given that there's no security reason why we would need to make such a change, > it is out of the question. While you're certainly welcome to make such a > change on your own systems, such a change will not be committed in the 1.4 > addons. > > In the 1.6 series and forward, we've changed the mysql driver to scan the > table metadata and adapt the queries to the table structure. Therefore, you > could, in fact, use 'start', 'answer', and 'end' in the 1.6 series, as you > suggested, above, and it would work perfectly well. On the other hand, if you > kept the legacy structure, that would work, too. > > Thanks for the reply. So my next question is could I take the cdr_mysql from 1.6's addons and use it in 1.4? ___ -- 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
Re: [asterisk-users] CDR_MYSQL 1.4 Database Structure
Wednesday, December 30, 2009, 6:48:37 PM, Robert wrote: > Tilghman Lesher wrote: >> On Wednesday 30 December 2009 10:52:48 Robert Broyles wrote: >>> >>> Just curious if anyone has successfully patched cdr_addon_mysql to use >>> accept the latest cdr fields from 1.4 ... namely: 'start', 'answer', 'end'? >>> Seems logical that the cdr_mysql addon should be updated to reflect the >>> current cdr. And for backwards compatibility it can still accept >>> 'calldate'. >>> >> >> The MySQL driver contains all of the same information, albeit in a slightly >> different form. Calldate is the same as start, calldate plus duration minus >> billsec is the same as answer, and calldate plus duration is the same as end. >> >> Generally, we do not make design changes in the middle of a release cycle, >> especially given that such changes would break a great many existing systems. >> Given that there's no security reason why we would need to make such a >> change, >> it is out of the question. While you're certainly welcome to make such a >> change on your own systems, such a change will not be committed in the 1.4 >> addons. >> >> In the 1.6 series and forward, we've changed the mysql driver to scan the >> table metadata and adapt the queries to the table structure. Therefore, you >> could, in fact, use 'start', 'answer', and 'end' in the 1.6 series, as you >> suggested, above, and it would work perfectly well. On the other hand, if >> you >> kept the legacy structure, that would work, too. >> >> > Thanks for the reply. > So my next question is could I take the cdr_mysql from 1.6's addons and > use it in 1.4? I don't think so. But you can define more columns, and an insert trigger which calculates the missing fields as defined in Tilghman's reply. -- Best regards, Gergomailto:csi...@gmail.com ___ -- 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
Re: [asterisk-users] CDR_MYSQL 1.4 Database Structure
On Wednesday 30 December 2009 11:48:37 Robert Broyles wrote: > So my next question is could I take the cdr_mysql from 1.6's addons and > use it in 1.4? No. The APIs are significantly different enough that a backport would require a good amount of modification. However, there is a backport of cdr_adaptive_odbc to 1.4: http://svnview.digium.com/community/tilghman/branches/1.4/ -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com & www.asterisk.org ___ -- 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
RE: [Asterisk-Users] cdr_mysql - would index slow down?
Roger- Assuming that you have a fast machine, and a reasonably fast disk, I don't anticipate a problem at this call level. At one customer site, I have 5 systems, each running 120 lines with very high call volume - no problem with MySQL keeping up. This customer uses asterisk for IVR, not VoIP, and so has a higher rate of call setups than a typical VoIP setup would. I tend to clear out my DB's way before they reach 1,000,000 records however. You might consider doing what I do, and that's have a Perl process on each machine that transfers the DB records off to a database server on a very regular basis. I do it because of multiple machines - you might do it to maintain large numbers of records on-line. Cheers Scott Stingel Scott M. Stingel President, Emerging Voice Technology, Inc. Palo Alto California & London England www.evtmedia.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Roger Schreiter Sent: Wednesday, May 12, 2004 7:13 AM To: [EMAIL PROTECTED] Subject: [Asterisk-Users] cdr_mysql - would index slow down? Hi, I intend to change the cdr_mysql-field "uniqueid", which seems not to be used so far, to an (not unique) indexed field and use it later for my own hints and infos. I don't have very much traffic so far, and I wonder, if there will appear problems when asterisk is under high load (100 simultanious calls) and the log table contains 1.000.000 log lines. This would mean, that asterisk would have to wait some time when writing a log line, because mysql has to update the index. Can anyone with some more experience predict, whether there will be problems cause to the indexed field? Your opinion is welcome! Roger. ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] cdr_mysql - would index slow down?
I have mySQL running on several servers where it is driving web-applications. One one site I track logins, ip-addresses and UAs, in addition to file downloads. The site is logging about 1,000,000 hits/month and the DB doesn't slow it down one but. mySQL has very good performance, as long as you plan your tables and indices well. On that note, you probably wouldn't re-use existing fields (whether they're used or not) but rather add new fields if needed. In order to keep insert-performance at peak, you may want to run table optimzation regularly. If size does become an issue, consider archiving old data -- you probably won't NEED 1,000,000 call records at your fingertips. Reality check: 100 simultaneous calls, 5 min average call, 6 days x 8 hours is less than 60K records per week, so 1M records would keep over four months of data. Even in that scenario, you only have about one insert every three seconds, and that shouldn't even cause a blip in your system load. Keep in mind that when asterisk is processing 100 simultaneous calls, you'll need a pretty beefy machine anyway, and if you're running a lot of queries against your CDR data, you may need to move the DB to a separate server. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Roger Schreiter Sent: Wednesday, May 12, 2004 9:13 AM To: [EMAIL PROTECTED] Subject: [Asterisk-Users] cdr_mysql - would index slow down? Hi, I intend to change the cdr_mysql-field "uniqueid", which seems not to be used so far, to an (not unique) indexed field and use it later for my own hints and infos. I don't have very much traffic so far, and I wonder, if there will appear problems when asterisk is under high load (100 simultanious calls) and the log table contains 1.000.000 log lines. This would mean, that asterisk would have to wait some time when writing a log line, because mysql has to update the index. Can anyone with some more experience predict, whether there will be problems cause to the indexed field? Your opinion is welcome! Roger. ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql - would index slow down?
Jay Milk schrieb: ... note, you probably wouldn't re-use existing fields (whether they're used or not) but rather add new fields if needed. In order to keep ... I assume, I may not add nor change fields to the "cdr" table, which cdr_mysql uses. Maybe I should consider patching the source code in order to modify the "cdr" table. Roger. ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] cdr_mysql - would index slow down?
Not having looked at the source code, I would assume that you can safely ADD fields. However, I would not reuse existing fields or remove any -- in that case, you may expect to make changes to the source. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Roger Schreiter Sent: Wednesday, May 12, 2004 3:10 PM To: [EMAIL PROTECTED] Subject: Re: [Asterisk-Users] cdr_mysql - would index slow down? Jay Milk schrieb: ... > note, you probably wouldn't re-use existing fields (whether they're > used or not) but rather add new fields if needed. In order to keep ... I assume, I may not add nor change fields to the "cdr" table, which cdr_mysql uses. Maybe I should consider patching the source code in order to modify the "cdr" table. Roger. ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db
Dear Kib, As I believe the Realtime options concerning the mysql database can only be used with the Asterisk CVS-HEAD version it's still not implemented on Asterisk v 1.0.* . Thx MAG Kib Eki wrote: Hi, I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql db. The problem is that no records are written to the db. Why? I can import the csv-file to the db. so i assume the db is setup correct. Is there any chance to get debug from cdr_mysql to find his problem? This is my cdr_mysql.conf file: [global] hostname=localhost dbname=cdr password=passw0rd user=root ;port=3306 ;sock=/tmp/mysql.sock userfield=1 Thanks and Regards ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- Thx MAG ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db
Kib Eki a écrit : Hi, I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql db. The problem is that no records are written to the db. Why? I can import the csv-file to the db. so i assume the db is setup correct. Is there any chance to get debug from cdr_mysql to find his problem? This is my cdr_mysql.conf file: [global] hostname=localhost dbname=cdr password=passw0rd user=root ;port=3306 ;sock=/tmp/mysql.sock userfield=1 Thanks and Regards ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users Asterisk don't use directly mysql database for cdr, astersisk use odbc and odbc connect to mysql. So you must configure odbc corectly wiyt libmyodbc (on debian) the config file are here: /etc/odbcinst.ini : [MySQL] Description = MySQL driver Driver = /usr/lib/odbc/libmyodbc.so Setup = /usr/lib/odbc/libodbcmyS.so CPTimeout = CPReuse = FileUsage = 1 /etc/odbc.ini : [MySQL-asterisk] Description = MySQL Asterisk Database Driver = MySQL Socket = /var/run/mysqld/mysqld.sock Server = @ipofMysqlddatabase (not domain name) User = Password = Database = asterisk Option = 3 #Port = /etc/asterisk/cdr_odbc.conf : [global] dsn=MySQL-asterisk username=database_username password=database_password loguniqueid=yes ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db
Try to put the IP of you CDR server instead of 'localhost', that's work for me. Regards. - Original Message - From: "Kib Eki" <[EMAIL PROTECTED]> To: "Asterisk Users Mailing List - Non-Commercial Discussion" Sent: Wednesday, July 27, 2005 9:44 AM Subject: [Asterisk-Users] cdr_mysql does not write to mysql db > Hi, > > I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql db. > > The problem is that no records are written to the db. Why? > > I can import the csv-file to the db. so i assume the db is setup correct. > > Is there any chance to get debug from cdr_mysql to find his problem? > > This is my cdr_mysql.conf file: > [global] > hostname=localhost > dbname=cdr > password=passw0rd > user=root > ;port=3306 > ;sock=/tmp/mysql.sock > userfield=1 > > Thanks and Regards > > ___ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: >http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db
sylvain garcia wrote: Kib Eki a écrit : Asterisk don't use directly mysql database for cdr, astersisk use odbc and odbc connect to mysql. So you must configure odbc corectly wiyt libmyodbc (on debian) the config file are here: Wrong. Asterisk can and does connect to MySQL directly. (Where the hell are these people getting this wrong info?) -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db
using localhost in you mysql conf should work, make sure you linux box and the loopback interface up and has a a entry in your /etc/ hosts for localhost and that your firewall (if you have one setup on your localbox) allows traffic from 172.0.0.1 to 172.0.0.1 On Jul 27, 2005, at 6:17 AM, Dpto. Técnico. wrote: Try to put the IP of you CDR server instead of 'localhost', that's work for me. Regards. - Original Message - From: "Kib Eki" <[EMAIL PROTECTED]> To: "Asterisk Users Mailing List - Non-Commercial Discussion" Sent: Wednesday, July 27, 2005 9:44 AM Subject: [Asterisk-Users] cdr_mysql does not write to mysql db Hi, I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql db. The problem is that no records are written to the db. Why? I can import the csv-file to the db. so i assume the db is setup correct. Is there any chance to get debug from cdr_mysql to find his problem? This is my cdr_mysql.conf file: [global] hostname=localhost dbname=cdr password=passw0rd user=root ;port=3306 ;sock=/tmp/mysql.sock userfield=1 Thanks and Regards ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db
Mohamed A. Gombolaty wrote: Dear Kib, As I believe the Realtime options concerning the mysql database can only be used with the Asterisk CVS-HEAD version it's still not implemented on Asterisk v 1.0.* . Thx MAG Wrong. He's not using RealTime. No where in his original post did he mention realtime. -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db
Kib Eki wrote: Hi, I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql db. The problem is that no records are written to the db. Why? Do you have the module installed? Is the module loaded? What happens when you type "cdr mysql status" on asterisk command line? You should see something like this: cytrex*CLI> cdr mysql status Connected to [EMAIL PROTECTED], port 3306 using table cdr for 7 hours, 41 minutes, 21 seconds. Wrote 70 records since last restart. If you get "no such command" then that means the module isn't loaded. If you are using "localhost" then you need to uncomment the sock and make sure it's path is correct. Don't listen to those other guys. The first two were both wrong. -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db
On Wed, 2005-07-27 at 09:44 +0200, Kib Eki wrote: > Hi, > > I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql > db. > > The problem is that no records are written to the db. Why? > > I can import the csv-file to the db. so i assume the db is setup correct. > > Is there any chance to get debug from cdr_mysql to find his problem? > > This is my cdr_mysql.conf file: > [global] > hostname=localhost > dbname=cdr > password=passw0rd > user=root > ;port=3306 > ;sock=/tmp/mysql.sock > userfield=1 > > Thanks and Regards > I do not know if this has changed but I remember that when I first installed the mysql cdr addon the database had to be named "asteriskcdrdb" and the table where everything is written is "cdr". Apart from that make sure that the module is loaded when you start Asterisk. Here is my cdr_mysql.conf: [global] hostname=localhost dbname=asteriskcdrdb table=cdr password=dbpassword user=dbuser ;port=3306 sock=/var/lib/mysql/mysql.sock userfield=1 I can see you are missing the "table=" from your config. -- Telecomunicaciones Abiertas de Mexico Carlos Chavez Director de Tecnologia +52-55-91169161 Ext. 2001 signature.asc Description: This is a digitally signed message part ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db
Neal Lawson wrote: using localhost in you mysql conf should work, make sure you linux box and the loopback interface up and has a a entry in your /etc/ hosts for localhost and that your firewall (if you have one setup on your localbox) allows traffic from 172.0.0.1 to 172.0.0.1 Don't you mean 127.0.0.1 ? Plus, in the MySQL API documentation the use of "localhost" indicates to the API that you want to use a socket connection. If you don't want to use sockets (which you should on local machine), the you need to change to an IP to use TCP. -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db
Matthew Boehm a écrit : > sylvain garcia wrote: > >> Kib Eki a écrit : >> Asterisk don't use directly mysql database for cdr, astersisk use >> odbc and odbc connect to mysql. >> >> So you must configure odbc corectly wiyt libmyodbc (on debian) >> the config file are here: > > > Wrong. Asterisk can and does connect to MySQL directly. > > (Where the hell are these people getting this wrong info?) > > -Matthew > Sorry Mea Culpa ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db - SOLVED
i reinstalled the addons and the module works fine now. Thanks to all!! Neal Lawson wrote: using localhost in you mysql conf should work, make sure you linux box and the loopback interface up and has a a entry in your /etc/ hosts for localhost and that your firewall (if you have one setup on your localbox) allows traffic from 172.0.0.1 to 172.0.0.1 On Jul 27, 2005, at 6:17 AM, Dpto. Técnico. wrote: Try to put the IP of you CDR server instead of 'localhost', that's work for me. Regards. - Original Message - From: "Kib Eki" <[EMAIL PROTECTED]> To: "Asterisk Users Mailing List - Non-Commercial Discussion" Sent: Wednesday, July 27, 2005 9:44 AM Subject: [Asterisk-Users] cdr_mysql does not write to mysql db Hi, I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql db. The problem is that no records are written to the db. Why? I can import the csv-file to the db. so i assume the db is setup correct. Is there any chance to get debug from cdr_mysql to find his problem? This is my cdr_mysql.conf file: [global] hostname=localhost dbname=cdr password=passw0rd user=root ;port=3306 ;sock=/tmp/mysql.sock userfield=1 Thanks and Regards ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] cdr_mysql: Cannot connect to database server - SSL error: SSL_CTX_set_default_verify_paths failed
On Monday 08 June 2020 at 12:15:56, Markus wrote: > Hi list! > > I'm getting this error frequently: > > ERROR[25193][C-0004f387]: cdr_mysql.c:203 mysql_log: Cannot connect to > database server localhost: (2026) SSL connection error: > SSL_CTX_set_default_verify_paths failed Hmmm... talking to localhost over SSL... seems a bit computationally wasteful. > Right now, as a workaround, I reload Asterisk via cron once an hour, and > after the reload everything is fine again _for a while_. Still, over the > course of a month I lose about 12% of my CDRs this way. I guess I could > reload more often but would prefer a real fix, not a workaround. Anyone > got an idea? > Database is a Galera cluster: galera-3-25.3.19-2.el7.x86_64 Use the ODBC connector and talk to MariaDB over a Unix socket instead of TCP: https://wiki.asterisk.org/wiki/display/AST/Getting+Asterisk+Connected+to+MySQL+via+ODBC Antony. -- "There is no reason for any individual to have a computer in their home." - Ken Olsen, President of Digital Equipment Corporation (DEC, later consumed by Compaq, later merged with HP) Please reply to the list; please *don't* CC me. -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] cdr_mysql: Cannot connect to database server - SSL error: SSL_CTX_set_default_verify_paths failed
On Mon, 8 Jun 2020 at 05:18, Markus wrote: > Hi list! > > I'm getting this error frequently: > > ERROR[25193][C-0004f387]: cdr_mysql.c:203 mysql_log: Cannot connect to > database server localhost: (2026) SSL connection error: > SSL_CTX_set_default_verify_paths failed > "SSL_CTX_set_default_verify_paths() specifies that the default locations from which CA certificates are loaded should be used." ( https://www.openssl.org/docs/man1.1.0/man3/SSL_CTX_set_default_verify_paths.html ) "The SSL_CTX_set_default_verify_paths failed error occurs if paths to any of the certificate files are invalid (either missing or have incorrect permissions)." ( https://stackoverflow.com/questions/27031318/what-does-this-error-mean-in-mariadb-ssl-error-2026-hy000-ssl-connection-e/45083610 ) Sounds to me like your CApath / CAfile being used by MySQL doesn't exist, and so it's unable to verify the certificate. You can try some of the answers in that stack overflow thread... or just don't use SSL to connect to a local MySQL instance. Unless you've done some weird configuration, only the same user as one of the processes, or root, has the ability to eavesdrop; and both could eavesdrop by attaching to the process (i.e. with a debugger) even with SSL enabled. -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] cdr_mysql: Cannot connect to database server - SSL error: SSL_CTX_set_default_verify_paths failed
Hi, Am 08.06.2020 um 12:25 schrieb Antony Stone: On Monday 08 June 2020 at 12:15:56, Markus wrote: Hi list! I'm getting this error frequently: ERROR[25193][C-0004f387]: cdr_mysql.c:203 mysql_log: Cannot connect to database server localhost: (2026) SSL connection error: SSL_CTX_set_default_verify_paths failed Hmmm... talking to localhost over SSL... seems a bit computationally wasteful. I switched to connecting via sock. My cdr_mysql.conf looks like this: [global] ;hostname=localhost dbname=asterisk table=cdr password=somepassword user=someuser ;port=3306 sock=/var/lib/mysql/mysql.sock However, I'm still frequently getting: "[Jun 29 12:40:08] ERROR[12977][C-07cc]: cdr_mysql.c:203 mysql_log: Cannot connect to database server localhost: (2026) SSL connection error: SSL_CTX_set_default_verify_paths failed" Which makes no sense because I'm no longer connecting via localhost. The error message still mentions localhost, though. Maybe the error message is not accurate enough?! Strange? As explained previously, the error comes and go. Right now I'm losing about 10% of my CDRs. But that means it's not a general problem with the SSL stuff. Thanks! Markus -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users