<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix"><tt>You mean the include files are actually
deployed by a percona package and not by a standard mysql
package ?<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
On 25.06.2014 20:45, Kelvin Williams wrote:<br>
</div>
<blockquote
cite="mid:CAJ9V0BZtXJCnn3kJYm44+btSKs5cqWhPkwQBGs1t2nvCwoaHZQ@mail.gmail.com"
type="cite">
<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
moz-do-not-send="true" 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 moz-do-not-send="true" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
On <a moz-do-not-send="true" 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
moz-do-not-send="true"
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 moz-do-not-send="true" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
On <a moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
href="mailto:kelvin@kelvinwilliams.net"
target="_blank">kelvin@kelvinwilliams.net</a></div>
<div><a moz-do-not-send="true"
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 moz-do-not-send="true" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a moz-do-not-send="true" 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 moz-do-not-send="true"
href="mailto:kelvin@kelvinwilliams.net"
target="_blank">kelvin@kelvinwilliams.net</a></div>
<div><a moz-do-not-send="true"
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 moz-do-not-send="true"
href="mailto:kelvin@kelvinwilliams.net" target="_blank">kelvin@kelvinwilliams.net</a></div>
<div>678.253.7871</div>
</div>
</blockquote>
<br>
</body>
</html>