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

[HZMI8gkCvPpom0tM (JIRA)]

HZMI8gkCvPpom0tM created ASTERISK-26106:
-------------------------------------------

             Summary: 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
            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)