[asterisk-bugs] [JIRA] (ASTERISK-25281) PJSIP realtime over ODBC broken

[HZMI8gkCvPpom0tM (JIRA)]

HZMI8gkCvPpom0tM created ASTERISK-25281:
-------------------------------------------

             Summary: PJSIP realtime over ODBC broken
                 Key: ASTERISK-25281
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-25281
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: Channels/chan_pjsip
    Affects Versions: 13.4.0
         Environment: any debian x64 with odbc configured. 
all configrations was done in accordance with document 
https://wiki.asterisk.org/wiki/display/AST/Setting+up+PJSIP+Realtime
            Reporter: HZMI8gkCvPpom0tM


Look like that pjsip funtionality completely broken in case of obdc driver used. 
but after loading asterisk 

*vpbxdev*CLI> pjsip show endpoints 
No objects found.*

[2015-07-28 10:52:51.740] DEBUG[11310]: res_config_odbc.c:113 custom_prepare: Skip: 0; SQL: SELECT * FROM ps_endpoints WHERE id LIKE ? ORDER BY id
[2015-07-28 10:52:51.740] DEBUG[11310]: res_config_odbc.c:129 custom_prepare: Parameter 1 ('id LIKE') = '%'
[2015-07-28 10:52:51.754] DEBUG[11310]: res_odbc.c:1057 odbc_release_obj2: odbc_release_obj2(0x1cda0c8) called (obj->txf = (nil))
[2015-07-28 10:52:51.755] DEBUG[11310]: res_sorcery_realtime.c:119 sorcery_realtime_filter_objectset: Filtering out realtime field 'ID' from retrieval
[2015-07-28 10:52:51.755] DEBUG[11310]: res_sorcery_realtime.c:119 sorcery_realtime_filter_objectset: Filtering out realtime field 'TRANSPORT' from retrieval
[2015-07-28 10:52:51.755] DEBUG[11310]: res_sorcery_realtime.c:119 sorcery_realtime_filter_objectset: Filtering out realtime field 'AORS' from retrieval
[2015-07-28 10:52:51.755] DEBUG[11310]: res_sorcery_realtime.c:119 sorcery_realtime_filter_objectset: Filtering out realtime field 'AUTH' from retrieval
[2015-07-28 10:52:51.755] DEBUG[11310]: res_sorcery_realtime.c:119 sorcery_realtime_filter_objectset: Filtering out realtime field 'CONTEXT' from retrieval
[2015-07-28 10:52:51.755] DEBUG[11310]: res_sorcery_realtime.c:119 sorcery_realtime_filter_objectset: Filtering out realtime field 'DISALLOW' from retrieval
[2015-07-28 10:52:51.755] DEBUG[11310]: res_sorcery_realtime.c:119 sorcery_realtime_filter_objectset: Filtering out realtime field 'ALLOW' from retrieval
[2015-07-28 10:52:51.755] DEBUG[11310]: res_sorcery_realtime.c:119 sorcery_realtime_filter_objectset: Filtering out realtime field 'DIRECT_MEDIA' from retrieval

If i do manually same query using isql (odbc) i get data. 



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