Re: MySQL statement in caMonitor code

[Aaron Brown via Tech-talk <tech-talk@aps.anl.gov>]

Hi Mark,

I tried that, but everything I did returned some sort of "missing separator" error. 

I tried typing the paths to the libraries at the end of the Makefile and at the beginning.

I even tried this:

MYSQLLIBS += <path to libraries>

I keep getting the same "missing separator" error.

Thanks,

Aaron Brown

Detector Support Group

Jefferson Lab

---

From: Mark Rivers <rivers@cars.uchicago.edu>
Sent: Tuesday, December 3, 2019 8:10 AM
To: Aaron Brown <ambrown@jlab.org>
Cc: tech-talk <tech-talk@aps.anl.gov>
Subject: [EXTERNAL] Re: MySQL statement in caMonitor code

 

> I think this means there is a linker issue, but am not sure how to fix this.


Did you modify the Makefile to add the MySQL libraries to those that should be linked with?


Mark



________________________________
From: Tech-talk <tech-talk-bounces@aps.anl.gov> on behalf of Aaron Brown via Tech-talk <tech-talk@aps.anl.gov>
Sent: Tuesday, December 3, 2019 6:50 AM
To: tech-talk@aps.anl.gov
Subject: MySQL statement in caMonitor code

Hello all,

I have embedded a MySQL statement in the caMonitor example code. I have included all the necessary header files, I think, but when I compile it complains of undefined references:

caMonitor.o: In function `eventCallback':
/home/ambrown/3rdTest/3rdTestApp/O.linux-x86_64/../caMonitor.c:74: undefined reference to `mysql_init'
/home/ambrown/3rdTest/3rdTestApp/O.linux-x86_64/../caMonitor.c:75: undefined reference to `mysql_real_connect'
/home/ambrown/3rdTest/3rdTestApp/O.linux-x86_64/../caMonitor.c:92: undefined reference to `mysql_query'
/home/ambrown/3rdTest/3rdTestApp/O.linux-x86_64/../caMonitor.c:93: undefined reference to `mysql_close'
collect2: error: ld returned 1 exit status

I think this means there is a linker issue, but am not sure how to fix this.
Any ideas?

Thanks
Aaron Brown
Detector Support Group
Jefferson Lab