[SR-Users] allow_trusted and ipv6 addresses

[Sergey Okhapkin]

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 at 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 at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users