Interesting to learn that mysql views are not using same type as the source column...
I guess we should handle this case internally, doing views is quite common out there. Cheers, Daniel On 23/02/15 21:23, Sergey Okhapkin wrote: > Address() functions are incompatible with mysql views/casts, > reload_address_table() expects columns grp, mask and port to be type DB1_INT > (mysql LONG) but views and casts always return column type LONGLONG > (DB1_BIGINT). reload_address_table() always fail because of that. > > On Monday 23 February 2015 09:53:08 Daniel-Constantin Mierla wrote: >> Hello, >> >> trusted does string comparison for the address field, it is not >> considered an ip address. >> >> You should use address table instead if you just need matching on any ip >> address or subnet. >> >> Cheers, >> Daniel >> >> On 23/02/15 03:49, Sergey Okhapkin wrote: >>> allow_trusted() function of permissions module doesn't work right with >>> ipv6 >>> addresses - it treats IP addresses as strings and doesn't take into >>> account >>> variations aaa:bbb::0 vs aaa:bbb:0:0:0:0:0:0. >>> >>> _______________________________________________ >>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list >>> sr-users@lists.sip-router.org >>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users -- Daniel-Constantin Mierla http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Kamailio World Conference, May 27-29, 2015 Berlin, Germany - http://www.kamailioworld.com _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
