sr-users June 2006

sr-users@lists.kamailio.org

203 participants
495 discussions

by John Peters

Hi All, We are an established company seeking a SIP and OpenSER expert to assist in the development and roll-out of a new SIP-based service. If you're interested in working on an innovative new service, and have an excellent understand of VoIP and OpenSER, please contact us! We look forward to any responses. Thanks! John Peters petersprc(a)gmail.com

18 years, 5 months

[Users] troubles with usrloc module: db_mode=3 (DB only)

by Christian Schlatter

Hi all, Running openser (CVS HEAD) with usrloc:db_mode=3 causes it to crash repeatedly after 15 secs or so. The core dump does not say much except (gdb) bt #0 0x00b2b392 in ?? () #1 0x08131468 in mem_pool () #2 0xbfff8b54 in ?? () #3 0xbfff8b54 in ?? () #4 0x00000008 in ?? () #5 0x00b3adbf in ?? () #6 0x00000007 in ?? () #7 0x00b3a88c in ?? () #8 0x00000006 in ?? () #9 0x00b3adcd in ?? () #10 0x00000005 in ?? () #11 0x00b3adae in ?? () #12 0xb576a560 in ?? () #13 0x00000007 in ?? () #14 0x00b39c59 in ?? () #15 0x00000005 in ?? () #16 0x00b3adae in ?? () #17 0x00000001 in ?? () #18 0x00000001 in ?? () #19 0x00000000 in ?? () The openser log looks like: ERROR: receive_fd: EOF on 16 child process 18101 exited by a signal 11 core was generated I also don't see any mysql errors. The last mysql query issued by openser before dying is always Query delete from location where expires<'2006-06-05 16:03:17' (only the timestamp changes) Deleting all location table entries before starting up openser does not help either. Is there something special I have to consider when running openser in DB-only mode? Thanks for any help, Christian

18 years, 5 months

[Serusers] how to catch an asterisk *

by bails

Hi all how do i catch a dtmf * in ser.cfg thanks Bails

18 years, 5 months

Re: [Users] openserctl error.

by Daniel-Constantin Mierla

I have changed openserctl to do the computation of GW_IP=$(($1+$2*256+$3*65536+$4*16777216)) within mysql query. The version for dbtext uses "expr" (more portable) if available. It is available only on development (frozen) branch. Cheers, Daniel On 06/09/06 17:55, Kelvin Williams wrote: > Changed the /bin/sh to /bin/bash at the beginning of the script and it > works. > > Kw > > > -----Original Message----- > From: Daniel-Constantin Mierla [mailto:daniel@voice-system.ro] > Sent: Friday, June 09, 2006 10:31 AM > To: Ovidiu Sas > Cc: Kelvin Williams; users(a)openser.org > Subject: Re: [Users] openserctl error. > > It seems that only bash understands expressions like > $(($1+$2*256+$3*65536+$4*16777216)). Maybe using expr is better. > > Kevin can you confirm that 'expr' is present in Solaris 10 box? On > debian it is part of coreutils. > > Cheers, > Daniel > > > On 06/09/06 17:28, Ovidiu Sas wrote: > >> What shell are you using? >> It looks like your shell doesn't understand the setting of GW_IP syntax. >> >> >> -ovi >> >> On 6/8/06, Kelvin Williams <kelvin-lists(a)williamschadwell.com> wrote: >> >>> >>> >>> This is a new OpenSER installation on a Solaris 10 box. >>> >>> >>> >>> Any time we call openserctl we receive the following error: >>> >>> >>> >>> /usr/local/sbin/openserctl: syntax error at line 1026: `GW_IP=$' >>> unexpected >>> >>> >>> >>> Line 26 of openserctl reads: >>> >>> >>> >>> GW_IP=$(($1+$2*256+$3*65536+$4*16777216)) >>> >>> >>> >>> Any advice would be greatly appreciated! >>> >>> >>> >>> Thanks, >>> >>> kw >>> >>> >>> _______________________________________________ >>> Users mailing list >>> Users(a)openser.org >>> http://openser.org/cgi-bin/mailman/listinfo/users >>> >>> >>> >>> >> _______________________________________________ >> Users mailing list >> Users(a)openser.org >> http://openser.org/cgi-bin/mailman/listinfo/users >> >> > > > > _______________________________________________ > Users mailing list > Users(a)openser.org > http://openser.org/cgi-bin/mailman/listinfo/users > >

