[OpenSIPS-Users] Blank domain field in subscriber table

[Schneur Rosenberg]

here is my problem, my server has multiple domain names, different
customers register with a different domain name (we combined a few
servers into one, therefore some register with different names) now as
long as I dont have the correct domain set in the subscriber table,
the system will keep on replying with a 401 Unauthorized.

I assume it has to do with the way ha1 passwords are handled, I set
the system to use plain text passwords, I also tried setting  static
challenge for www_authorize, I thought this will eliminate the need
for the domain in the challenge, but still no registration.

in my debug I get the following 2 lines

Dec 19 09:11:06 opensipsmaster /sbin/opensips[4937]:
DBG:db_mysql:db_mysql_convert_rows: no rows returned from the query
Dec 19 09:11:06 opensipsmaster /sbin/opensips[4937]:
DBG:auth_db:get_ha1: no result for user 'gratt1 at sipsvr1.mydomain.com'

Schneur Rosenberg