24 Feb
2015
24 Feb
'15
2:19 p.m.
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(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users