Anyone have luck recreating the astdb.sqlite3 database? I was getting SQL errors so i tried what I found online but FreePBX says the SQL database is gone. This is still in a setup phase so this isn’t live. I’m just trying to avoid re-installing. Even restoring a backup of the database doesn’t help unless i’m missing some steps.
Manually starting Asterisk without FreePBX should recreate the database, so it exists.
So i did that and it recreated it but I still get all these errors when trying to update/install core
In ExceptionConverter.php line 104:
An exception occurred while executing a query: SQLSTATE[HY000]: General err
or: 2006 MySQL server has gone away
In Exception.php line 28:
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
In Statement.php line 121:
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
That’s MySQL, not sqlite3. It sounds like you’ve managed to corrupt the mysql database files, in /var/lib/mysql – Honestly, I’d just reinstall. It’ll be easier.
Ok, thanks. Will do.