sr-users

sr-users@lists.kamailio.org

10 participants
37461 discussions

Start a nNew thread

[Serusers] how to catch an asterisk *
by bails 09 Jun '06

09 Jun '06

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

3 2

Re: [Users] openserctl error.
by Daniel-Constantin Mierla 09 Jun '06

09 Jun '06

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 > >

1 0

[Users] rlm_sql is not updating the record...
by raviprakash sunkara 09 Jun '06

09 Jun '06

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>

1 0

Re: [Users] openserctl error.
by Ovidiu Sas 09 Jun '06

09 Jun '06

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 > > >

3 2

[Users] insering the 3 record in radius db my using openser+radius+mysql
by raviprakash sunkara 09 Jun '06

09 Jun '06

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>

2 1

RE: [Users] openserctl error.
by Edson 09 Jun '06

09 Jun '06

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

1 0

[Serusers] Problem in starting SER
by sumit dengri 09 Jun '06

09 Jun '06

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/

4 3

[Serusers] RE: novice issue
by Shyamsundar, Purkayastha (Purkayastha)** CTR ** 09 Jun '06

09 Jun '06

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 > >

4 6

RE: [Users] openserctl error.
by Kelvin Williams 09 Jun '06

09 Jun '06

# # $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

1 0

[Serusers] ser.cfg Operators and Operands
by Szabolcs Szasz 09 Jun '06

09 Jun '06

Hi All! What is the correct operand in a condtional statement for negation? I have a problem in a ser.cfg line: if (uri=~"sip:0[1-9][0-9]*@.*" && uri!="sip:01234[6-9][0-9]@.*") The SER doesn't take in consideration the 2nd part of the conditional statement after the && operand. What is wrong in this line? Thanks! Szasz Szabolcs -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/

2 1

Jump to page:

2025

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