I had the same problem.
Eventually I changed the /usr/local/sbin/ser_mysql.sh setup script and recreated the sql tables as follows:
# # Table structure for table 'aliases' -- location-like table #
CREATE TABLE aliases ( $USERCOL BIGINT NOT NULL AUTO_INCREMENT default '', domain varchar(128) NOT NULL default 'mydomain.com', contact varchar(255) NOT NULL default '', expires datetime default NULL, q float(10,2) default NULL, callid varchar(255) default NULL, cseq int(11) default NULL, last_modified timestamp(14) NOT NULL, replicate int(10) unsigned default NULL, state tinyint(1) unsigned default NULL, flags int(11) NOT NULL default '0', PRIMARY KEY($USERCOL, domain, contact) ) $TABLE_TYPE;
Hope it helps.
Mike
-----Original Message----- From: serusers-bounces@iptel.org [mailto:serusers-bounces@lists.iptel.org]On Behalf Of cybermambo Sent: 02 March 2004 15:48 To: Jan Janak Cc: serusers@lists.iptel.org Subject: Re: [Serusers] RE: Auto adding alias after registration confirmation?
Jan, It's creating the same numeric alias for every new user who subscribes through serweb.
I don't quite see the use of this since I would create alias separately using serctl, when users specifically request for aliases.
Is there a way to control this behavior or simply turn the auto numeric alias off?
--- Jan Janak jan@iptel.org wrote:
Nothing is wrong, serweb creates a numeric alias for each username automatically.
Jan.
On 01-03 21:30, cybermambo wrote:
I rebuilt my server with fresh install and plain configuration:
SERCTL: 1.62.4.1 SER: 0.8.12-tcp_nonb (i386/linux)
Through serweb's user interface, I subscribed for
user
"8111". Confirmation went well. However, the
system
auto added alias of 82000 for the user I created.
What
could be wrong?
"serctl ul show" gives me:
...Record(0x422bb140)... domain: 'aliases' aor : '82000'
domain : 'aliases' aor : '82000' Contact: 'sip:8111@mydomain.com' Expires: 567647871 q : 1.00 Call-ID:
'The-Answer-To-The-Ultimate-Question-Of-Life-Universe-And-Everything'
CSeq : 42 replic : 0 State : CS_SYNC Flags : 0 next : (nil) prev : (nil)
.../Record... ser.cfg: ========= # # $Id: ser.cfg,v 1.21.4.1 2003/11/10 15:35:15andrei
Exp $ # # simple quick-start config script #
# ----------- global configuration parameters
#debug=3 # debug level (cmd line:
-dddddddddd)
#fork=yes #log_stderror=no # (cmd line: -E)
/* Uncomment these lines to enter debugging mode debug=7 fork=no log_stderror=yes */
check_via=no # (cmd. line: -v) dns=no # (cmd. line: -r) rev_dns=no # (cmd. line: -R) #port=5060 #children=4 fifo="/tmp/ser_fifo" fifo_mode=0666
# ------------------ module loading
# Uncomment this if you want to use SQL database loadmodule "/usr/local/lib/ser/modules/mysql.so"
loadmodule "/usr/local/lib/ser/modules/sl.so" loadmodule "/usr/local/lib/ser/modules/tm.so" loadmodule "/usr/local/lib/ser/modules/rr.so" loadmodule "/usr/local/lib/ser/modules/maxfwd.so" loadmodule "/usr/local/lib/ser/modules/usrloc.so" loadmodule
"/usr/local/lib/ser/modules/registrar.so"
# Uncomment this if you want digest authentication # mysql.so must be loaded ! loadmodule "/usr/local/lib/ser/modules/auth.so" loadmodule "/usr/local/lib/ser/modules/auth_db.so"
# ----------------- setting module-specific
parameters
# -- usrloc params --
#modparam("usrloc", "db_mode", 0)
# Uncomment this if you want to use SQL database # for persistent storage and comment the previous
line
modparam("usrloc", "db_mode", 2)
# -- auth params -- # Uncomment if you are using auth module # modparam("auth_db", "calculate_ha1", yes) # # If you set "calculate_ha1" parameter to yes
(which
true in this config), # uncomment also the following parameter) # modparam("auth_db", "password_column", "password")
# -- rr params -- # add value to ;lr param to make some broken UAs
happy
modparam("rr", "enable_full_lr", 1)
# ------------------------- request routing logic
# main routing logic alias=sip01.mydomain.com
route{ # initial sanity checks -- messages with # max_forwards==0, or excessively long requests if (!mf_process_maxfwd_header("10")) { sl_send_reply("483","Too Many
Hops");
break; }; if ( msg:len > max_len ) { sl_send_reply("513", "Message toobig"); break; };
# we record-route all messages -- to makesure
that # subsequent messages will go through our proxy; that's # particularly good if upstream and
downstream
entities # use different transport protocol record_route(); # loose-route processing if (loose_route()) { t_relay(); break; };
# if the request is for other domain useUsrLoc # (in case, it does not work, use the following command # with proper names and addresses in it) if (uri==myself) { if (method=="REGISTER") {
# Uncomment this if you want to use digest authentication if (!www_authorize("mydomain.com", "subscriber")) {
www_challenge("mydomain.com", "0"); break; }; save("location"); break; }; lookup("aliases");
# native SIP destinations arehandled
using our USRLOC DB if (!lookup("location")) { sl_send_reply("404", "Not Found"); break; }; }; # forward to current uri now; use stateful forwarding; that # works reliably even if we forward from
TCP
to UDP if (!t_relay()) {
=== message truncated ===
__________________________________ Do you Yahoo!? Yahoo! Search - Find what youre looking for faster http://search.yahoo.com
_______________________________________________ Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers