[OpenSIPS-Users] db_mysql compilation issues.... Resolved.

[Bogdan-Andrei Iancu]

You mean the include files are actually deployed by a percona package 
and not by a standard mysql package ?

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 25.06.2014 20:45, Kelvin Williams wrote:
> It would appear we use Percona in our production boxes.
>
>
> On Wed, Jun 25, 2014 at 1:05 PM, Bogdan-Andrei Iancu 
> <bogdan at opensips.org <mailto:bogdan at opensips.org>> wrote:
>
>     Strange.... I have Ubuntu 14.04 LTS and mysql has the include
>     files under /usr/local/mysql/ and /usr/local/mysql/mysql/
>
>     And "mysql_config" reports the same as in your case. Are you sure
>     you do not have any package mixing or so ?
>
>     Regards,
>
>     Bogdan-Andrei Iancu
>     OpenSIPS Founder and Developer
>     http://www.opensips-solutions.com
>
>     On 25.06.2014 17 <tel:25.06.2014%2017>:14, Kelvin Williams wrote:
>>     Bogdan:
>>
>>     I generally install from the libmysqlclient-dev from apt-get.
>>      Below is the output you asked about:
>>
>>     root at 13cn36:~# cat /etc/issue
>>     Ubuntu 12.04.4 LTS \n \l
>>
>>     root at 13cn36:~# mysql_config --include
>>     -I/usr/include
>>     root at 13cn36:~# mysql_config --include | sed 's/\(-I.*\)\/mysql/\1/g'
>>     -I/usr/include
>>     root at 13cn36:~# cd /usr/include/mysql/
>>     root at 13cn36:/usr/include/mysql# ls
>>     client_authentication.h  plugin_audit.h.pp plugin.h              
>>          services.h
>>     client_plugin.h          plugin_auth_common.h
>>      plugin_validate_password.h  service_thd_alloc.h
>>     client_plugin.h.pp       plugin_auth.h psi                      
>>       service_thd_wait.h
>>     get_password.h           plugin_auth.h.pp
>>      service_my_plugin_log.h service_thread_scheduler.h
>>     innodb_priv.h            plugin_ftparser.h service_my_snprintf.h
>>           thread_pool_priv.h
>>     plugin_audit.h           plugin_ftparser.h.pp  service_mysql_string.h
>>     root at 13cn36:/usr/include/mysql# cd ..
>>     root at 13cn36:/usr/include# ls mysql*
>>     mysql_com.h  mysql_com_server.h  mysqld_ername.h  mysqld_error.h
>>      mysql_embed.h  mysql.h  mysql_time.h  mysql_version.h
>>
>>
>>     On Wed, Jun 25, 2014 at 6:03 AM, Bogdan-Andrei Iancu
>>     <bogdan at opensips.org <mailto:bogdan at opensips.org>> wrote:
>>
>>         Hi Kelvin,
>>
>>         The Makefile for the db_mysql module is using the
>>         mysql_config tool in order to "learn" the correct path for
>>         include files and libraries. There is no need to change the
>>         code in the module.
>>
>>         In your case, what is the output for (running in shell) :
>>             mysql_config --include
>>             mysql_config --include | sed 's/\(-I.*\)\/mysql/\1/g'
>>
>>         Also, is your mysql installed via packages or from sources ?
>>         I use also Ubuntu and I see mysql include files installed under:
>>             /usr/include/mysql/
>>
>>         Regards,
>>
>>         Bogdan-Andrei Iancu
>>         OpenSIPS Founder and Developer
>>         http://www.opensips-solutions.com
>>
>>         On 25.06.2014 05 <tel:25.06.2014%2005>:30, Kelvin Williams wrote:
>>>         Several times recently when trying to build OpenSIPS from
>>>         source I had trouble with the required MySQL libraries not
>>>         being found even though I knew they were installed on the box.
>>>
>>>         After looking a bit further I found that the
>>>         libmysqlclient-dev package does not install them in
>>>         /usr/lib/mysql/* but /usr/lib/mysql.  The includes specify
>>>         the mysql directory.
>>>
>>>         I've created a patch that I use now prior to compilation and
>>>         it works every time (on our Ubuntu boxes).  Is there a
>>>         reason for the hard path to mysql/*?
>>>
>>>         Patch:
>>>         https://gist.github.com/kelvinewilliams/6767892c153193b11008
>>>
>>>         -- 
>>>
>>>         --
>>>         Kelvin Williams
>>>         kelvin at kelvinwilliams.net <mailto:kelvin at kelvinwilliams.net>
>>>         678.253.7871 <tel:678.253.7871>
>>>
>>>
>>>         _______________________________________________
>>>         Users mailing list
>>>         Users at lists.opensips.org  <mailto:Users at lists.opensips.org>
>>>         http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>>
>>
>>     -- 
>>
>>     --
>>     Kelvin Williams
>>     kelvin at kelvinwilliams.net <mailto:kelvin at kelvinwilliams.net>
>>     678.253.7871 <tel:678.253.7871>
>
>
>
>
> -- 
>
> --
> Kelvin Williams
> kelvin at kelvinwilliams.net <mailto:kelvin at kelvinwilliams.net>
> 678.253.7871

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20140626/9f6097be/attachment.htm>