[asterisk-users] [0017330] 1.6.1 and 1.6.2 + MySQL crases on ODBC Query (via func_odbc or sip realtime)
Hi, I'm expiriencing very annoying issue with Asterisk while using ODBC on Linux box running Debian with following packages: Asterisk-node0:/tmp# dpkg -l | grep -i odbc ii libiodbc23.52.6-2 iODBC Driver Manager ii libmyodbc3.51.15r409-4 the MySQL ODBC driver ii libodbcinstq1c2 2.2.11-16 Qt-based ODBC configuration library ii odbcinst1debian1 2.2.11-16 Support library and helper program for acces ii unixodbc 2.2.11-16 ODBC tools libraries ii unixodbc-bin 2.2.11-16 Graphical tools for ODBC management and brow ii unixodbc-dev 2.2.11-16 ODBC libraries for UNIX (development files) Asterisk-node0:/tmp# dpkg -l | grep -i mysql ii libdbd-mysql-perl4.007-1A Perl5 database interface to the MySQL data ii libmyodbc3.51.15r409-4 the MySQL ODBC driver ii libmysql5.0-cil 5.2.1+dfsg-2 MySQL database connector for CLI ii libmysqlclient15-dev 5.0.51a-17 MySQL database development files ii libmysqlclient15off 5.0.51a-17 MySQL database client library ii mysql-client-5.0 5.0.51a-17 MySQL database client binaries ii mysql-common 5.0.51a-17 MySQL database common files ii mysql-server 5.0.51a-17 MySQL database server (metapackage depending ii mysql-server-5.0 5.0.51a-17 MySQL database server binaries Medium load system (~300 simultaneous calls) crases few times a day. I'm not able to reproduce issue in lab conditions. I've raised a bug https://issues.asterisk.org/view.php?id=17330 for 1.6.1.19 but then upgraded to 1.6.2.7 but it's not solving issue. Any idea what can be wrong/tunned? -- _ -- 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] Call terminates after 20 minutes
Jim Boykin pisze: We are running Asterisk SVN. We are facing a strange and repetable problem. All outgoing call gets terminated in approx 20 minutes. Asterisk initiates BYE message to the remote end and call terminates. Sesion-timer set but not supported by sip-peers? ___ -- 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] Customized Queuing Strategy
Syed Nasruddin pisze: Hi All, I have this Call Center requirement to be implenetd: 1. 10 Call Center Agents. 2. All the calls coming in will ALWAYS be routed to specific 5 agents, firstly. 4. IF ALL the first 5 agents are busy then ONLY then the call will be routed to next 5 Agents. Kindly suggest some good easy strategy to handle this. http://www.voip-info.org/wiki-Asterisk+call+queues read about Penalties should do the trick ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2008 - September 22 - 25 Phoenix, Arizona Register Now: http://www.astricon.net asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] Unrecognized prilocaldialplan TON modifier: 5
Hi, I'm having strange warning from asterisk when I try to dial GSM Gateway: -- Executing [EMAIL PROTECTED]:1] NoCDR(SIP/ibm-b2c52848, ) in new stack -- Executing [EMAIL PROTECTED]:2] Dial(SIP/ibm-b2c52848, Zap/R3/501522xxx) in new stack -- Requested transfer capability: 0x00 - SPEECH [Jul 13 11:58:50] WARNING[18208]: chan_zap.c:2731 zt_call: Unrecognized prilocaldialplan TON modifier: 5 [Jul 13 11:58:50] WARNING[18208]: chan_zap.c:2731 zt_call: Unrecognized prilocaldialplan TON modifier: 5 [Jul 13 11:58:50] WARNING[18208]: chan_zap.c:2731 zt_call: Unrecognized prilocaldialplan TON modifier: 5 [Jul 13 11:58:50] WARNING[18208]: chan_zap.c:2731 zt_call: Unrecognized prilocaldialplan TON modifier: 5 [Jul 13 11:58:50] WARNING[18208]: chan_zap.c:2731 zt_call: Unrecognized prilocaldialplan TON modifier: 5 [Jul 13 11:58:50] WARNING[18208]: chan_zap.c:2731 zt_call: Unrecognized prilocaldialplan TON modifier: 5 -- Called R3/501522xxx -- SIP/sempron-0829ba70 is making progress passing it to SIP/kowal-b2c35fe8 -- Zap/113-1 is proceeding passing it to SIP/ibm-b2c52848 -- Zap/113-1 is making progress passing it to SIP/ibm-b2c52848 == Spawn extension (na-miasto, 1010501522xxx, 5) exited non-zero on 'SIP/kowal-b2c35fe8' -- Executing [EMAIL PROTECTED]:1] Hangup(SIP/kowal-b2c35fe8, ) in new stack I've tried to google sth about this error but I found nothing. ZAP card is Sangoma A104d, group 3 configured as Master, EuroISDN, hw EC on. Marcin ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2008 - September 22 - 25 Phoenix, Arizona Register Now: http://www.astricon.net asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] cdr_addon_mysql - additional fields
Hi, I need help with modifying cdr_addon_mysql.c I want to have more fields in cdr table in asterisk. I've tried to modify cdr_addon_mysql.c and replace userfield with ex team (sed -e 's/userfield/team/g' ). When I try to recomplie menuselect/menuselect --check-deps menuselect.makeopts Generating embedded module rules ... make[1]: Nothing to be done for `all'. make[1]: Nothing to be done for `all'. make[1]: Nothing to be done for `all'. [CC] cdr_addon_mysql.c - cdr_addon_mysql.o cdr_addon_mysql.c: In function 'mysql_log': cdr_addon_mysql.c:214: error: 'struct ast_cdr' has no member named 'team' cdr_addon_mysql.c:215: error: 'struct ast_cdr' has no member named 'team' cdr_addon_mysql.c:215: error: 'struct ast_cdr' has no member named 'team' make[1]: *** [cdr_addon_mysql.o] Error 1 make: *** [cdr] Error 2 asterisk-IBM:/usr/src/asterisk-addons-1.4.7# Any idea how to solve this problem? ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2008 - September 22 - 25 Phoenix, Arizona Register Now: http://www.astricon.net asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] cdr_addon_mysql - additional fields
Tilghman Lesher pisze: Use the one in trunk. It already supports arbitrary fields, no source change necessary. Motivate the right person, and it may even get backported to 1.4 (or backport it yourself). I've tried to use: svn co http://svn.digium.com/svn/asterisk-addons/trunk/ asterisk-addons Fetching external item into 'asterisk-addons/menuselect' Fetching external item into 'asterisk-addons/menuselect/mxml' Checked out external at revision 82. Checked out revision 342. Checked out revision 645. and I have problem with compiling make[1]: Entering directory `/usr/src/asterisk-addons/cdr' [CC] cdr_addon_mysql.c - cdr_addon_mysql.o cdr_addon_mysql.c:94: warning: 'struct ast_cli_args' declared inside parameter list cdr_addon_mysql.c:94: warning: its scope is only this definition or declaration, which is probably not what you want cdr_addon_mysql.c: In function 'handle_cli_cdr_mysql_status': cdr_addon_mysql.c:97: error: 'CLI_INIT' undeclared (first use in this function) cdr_addon_mysql.c:97: error: (Each undeclared identifier is reported only once cdr_addon_mysql.c:97: error: for each function it appears in.) cdr_addon_mysql.c:98: error: 'struct ast_cli_entry' has no member named 'command' cdr_addon_mysql.c:103: error: 'CLI_GENERATE' undeclared (first use in this function) cdr_addon_mysql.c:107: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:108: error: 'CLI_SHOWUSAGE' undeclared (first use in this function) cdr_addon_mysql.c:114: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:114: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:116: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:116: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:116: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:118: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:118: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:120: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:121: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:122: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:123: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:125: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:127: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:129: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:131: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:133: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:136: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:138: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:140: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:143: error: 'CLI_SUCCESS' undeclared (first use in this function) cdr_addon_mysql.c: At top level: cdr_addon_mysql.c:147: error: initializer element is not constant cdr_addon_mysql.c:147: error: (near initialization for 'cdr_mysql_status_cli[0].cmda[0]') cdr_addon_mysql.c: In function 'mysql_log': cdr_addon_mysql.c:182: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:182: error: request for member 'str' in something not a structure or union cdr_addon_mysql.c:182: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:182: error: request for member 'str' in something not a structure or union cdr_addon_mysql.c:182: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:182: error: request for member 'str' in something not a structure or union cdr_addon_mysql.c:182: warning: passing argument 2 of 'mysql_ssl_set' from incompatible pointer type cdr_addon_mysql.c:182: warning: passing argument 3 of 'mysql_ssl_set' from incompatible pointer type cdr_addon_mysql.c:182: warning: passing argument 4 of 'mysql_ssl_set' from incompatible pointer type cdr_addon_mysql.c:184: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:184: error: request for member 'str' in something not a structure or union cdr_addon_mysql.c:184: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:184: error: request for member 'str' in something not a structure or union cdr_addon_mysql.c:184: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:184: error: request for member 'str' in something not a structure or union cdr_addon_mysql.c:184: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:184: error: request for member 'str' in something not a structure or union cdr_addon_mysql.c:184: error: dereferencing pointer to incomplete type cdr_addon_mysql.c:184: error: request for member 'str' in something not a structure or union
[asterisk-users] queue show name - callerID
Hi, Is there a way to show callerID of calls waiting in queue? queue show shows only channel not callerID Cheers, Marcin ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2008 - September 22 - 25 Phoenix, Arizona Register Now: http://www.astricon.net asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Palyback and CDR records
michael_t Gazeta.pl pisze: Hello all! I have a problem when I try to playback soundfile using Playback or Background in extensions.conf CDR is recording call as ANSWERED even if it's not, and record time from beginning of Playback. Is it a bug or do i do something wrong? exten = _078.,1,Set(CHANNEL(language)=pl) exten = _078.,2,Wait(2) exten = _078.,3,Playback(platna) exten = _078.,4,SetAMAFlags(documentation) exten = _078.,5,Dial(SIP/voipnet/0048${EXTEN:1},120,Tt) exten = _078.,6,Hangup I think you shoud add http://www.voip-info.org/wiki/view/Asterisk+cmd+ResetCDR before dial. I may be wrong, so you have to check ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2008 - September 22 - 25 Phoenix, Arizona Register Now: http://www.astricon.net asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] Software loop on ZAP trunk - Sangoma
Hi, Is there a way to setup software loop on one of E1 ports on Sangoma A104d card? I need to setup loop for my telco operator, but Asterisk is located 300km from my place. Cheers, Marcin ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2008 - September 22 - 25 Phoenix, Arizona Register Now: http://www.astricon.net asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Asterisk 1.4.21 stalls?
Remco Barendse pisze: However after some time it is not possible to call anymore, my Snom display simply shows Not available and incoming calls from the PRI fail, like the PRI is not connected. Reverting back to 1.4.20.1 solves the problem. I tried re-installing and re-compiling 1.4.21 and all the modules several times, didn't help. Anyone else seeing this? I have same problem. I'm just downgrading to 1.4.20.1 ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2008 - September 22 - 25 Phoenix, Arizona Register Now: http://www.astricon.net asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] Asterisk + zap + sangoma A104D - how to setup call using particular timeslot
Hi all, I need to setup call using particular timeslot on one of E1's. I've looked into http://www.voip-info.org/wiki/index.php?page=Asterisk+Zap+channels and it says that: exten = TestTrakt,1,Dial(ZAP/1-2/517255333) exten = TestTrakt,2,hangup should work and force call setup via span 1 (port 1) but when I try setup call rasterisk says: -- Executing [EMAIL PROTECTED]:1] Dial(SIP/sempron-b2ae1918, ZAP/1-2/517255333) in new stack [Jun 19 21:22:20] WARNING[23814]: chan_zap.c:7966 zt_request: Unknown option '-' in '1-2/517255333' -- Requested transfer capability: 0x00 - SPEECH -- Called 1-2/517255333 -- Hungup 'Zap/1-1' == Spawn extension (na-miasto, TestTrakt, 1) exited non-zero on 'SIP/sempron-b2ae1918' any idea how to force Asterisk to push call via particular timeslot? Regards, Marcin ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2008 - September 22 - 25 Phoenix, Arizona Register Now: http://www.astricon.net asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] zaphfc - problem
hI, I've got problem with zaphfc kernel module. After I load into kernel i receive something like that into syslog: 0 16:56:42 viperprint-de kernel: zaphfc: empty HDLC frame or bad CRC received (framelen = 5, stat = 0xff, card = 0). Jul 10 16:56:42 viperprint-de kernel: zaphfc: empty HDLC frame or bad CRC received (framelen = 3, stat = 0xff, card = 0). Jul 10 16:56:42 viperprint-de kernel: zaphfc: empty HDLC frame or bad CRC received (framelen = 30, stat = 0xfc, card = 0). in my zapta.conf i'vh got: [channels] language=en signalling = bri_net_ptmp group = 1 context=default channel = 1 i've tried to change bri_net_ptmp into bri_cpe_ptmp but it didn't help. ISDN card is connected with good cable (i've plugged out phone) - or should I use ISDN crossover cable? I've searched google, but I didn't find anything helpfull. Regards, Marcin begin:vcard fn:Marcin J. Kowalczyk n:Kowalczyk;Marcin Janusz email;internet:[EMAIL PROTECTED] tel;work:+48 501 522 511 tel;home:+48 71 722 80 22 note;quoted-printable:skype:kowalma=0D=0A= gg:1171510 x-mozilla-html:FALSE version:2.1 end:vcard ___ --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] zaphfc - problem
Kai Fürstenberg napisał(a): If you want to connect a telephone to the HFC card you need a crossed cable to connect to an NTBA to which you connect the phones. i'm connecting to ISDN-NTBA from T-Com. As far as I know you don't need a crossed cable when you connect the phone directly. Have you set HFC mode correctly (NT or TE)? I've tried with NT or TE (modprobe zaphfc modes=1 zaphfc modes=0 ) begin:vcard fn:Marcin J. Kowalczyk n:Kowalczyk;Marcin Janusz email;internet:[EMAIL PROTECTED] tel;work:+48 501 522 511 tel;home:+48 71 722 80 22 note;quoted-printable:skype:kowalma=0D=0A= gg:1171510 x-mozilla-html:FALSE version:2.1 end:vcard ___ --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