[SR-Users] Hashed Passwords

[Ali Jawad]

Hi

I must add at log level 3 I get this error

 7(17642) DEBUG: auth [challenge.c:102]: build_challenge_hf:
realm='register.nymgo.com'
 7(17642) DEBUG: auth [challenge.c:244]: auth: 'WWW-Authenticate:
Digest realm="register.mydomain.com",
nonce="TwLkEk8C4uaGawXB1G3p4AfjIGPhpa3T"
'
 7(17642) DEBUG: sl [sl.c:278]: reply in stateless mode (sl)
 7(17642) DEBUG: <core> [msg_translator.c:204]:
check_via_address(pubIP, 192.168.0.191, 0)



And I use this in my config

   if (!www_authorize("$fd", "subscriber"))
                {

Regards

On Tue, Jan 3, 2012 at 1:03 PM, Ali Jawad <ali.jawad at splendor.net> wrote:
> Hi All
> We are using plain text passwords for authentication, for the obvious
> reasons we want to change to hashed passwords so first I executed the
> following on the SQL server :
>
> update subscriber set ha1 = md5(concat(username, ':', domain, ':',
> password)), ha1b = md5(concat(username, '@', domain, ':', domain, ':',
> password))
>
> The related config is :
>
>
>
> # ----- auth_db params -----
> #!ifdef WITH_AUTH
> modparam("auth_db", "db_url", DBURL)
> modparam("auth_db", "calculate_ha1", yes)
> modparam("auth_db", "password_column", "ha1")
> modparam("auth_db", "load_credentials", "")
> modparam("auth_db", "use_domain", MULTIDOMAIN)
>
> and
>
> # ----- auth_db params -----
> #!ifdef WITH_AUTH
> modparam("auth_db", "db_url", DBURL)
> modparam("auth_db", "calculate_ha1", yes)
> modparam("auth_db", "password_column", "ha1")
> modparam("auth_db", "load_credentials", "")
> modparam("auth_db", "use_domain", 1)
>
>
> But I keep getting unauthorized, what did I miss here.
>
> Regards



-- 
Ali Jawad
Information Systems Manager
Splendor Telecom (www.splendor.net)
Beirut, Lebanon
Phone: +9611373725/ext 116
FAX: +9611375554