[OpenSIPS-Users] CDR issue

ASHWINI NAIDU ashwini.naidu at gmail.com
Sat Jan 24 14:31:08 CET 2009


hi all,

    I have *CDR tool -6.6.10, Freeradius-1.1.3 *running. it is integrated
with *openser-1.2.2*. i have attached my global.inc file. when i try to
search the cdr details i get the following error

* Table 'openser.radacct' doesn't exist*

*Database error: Invalid SQL: update active_sessions set
val='Q0RSYzokdGhpcy0+aW4gPSAnMSc7ICR0aGlzLT5wdCA9IGFycmF5KCk7ICR0aGlzLT5wdFsnYXV0aCddID0gJzEnOyAkdGhpcy0+cHRbJ2NoYWxsZW5nZSddID0gJzEnOyAkdGhpcy0+cHRbJ0NEUlRvb2wnXSA9ICcxJzsgJEdMT0JBTFNbJ2F1dGgnXSA9IG5ldyBDRFJUb29sX0F1dGg7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGggPSBhcnJheSgpOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWyd1aWQnXSA9ICdjMTRjYmYxNDFhYjFiN2NkMDA5MzU2ZjU1NWI2MDdkYyc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ3Blcm0nXSA9ICdhZG1pbixjYWxsc2VhcmNoLHN0YXRpc3RpY3MscmF0ZXMnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydzb3VyY2UnXSA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydleHAnXSA9ICcxMjMyODE3ODg5JzsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsncmVmcmVzaCddID0gJzEyMzI3NzY0OTInOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWyd1bmFtZSddID0gJ2FkbWluJzsgJEdMT0JBTFNbJ2NoYWxsZW5nZSddID0gJyc7ICRHTE9CQUxTWydDRFJUb29sJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snQ0RSVG9vbCddWyd0bGQnXSA9ICcvQ0RSVG9vbCc7ICRHTE9CQUxTWydDRFJUb29sJ11bJ1BhdGgnXSA9ICcvdmFyL3d3dy9DRFJUb29sJzsgJEdMT0JBTFNbJ0NEUlRvb2wnXVsncHJvdmlkZXInXSA9IGFycmF5KCk7ICRHTE9CQUxTWydDRFJUb29sJ11bJ3Byb3ZpZGVyJ11bJ25hbWUnXSA9ICdQcm92aWRlciBuYW1lJzsgJEdMT0JBTFNbJ0NEUlRvb2wnXVsncHJvdmlkZXInXVsnc2VydmljZSddID0gJ1NJUCBzZXJ2aWNlJzsgJEdMT0JBTFNbJ0NEUlRvb2wnXVsncHJvdmlkZXInXVsndGltZXpvbmUnXSA9ICdFdXJvcGUvQW1zdGVyZGFtJzsgJEdMT0JBTFNbJ0NEUlRvb2wnXVsncHJvdmlkZXInXVsnZnJvbUVtYWlsJ10gPSAnc3VwcG9ydEBleGFtcGxlLmNvbSc7ICRHTE9CQUxTWydDRFJUb29sJ11bJ3Byb3ZpZGVyJ11bJ3RvRW1haWwnXSA9ICdzdXBwb3J0QGV4YW1wbGUuY29tJzsgJEdMT0JBTFNbJ0NEUlRvb2wnXVsncHJvdmlkZXInXVsnc2FtcGxlTG9naW5TdWJzY3JpYmVyJ10gPSAnbnVtYmVyQGV4YW1wbGUuY29tJzsgJEdMT0JBTFNbJ0NEUlRvb2wnXVsncHJvdmlkZXInXVsnc2FtcGxlTG9naW5Eb21haW4nXSA9ICdleGFtcGxlLmNvbSc7ICRHTE9CQUxTWydDRFJUb29sJ11bJ25vcm1hbGl6ZSddID0gYXJyYXkoKTsgJEdMT0JBTFNbJ0NEUlRvb2wnXVsnbm9ybWFsaXplJ11bJ2RlZmF1bHRDb3VudHJ5Q29kZSddID0gJzMxJzsgJEdMT0JBTFNbJ0NEUlRvb2wnXVsnbG9naW5OYW1lJ10gPSAnQWRtaW5pc3RyYXRvcic7ICRHTE9CQUxTWydDRFJUb29sJ11bJ2xvZ2luRW1haWwnXSA9ICdzdXBwb3J0QDFleGFtcGxlLmNvbSc7ICRHTE9CQUxTWydDRFJUb29sJ11bJ2RhdGFTb3VyY2VzQWxsb3dlZCddID0gYXJyYXkoKTsgJEdMT0JBTFNbJ0NEUlRvb2wnXVsnZGF0YVNvdXJjZXNBbGxvd2VkJ11bJzAnXSA9ICdzZXJfcmFkaXVzJzsgJEdMT0JBTFNbJ0NEUlRvb2wnXVsnZGF0YVNvdXJjZXNBbGxvd2VkJ11bJzEnXSA9ICdzaXBfdHJhY2UnOyAkR0xPQkFMU1snQ0RSVG9vbCddWydmaWx0ZXInXSA9IGFycmF5KCk7ICRHTE9CQUxTWydDRFJUb29sJ11bJ2ZpbHRlciddWyd1c2VyX2lkJ10gPSAnYzE0Y2JmMTQxYWIxYjdjZDAwOTM1NmY1NTViNjA3ZGMnOyAkR0xPQkFMU1snQ0RSVG9vbCddWydmaWx0ZXInXVsnYU51bWJlciddID0gJyc7ICRHTE9CQUxTWydDRFJUb29sJ11bJ2ZpbHRlciddWydkaXNwbGF5QSddID0gJzEnOyAkR0xPQkFMU1snQ0RSVG9vbCddWydmaWx0ZXInXVsnZG9tYWluJ10gPSAnJzsgJEdMT0JBTFNbJ0NEUlRvb2wnXVsnZmlsdGVyJ11bJ2dhdGV3YXknXSA9ICcnOyAkR0xPQkFMU1snQ0RSVG9vbCddWydmaWx0ZXInXVsnY29tcGlkJ10gPSAnJzsgJEdMT0JBTFNbJ0NEUlRvb2wnXVsnZmlsdGVyJ11bJ2NzY29kZSddID0gJyc7ICRHTE9CQUxTWydDRFJUb29sJ11bJ2ltcGVyc29uYXRlJ10gPSAnMCc7IA==',
changed='20090124142449', count=count+1 where
sid='10d7974e11ae2d1746c1e8e298bab694' and name='CDRc' MySQL error: 1054
(Unknown column 'count' in 'field list') 59Session halted.
*
And i donot have sip_trace database and mediaproxy database. where can i get
the structures for building the databases. *My media proxy version is
1.9.1*. I wanted to know if there are versions of  2.3.2  > mediaproxy
> 2.0 which
supports openser.


*Please let me know if any changes have to be made in global.inc file*

-- 
Thankin You,
Ashwini BR Naidu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090124/62b87846/attachment.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: global.inc
Type: application/octet-stream
Size: 9135 bytes
Desc: not available
Url : http://lists.opensips.org/pipermail/users/attachments/20090124/62b87846/attachment.obj 


More information about the Users mailing list