RE: MySQL statement in caMonitor code

[Mark Rivers via Tech-talk <tech-talk@aps.anl.gov>]

Hi Aaron,

 

My mistake, /usr/lib64/mysql is a directory, not a library, so those lines should be the following (I also added EPICS_BASE_HOST_LIBS).

 

PROD_HOST += caMonitor

caMonitor_SRCS += caMonitor.c

USR_CFLAGS += -I/usr/include/mysql

USR_LDFLAGS += -L/usr/lib64/mysql

caMonitor_LIBS += $(EPICS_BASE_HOST_LIBS)

caMonitor_SYS_LIBS += mysqlclient pthread z m dl ssl crypto

 

Mark

 

 

 

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

 

Okay,

I have changed my Makefile:

 

TOP=..

 

include $(TOP)/configure/CONFIG

#----------------------------------------

#  ADD MACRO DEFINITIONS AFTER THIS LINE

#=============================

 

PROD_HOST += caExample

caExample_SRCS += caExample.c

caExample_LIBS += $(EPICS_BASE_HOST_LIBS)

 

PROD_HOST += caMonitor

caMonitor_SRCS += caMonitor.c

USR_CFLAGS += -I/usr/include/mysql

USR_LDFLAGS += -L/usr/lib64/

caMonitor_SYS_LIBS += mysql mysqlclient pthread z m dl ssl crypto

 

include $(TOP)/configure/RULES

#----------------------------------------

#  ADD RULES AFTER THIS LINE

 

I have attached a screenshot of the errors that I'm still getting. For some reason it's still saying that it cannot find the libraries.

---

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

 

Hi Aaron,

 

Change these lines:

 

caMonitor_SYS_LIBS += -I/usr/include/mysql

USR_LDFLAGS += -L/usr/lib64/mysql -lmysqlclient -lpthread -lz -lm -ldl -lssl -lcrypto

 

to this:

 

USR_CFLAGS += -I/usr/include/mysql

USR_LDFLAGS += -L/usr/lib64/

caMonitor_SYS_LIBS += mysql mysqlclient pthread z m dl ssl crypto

 

The USR_LDFLAGS line is almost certainly not needed, because it will search that library by default.

 

You can probably also remove pthread and m from caMonitor_SYS_LIBS because EPICS base uses those by default.

 

Mark

 

 

 

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

 

So, here is what I have changed my Makefile to:

 

TOP=..

 

include $(TOP)/configure/CONFIG

#----------------------------------------

#  ADD MACRO DEFINITIONS AFTER THIS LINE

#=============================

 

PROD_HOST += caExample

caExample_SRCS += caExample.c

caExample_LIBS += $(EPICS_BASE_HOST_LIBS)

 

PROD_HOST += caMonitor

caMonitor_SRCS += caMonitor.c

caMonitor_SYS_LIBS += -I/usr/include/mysql

USR_LDFLAGS += -L/usr/lib64/mysql -lmysqlclient -lpthread -lz -lm -ldl -lssl -lcrypto

 

 

include $(TOP)/configure/RULES

#----------------------------------------

#  ADD RULES AFTER THIS LINE

 

Now the error I am getting is:

"cannot find -l-I/usr/include/mysql" even though that is what running mysql_config --cflags returns. Did I do this correctly?

---

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

 

Your Makefile should be changed to

caMonitor _SYS_LIBS += all your libraries without the -l in front of each.

The -L is probably not needed but it would go in

USR_LDFLAGS += -L ...

Mark


Sent from my iPhone

On Dec 3, 2019, at 8:58 AM, Aaron Brown <ambrown@jlab.org<mailto:ambrown@jlab.org>> wrote:

This is what my make file looks like:

TOP=..

include $(TOP)/configure/CONFIG
#----------------------------------------
#  ADD MACRO DEFINITIONS AFTER THIS LINE
#=============================

PROD_HOST += caExample
caExample_SRCS += caExample.c
caExample_LIBS += $(EPICS_BASE_HOST_LIBS)

PROD_HOST += caMonitor
caMonitor_SRCS += caMonitor.c
caMonitor_LIBS += $(EPICS_BASE_HOST_LIBS)

MYSQLCFLAGS += -I/usr/include/mysql
MYSQLLIBS += -L/usr/lib64/mysql -lmysqlclient -lpthread -lz -lm -ldl -lssl -lcrypto

include $(TOP)/configure/RULES
#----------------------------------------
#  ADD RULES AFTER THIS LINE

I have highlighted my additions in yellow. I got the library paths from running mysql_config --cflags --libs.


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

Please send the Makefile.


________________________________
From: Aaron Brown <ambrown@jlab.org<mailto:ambrown@jlab.org>>
Sent: Tuesday, December 3, 2019 7:18 AM
To: Mark Rivers
Cc: tech-talk
Subject: Re: MySQL statement in caMonitor code

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<mailto:rivers@cars.uchicago.edu>>
Sent: Tuesday, December 3, 2019 8:10 AM
To: Aaron Brown <ambrown@jlab.org<mailto:ambrown@jlab.org>>
Cc: tech-talk <tech-talk@aps.anl.gov<mailto: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<mailto:tech-talk-bounces@aps.anl.gov>> on behalf of Aaron Brown via Tech-talk <tech-talk@aps.anl.gov<mailto:tech-talk@aps.anl.gov>>
Sent: Tuesday, December 3, 2019 6:50 AM
To: tech-talk@aps.anl.gov<mailto: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