Looks like I found a solution: create function toint(num int) returns int NO SQL begin return num; end;
select toint(1) as grp returns LONG datatype. On Monday 23 February 2015 17:42:30 Sergey Okhapkin wrote: > 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 _______________________________________________ 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
