[OpenSIPS-Users] How to set auth_db module & db_mysql module work on opensips 3.3

[SparkleZou]

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


2. apt install mariadb-server
opensips-cli -x database create opensips


root at 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:1000 at 10.120.100.250:39720;rinstance=69251742e61e3bf0>

To: "1000"<sip:1000 at 192.168.3.53>

From: "1000"<sip:1000 at 192.168.3.53>;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:1000 at 192.168.3.53>;tag=a42c.30207dd1fda47907656684ceecd519a5

From: "1000"<sip:1000 at 192.168.3.53>;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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20220826/8a146707/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: opensips.cfg
Type: application/octet-stream
Size: 6726 bytes
Desc: not available
URL: <http://lists.opensips.org/pipermail/users/attachments/20220826/8a146707/attachment-0001.obj>