<div dir="ltr">It would appear we use Percona in our production boxes.</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Jun 25, 2014 at 1:05 PM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div><tt>Strange.... I have Ubuntu 14.04 LTS
and mysql has the include files under /usr/local/mysql/ and
/usr/local/mysql/mysql/<br>
<br>
And "mysql_config" reports the same as in your case. Are you
sure you do not have any package mixing or so ?<br>
<br>
Regards, </tt><br>
<pre cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
On <a href="tel:25.06.2014%2017" value="+12506201417" target="_blank">25.06.2014 17</a>:14, Kelvin Williams wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>Bogdan:</div>
<div><br>
</div>
<div>I generally install from the libmysqlclient-dev from
apt-get. Below is the output you asked about:</div>
<div><br>
</div>
<div>root@13cn36:~# cat /etc/issue</div>
<div>Ubuntu 12.04.4 LTS \n \l</div>
<div><br>
</div>
<div>root@13cn36:~# mysql_config --include</div>
<div>-I/usr/include</div>
<div>root@13cn36:~# mysql_config --include | sed
's/\(-I.*\)\/mysql/\1/g'</div>
<div>-I/usr/include</div>
<div>root@13cn36:~# cd /usr/include/mysql/</div>
<div>root@13cn36:/usr/include/mysql# ls</div>
<div>client_authentication.h plugin_audit.h.pp plugin.h
services.h</div>
<div>client_plugin.h plugin_auth_common.h
plugin_validate_password.h service_thd_alloc.h</div>
<div>client_plugin.h.pp plugin_auth.h psi
service_thd_wait.h</div>
<div>get_password.h plugin_auth.h.pp
service_my_plugin_log.h service_thread_scheduler.h</div>
<div>
innodb_priv.h plugin_ftparser.h
service_my_snprintf.h thread_pool_priv.h</div>
<div>plugin_audit.h plugin_ftparser.h.pp
service_mysql_string.h</div>
<div>
<div>root@13cn36:/usr/include/mysql# cd ..</div>
<div>root@13cn36:/usr/include# ls mysql*</div>
<div>mysql_com.h mysql_com_server.h mysqld_ername.h
mysqld_error.h mysql_embed.h mysql.h mysql_time.h
mysql_version.h</div>
</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Wed, Jun 25, 2014 at 6:03 AM,
Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div><tt>Hi Kelvin,<br>
<br>
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.<br>
<br>
In your case, what is the output for (running in
shell) :<br>
mysql_config --include<br>
mysql_config --include | sed
's/\(-I.*\)\/mysql/\1/g'<br>
<br>
Also, is your mysql installed via packages or from
sources ? I use also Ubuntu and I see mysql include
files installed under:<br>
/usr/include/mysql/<br>
<br>
Regards,<br>
</tt>
<pre cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
On <a href="tel:25.06.2014%2005" value="+12506201405" target="_blank">25.06.2014 05</a>:30,
Kelvin Williams wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">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.
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>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/*?</div>
<div><br>
</div>
<div>Patch: <a href="https://gist.github.com/kelvinewilliams/6767892c153193b11008" target="_blank">https://gist.github.com/kelvinewilliams/6767892c153193b11008</a><span><font color="#888888"><br>
</font></span></div>
<span><font color="#888888">
<div>
<div><br>
</div>
-- <br>
<br>
<div>--</div>
<div>Kelvin Williams</div>
<div><a href="mailto:kelvin@kelvinwilliams.net" target="_blank">kelvin@kelvinwilliams.net</a></div>
<div><a href="tel:678.253.7871" value="+16782537871" target="_blank">678.253.7871</a></div>
</div>
</font></span></div>
<span><font color="#888888"> <br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Users mailing list
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</font></span></blockquote>
<br>
</div>
</blockquote>
</div>
<br>
<br clear="all"><span class="HOEnZb"><font color="#888888">
<div><br>
</div>
-- <br>
<br>
<div>--</div>
<div>Kelvin Williams</div>
<div><a href="mailto:kelvin@kelvinwilliams.net" target="_blank">kelvin@kelvinwilliams.net</a></div>
<div><a href="tel:678.253.7871" value="+16782537871" target="_blank">678.253.7871</a></div>
</font></span></div>
</blockquote>
<br>
</div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><br><div>--</div><div>Kelvin Williams</div><div><a href="mailto:kelvin@kelvinwilliams.net" target="_blank">kelvin@kelvinwilliams.net</a></div><div>678.253.7871</div>
</div>