Fetch data from Astdb

Hi,

I am using asterisk 1.8 and store short code data on astdb and want to fetch data from astdb.

Please suggest best way to fetch data from astdb.

One more thing its possible to upload data in astdb from .xls or .csv

Thanks
Rajeev

Asterisk 1.8 hasn’t been supported for over 6 years!

I believe astdb in that version uses Berkley hashed files. https://en.wikipedia.org/wiki/DBM_(computing) may help you fijnd tools to manipulate it.

-pbx10::sedwards:~$ file /var/lib/asterisk/astdb.sqlite3 /var/lib/asterisk/sqlite.db 
/var/lib/asterisk/astdb.sqlite3: SQLite 3.x database, last written using SQLite version 3016002
/var/lib/asterisk/sqlite.db:     SQLite 2.x database

Asterisk uses SQLite, so you can use the SQLite shell (sqlite or sqlite3) or whatever libraries are available for whatever language you want to use.

The OP is using an obsolete version of Asterisk. Asterisk 1.6 definitely didn’t use SQLite, and I’m not convinced that the switch happened in 1.8.

Ha, my bad. I don’t have any systems that old to check :slight_smile: