app_mysql removed in Asterisk 19

[lgaetz]

https://docs.asterisk.org/Development/Asterisk-Module-Deprecations/

Dynroutes currently relies on the asterisk MYSQL diaplan applications for MYSQL lookups, but they were removed in Asterisk 19. FreePBX 17 is not expected to support any asterisk versions under 20.

The Caller ID Lookup module got around this limitation by using an AGI, would could be adapted for dynroutes
https://github.com/FreePBX/cidlookup/blob/release/17.0/agi-bin/cidlookup_mysql.agi

[johnfawcett]

That would work since AGI is already supported. Another possibility is to use ODBC which is also suppported. That would require setting up odbc in asterisk - I'm not sure if there's a module already available for that but if not it could be a good addition to freepbx.

[lgaetz]

FreePBX currently only uses odbc for cdr stuff. I don't recall where in freepbx this is setup, CDR module or perhaps even framework.

vultr*CLI> odbc show all

ODBC DSN Settings
-----------------

  Name:   asteriskcdrdb
  DSN:    MySQL-asteriskcdrdb
    Number of active connections: 2 (out of 5)
    Logging: Disabled

[johnfawcett]

I can see asterisk config file settings for odbc in the cdr module. I cannot see where /etc/odbc.ini gets written, though it contains the asterisk cdr DSN definition, so was not installed by the system install.