<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 10">
<meta name=Originator content="Microsoft Word 10">
<link rel=File-List href="cid:filelist.xml@01C5D5AF.6630BB70">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="time"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="date"/>
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:553679495 -2147483648 8 0 66047 0;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:536871559 0 0 0 415 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;
text-underline:single;}
span.EmailStyle17
{mso-style-type:personal-reply;
mso-style-noshow:yes;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Arial;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:navy;}
span.SpellE
{mso-style-name:"";
mso-spl-e:yes;}
span.GramE
{mso-style-name:"";
mso-gram-e:yes;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";}
</style>
<![endif]--><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=EN-US link=blue vlink=purple style='tab-interval:.5in'>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hi,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><span style='mso-tab-count:1'> </span>I
have two queries bases upon the topic.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>1. What filed can <span
class=SpellE>i</span> use from the subscriber table to assign each user, upon registration
a DID to make them reachable from <span class=SpellE>pstn</span>. That field
will be used as 'username' in the aliases table to implement this functionality
(an <span class=SpellE>insertin</span> into aliases...), then do a <span
class=GramE>lookup(</span>aliases)<span style='mso-spacerun:yes'> </span>in <span
class=SpellE>ser.cfg</span>. <span class=GramE>If my approach is wrong, kindly
guide.</span><o:p></o:p></span></font></p>
<p class=MsoNormal style='text-indent:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>2. IS the ser-><span
class=SpellE>timezone</span> filed really <span class=GramE>needed.</span><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-indent:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>Thanks<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-indent:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>Ashutosh<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> serusers-bounces@lists.iptel.org
[mailto:serusers-bounces@lists.iptel.org] <b><span style='font-weight:bold'>On Behalf
Of </span></b>sip<br>
<b><span style='font-weight:bold'>Sent:</span></b> </span></font><st1:date
Month="10" Day="20" Year="2005"><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>Thursday, October 20, 2005</span></font></st1:date><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> </span></font><st1:time
Hour="19" Minute="8"><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'>7:08 PM</span></font></st1:time><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'><br>
<b><span style='font-weight:bold'>To:</span></b> Frank Fischer;
serusers@lists.iptel.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [Serusers] Which
database fields (table subscriber and aliases)are needed by ser?</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:
12.0pt;margin-left:.5in'><b><font size=2 face="Times New Roman"><span
style='font-size:10.0pt;font-weight:bold'>I'm happy to add some comments based
on what I know... <br>
<br>
On Thu, </span></font></b><st1:date Month="10" Day="20" Year="2005"><b><font
size=2><span style='font-size:10.0pt;font-weight:bold'>20 Oct 2005</span></font></b></st1:date><b><font
size=2><span style='font-size:10.0pt;font-weight:bold'> </span></font></b><st1:time
Hour="15" Minute="14"><b><font size=2><span style='font-size:10.0pt;font-weight:
bold'>15:14:46</span></font></b></st1:time><b><font size=2><span
style='font-size:10.0pt;font-weight:bold'> +0200, Frank Fischer wrote</span></font></b><font
size=2><span style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>Hi all</span></font><font size=2><span style='font-size:
10.0pt'> <br>
> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>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).</span></font><font size=2><span
style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>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?</span></font><font
size=2><span style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>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?</span></font><font
size=2><span style='font-size:10.0pt'> <br>
> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>If there is no such documentation, maybe someone knows and
would be willing to place a few comments to the table listings below?</span></font><font
size=2><span style='font-size:10.0pt'> <br>
> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>Thanks a lot for your help!</span></font><font size=2><span
style='font-size:10.0pt'> <br>
> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>Kind regards</span></font><font size=2><span
style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>Frank</span></font><font size=2><span style='font-size:
10.0pt'> <br>
> <br>
> <br>
> <br>
<br>
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) <br>
<br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>subscriber</span></font><font size=2><span
style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>------------------------</span></font><font size=2><span
style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>phplib_id</span></font><font size=2><span
style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>username</span></font><font size=2><span style='font-size:
10.0pt'> (needed -- this is just as it says, the username someone registers
with... either a word or a number) <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>domain</span></font><font size=2><span style='font-size:
10.0pt'> (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)
<br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>password</span></font><font size=2><span style='font-size:
10.0pt'> (needed -- this is the plaintext password for the user) <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>first_name</span></font><font size=2><span
style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>last_name</span></font><font size=2><span
style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>phone</span></font><font size=2><span style='font-size:
10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>email_address</span></font><font size=2><span
style='font-size:10.0pt'> (needed for things like SEMS in order to send
voicemail... not otherwise necessary) <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>datetime_created</span></font><font size=2><span
style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>datetime_modified</span></font><font size=2><span
style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>confirmation</span></font><font size=2><span
style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>flag</span></font><font size=2><span style='font-size:
10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>sendnotification</span></font><font size=2><span
style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>greeting</span></font><font size=2><span style='font-size:
10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>ha1</span></font><font size=2><span style='font-size:10.0pt'>
(needed -- this is an md5 of the string
"<username>:<domain>:<password>" needed if you're
using digest authentication) <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>ha1b</span></font><font size=2><span style='font-size:
10.0pt'> (needed -- another md5 string... this one is
"<username@domain>:<domain>:<password>" ) <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>allow_find</span></font><font size=2><span
style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>timezone</span></font><font size=2><span style='font-size:
10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>rpid</span></font><font size=2><span style='font-size:
10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>domn</span></font><font size=2><span style='font-size:
10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>uuid</span></font><font size=2><span style='font-size:
10.0pt'> <br>
> <br>
> <br>
> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>aliases</span></font><font size=2><span style='font-size:
10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>------------------------</span></font><font size=2><span
style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>username</span></font><font size=2><span style='font-size:
10.0pt'> (needed -- this is the alias itself i.e. what someone would dial to
get the original user) <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>domain</span></font><font size=2><span style='font-size:
10.0pt'> (I imagine it's needed for multiple domains, but no matter what I set
my SIP_DOMAIN to, it's always blank on mine) <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>contact</span></font><font size=2><span style='font-size:
10.0pt'> (this is a SIP URI of the actual username which the alias maps to.
sip:originaluser@domain.com ) <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>received</span></font><font size=2><span style='font-size:
10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>expires</span></font><font size=2><span style='font-size:
10.0pt'> (needed -- a date in the past makes this permanent) <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>q</span></font><font size=2><span style='font-size:10.0pt'>
<br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>callid</span></font><font size=2><span style='font-size:
10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>cseq</span></font><font size=2><span style='font-size:
10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>last_modified</span></font><font size=2><span
style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>replicate</span></font><font size=2><span
style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>state</span></font><font size=2><span style='font-size:
10.0pt'> <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>flags</span></font><font size=2><span style='font-size:
10.0pt'> (not sure what this is for or if it's needed) <br>
> </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>user_agent</span></font><font size=2><span
style='font-size:10.0pt'> <br>
<br>
<br>
The rest of those are all superfluous and not absolutely necessary. <br>
<br style='mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]></span></font><o:p></o:p></p>
</div>
</body>
</html>