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(a)iptel.org [mailto:serusers-bounces@lists.iptel.org]On
Behalf Of cybermambo
Sent: 02 March 2004 15:48
To: Jan Janak
Cc: serusers(a)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(a)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'
~~~Contact(0x422bb180)~~~
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)
~~~/Contact~~~~
.../Record...
ser.cfg:
=========
#
# $Id: ser.cfg,v 1.21.4.1 2003/11/10 15:35:15
andrei
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 too
big");
break;
};
# we record-route all messages -- to make
sure
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 use
UsrLoc
# (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 are
handled
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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers