Wow what timing. I was just about to do my first CDRTool install but haven't started yet.now I can avoid this headache completely. ;)
S. From: users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] On Behalf Of Duane Larson Sent: Wednesday, June 01, 2011 12:17 PM To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] CDRTool - MySQL Database error: Invalid SQL: Thanks Adrian. Took a little while to figure out, but it's probably best to use different credentials anyway from a security standpoint. Got to love bugs. On Wed, Jun 1, 2011 at 2:14 PM, Adrian Georgescu <a...@ag-projects.com> wrote: Seems to be a php bug that cannot correctly identify the different connections in a mysql pool. Work around it by using different credentials/database combinations. Adrian On Jun 1, 2011, at 9:05 PM, osiris123d wrote: > Figured out the issue but it doesn't make sense. From my last post it > appeared that when mysql was querying for the radacct201106 table it was > looking in the cdrtool database. Well when I set up cdrtool's global.inc > config I made it so that cdradmin mysql user was used to log into the > cdrtool database and also the radius database. Here is an example of what I > had > > class DB_CDRTool extends DB_Sql { > var $Host = "127.0.0.1"; > var $Database = "cdrtool"; > var $User = "cdradmin"; > var $Password = "*"; > var $Halt_On_Error ="yes"; > } > > class DB_Locker extends DB_Sql { > var $Host = "127.0.0.1"; > var $Database = "cdrtool"; > var $User = "locker"; > var $Password = "*"; > var $Halt_On_Error ="yes"; > } > > class DB_radius extends DB_Sql { > var $Host = "127.0.0.1"; > var $Database = "radius"; > var $User = "cdradmin"; > var $Password = "*"; > var $Halt_On_Error ="yes"; > } > > class DB_opensips extends DB_Sql { > var $Host = "127.0.0.1"; > var $Database = "opensips"; > var $User = "opensips"; > var $Password = "*"; > var $Halt_On_Error ="yes"; > } > > class DB_mediaproxy extends DB_Sql { > var $Host = "127.0.0.1"; > var $Database = "mediaproxy"; > var $User = "cdradmin"; > var $Password = "*"; > var $Halt_On_Error ="yes"; > > > > Originally I had the radius database user as "radius", but when I tried to > create that user in mysql it wouldn't let me (maybe because there is a > database called radius, not sure). So I figured I would just use the > cdradmin user for everything except for opensips database. Well when I > changed the cdrtool config to the following it is now about to do CDR > searches > > > class DB_CDRTool extends DB_Sql { > var $Host = "127.0.0.1"; > var $Database = "cdrtool"; > var $User = "cdradmin"; > var $Password = "*"; > var $Halt_On_Error ="yes"; > } > > class DB_Locker extends DB_Sql { > var $Host = "127.0.0.1"; > var $Database = "cdrtool"; > var $User = "locker"; > var $Password = "*"; > var $Halt_On_Error ="yes"; > } > > class DB_radius extends DB_Sql { > var $Host = "127.0.0.1"; > var $Database = "radius"; > var $User = "radadmin"; > var $Password = "*"; > var $Halt_On_Error ="yes"; > } > > class DB_opensips extends DB_Sql { > var $Host = "127.0.0.1"; > var $Database = "opensips"; > var $User = "opensips"; > var $Password = "*"; > var $Halt_On_Error ="yes"; > } > > class DB_mediaproxy extends DB_Sql { > var $Host = "127.0.0.1"; > var $Database = "mediaproxy"; > var $User = "cdradmin"; > var $Password = "*"; > var $Halt_On_Error ="yes"; > > > So it all appears to be good now, but I figured I should have still been > able to use the cdradmin user for both databases. For some reason CDRTool > was looking in the cdrtool database for the radacct201106. > > > > -- > View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-MySQL-Database -error-Invalid-SQL-tp6427865p6428379.html > Sent from the OpenSIPS - Users mailing list archive at Nabble.com. > > _______________________________________________ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- -- *--*--*--*--*--* Duane *--*--*--*--*--* -- _____ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1375 / Virus Database: 1511/3673 - Release Date: 06/01/11
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users