[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` =
'destinations'
110601 13:28:45 13 Query select `value` from memcache where `key` =
'destinations_sip'
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