Dear List,
 
Currently working in Billing Software for SER.
 
The problem i've met is very interesting:
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
modparam("auth_db", "calculate_ha1", 1)
modparam("auth_db", "password_column", "password")
modparam("auth_db", "use_domain", 1)
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
 
As you see above i force SER to use passwords in "password" column as plain texts.
 
* I create some users via console by using openserctl / serctl command.
* Register some ATA's to SER, no problem, auth and accounting is working perfect.
* They can call each other and PSTN connectivity is fine.
* I tried to code a PHP for creation/deletion/editing of users.
* 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.
* I can see some accounts created from PHP :)
* They can register with SER, no problem. They can call to others and PSTN, no problem.
 
Ka'Booom !!!
 
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
 
The difference between openserctl/serctl created ones and the PHP-created ones are :
"phplib_id", "ha" and "ha1b" are empty in my examples and also "datetime_created" values are "0000-00-00 00:00:00"
 
I do not know why caused accounting module to log only "BYE" messages and what is the solution ?
 
btw : a very early demo for upcoming opensource billing for OpenSER / SER can be seen at http://www.intertet.net/goktar/?page=x
 
Thanks,
Ozan