asterisk users - Sep 2015 - problems with PJSIP install on UBUNTU 14.04

Ok, I reinstalled pkg-config from apt-get and now I think it?s all good.
Man, PJSIP has been a chore to get working right on this server and on the
last. Though the last server wasn?t near the issue this was. Lol

I think what happened was that after initial trouble, I ran the ?install
prereq? or something like that and it must have did it?s own install of
pjsip that sent me down a duplicate path, etc.

Thanks Josh and all!

On 9/24/15, 2:10 PM, "asterisk-users-bounces at lists.digium.com on behalf
of
Joshua Colp" <asterisk-users-bounces at lists.digium.com on behalf of
jcolp at digium.com> wrote:
>Ryan, Travis wrote:
>>>
>> I think i?m down to the right set of pj and only have one of the files
>>for
>> pkg-config but now asterisk doesn?t see that it?s installed. Also
>>ldconfig
>> is showing right info.
>> 
>> 
>
>What does pkg-config --libs libpjproject show now? That is what Asterisk
>uses.
>
>-- 
>Joshua Colp
>Digium, Inc. | Senior Software Developer
>445 Jan Davis Drive NW - Huntsville, AL 35806 - US
>Check us out at: www.digium.com & www.asterisk.org
>
>-- 
>_____________________________________________________________________
>-- Bandwidth and Colocation Provided by http://www.api-digital.com --
>New to Asterisk? Join us for a live introductory webinar every Thurs:
>               http://www.asterisk.org/hello
>
>asterisk-users mailing list
>To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users

Did something change DB-wise with PJSIP and realtime between 13.3.2 and 13.5.0?
I'm getting an unknown column error and unsure where I need that column and
the type it needs to be.

Thanks!

[Sep 24 15:32:41]     -- Attempted to remove non-existent contact 'sip:312
at 10.1.1.201:5060' from AOR '312' by request
[Sep 24 15:33:53] WARNING[27948]: res_odbc.c:649 ast_odbc_prepare_and_execute:
SQL Execute returned an error -1: 42S22: [MySQL][ODBC 5.1
Driver][mysqld-5.5.44-0ubuntu0.14.04.1]Unknown column 'qualify_timeout'
in 'field list' (104)
[Sep 24 15:33:53] WARNING[27948]: res_odbc.c:661 ast_odbc_prepare_and_execute:
SQL Execute error -1! Verifying connection to pcim [pcim]...
[Sep 24 15:33:53] WARNING[27948]: res_odbc.c:765 ast_odbc_sanity_check:
Connection is down attempting to reconnect...
[Sep 24 15:33:58] NOTICE[27948]: res_odbc.c:1528 odbc_obj_connect: Connecting
pcim
[Sep 24 15:33:58] NOTICE[27948]: res_odbc.c:1567 odbc_obj_connect: res_odbc:
Connected to pcim [pcim]
[Sep 24 15:33:58] WARNING[27948]: res_odbc.c:649 ast_odbc_prepare_and_execute:
SQL Execute returned an error -1: 42S22: [MySQL][ODBC 5.1
Driver][mysqld-5.5.44-0ubuntu0.14.04.1]Unknown column 'qualify_timeout'
in 'field list' (104)
[Sep 24 15:33:58] WARNING[27948]: res_odbc.c:661 ast_odbc_prepare_and_execute:
SQL Execute error -1! Verifying connection to pcim [pcim]...
[Sep 24 15:33:58] WARNING[27948]: res_odbc.c:765 ast_odbc_sanity_check:
Connection is down attempting to reconnect...
[Sep 24 15:34:03] NOTICE[27948]: res_odbc.c:1528 odbc_obj_connect: Connecting
pcim
[Sep 24 15:34:03] NOTICE[27948]: res_odbc.c:1567 odbc_obj_connect: res_odbc:
Connected to pcim [pcim]
[Sep 24 15:34:03] ERROR[27948]: res_pjsip_registrar.c:504 rx_task: Unable to
bind contact 'sip:312 at 10.1.1.201:5060' to AOR '312'

On 15-09-24 04:42 PM, Ryan, Travis wrote:
> Did something change DB-wise with PJSIP and realtime between 13.3.2
> and 13.5.0? I'm getting an unknown column error and unsure where I
> need that column and the type it needs to be.
Yes, the schema can change between versions. Following the instructions 
on 
https://wiki.asterisk.org/wiki/display/AST/Setting+up+PJSIP+Realtime#SettingupPJSIPRealtime-InstallingandUsingAlembic
will cause alembic to upgrade the tables.

-- 
Joshua Colp
Digium, Inc. | Senior Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - US
Check us out at: www.digium.com & www.asterisk.org