No data in the call report

[jrglass]

I installed 1.1 last week and everything seemed to be working until I clicked on reports today. There is no data in the report even though I have made and receive call every day.

Thanks,

Jeff

 

[wardmundy]

Have a look at this thread.

 

[jrglass]

I added this to my modules.conf:

load => cdr_addon_mysql.so

Still no calls

 

[cosmicwombat]

Same here

New 1.1 with FreePBX backup restored.

 

[wardmundy]

Have you changed any passwords?? MySQL passwords, e.g. asteriskuser?

Does your /etc/asterisk/cdr_mysql.conf file look like the following:

 [global] 
 hostname = localhost
 dbname=asteriskcdrdb 
 password = amp109
 user = asteriskuser
 ;port=3306 
 ;sock=/tmp/mysql.sock

If no changes and not working, try changing to... user=root and password=passw0rd (with a zero). Then amportal restart and test.

 

[cosmicwombat]

Thanks Ward, I had changed the passwd and it was carried over during restore.

I just had to change to amp109.

 

[jrglass]

Have you changed any passwords?? MySQL passwords, e.g. asteriskuser?

Does your /etc/asterisk/cdr_mysql.conf file look like the following:

 [global] 
 hostname = localhost
 dbname=asteriskcdrdb 
 password = amp109
 user = asteriskuser
 ;port=3306 
 ;sock=/tmp/mysql.sock

If no changes and not working, try changing to... user=root and password=passw0rd (with a zero). Then amportal restart and test.

Ward,
Mine has a couple of extra lines and all seem to be commented out!

;[global]
;hostname = localhost
;dbname=asteriskcdrdb
;table=cdr
;password = amp109
;user = asteriskuser
;port=3306
;sock=/tmp/mysql.sock
;userfield=1

Thanks,

Jeff

 

[stuck]

Jrglass,
I have the exact same problem as you, after update-source, all the lines are commented out. and the report panel doesn't work. I uncommented out the lines in Ward's post and reloaded. Still doesn't work.
did you ever fix it?
Never Mind... I forgot to uncomment [global]