[asterisk-bugs] [JIRA] (ASTERISK-25041) Broken column type checking in res_config_mysql addon

[Alexandre Fournier (JIRA)]

Alexandre Fournier created ASTERISK-25041:
---------------------------------------------

             Summary: Broken column type checking in res_config_mysql addon
                 Key: ASTERISK-25041
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-25041
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: Addons/res_config_mysql
    Affects Versions: 13.3.2
            Reporter: Alexandre Fournier
            Severity: Trivial
         Attachments: fix-res_config_mysql-column-type-checking.diff.txt

The improved real-time queue logging, introduced by [~coolmig] in 2010 does not work with a MySQL (or MariaDB) database since column type checking is broken in the _res_config_mysql_ add-on.

Nevertheless, it is still possible to use this feature with _res_config_odbc_  and a MySQL connector or _res_config_pgsql_ as stated in the original patch proposal: [https://issues.asterisk.org/jira/browse/ASTERISK-15863]

This might affect all versions of asterisk since 1.8 to current.

To know if your version of Asterisk is affected by this bug, you'll get this error message in the CLI:

{noformat}
res_config_mysql.c:XXXX require_mysql: Realtime table queue_log at db: Column time cannot be a datetime)
{noformat}

Also, this might be related: [https://issues.asterisk.org/jira/browse/ASTERISK-18252]

Please review the patch in attachment  It fixes MySQL type checking for DATETIME, DATE and FLOAT types in _res_config_mysql_.

-- Waiting for CLA approval.



--
This message was sent by Atlassian JIRA
(v6.2#6252)