Hi DanB,

I updated the CDRTool to version 6.6.8 and freeradius-cdrtool to version 1.2-pre. I'm getting this log and not doing the Debit.

Sep 30 09:57:22 sipserver1 cdrtool[12948]: DebitBalance CallId=000d6570-880e0035-39c8f267-5c77e9d2@192.168.0.1 From=87001@mydomain.com.br To=sip:00551599998888@mydomain.com.br Gateway=127.0.0.1 Duration=11 Sep 30 09:57:22 sipserver1 cdrtool[12948]: ConnectFee=0.00 Span=1 Duration=60 DestId=55159 domain=mydomain.com.br Profile=551 Period=weekday Rate=551 Interval=0-24 Cost=0.85/60 Price=0.8500 Sep 30 09:57:22 sipserver1 cdrtool[12948]: Error: session 000d6570-880e0035-39c8f267-5c77e9d2@192.168.0.1 for 87001@mydomain.com.br does not exist

Thanks. Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 5:47 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Hi Diego,

you don't need to set anything in Users file. The connector does that for you dynamically, based on the responses received from cdrtool. Your configuration will be static and always limit the user to the same call duration. For more information, see the README file within freeradius-cdrtool source directory.

Cheers, DanB

On Mon, Sep 29, 2008 at 10:49 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

Hi all,

How I send to freeradius-cdrtool the maxCallDuration and UserCredit? On the /etc/raddb/users I have:

87001@mydomain.com.br Auth-Type := Digest, User-Password == "mypassword" Reply-Message = "Authenticated", SIP-AVP = "authentic#1", SIP-AVP = "callMaxDur:60", SIP-AVP = "credit:25"

Is this correct ?

Thanks. Diego.

_______________________________________________ Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

DanB,

Yes, I changed the kamailio.cfg. I´m sending the full log of radius attached.

Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 10:34 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Diego,

looks like there was no session started at first place. Did u change the openser.cfg config? You need to add callid into radius_proxy_authorize so that the callid should be used (example in README.txt of the freeradius-cdrtool sources).

Also, can u post a full authorize/account_start/account_stop sequence as logged by "radiusd -X".

DanB

On Tue, Sep 30, 2008 at 3:00 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

Hi DanB,

I updated the CDRTool to version 6.6.8 and freeradius-cdrtool to version 1.2-pre. I'm getting this log and not doing the Debit.

Sep 30 09:57:22 sipserver1 cdrtool[12948]: DebitBalance CallId=000d6570-880e0035-39c8f267-5c77e9d2@192.168.0.1 From=87001@mydomain.com.br To=sip:00551599998888@mydomain.com.br Gateway=127.0.0.1 Duration=11 Sep 30 09:57:22 sipserver1 cdrtool[12948]: ConnectFee=0.00 Span=1 Duration=60 DestId=55159 domain=mydomain.com.br Profile=551 Period=weekday Rate=551 Interval=0-24 Cost=0.85/60 Price=0.8500 Sep 30 09:57:22 sipserver1 cdrtool[12948]: Error: session 000d6570-880e0035-39c8f267-5c77e9d2@192.168.0.1 for 87001@mydomain.com.br does not exist

Thanks. Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 5:47 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Hi Diego,

you don't need to set anything in Users file. The connector does that for you dynamically, based on the responses received from cdrtool. Your configuration will be static and always limit the user to the same call duration. For more information, see the README file within freeradius-cdrtool source directory.

Cheers, DanB

On Mon, Sep 29, 2008 at 10:49 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

Hi all,

How I send to freeradius-cdrtool the maxCallDuration and UserCredit? On the /etc/raddb/users I have:

87001@mydomain.com.br Auth-Type := Digest, User-Password == "mypassword" Reply-Message = "Authenticated", SIP-AVP = "authentic#1", SIP-AVP = "callMaxDur:60", SIP-AVP = "credit:25"

Is this correct ?

Thanks. Diego.

_______________________________________________ Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

I'm using the freeradius 1.1.7, and not patched the rlm_digest. Where to find the patch rlm_digest ?

Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 11:08 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Diego,

the problem is with your digest module which is sanitizing the parameters in authentication phase only, therefore the parameters like Username, Digest-URI are not available in the authorization phase (no way for the connector to read them). Did u patch your rlm_digest as per the README.txt? What version of freeradius are u using?

DanB

On Tue, Sep 30, 2008 at 3:56 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

DanB,

Yes, I changed the kamailio.cfg. I´m sending the full log of radius attached.

Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 10:34 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Diego,

looks like there was no session started at first place. Did u change the openser.cfg config? You need to add callid into radius_proxy_authorize so that the callid should be used (example in README.txt of the freeradius-cdrtool sources).

Also, can u post a full authorize/account_start/account_stop sequence as logged by "radiusd -X".

DanB

On Tue, Sep 30, 2008 at 3:00 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

Hi DanB,

I updated the CDRTool to version 6.6.8 and freeradius-cdrtool to version 1.2-pre. I'm getting this log and not doing the Debit.

Sep 30 09:57:22 sipserver1 cdrtool[12948]: DebitBalance CallId=000d6570-880e0035-39c8f267-5c77e9d2@192.168.0.1 From=87001@mydomain.com.br To=sip:00551599998888@mydomain.com.br Gateway=127.0.0.1 Duration=11 Sep 30 09:57:22 sipserver1 cdrtool[12948]: ConnectFee=0.00 Span=1 Duration=60 DestId=55159 domain=mydomain.com.br Profile=551 Period=weekday Rate=551 Interval=0-24 Cost=0.85/60 Price=0.8500 Sep 30 09:57:22 sipserver1 cdrtool[12948]: Error: session 000d6570-880e0035-39c8f267-5c77e9d2@192.168.0.1 for 87001@mydomain.com.br does not exist

Thanks. Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 5:47 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Hi Diego,

you don't need to set anything in Users file. The connector does that for you dynamically, based on the responses received from cdrtool. Your configuration will be static and always limit the user to the same call duration. For more information, see the README file within freeradius-cdrtool source directory.

Cheers, DanB

On Mon, Sep 29, 2008 at 10:49 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