18 years, 5 months

[Users] rlm_sql is not updating the record...

by raviprakash sunkara

Hi .... I'm working openser + mysql + Freeradius.... when i'm making a call for accounting, first it say " Acct-Status-Type = Failed " and then its " Acct-Status-Type = start " After that when the User hang up the call , it didn't update the Acct Stop time and inserting the t2 records ... And also what means this...... rlm_sql (sql): Reserving sql socket id: 2 radius_xlat: 'stop packet with zero session length. [user '666(a)192.168.2.55', nas '192.168.2.55']' rlm_sql (sql) in sql_accounting: stop packet with zero session length. [user '666(a)192.168.2.55', nas '192.168.2.55'] rlm_sql (sql): Released sql socket id: 2 This query is not updating ---> " 'UPDATE radacct SET AcctStopTime = '2006-06-09 19:57:27', AcctSessionTime = '', AcctInputOctets = '', AcctOutputOctets = '', AcctTerminateCause = '', AcctStopDelay = '0', ConnectInfo_stop = '' WHERE AcctSessionId = ' 76788233-9611-4A96-9FAA-E829F175C69C(a)192.168.2.20' AND NASIPAddress = ' 192.168.2.55'' " why ? and this query is inserting -----> " INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values(' 76788233-9611-4A96-9FAA-E829F175C69C(a)192.168.2.20', '63170499b83f412d', ' 666(a)192.168.2.55', '', '192.168.2.55', '5060', '', DATE_SUB('2006-06-09 19:57:27', INTERVAL (0 + 0) SECOND), '2006-06-09 19:57:27', '', '', '', '', '', '', 'sip:555@192.168.2.55', 'sip:666@192.168.2.55', '', 'Sip-Session', '', '', '0', '0')' " Acct-Session-time is zero showing ? why ? Can U see the below one .... I need to change . please guys help me , this very important to complete the task .... please . rad_recv: Accounting-Request packet from host 192.168.2.55:33879, id=219, length=233 Acct-Status-Type = Stop Service-Type = Sip-Session Sip-Response-Code = 200 Sip-Method = BYE User-Name = "666(a)192.168.2.55" Calling-Station-Id = "sip:666@192.168.2.55" Called-Station-Id = "sip:555@192.168.2.55" Sip-Translated-Request-URI = "sip:555@192.168.2.21:5060" Acct-Session-Id = "76788233-9611-4A96-9FAA-E829F175C69C(a)192.168.2.20 " Sip-To-Tag = "2044753626" Sip-From-Tag = "4110988557" Sip-Cseq = "57538" NAS-Port = 5060 Acct-Delay-Time = 0 NAS-IP-Address = 192.168.2.55 Processing the preacct section of radiusd.conf modcall: entering group preacct for request 2 modcall[preacct]: module "preprocess" returns noop for request 2 rlm_acct_unique: Hashing 'NAS-Port = 5060,Client-IP-Address = 192.168.2.55,NAS-IP-Address = 192.168.2.55,Acct-Session-Id = " 76788233-9611-4A96-9FAA-E829F175C69C(a)192.168.2.20",User-Name = " 666(a)192.168.2.55"' rlm_acct_unique: Acct-Unique-Session-ID = "63170499b83f412d". modcall[preacct]: module "acct_unique" returns ok for request 2 rlm_realm: Looking up realm "192.168.2.55" for User-Name = " 666(a)192.168.2.55" rlm_realm: No such realm "192.168.2.55" modcall[preacct]: module "suffix" returns noop for request 2 modcall[preacct]: module "files" returns noop for request 2 modcall: leaving group preacct (returns ok) for request 2 Processing the accounting section of radiusd.conf modcall: entering group accounting for request 2 radius_xlat: '/usr/local/var/log/radius/radacct/192.168.2.55/detail-20060609' rlm_detail: /usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /usr/local/var/log/radius/radacct/192.168.2.55/detail-20060609 modcall[accounting]: module "detail" returns ok for request 2 radius_xlat: '/usr/local/var/log/radius/radutmp' radius_xlat: '666(a)192.168.2.55' modcall[accounting]: module "radutmp" returns ok for request 2 radius_xlat: '666(a)192.168.2.55' rlm_sql (sql): sql_set_user escaped user --> '666(a)192.168.2.55' radius_xlat: 'UPDATE radacct SET AcctStopTime = '2006-06-09 19:57:27', AcctSessionTime = '', AcctInputOctets = '', AcctOutputOctets = '', AcctTerminateCause = '', AcctStopDelay = '0', ConnectInfo_stop = '' WHERE AcctSessionId = '76788233-9611-4A96-9FAA-E829F175C69C(a)192.168.2.20' AND NASIPAddress = '192.168.2.55'' rlm_sql (sql): Reserving sql socket id: 2 radius_xlat: 'stop packet with zero session length. [user '666(a)192.168.2.55', nas '192.168.2.55']' rlm_sql (sql) in sql_accounting: stop packet with zero session length. [user '666(a)192.168.2.55', nas '192.168.2.55'] rlm_sql (sql): Released sql socket id: 2 radius_xlat: 'INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values(' 76788233-9611-4A96-9FAA-E829F175C69C(a)192.168.2.20', '63170499b83f412d', ' 666(a)192.168.2.55', '', '192.168.2.55', '5060', '', DATE_SUB('2006-06-09 19:57:27', INTERVAL (0 + 0) SECOND), '2006-06-09 19:57:27', '', '', '', '', '', '', 'sip:555@192.168.2.55', 'sip:666@192.168.2.55', '', 'Sip-Session', '', '', '0', '0')' rlm_sql (sql): Released sql socket id: 2 modcall[accounting]: module "sql" returns noop for request 2 modcall: leaving group accounting (returns ok) for request 2 Sending Accounting-Response of id 219 to 192.168.2.55 port 33879 -- Thanks and Regards with cheers Sunkara Ravi Prakash (Voip Developer) Hyperion Technology www.hyperion-tech.com <b>

