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

[Kelvin Williams]

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


-- 

--
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/b4007b90/attachment-0001.htm>