Hi all,

How I send to freeradius-cdrtool the maxCallDuration and UserCredit? On the /etc/raddb/users I have:

87001@mydomain.com.br Auth-Type := Digest, User-Password == "mypassword" Reply-Message = "Authenticated", SIP-AVP = "authentic#1", SIP-AVP = "callMaxDur:60", SIP-AVP = "credit:25"

Is this correct ?

Thanks. Diego.

_______________________________________________ Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

Thanks DanB, the problem was solved. How send BYE when expires credit in conversation?

Thanks. Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 11:19 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Here is an already patched version: http://frad-cdrtool.sourceforge.net/rlm_digest.c You should replace your rlm_digest.c with this one and recompile the server.

DanB

On Tue, Sep 30, 2008 at 4:14 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

I'm using the freeradius 1.1.7, and not patched the rlm_digest. Where to find the patch rlm_digest ?

Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 11:08 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Diego,

the problem is with your digest module which is sanitizing the parameters in authentication phase only, therefore the parameters like Username, Digest-URI are not available in the authorization phase (no way for the connector to read them). Did u patch your rlm_digest as per the README.txt? What version of freeradius are u using?

DanB

On Tue, Sep 30, 2008 at 3:56 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

DanB,

Yes, I changed the kamailio.cfg. I´m sending the full log of radius attached.

Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 10:34 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Diego,

looks like there was no session started at first place. Did u change the openser.cfg config? You need to add callid into radius_proxy_authorize so that the callid should be used (example in README.txt of the freeradius-cdrtool sources).

Also, can u post a full authorize/account_start/account_stop sequence as logged by "radiusd -X".

DanB

On Tue, Sep 30, 2008 at 3:00 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

Hi DanB,

I updated the CDRTool to version 6.6.8 and freeradius-cdrtool to version 1.2-pre. I'm getting this log and not doing the Debit.

Sep 30 09:57:22 sipserver1 cdrtool[12948]: DebitBalance CallId=000d6570-880e0035-39c8f267-5c77e9d2@192.168.0.1 From=87001@mydomain.com.br To=sip:00551599998888@mydomain.com.br Gateway=127.0.0.1 Duration=11 Sep 30 09:57:22 sipserver1 cdrtool[12948]: ConnectFee=0.00 Span=1 Duration=60 DestId=55159 domain=mydomain.com.br Profile=551 Period=weekday Rate=551 Interval=0-24 Cost=0.85/60 Price=0.8500 Sep 30 09:57:22 sipserver1 cdrtool[12948]: Error: session 000d6570-880e0035-39c8f267-5c77e9d2@192.168.0.1 for 87001@mydomain.com.br does not exist

Thanks. Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 5:47 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Hi Diego,

you don't need to set anything in Users file. The connector does that for you dynamically, based on the responses received from cdrtool. Your configuration will be static and always limit the user to the same call duration. For more information, see the README file within freeradius-cdrtool source directory.

Cheers, DanB

On Mon, Sep 29, 2008 at 10:49 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

Hi all,

How I send to freeradius-cdrtool the maxCallDuration and UserCredit? On the /etc/raddb/users I have:

87001@mydomain.com.br Auth-Type := Digest, User-Password == "mypassword" Reply-Message = "Authenticated", SIP-AVP = "authentic#1", SIP-AVP = "callMaxDur:60", SIP-AVP = "credit:25"

Is this correct ?

Thanks. Diego.

_______________________________________________ Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

DanB,

I'm testing the freeradius-cdrtool, and found a possible problem. When I turn off the call before answer, the session is not finished. Here's a part of the logs:

rlm_python [freeradius-cdrtool]: Entering accounting section rlm_python [freeradius-cdrtool]: Got the following params: (('Acct-Status-Type', 'Failed'), ('Service-Type', 'Sip-Session'), ('Sip-Response-Code', '503'), ('Sip-Method', 'Invite'), ('X-Ascend-Bridge', '0x694de248a0b22d087cf199b7'), ('Sip-From-Tag', '"000d6570880e01462b3c62f9-0908d279"'), ('Acct-Session-Id', '"000d6570-880e0028-2a382841-1ef5c833@200.187.80.9"'), ('User-Name', '"87001@fastervoip.com.br"'), ('Calling-Station-Id', '"sip:87001@fastervoip.com.br"'), ('Called-Station-Id', '"sip:01591184701@fastervoip.com.br"'), ('Sip-Translated-Request-URI', '"sip:01591184701@200.187.80.17:5060;transport=udp"'), ('Sip-Rpid', '"87001"'), ('Source-IP', '"200.187.80.9"'), ('Source-Port', '"5070"'), ('Acct-Authentic', '49'), ('SIP-Proxy-IP', '"127.0.0.1"'), ('Canonical-URI', '"sip:01591184701@fastervoip.com.br"'), ('Billing-Party', '"87001@fastervoip.com.br"'), ('Contact', '"sip:87001@200.187.80.9:5070;transport=udp"'), ('NAS-Port', '5060'), ('Acct-Delay-Time', '0'), ('NAS-IP-Address', '127.0.0.1'), ('Client-IP-Address', '127.0.0.1'), ('Acct-Unique-Session-Id', '"3db548b64d9445ce"')) rlm_python [freeradius-cdrtool]: Extracted atribute <Acct-Status-Type> with value <Failed> rlm_python [freeradius-cdrtool]: Extracted atribute <User-Name> with value 87001@fastervoip.com.br rlm_python [freeradius-cdrtool]: Extracted atribute <Canonical-URI> with value sip:01591184701@fastervoip.com.br rlm_python [freeradius-cdrtool]: Extracted atribute <Called-Station-Id> with value sip:01591184701@fastervoip.com.br rlm_python [freeradius-cdrtool]: Extracted atribute <Acct-Session-Id> with value 000d6570-880e0028-2a382841-1ef5c833@200.187.80.9 rlm_python:EXCEPT:<type 'exceptions.TypeError'>: end_session() takes exactly 6 arguments (4 given) modcall[accounting]: module "python" returns ?? for request 261 modcall: leaving group accounting (returns ok) for request 261 Sending Accounting-Response of id 147 to 127.0.0.1 port 41560 Finished request 261

Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 11:54 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

