CDR issue

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

CDR issue

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

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

global.inc (12K) Download Attachment