[Serusers] Adding new user

[José Nunes]

  Hello again,

  I got through the problem of adding new user, by writing these two lines
to ser.cfg:
           lookup("aliases");
           setflag(1);

  Its strange, because it seems that if this isn't done, the serctl command
doesn't allow adding new users.
  Nevertheless, here's the debugging of the serctl command when I still had
the problem:

  [root at klingon sbin]# serctl add user1 user1 user1 at klingon.av.it.pt
  + PID_FILE=/var/run/ser.pid
  + SYSLOG=1
  + STARTOPTIONS=
  ++ dirname /usr/local/sbin/serctl
  + DIR=/usr/local/sbin
  + SERBIN=/usr/local/sbin/ser
  + '[' -z '' ']'
  + SER_FIFO=/tmp/ser_fifo
  + '[' -z '' ']'
  + WATCH_PERIOD=2
  + '[' -z '' ']'
  + SQL_DB=ser
  + '[' -z '' ']'
  + SQL_HOST=localhost
  + '[' -z '' ']'
  + SQL_USER=ser
  + '[' -z '' ']'
  + RO_USER=serro
  + '[' -z '' ']'
  + RO_PW=47serro11
  + GENHA1=gen_ha1
  + MYSQL=mysql
  + SER=sr
  + LAST_LINE=tail -1
  + VERIFY_ACL=1
  + ACL_GROUPS=local ld int voicemail free-pstn
  + FOREVER=2020-05-28 21:32:15
  + FOREVER_REL=1073741823
  + VERSION=$Revision: 1.76 $
  + '[' -z '' ']'
  + UL_TABLE=location
  + USER_COLUMN=username
  + CALLID_COLUMN=callid
  + '[' -z '' ']'
  + SUB_TABLE=subscriber
  + REALM_COLUMN=domain
  + HA1_COLUMN=HA1
  + HA1B_COLUMN=HA1B
  + PASSWORD_COLUMN=password
  + RPID_COLUMN=rpid
  + SUBSCRIBER_COLUMN=username
  + EMAIL_COLUMN=email_address
  + SUB_CREATED_COLUMN=datetime_created
  + SUB_MODIFIED_COLUMN=datetime_modified
  + PHP_LIB_COLUMN=phplib_id
  + '[' -z '' ']'
  + ACL_TABLE=grp
  + ACL_USER_COLUMN=username
  + ACL_DOMAIN_COLUMN=domain
  + ACL_GROUP_COLUMN=grp
  + ACL_MODIFIED_COLUMN=last_modified
  + ACL_DOMAIN_COLUMN=domain
  + '[' -z '' ']'
  + ALS_TABLE=aliases
  + A_USER_COLUMN=username
  + A_CONTACT_COLUMN=contact
  + A_EXPIRES_COLUMN=expires
  + A_Q_COLUMN=q
  + A_CALLID_COLUMN=callid
  + A_CSEQ_COLUMN=cseq
  + A_LAST_MODIFIED_COLUMN=last_modified
  + DOMAIN_TABLE=domain
  + '[' -z '' ']'
  + URI_TABLE=uri
  + URIUSER_COLUMN=uri_user
  + MODIFIED_COLUMN=last_modified
  + FIFO_DBG=0
  + EGREP=egrep
  + export PW
  + '[' 4 -ne 4 ']'
  + shift
  + credentials user1 user1
  + set_user user1
  ++ echo user1
  ++ awk -F @ '{print $1}'
  + SERUSER=user1
  ++ echo user1
  ++ awk -F @ '{print $2}'
  + SERDOMAIN=
  + '[' -z '' ']'
  + SERDOMAIN=klingon.av.it.pt
  + '[' -z klingon.av.it.pt ']'
  ++ gen_ha1 user1 klingon.av.it.pt user1
  + HA1=b2b56ee9986b1d259d12a8babf993634
  + '[' 0 -ne 0 ']'
  ++ gen_ha1 user1 at klingon.av.it.pt klingon.av.it.pt user1
  + HA1B=08f6a51d434cad750f7190b8152c19a4
  + '[' 0 -ne 0 ']'
  + prompt_pw
  + '[' -z '' ']'
  ++ stty -g
  +
savetty=500:5:bf:8a3b:3:1c:7f:15:4:0:1:0:11:13:1a:0:12:f:17:16:0:0:0:0:0:0:0
:0:0:0:0:0:0:0:0:0
  + printf 'MySql password: '
  MySql password: + stty -echo
  + read PW
  + stty
500:5:bf:8a3b:3:1c:7f:15:4:0:1:0:11:13:1a:0:12:f:17:16:0:0:0:0:0:0:0:0:0:0:0
:0:0:0:0:0
  + echo

  + is_user user1
  + QUERY=select count(*) from subscriber                 where
username='user1' and domain='klingon.av.it.pt';
  ++ sql_ro_query 'select count(*) from subscriber                where
username='\''user1'\'' and domain='\''klingon.av.it.pt'\'';'
  ++ mysql -h localhost -u serro -p47serro11 -e 'select count(*) from
subscriber          where username='\''user1'\'' and
domain='\''klingon.av.it.pt'\''; ;' ser
  ++ grep -v ERROR
  ++ tail -1
  + CNT=0
  + '[' 00 -eq 0 ']'
  + false
  + '[' 1 -eq 0 ']'
  + grep 404
  + fifo_cmd ul_show_contact aliases user1 at klingon.av.it.pt
  + '[' 00 -eq 1 ']'
  + '[' 3 -lt 1 ']'
  + name=ser_receiver_3472
  + path=/tmp/ser_receiver_3472
  + '[' '!' -w /tmp/ser_fifo ']'
  + mkfifo /tmp/ser_receiver_3472
  + '[' 0 -ne 0 ']'
  + chmod a+w /tmp/ser_receiver_3472
  + CMD=:ul_show_contact:ser_receiver_3472\n
  + shift
  + '[' -n aliases ']'
  + CMD=:ul_show_contact:ser_receiver_3472\naliases\n
  + shift
  + '[' -n user1 at klingon.av.it.pt ']'
  +
CMD=:ul_show_contact:ser_receiver_3472\naliases\nuser1 at klingon.av.it.pt\n
  + shift
  + '[' -n '' ']'
  +
CMD=:ul_show_contact:ser_receiver_3472\naliases\nuser1 at klingon.av.it.pt\n\n
  + trap 'rm -f /tmp/ser_receiver_3472; kill 0' 2
  + cat
  + filter_fl
  + awk 'BEGIN {line=0;IGNORECASE=1;}
                  {line++}
                  line==1 && /^200 ok/ { next }
                  { print }'
  + printf
':ul_show_contact:ser_receiver_3472\naliases\nuser1 at klingon.av.it.pt\n\n'
  + wait
  + rm /tmp/ser_receiver_3472
  + '[' 00 -eq 1 ']'
  + '[' 1 -ne 0 ']'
  + echo error: overlap with an existing alias
  error: overlap with an existing alias
  + exit 1