[OpenSIPS-Users] special characters on password field

[Andrei G.]

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
1234 at 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'
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']
(Background on this error at: http://sqlalche.me/e/f405)

Please advice

Thanks
Andrei
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20221213/273e8c6c/attachment-0001.html>