[OpenSIPS-Users] CDRTool - MySQL Database error: Invalid SQL:

osiris123d duane.larson at gmail.com
Wed Jun 1 20:35:34 CEST 2011

I enabled logging on the MySQL server and when I click Search on the CDR
search and then go to the log after it fails with the "MySQL error: 1146
(Table 'cdrtool.radacct201106' doesn't exist) Session halted." error I see
the following in the log

110601 13:28:44    13 Connect   cdradmin at localhost on 
                   13 Init DB   cdrtool
                   13 Query     select val from active_sessions where sid  =
'47e6b96d5dbb0405bba6d9d5181f392a' and name = 'CDRc'
                   13 Init DB   radius
                   13 Query     SELECT 1
                   13 Init DB   cdrtool
                   13 Query     select * from sip_status order by code
                   13 Query     select `value` from memcache where `key` =
110601 13:28:45    13 Query     select `value` from memcache where `key` =
                   13 Query     select * from billing_enum_tlds
                   14 Connect   opensips at localhost on 
                   14 Init DB   opensips
                   14 Query     select * from domain
                   14 Query     select * from trusted
                   13 Query     SHOW TABLES
                   13 Query     select count(*) as records
            from radacct201106 where  (AcctStartTime >= '2011-06-01 12:18'
and AcctStartTime < '2011-06-01 23:55')

This makes me think that CDRTool is looking for the radacct201106 table in
the OpenSIPS database.  Am I wrong?

View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-MySQL-Database-error-Invalid-SQL-tp6427865p6428272.html
Sent from the OpenSIPS - Users mailing list archive at Nabble.com.

More information about the Users mailing list