FOP2 installation on not bundled versions of Asterisk
First of all here's my environment:
- My server runs a fresh installation of Debian 12 with Apache + MariaDB + PHP
- Asterisk 18 is compiled from source (not .deb version)
- I'm not using a bundled Asterisk solution like FreePBX or other.
I'm trying to install FOP2 v2.31.36 using the one liner script found in the documentation. No visible error during the process...
Then I created the fop2 database & user and updated config.php with database informations.
The switchboard login page doesn't work: it's stuck at "One moment please - Connecting to server, attempt number 1"
I don't see any errors in logs.
I can sucessfully connect to the admin page but after logging in, the dashboard is stuck with refreshing icons
In Apache2 error log, I can see that it fails opening a database that doesn't exists because I don't use Asterisk realtime:
Uncaught mysqli_sql_exception: SELECT command denied to user '
fop2'@'localhost' for table 'asterisk'.'sippeers' in /var/www/fop2/admin/dblib.php:103
Any ideas on what's going on and how to fix this?