18 years, 5 months

Re: [Users] openserctl error.

by Ovidiu Sas

What shell are you using? It looks like your shell doesn't understand the setting of GW_IP syntax. -ovi On 6/8/06, Kelvin Williams <kelvin-lists(a)williamschadwell.com> wrote: > > > > > This is a new OpenSER installation on a Solaris 10 box. > > > > Any time we call openserctl we receive the following error: > > > > /usr/local/sbin/openserctl: syntax error at line 1026: `GW_IP=$' unexpected > > > > Line 26 of openserctl reads: > > > > GW_IP=$(($1+$2*256+$3*65536+$4*16777216)) > > > > Any advice would be greatly appreciated! > > > > Thanks, > > kw > > > _______________________________________________ > Users mailing list > Users(a)openser.org > http://openser.org/cgi-bin/mailman/listinfo/users > > >

18 years, 5 months

[Users] insering the 3 record in radius db my using openser+radius+mysql

by raviprakash sunkara

Hi I'm using openser and freeradius server . Accounting part in openser and radius by using the mysql. help me ... Below one is radius server in debug mode..... in that is didn't understand what is " unsupported acct-status-type =15 " and " send packet with zero session length " please help me..... rad_recv: Accounting-Request packet from host 192.168.2.55:35094, id=151, length=220 Acct-Status-Type = Failed Service-Type = Sip-Session Sip-Response-Code = 0 Sip-Method = INVITE User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Calling-Station-Id = "sip:666@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Called-Station-Id = "sip:555@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Sip-Translated-Request-URI = "sip:555@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Acct-Session-Id = "893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Sip-To-Tag = "n/a" Sip-From-Tag = "757680932" Sip-Cseq = "18235" NAS-Port = 5060 Acct-Delay-Time = 0 NAS-IP-Address = 192.168.2.55 Processing the preacct section of radiusd.conf modcall: entering group preacct for request 2 modcall[preacct]: module "preprocess" returns noop for request 2 rlm_realm: Looking up realm "192.168.2.55" for User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " rlm_realm: No such realm "192.168.2.55" modcall[preacct]: module "suffix" returns noop for request 2 modcall: leaving group preacct (returns noop) for request 2 Processing the accounting section of radiusd.conf modcall: entering group accounting for request 2 rlm_acct_unique: Hashing 'NAS-Port = 5060,Client-IP-Address = 192.168.2.55,NAS-IP-Address = 192.168.2.55,Acct-Session-Id = "893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>",User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> "' rlm_acct_unique: Acct-Unique-Session-ID = "5488f64bd8d99c57". modcall[accounting]: module "acct_unique" returns ok for request 2 radius_xlat: '/usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606' rlm_detail: /usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606 modcall[accounting]: module "detail" returns ok for request 2 modcall[accounting]: module "unix" returns noop for request 2 radius_xlat: '/usr/local/var/log/radius/radutmp' rlm_radutmp: NAS radiusdtest port 5060 unknown packet type 15) modcall[accounting]: module "radutmp" returns noop for request 2 rlm_sql (sql): Unsupported Acct-Status-Type = 15 modcall[accounting]: module "sql" returns noop for request 2 modcall: leaving group accounting (returns ok) for request 2 Sending Accounting-Response of id 151 to 192.168.2.55 port 35094 Finished request 2 Going to the next request --- Walking the entire request list --- Waking up in 6 seconds... --- Walking the entire request list --- Cleaning up request 2 ID 151 with timestamp 44857cc6 Nothing to do. Sleeping until we see a request. rad_recv: Accounting-Request packet from host 192.168.2.55:35096, id=152, length=232 Acct-Status-Type = Start Service-Type = Sip-Session Sip-Response-Code = 200 Sip-Method = ACK User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Calling-Station-Id = "sip:666@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Called-Station-Id = "sip:555@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Sip-Translated-Request-URI = "sip:555@192.168.2.21<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> :5060" Acct-Session-Id = "893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Sip-To-Tag = "2710541959" Sip-From-Tag = "757680932" Sip-Cseq = "18235" NAS-Port = 5060 Acct-Delay-Time = 0 NAS-IP-Address = 192.168.2.55 Processing the preacct section of radiusd.conf modcall: entering group preacct for request 3 modcall[preacct]: module "preprocess" returns noop for request 3 rlm_realm: Looking up realm "192.168.2.55" for User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " rlm_realm: No such realm "192.168.2.55" modcall[preacct]: module "suffix" returns noop for request 3 modcall: leaving group preacct (returns noop) for request 3 Processing the accounting section of radiusd.conf modcall: entering group accounting for request 3 rlm_acct_unique: Hashing 'NAS-Port = 5060,Client-IP-Address = 192.168.2.55,NAS-IP-Address = 192.168.2.55,Acct-Session-Id = "893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>",User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> "' rlm_acct_unique: Acct-Unique-Session-ID = "5488f64bd8d99c57". modcall[accounting]: module "acct_unique" returns ok for request 3 radius_xlat: '/usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606' rlm_detail: /usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606 modcall[accounting]: module "detail" returns ok for request 3 modcall[accounting]: module "unix" returns ok for request 3 radius_xlat: '/usr/local/var/log/radius/radutmp' radius_xlat: '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ' modcall[accounting]: module "radutmp" returns ok for request 3 radius_xlat: '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ' rlm_sql (sql): sql_set_user escaped user --> '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ' radius_xlat: 'INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ', '5488f64bd8d99c57', '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', '', '192.168.2.55', '5060', '', '2006-06-06 18:32:05', '0', '0', '', '', '', '0', '0', 'sip:555@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', 'sip:666@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', '', 'Sip-Session', '', '', '0', '0')' rlm_sql (sql): Reserving sql socket id: 2 rlm_sql (sql): Released sql socket id: 2 modcall[accounting]: module "sql" returns ok for request 3 modcall: leaving group accounting (returns ok) for request 3 Sending Accounting-Response of id 152 to 192.168.2.55 port 35096 Finished request 3 Going to the next request --- Walking the entire request list --- Waking up in 6 seconds... --- Walking the entire request list --- Cleaning up request 3 ID 152 with timestamp 44857ccd Nothing to do. Sleeping until we see a request. rad_recv: Accounting-Request packet from host 192.168.2.55:35097, id=153, length=232 Acct-Status-Type = Stop Service-Type = Sip-Session Sip-Response-Code = 200 Sip-Method = BYE User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Calling-Station-Id = "sip:666@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Called-Station-Id = "sip:555@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Sip-Translated-Request-URI = "sip:555@192.168.2.21<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> :5060" Acct-Session-Id = "893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Sip-To-Tag = "2710541959" Sip-From-Tag = "757680932" Sip-Cseq = "18236" NAS-Port = 5060 Acct-Delay-Time = 0 NAS-IP-Address = 192.168.2.55 Processing the preacct section of radiusd.conf modcall: entering group preacct for request 4 modcall[preacct]: module "preprocess" returns noop for request 4 rlm_realm: Looking up realm "192.168.2.55" for User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " rlm_realm: No such realm "192.168.2.55" modcall[preacct]: module "suffix" returns noop for request 4 modcall: leaving group preacct (returns noop) for request 4 Processing the accounting section of radiusd.conf modcall: entering group accounting for request 4 rlm_acct_unique: Hashing 'NAS-Port = 5060,Client-IP-Address = 192.168.2.55,NAS-IP-Address = 192.168.2.55,Acct-Session-Id = "893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>",User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> "' rlm_acct_unique: Acct-Unique-Session-ID = "5488f64bd8d99c57". modcall[accounting]: module "acct_unique" returns ok for request 4 radius_xlat: '/usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606' rlm_detail: /usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606 modcall[accounting]: module "detail" returns ok for request 4 modcall[accounting]: module "unix" returns ok for request 4 radius_xlat: '/usr/local/var/log/radius/radutmp' radius_xlat: '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ' modcall[accounting]: module "radutmp" returns ok for request 4 radius_xlat: '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ' rlm_sql (sql): sql_set_user escaped user --> '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ' radius_xlat: 'UPDATE radacct SET AcctStopTime = '2006-06-06 18:34:11', AcctSessionTime = '', AcctInputOctets = '', AcctOutputOctets = '', AcctTerminateCause = '', AcctStopDelay = '0', ConnectInfo_stop = '' WHERE AcctSessionId = '893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>' AND UserName = '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>' AND NASIPAddress = '192.168.2.55'' rlm_sql (sql): Reserving sql socket id: 1 radius_xlat: 'stop packet with zero session length. [user '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', nas '192.168.2.55']' rlm_sql (sql) in sql_accounting: stop packet with zero session length. [user '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', nas '192.168.2.55'] rlm_sql (sql): Released sql socket id: 1 radius_xlat: 'INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ', '5488f64bd8d99c57', '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', '', '192.168.2.55', '5060', '', DATE_SUB('2006-06-06 18:34:11', INTERVAL (0 + 0) SECOND), '2006-06-06 18:34:11', '', '', '', '', '', '', 'sip:555@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ', 'sip:666@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', '', 'Sip-Session', '', '', '0', '0')' rlm_sql (sql): Released sql socket id: 1 modcall[accounting]: module "sql" returns noop for request 4 modcall: leaving group accounting (returns ok) for request 4 Sending Accounting-Response of id 153 to 192.168.2.55 port 35097 Finished request 4 Going to the next request --- Walking the entire request list --- Waking up in 6 seconds... rad_recv: Accounting-Request packet from host 192.168.2.55:35098, id=154, length=232 Acct-Status-Type = Stop Service-Type = Sip-Session Sip-Response-Code = 200 Sip-Method = BYE User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Calling-Station-Id = "sip:666@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Called-Station-Id = "sip:555@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Sip-Translated-Request-URI = "sip:555@192.168.2.21<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> :5060" Acct-Session-Id = "893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " Sip-To-Tag = "2710541959" Sip-From-Tag = "757680932" Sip-Cseq = "18236" NAS-Port = 5060 Acct-Delay-Time = 0 NAS-IP-Address = 192.168.2.55 Processing the preacct section of radiusd.conf modcall: entering group preacct for request 5 modcall[preacct]: module "preprocess" returns noop for request 5 rlm_realm: Looking up realm "192.168.2.55" for User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> " rlm_realm: No such realm "192.168.2.55" modcall[preacct]: module "suffix" returns noop for request 5 modcall: leaving group preacct (returns noop) for request 5 Processing the accounting section of radiusd.conf modcall: entering group accounting for request 5 rlm_acct_unique: Hashing 'NAS-Port = 5060,Client-IP-Address = 192.168.2.55,NAS-IP-Address = 192.168.2.55,Acct-Session-Id = "893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>",User-Name = "666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> "' rlm_acct_unique: Acct-Unique-Session-ID = "5488f64bd8d99c57". modcall[accounting]: module "acct_unique" returns ok for request 5 radius_xlat: '/usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606' rlm_detail: /usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /usr/local/var/log/radius/radacct/192.168.2.55/detail-20060606 modcall[accounting]: module "detail" returns ok for request 5 modcall[accounting]: module "unix" returns ok for request 5 radius_xlat: '/usr/local/var/log/radius/radutmp' radius_xlat: '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ' rlm_radutmp: Logout for NAS radiusdtest port 5060, but no Login record modcall[accounting]: module "radutmp" returns ok for request 5 radius_xlat: '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ' rlm_sql (sql): sql_set_user escaped user --> '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ' radius_xlat: 'UPDATE radacct SET AcctStopTime = '2006-06-06 18:34:11', AcctSessionTime = '', AcctInputOctets = '', AcctOutputOctets = '', AcctTerminateCause = '', AcctStopDelay = '0', ConnectInfo_stop = '' WHERE AcctSessionId = '893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>' AND UserName = '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>' AND NASIPAddress = '192.168.2.55'' rlm_sql (sql): Reserving sql socket id: 0 radius_xlat: 'stop packet with zero session length. [user '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', nas '192.168.2.55']' rlm_sql (sql) in sql_accounting: stop packet with zero session length. [user '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', nas '192.168.2.55'] rlm_sql (sql): Released sql socket id: 0 radius_xlat: 'INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('893D5817-07A7-40D2-B0A8-987237749015(a)192.168.2.20<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ', '5488f64bd8d99c57', '666(a)192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', '', '192.168.2.55', '5060', '', DATE_SUB('2006-06-06 18:34:11', INTERVAL (0 + 0) SECOND), '2006-06-06 18:34:11', '', '', '', '', '', '', 'sip:555@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…> ', 'sip:666@192.168.2.55<https://email.secureserver.net/view.php?folder=INBOX.Sent_Items&uid=70#Comp…>', '', 'Sip-Session', '', '', '0', '0')' rlm_sql (sql): Released sql socket id: 0 -- Thanks and Regards with cheers Sunkara Ravi Prakash (Voip Developer) Hyperion Technology www.hyperion-tech.com <b>

