[asterisk-bugs] [JIRA] (ASTERISK-25798) Agent CLI commands no longer exist on 11.21.2

[Jeff Hoppe (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-25798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=229537#comment-229537 ] 

Jeff Hoppe commented on ASTERISK-25798:
---------------------------------------

I am using Asterisk 11 with MSSQL Server database for static realtime queues and agents.  I had no issues with 11.6, so at some point afterwards a change was made to res/res_config_odbc.c that uses the LENGTH database function.  Since this is not compatible with MSSQL I changed it to LEN and recompiled and now it works.

I modified the query in res/res_config_odbc.c.
Original:  "SELECT MAX(LENGTH(var_val)) FROM %s WHERE filename='%s'"
Modified: "SELECT MAX(LEN(var_val)) FROM %s WHERE filename='%s'"

Agent capabilities were being disabled at start up due to no agent configuration.  Agent configuration was not being loaded due to the above error.

Thanks for your guidance.

> Agent CLI commands no longer exist on 11.21.2
> ---------------------------------------------
>
>                 Key: ASTERISK-25798
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-25798
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>    Affects Versions: 11.22.0
>         Environment: Command Line Interface
>            Reporter: Jeff Hoppe
>            Assignee: Jeff Hoppe
>
> The following CLI commands are no longer available on 11.21.2
> Latest version of Asterisk 11



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