20 Oct
2005
20 Oct
'05
5:14 p.m.
Hi all
i'm planing to create a simple application interface to administer
subscriber and alias data directly in the mysql db backend (i will use
Andreas Granig's userloc-cl module).
Looking at the mysql database that comes with ser, there seem to be a lot of
fields in the subscriber and aliases table that are not needed by ser itself
but only by serweb. Do i get this right?
If so, is there any specification of the fields that are required by ser
(incl. valid value range) so i know which fields i have to administer? Are
there any fields needed by ser which i may not touch?
If there is no such documentation, maybe someone knows and would be willing
to place a few comments to the table listings below?
Thanks a lot for your help!
Kind regards
Frank
subscriber
------------------------
phplib_id
username
domain
password
first_name
last_name
phone
email_address
datetime_created
datetime_modified
confirmation
flag
sendnotification
greeting
ha1
ha1b
allow_find
timezone
rpid
domn
uuid
aliases
------------------------
username
domain
contact
received
expires
q
callid
cseq
last_modified
replicate
state
flags
user_agent
20 Oct
20 Oct
5:33 p.m.
New subject: [Serusers] Which database fields (table subscriber and aliases) are needed by ser?
On 20-10-2005 15:14, Frank Fischer wrote:
Hi all
i'm planing to create a simple application interface to administer
subscriber and alias data directly in the mysql db backend (i will use
Andreas Granig's userloc-cl module).
Looking at the mysql database that comes with ser, there seem to be a lot of
fields in the subscriber and aliases table that are not needed by ser itself
but only by serweb. Do i get this right?
Yes.
If so, is there any specification of the fields that
are required by ser
(incl. valid value range) so i know which fields i have to administer? Are
there any fields needed by ser which i may not touch?
If there is no such documentation, maybe someone knows and would be willing
to place a few comments to the table listings below?
Thanks a lot for your help!
Kind regards
Frank
subscriber
------------------------
phplib_id -- Will be droped in the future
username -- Needed by ser (auth_db module)
domain -- Needed by ser (auth_db module)
password -- Needed by ser (auth_db module)
first_name -- serweb only
last_name -- serweb only
phone -- serweb only
email_address -- serweb and sems (voicemail)
datetime_created -- not needed
datetime_modified -- not needed
confirmation -- serweb only
flag -- serweb (and optionaly ser)
sendnotification -- serweb only
greeting -- serweb only
ha1 -- ser (auth_db module)
ha1b -- ser (auth_db module)
allow_find -- serweb only
timezone -- serweb and ser
rpid -- ser
domn -- not needed at the moment
uuid -- will be used in the future by serweb and ser
aliases
------------------------
username
domain
contact
received
expires
q
callid
cseq
last_modified -- not needed
replicate -- not needed
state
flags
user_agent
Jan.
5:37 p.m.
New subject: [Serusers] Which database fields (table subscriber and aliases) are needed by ser?
I'm happy to add some comments based on what I know...
On Thu, 20 Oct 2005 15:14:46 +0200, Frank Fischer wrote
Hi all
i'm planing to create a simple application interface to administer subscriber and
alias data directly in the mysql db backend (i will use Andreas Granig's userloc-cl
module).
Looking at the mysql database that comes with ser, there seem to be a lot of fields in
the subscriber and aliases table that are not needed by ser itself but only by serweb. Do
i get this right?
If so, is there any specification of the fields that are required by ser (incl.
valid value range) so i know which fields i have to administer? Are there any fields
needed by ser which i may not touch?
If there is no such documentation, maybe someone knows and would be willing to place a
few comments to the table listings below?
Thanks a lot for your help!
Kind regards
Frank
The ones needed for ser, I'll comment (and what they're needed for as far as I
know... please feel free to make corrections)
subscriber
------------------------
phplib_id
username(needed -- this is just as it says, the username someone registers with... either
a word or a number)
domain(needed -- this is the domain for that user. Multiple domains are supported, so SER
needs a way of knowing which users to put with which domains)
password (needed -- this is the plaintext password for the user)
first_name
last_name
phone
email_address(needed for things like SEMS in order to send voicemail... not otherwise
necessary)
datetime_created
datetime_modified
confirmation
flag
sendnotification
greeting
ha1(needed -- this is an md5 of the string
"<username>:<domain>:<password>" needed if you're using
digest authentication)
ha1b (needed -- another md5 string... this one is
"<username@domain>:<domain>:<password>" )
allow_find
timezone
rpid
domn
uuid
aliases
------------------------
username(needed -- this is the alias itself i.e. what someone would dial to get the
original user)
domain(I imagine it's needed for multiple domains, but no matter what I set my
SIP_DOMAIN to, it's always blank on mine)
contact(this is a SIP URI of the actual username which the alias maps to.
sip:originaluser@domain.com )
received
expires(needed -- a date in the past makes this permanent)
q
callid
cseq
last_modified
replicate
state
flags(not sure what this is for or if it's needed)
user_agent
The rest of those are all superfluous and not absolutely necessary.
9:56 p.m.
New subject: [Serusers] Which database fields (table subscriber and aliases) are needed by ser?
Yay.. and therein lies the glory of a community forum. Thanks. I can update my
notes on that.
N.
On Thu, 20 Oct 2005 16:10:51 +0200, Andreas Granig wrote
sip wrote:
> expires (needed -- a date in the past makes
this permanent)
Ehm, no. You've to set the "flags" column to 128 to make it permanent.
Andy 
6:19 p.m.
New subject: [Serusers] Which database fields (table subscriber and aliases)are needed by ser?
Hi,
I have two queries bases upon the topic.
1. What filed can i use from the subscriber table to assign each user,
upon registration a DID to make them reachable from pstn. That field
will be used as 'username' in the aliases table to implement this
functionality (an insertin into aliases...), then do a lookup(aliases)
in ser.cfg. If my approach is wrong, kindly guide.
2. IS the ser->timezone filed really needed.
Thanks
Ashutosh
-----Original Message-----
From: serusers-bounces(a)iptel.org [mailto:serusers-bounces@lists.iptel.org] On
Behalf Of sip
Sent: Thursday, October 20, 2005 7:08 PM
To: Frank Fischer; serusers(a)lists.iptel.org
Subject: Re: [Serusers] Which database fields (table subscriber and
aliases)are needed by ser?
I'm happy to add some comments based on what I know...
On Thu, 20 Oct 2005 15:14:46 +0200, Frank Fischer wrote
Hi all
i'm planing to create a simple application interface to administer
subscriber
and alias data directly in the mysql db backend (i will use
Andreas Granig's userloc-cl module).
Looking at the mysql database that comes with ser,
there seem to be a
lot of fields in the subscriber and aliases table that are not
needed by
ser itself but only by serweb. Do i get this right?
If so, is there any specification of the fields that
are required by
ser (incl. valid value range) so i know which fields i have to
administer? Are there any fields needed by ser which i may not touch?
If there is no such documentation, maybe someone knows and would be
willing to
place a few comments to the table listings below?
Thanks a lot for your help!
Kind regards
Frank
The ones needed for ser, I'll comment (and what they're needed for as
far as I know... please feel free to make corrections)
subscriber
------------------------
phplib_id
username (needed -- this is just as it says, the username someone
registers with...
either a word or a number)
domain (needed -- this is the domain for that user.
Multiple domains
are supported, so SER needs a way of knowing which users to put
with
which domains)
password (needed -- this is the plaintext password
for the user)
first_name
last_name
phone
email_address (needed for things like SEMS in order to send
voicemail... not
otherwise necessary)
datetime_created
datetime_modified
confirmation
flag
sendnotification
greeting
ha1 (needed -- this is an md5 of the string
"<username>:<domain>:<password>" needed if you're
using digest
authentication)
ha1b (needed -- another md5 string... this one is
"<username@domain>:<domain>:<password>" )
allow_find
timezone
rpid
domn
uuid
aliases
------------------------
username (needed -- this is the alias itself i.e. what someone would
dial to get
the original user)
domain (I imagine it's needed for multiple
domains, but no matter what
I set my SIP_DOMAIN to, it's always blank on mine)
contact (this is a SIP URI of the actual username
which the alias maps
to. sip:originaluser@domain.com )
received
expires (needed -- a date in the past makes this permanent)
q
callid
cseq
last_modified
replicate
state
flags (not sure what this is for or if it's needed)
user_agent
The rest of those are all superfluous and not absolutely necessary.
6963
days inactive
6963
days old
5 comments
5 participants
participants (5)
-
Andreas Granig -
Ashutosh kumar -
Frank Fischer -
Jan Janak -
sip