It depends a bit on your version of FreePBX, but here's a link to show you
how:
http://telium.ca/pages/forums/viewtopic.php?f=7&t=19
Hopefully option 1 works for you (quick and easy). If not, you'll have to
try option 2. Ignore option 3 since that's only for users of High
Availability for Asterisk (HAAst).
(I assume that if you had a full backup you would have already tried to
restore it)
-Raj-
-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of James B. Byrne
Sent: Thursday, May 4, 2017 11:00 AM
To: asterisk-users at lists.digium.com
Subject: Re: [asterisk-users] iaxModem pickup problem
On Thu, May 4, 2017 10:22, James B. Byrne wrote:
I am advised that it may be possible thast the astdb.sqlite3 database may be
corrupted. Are there procedures to rebuild or repair this?
Where are they documented? If not then how does one repair such?
--
*** e-Mail is NOT a SECURE channel ***
Do NOT transmit sensitive data via e-Mail Do NOT open attachments
nor follow links sent by e-Mail
James B. Byrne mailto:ByrneJB at Harte-Lyne.ca
Harte & Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
Check out the new Asterisk community forum at:
https://community.asterisk.org/
New to Asterisk? Start here:
https://wiki.asterisk.org/wiki/display/AST/Getting+Started
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
On Thu, May 4, 2017 11:38, Telium Technical Support wrote:> It depends a bit on your version of FreePBX, but here's a link to show > you how: > > http://telium.ca/pages/forums/viewtopic.php?f=7&t=19 > > Hopefully option 1 works for you (quick and easy). If not, you'll > have to try option 2. Ignore option 3 since that's only for users > of High Availability for Asterisk (HAAst). > > (I assume that if you had a full backup you would have already tried > to restore it) >No, I did not try to restore from backups; and yes I have daily backups to recover from if that is necessary. However, I have since corrected the damaged rows in astdb.sqlite and the fax service is now working again. If someone could explain what likely happens to damage astdb.sqlite when the system is suddenly powered off I would appreciate it. -- *** e-Mail is NOT a SECURE channel *** Do NOT transmit sensitive data via e-Mail Do NOT open attachments nor follow links sent by e-Mail James B. Byrne mailto:ByrneJB at Harte-Lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3
The file astdb.sqlite is a SQLite 3 file (all tables and indices rolled into
one file). While Asterisk is running the astdb file is always open for r/w.
FreePBX regularly updates rows ("keys") in this database, so writes
are
often in progress.
In the event of a power failure the file will not be properly closed, or
worse be left in an invalid state. Once Asterisk starts it is may refuse to
read some astdb rows, or potentially the whole file.
Asterisk natively does not need the astdb file but FreePBX makes extensive
use of it. In particular, FreePBX dialplans check device/user information
in the astdb for call handling. So a missing/corrupt user/device will cause
the dialplan to fail. (That's why I suggested to you watch the dialplan
from the Asterisk CLI when a fax comes in).
This design (FreePBX) makes Asterisk much more fragile than it has to be.
It's a good idea to keep a backup astdb on the PBX in case of corruption.
-----Original Message-----
From: James B. Byrne [mailto:byrnejb at harte-lyne.ca]
Sent: Thursday, May 4, 2017 12:29 PM
To: Telium Technical Support <support at telium.ca>
Cc: asterisk-users at lists.digium.com
Subject: RE: [asterisk-users] iaxModem pickup problem
On Thu, May 4, 2017 11:38, Telium Technical Support
wrote:> It depends a bit on your version of FreePBX, but here's a link to show
> you how:
>
> http://telium.ca/pages/forums/viewtopic.php?f=7&t=19
>
> Hopefully option 1 works for you (quick and easy). If not, you'll
> have to try option 2. Ignore option 3 since that's only for users of
> High Availability for Asterisk (HAAst).
>
> (I assume that if you had a full backup you would have already tried
> to restore it)
>
No, I did not try to restore from backups; and yes I have daily backups to
recover from if that is necessary. However, I have since corrected the
damaged rows in astdb.sqlite and the fax service is now working again.
If someone could explain what likely happens to damage astdb.sqlite when the
system is suddenly powered off I would appreciate it.
--
*** e-Mail is NOT a SECURE channel ***
Do NOT transmit sensitive data via e-Mail Do NOT open attachments
nor follow links sent by e-Mail
James B. Byrne mailto:ByrneJB at Harte-Lyne.ca
Harte & Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3