I checked the kamctl script and saw this, in the section to add users
if [ "$STORE_PLAINTEXT_PW" = "1" ] ; then PASS="$2" else PASS="" fi
so I went to the kamctltc file and see this option: STORE_PLAINTEXT_PW, which was using default values, hence saving passwds as clear text: I set it to 0 and now it is fine. Problem fixed.
## do (1) or don't (0) store plaintext passwords ## in the subscriber table - default '1' STORE_PLAINTEXT_PW=0
txs a lot fborot
From: fborot@hotmail.com To: sr-users@lists.sip-router.org Subject: RE: auth_db question Date: Fri, 1 Jul 2011 22:06:30 -0400
Thank you klaus, what you say makes sense, but I was under the impression that it could be set from the config file, I will take a look at the kamctl script
From: fborot@hotmail.com To: sr-users@lists.sip-router.org Subject: RE: auth_db question Date: Fri, 1 Jul 2011 14:55:52 -0400
I just tried and the phones register but I still see the password on the password column as clear text.
modparam("auth_db", "db_url", DBURL) modparam("auth_db", "calculate_ha1", 0) modparam("auth_db", "password_column", "ha1") modparam("auth_db", "load_credentials", "") modparam("auth_db", "use_domain", MULTIDOMAIN) I create the users like this:
kamctl add 300 abc
From: fborot@hotmail.com To: sr-users@lists.sip-router.org Subject: auth_db question Date: Fri, 1 Jul 2011 14:36:21 -0400
Hello I am trying to store the password on the subscriber db as encrypted instead of plain text and when I do it then the registration fails,
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)
If I change the 3rd line to this it works but it shows the password in clear text:
modparam("auth_db", "password_column", "password")
This is how my subscriber table is defined
mysql> describe subscriber; +---------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | username | varchar(64) | NO | MUL | | | | domain | varchar(64) | NO | | | | | password | varchar(25) | NO | | | | | email_address | varchar(64) | NO | | | | | ha1 | varchar(64) | NO | | | | | ha1b | varchar(64) | NO | | | | | rpid | varchar(64) | YES | | NULL | | +---------------+------------------+------+-----+---------+----------------+
and this is how it looks like in the db:
[root@registrar ~]# /usr/local/kamailio-3.1/sbin/kamctl db show subscriber +----+----------+---------------+----------+---------------+----------------------------------+----------------------------------+------+ | id | username | domain | password | email_address | ha1 | ha1b | rpid | +----+----------+---------------+----------+---------------+----------------------------------+----------------------------------+------+ | 1 | 100 | 192.168.169.1 | abc | | 4a169916d58247f9e7eac55251fa7467 | 28787e5b5d3a2c6e2e0a80d3e9e3c6de | NULL | | 2 | 200 | 192.168.169.1 | abc | | 0b15f8f9e348ec64a2e7d5fca6b629c3 | 99eea8b456956d67e7915ed9c96e420b | NULL | +----+----------+---------------+----------+---------------+----------------------------------+----------------------------------+------+
please give me hand figuring this one out, I can't see what I am doing wrong
fborot