Database Schema's for Asterisk 16

Asterisk Asterisk Support
1

** MOD’s please move this if there is a more appropriate category for it. **

I’m getting my feet wet with Asterisk 16, installed from source on Ubuntu 18.04.

I’ve gone through numerous posts and tutorials on Realtime functionality, and have setup the ODBC connector.
I have SIP Peers, Voicemail and CDR working, but can’t find up-to-date MySQL schema’s for Queue Logging.

I’ve been trying to figure it out from this page (https://www.voip-info.org/asterisk-queuelog-on-mysql) but I’m having a hard time guessing at which SQL statements (or combination of) is correct.

Can anyone share what they have working, or point me in the right direction.

Cheers!

2

Howdy,

See - https://wiki.asterisk.org/wiki/display/AST/Managing+Realtime+Databases+with+Alembic

1 Like
3

I think I stumbled across that at some point but didn’t know what I was looking at.

Thank you Malcom :slight_smile:

1 Like