Hi, On 18/12/09 8:48 AM, Darshak Modi wrote: > Hi, > When I try to login in cdr tool it gives error > > Invalid SQL: select * from trusted MySQL error: 1146 (Table > 'opensips.trusted' doesn't exist) > > > Where in opensips, it says the table is merged with address table. > Where can I change to point to address table? >
This was changed in OpenSIPS 1.6, so until we release a new version with a fix for this you can fix it yourself with the solution provided by Jeff Pyle earlier this week. 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. Regards, -- Saúl Ibarra Corretgé AG Projects _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users