"The avps received will be available in openser as: callMaxDur and credit, where callMaxDur is the maximum duration the user is allowed to be connected with the destination and credit represents the amount of credit available at starting of the call. This info can be used later in an bbua able to timeout calls based on duration. "

On Tue, Sep 30, 2008 at 4:38 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

Thanks DanB, the problem was solved. How send BYE when expires credit in conversation?

Thanks. Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 11:19 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Here is an already patched version: http://frad-cdrtool.sourceforge.net/rlm_digest.c You should replace your rlm_digest.c with this one and recompile the server.

DanB

On Tue, Sep 30, 2008 at 4:14 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

I'm using the freeradius 1.1.7, and not patched the rlm_digest. Where to find the patch rlm_digest ?

Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 11:08 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Diego,

the problem is with your digest module which is sanitizing the parameters in authentication phase only, therefore the parameters like Username, Digest-URI are not available in the authorization phase (no way for the connector to read them). Did u patch your rlm_digest as per the README.txt? What version of freeradius are u using?

DanB

On Tue, Sep 30, 2008 at 3:56 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

DanB,

Yes, I changed the kamailio.cfg. I´m sending the full log of radius attached.

Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 10:34 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Diego,

looks like there was no session started at first place. Did u change the openser.cfg config? You need to add callid into radius_proxy_authorize so that the callid should be used (example in README.txt of the freeradius-cdrtool sources).

Also, can u post a full authorize/account_start/account_stop sequence as logged by "radiusd -X".

DanB

On Tue, Sep 30, 2008 at 3:00 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

Hi DanB,

I updated the CDRTool to version 6.6.8 and freeradius-cdrtool to version 1.2-pre. I'm getting this log and not doing the Debit.

Sep 30 09:57:22 sipserver1 cdrtool[12948]: DebitBalance CallId=000d6570-880e0035-39c8f267-5c77e9d2@192.168.0.1 From=87001@mydomain.com.br To=sip:00551599998888@mydomain.com.br Gateway=127.0.0.1 Duration=11 Sep 30 09:57:22 sipserver1 cdrtool[12948]: ConnectFee=0.00 Span=1 Duration=60 DestId=55159 domain=mydomain.com.br Profile=551 Period=weekday Rate=551 Interval=0-24 Cost=0.85/60 Price=0.8500 Sep 30 09:57:22 sipserver1 cdrtool[12948]: Error: session 000d6570-880e0035-39c8f267-5c77e9d2@192.168.0.1 for 87001@mydomain.com.br does not exist

Thanks. Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 5:47 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Hi Diego,

you don't need to set anything in Users file. The connector does that for you dynamically, based on the responses received from cdrtool. Your configuration will be static and always limit the user to the same call duration. For more information, see the README file within freeradius-cdrtool source directory.

Cheers, DanB

On Mon, Sep 29, 2008 at 10:49 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

Hi all,

How I send to freeradius-cdrtool the maxCallDuration and UserCredit? On the /etc/raddb/users I have:

87001@mydomain.com.br Auth-Type := Digest, User-Password == "mypassword" Reply-Message = "Authenticated", SIP-AVP = "authentic#1", SIP-AVP = "callMaxDur:60", SIP-AVP = "credit:25"

Is this correct ?

Thanks. Diego.

_______________________________________________ Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

DanB,

The problem was solved with the new version. I don't understand very well the python language. It's possible to return SIP-AVP = nocredit#1 when the user have no credits? So I can return a message to the user saying he has no credits.

Thanks again. Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 3:15 PM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Hi Diego,

fixed now in pre2.

Cheers, DanB

On Tue, Sep 30, 2008 at 5:58 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

DanB,

I'm testing the freeradius-cdrtool, and found a possible problem. When I turn off the call before answer, the session is not finished. Here's a part of the logs:

rlm_python [freeradius-cdrtool]: Entering accounting section rlm_python [freeradius-cdrtool]: Got the following params: (('Acct-Status-Type', 'Failed'), ('Service-Type', 'Sip-Session'), ('Sip-Response-Code', '503'), ('Sip-Method', 'Invite'), ('X-Ascend-Bridge', '0x694de248a0b22d087cf199b7'), ('Sip-From-Tag', '"000d6570880e01462b3c62f9-0908d279"'), ('Acct-Session-Id', '"000d6570-880e0028-2a382841-1ef5c833@200.187.80.9"'), ('User-Name', '"87001@fastervoip.com.br"'), ('Calling-Station-Id', '"sip:87001@fastervoip.com.br"'), ('Called-Station-Id', '"sip:01591184701@fastervoip.com.br"'), ('Sip-Translated-Request-URI', '"sip:01591184701@200.187.80.17:5060;transport=udp"'), ('Sip-Rpid', '"87001"'), ('Source-IP', '"200.187.80.9"'), ('Source-Port', '"5070"'), ('Acct-Authentic', '49'), ('SIP-Proxy-IP', '"127.0.0.1"'), ('Canonical-URI', '"sip:01591184701@fastervoip.com.br"'), ('Billing-Party', '"87001@fastervoip.com.br"'), ('Contact', '"sip:87001@200.187.80.9:5070;transport=udp"'), ('NAS-Port', '5060'), ('Acct-Delay-Time', '0'), ('NAS-IP-Address', '127.0.0.1'), ('Client-IP-Address', '127.0.0.1'), ('Acct-Unique-Session-Id', '"3db548b64d9445ce"')) rlm_python [freeradius-cdrtool]: Extracted atribute <Acct-Status-Type> with value <Failed> rlm_python [freeradius-cdrtool]: Extracted atribute <User-Name> with value 87001@fastervoip.com.br rlm_python [freeradius-cdrtool]: Extracted atribute <Canonical-URI> with value sip:01591184701@fastervoip.com.br rlm_python [freeradius-cdrtool]: Extracted atribute <Called-Station-Id> with value sip:01591184701@fastervoip.com.br rlm_python [freeradius-cdrtool]: Extracted atribute <Acct-Session-Id> with value 000d6570-880e0028-2a382841-1ef5c833@200.187.80.9 rlm_python:EXCEPT:<type 'exceptions.TypeError'>: end_session() takes exactly 6 arguments (4 given) modcall[accounting]: module "python" returns ?? for request 261 modcall: leaving group accounting (returns ok) for request 261 Sending Accounting-Response of id 147 to 127.0.0.1 port 41560 Finished request 261

Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 11:54 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

