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
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
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
[asterisk-users] cdr_mysql: Cannot connect to database server - SSL error: SSL_CTX_set_default_verify_paths failed
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 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? Asterisk 11.25.0 built by mockbuild @ olive.ph.tucny.com on a x86_64 running Linux on 2016-11-23 22:17:54 UTC Database is a Galera cluster: galera-3-25.3.19-2.el7.x86_64 Asterisk is writing to the local MySQL instance and there's SSL between the Galera cluster nodes. 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
[asterisk-users] CDR_MYSQL
I need to install cdr_mysql.so module for logging call to mysql. I have the source file cdr_mysql.c only. Can someone explain the steps needed to get this module compiled and working in Asterisk 1.8.22.0 on CentOS. Thanks. Nick -- _ -- 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
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 stopped working
On Mon, Dec 20, 2010 at 5:02 PM, Bryant Zimmerman brya...@zktech.com 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 brya...@zktech.com 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 dbackeb...@gmail.com Sent: Thursday, December 23, 2010 10:59 AM To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Subject: Re: [asterisk-users] cdr_mysql stopped working On Mon, Dec 20, 2010 at 5:02 PM, Bryant Zimmerman brya...@zktech.com 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 j...@slackware-es.com Sent: Thursday, December 23, 2010 12:19 PM To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com 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 brya...@zktech.com 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
[asterisk-users] cdr_mysql stopped working
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? Thanks Bryant -- _ -- 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
[asterisk-users] CDR_MYSQL 1.4 Database Structure
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'. Thanks in advance ___ -- 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 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
[asterisk-users] cdr_mysql custom fields ?
* * * Hi there 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 Regards Kev This Communication is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential or copyright. You are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited without the authority of the sender. If you have received this e-mail message in error or are not the intended recipient, please delete and destroy all copies and notify us immediately by return mail. Any views expressed in this communication are those of the individual sender, except where the sender specifically states otherwise. If you no longer want to receive notifications, simply reply to this e-mail. ___ -- 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 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
[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
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 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
[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
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-HEADversion 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 asterisk-users@lists.digium.com 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 asterisk-users@lists.digium.com 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 - 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 asterisk-users@lists.digium.com 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 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
[Asterisk-Users] cdr_mysql
Hi, Something seamless has become rather painful lately: cc -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/include/mysql -c -o app_addon_sql_mysql.o app_addon_sql_mysql.c app_addon_sql_mysql.c:162:77: macro AST_LIST_REMOVE passed 4 arguments, but takes just 3 app_addon_sql_mysql.c: In function `del_identifier': app_addon_sql_mysql.c:162: error: `AST_LIST_REMOVE' undeclared (first use in this function) app_addon_sql_mysql.c:162: error: (Each undeclared identifier is reported only once app_addon_sql_mysql.c:162: error: for each function it appears in.) make: *** [app_addon_sql_mysql.o] Error 1 A search on google says to use an older release, done that, no help.. any ideas guys? Regards, Sahil Gupta VoiceValley ___ 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
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
[Asterisk-Users] cdr_mysql losing logs
I noticed a problem this morning with our cdr logging. We have a cron job that places a call file into the spool directory having asterisk call itself to check to make sure its still handling incoming calls correctly, then queries the CDR database in mysql and makes sure that appropriate records exist. I can confirm that the call is happening correctly, but I'm missing records in the database: select calldate, disposition, lastapp, channel from cdr where clid = xx order by calldate desc limit 45; | 2005-02-14 11:34:04 | ANSWERED| Hangup | Zap/2-1 | | 2005-02-14 11:34:03 | ANSWERED| BackGround | Zap/3-1 | | 2005-02-14 11:32:03 | ANSWERED| Hangup | Zap/1-1 | | 2005-02-14 11:30:04 | ANSWERED| Hangup | Zap/3-1 | | 2005-02-14 11:30:02 | ANSWERED| BackGround | Zap/4-1 | Notice the missing BackGround entry from the 11:32 call. The asterisk console logs for this same duration: ^M-- Attempting call on Zap/g1/2144680768 for [EMAIL PROTECTED]:1 (Retry 1) Using channel 1 Urgent handler Urgent handler ^M-- Remote UNIX connection disconnected ^M-- Accepting call from '' to '2144680768' on channel 0/3, span 1 Enabled echo cancellation on channel 3 Launching 'Goto' ^M-- Executing Goto(Zap/3-1, neospire|s|1) in new stack ^M-- Goto (neospire,s,1) Launching 'Wait' ^M-- Executing Wait(Zap/3-1, 1) in new stack Difference is 1120, ms is 160 Write returned -1 (Resource temporarily unavailable) on channel 2 Write returned -1 (Resource temporarily unavailable) on channel 2 Write returned -1 (Resource temporarily unavailable) on channel 2 Write returned -1 (Resource temporarily unavailable) on channel 2 Launching 'Answer' ^M-- Executing Answer(Zap/3-1, ) in new stack Urgent handler Launching 'Wait' ^M-- Executing Wait(Zap/3-1, 1) in new stack Enabled echo cancellation on channel 1 Dropping duplicate answer! ^MChannel Zap/1-1 was answered. Launching 'StopMonitor' ^M-- Executing StopMonitor(Zap/1-1, ) in new stack Launching 'Answer' ^M-- Executing Answer(Zap/1-1, ) in new stack Launching 'Playback' ^M-- Executing Playback(Zap/1-1, 30seconds) in new stack Set channel Zap/1-1 to write format gsm Scheduling timer at 160 sample intervals ^M-- Playing '30seconds' (language 'en') Launching 'DigitTimeout' ^M-- Executing DigitTimeout(Zap/3-1, 5) in new stack ^M-- Set Digit Timeout to 5 Launching 'ResponseTimeout' ^M-- Executing ResponseTimeout(Zap/3-1, 10) in new stack ^M-- Set Response Timeout to 10 Launching 'BackGround' ^M-- Executing BackGround(Zap/3-1, neo-welcome-options) in new stack Set channel Zap/3-1 to write format gsm Scheduling timer at 160 sample intervals ^M-- Playing 'neo-welcome-options' (language 'en') Scheduling timer at 0 sample intervals Scheduling timer at 0 sample intervals Set channel Zap/3-1 to write format ulaw Scheduling timer at 0 sample intervals Scheduling timer at 0 sample intervals Set channel Zap/1-1 to write format ulaw Launching 'Hangup' ^M-- Executing Hangup(Zap/1-1, ) in new stack Spawn extension (neospire,6501,4) exited non-zero on 'Zap/1-1' cdr_mysql: inserting a CDR record. cdr_mysql: SQL command as follows: INSERT INTO cdr (calldate,clid,src,dst,dcont ext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,ac countcode,uniqueid,userfield) VALUES ('2005-02-14 11:32:03','2147201442','214720 1442','6501','neospire', 'Zap/1-1','','Hangup','',16,16,'ANSWERED',3,'','1108402 321.10557','') Hanging up channel 'Zap/1-1' zt_hangup(Zap/1-1) Set option AUDIO MODE, value: ON(1) on Zap/1-1 Hangup: channel: 1 index = 0, normal = 13, callwait = -1, thirdcall = -1 Not yet hungup... Calling hangup once with icause, and clearing call Urgent handler disabled echo cancellation on channel 1 Set option TDD MODE, value: OFF(0) on Zap/1-1 Updated conferencing on 1, with 0 conference users Set option AUDIO MODE, value: OFF(0) on Zap/1-1 disabled echo cancellation on channel 1 ^M-- Hungup 'Zap/1-1' Urgent handler Call completed to Zap/g1/2144680768 ^M-- Channel 0/3, span 1 got hangup cdr_mysql: inserting a CDR record. cdr_mysql: SQL command as follows: INSERT INTO cdr (calldate,clid,src,dst,dcont ext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,ac countcode,uniqueid,userfield) VALUES ('2005-02-14 11:32:01','','','s','neospire' , 'Zap/3-1','','BackGround','neo-welcome-options',18,17,'ANSWERED',3,'','1108402 321.10558','') Hanging up channel 'Zap/3-1' zt_hangup(Zap/3-1) Set option AUDIO MODE, value: ON(1) on Zap/3-1 Hangup: channel: 3 index = 0, normal = 15, callwait = -1, thirdcall = -1 Not yet hungup... Calling hangup once with icause, and clearing call Urgent handler disabled echo cancellation on channel 3 Set option TDD MODE, value: OFF(0) on Zap/3-1 Updated conferencing on 3, with 0 conference users Set option AUDIO MODE, value: OFF(0) on Zap/3-1 disabled echo cancellation on channel 3 ^M-- Hungup 'Zap/3-1' Notice that
[Asterisk-Users] cdr_mysql compilation error
I am trying to compile current cvs asterisk-addons for mysql cdr but I get the following error. Iam running mysql 4.0.20 and cvs v1 stable version of asterisk. cc -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/local/mysql/include -c -o cdr_addon_mysql.o cdr_addon_mysql.c cdr_addon_mysql.c:50: warning: parameter names (without types) in function declaration cdr_addon_mysql.c:50: warning: data definition has no type or storage class cdr_addon_mysql.c: In function `mysql_log': cdr_addon_mysql.c:108: `mysql_lock' undeclared (first use in this function) cdr_addon_mysql.c:108: (Each undeclared identifier is reported only once cdr_addon_mysql.c:108: for each function it appears in.) cdr_addon_mysql.c: In function `usecount': cdr_addon_mysql.c:420: `mysql_lock' undeclared (first use in this function) make: *** [cdr_addon_mysql.o] Error 1 Any idea? -- Manuel Marin Garcia TRANSTELCO S.A. DE C.V. Campos Eliseos 9050 B4 – Cd. Juárez, Chih. 32452 - México Oficina: +52 656 692 11 09 – Fax: +52 656 692 1112 - Celular: 915 727 6141 http://www.transtelco.com.mx ___ 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] cdr_mysql: Unknown connection error
Usually we get this error cdr_mysql: Unknown connection error early in the morning when the first call tries to get logged into the database. The result of course is that the call does not get logged. But all calls after that get logged fine for the rest of the day. This happens on ALL our servers and on all MySQL databases used in our network. The code in cdr_addon_mysql.c points to the use of the mysql_ping function to keep the connection alive...but something is definitely going wrong when the connection is idle for a few hours. Any ideas? I am sure we are not the only ones experiencing this. Any MySQL gurus here? -- Andres Network Admin http://www.telesip.net ___ 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] 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
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 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: 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=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
[Asterisk-Users] cdr_mysql: cannot connect
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=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. 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)
[Asterisk-Users] cdr_mysql question: accountcode
Hello- I'm using the accountcode field in cdr table to store some temporary information used by my perl scripts. I'm finding that the field seems to be truncated to 19 characters, even though the allocated field in the table is larger (varchar(45)). 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). Thanks! Scott M. Stingel Emerging Voice Technology Inc. ___ 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
-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
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
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
[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
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
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
[Asterisk-Users] cdr_mysql uncompress
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
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
[Asterisk-Users] cdr_mysql
After updating asterisk from cvs today (08/07/03). i have been unable to Asterisk to connect to mysql. cdr_mysql.so compile with no issues. - And yes, i have mysql running on the same box as asterisk. - And yes, cdr_mysql worked prior to update from cvs Has anything change from cdr_mysql.c? Can anyone tell me what i am doing wrong? Regards Patrick -- __ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup CareerBuilder.com has over 400,000 jobs. Be smarter about your job search http://corp.mail.com/careers ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users