1 Jul
2011
1 Jul
'11
9:36 p.m.
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