[asterisk-bugs] [JIRA] (ASTERISK-26106) PJSIP driver completely broken with oracle using ODBC

[HZMI8gkCvPpom0tM (JIRA)]

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

HZMI8gkCvPpom0tM commented on ASTERISK-26106:
---------------------------------------------

Little bit different 
It is happening because of hardcoded defined variable UUID_FIELD in res_sorcery_realtime.c. 
It defined in lower case as "id". But oracle always return data with high case columns names.
I not commit patch because of strange policy of asterisk team. 
If somebody have same issue you can easyly fix it in  res_sorcery_realtime.c

if (!strcasecmp(field->name, UUID_FIELD)) {
instead of 
if (!strcmp(field->name, UUID_FIELD)) {

> PJSIP driver completely broken with oracle using ODBC 
> ------------------------------------------------------
>
>                 Key: ASTERISK-26106
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-26106
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: pjproject/pjsip, Resources/res_config_odbc
>    Affects Versions: 13.9.1
>         Environment: any with configured ORACLE ODBC driver
>            Reporter: HZMI8gkCvPpom0tM
>            Assignee: HZMI8gkCvPpom0tM
>            Severity: Critical
>
> Asterisk not see anything in any pjsip tables because of mistakes in interpretation of results in asterisk core. 
> example 
> tmpl*CLI> pjsip show aors
> No objects found.
> tmpl*CLI> 
> but if to use console odbc isql command data exist
> SELECT * FROM PS_AORS WHERE id LIKE '%' ORDER BY id 
> +-----------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------+---------------------------------------------------------------------------------+-----------------------------------------+-----------------------------------------+----------------+-----------------------------------------+---------------------+-----------------------------------------+-----------------------------------------+-------------+-----------------------------------------+-----------------------------------------+
> | ID                                      | CONTACT                                                                                                                                                                                                                                                        | DEFAULT_EXPIRATION                      | MAILBOXES                                                                       | MAX_CONTACTS                            | MINIMUM_EXPIRATION                      | REMOVE_EXISTING| QUALIFY_FREQUENCY                       | AUTHENTICATE_QUALIFY| MAXIMUM_EXPIRATION                      | OUTBOUND_PROXY                          | SUPPORT_PATH| QUALIFY_TIMEOUT                         | VOICEMAIL_EXTENSION                     |
> +-----------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------+---------------------------------------------------------------------------------+-----------------------------------------+-----------------------------------------+----------------+-----------------------------------------+---------------------+-----------------------------------------+-----------------------------------------+-------------+-----------------------------------------+-----------------------------------------+
> | 101                                     |                                                                                                                                                                                                                                                                |                                         |                                                                                 | 1                                       |                                         |                |                                         |                     |                                         |                                         |             |                                         |                                         |
> | 102                                     |                                                                                                                                                                                                                                                                |                                         |                                                                                 | 1                                       |                                         |                |                                         |                     |                                         |                                         |             |                                         |                                         |
> +-----------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------+---------------------------------------------------------------------------------+-----------------------------------------+-----------------------------------------+----------------+-----------------------------------------+---------------------+-----------------------------------------+-----------------------------------------+-------------+-----------------------------------------+-----------------------------------------+
> SQLRowCount returns -1
> 2 rows fetched



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