Re: [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','31e118ac5b09f071858740d6125d901d','');' new user '1000' added Regards Pavlo. _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users