| ROS Resources: Documentation | Support | Discussion Forum | Index | Service Status | ros @ Robotics Stack Exchange |
Hello,
How would I add MySQL functionality to a ROS project? I am running Ubuntu 11.04, I have MySQL installed, the .h is located at /usr/include/mysql/mysql.h.
Is there a way to include MySQL in the CMakeLists.txt file? Ideally, I would like to be able to do something like: #include <mysql.h> from my node.
Thanks!
This may not be complete:
First, add <rosdep name="libmysqlclient-dev"/> to your manifest.xml.
Reference the file in your C++ sources using: #include <mysql/mysql.h>
Add something like this to your CmakeLists.txt:
find_package(MySql REQUIRED)
include_directories(${MYSQL_INCLUDE_DIRS})
add_definitions(${MYSQL_DEFINITIONS})
UPDATE: a library that depends on MySQL probably needs to export some link flags in its manifest.xml like this:
<export>
<cpp lflags="-lmysqlclient"/>
</export>
Normally, that would be done using pkg-config, but I don't see a .pc file for MySQL on Ubuntu Oneiric. You may have to figure out the correct lflags experimentally.
I think this is on the right track... To give more info: I am trying to execute MySQL queries in a package that I expose as a library to another node... the library package compiles just fine, it's when I try to compile the node that depends on the library that I get an error.
Dustin, say for example I attempt to call a library function from within the C++ of the node that is using the library, and the library function uses mysql_init(...), the compiler will throw "mysql_init(...) has not been defined." The library package itself compiles just fine, however.
Yep, adding the linker flag appeared to fix it! I added exactly what you posted above.
Hello, I have the same problem (the compiler say "mysql_init(...) has not been defined". I have done everything suggested,I added in manifest and CMakelist files the lines referred. I use ROS groovy and Ubuntu 12.04. I think there is something else that is needed to work. What exactly do I need to put in "name" field of "rosdep"? I see many choices. The "lflag" is always the same? Thanks.
Asked: 2012-04-24 17:01:02 -0600
Seen: 1,772 times
Last updated: Apr 24 '13
ROS Answers is licensed under Creative Commons Attribution 3.0 Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
