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

[Kevin Harwell (JIRA)]

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

Kevin Harwell commented on ASTERISK-27357:
------------------------------------------

Please attach all relevant configuration files (with .txt extension please) to the issue (I realize a lot of that information is contained in the provided link, but if for some reason that link is unreachable that data is lost).

What version of the database are you using? Also what are the exact sql statements you used to insert data into the database?

What's the table definition look like within your database? For instance here is mine:
{noformat}
asterisk=> \dS ps_aors;
                  Table "public.ps_aors"
        Column        |          Type          | Modifiers 
----------------------+------------------------+-----------
 id                   | character varying(40)  | not null
 contact              | character varying(255) | 
 default_expiration   | integer                | 
 mailboxes            | character varying(80)  | 
 max_contacts         | integer                | 
 minimum_expiration   | integer                | 
 remove_existing      | yesno_values           | 
 qualify_frequency    | integer                | 
 authenticate_qualify | yesno_values           | 
 maximum_expiration   | integer                | 
 outbound_proxy       | character varying(40)  | 
 support_path         | yesno_values           | 
 qualify_timeout      | double precision       | 
 voicemail_extension  | character varying(40)  | 
Indexes:
    "ps_aors_id_key" UNIQUE CONSTRAINT, btree (id)
    "ps_aors_id" btree (id)
    "ps_aors_qualifyfreq_contact" btree (qualify_frequency, contact)
{noformat}

I have used what I believe is setup similar to yours, but am unable to duplicate. I'm testing on Ubuntu 16.04 with postgresql server 9.5. My odbc libraries though are slightly newer than yours:
{noformat}
dpkg -l | grep odbc
ii  libodbc1:amd64                       2.3.1-4.1                                  amd64        ODBC library for Unix
ii  odbc-postgresql:amd64                1:09.03.0300-1                             amd64        ODBC driver for PostgreSQL
ii  odbcinst                             2.3.1-4.1                                  amd64        Helper program for accessing odbc ini files
ii  odbcinst1debian2:amd64               2.3.1-4.1                                  amd64        Support library for accessing odbc ini files
ii  unixodbc                             2.3.1-4.1                                  amd64        Basic ODBC tools
ii  unixodbc-dev                         2.3.1-4.1                                  amd64        ODBC libraries for UNIX (development files)
{noformat}
If it's possible you might try upgrading the relevant libraries to see if that helps?

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