[asterisk-users] [0017330] 1.6.1 and 1.6.2 + MySQL crases on ODBC Query (via func_odbc or sip realtime)

2010-05-24 Thread Marcin J. Kowalczyk
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

2008-10-31 Thread Marcin J. Kowalczyk
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

2008-08-04 Thread Marcin J. Kowalczyk

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

2008-07-13 Thread Marcin J. Kowalczyk
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

2008-07-07 Thread Marcin J. Kowalczyk

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

2008-07-07 Thread Marcin J. Kowalczyk

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

2008-07-01 Thread Marcin J. Kowalczyk
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

2008-06-28 Thread Marcin J. Kowalczyk
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

2008-06-22 Thread Marcin J. Kowalczyk
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?

2008-06-20 Thread Marcin J. Kowalczyk
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

2008-06-19 Thread Marcin J. Kowalczyk
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

2006-07-10 Thread Marcin J. Kowalczyk
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

2006-07-10 Thread Marcin J. Kowalczyk
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