app_mysql removed in Asterisk 19

FreePBX-ContributedModules / dynroute

GNU General Public License v3.0

1 stars 3 forks source link

app_mysql removed in Asterisk 19 #5

Open lgaetz opened 2 months ago

lgaetz commented 2 months ago

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 commented 2 months ago

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 commented 2 months ago

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 commented 2 months ago

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.