27 Sep
2004
27 Sep
'04
8:54 a.m.
On 9/27/2004 2:38 PM, Pavel Siderov wrote:
Hi,
I have problem with acc module - according to
method.get_accounting.php there should be table coloumn named length
ant there have to be the call legth ... but
there is no such table in - latest CVS, 0.8.14 and 0.8.11 versions
(I've checked them). Can you help me I need to have call length for
every call for the billing.
there is no such column. 'length' is an alias to an expression returned
by SELECT => length=BYE_time - INVITE_time. You need to correlate the
BYEs with INVITEs and substract the time of the two requests to get the
length. If you enable SQL logging for MySQL you will see the whole
SELECT statement that serweb uses to get the call details.
Also is there version of acc for PostgreSQL.
Just load the postgres module instead of mysql.
Daniel
Thanks in advance.
Pavel Siderov,
Exsisto LTD
------------------------------------------------------------------------
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers