Elastix billinghttp://store.palosanto.com/index.ph

Joined
May 16, 2007
Messages
113
Points
0
Hi,
On an elastix 2.3.0 on a new XR3030 Xorcom the billing report is not working.
The mysql table cdr in asteriskcdrdb is well updated, the file Master.csv in /var/log/asterisk/cdr-csv is well updated
But the sqlite3 table master.db is empty, then the billing report cannot retrieve any information. I've done a copy from a working master.db on the machine, but the file don't receive any new records.

Do you have an idea?

Thanks

Brice
 
Joined
May 16, 2007
Messages
113
Points
0
You can see belaow the result:

[root@ipbx db]# ll
total 456
-rw-r--r-- 1 asterisk asterisk 21504 Jan 9 17:02 acl.db
-rw-r--r-- 1 asterisk asterisk 4096 Feb 23 2012 addons.db
-rw-r--r-- 1 asterisk asterisk 3072 Feb 23 2012 address_book.db
-rw-r--r-- 1 asterisk asterisk 2048 Feb 23 2012 calendar.db
-rw-r--r-- 1 asterisk asterisk 3072 Dec 3 10:22 control_panel_design.db
-rw-r--r-- 1 asterisk asterisk 4096 Jan 8 11:18 dashboard.db
-rw-r--r-- 1 asterisk asterisk 40960 Jan 9 17:01 email.db
-rw-r--r-- 1 asterisk asterisk 35840 Oct 11 02:01 endpoint.db
-rw-rw-rw- 1 asterisk asterisk 7168 Feb 23 2012 fax.db
-rw-r--r-- 1 asterisk asterisk 3072 Feb 23 2012 FTP.db
-rw-r--r-- 1 asterisk asterisk 8192 Oct 22 12:26 hardware_detector.db
-rw-r--r-- 1 asterisk asterisk 8192 Feb 23 2012 iptables.db
-rw-r--r-- 1 asterisk asterisk 7168 Oct 11 02:01 menu.db
-rw-r--r-- 1 asterisk asterisk 2048 Feb 23 2012 network.db
-rw-r--r-- 1 asterisk asterisk 6144 Jan 8 20:10 rate.db
-rw-r--r-- 1 asterisk asterisk 6144 Jan 8 20:06 rate-old.db
-rw-r--r-- 1 asterisk asterisk 2048 Feb 23 2012 register.db
-rw-r--r-- 1 asterisk asterisk 261120 Jan 9 17:10 samples.db
-rw-r--r-- 1 root root 0 Feb 23 2012 settings_2012Feb23_164337
-rw-r--r-- 1 asterisk asterisk 2048 Dec 20 11:50 settings.db
-rw-r--r-- 1 asterisk asterisk 9216 Jan 8 18:41 trunk.db
 
Joined
Feb 28, 2008
Messages
5,737
Points
0
Hav you already setup some rates and trunks? If not, you won't have any data on billing report, also just in case, try:
yum update elastix elastix-*
 
Joined
May 16, 2007
Messages
113
Points
0
All trunk for outbound routes are billing capable.

When I import the file master.db from another machine, I have the billing report (for the other machine of course)
I cannot do a yum update because the machine is not directly connected to internet.

Thanks

Brice
 
Joined
May 16, 2007
Messages
113
Points
0
For your information the destination distribution displays correct informations

Brice
 
Joined
May 16, 2007
Messages
113
Points
0
Even after a yum update, problem is the same. master.db is not updated automatically.

Brice
 
Joined
Dec 3, 2007
Messages
8,069
Points
88
Did you check every cdr config files?

I think at cdr_sqlite3_custom.conf and why not some else.
 
Joined
May 16, 2007
Messages
113
Points
0
Problem is solved

Xorcom comment informations in the file cdr_sqlite3_custom.conf then the billing cannot work.
Thanks for all
Brice
 

Members online

No members online now.

Latest posts

Forum statistics

Threads
30,994
Messages
131,110
Members
17,716
Latest member
Orbit114
Top