<html><head></head><body style="font-family: Monospace;"><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`<u></u><u></u><u></u></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></body></html>