Problem with miss call logging in radius (radacct) database

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Problem with miss call logging in radius (radacct) database

ASHWINI NAIDU
Hi all,

    I have upgraded my CDRTool-6.9.x to CDRTool-7.0.0 . I could see the cdrs of miss calls when i was using the CDRTool-6.9.x but after upgrading i do not see the missed call logs for CDRTool-7.0.0 nor in the radacct table. I have followed all the instructions for the upgrade.


Below is the radius log.
rad_recv: Accounting-Request packet from host 127.0.0.1 port 60042, id=222, length=352
    Acct-Status-Type = Failed
    Service-Type = Sip-Session
    Sip-Response-Code = 487
    Sip-Method = Invite
    Event-Timestamp = "Jan 29 2010 10:03:24 EST"
    Sip-From-Tag = "1b1bad63"
    Sip-To-Tag = "177306757"
    Acct-Session-Id = "3e19711acb6a541dYzE5ODJiZGU5NTg5ZWQ5MmE5NmE4MGFlOGMzYTI1NjA."
    User-Name = "[hidden email]"
    Calling-Station-Id = "[hidden email]"
    Called-Station-Id = "[hidden email]"
    Sip-Translated-Request-URI = "sip:1000@202.63.111.2:5060"
    Source-IP = "59.92.156.18"
    Source-Port = "50682"
    Canonical-URI = "[hidden email]"
    Contact = "<sip:5555@59.92.156.18:50682>"
    SIP-Proxy-IP = "aaa.aaa.com"
    NAS-Port = 5060
    Acct-Delay-Time = 0
    NAS-IP-Address = 127.0.0.1
+- entering group preacct {...}
++[preprocess] returns ok
[acct_unique] Hashing 'NAS-Port = 5060,Client-IP-Address = 127.0.0.1,NAS-IP-Address = 127.0.0.1,Acct-Session-Id = "3e19711acb6a541dYzE5ODJiZGU5NTg5ZWQ5MmE5NmE4MGFlOGMzYTI1NjA.",User-Name = "[hidden email]"'
[acct_unique] Acct-Unique-Session-ID = "0ef7a78049ee134a".
++[acct_unique] returns ok
++[files] returns noop
+- entering group accounting {...}
[detail]     expand: /usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d -> /usr/local/var/log/radius/radacct/127.0.0.1/detail-20100129
[detail] /usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /usr/local/var/log/radius/radacct/127.0.0.1/detail-20100129
[detail]     expand: %t -> Fri Jan 29 10:03:24 2010
++[detail] returns ok
++[unix] returns noop
[radutmp]     expand: /usr/local/var/log/radius/radutmp -> /usr/local/var/log/radius/radutmp
rlm_radutmp: NAS localhost port 5060 unknown packet type 15)
++[radutmp] returns noop
[sql] Unsupported Acct-Status-Type = 15
++[sql] returns noop
[attr_filter.accounting_response]     expand: %{User-Name} -> [hidden email]
 attr_filter: Matched entry DEFAULT at line 12
++[attr_filter.accounting_response] returns updated
Sending Accounting-Response of id 222 to 127.0.0.1 port 60042
Finished request 1.
Cleaning up request 1 ID 222 with timestamp +48
Going to the next request
Ready to process requests.


--
Thanking You,
Ashwini BR Naidu

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Problem with miss call logging in radius (radacct) database

Saúl Ibarra Corretgé
Hi,

El 29/01/10 16:28, ASHWINI NAIDU escribió:
> Hi all,
>
>      I have upgraded my CDRTool-6.9.x to CDRTool-7.0.0 . I could see the
> cdrs of miss calls when i was using the CDRTool-6.9.x but after
> upgrading i do not see the missed call logs for CDRTool-7.0.0 nor in the
> radacct table. I have followed all the instructions for the upgrade.
>

Did you also upgrade the MySQL stored procedures?


Regards,

--
Saúl Ibarra Corretgé
AG Projects

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Problem with miss call logging in radius (radacct) database

ASHWINI NAIDU
Hi Saul,

    Yes i have upgraded even mysql stored procedures. but still no luck.

On Sat, Jan 30, 2010 at 4:28 AM, Saúl Ibarra Corretgé <[hidden email]> wrote:
Hi,

El 29/01/10 16:28, ASHWINI NAIDU escribió:
> Hi all,
>
>      I have upgraded my CDRTool-6.9.x to CDRTool-7.0.0 . I could see the
> cdrs of miss calls when i was using the CDRTool-6.9.x but after
> upgrading i do not see the missed call logs for CDRTool-7.0.0 nor in the
> radacct table. I have followed all the instructions for the upgrade.
>

Did you also upgrade the MySQL stored procedures?


Regards,

--
Saúl Ibarra Corretgé
AG Projects

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



--
Thanking You,
Ashwini BR Naidu

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users