<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>On 9/12/16 4:21 PM, George Joseph wrote:<br>
</p>
<blockquote
cite="mid:CAP=uFEuxF3kVYdq2Z7vPf7EidWaS7GhT7An8B4nKKuEa3NXSPQ@mail.gmail.com"
type="cite">
<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 moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
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 moz-do-not-send="true"
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
moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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>
</div>
</blockquote>
Ok, thank you for the help. I'll be trying out ODBC later today
and test it for a few days. You should probably mark
res_config_mysql as deprecated now since it will not work with
anything higher than 13.10 as is.<br>
<br>
<blockquote
cite="mid:CAP=uFEuxF3kVYdq2Z7vPf7EidWaS7GhT7An8B4nKKuEa3NXSPQ@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_extra">
<div class="gmail_quote">-- </div>
</div>
</div>
</blockquote>
<pre class="moz-signature" cols="72">Telecomunicaciones Abiertas de México S.A. de C.V.
Carlos Chávez
+52 (55)9116-91161</pre>
</body>
</html>