How to move Sonata Stats to a remote server? 

If you’d like to move Sonata Stats to another server, to reduce the load on the main VitalPBX server. 

1. Install the Sonata Stats on your new server. 

2. Then, you will need to edit this file /usr/share/sonata/queues-stats/backend/.env 

DB_ASTERISK_HOST=VITALPBX_IP_SERVER 

DB_ASTERISK_PORT=3306 

DB_ASTERISK_USERNAME=REMOTE_MYSQL_USER 

DB_ASTERISK_PASSWORD=REMOTE_MYSQL_SECURE_PWD 

On this configuration, you will need to enter the IP address of the asterisk, server port, and credentials. 

3. In the Linux CLI, execute the command below. 

mysql -uroot -e"create database sonata_stats" 

4. Create a user with all permissions for the sonata_stats database. 

mysql -uroot 

grant all privileges on sonata_stats.*  to “stats”@”localhost” identified by “SECURE_PWD” 

5. On the .env file edit these configurations and enter the credentials created in the previous step. 

DB_USERNAME=stats 

DB_PASSWORD=SECURE_PWD 

6. From this location /usr/share/sonata/queues-stats/backend execute these commands 

php artisan config:cache 

php artisan migrate 

7. To create our admin user, we have to execute the command below. 

php artisan tinker 

8. Then, we have to paste the following code. 

use App\Role; 

use App\User; 

$user = User::updateOrCreate( 

  ['name' => 'admin'], 

  ['password' => 'enter your password here', 

  'full_name' => 'admin', 

  'tenant_id' => 1, 

  'tenant' => 'vitalpbx'] 

); 

$user->roles()->sync(Role::where('name', 'admin')->first()); 

9. Finally, edit the file /var/lib/sonata/stats/wizard.conf and configure the flag below. 

installed=yes 

Now, you should be able to access sonata stats from your new server.