<HTML>
<HEAD>
<TITLE>Re: [OpenSIPS-Users] CDRTool 6.9.9 with OpenSIPS 1.6 Issue - No Trusted DB Table</TITLE>
</HEAD>
<BODY>
<FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>Until that happens I was able to make CDRTool happy by creating a view of the address table:<BR>
<BR>
</SPAN></FONT><SPAN STYLE='font-size:10pt'><FONT FACE="Lucida Console">CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`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)<BR>
</FONT><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><BR>
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.<BR>
<BR>
<BR>
- Jeff<BR>
<BR>
<BR>
<BR>
On 12/15/09 3:13 PM, "Jai Rangi" <<a href="jprangi@gmail.com">jprangi@gmail.com</a>> wrote:<BR>
<BR>
<FONT COLOR="#0000FF">> There is no trusted table in 1.6. All the entries goes to address table. Need <BR>
> to add fix/update to CDRTool..<BR>
> <BR>
> -Jai<BR>
> <BR>
> On Tue, Dec 15, 2009 at 12:09 PM, osiris123d <<a href="duane.larson@gmail.com">duane.larson@gmail.com</a>> wrote:<BR>
</FONT><FONT COLOR="#008000">>> <BR>
>> I am trying to set up CDRTool on Ubuntu from source and was almost done, but<BR>
>> I am not able to get into the CDRTool webpage because I am getting the<BR>
>> following error<BR>
>> Database error: Invalid SQL: select * from trusted MySQL error: 1146 (Table<BR>
>> 'opensips.trusted' doesn't exist) 59Session halted.<BR>
>> <BR>
>> I see that OpenSIPS 1.6 no longer has the Trusted table in its database. Is<BR>
>> there a workaround for this?<BR>
>> --<BR>
>> View this message in context: <BR>
>> <a href="http://n2.nabble.com/CDRTool-6-9-9-with-OpenSIPS-1-6-Issue-No-Trusted-DB-Tabl">http://n2.nabble.com/CDRTool-6-9-9-with-OpenSIPS-1-6-Issue-No-Trusted-DB-Tabl</a><BR>
>> e-tp4171857p4171857.html<BR>
>> Sent from the OpenSIPS - Users mailing list archive at Nabble.com.<BR>
>> <BR>
>> _______________________________________________<BR>
>> Users mailing list<BR>
>> <a href="Users@lists.opensips.org">Users@lists.opensips.org</a><BR>
>> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><BR>
</FONT><FONT COLOR="#0000FF">> <BR>
> <BR>
</FONT></FONT></SPAN>
</BODY>
</HTML>