"The avps received will be available in openser as: callMaxDur and credit, where callMaxDur is the maximum duration the user is allowed to be connected with the destination and credit represents the amount of credit available at starting of the call. This info can be used later in an bbua able to timeout calls based on duration. "

On Tue, Sep 30, 2008 at 4:38 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

Thanks DanB, the problem was solved. How send BYE when expires credit in conversation?

Thanks. Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 11:19 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Here is an already patched version: http://frad-cdrtool.sourceforge.net/rlm_digest.c You should replace your rlm_digest.c with this one and recompile the server.

DanB

On Tue, Sep 30, 2008 at 4:14 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

I'm using the freeradius 1.1.7, and not patched the rlm_digest. Where to find the patch rlm_digest ?

Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 11:08 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Diego,

the problem is with your digest module which is sanitizing the parameters in authentication phase only, therefore the parameters like Username, Digest-URI are not available in the authorization phase (no way for the connector to read them). Did u patch your rlm_digest as per the README.txt? What version of freeradius are u using?

DanB

On Tue, Sep 30, 2008 at 3:56 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

DanB,

Yes, I changed the kamailio.cfg. I´m sending the full log of radius attached.

Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 10:34 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Diego,

looks like there was no session started at first place. Did u change the openser.cfg config? You need to add callid into radius_proxy_authorize so that the callid should be used (example in README.txt of the freeradius-cdrtool sources).

Also, can u post a full authorize/account_start/account_stop sequence as logged by "radiusd -X".

DanB

On Tue, Sep 30, 2008 at 3:00 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

Hi DanB,

I updated the CDRTool to version 6.6.8 and freeradius-cdrtool to version 1.2-pre. I'm getting this log and not doing the Debit.

Sep 30 09:57:22 sipserver1 cdrtool[12948]: DebitBalance CallId=000d6570-880e0035-39c8f267-5c77e9d2@192.168.0.1 From=87001@mydomain.com.br To=sip:00551599998888@mydomain.com.br Gateway=127.0.0.1 Duration=11 Sep 30 09:57:22 sipserver1 cdrtool[12948]: ConnectFee=0.00 Span=1 Duration=60 DestId=55159 domain=mydomain.com.br Profile=551 Period=weekday Rate=551 Interval=0-24 Cost=0.85/60 Price=0.8500 Sep 30 09:57:22 sipserver1 cdrtool[12948]: Error: session 000d6570-880e0035-39c8f267-5c77e9d2@192.168.0.1 for 87001@mydomain.com.br does not exist

Thanks. Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 5:47 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Hi Diego,

you don't need to set anything in Users file. The connector does that for you dynamically, based on the responses received from cdrtool. Your configuration will be static and always limit the user to the same call duration. For more information, see the README file within freeradius-cdrtool source directory.

Cheers, DanB

On Mon, Sep 29, 2008 at 10:49 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

Hi all,

How I send to freeradius-cdrtool the maxCallDuration and UserCredit? On the /etc/raddb/users I have:

87001@mydomain.com.br Auth-Type := Digest, User-Password == "mypassword" Reply-Message = "Authenticated", SIP-AVP = "authentic#1", SIP-AVP = "callMaxDur:60", SIP-AVP = "credit:25"

Is this correct ?

Thanks. Diego.

_______________________________________________ Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

Ok, but the radius returns status 407, and the call does not come to openser. There is some additional configuration for the call is routed to the openser when the user do not have credit?

In the messages logs, I have:

Oct 1 08:59:52 sipserver1 cdrtool[4698]: Notice: maxduration of 0 is less then minimumDurationCharged (60) Oct 1 08:59:52 sipserver1 cdrtool[4698]: GetBalance From=87004@fastervoip.com.br Oct 1 08:59:53 sipserver1 cdrtool[4698]: MaxSessionTime CallId=YzcyMWM3YTgzNDg1MWY2YWFlYzhjMzdhNDYxM2Q3NGU. From=87004@fastervoip.com.br To=sip:01591184701@fastervoip.com.br Duration=10800 Gateway=127.0.0.1 Lock=1 Oct 1 08:59:53 sipserver1 cdrtool[4698]: Notice: maxduration of 0 is less then minimumDurationCharged (60) Oct 1 08:59:53 sipserver1 cdrtool[4698]: GetBalance From=87004@fastervoip.com.br Oct 1 08:59:54 sipserver1 cdrtool[4698]: MaxSessionTime CallId=YzcyMWM3YTgzNDg1MWY2YWFlYzhjMzdhNDYxM2Q3NGU. From=87004@fastervoip.com.br To=sip:01591184701@fastervoip.com.br Duration=10800 Gateway=127.0.0.1 Lock=1 Oct 1 08:59:54 sipserver1 cdrtool[4698]: Notice: maxduration of 0 is less then minimumDurationCharged (60) Oct 1 08:59:54 sipserver1 cdrtool[4698]: GetBalance From=87004@fastervoip.com.br Oct 1 08:59:54 sipserver1 cdrtool[4698]: MaxSessionTime CallId=YzcyMWM3YTgzNDg1MWY2YWFlYzhjMzdhNDYxM2Q3NGU. From=87004@fastervoip.com.br To=sip:01591184701@fastervoip.com.br Duration=10800 Gateway=127.0.0.1 Lock=1 Oct 1 08:59:54 sipserver1 cdrtool[4698]: Notice: maxduration of 0 is less then minimumDurationCharged (60) Oct 1 08:59:54 sipserver1 cdrtool[4698]: GetBalance From=87004@fastervoip.com.br Oct 1 08:59:54 sipserver1 cdrtool[4698]: MaxSessionTime CallId=YzcyMWM3YTgzNDg1MWY2YWFlYzhjMzdhNDYxM2Q3NGU. From=87004@fastervoip.com.br To=sip:01591184701@fastervoip.com.br Duration=10800 Gateway=127.0.0.1 Lock=1 Oct 1 08:59:54 sipserver1 cdrtool[4698]: Notice: maxduration of 0 is less then minimumDurationCharged (60) Oct 1 08:59:54 sipserver1 cdrtool[4698]: GetBalance From=87004@fastervoip.com.br Oct 1 08:59:55 sipserver1 cdrtool[4698]: DebitBalance CallId=NTcyZjgyYzY5N2QzMDdhNmI4Yzk5MTBkZTUwMzljNmU. From=87004@fastervoip.com.br To=sip:01591184701@fastervoip.com.br Gateway=127.0.0.1 Duration=0 Oct 1 08:59:55 sipserver1 cdrtool[4698]: Error: session NTcyZjgyYzY5N2QzMDdhNmI4Yzk5MTBkZTUwMzljNmU. of 87004@fastervoip.com.br does not exist Oct 1 08:59:56 sipserver1 cdrtool[4698]: MaxSessionTime CallId=YzcyMWM3YTgzNDg1MWY2YWFlYzhjMzdhNDYxM2Q3NGU. From=87004@fastervoip.com.br To=sip:01591184701@fastervoip.com.br Duration=10800 Gateway=127.0.0.1 Lock=1 Oct 1 08:59:56 sipserver1 cdrtool[4698]: Notice: maxduration of 0 is less then minimumDurationCharged (60) Oct 1 08:59:56 sipserver1 cdrtool[4698]: GetBalance From=87004@fastervoip.com.br

