Is it possible to make Siremis store passwords in plaintext? I've just converted to hashed passwords as well and kamctlrc has STORE_PLAINTEXT_PW=0 but Siremis is still storing passwords in plaintext.
On Wed, Jan 4, 2012 at 12:28 AM, Ali Jawad <ali.ja...@splendor.net> wrote: > Did trigger an email to fast this time, for people who might get here > using Google > > modparam("auth_db", "calculate_ha1", yes) > should be > modparam("auth_db", "calculate_ha1", 0) > > On Tue, Jan 3, 2012 at 1:03 PM, Ali Jawad <ali.ja...@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 > > _______________________________________________ > SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list > sr-users@lists.sip-router.org > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users