Adding or editing extensions

Everytime I try to add or edit an extension I get the following in the log-

[2023-03-31 13:41:23] WARNING[20935] db.c: Couldn’t execute statement: attempt to write a readonly database

What database it trying to be written?

Sounds like MySQL may be protecting itself. Check your disk space and for table corruption

Pkeanty of space, and I think the database is sqlite

df -h
Filesystem Size Used Avail Use% Mounted on
/dev/root 29G 2.4G 26G 9% /
devtmpfs 430M 0 430M 0% /dev
tmpfs 462M 0 462M 0% /dev/shm
tmpfs 462M 48M 415M 11% /run
tmpfs 5.0M 4.0K 5.0M 1% /run/lock
tmpfs 462M 0 462M 0% /sys/fs/cgroup
/dev/mmcblk0p1 253M 49M 204M 20% /boot
tmpfs 93M 0 93M 0% /run/user/0

FreePBX data is stored in MySQL, AstDB is sqlite

The warning is logged in /var/log/asterisk/full and when I reported it in the asterisk forum they said to ask here.

That’s because they were adding extension in the FreePBX sense and doing so with the FreePBX GUI. (As far as I know, it is still the case that, for a plain Asterisk .conf addition of an extension or endpoint, no databases will be touched.)

The back history they should have provided is:

1 Like

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.