And after that returns 407 to the user.

Thanks again. Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Wednesday, October 01, 2008 4:28 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Diego,

the connector is just the translator between cdrtool and radius/openser, so no need of coding anything inside, but use that information inside openser to make a decision. A good way to go would be an AVP check inside openser.cfg like:

check_value_of_ ($avp(s:credit)): (need to be replaced by real condition you want to match) $rU = "ann-insufficient_credit";

Cheers, DanB

On Tue, Sep 30, 2008 at 10:38 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

DanB,

The problem was solved with the new version. I don't understand very well the python language. It's possible to return SIP-AVP = nocredit#1 when the user have no credits? So I can return a message to the user saying he has no credits.

Thanks again. Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 3:15 PM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Hi Diego,

fixed now in pre2.

Cheers, DanB

On Tue, Sep 30, 2008 at 5:58 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

DanB,

I'm testing the freeradius-cdrtool, and found a possible problem. When I turn off the call before answer, the session is not finished. Here's a part of the logs:

rlm_python [freeradius-cdrtool]: Entering accounting section rlm_python [freeradius-cdrtool]: Got the following params: (('Acct-Status-Type', 'Failed'), ('Service-Type', 'Sip-Session'), ('Sip-Response-Code', '503'), ('Sip-Method', 'Invite'), ('X-Ascend-Bridge', '0x694de248a0b22d087cf199b7'), ('Sip-From-Tag', '"000d6570880e01462b3c62f9-0908d279"'), ('Acct-Session-Id', '"000d6570-880e0028-2a382841-1ef5c833@200.187.80.9"'), ('User-Name', '"87001@fastervoip.com.br"'), ('Calling-Station-Id', '"sip:87001@fastervoip.com.br"'), ('Called-Station-Id', '"sip:01591184701@fastervoip.com.br"'), ('Sip-Translated-Request-URI', '"sip:01591184701@200.187.80.17:5060;transport=udp"'), ('Sip-Rpid', '"87001"'), ('Source-IP', '"200.187.80.9"'), ('Source-Port', '"5070"'), ('Acct-Authentic', '49'), ('SIP-Proxy-IP', '"127.0.0.1"'), ('Canonical-URI', '"sip:01591184701@fastervoip.com.br"'), ('Billing-Party', '"87001@fastervoip.com.br"'), ('Contact', '"sip:87001@200.187.80.9:5070;transport=udp"'), ('NAS-Port', '5060'), ('Acct-Delay-Time', '0'), ('NAS-IP-Address', '127.0.0.1'), ('Client-IP-Address', '127.0.0.1'), ('Acct-Unique-Session-Id', '"3db548b64d9445ce"')) rlm_python [freeradius-cdrtool]: Extracted atribute <Acct-Status-Type> with value <Failed> rlm_python [freeradius-cdrtool]: Extracted atribute <User-Name> with value 87001@fastervoip.com.br rlm_python [freeradius-cdrtool]: Extracted atribute <Canonical-URI> with value sip:01591184701@fastervoip.com.br rlm_python [freeradius-cdrtool]: Extracted atribute <Called-Station-Id> with value sip:01591184701@fastervoip.com.br rlm_python [freeradius-cdrtool]: Extracted atribute <Acct-Session-Id> with value 000d6570-880e0028-2a382841-1ef5c833@200.187.80.9 rlm_python:EXCEPT:<type 'exceptions.TypeError'>: end_session() takes exactly 6 arguments (4 given) modcall[accounting]: module "python" returns ?? for request 261 modcall: leaving group accounting (returns ok) for request 261 Sending Accounting-Response of id 147 to 127.0.0.1 port 41560 Finished request 261

Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 11:54 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

"The avps received will be available in openser as: callMaxDur and credit, where callMaxDur is the maximum duration the user is allowed to be connected with the destination and credit represents the amount of credit available at starting of the call. This info can be used later in an bbua able to timeout calls based on duration. "

On Tue, Sep 30, 2008 at 4:38 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

Thanks DanB, the problem was solved. How send BYE when expires credit in conversation?

Thanks. Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 11:19 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Here is an already patched version: http://frad-cdrtool.sourceforge.net/rlm_digest.c You should replace your rlm_digest.c with this one and recompile the server.

DanB

On Tue, Sep 30, 2008 at 4:14 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

I'm using the freeradius 1.1.7, and not patched the rlm_digest. Where to find the patch rlm_digest ?

Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 11:08 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Diego,

