I think the problem is not in the source column type, but in casts. I found no way to create a view using existing table with "select cast(1 as unsigned) as grp" to return LONG. It always returns LONGLONG. I don't have concept of group in my DB schema and I don't need one, I just need to emulate the table structure kamailio expects.
On Monday 23 February 2015 23:34:12 you wrote: > 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 _______________________________________________ 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
