SMS Database Location

Hello, I have successfully configured SMS for phone numbers through the UCP and I am able to send/receive messages through it. I saw a reference that the SMS messages are stored in a table called sms_messages, however, I cannot find this.

I am searching for the database to extract the messages for all DIDs. Could anyone direct me to where it would be located on the server?

If you want to access the database from the terminal as the asterisk user, just type fwconsole m

View what tables are in the asterisk database
show tables;

Select all data from sms_messages table
select * from sms_messages;

Good primer for viewing table data out of mysql can be found here:

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.