<HTML>
<HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="Open WebMail 2.20 20031014" name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<font size="2"><b>I'm happy to add some comments based on what I know...
<br />
<br />On Thu, 20 Oct 2005 15:14:46 +0200, Frank Fischer wrote</b>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005">Hi
all</span></font>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005"></span></font>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005">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>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005">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>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005">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>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005"></span></font>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005">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>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005"></span></font>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005">Thanks a lot for
your help!</span></font>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005"></span></font>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005">Kind
regards</span></font>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005">Frank</span></font>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005"></span></font>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005"></span></font>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005"></span></font>
<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 />> <font size="2" face="Verdana"><span class="536204312-20102005">subscriber</span></font>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005">------------------------</span></font>
<br />> <font size="2" face="Verdana">phplib_id</font>
<br />> <font size="2" face="Verdana">username</font>
(needed -- this is just as it says, the username someone registers with... either a word or a number)
<br />> <font size="2" face="Verdana">domain</font>
(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 />> <font size="2" face="Verdana">password</font>
(needed -- this is the plaintext password for the user)
<br />> <font size="2" face="Verdana">first_name</font>
<br />> <font size="2" face="Verdana">last_name</font>
<br />> <font size="2" face="Verdana">phone</font>
<br />> <font size="2" face="Verdana">email_address</font>
(needed for things like SEMS in order to send voicemail... not otherwise necessary)
<br />> <font size="2" face="Verdana">datetime_created</font>
<br />> <font size="2" face="Verdana">datetime_modified</font>
<br />> <font size="2" face="Verdana">confirmation</font>
<br />> <font size="2" face="Verdana">flag</font>
<br />> <font size="2" face="Verdana">sendnotification</font>
<br />> <font size="2" face="Verdana">greeting</font>
<br />> <font size="2" face="Verdana">ha1</font>
(needed -- this is an md5 of the string "<username>:<domain>:<password>" needed if you're using digest authentication)
<br />> <font size="2" face="Verdana">ha1b</font> (needed -- another md5 string... this one is "<username@domain>:<domain>:<password>" )
<br />> <font size="2" face="Verdana">allow_find</font>
<br />> <font size="2" face="Verdana">timezone</font>
<br />> <font size="2" face="Verdana">rpid</font>
<br />> <font size="2" face="Verdana">domn</font>
<br />> <font size="2" face="Verdana">uuid</font>
<br />>
<br />>
<br />>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005">aliases</span></font>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005">------------------------</span></font>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005">username</span></font>
(needed -- this is the alias itself i.e. what someone would dial to get the original user)
<br />> <font size="2" face="Verdana"><span class="536204312-20102005">domain</span></font>
(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 />> <font size="2" face="Verdana"><span class="536204312-20102005">contact</span></font>
(this is a SIP URI of the actual username which the alias maps to. sip:originaluser@domain.com )
<br />> <font size="2" face="Verdana"><span class="536204312-20102005">received</span></font>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005">expires</span></font>
(needed -- a date in the past makes this permanent)
<br />> <font size="2" face="Verdana"><span class="536204312-20102005">q</span></font>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005">callid</span></font>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005">cseq</span></font>
<br />> <font size="2" face="Verdana"><span class="536204312-20102005">last_modified</span></font>
<br />> <font size="2" face="Verdana">replicate</font>
<br />> <font size="2" face="Verdana">state</font>
<br />> <font size="2" face="Verdana">flags</font>
(not sure what this is for or if it's needed)
<br />> <font size="2" face="Verdana">user_agent</font>
<br />
<br />
<br />The rest of those are all superfluous and not absolutely necessary.
<br />
<br />
<br />
<br />
</font>
</BODY>
</HTML>