Re: [asterisk-users] iaxModem pickup problem
On Thu, May 4, 2017 13:19, Telium Technical Support wrote: . . . > 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. > I have added a cron job to make a copy that file every day at midnight with a date timestamp in the file name. I also have daily scheduled backups of the entire FreePBX installation and databases through FreePBX itself but this approach seems a little more convenient. We have had similar incidents in the past which we could never determine the cause of before it was somehow rectified. I infer that on each occasion something we tried simply caused the astdb file to be rebuilt and thereby corrected the issue without us ever being aware that is what happened. -- *** 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. Byrnemailto:byrn...@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
Re: [asterisk-users] iaxModem pickup problem
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:byrn...@harte-lyne.ca] Sent: Thursday, May 4, 2017 12:29 PM To: Telium Technical Support <supp...@telium.ca> Cc: asterisk-users@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=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. Byrnemailto:byrn...@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
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=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. Byrnemailto:byrn...@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
Re: [asterisk-users] iaxModem pickup problem
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=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-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of James B. Byrne Sent: Thursday, May 4, 2017 11:00 AM To: asterisk-users@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. Byrnemailto:byrn...@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 -- _ -- 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
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. Byrnemailto:byrn...@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