18 years, 5 months

RE: [Users] openserctl error.

by Edson

First rule on scripting debug: use 'echo'.. ;) Try to include, just before line 26, a command like 'echo "[$1+$2*256+$3*65536+$4*16777216]" > ~/DEBUG' Run it again and take a look on the contends of '~/DEBUG' I hope that You would be able to find Your way out.. ;) Edson. _____ From: users-bounces(a)openser.org [mailto:users-bounces@openser.org] On Behalf Of Kelvin Williams Sent: sexta-feira, 9 de junho de 2006 08:32 To: 'ram'; users(a)openser.org Subject: RE: [Users] openserctl error. # # $Id: openser.cfg,v 1.5 2005/10/28 19:45:33 bogdan_iancu Exp $ # # simple quick-start config script # # ----------- global configuration parameters ------------------------ debug=3 # debug level (cmd line: -dddddddddd) fork=yes log_stderror=no # (cmd line: -E) /* Uncomment these lines to enter debugging mode fork=no log_stderror=yes */ check_via=no # (cmd. line: -v) dns=no # (cmd. line: -r) rev_dns=no # (cmd. line: -R) port=5060 children=4 fifo="/tmp/openser_fifo" # # uncomment the following lines for TLS support #disable_tls = 0 #listen = tls:your_IP:5061 #tls_verify = 1 #tls_require_certificate = 0 #tls_method = TLSv1 #tls_certificate = "/usr/local/etc/openser/tls/user/user-cert.pem" #tls_private_key = "/usr/local/etc/openser/tls/user/user-privkey.pem" #tls_ca_list = "/usr/local/etc/openser/tls/user/user-calist.pem" # ------------------ module loading ---------------------------------- # Uncomment this if you want to use SQL database #loadmodule "/usr/local/lib/openser/modules/mysql.so" loadmodule "/usr/local/lib/openser/modules/sl.so" loadmodule "/usr/local/lib/openser/modules/tm.so" loadmodule "/usr/local/lib/openser/modules/rr.so" loadmodule "/usr/local/lib/openser/modules/maxfwd.so" loadmodule "/usr/local/lib/openser/modules/usrloc.so" loadmodule "/usr/local/lib/openser/modules/registrar.so" loadmodule "/usr/local/lib/openser/modules/textops.so" # Uncomment this if you want digest authentication # mysql.so must be loaded ! #loadmodule "/usr/local/lib/openser/modules/auth.so" #loadmodule "/usr/local/lib/openser/modules/auth_db.so" # ----------------- setting module-specific parameters --------------- # -- usrloc params -- modparam("usrloc", "db_mode", 0) # Uncomment this if you want to use SQL database # for persistent storage and comment the previous line #modparam("usrloc", "db_mode", 2) # -- auth params -- # Uncomment if you are using auth module # #modparam("auth_db", "calculate_ha1", yes) # # If you set "calculate_ha1" parameter to yes (which true in this config), # uncomment also the following parameter) # #modparam("auth_db", "password_column", "password") # -- rr params -- # add value to ;lr param to make some broken UAs happy modparam("rr", "enable_full_lr", 1) # ------------------------- request routing logic ------------------- # main routing logic route{ # initial sanity checks -- messages with # max_forwards==0, or excessively long requests if (!mf_process_maxfwd_header("10")) { sl_send_reply("483","Too Many Hops"); exit; }; if (msg:len >= 2048 ) { sl_send_reply("513", "Message too big"); exit; }; # we record-route all messages -- to make sure that # subsequent messages will go through our proxy; that's # particularly good if upstream and downstream entities # use different transport protocol if (!method=="REGISTER") record_route(); # subsequent messages withing a dialog should take the # path determined by record-routing if (loose_route()) { # mark routing logic in request append_hf("P-hint: rr-enforced\r\n"); route(1); }; if (!uri==myself) { # mark routing logic in request append_hf("P-hint: outbound\r\n"); # if you have some interdomain connections via TLS #if(uri=~"@tls_domain1.net") { # t_relay_to_tls("IP_domain1","port_domain1"); # exit; #} else if(uri=~"@tls_domain2.net") { # t_relay_to_tls("IP_domain2","port_domain2"); # exit; #} route(1); }; # if the request is for other domain use UsrLoc # (in case, it does not work, use the following command # with proper names and addresses in it) if (uri==myself) { if (method=="REGISTER") { # Uncomment this if you want to use digest authentication #if (!www_authorize("openser.org", "subscriber")) { # www_challenge("openser.org", "0"); # exit; #}; save("location"); exit; }; lookup("aliases"); if (!uri==myself) { append_hf("P-hint: outbound alias\r\n"); route(1); }; # native SIP destinations are handled using our USRLOC DB if (!lookup("location")) { sl_send_reply("404", "Not Found"); exit; }; append_hf("P-hint: usrloc applied\r\n"); }; route(1); } route[1] { # send it out now; use stateful forwarding as it works reliably # even for UDP2TCP if (!t_relay()) { sl_reply_error(); }; exit; } _____ From: ram [mailto:talk2ram@gmail.com] Sent: Friday, June 09, 2006 1:33 AM To: Kelvin Williams Subject: Re: [Users] openserctl error. post ur config file to assist ram On 6/9/06, Kelvin Williams <kelvin-lists(a)williamschadwell.com> wrote: This is a new OpenSER installation on a Solaris 10 box. Any time we call openserctl we receive the following error: /usr/local/sbin/openserctl: syntax error at line 1026: `GW_IP=$' unexpected Line 26 of openserctl reads: GW_IP=$(($1+$2*256+$3*65536+$4*16777216)) Any advice would be greatly appreciated! Thanks, kw _______________________________________________ Users mailing list Users(a)openser.org http://openser.org/cgi-bin/mailman/listinfo/users

