<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
thanks for report and troubleshooting.<br>
<br>
Can you make a pull request with the patch that you think is fixing
the issue? It will be easier to review and merge if allok. Use the
github for that:<br>
<br>
- <a class="moz-txt-link-freetext" href="https://github.com/kamailio/kamailio/pulls">https://github.com/kamailio/kamailio/pulls</a><br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 17/10/15 02:32, Pavlo Karbovnyk
wrote:<br>
</div>
<blockquote cite="mid:1445041938.2396.14.camel@gmail.com"
type="cite">
<div>Good Day All.</div>
<div><br>
</div>
<div>I run into following problem:</div>
<div>(It may be helpful for other people how have similar problem)</div>
<div><br>
</div>
<div>kamctl add 1000 password</div>
<div>database engine 'PGSQL' loaded</div>
<div>Control engine 'FIFO' loaded</div>
<div>is_user: user counter=0 <--- showing
counter=0</div>
<div>check_db_alias: alias counter= <--- showing
counter= nothing</div>
<div>INFO: user '1000' already exists as alias</div>
<div><br>
</div>
<div>============================================================</div>
<div>how to fix it :</div>
<div><br>
</div>
<div>in kamctl locate a function</div>
<div><br>
</div>
<div>check_db_alias() {</div>
<div>.....</div>
<div> CNT=`$DBROCMD "$QUERY" | $EGREP -v ERROR | $LAST_LINE`</div>
<div>.....</div>
<div>}</div>
<div><br>
</div>
<div>replace with CNT command with following:</div>
<div>
<div><br>
</div>
<div>check_db_alias() {</div>
<div>.....</div>
<div> CNT=`$DBROCMD "$QUERY" <b>"$DBRAWPARAMS"</b> |
$EGREP -v ERROR | $LAST_LINE`</div>
<div>.....</div>
<div>}</div>
<div><u><br>
</u></div>
<div>
<div>============================================================</div>
<div>after this</div>
<div><br>
</div>
</div>
<div>kamctl add 1000 password</div>
<div>database engine 'PGSQL' loaded</div>
<div>Control engine 'FIFO' loaded</div>
<div>is_user: user counter=0</div>
<div>check_db_alias: alias counter=0</div>
<div>pgsql_query: /usr/bin/psql -A -q -t -P fieldsep='<span class="Apple-tab-span" style="white-space:pre"> </span>'
-h localhost -U kamailio kamailio -c 'insert into subscriber
(username,<span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span>domain,ha1,ha1b,password) <span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span>values
('1000','127.0.0.1','6fda0594de6ea94b03a12fdd998758ae','31e118ac5b09f071858740d6125d901d','');'</div>
<div>new user '1000' added</div>
<div><br>
</div>
<div>Regards Pavlo.</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Book: SIP Routing With Kamailio - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a></pre>
</body>
</html>