[SR-Users] Kamctl cannot add user to pgsql

Good Day All.

I run into following problem: (It may be helpful for other people how have similar problem)

kamctl add 1000 password database engine 'PGSQL' loaded Control engine 'FIFO' loaded is_user: user counter=0 <--- showing counter=0 check_db_alias: alias counter= <--- showing counter= nothing INFO: user '1000' already exists as alias

============================================================ how to fix it :

in kamctl locate a function

check_db_alias() { ..... CNT=`$DBROCMD "$QUERY" | $EGREP -v ERROR | $LAST_LINE` ..... }

replace with CNT command with following:

check_db_alias() { ..... CNT=`$DBROCMD "$QUERY" "$DBRAWPARAMS" | $EGREP -v ERROR | $LAST_LINE` ..... }

============================================================ after this

kamctl add 1000 password database engine 'PGSQL' loaded Control engine 'FIFO' loaded is_user: user counter=0 check_db_alias: alias counter=0 pgsql_query: /usr/bin/psql -A -q -t -P fieldsep=' ' -h localhost -U kamailio kamailio -c 'insert into subscriber (username, domain,ha1,ha1b,password) values ('1000','127.0.0.1','6fda0594de6ea94b03a12fdd998758ae','31e118ac5b09f07 1858740d6125d901d','');' new user '1000' added

Regards Pavlo.