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

[osiris123d]

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=`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
>>
>>
> 
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> 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.