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

[Kelvin Williams]

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>
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 Developerhttp://www.opensips-solutions.com
>
> On 25.06.2014 05: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
> 678.253.7871
>
>
> _______________________________________________
> Users mailing listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>


-- 

--
Kelvin Williams
kelvin at kelvinwilliams.net
678.253.7871
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20140625/078984a4/attachment-0001.htm>