[OpenSIPS-Users] special characters on password field

[Bogdan-Andrei Iancu]

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 1234 at sip.domain.com <mailto: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 <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 at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20230103/e7828111/attachment.html>