2 Jun
2010
2 Jun
'10
8:32 p.m.
On Wednesday 02 June 2010, Iñaki Baz Castillo wrote:
Yes, this is correct. Then:
- check_from / check_to should b fixed to use case sensitive comparison.
Hi Iñaki,
this should be properly documented, as it has the potential of breaking some
configurations.
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. - MySQL database schema should use case sensitive
columns for
'username' in subscriber, location and any other tables containing an
'username' column.
I think we should think a bit more about this step, as it would be a major
change in the way most people expect the database to work, which happens to be
mostly mysql in our case. Add devel list as CC.
Henning