<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal>I’m doing an upgrade from Asterisk 11 to 13. I’m
following the guide at <a
href="https://wiki.asterisk.org/wiki/display/ast/setting+up+PJSIP+REaltime">https://wiki.asterisk.org/wiki/display/ast/setting+up+PJSIP+REaltime</a>
to setup realtime, as I use realtime on Asterisk 11 too.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I’m getting the following error when trying to connect
the peer to the server.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Help? <span style='font-family:Wingdings'>J</span><o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Thanks,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Travis<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>[Jun 15 16:20:03] NOTICE[5116] res_odbc.c: res_odbc:
Connected to laf [laf]<o:p></o:p></p>
<p class=MsoNormal>[Jun 15 16:20:03] DEBUG[5116] res_odbc.c:
odbc_release_obj2(0x7f3f1c4815d8) called (obj->txf = (nil))<o:p></o:p></p>
<p class=MsoNormal>[Jun 15 16:20:03] ERROR[5116] res_pjsip_registrar.c: Unable
to bind contact 'sip:812@10.1.80.112:5062' to AOR '812'<o:p></o:p></p>
<p class=MsoNormal>[Jun 15 16:20:03] DEBUG[5116] res_config_odbc.c: Skip: 0;
SQL: SELECT * FROM ps_contacts WHERE id LIKE ? ORDER BY id<o:p></o:p></p>
<p class=MsoNormal>[Jun 15 16:20:03] DEBUG[5116] res_config_odbc.c: Parameter 1
('id LIKE') = '812;@%'<o:p></o:p></p>
<p class=MsoNormal>[Jun 15 16:20:03] DEBUG[5116] res_odbc.c:
odbc_release_obj2(0x7f3f1c4815d8) called (obj->txf = (nil))<o:p></o:p></p>
<p class=MsoNormal>[Jun 15 16:20:03] DEBUG[5116] res_config_odbc.c: Skip: 0;
SQL: SELECT * FROM ps_contacts WHERE id LIKE ? ORDER BY id<o:p></o:p></p>
<p class=MsoNormal>[Jun 15 16:20:03] DEBUG[5116] res_config_odbc.c: Parameter 1
('id LIKE') = '812;@%'<o:p></o:p></p>
<p class=MsoNormal>[Jun 15 16:20:03] DEBUG[5116] res_odbc.c:
odbc_release_obj2(0x7f3f1c4815d8) called (obj->txf = (nil))<o:p></o:p></p>
<p class=MsoNormal>[Jun 15 16:20:03] DEBUG[5116] res_config_odbc.c: Skip: 0;
SQL: INSERT INTO ps_contacts (id, outbound_proxy, expiration_time, path,
qualify_frequency, user_agent, uri) VALUES (?, ?, ?, ?, ?, ?, ?)<o:p></o:p></p>
<p class=MsoNormal>[Jun 15 16:20:03] DEBUG[5116] res_config_odbc.c: Parameter 1
('id') = '812;@sip:812@10.1.80.112:5062'<o:p></o:p></p>
<p class=MsoNormal>[Jun 15 16:20:03] DEBUG[5116] res_config_odbc.c: Parameter 2
('outbound_proxy') = ''<o:p></o:p></p>
<p class=MsoNormal>[Jun 15 16:20:03] DEBUG[5116] res_config_odbc.c: Parameter 3
('expiration_time') = '1434399723'<o:p></o:p></p>
<p class=MsoNormal>[Jun 15 16:20:03] DEBUG[5116] res_config_odbc.c: Parameter 4
('path') = ''<o:p></o:p></p>
<p class=MsoNormal>[Jun 15 16:20:03] DEBUG[5116] res_config_odbc.c: Parameter 5
('qualify_frequency') = '0'<o:p></o:p></p>
<p class=MsoNormal>[Jun 15 16:20:03] DEBUG[5116] res_config_odbc.c: Parameter 6
('user_agent') = 'Media5-fone/4.1.3.3034 iOS/8.3'<o:p></o:p></p>
<p class=MsoNormal>[Jun 15 16:20:03] DEBUG[5116] res_config_odbc.c: Parameter 7
('uri') = 'sip:812@10.1.80.112:5062'<o:p></o:p></p>
<p class=MsoNormal>[Jun 15 16:20:03] WARNING[5116] res_odbc.c: SQL Execute
returned an error -1: 42S22: [MySQL][ODBC 5.1
Driver][mysqld-5.5.40-0ubuntu0.14.04.1]Unknown column 'outbound_proxy' in
'field list' (103)<o:p></o:p></p>
<p class=MsoNormal>[Jun 15 16:20:03] WARNING[5116] res_odbc.c: SQL Execute
error -1! Verifying connection to laf [laf]...<o:p></o:p></p>
</div>
</body>
</html>