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=`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 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 _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
