[Users] Billing Stopped in Account Creation (SERWEB Like)

[Ozan Blotter]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20050713/939291a0/attachment.htm