[SR-Users] check_from and check_to: case sensitive?

[Iñaki Baz Castillo]

2010/6/1 Klaus Darilion <klaus.mailinglists at pernau.at>:

>> The problem is that more SIP username related stuff is also case
>> insensitive in Kamailio, i.e. the database columns. For example a user
>> "TEST" with a location entry with username "test" woudl be retrieved
>> because the location.username column is case insensitive.
>
> IIRC that depends on the DB backend: MySQL is by default case insensitive,
> Postgresql is by default case sensitive.

Yes, this is correct. Then:

- check_from / check_to should b fixed to use case sensitive comparison.

- MySQL database schema should use case sensitive columns for
'username' in subscriber, location and any other tables containing an
'username' column.

Do I miss something?


-- 
Iñaki Baz Castillo
<ibc at aliax.net>