[asterisk-bugs] [JIRA] (ASTERISK-27357) PJSip endpoints lose AoRs when enabling ODBC

[Guilherme Bizzani (JIRA)]

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

Guilherme Bizzani commented on ASTERISK-27357:
----------------------------------------------

I forgot to include the inserts I used in the example, here they are: 

insert into ps_aors (id, max_contacts) values (101, 1);
insert into ps_aors (id, max_contacts) values (102, 1);

insert into ps_auths (id, auth_type, password, username) values (101, 'userpass', 101, 101);
insert into ps_auths (id, auth_type, password, username) values (102, 'userpass', 102, 102);

insert into ps_endpoints (id, transport, aors, auth, context, disallow, allow, direct_media) values (101, 'transport-udp', '101', '101', 'testing', 'all', 'g722', 'no');
insert into ps_endpoints (id, transport, aors, auth, context, disallow, allow, direct_media) values (102, 'transport-udp', '102', '102', 'testing', 'all', 'g722', 'no');

> PJSip endpoints lose AoRs when enabling ODBC
> --------------------------------------------
>
>                 Key: ASTERISK-27357
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-27357
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: pjproject/pjsip, Resources/res_odbc
>    Affects Versions: 15.0.0
>         Environment: Debian GNU/Linux 8.9 (jessie). Firstly got the error on a Asterisk version 13.11.2.
>            Reporter: Guilherme Bizzani
>            Assignee: Unassigned
>         Attachments: info.txt
>
>
> This issue was basically found by following the tutorial on https://wiki.asterisk.org/wiki/display/AST/Setting+up+PJSIP+Realtime using PostgreSQL for the database. My first approach to the error was on version 13.11.2 of Asterisk, then I tried with version 15 and get the same error.
> After all the installation, configuration and population, when starting asterisk the "pjsip show endpoints" objects don't contain AoR, and "pjsip show aors" return "No objects found."
> The only error i'm receiving back after these two commands is:
> ERROR 3875: config_options.c:883 aco_set_defaults: Unable to set default for 101, qualify_timeout=3.0
> Note: When I disable "res_odbc.conf" and configure any endpoint statically on "pjsip.conf" it does get the informations, register and make calls.
> More info and config files used can be seen in my thread on Asterisk's forum: https://community.asterisk.org/t/possible-incompatibility-between-odbc-and-pjsip/72340



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