FreeSWITCH 1.11.1 Post-Upgrade SQLite RAM Storage Fix

[pbxgeek]

Please update to the latest commit as of today and run the command below to move SQLite back to RAM storage.

Disclaimer: If you have customized your setup to use PostgreSQL instead of SQLite, you can disregard this notice.

After the upgrade, SQLite was moved to file storage, which is not ideal for performance. Certain features, such as call pickup, may also not work properly when SQLite is stored on disk.

During the FS PBX installation, SQLite is configured to use RAM storage by default. Running the command below will restore the correct configuration.

php artisan fs:migrate-sqlite-to-ram

After running the command, please flush the cache first, then restart FreeSWITCH for the change to take effect.

To verify that FreeSWITCH uses the correct path for database storage, you can run this command:

 sudo lsof -nP -p "$(pidof freeswitch)" \
  | grep -E '/dev/shm/.*\.db|/var/lib/freeswitch/db/.*\.db'

The output should look like this

freeswitc 668409 www-data    6u      REG               0,24   385024     138290 /dev/shm/core.db
freeswitc 668409 www-data   11u      REG               0,24   339968          4 /dev/shm/sofia_reg_external.db
freeswitc 668409 www-data   22u      REG               0,24   352256         84 /dev/shm/sofia_reg_internal.db
freeswitc 668409 www-data   31u      REG               0,24   339968          4 /dev/shm/sofia_reg_external.db
freeswitc 668409 www-data   32u      REG               0,24   352256         84 /dev/shm/sofia_reg_internal.db
freeswitc 668409 www-data   34u      REG               0,24    16384        164 /dev/shm/callcenter.db
freeswitc 668409 www-data   36u      REG               0,24    16384     138295 /dev/shm/fifo.db

All directories should point at /dev/shm