[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=230975#comment-230975 ] 

HZMI8gkCvPpom0tM edited comment on ASTERISK-26106 at 6/10/16 6:49 AM:
----------------------------------------------------------------------

it is different because of different reasons. 
Old issue i fixed already in my fork because nobody wanted to do it here. 
It is possible that new issue also nobody want to fix. So i placed description how to fix for people who want to fork and continue to use oracle with asterisk. Because current Asterisk without special patches not usable with oracle at all. But you can connect this issue of course. In this case provided  solution will be little bit not full .


was (Author: y2fbo4ievym5ve9u):
it is different because of different reasons. 
Old issue i fixed already in my fork because nobody wanted to do it here. 
It is possible that new issue also nobody want to fix. So i placed description how to fix for people who want to fork and continue to use oracle with asterisk. Because current Asterisk without special patches not usable with oracle at all. 

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