Hi Andrei,
it looks like some escaping is needed. Please open a bug report (with
this issue) here https://github.com/OpenSIPS/opensips-cli
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
https://www.opensips-solutions.com
OpenSIPS Bootcamp 5-16 Dec 2022, online
https://www.opensips.org/training/OpenSIPS_eBootcamp_2022/
On 12/13/22 1:08 PM, Andrei G. wrote:
Hello,
I'm trying to add a user with password containing % character:
~# opensips-cli -i opensips-1 -f /etc/opensips-cli.cfg -x user
password 1...@sip.domain.com <mailto:1...@sip.domain.com> '%1234'
ERROR: cannot execute query: UPDATE subscriber SET ha1 =
'1460228c41f725017708f4f684b7edb1', password = '%1234', ha1b =
'580f8f81d95fcec5e7044f9aba97868a' WHERE username = '1234' AND domain
= ' sip.domain.com <http://sip.domain.com>'
ERROR: (_mysql_exceptions.ProgrammingError) not enough arguments for
format string
[SQL: UPDATE subscriber SET ha1 = '1460228c41f725017708f4f684b7edb1',
password = '%1234', ha1b = '580f8f81d95fcec5e7044f9aba97868a' WHERE
username = '1234' AND domain = ' sip.domain.com <http://sip.domain.com>']
(Background on this error at: http://sqlalche.me/e/f405
<http://sqlalche.me/e/f405>)
Please advice
Thanks
Andrei
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
