FreePBX reporting broken in 0710-beta3?

[Zaerc]

When I go in the web-admin to Advanced > Configuration > Phones setup and click Reports, I get the following error:

Code Select Expand


[nativecode=Access denied for user 'www-data'@'localhost' (using password: NO)] ** mysql://:@localhost/asteriskcdrdb

Couldn't find anything with google about it, so I was wondering does anybody else get that and/or maybe knows how to fix it?

[1audio]

It was working on the 704 version (AMP). The "flash operators panel" doesn't work on the 704 version however.

[bulek]

When I go in the web-admin to Advanced > Configuration > Phones setup and click Reports, I get the following error:

Code Select Expand


[nativecode=Access denied for user 'www-data'@'localhost' (using password: NO)] ** mysql://:@localhost/asteriskcdrdb

Couldn't find anything with google about it, so I was wondering does anybody else get that and/or maybe knows how to fix it?

Hi,

I'm more or less inexperienced mysql guy, but I think that this is an error that needs bug report. Basically it means, that user "www-data" (this is user under which apache is usually running) cannot access Asterisk internal database in sql... Cause my lack of sql knowledge I like to use phpmyadmin. You can try to fix it with adding new user "www-data" that has access to that database. But anyway if someone else also confirms this, then it should be reported as a bug...

I'll try mine tomorrow and see if I'll get same error.

HTH,

regards,

Bulek.

[Zaerc]

After some more digging, I tried setting the username/password as described here, but that didn't help so I fixed the other end.  As root do on the core:

Code Select Expand

mysql -e "GRANT ALL PRIVILEGES ON asteriskcdrdb.* TO 'www-data'@'localhost'"

I notice bulek just posted the same suggestion while writing this, thanks.  Seems like the php page is unable to get the credentials from the config file properly.  And If some people could confirm that this is not just my setup then it can be reported to mantis.

[bulek]

After some more digging, I tried setting the username/password as described here, but that didn't help so I fixed the other end.  As root do on the core:

Code Select Expand

mysql -e "GRANT ALL PRIVILEGES ON asteriskcdrdb.* TO 'www-data'@'localhost'"

I notice bulek just posted the same suggestion while writing this, thanks.  Seems like the php page is unable to get the credentials from the config file properly.  And If some people could confirm that this is not just my setup then it can be reported to mantis.

I can confirm this also on 701 B3 virgin setup... It shows when I enter Reports section. I also vote for mantis report.

I also spot that flash panel is not working (but it would be really useful, to be able to control Asterisk from nice flash web GUI . check http://www.asternic.org/demo.php )

I also cannot login into voicemail. it says in installation process that pin is also used for voicemail retrieve... But if you check /etc/voicemail.conf, there is no password for user....

I've posted  mantis thread : http://mantis.linuxmce.org/view.php?id=3883

Regards,

Bulek.

[Zaerc]

Thanks, I've added some comments there as well.