[OpenSIPS-Users] CDRTool and opensips 1.6

[Saúl Ibarra Corretgé]

Hi,

On 1/4/10 11:48 AM, Carlo Dimaggio wrote:
> Hello Ag-projects Team,
>
> I would like to know if the next version of CDRTool will be fully-
> compatible with opensips 1.6.
> In a test environment I have CDRTool 7.0.2 and the following error
> (because opensips 1.6 doesn't use anymore the trusted table):
>
> Database DB_opensips error: Table 'opensips.trusted' doesn't exist
> (1146) select * from trusted
>
> Do you think that this is the only problem (I can ignore it) or there
> are other hidden incompatibilities?
>

That's the only 'incompatibility' I'm currently aware of. The way 
trusted peers are handled in OpenSIPS 1.6 has changed, but you can get 
CDRTool working by doing this:

You need to create a MySQL view to 'emulate' the trusted 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 the above case you'd be using address groups 1 as a the trusted table.

We need to keep backwards compatibility in CDRTool, but we'll add this 
to the documentation, thanks for pointing it out.


Regards,


PS: The view was suggested by Jeff Pyle IIRC :)

-- 
Saúl Ibarra Corretgé
AG Projects