On Wednesday 02 June 2010, Iñaki Baz Castillo wrote: > >> 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.
Hi Iñaki, this should be properly documented, as it has the potential of breaking some configurations. > - 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 _______________________________________________ sr-dev mailing list [email protected] http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
