Thanks Jeff. I will try to do the View fix for the Trusted Table.
Jeff Pyle wrote: > > Until that happens I was able to make CDRTool happy by creating a view of > the address table: > > CREATE ALGORITHM=UNDEFINED definer=`ro...@`localhost` SQL SECURITY DEFINER > VIEW `trusted` AS select `address`.`id` AS `id`,`address`.`ip` AS > `src_ip`,`address`.`proto` AS `proto`,`address`.`pattern` AS > `from_pattern`,`address`.`context_info` AS `tag` from `address` where > (`address`.`grp` = 1) > > In my case I used address group 1 for the same purposes as the old trusted > table. Remove the where clause to show all entries. > > > - Jeff > > > > On 12/15/09 3:13 PM, "Jai Rangi" <[email protected]> wrote: > >> There is no trusted table in 1.6. All the entries goes to address table. >> Need >> to add fix/update to CDRTool.. >> >> -Jai >> >> On Tue, Dec 15, 2009 at 12:09 PM, osiris123d <[email protected]> >> wrote: >>> >>> I am trying to set up CDRTool on Ubuntu from source and was almost done, >>> but >>> I am not able to get into the CDRTool webpage because I am getting the >>> following error >>> Database error: Invalid SQL: select * from trusted MySQL error: 1146 >>> (Table >>> 'opensips.trusted' doesn't exist) 59Session halted. >>> >>> I see that OpenSIPS 1.6 no longer has the Trusted table in its database. >>> Is >>> there a workaround for this? >>> -- >>> View this message in context: >>> http://n2.nabble.com/CDRTool-6-9-9-with-OpenSIPS-1-6-Issue-No-Trusted-DB-Tabl >>> e-tp4171857p4171857.html >>> Sent from the OpenSIPS - Users mailing list archive at Nabble.com. >>> >>> _______________________________________________ >>> Users mailing list >>> [email protected] >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > -- View this message in context: http://n2.nabble.com/CDRTool-6-9-9-with-OpenSIPS-1-6-Issue-No-Trusted-DB-Table-tp4171857p4172225.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
