Hello,
I recently installed ser 0.8.12. And after that, I reinstalled the database in MySQL. Now, when I try to add a new user with: serctl add user1 user1 user1@mydomain.com I get the following message: "error: overlap with an existing alias". Although I checked the Subscriber and Aliases tables, and there's no entry for user1. What can I do to correct this problem?
Thanks in advance
José Nunes
At 03:23 PM 1/6/2004, José Nunes wrote:
Hello,
I recently installed ser 0.8.12. And after that, I reinstalled the database in MySQL. Now, when I try to add a new user with: serctl add user1 user1 mailto:user1@mydomain.comuser1@mydomain.com I get the following message: "error: overlap with an existing alias". Although I checked the Subscriber and Aliases tables, and there's no entry for user1. What can I do to correct this problem?
debug it. run serctl in debugging mode (add the -x flag to #!/bin/sh line), see what the doublechecking database lookups return, and eventually report your findings to the mailing list.
thanks,
-jiri
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@klingon sbin]# serctl add user1 user1 user1@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@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@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@klingon.av.it.pt ']' + CMD=:ul_show_contact:ser_receiver_3472\naliases\nuser1@klingon.av.it.pt\n + shift + '[' -n '' ']' + CMD=:ul_show_contact:ser_receiver_3472\naliases\nuser1@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@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
Thanks for your report -- I did not realize that serctl assumes aliases are used by SER and alway checks new user names against conflicts with existing aliases. These checks are only successful, if aliases are turned on in SER, which is what you did with the line lookup("aliases") in SER script.
-jiri
At 02:04 PM 1/7/2004, José Nunes wrote:
Hello again,
I got through the problem of adding new user, by writing these two lines to ser.cfg: lookup("aliases"); setflag(1);
-
Jiri Kuthan -
José Nunes