<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hello Carlos,</p>
<p>I'm testing CentOS 7 ODBC packages with PJSIP Realtime without
problems.</p>
<p>Maybe you use a different configuration?<br>
</p>
Regards<br>
<br>
<div class="moz-cite-prefix">El 12/09/2016 a las 16:01, Carlos
Chavez escribió:<br>
</div>
<blockquote
cite="mid:4decfd3e-784d-4d79-3e5d-4c8026a79c3d@telecomabmex.com"
type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<p>On 9/12/16 3:39 PM, George Joseph wrote:<br>
</p>
<blockquote
cite="mid:CAP=uFEtOP7E3kenJq5i4FJHYY8RmXmmW=qo5n2am9vq+U-biHw@mail.gmail.com"
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:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><br>
<div class="gmail_extra"><br>
<div class="gmail_quote"><span class="">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:0
0 0 .8ex;border-left:1px #ccc
solid;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">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>
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.<br>
<pre class="moz-signature" cols="72">--
Telecomunicaciones Abiertas de México S.A. de C.V.
Carlos Chávez
+52 (55)9116-91161</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
</blockquote>
<br>
</body>
</html>