<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-9">
<META content="MSHTML 6.00.2900.2627" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Dear List,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Currently working in Billing Software for
SER.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The problem i've met is very
interesting:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial
size=2>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>></FONT></DIV>
<DIV><FONT face=Arial size=2>modparam("auth_db", "calculate_ha1",
1)<BR>modparam("auth_db", "password_column", "password")<BR>modparam("auth_db",
"use_domain", 1)</FONT></DIV>
<DIV><FONT face=Arial
size=2><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>As you see above i force SER to use passwords
in "password" column as plain texts.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>* I create some users via console by using
openserctl / serctl command.</FONT></DIV>
<DIV><FONT face=Arial size=2>* Register some ATA's to SER, no problem, auth
and accounting is working perfect.</FONT></DIV>
<DIV><FONT face=Arial size=2>* They can call each other and PSTN connectivity is
fine.</FONT></DIV>
<DIV><FONT face=Arial size=2>* I tried to code a PHP for
creation/deletion/editing of users.</FONT></DIV>
<DIV><FONT face=Arial size=2>* I managed to write values into database :
"username", "domain", "password", "first_name", "last_name", "phone", "e_mail"
as they come default in table, i added one more table for "address" which will
be used to keep customer's address when i want to send invoices or post them
something.</FONT></DIV>
<DIV><FONT face=Arial size=2>* I can see some accounts created from PHP
:)</FONT></DIV>
<DIV><FONT face=Arial size=2>* They can register with SER, no problem. They can
call to others and PSTN, no problem.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Ka'Booom !!!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>When i look into "acc" table, i cannot see INVITEs
and BYEs for customers who are created via PHP, only BYE lines written into
database. I'm sure that INVITE, ACK and BYE's are written if i create a user
with openserctl / serctl utility but not from PHP-created ones</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The difference between openserctl/serctl created
ones and the PHP-created ones are :</FONT></DIV>
<DIV><FONT face=Arial size=2>"phplib_id", "ha" and "ha1b" are empty in my
examples and also "datetime_created" values are "0000-00-00
00:00:00"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I do not know why caused accounting module
to log only "BYE" messages and what is the solution ?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>btw : a very early demo for upcoming opensource
billing for OpenSER / SER can be seen at <A
href="http://www.intertet.net/goktar/?page=x">http://www.intertet.net/goktar/?page=x</A></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2>Ozan</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>