<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<font face="monospace">Hi Andrei,<br>
<br>
it looks like some escaping is needed. Please open a bug report
(with this issue) here <a class="moz-txt-link-freetext" href="https://github.com/OpenSIPS/opensips-cli">https://github.com/OpenSIPS/opensips-cli</a><br>
<br>
Regards,<br>
</font>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="https://www.opensips-solutions.com">https://www.opensips-solutions.com</a>
OpenSIPS Bootcamp 5-16 Dec 2022, online
<a class="moz-txt-link-freetext" href="https://www.opensips.org/training/OpenSIPS_eBootcamp_2022/">https://www.opensips.org/training/OpenSIPS_eBootcamp_2022/</a></pre>
<div class="moz-cite-prefix">On 12/13/22 1:08 PM, Andrei G. wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CALUe06-0mfhSQHdn9L7FG84CoDJ1iGTEDQwEDofx5V9Rx8VUug@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Hello,
<div><br>
</div>
<div>I'm trying to add a user with password containing %
character:</div>
<div><br>
</div>
<div>~# opensips-cli -i opensips-1 -f /etc/opensips-cli.cfg -x
user password <a href="mailto:1234@sip.domain.com"
moz-do-not-send="true">1234@sip.domain.com</a> '%1234'<br>
<br>
</div>
<div>ERROR: cannot execute query: UPDATE subscriber SET ha1 =
'1460228c41f725017708f4f684b7edb1', password = '%1234', ha1b =
'580f8f81d95fcec5e7044f9aba97868a' WHERE username = '1234' AND
domain = '
<a href="http://sip.domain.com" moz-do-not-send="true">sip.domain.com</a>'<br>
ERROR: (_mysql_exceptions.ProgrammingError) not enough
arguments for format string<br>
[SQL: UPDATE subscriber SET ha1 =
'1460228c41f725017708f4f684b7edb1',
password = '%1234', ha1b = '580f8f81d95fcec5e7044f9aba97868a'
WHERE username = '1234' AND domain = ' <a
href="http://sip.domain.com" moz-do-not-send="true">sip.domain.com</a>']<br>
(Background on this error at: <a
href="http://sqlalche.me/e/f405" moz-do-not-send="true">http://sqlalche.me/e/f405</a>)<br>
</div>
<div><br>
</div>
<div>Please advice</div>
<div><br>
</div>
<div>Thanks</div>
<div>Andrei</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>