[Serusers] RE: Auto adding alias after registration confirmation?
Mike Fallows
mike.fallows at netsquare.co.uk
Tue Mar 2 17:16:50 CET 2004
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 at iptel.org [mailto:serusers-bounces at lists.iptel.org]On
Behalf Of cybermambo
Sent: 02 March 2004 15:48
To: Jan Janak
Cc: serusers at 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 at 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 at 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 at lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
More information about the sr-users
mailing list