<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hi Folks, </div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I recently set up OpenSIPs 3.2 on AWS. All the installation and control panel setup went fine. I am facing two issues and was looking for some help to further troubleshoot it. </div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
1 - When I try to configure the users via the OpenSIPs control panel, I get following error when I click on Register:</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<b> <span style="font-family: calibri, helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgba(0, 0, 0, 0);">Inserting user record into DB failed: Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'ha1b' in 'field list' )</span></b></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I have no idea what is causing this error. </div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
2 - I am able to add users via OpenSIPs CLI:</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<b>opensips-cli -x user add alice@my.pub.lic.ip 123456</b><br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
but when alice is trying to register, I am seeing the following errors in the syslog file:</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Jul 27 05:35:17 ip-172-31-46-21 /usr/sbin/opensips[7618]: INFO:db_mysql:switch_state_to_disconnected: disconnect event for 0x7f51bb655e10
<div>Jul 27 05:35:17 ip-172-31-46-21 /usr/sbin/opensips[7618]: INFO:db_mysql:reset_all_statements: resetting all statements on connection: (0x7f51bb6566b0) 0x7f51bb655e10</div>
<div>Jul 27 05:35:17 ip-172-31-46-21 /usr/sbin/opensips[7618]: INFO:db_mysql:connect_with_retry: re-connected successful for 0x7f51bb655e10</div>
<div>Jul 27 05:35:17 ip-172-31-46-21 /usr/sbin/opensips[7618]: INFO:db_mysql:db_mysql_do_prepared_query: reconnected to mysql server -> re-init the statement</div>
<div><b>Jul 27 05:35:17 ip-172-31-46-21 /usr/sbin/opensips[7618]: ERROR:db_mysql:db_mysql_store_result: driver error: Commands out of sync; you can't run this command now</b></div>
<div><b>Jul 27 05:35:17 ip-172-31-46-21 /usr/sbin/opensips[7618]: ERROR:auth_db:get_ha1: failed to query database</b></div>
<div><b>Jul 27 05:35:18 ip-172-31-46-21 /usr/sbin/opensips[7615]: ERROR:db_mysql:db_mysql_store_result: driver error: Commands out of sync; you can't run this command now</b></div>
<div><b>Jul 27 05:35:18 ip-172-31-46-21 /usr/sbin/opensips[7615]: ERROR:auth_db:get_ha1: failed to query database</b></div>
<div>Jul 27 05:35:18 ip-172-31-46-21 /usr/sbin/opensips[7617]: ERROR:db_mysql:db_mysql_store_result: driver error: Commands out of sync; you can't run this command now</div>
<span>Jul 27 05:35:18 ip-172-31-46-21 /usr/sbin/opensips[7617]: ERROR:auth_db:get_ha1: failed to query database</span><br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span><br>
</span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I am using 'opensips' user for the MySQL database, I can log in with opensips user to the database:</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
MariaDB [(none)]> SELECT user FROM mysql. user;
<div>+----------+</div>
<div>| user |</div>
<div>+----------+</div>
<div>| opensips |</div>
<div>| root |</div>
<div>+----------+</div>
<div>2 rows in set (0.000 sec)</div>
<div><br>
</div>
<span>MariaDB [(none)]> exit</span><br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<b>root@ip-172-31-46-21:/etc/opensips# mysql -u opensips -p</b>
<div>Enter password:</div>
<div>Welcome to the MariaDB monitor. Commands end with ; or \g.</div>
<div>Your MariaDB connection id is 251</div>
<div>Server version: 10.3.29-MariaDB-0+deb10u1 Debian 10</div>
<div><br>
</div>
<div>Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.</div>
<div><br>
</div>
<div>Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.</div>
<div><br>
</div>
<span>MariaDB [(none)]></span><br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
and the URL I have specified in the opensips.cfg file is:</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span>#### USeR LOCation module
<div>loadmodule "usrloc.so"</div>
<div>modparam("usrloc", "nat_bflag", "NAT")</div>
<div>modparam("usrloc", "working_mode_preset", "single-instance-sql-write-back")</div>
<div>modparam("usrloc", "db_url",</div>
"<b>mysql://opensips:opensipsrw@localhost/opensips</b>") # CUSTOMIZE ME<br>
</span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span><span><br>
</span></span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span><span><br>
</span></span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span><span>From socket perspective, the MySQL is binded to local host 127.0.0.1 and opensips is binded to my VM private IP:</span></span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span><span><br>
</span></span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span><span>root@ip-172-31-46-21:/etc/opensips# netstat -natup | grep mysql
<div><b>tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 7700/mysqld</b></div>
<div>root@ip-172-31-46-21:/etc/opensips# netstat -natup | grep opensips</div>
<div>tcp 0 0 172.31.46.21:5060 0.0.0.0:* LISTEN 7609/opensips</div>
<div>tcp 0 0 0.0.0.0:8888 0.0.0.0:* LISTEN 7611/opensips</div>
<span><b>udp 0 0 172.31.46.21:5060 0.0.0.0:* 7609/opensips</b></span><br>
</span></span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span><span><span><br>
</span></span></span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span><span><span>my <span style="background-color:rgb(255, 255, 255);display:inline !important">opensips-cli.cfg contains:</span></span></span></span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span><span><span><br>
</span></span></span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span><span><span><br>
</span></span></span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span><span><span>root@ip-172-31-46-21:~# more ~/.opensips-cli.cfg
<div>[default]</div>
<div>log_level: WARNING</div>
<div>prompt_name: cli</div>
<div>prompt_intro: Welcome to CLI!</div>
<div>prompt_emptyline_repeat_cmd: False</div>
<div>history_file: ~/.opensips-cli.history</div>
<div>history_file_size: 1000</div>
<div>output_type: pretty-print</div>
<div>communication_type: fifo</div>
<div>fifo_file: /tmp/opensips_fifo</div>
<div>domain: opensips.org</div>
<div>#database_modules: acc clusterer dialog dialplan dispatcher domain rtpproxy usrloc</div>
<div>database_modules: ALL</div>
<div><br>
</div>
<div>#database_admin_url: postgres://root@localhost</div>
<div><b>database_admin_url: mysql://root@localhost</b></div>
<div><br>
</div>
<span>root@ip-172-31-46-21:~#</span><br>
</span></span></span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span><span><span><br>
</span></span></span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span><span><span><br>
</span></span></span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span>I am looking for some help, how can I troubleshoot the above two mentioned issues. Sorry if it is too basic a question as I am new to OpenSIPs and hope to learn from the great community. </span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span><br>
</span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span><br>
</span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span>Regards,</span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Shah Hussain </div>
</body>
</html>