<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><base href="x-msg://21/"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Thank you Paul, that solved the problem once I set the env variable (which I did not have)<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>setenv MYSQL_INCLUDE_PATH /usr/include/mysql/<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I will put this into my .cshrc.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Now I passed the mysql error but I encountered the following error:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>make[2]: Entering directory `/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/helcor_eg6'<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>make[2]: *** No rule to make target `lib'. Stop.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>make[2]: Leaving directory `/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/helcor_eg6'<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>make[1]: *** [helcor_eg6] Error 2<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>make[1]: Leaving directory `/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages'<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>make: *** [lib] Error 2<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Any suggestion on this one? I don’t have any idea what to do here..<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Just for the record, I had to make various changes to overcome number of arithmetic overflow errors to reach to this point..<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Best regards, - NG<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> Paul Mattione [mailto:pmatt@jlab.org] <br><b>Sent:</b> Tuesday, February 11, 2014 11:14 PM<br><b>To:</b> Nevzat Guler<br><b>Cc:</b> 'CLAS Offline'<br><b>Subject:</b> Re: [Clas_offline] mysql.h<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>On ifarm1102, this file is located in:<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>/usr/include/mysql/<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Assuming there are no eccentricities in the eg1b software, make sure that your $MYSQL_INCLUDE_PATH environment variable is pointing to this directory. <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> - Paul<o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On Feb 11, 2014, at 10:52 PM, Nevzat Guler wrote:<o:p></o:p></p></div><p class=MsoNormal><br><br><o:p></o:p></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><div><div><p class=MsoNormal><span style='color:#1F497D'>Dear CLAS offline members,</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I am trying to recompile my clas libraries for Linux64RHEL5. During compilation, I encounter some error related to a missing file mysql.h in calib_connect.c</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I am printing the part of the message below</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I appreciate any suggestion on the nature of this error message and how to fix it.</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Thanks, - NG</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>ar: creating /home/nguler/eg1b/clas/builds/release-4-15/lib/Linux64RHEL5/libana.a</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>make[2]: Leaving directory `/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/ana'</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>if test -d caldb; then \</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> make -e -C caldb lib; \</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> fi</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>make[2]: Entering directory `/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/caldb'</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>make -C Map lib</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>make[3]: Entering directory `/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/caldb/Map'</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/cms/Makefile:661: depends/Linux64RHEL5/calib_connect.d: No such file or directory</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/cms/Makefile:661: depends/Linux64RHEL5/calib_disconnect.d: No such file or directory</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/cms/Makefile:661: depends/Linux64RHEL5/calib_get_char.d: No such file or directory</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/cms/Makefile:661: depends/Linux64RHEL5/calib_get_float.d: No such file or directory</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/cms/Makefile:661: depends/Linux64RHEL5/calib_get_int.d: No such file or directory</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/cms/Makefile:661: depends/Linux64RHEL5/calib_put.d: No such file or directory</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/cms/Makefile:661: depends/Linux64RHEL5/calib_stat_item.d: No such file or directory</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/cms/Makefile:661: depends/Linux64RHEL5/calib_tcl_init.d: No such file or directory</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/cms/Makefile:661: depends/Linux64RHEL5/Map_wrap.d: No such file or directory</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/cms/Makefile:664: depends/Linux64RHEL5/calib_test.dd: No such file or directory</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Makefile: making dependency file for calib_test.c</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>calib_test.c:8:19: error: mysql.h: No such file or directory</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Makefile: making dependency file for Map_wrap.c</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Makefile: making dependency file for calib_tcl_init.c</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Makefile: making dependency file for calib_stat_item.c</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>calib_stat_item.c:10:19: mysql.h: No such file or directory</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Makefile: making dependency file for calib_put.c</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>calib_put.c:11:19: mysql.h: No such file or directory</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Makefile: making dependency file for calib_get_int.c</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>calib_get_int.c:10:19: mysql.h: No such file or directory</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Makefile: making dependency file for calib_get_float.c</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>calib_get_float.c:11:19: mysql.h: No such file or directory</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Makefile: making dependency file for calib_get_char.c</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>calib_get_char.c:11:19: mysql.h: No such file or directory</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Makefile: making dependency file for calib_disconnect.c</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>calib_disconnect.c:8:19: mysql.h: No such file or directory</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Makefile: making dependency file for calib_connect.c</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>calib_connect.c:10:19: mysql.h: No such file or directory</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>make[3]: Leaving directory `/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/caldb/Map'</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>make[3]: Entering directory `/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/caldb/Map'</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>gcc -O3 -m64 -fPIC -DLinux -DLinux64 -fPIC \</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> -I -I. -I./ -I/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/include -I/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/inc_derived -I/usr/include -I/usr/X11R6/include -c \</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> calib_connect.c -o /home/nguler/eg1b/clas/builds/release-4-15/obj/Linux64RHEL5/Map/calib_connect.o</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>calib_connect.c:10:19: error: mysql.h: No such file or directory</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>In file included from calib_connect.c:11:</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/include/calib_manager.h:51: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'mysql'</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>calib_connect.c:18: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'mysql'</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>calib_connect.c: In function 'calib_connect':</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>calib_connect.c:38: error: 'mysql' undeclared (first use in this function)</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>calib_connect.c:38: error: (Each undeclared identifier is reported only once</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>calib_connect.c:38: error: for each function it appears in.)</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>calib_connect.c:111: error: 'MYSQL_OPT_COMPRESS' undeclared (first use in this function)</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>make[3]: *** [/home/nguler/eg1b/clas/builds/release-4-15/lib/Linux64RHEL5/libcaldbMap.a(calib_connect.o)] Error 1</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>make[3]: Leaving directory `/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/caldb/Map'</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>make[2]: *** [lib] Error 2</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>make[2]: Leaving directory `/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages/caldb'</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>make[1]: *** [caldb] Error 2</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>make[1]: Leaving directory `/w/hallb/claseg1/nguler/Include/clas/builds/release-4-15/packages'</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>make: *** [lib] Error 2</span><o:p></o:p></p></div></div></div><p class=MsoNormal>_______________________________________________<br>Clas_offline mailing list<br><a href="mailto:Clas_offline@jlab.org">Clas_offline@jlab.org</a><br><a href="https://mailman.jlab.org/mailman/listinfo/clas_offline">https://mailman.jlab.org/mailman/listinfo/clas_offline</a><o:p></o:p></p></div></blockquote></div><p class=MsoNormal><o:p> </o:p></p></div></body></html>