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

[Bogdan-Andrei Iancu]

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: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

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