[OpenSIPS-Users] CDRTool 6.9.9 with OpenSIPS 1.6 Issue - No Trusted DB Table

[Jeff Pyle]

Until that happens I was able to make CDRTool happy by creating a view of the address table:

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)

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" <jprangi at gmail.com> 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 <duane.larson at gmail.com> 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
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20091215/2e428e7d/attachment-0001.htm