the problem is with your digest module which is sanitizing the parameters in authentication phase only, therefore the parameters like Username, Digest-URI are not available in the authorization phase (no way for the connector to read them). Did u patch your rlm_digest as per the README.txt? What version of freeradius are u using?

DanB

On Tue, Sep 30, 2008 at 3:56 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

DanB,

Yes, I changed the kamailio.cfg. I´m sending the full log of radius attached.

Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 10:34 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Diego,

looks like there was no session started at first place. Did u change the openser.cfg config? You need to add callid into radius_proxy_authorize so that the callid should be used (example in README.txt of the freeradius-cdrtool sources).

Also, can u post a full authorize/account_start/account_stop sequence as logged by "radiusd -X".

DanB

On Tue, Sep 30, 2008 at 3:00 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

Hi DanB,

I updated the CDRTool to version 6.6.8 and freeradius-cdrtool to version 1.2-pre. I'm getting this log and not doing the Debit.

Sep 30 09:57:22 sipserver1 cdrtool[12948]: DebitBalance CallId=000d6570-880e0035-39c8f267-5c77e9d2@192.168.0.1 From=87001@mydomain.com.br To=sip:00551599998888@mydomain.com.br Gateway=127.0.0.1 Duration=11 Sep 30 09:57:22 sipserver1 cdrtool[12948]: ConnectFee=0.00 Span=1 Duration=60 DestId=55159 domain=mydomain.com.br Profile=551 Period=weekday Rate=551 Interval=0-24 Cost=0.85/60 Price=0.8500 Sep 30 09:57:22 sipserver1 cdrtool[12948]: Error: session 000d6570-880e0035-39c8f267-5c77e9d2@192.168.0.1 for 87001@mydomain.com.br does not exist

Thanks. Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Tuesday, September 30, 2008 5:47 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Hi Diego,

you don't need to set anything in Users file. The connector does that for you dynamically, based on the responses received from cdrtool. Your configuration will be static and always limit the user to the same call duration. For more information, see the README file within freeradius-cdrtool source directory.

Cheers, DanB

On Mon, Sep 29, 2008 at 10:49 PM, Diego Zuaneti Arruda diego@fasternet.com.br wrote:

Hi all,

How I send to freeradius-cdrtool the maxCallDuration and UserCredit? On the /etc/raddb/users I have:

87001@mydomain.com.br Auth-Type := Digest, User-Password == "mypassword" Reply-Message = "Authenticated", SIP-AVP = "authentic#1", SIP-AVP = "callMaxDur:60", SIP-AVP = "credit:25"

Is this correct ?

Thanks. Diego.

_______________________________________________ Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

DanB, the "radius -X" logs is attached.

