The following seems to work well to clear the Asterisk database:
service asterisk stop
sqlite3 /mnt/kd/astdb.sqlite3 'delete from astdb;'
service asterisk start
Easy to clear out the cdr database the same way (not sure if you need to stop
Asterisk though)
sqlite3 /mnt/kd/cdr-sqlite3/cdr-odbc.sql
Thanks Lonnie. Simple!
Add 'service asterisk stop' to any restore or factory reset script and all is
resolved after a reboot.
Regards
Michael Knill
On 5/7/18, 9:24 am, "Lonnie Abelbeck" wrote:
> On Jul 4, 2018, at 5:23 PM, Michael Knill
wrote:
>
> Does anyone know if there
> On Jul 4, 2018, at 5:23 PM, Michael Knill
> wrote:
>
> Does anyone know if there is an issue with writing or deleting entries
> directly in the astdb.sqlite3 database rather than via Asterisk?
> It would only be used for backup/restore/factory reset purposes.
I would not do that if Asteris
I’ve done it and it didn’t seem to hurt though I’d never do it in production.
I’m not sure how much data is cached by asterisk so I end up always handling
the DB through AMI Christopher
On Wednesday, July 4, 2018, 6:23:56 PM EDT, Michael Knill
wrote:
Does anyone know if there is an
Does anyone know if there is an issue with writing or deleting entries directly
in the astdb.sqlite3 database rather than via Asterisk?
It would only be used for backup/restore/factory reset purposes.
Regards
Michael Knill
--
