<HTML xmlns:o = "urn:schemas-microsoft-com:office:office"><HEAD>
<META charset=UTF-8 http-equiv=Content-Type content="text/html; charset=UTF-8">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY style="FONT-SIZE: 12pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff">
<DIV><FONT face="Times New Roman">
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Hi ,</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"> I had raised a doubt regarding connecting to mysql database from the plugin.As per the solution that was suggested yesterday I have included the path where the libmysqlclient.so.* file is present in the /etc/ld.so.conf. file.</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">If <SPAN style="mso-spacerun: yes"> </SPAN>I give a command “locate libmysqlclient” in my system ,I am getting the following output.</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">[]$ <SPAN style="COLOR: blue">locate libmysqlclient<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">/usr/lib/mysql/libmysqlclient.la</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">/usr/lib/mysql/libmysqlclient_r.la</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">/usr/lib/mysql/libmysqlclient.a</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">/usr/lib/mysql/libmysqlclient_r.a</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">/usr/lib/libmysqlclient.so</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">/usr/lib/libmysqlclient.so.10.0.0</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">/usr/lib/libmysqlclient.so.10</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">/usr/lib/libmysqlclient.so.14.0.0</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">/usr/lib/libmysqlclient.so.14</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">/usr/lib/libmysqlclient_r.so.10</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">/usr/lib/libmysqlclient_r.so</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">/usr/lib/libmysqlclient_r.so.10.0.0</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">/usr/lib/libmysqlclient_r.so.14</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">/usr/lib/libmysqlclient_r.so.14.0.0</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">So after adding the path in the /etc/ld.so.conf file </P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">[root@localhost etc]# cat<SPAN style="COLOR: blue"> ld.so.conf</SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">/usr/kerberos/lib</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">/usr/X11R6/lib</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">/usr/lib/sane</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">/usr/lib/qt-3.1/lib</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><B style="mso-bidi-font-weight: normal"><SPAN style="COLOR: blue">/usr/lib/mysql<o:p></o:p></SPAN></B></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">While giving “make all” command for the plugins I am getting the following error still</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">undefined reference to `mysql_init'</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">undefined reference to `mysql_real_connect' …….</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">But while trying to compiling the plugin from the command prompt by giving the following command ,</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="COLOR: blue">gcc -o check_dummy1 check_dummy1.c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient -lz -fno-exceptions<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="COLOR: blue"><o:p> </o:p></SPAN><SPAN style="COLOR: blue"><o:p><FONT color=#000000>{check_dummy1 is the plugin in which i have coded to connect to the mysql database}</FONT></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"> </P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">I am not getting the error as undefined reference to “mysql_init” and other mysql related functions.{But the error I am getting is undefined reference for the functions that are common to all plugins like “undefined reference to `print_revision'” which I understand should come.}</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Now where should I make changes for linking with the mysql client library which is the problem as far i understand.</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Can anybody please help me out in this issue??</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Regards,</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Jaya</P></FONT></DIV></BODY></HTML>