Hi SparkleZou,
The issue here is how the password is stored in DB. As per the sql
dump, the pwd is in pre-computed HA1 format, while your opensips cfg
expects the pwd in plain-text format, see the `calculate_ha1` and
`password_column` modparams for auth_db module.
For more, see
https://opensips.org/html/docs/modules/3.2.x/auth_db.html#param_calculate_ha1
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
https://www.opensips-solutions.com
OpenSIPS Summit 27-30 Sept 2022, Athens
https://www.opensips.org/events/Summit-2022Athens/
On 8/26/22 8:31 AM, SparkleZou wrote:
Hi All,
I'm just start to use OpenSips. Already checked the manual. Step by
Step, here I need help. Thanks! ^_^
1. Already install Opensips 3.3 successfully refer to OpenSIPS 3.1/3.2
Installation Instructions | VoIP School
<https://www.voip.school/courses/1362752/lectures/31626804>
2. apt install mariadb-server
opensips-cli -x database create opensips
root@opensips:/etc/opensips# mysql opensips -e "show tables"
+--------------------+ | Tables_in_opensips | +--------------------+ |
acc | | address | | clusterer | | dbaliases | | dialog | | dialplan |
| dispatcher | | domain | | dr_carriers | | dr_gateways | | dr_groups
| | dr_partitions | | dr_rules | | grp | | load_balancer | | location
| | missed_calls | | re_grp | | rtpengine | | rtpproxy_sockets | |
silo | | speed_dial | | subscriber | | tls_mgm | | uri | |
usr_preferences | | version | +--------------------+
MariaDB [opensips]> select * FROM subscriber;
+----+----------+--------------+----------+---------------+----------------------------------+------------------------------------------------------------------+------------------------------------------------------------------+------+
| id | username | domain | password | email_address | ha1 | ha1_sha256
| ha1_sha512t256 | rpid |
+----+----------+--------------+----------+---------------+----------------------------------+------------------------------------------------------------------+------------------------------------------------------------------+------+
| 1 | 1000 | 192.168.3.53 | | | 1c77bd7afa5414714be613363977341f |
a821eb87519b53a8e505184a8798b9300dd1788c32ce59026c6f047d5f0eb717 |
1947492ee9de11818d8a54cc5969bd87e5622f412e1b3e1a117ce8c44b936b5d |
NULL | | 2 | 1001 | 192.168.3.53 | | |
c3d0ccc517e752190644392e7f0c5d93 |
b4efb98003f1e5f75ad6ca5ce320a367a430415b9e304ef384e19b969e14ea44 |
49a9a44fbb296fed9c7fe9b4e86ef113642d2e911fe34e93742cc249de261d5a |
NULL |
+----+----------+--------------+----------+---------------+----------------------------------+------------------------------------------------------------------+------------------------------------------------------------------+------+
2 rows in set (0.000 sec)
accounts 1000 & 1001 are already created in db.
run /usr/sbin/osipsconfig select ENABLE_TCP & USE_AUTH, generate the
CFG file.
____________________________________________ | | | [*] ENABLE_TCP | |
[ ] ENABLE_TLS | | [ ] USE_ALIASES | | [*] USE_AUTH | | [ ] USE_DBACC
| | [ ] USE_DBUSRLOC | | [ ] USE_DIALOG | | [ ] USE_MULTIDOMAIN | | [
] USE_NAT | | [ ] USE_PRESENCE | | [ ] USE_DIALPLAN | | [ ]
VM_DIVERSION | | [ ] HAVE_INBOUND_PSTN | | [ ] HAVE_OUTBOUND_PSTN | |
[ ] USE_DR_PSTN | | [ ] USE_HTTP_MANAGEMENT_INTERFACE |
|____________________________________________|
Then start the opensips. But REGISTER get 401 fail message.
REGISTER sip:192.168.3.53 SIP/2.0
Via: SIP/2.0/UDP
10.120.100.250:39720;branch=z9hG4bK-d87543-ec515058dd0d9227-1--d87543-;rport
Max-Forwards: 70
Contact: <sip:[email protected]:39720;rinstance=69251742e61e3bf0>
To: "1000"<sip:[email protected]>
From: "1000"<sip:[email protected]>;tag=a16e1263
Call-ID: ZTY2NDZlYjc1ZTE3MGE4ZjI5YzhhZjA4M2IzYTIyZTc.
CSeq: 1 REGISTER
Expires: 3600
Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, NOTIFY, MESSAGE,
SUBSCRIBE, INFO
User-Agent: X-Lite release 1011s stamp 41150
Content-Length: 0
SIP/2.0 401 Unauthorized
Via: SIP/2.0/UDP
10.120.100.250:39720;received=192.168.3.250;branch=z9hG4bK-d87543-ec515058dd0d9227-1--d87543-;rport=39720
To:
"1000"<sip:[email protected]>;tag=a42c.30207dd1fda47907656684ceecd519a5
From: "1000"<sip:[email protected]>;tag=a16e1263
Call-ID: ZTY2NDZlYjc1ZTE3MGE4ZjI5YzhhZjA4M2IzYTIyZTc.
CSeq: 1 REGISTER
WWW-Authenticate: Digest realm="192.168.3.53",
nonce="Tx723UFoxz9VG6/4szaVxWNyEKleCmoNQbbunbDRcdAA", qop="auth"
Server: OpenSIPS (3.3.1 (x86_64/linux))
Content-Length: 0
The opensips.cfg is attached. Please help check where is the problem.
Thanks!
BR,
SparkleZou
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