18 years, 5 months

[Serusers] Problem in starting SER

by sumit dengri

sir when I start SER using "serctl start ser" command it showed following error message: Starting SER : cat: /var/run/ser.pid: No such file or directory started pid() Also there is no entry of ser in /etc/init.d PLZ help me out. Send instant messages to your online friends http://in.messenger.yahoo.com <br><br> Stay connected with your friends even when away from PC. Link: http://in.mobile.yahoo.com/new/messenger/

18 years, 5 months

[Serusers] RE: novice issue

by Shyamsundar, Purkayastha (Purkayastha)** CTR **

I fixed the problem which was basically a path issue but now it is cribbing for mysql.so The path is correct but when I run "./ser -c" I get the following output ./ser -c 0(4472) ERROR: load_module: could not open module </usr/local/lib/ser/modules/mysql.so>: libmysqlclient.so.12: cannot open shared object file: No such file or directory How do I sort it out?? thanks Shyam > -----Original Message----- > From: Shyamsundar, Purkayastha (Purkayastha)** CTR ** > Sent: Thursday, June 08, 2006 4:48 PM > To: 'serusers(a)lists.iptel.org' > Subject: novice issue > > Hi all > > Just started using ser but i am stuck at the first step itself > > i downloaded ser-0.9.6_linux_i386.tar > > untared it , set the cfg file and modules in correct path as per cfg file > and ran ./ser from the sbin directory > > and it says > > ERROR in cfg file ( 24 errors) > > if i comment out the loadmodule statements on the cfg files then the > errors reduce but inspite of verifying the correct path several times its > not getting through. > That means its reading the cfg file correctly but not loading the modules > or not able to interpret loadmodule command maybe > > Please help me > > thanks in advance > Shyam > >

18 years, 5 months

← Newer
1
...
33
34
35
36
37
38
39
...
50
Older →

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

sr-users June 2006