{"id":780,"date":"2008-04-14T08:45:53","date_gmt":"2008-04-14T13:45:53","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/14\/compiling-mysql-udfs-on-mac-os-x"},"modified":"2008-04-14T11:28:29","modified_gmt":"2008-04-14T16:28:29","slug":"compiling-mysql-udfs-on-mac-os-x","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/14\/compiling-mysql-udfs-on-mac-os-x","title":{"rendered":"Compiling MySQL UDFs on Mac OS X"},"content":{"rendered":"

Compiling and installing a User Defined Function for MySQL on Mac OS X seems tricky. There are installation notes<\/a>, but they seem to be sparse on OS X (the comments are clues, though).<\/p>\n

I was looking through the tutorial materials for Roland’s<\/a> talk, and came up with what I think is the most full-proof way to ensure your UDFs get compiled…<\/p>\n

gcc -Wall -dynamiclib -o udf_lightspeed.dylib -lstdc++ udf_lightspeed.c<\/tt><\/p>\n

The above will compile just fine, but MySQL will give you an interesting error saying “no suitable image found”. Its the infamous Error 1126.<\/p>\n

Upon further poking, it seemed like the following should work:
\ngcc -Wall -dynamiclib -o udf_lightspeed.dylib -lstdc++ -lc -I`\/usr\/local\/mysql\/bin\/mysql_config --cflags` udf_lightspeed.c<\/tt><\/p>\n

And it does. MySQL loads the UDF just fine. But sometimes, you get linker errors, which can be annoying.<\/p>\n

So, the full-proof solution to compiling UDFs on OS X, Leopard 10.5? A two-step process:
\ngcc -c `\/usr\/local\/mysql\/bin\/mysql_config --cflags` udf_lightspeed.c
\nlibtool -dynamic -o udf_lightspeed.so udf_lightspeed.o -lc<\/tt><\/p>\n

Feel free to add -O2<\/tt> as an option to GCC. One day I might talk about the amazing mysql_config<\/tt> (use it! Read the documentation<\/a>, in the meantime.)<\/p>\n

Remember, once you’ve your your .dylib, to move it to your plugin_dir (find it by doing SHOW VARIABLES LIKE 'plugin_dir';<\/tt>). Also note that on OS X, it doesn’t matter if the extension is .dylib or .so – either one will do.<\/p>\n

Happy UDF usage!<\/p>\n

Update:<\/strong> As a reader points out in the comments, probably the easiest way, in a one-step process, is to use the bundle_loader<\/tt>. gcc -Wall -bundle -bundle_loader \/usr\/local\/mysql\/bin\/mysqld -o udf_return_values.so `\/usr\/local\/mysql\/bin\/mysql_config \u2014cflags` udf_return_values.c<\/tt> works a charm.<\/p>\n

Technorati Tags: udf<\/a>, mysql<\/a>, compiling<\/a>, macosx<\/a>, leopard<\/a>, libtool<\/a>, mysql_config<\/a><\/p>\n

Share this:<\/h3>