Diego. ----- Original Message ----- From: DanB To: Diego Zuaneti Arruda Cc: users@lists.kamailio.org Sent: Wednesday, October 01, 2008 9:10 AM Subject: Re: [Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Diego,

It looks like there is another problem (nothing to do with the fact that your account is bellow 0. Can u send me the "radius -X" logs?

DanB

Hi all! One stupid question... How can i change Sip-Uri-User in openser.cfg to point to CallId?... Thanks in advance!

Hi DanB... Finally i have to set up manually, nothing different from README configuration and from my older platform running previous version of freeradius-cdrtool (1.1)... It's doesn't matter, setting up manually is enough for me... Thank you. I have other stupid problem... first one is extracting gateway ip in authorization section of the script. I see it is extracted from NAS-IP-Address... this contain the loopbak ip 127.0.0.1... how i can change this parameter in openser to send my real gateway ip? The second one isn't so easy and it's possible that have some kind of relation with the previous one. When the script tries to do and endsession over cdrtool (6.6.9) rating engine, it raises the following exception: rlm_python [freeradius-cdrtool]: DebitBalance CallId=27874A50-6363-3C25-6B88-6FBCB76686C6@192.168.0.41 From=admin@goldslam.com To=sip:0034XXXXXXXXX@192.168.0.130:5060 Gateway=127.0.0.1 Duration=9 rlm_python:EXCEPT:exceptions.AttributeError: 'NoneType' object has no attribute 'find' I'll try to investigate a bit more why this is happening... Cheers.

DanB-2 wrote:

Raul,

regarding auth parameter, you can either get it as returned from the rad_auth (inside the avp), or force it yourself. Make sure you have the attribute defined into the dictionary and check once again the configurations.

If you need further help, send me the "radiusd -X" output for both of your auth and acct-stop as well as your openser config.

Cheers, DanB

On Tue, Oct 7, 2008 at 1:14 PM, raul2r2 raul2r2@gmail.com wrote:

...

Thank you for your answer Dan... The problem was that the previous README file was too similar and i forget read more carefully the configuration part because i suppose in a first sight that it was equal to the new one... Another stupid question is why script don't receive the Acct-Authentic parameter from openser, giving up accounting it when receive the accounting start packet... I can sure you that i revised README file again and nothing different in configuration... I have Acct-Authentic in acc extra parameters and also defined in freeradius dictionary... strange thing is that in previous version of the script this is working... I Know that is not a script problem, openser must send this parameter... but why not? Thank you in advance...

Diego Zuaneti Arruda wrote:

...

Hi all,

How I send to freeradius-cdrtool the maxCallDuration and UserCredit? On the /etc/raddb/users I have:

87001@mydomain.com.br Auth-Type := Digest, User-Password ==

"mypassword"

...

    Reply-Message = "Authenticated",
    SIP-AVP = "authentic#1",
    SIP-AVP = "callMaxDur:60",
    SIP-AVP = "credit:25"

Is this correct ?

Thanks. Diego.

---

Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

-- View this message in context: http://www.nabble.com/Send-MaxCallDuration-and-UserCredit-for-freeradius-cdr... Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.

---

Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

---

Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

Hi Dan...: The syslog show this: Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Normalize datasource ser_radius, database DB_radius, table radacct200810 Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Normalize lock id 5889 aquired for ser_radius:radacct200810 Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Normalize datasource ser_radius, database DB_radius, table radacct200809 Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Normalize lock id 5889 aquired for ser_radius:radacct200809 Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Database error: Table 'radius.radacct200809' doesn't exist (1146) Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Unlock ser_radius:radacct200810 Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Unlock ser_radius:radacct200809 Oct 9 14:40:02 PREPSQL01 cdrtool[27236]: Checking user quotas for data source OpenSER Oct 9 14:40:02 PREPSQL01 cdrtool[27236]: Using database queries to block accounts Oct 9 14:40:02 PREPSQL01 cdrtool[27236]: No quota has been exceeded Oct 9 14:40:14 PREPSQL01 cdrtool[7803]: DebitBalance CallId=1A0082B8-7734-BA31-4828-3D24892A184C@192.168.0.41 From=admin@goldslam.com To=sip:0034678650039@192.168.0.130:5060 Gateway=127.0.0.1 Duration=8 Oct 9 14:40:14 PREPSQL01 cdrtool[7803]: Error: session 1A0082B8-7734-BA31-4828-3D24892A184C@192.168.0.41 for admin@goldslam.com does not exist

I don't know if the bad gateway could be the cause of this... How i can change NAS-IP-Address in openser? Cheers...

DanB-2 wrote:

Raul,

it looks like there is something wrong with the answer you receive from cdrtool (could be wrong handled by connector too...).

Can u post me the cdrtool syslog? There it should be seen the answer received.

Cheers, DanB

On Tue, Oct 7, 2008 at 7:27 PM, raul2r2 raul2r2@gmail.com wrote:

...

Hi DanB... Finally i have to set up manually, nothing different from README configuration and from my older platform running previous version of freeradius-cdrtool (1.1)... It's doesn't matter, setting up manually is enough for me... Thank you. I have other stupid problem... first one is extracting gateway ip in authorization section of the script. I see it is extracted from NAS-IP-Address... this contain the loopbak ip 127.0.0.1... how i can change this parameter in openser to send my real gateway ip? The second one isn't so easy and it's possible that have some kind of relation with the previous one. When the script tries to do and endsession over cdrtool (6.6.9) rating engine, it raises the following exception: rlm_python [freeradius-cdrtool]: DebitBalance CallId=27874A50-6363-3C25-6B88-6FBCB76686C6@192.168.0.41 From=admin@goldslam.com To=sip:0034XXXXXXXXX@192.168.0.130:5060 Gateway=127.0.0.1 Duration=9 rlm_python:EXCEPT:exceptions.AttributeError: 'NoneType' object has no attribute 'find' I'll try to investigate a bit more why this is happening... Cheers.

---

Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

Hi Dan... Well, it seems that i can solve the problem... the problem was that i don't recompile correctly rlm_python module support. Thank you, i see a similar answer from you in the same thread... Although my other problem persists... 1. How can i change/define NAS-IP-Addrees parameter from openser... it takes loopback interface, and i need that this must be gateway public ip, that i use in my rates for cdrtool to calculate correctly MaxSessionTime. 2. I'm trying to hangup the call... I use a little server script that use end_dlg_end MI function to fake bye's in both directions ending media session. Problems is that openser script does not process these bye's so i can not stop accounting. I know that this is an opensips limitation and saw a discursion this October where opensips Bogdan developer admit that he is working on some kind of solution.... Meanwhile i am looking for alternativies... these are the two i have: 1. Use mediaproxy and engage_media_proxy to end media session when dialog expires (probably playing with timeout_avp dialog function and your script)... but i'm not sure that this can solve the accounting problem. 2. I read a bit about you are using SIP Session Timers and Yate to solve this... can you help me a bit in the right direction or configuration scripts...

Thank you in advance... Cheers

DanB-2 wrote:

Raul,

this log shows only half of the call(stop one). Can u show a full trace (start and stop of the call)?

Cheers, DanB

On Thu, Oct 9, 2008 at 12:40 PM, raul2r2 raul2r2@gmail.com wrote:

...

Hi Dan...: The syslog show this: Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Normalize datasource ser_radius, database DB_radius, table radacct200810 Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Normalize lock id 5889 aquired for ser_radius:radacct200810 Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Normalize datasource ser_radius, database DB_radius, table radacct200809 Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Normalize lock id 5889 aquired for ser_radius:radacct200809 Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Database error: Table 'radius.radacct200809' doesn't exist (1146) Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Unlock ser_radius:radacct200810 Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Unlock ser_radius:radacct200809 Oct 9 14:40:02 PREPSQL01 cdrtool[27236]: Checking user quotas for data source OpenSER Oct 9 14:40:02 PREPSQL01 cdrtool[27236]: Using database queries to block accounts Oct 9 14:40:02 PREPSQL01 cdrtool[27236]: No quota has been exceeded Oct 9 14:40:14 PREPSQL01 cdrtool[7803]: DebitBalance CallId=1A0082B8-7734-BA31-4828-3D24892A184C@192.168.0.41 From=admin@goldslam.com To=sip:0034678650039@192.168.0.130:5060 Gateway=127.0.0.1 Duration=8 Oct 9 14:40:14 PREPSQL01 cdrtool[7803]: Error: session 1A0082B8-7734-BA31-4828-3D24892A184C@192.168.0.41 for admin@goldslam.com does not exist

I don't know if the bad gateway could be the cause of this... How i can change NAS-IP-Address in openser? Cheers...

DanB-2 wrote:

...

Raul,

it looks like there is something wrong with the answer you receive from cdrtool (could be wrong handled by connector too...).

Can u post me the cdrtool syslog? There it should be seen the answer received.

Cheers, DanB

On Tue, Oct 7, 2008 at 7:27 PM, raul2r2 raul2r2@gmail.com wrote:

...

Hi DanB... Finally i have to set up manually, nothing different from README configuration and from my older platform running previous version of freeradius-cdrtool (1.1)... It's doesn't matter, setting up manually

is

...

...

enough for me... Thank you. I have other stupid problem... first one is extracting gateway ip

in

...

...

authorization section of the script. I see it is extracted from NAS-IP-Address... this contain the loopbak ip 127.0.0.1... how i can change this parameter in openser to send my real gateway ip? The second one isn't so easy and it's possible that have some kind

of

...

...

relation with the previous one. When the script tries to do and endsession over cdrtool (6.6.9) rating engine, it raises the following exception: rlm_python [freeradius-cdrtool]: DebitBalance CallId=27874A50-6363-3C25-6B88-6FBCB76686C6@192.168.0.41 From=admin@goldslam.com To=sip:0034XXXXXXXXX@192.168.0.130:5060 Gateway=127.0.0.1 Duration=9 rlm_python:EXCEPT:exceptions.AttributeError: 'NoneType' object has no attribute 'find' I'll try to investigate a bit more why this is happening... Cheers.

---

Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

-- View this message in context: http://www.nabble.com/Send-MaxCallDuration-and-UserCredit-for-freeradius-cdr... Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.

---

Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

---

Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

Hi Raul,

the design I follow is:

1. Use the timeout value received from radius into openser avps and write it into a header (Session-Timer). 2. Make Yate parse this header with regexpfile module and force that session-timer value to become timer recognized by Yate.

Once the timeout value is hit, Yate will automatically disconnect the running session.

Hope this info helps.

DanB

On Tue, Oct 14, 2008 at 4:54 PM, raul2r2 raul2r2@gmail.com wrote:

Hi Again... It seems that problem 1 is solved... i only have to change the configuration in clients and servers configs file from freeradius and radius-client to point to my gateway ip-address not to my loopbak interface... But for problem two... any advice?...

raul2r2 wrote:

...

Hi Dan... Well, it seems that i can solve the problem... the problem was

that

...

i don't recompile correctly rlm_python module support. Thank you, i see a similar answer from you in the same thread... Although my other problem persists...

1. How can i change/define NAS-IP-Addrees parameter from openser... it

takes loopback interface, and i need that this must be gateway public ip, that i use in my rates for cdrtool to calculate correctly MaxSessionTime. 2. I'm trying to hangup the call... I use a little server script that use end_dlg_end MI function to fake bye's in both directions ending media session. Problems is that openser script does not process these bye's so

i

...

can not stop accounting. I know that this is an opensips limitation and saw a discursion this October where opensips Bogdan developer admit that he is working on some kind of solution.... Meanwhile i am looking for alternativies... these are the two i have: 1. Use mediaproxy and engage_media_proxy to end media session when

dialog

...

expires (probably playing with timeout_avp dialog function and your script)... but i'm not sure that this can solve the accounting problem. 2. I read a bit about you are using SIP Session Timers and Yate to

solve

...

this... can you help me a bit in the right direction or configuration scripts...

Thank you in advance... Cheers

DanB-2 wrote:

...

Raul,

this log shows only half of the call(stop one). Can u show a full trace (start and stop of the call)?

Cheers, DanB

On Thu, Oct 9, 2008 at 12:40 PM, raul2r2 raul2r2@gmail.com wrote:

...

Hi Dan...: The syslog show this: Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Normalize datasource ser_radius, database DB_radius, table radacct200810 Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Normalize lock id 5889

aquired

...

...

...

for ser_radius:radacct200810 Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Normalize datasource ser_radius, database DB_radius, table radacct200809 Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Normalize lock id 5889

aquired

...

...

...

for ser_radius:radacct200809 Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Database error: Table 'radius.radacct200809' doesn't exist (1146) Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Unlock ser_radius:radacct200810 Oct 9 14:40:01 PREPSQL01 cdrtool[27237]: Unlock ser_radius:radacct200809 Oct 9 14:40:02 PREPSQL01 cdrtool[27236]: Checking user quotas for data source OpenSER Oct 9 14:40:02 PREPSQL01 cdrtool[27236]: Using database queries to block accounts Oct 9 14:40:02 PREPSQL01 cdrtool[27236]: No quota has been exceeded Oct 9 14:40:14 PREPSQL01 cdrtool[7803]: DebitBalance CallId=1A0082B8-7734-BA31-4828-3D24892A184C@192.168.0.41 From=admin@goldslam.com To=sip:0034678650039@192.168.0.130:5060 Gateway=127.0.0.1 Duration=8 Oct 9 14:40:14 PREPSQL01 cdrtool[7803]: Error: session 1A0082B8-7734-BA31-4828-3D24892A184C@192.168.0.41 for

admin@goldslam.com

...

...

...

does not exist

I don't know if the bad gateway could be the cause of this... How i can change NAS-IP-Address in openser? Cheers...

DanB-2 wrote:

...

Raul,

it looks like there is something wrong with the answer you receive

from

...

cdrtool (could be wrong handled by connector too...).

Can u post me the cdrtool syslog? There it should be seen the answer received.

Cheers, DanB

On Tue, Oct 7, 2008 at 7:27 PM, raul2r2 raul2r2@gmail.com wrote:

...

Hi DanB... Finally i have to set up manually, nothing different from README configuration and from my older platform running previous version of freeradius-cdrtool (1.1)... It's doesn't matter, setting up manually

is

...

...

enough for me... Thank you. I have other stupid problem... first one is extracting gateway ip

in

...

...

authorization section of the script. I see it is extracted from NAS-IP-Address... this contain the loopbak ip 127.0.0.1... how i can change this parameter in openser to send my real gateway ip? The second one isn't so easy and it's possible that have some

kind

...

...

...

of

...

...

relation with the previous one. When the script tries to do and endsession over cdrtool (6.6.9) rating engine, it raises the following

exception:

...

...

rlm_python [freeradius-cdrtool]: DebitBalance CallId=27874A50-6363-3C25-6B88-6FBCB76686C6@192.168.0.41 From=admin@goldslam.com To=sip:0034XXXXXXXXX@192.168.0.130:5060 Gateway=127.0.0.1 Duration=9 rlm_python:EXCEPT:exceptions.AttributeError: 'NoneType' object has

no

...

...

...

...

...

attribute 'find' I'll try to investigate a bit more why this is happening... Cheers.

---

Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

-- View this message in context:

http://www.nabble.com/Send-MaxCallDuration-and-UserCredit-for-freeradius-cdr...

...

...

...

Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.

---

Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

---

Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

-- View this message in context: http://www.nabble.com/Send-MaxCallDuration-and-UserCredit-for-freeradius-cdr... Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.

---

Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users