[asterisk-users] Queue_log into MySQL - best practices
Hi, I use asterisk 1.8. Currently I use a perl daemon to parse queue_log into MySQL. It works reliably. But I know that there is a method (http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL and http://work.mikeboylan.com/asterisk-queuelog-to-mysql) to write to MySQL directly with app_mysql which has a DEPRECATED status. My question is: What is the best/preffered approach to put queue_log into MySQL in asterisk 1.8 and up? 1) To use external daemons to parse /var/log/queue_log? 2) To use the deprecated app_mysql? the status does not guarantee that this application will be in the future 3) To use odbc to access mysql? but I could not find a procedure for it. And I doubt it is possible. BR, Dmitry Pavlenko -- _ -- 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] leading ghost 0
Un-top-posting, On Tue, Nov 20, 2012 at 03:49:49PM +0100, Leandro Dardini wrote: 2012/11/20 Frederic Van Espen frederic...@gmail.com On Tue, 2012-11-20 at 15:03 +0100, gincantalupo wrote: I'm sure nobody has added something... tried prilocaldialplan and pridialplan but nothing changed. Question: if pridialplan or prilocaldialplan would work, should I see the 0 inside PRI frame with intense debug or it is hidden? Somebody correct me if I'm wrong but I think you have to restart asterisk when you change these settings on dahdi. Keep that in mind. Not only, you have to restart dahdi/zaptel as well. No need for that. Some of the settings in chan_dahdi.conf (most of the per-span settings) are not applied at configuration reload. There are some slightly less brutal ways than fully restarting Asterisk to apply them: In the Asterisk CLI: dahdi restart Or, again in the Asterisk CLI: module unload chan_dahdi.so module load chan_dahdi.so No need to load / unload any kernel modules and such. -- Tzafrir Cohen icq#16849755 jabber:tzafrir.co...@xorcom.com +972-50-7952406 mailto:tzafrir.co...@xorcom.com http://www.xorcom.com iax:gu...@local.xorcom.com/tzafrir -- _ -- 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] Facing issue in installation of asterisk ...
Hi Team, That's 1st time I had that issue with installation.. I tried with 1.4,1.6 but the same issue and after log of googling I drop an e-mail... I am sure that not asterisk product issue, but I want to know what module,rpm I missed on that process... Below are the error details on centof 5.8 with asterisk 1.4 and 1.6 issue mkdir -p /var/lib/asterisk/agi-bin make -C sounds install make[1]: Entering directory `/usr/src/asterisk/asterisk-1.6.2.23/sounds' mkdir -p /var/lib/asterisk/sounds/en mkdir -p /var/lib/asterisk/sounds/en_AU mkdir -p /var/lib/asterisk/sounds/es mkdir -p /var/lib/asterisk/sounds/fr mkdir -p /var/lib/asterisk/moh make[1]: Leaving directory `/usr/src/asterisk/asterisk-1.6.2.23/sounds' mkdir -p /usr/lib/asterisk/modules mkdir -p /usr/sbin mkdir -p /etc/asterisk mkdir -p /var/run/asterisk mkdir -p /var/spool/asterisk/voicemail mkdir -p /var/spool/asterisk/dictate mkdir -p /var/spool/asterisk/system mkdir -p /var/spool/asterisk/tmp mkdir -p /var/spool/asterisk/meetme mkdir -p /var/spool/asterisk/monitor make[1]: Warning: File `/usr/include/linux/limits.h' has modification time 2e+05 s in the future [CC] eagi-test.c - eagi-test.o In file included from eagi-test.c:8: /usr/include/asterisk.h:21:33: error: asterisk/autoconfig.h: No such file or directory /usr/include/asterisk.h:27:29: error: asterisk/compat.h: No such file or directory In file included from eagi-test.c:8: /usr/include/asterisk.h:195: error: expected declaration specifiers or â...â before âuint64_tâ /usr/include/asterisk.h:196: error: expected â=â, â,â, â;â, âasmâ or â__attribute__â before âast_profileâ /usr/include/asterisk.h:197: error: expected â=â, â,â, â;â, âasmâ or â__attribute__â before âast_markâ eagi-test.c: In function âread_environmentâ: eagi-test.c:27: error: âstdinâ undeclared (first use in this function) eagi-test.c:27: error: (Each undeclared identifier is reported only once eagi-test.c:27: error: for each function it appears in.) eagi-test.c:32: warning: incompatible implicit declaration of built-in function âstrlenâ eagi-test.c:36: warning: incompatible implicit declaration of built-in function âstrchrâ eagi-test.c:38: warning: incompatible implicit declaration of built-in function âfprintfâ eagi-test.c:38: error: âstderrâ undeclared (first use in this function) eagi-test.c:45: warning: incompatible implicit declaration of built-in function âfprintfâ eagi-test.c: In function âwait_resultâ: eagi-test.c:57: error: âfd_setâ undeclared (first use in this function) eagi-test.c:57: error: expected â;â before âfdsâ eagi-test.c:63: error: âfdsâ undeclared (first use in this function) eagi-test.c:64: error: âSTDIN_FILENOâ undeclared (first use in this function) eagi-test.c:65: error: âSTDERR_FILENOâ undeclared (first use in this function) eagi-test.c:67: error: âNULLâ undeclared (first use in this function) eagi-test.c:69: warning: incompatible implicit declaration of built-in function âfprintfâ eagi-test.c:69: error: âstderrâ undeclared (first use in this function) eagi-test.c:69: error: âerrnoâ undeclared (first use in this function) eagi-test.c:73: error: âstdinâ undeclared (first use in this function) eagi-test.c:77: warning: incompatible implicit declaration of built-in function âfprintfâ eagi-test.c:80: warning: incompatible implicit declaration of built-in function âstrlenâ eagi-test.c:81: warning: incompatible implicit declaration of built-in function âfprintfâ eagi-test.c: In function ârun_commandâ: eagi-test.c:105: warning: incompatible implicit declaration of built-in function âfprintfâ eagi-test.c:105: error: âstdoutâ undeclared (first use in this function) eagi-test.c: In function ârun_scriptâ: eagi-test.c:114: warning: incompatible implicit declaration of built-in function âfprintfâ eagi-test.c:114: error: âstderrâ undeclared (first use in this function) eagi-test.c:117: warning: incompatible implicit declaration of built-in function âfprintfâ eagi-test.c: In function âmainâ: eagi-test.c:151: error: âstdinâ undeclared (first use in this function) eagi-test.c:152: error: âstdoutâ undeclared (first use in this function) eagi-test.c:154: warning: incompatible implicit declaration of built-in function âfprintfâ eagi-test.c:154: error: âstderrâ undeclared (first use in this function) eagi-test.c:154: error: âerrnoâ undeclared (first use in this function) eagi-test.c:155: warning: incompatible implicit declaration of built-in function âexitâ eagi-test.c:157: warning: assignment makes pointer from integer without a cast eagi-test.c:159: warning: incompatible implicit declaration of built-in function âsscanfâ eagi-test.c:163: warning: incompatible implicit declaration of built-in function âfprintfâ eagi-test.c:164: warning: incompatible implicit declaration of built-in function âexitâ eagi-test.c:168: warning: incompatible implicit declaration of built-in function âexitâ make[1]: *** [eagi-test.o] Error 1 make: *** [agi-install] Error 2 [root@localhost asterisk-1.6.2.23]# -- Thanks and regards
Re: [asterisk-users] Queue_log into MySQL - best practices
Hi Dmitry, we usually advise against writing queue_log events straight to a database, as it is marginally more likely that the DB has issues that a simple flat file. And when data is lost it's lost forever. Still everybody seems to love writing data straight to the DB :) l. 2012/11/22 Dmitry mbike200...@yahoo.com Hi, I use asterisk 1.8. Currently I use a perl daemon to parse queue_log into MySQL. It works reliably. But I know that there is a method ( http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL and http://work.mikeboylan.com/asterisk-queuelog-to-mysql) to write to MySQL directly with app_mysql which has a DEPRECATED status. My question is: What is the best/preffered approach to put queue_log into MySQL in asterisk 1.8 and up? 1) To use external daemons to parse /var/log/queue_log? 2) To use the deprecated app_mysql? the status does not guarantee that this application will be in the future 3) To use odbc to access mysql? but I could not find a procedure for it. And I doubt it is possible. BR, Dmitry Pavlenko -- Loway - home of QueueMetrics - http://queuemetrics.com Test-drive WombatDialer beta @ http://wombatdialer.com -- _ -- 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] Queue_log into MySQL - best practices
Have you considered using something like Splunk to aggregate your log files and store a copy for later analysis? Even if you want it to be available to someone, say a remote customer, via a web panel, I believe you could even have Splunk put it into another database or make a view in Splunk's database. I believe that might work. On Nov 22, 2012 2:01 AM, Dmitry mbike200...@yahoo.com wrote: Hi, I use asterisk 1.8. Currently I use a perl daemon to parse queue_log into MySQL. It works reliably. But I know that there is a method ( http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL and http://work.mikeboylan.com/asterisk-queuelog-to-mysql) to write to MySQL directly with app_mysql which has a DEPRECATED status. My question is: What is the best/preffered approach to put queue_log into MySQL in asterisk 1.8 and up? 1) To use external daemons to parse /var/log/queue_log? 2) To use the deprecated app_mysql? the status does not guarantee that this application will be in the future 3) To use odbc to access mysql? but I could not find a procedure for it. And I doubt it is possible. BR, Dmitry Pavlenko -- _ -- 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] Channelvariables not set in Newchannel event and DADHIChannel
I'd like to receive channelvariables in my AMI-events. Unfortunately this seems not to work for Newchannel- and DAHDIChannel- events caused by an Originate. In manager.conf I putted the following line: channelvars=CHANNEL(uniqueid),AJ_TRACE_ID . Only CHANNEL(uniqueid) appears to work for every event. This seems like a bug to me, or is there a purpose for this behaviour? Anyway, receiving channelvariables in Newchannel- and DAHDIChannel- events would be a very useful functionality for my application. Best regards, Arjan Kroon Below you'll find some information about my testcase. Asterisk 1.8.15 settings in manager.conf [general] channelvars=CHANNEL(uniqueid),AJ_TRACE_ID flow 1) originate with __AJ_TRACE_ID=AJ_ORIGINATE_2 2) Newchannel event received without AJ_TRACE_ID set 3) DAHDIChannel event received without AJ_TRACE_ID set 4) NewAccountCode event received and AJ_TRACE_ID is set action: Originate actionid: 608078545_40#AJ_ORIGINATE_2 callerid: async: true variable: CALLERPRES()=prohib variable: dcoModURL= variable: dcoCoreURL=http://localhost:8080/DijkConnectIVRWebApp/services/TestService variable: dcoLicenseeId=39 variable: dcoApplicationReference= variable: dcoPresentationNumber= variable: dcoCallId=TESTMOBILLION3 variable: dcoRecordingStorageReference= variable: dcoRedirectCallId= variable: dcoSetupTimedOut=SETUP variable: dcoAgentId=100 variable: dcoDestinationNumber=0031650747314 variable: __AJ_TRACE_ID=AJ_ORIGINATE_2 variable: dcoRecordingMode= variable: dcoConnectionTimeOut=60 variable: dcoUserRole=OUTBOUND_AGENT variable: dcoRecordingProcessingURL= variable: dcoDialMode=AGENT variable: dcoRingTimeOut=60 variable: dcoRecordingStorageDuration= variable: dcoBillingReference=t=mobtest priority: 1 exten: s context: setup_agent channel: DAHDI/g1/0031650747314 timeout: 13 message : Originate successfully queued response : Success actionid : 608078545_40#AJ_ORIGINATE_2 Event: Newchannel Privilege: call,all SequenceNumber: 1877 File: channel.c Line: 1349 Func: __ast_channel_alloc_ap Channel: DAHDI/i1/0031650747314-3 ChannelState: 1 ChannelStateDesc: Rsrvd CallerIDNum: CallerIDName: AccountCode: Exten: Context: incoming Uniqueid: dijkivr04-nwg.mobillion.biz-1353083131.2 ChanVariable(DAHDI/i1/0031650747314-3): CHANNEL(uniqueid)=dijkivr04-nwg.mobillion.biz-1353083131.2 ChanVariable(DAHDI/i1/0031650747314-3): AJ_TRACE_ID= -- above: AJ_TRACE_ID not set Event: DAHDIChannel Privilege: call,all SequenceNumber: 1878 File: chan_dahdi.c Line: 2141 Func: dahdi_ami_channel_event Channel: DAHDI/i1/0031650747314-3 Uniqueid: dijkivr04-nwg.mobillion.biz-1353083131.2 DAHDISpan: 1 DAHDIChannel: 1 ChanVariable(DAHDI/i1/0031650747314-3): CHANNEL(uniqueid)=dijkivr04-nwg.mobillion.biz-1353083131.2 ChanVariable(DAHDI/i1/0031650747314-3): AJ_TRACE_ID= -- above: AJ_TRACE_ID not set action: GetVar actionid: 608078545_41# variable: AJ_TRACE_ID channel: DAHDI/i1/0031650747314-3 response : Success actionid : 608078545_41# value : AJ_ORIGINATE_2 variable : AJ_TRACE_ID Event: NewAccountCode Privilege: call,all SequenceNumber: 1900 File: cdr.c Line: 1010 Func: ast_cdr_setaccount Channel: DAHDI/i1/0031650747314-3 Uniqueid: dijkivr04-nwg.mobillion.biz-1353083131.2 AccountCode: OldAccountCode: ChanVariable(DAHDI/i1/0031650747314-3): CHANNEL(uniqueid)=dijkivr04-nwg.mobillion.biz-1353083131.2 ChanVariable(DAHDI/i1/0031650747314-3): AJ_TRACE_ID=AJ_ORIGINATE_2 -- above: AJ_TRACE_ID set Regards, Arjan Kroon Mobillion BV -- _ -- 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] Incorrect DTMF detection in Asterisk 1.8
Hi All, I'm using 1.8 Asterisk and i havet set DTMF mode=rfc2833 in SIP global default settings. but when user sending DTMf event with SIP info method my asterisk accepting that DTMF. If default or global setting is rfc2833 then how come asterisk accepting SIP info dtmf event? what to check please guide Amit-- -- _ -- 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] Java server side components
Hello, I am a java programmer and I will like to integrate Asterisk to my product line. The challenge is that I have been searching for a java server component that I can use to create an Asterisk GUI configurator. it could be open source or commercial . Nweike Onwuyali . excuse my typos brevity. Sent from a mobile device -- _ -- 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] monitoring asteriks
How can I monitor asterisk if all lines are registered etc? I have an asterisk on a remote location and sometime they reporting problems that phone is not ringing, they can not dial out etc. Usually I just restart asterisk and it solves the problem. Is there an application that will email me if case any line looses registration with with asterisk? Or any better solution! -- Joseph -- _ -- 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] Asterisk 11 - Security event logging over syslog
Hi all, I am just testing with Asterisk 11.01. The SIP security event logging works fine for me for console and file logging, but the security events are not logged over syslog. logger.conf: ... syslog.local0 = notice,warning,error,security Is this on purpose, a fault on my side, or is this a bug? Michael http://www.mksolutions.info smime.p7s Description: S/MIME cryptographic signature -- _ -- 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] monitoring asteriks
take a look at AsteriskControl script at www.generationd.com This is a free script that monitors, responds to IP address changes, etc. and restarts asterisk. You can also use HAAST (commercial) at same site - it can check for missing registrations etc and restart asterisk too. -=M=- From: asterisk-users-boun...@lists.digium.com [asterisk-users-boun...@lists.digium.com] On Behalf Of Joseph [syscon...@gmail.com] Sent: Thursday, November 22, 2012 4:18 PM To: Asterisk Users List Subject: [asterisk-users] monitoring asteriks How can I monitor asterisk if all lines are registered etc? I have an asterisk on a remote location and sometime they reporting problems that phone is not ringing, they can not dial out etc. Usually I just restart asterisk and it solves the problem. Is there an application that will email me if case any line looses registration with with asterisk? Or any better solution! -- Joseph -- _ -- 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] monitoring asteriks
How about any of these programs listed in: http://www.voip-info.org/wiki/view/Asterisk%2Bmonitoring -- Joseph On 11/22/12 17:04, Michelle Dupuis wrote: take a look at AsteriskControl script at www.generationd.com This is a free script that monitors, responds to IP address changes, etc. and restarts asterisk. You can also use HAAST (commercial) at same site - it can check for missing registrations etc and restart asterisk too. -=M=- -- _ -- 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] Queue_log into MySQL - best practices
Hi Dmitry, I've been using the below for a long time and it works perfectly. I've built a custom solution in terms of the tables. My understand of the external queue logging to MySQL is that it uses the Realtime engine to do so, so it's not affected by app_mysql directly. Please do correct me if I'm wrong. Thanks, Andrew From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Dmitry Sent: Thursday, 22 November 2012 6:58 PM To: asterisk-users@lists.digium.com Subject: [asterisk-users] Queue_log into MySQL - best practices Hi, I use asterisk 1.8. Currently I use a perl daemon to parse queue_log into MySQL. It works reliably. But I know that there is a method (http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL and http://work.mikeboylan.com/asterisk-queuelog-to-mysql) to write to MySQL directly with app_mysql which has a DEPRECATED status. My question is: What is the best/preffered approach to put queue_log into MySQL in asterisk 1.8 and up? 1) To use external daemons to parse /var/log/queue_log? 2) To use the deprecated app_mysql? the status does not guarantee that this application will be in the future 3) To use odbc to access mysql? but I could not find a procedure for it. And I doubt it is possible. BR, Dmitry Pavlenko -- _ -- 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] monitoring asteriks
Hi, I had a zabbix http://zabbix.org/wiki/Main_Page monitoring server with zabbix_agent installed on the asterisk server. Zabbix server requests the agent to execute an AMI script and pull information about the phone in the given argument to that function. That AMI script returned the 1 from the OK(1ms) of the peer status and zabbix server printed that onthe graph. As soon as the peer went unreachable Zabbix server has the ability to wait for 2/3/X tries and trigger an email or action(i.e SMS or etc) to the administrator. That thing worked fine with minimum effort. Also one of my student developed a C# GUI based tool which connected to asterisk via AMI and shows the buddy icons of online users. (green for online extensions and grey for recently timeout/unregistered) Like FOP - That was a windows based utility. Such simple development can be good for you too. Like Joseph referenced there are other tools which you can experience as well. Munin can be a good simple monitoring tool too. Hope it will give you some pointers. Regards, Sammy Go. On Fri, Nov 23, 2012 at 4:07 AM, Joseph syscon...@gmail.com wrote: How about any of these programs listed in: http://www.voip-info.org/wiki/**view/Asterisk%2Bmonitoringhttp://www.voip-info.org/wiki/view/Asterisk%2Bmonitoring -- Joseph On 11/22/12 17:04, Michelle Dupuis wrote: take a look at AsteriskControl script at www.generationd.com This is a free script that monitors, responds to IP address changes, etc. and restarts asterisk. You can also use HAAST (commercial) at same site - it can check for missing registrations etc and restart asterisk too. -=M=- -- __**__**_ -- 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-**usershttp://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