<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Sep 12, 2016 at 3:01 PM, Carlos Chavez <span dir="ltr"><<a href="mailto:cursor@telecomabmex.com" target="_blank">cursor@telecomabmex.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF"><span class="gmail-">
<p>On 9/12/16 3:39 PM, George Joseph wrote:<br>
</p>
<blockquote type="cite">
<div dir="ltr"><br>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Mon, Sep 12, 2016 at 2:31 PM,
George Joseph <span dir="ltr"><<a href="mailto:gjoseph@digium.com" target="_blank">gjoseph@digium.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr"><br>
<div class="gmail_extra"><br>
<div class="gmail_quote"><span>On Mon, Sep
12, 2016 at 2:14 PM, Carlos Chavez <span dir="ltr"><<a href="mailto:cursor@telecomabmex.com" target="_blank">cursor@telecomabmex.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"> Has anyone
successfully used Mysql realtime PJSIP with
Asterisk 13.11? I have tried 13.11, 13.11.1 and
13.11.2 but I always get the following error
now:<br>
<br>
Sep 12 14:42:35] WARNING[24498]:
res_config_mysql.c:1162 require_mysql: Realtime
table general@ps_contacts: column
'qualify_timeout' cannot be type 'int(10)' (need
char)<br>
[Sep 12 14:42:35] WARNING[24498]:
res_config_mysql.c:1162 require_mysql: Realtime
table general@ps_contacts: column
'expiration_time' cannot be type 'bigint(20)'
(need char)<br>
[Sep 12 14:42:35] WARNING[24498]:
res_config_mysql.c:1246 require_mysql: Possibly
unsupported column type 'enum('yes','no')' on
column 'authenticate_qualify'<br>
[Sep 12 14:42:35] WARNING[24498]:
res_config_mysql.c:1162 require_mysql: Realtime
table general@ps_contacts: column 'via_port'
cannot be type 'int(11)' (need char)<br>
[Sep 12 14:42:35] ERROR[24498]:
res_pjsip_registrar.c:411 register_aor_core:
Unable to bind contact '<a href="http://sip:2001@192.168.2.165:5060" target="_blank">sip:2001@192.168.2.165:5060</a>;t<wbr>ransport=udp'
to AOR '2001'<br>
== Contact 2001/<a href="mailto:sip%3A2001@192.168.2.165" target="_blank">sip:2001@192.168.2.165</a>:50<wbr>60;transport=udp
has been deleted<br>
<br>
Up until 13.10 everything was working
despite the warnings about field types. Now my
phones will not register. I can make calls but
not receive. All database modifications are
done through alembic so they are supposed to be
up to date. The only way I can find to solve
this issue right now is to restore a 13.10
backup for both the database and Asterisk.<br>
</blockquote>
<div><br>
</div>
</span>
<div>res_config_mysql has been in "extended" support
for some time now and it's possible it just will
no longer work. We only test alembic changes with
postgres or odbc now. Your best bet is to convert
to res_odbc.</div>
</div>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>Oh yeah, if you really do need res_config_mysql, go
ahead and open an issue at <a href="http://issues.asterisk.org" target="_blank">issues.asterisk.org</a>
and we'll take a look. Since we don't test with it
though, we might not notice if it gets broken again in the
future unless someone reports it.</div>
<div><br>
</div>
<div> </div>
<br>
</div>
</div>
</div>
</blockquote></span>
I have solved the problem for the moment by changing the
ps_contacts table with the "recommendations" res_config_mysql is
giving. I just modified all the fields to varchar and now my phones
are registering. Obviously this is not a solution as the database
needs to be modified by alembic on future versions and it will keep
breaking.<br>
<br>
I tried to migrate to res_config_odbc about 6 months ago but my
Asterisk kept crashing. I was told that the crashes were due to the
version of ODBC distributed by CentOS 7 and that I would have to
compile my own to be able to solve the issue. Has this been
solved? Is the RPM ODBC package included with CentOS 7 still
bugged? I try to avoid using packages not included in the
distribution as they make upgrades a pain later on.</div></blockquote><div><br></div><div>Although CentOS7 is still on 2.3.1 for unixodbc, there were changes made in 13.10.0 that should prevent the crashes. </div><div><a href="http://lists.digium.com/pipermail/asterisk-dev/2016-June/075582.html">http://lists.digium.com/pipermail/asterisk-dev/2016-June/075582.html</a><br></div><div><br></div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div bgcolor="#FFFFFF"><span class="gmail-"><br>
<pre cols="72">--
Telecomunicaciones Abiertas de México S.A. de C.V.
Carlos Chávez
+52 (55)9116-91161</pre>
</span></div>
<br>--<br>
______________________________<wbr>______________________________<wbr>_________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" rel="noreferrer" target="_blank">http://www.api-digital.com</a> --<br>
<br>
Join the Asterisk Community at the 13th AstriCon, September 27-29, 2016<br>
<a href="http://www.asterisk.org/community/astricon-user-conference" rel="noreferrer" target="_blank">http://www.asterisk.org/<wbr>community/astricon-user-<wbr>conference</a><br>
<br>
New to Asterisk? Start here:<br>
<a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" rel="noreferrer" target="_blank">https://wiki.asterisk.org/<wbr>wiki/display/AST/Getting+<wbr>Started</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" rel="noreferrer" target="_blank">http://lists.digium.com/<wbr>mailman/listinfo/asterisk-<wbr>users</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><span style="font-size:12.8px">George Joseph</span><br style="font-size:12.8px"><span style="font-size:12.8px">Digium, Inc. | Software Developer</span><span style="font-size:12.8px"><br>445 Jan Davis Drive NW - Huntsville, AL 35806 - US<br></span><span style="font-size:12.8px">Check us out at: </span><a href="http://www.digium.com/" rel="noreferrer" style="color:rgb(17,85,204);font-size:12.8px" target="_blank">www.digium.com</a><span style="font-size:12.8px"> & </span><a href="http://www.asterisk.org/" rel="noreferrer" style="color:rgb(17,85,204);font-size:12.8px" target="_blank">www.asterisk.org</a><br><div><br></div></div></div>
</div></div>