asterisk users - Oct 2016 - Asterisk 11.23 with libmysqlclient20 on Debian 8

Hi List!

I'm facing a problem while compiling Asterisk-11 on a Debian 8 server.

The mysql-server version installed is 5.7 and come from the official mySQL
community repo for Debian.

After compile, install and execute Asterisk, the comman "lsof -p `pidof
asterisk` | grep mysql" don't produce any output. Like if confgure
script
don't found the mysql lib.

With libmysqlclient18 every is Ok. How can I use libmysqlclient20 with
Asterisk ?

Thanks in advance, and best regards.

root at nodo1:/usr/src/asterisk-11.23.0# ls -lh /usr/lib/x86_64-linux-gnu/ |
grep mysql
-rw-r--r-- 1 root root 5,7M ago 25 09:37 libmysqlclient.a
lrwxrwxrwx 1 root root   20 ago 25 09:37 libmysqlclient.so ->
libmysqlclient.so.20
lrwxrwxrwx 1 root root   24 ago 25 09:37 libmysqlclient.so.20 ->
libmysqlclient.so.20.3.2
-rw-r--r-- 1 root root 4,2M ago 25 09:37 libmysqlclient.so.20.3.2
-rw-r--r-- 1 root root  18K ago 25 09:37 libmysqlservices.a

-- 
GnuPG Key ID: 0x39BCA9D8
https://www.github.com/mefhigoseth
...:::[ God Rulz ! ]:::...
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20161003/159e8c86/attachment.html>

I think that you need the dev files too. In Debian 8, the package is
libmysqlclient-dev.

But Debian 8 uses libmysqlclient-18. Where did you get the 20 ?

Regards,

Marcelo H. Terres <mhterres at gmail.com>
IM: mhterres at jabber.mundoopensource.com.br
https://www.mundoopensource.com.br
https://twitter.com/mhterres
https://linkedin.com/in/marceloterres


On Mon, Oct 3, 2016 at 7:54 PM, Victor Villarreal <mefhigoseth at
gmail.com> wrote:
> Hi List!
>
> I'm facing a problem while compiling Asterisk-11 on a Debian 8 server.
>
> The mysql-server version installed is 5.7 and come from the official mySQL
> community repo for Debian.
>
> After compile, install and execute Asterisk, the comman "lsof -p
`pidof
> asterisk` | grep mysql" don't produce any output. Like if confgure
script
> don't found the mysql lib.
>
> With libmysqlclient18 every is Ok. How can I use libmysqlclient20 with
> Asterisk ?
>
> Thanks in advance, and best regards.
>
> root at nodo1:/usr/src/asterisk-11.23.0# ls -lh /usr/lib/x86_64-linux-gnu/
|
> grep mysql
> -rw-r--r-- 1 root root 5,7M ago 25 09:37 libmysqlclient.a
> lrwxrwxrwx 1 root root   20 ago 25 09:37 libmysqlclient.so ->
> libmysqlclient.so.20
> lrwxrwxrwx 1 root root   24 ago 25 09:37 libmysqlclient.so.20 ->
> libmysqlclient.so.20.3.2
> -rw-r--r-- 1 root root 4,2M ago 25 09:37 libmysqlclient.so.20.3.2
> -rw-r--r-- 1 root root  18K ago 25 09:37 libmysqlservices.a
>
> --
> GnuPG Key ID: 0x39BCA9D8
> https://www.github.com/mefhigoseth
> ...:::[ God Rulz ! ]:::...
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> Join the Asterisk Community at the 13th AstriCon, September 27-29, 2016
>       http://www.asterisk.org/community/astricon-user-conference
>
> New to Asterisk? Start here:
>       https://wiki.asterisk.org/wiki/display/AST/Getting+Started
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users

On Mon, Oct 03, 2016 at 07:54:23PM -0300, Victor Villarreal
wrote:
> Hi List!
> 
> I'm facing a problem while compiling Asterisk-11 on a Debian 8 server.
> 
> The mysql-server version installed is 5.7 and come from the official mySQL
> community repo for Debian.
For the record, we ubild both asterisk 11 (last version: 11.21.2) and 13
(13.11.2) for Debian Stable using the distro-provided MySQL packages.
> 
> After compile, install and execute Asterisk, the comman "lsof -p
`pidof
> asterisk` | grep mysql" don't produce any output. Like if confgure
script
> don't found the mysql lib.
Is Are there any mysql-related module loaded?

Start with e.g.

  ldd /usr/lib/asterisk/module/cdr_mysql.so
> 
> With libmysqlclient18 every is Ok. How can I use libmysqlclient20 with
> Asterisk ?
Were the relevant modules built? Do you use direct MySQL support? ODBC?
Maybe you forgot to install development headers?
> 
> Thanks in advance, and best regards.
> 
> root at nodo1:/usr/src/asterisk-11.23.0# ls -lh /usr/lib/x86_64-linux-gnu/
|
> grep mysql
> -rw-r--r-- 1 root root 5,7M ago 25 09:37 libmysqlclient.a
> lrwxrwxrwx 1 root root   20 ago 25 09:37 libmysqlclient.so ->
> libmysqlclient.so.20
This one typically comes from the development headers package, so it's
probably installed.
> lrwxrwxrwx 1 root root   24 ago 25 09:37 libmysqlclient.so.20 ->
> libmysqlclient.so.20.3.2
> -rw-r--r-- 1 root root 4,2M ago 25 09:37 libmysqlclient.so.20.3.2
> -rw-r--r-- 1 root root  18K ago 25 09:37 libmysqlservices.a
-- 
               Tzafrir Cohen
icq#16849755              jabber:tzafrir.cohen at xorcom.com
+972-50-7952406           mailto:tzafrir.cohen at xorcom.com
http://www.xorcom.com