FreePBX | Register | Issues | Wiki | Portal | Support

Corrupted ASTDB - how to rebuild?


#1

I have a corrupted ASTDB on a Trixbox 2.4 system. A “database show” ends after about five entries. The last entry is:
/BLKVM/210/SIP/208-b7db11b0 : TRUE

None of the CALLTRACE, CW, or DEVICE entries are visible.

The disk was full recently, so this may have caused the problem.

How can I rebuild the ASTDB?

Peter


SQL logic error
#2

Go to Extensions, select each extension that you have, click Submit on each.
When done, click on Apply Configuration Changes
This will re-create the settings for AMPUSER and DEVICE so that your system will be up and running.


#3

Micke

I did as you suggested, but “database show” still ends at the same place - no DEVICE entries.

I even found the dumpastdb.php script and ran that, but it gives me the same subset of data. I suspect maybe something corrupt inside the astdb file.

Peter


SQL logic error or missing database
#4

Do an amportal stop to shutdown asterisk. Rename the file /var/lib/asterisk/astdb to, for example, astdbold. Start asterisk again with amportal start and go through the extension submitting each entry.


#5

Micke

That did the trick - thanks a lot.

We also had to go through the FollowMe entries and resubmit them too.

Thanks

Peter


#6

Thank you for the feedback, I am glad that you got your system back on track.
Mikael Carlsson


#7

Hi there,

I have a server with thousand of users and I need a script to rebuild the whole ASTDB after a MySQL DB migration. Do you know which FreePBX function I should call?

Thanks.


(Corrado Mella) #8

[strong]DO NOT[/strong] hijack or resurrect 6 year old posts, start a new one if you want to be considered.


(system) closed #9