[SR-Users] allow_trusted and ipv6 addresses

[Sergey Okhapkin]

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