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

Wed Sep 7 03:31:55 UTC 2022

Hi Bogdan-Andrei,

Really thanks! It works now.

Here I'm trying to go further steps.

Try to set the domain name.

only add "opensips-cli -x user add 1000 at sip-server.com S3cureP4s$"

sip-server.com already set to 192.168.3.53 at dns side.

Change at X-lite to use 1000 at sip-server.com failed to log in.

Then try to use the USE_MULTIDOMAIN . Generate the script. And set according to domain Module (opensips.org) as following:

#### DOMAIN module
loadmodule "domain.so"
modparam("domain", "db_url",
        "mysql://opensips:opensipsrw@localhost/opensips") # CUSTOMIZE ME
modparam("domain", "db_mode", 0)   # Use caching
modparam("auth_db|usrloc", "use_domain", 1)
modparam("domain", "domain_table", "domain")
modparam("domain", "domain_col", "domain")
modparam("domain", "attrs_col", "attrs")

But got the error "483 Too Many Hops". seems should run command "insert into domian(domain) values('192.168.3.53');" to add the domain info in the table domain.

But got the following error.

MariaDB [opensips]> insert into domian(domain) values('192.168.3.53);
ERROR 1146 (42S02): Table 'opensips.domian' doesn't exist

Puzzled me.

Please help me. Thanks!

BR,
Sparkle Zou

At 2022-09-06 16:27:10, "Bogdan-Andrei Iancu" <bogdan at opensips.org> wrote:

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

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

_______________________________________________
Users mailing list
Users at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20220907/357ec440/attachment-0001.html>