[b]NOTE : The responses to this post may bring you help that is normally NOT a freepbx issue. If you have any questions about them, I would suggest you NOT do like I (unknowingly) did and look for help on this site, but more on an asterisk help forum. Also, the final cause may make you realize that sometimes a problem that SEEMS to originate from a wrong config can be caused by a VERY MUCH DEEPER cause.
First of all, I’d like to take the time to thank all of you guys. I haven’t posted a problem yet before today, and that’s due to the fact that very often other people have had the same problems, and that I could fix them without posting.
Now for this one… I found “part” of the fix on http://www.freepbx.org/forum/freepbx/users/i-cant-get-reports-to-work but my problem goes further than up to where this thread goes.
I use freepbx 220.127.116.11 on asterisk 1.4.24.
My cdr’s record in a csv in /var/log/asterisk/cdr-csv but don’t show up in the “reports” tab nor do they record in the mysql database. The databse name is correct, but I noticed that instead of being in the /var/lib/mysql/asterisk folder, it’s in /var/lib/mysql/asteriskcdrdb. Does that matter? The field headers are there but there is no other data.
-1- I installed the “asterisk-addons-1.4.2”. Is that right or should I install the or the 1.4.9 since I’m on the 1.4.24?
-2- When I uploaded it through the module admin, it gave me an incorrect filename format error, so I started by renaming it asteriskaddons-1.4.2, but i gave me an invalid path error. Then I uploaded it through my webmin file manager, unzipped it in /var/www/html/admin/modules/asterisk-addons-1.4.2 and followed the instructions from http://www.voip-info.org/wiki/view/Asterisk+cdr+mysql saying to “make clean”, “make” (which gave a “[config.status] error 1”), and “make install” which gave me 3 errors :
- /usr/bin/install: cannot stat ‘app_addon_sql_mysql.so’ : No such file or directory
- /usr/bin/install: cannot stat ‘app_saycountpl.so’ : No such file or directory
- /usr/bin/install: cannot stat ‘res_config_mysql.so’ : No such file or directory
I did a lookup for those files and didn’t find them anywhere.
Then I thought to myself that there could be a permission issue, so I checked the permission of the folder (including files and folders) and switched them from root user and group to asterisk and to 775.
- Anything I missed?
- Need more infos I didn’t think of putting here?
- I suppose there’s a missing module I need to install to get those missing sql files. What is it and where do I get it please?
Thanks in advance for your help,
P.S. : I hope I’m in the right place to post this :-S