Missing symbols for dialog.so on Mac OS X

[monty solomon]

I built a fresh copy of Percona Server on OS X and then tried to use dialog.so with the Percona PAM authentication plugin for MySQL.

MySQL said: Authentication plugin 'dialog' cannot be loaded: dlopen(/usr/local/lib/plugin/dialog.so, 2): Symbol not found: _my_stpnmov
  Referenced from: /usr/local/lib/plugin/dialog.so
  Expected in: /Applications/Sequel Pro.app/Contents/MacOS/Sequel Pro
 in /usr/local/lib/plugin/dialog.so

[monty solomon (monty+launchpad)]

I built Percona Server different ways and the dialog.so failed to find the symbols

cmake .. -G Xcode -DWITH_BOOST=/Users/monty/boost_1_59_0/ -DCMAKE_VERBOSE_MAKEFILE=ON -DCMAKE_BUILD_TYPE=RelWithDebInfo -DWITH_PAM=yes -DHAVE_STRUCT_IFREQ_IFR_NAME=yes -DCMAKE_FIND_FRAMEWORK=LAST -DWITHOUT_TOKUDB=1

xcodebuild -configuration RelWithDebInfo

[monty solomon (monty+launchpad)]

brew install percona-server

after modifying the formula to include

      -DWITH_PAM=yes
      -DHAVE_PAM=yes
      -DHAVE_STRUCT_IFREQ_IFR_NAME=yes

[monty solomon (monty+launchpad)]

percona-server-5.7.17-11

[monty solomon (monty+launchpad)]

$ nm -gu dialog.so
___stack_chk_fail
___stack_chk_guard
___stdinp
_dlsym
_fgets
_free
_getpass
_my_stpnmov
_strcmp
_strdup
_strlen
_strncpy
dyld_stub_binder

[monty solomon (monty+launchpad)]

There appears to be an issue with the build and enabling dialog.so to find my_stpnmov in libperconaserverclient.dylib.

Copying the code for my_stpnmov into the dialog.c file before building permits it to work.

[monty solomon (monty+launchpad)]

An additional incompatibility is the moving of the plugins to a different directory.

Upstream
 SET(INSTALL_PLUGINDIR_STANDALONE "lib/plugin")

Percona
 SET(INSTALL_PLUGINDIR_STANDALONE "lib/mysql/plugin")

[monty solomon (monty+launchpad)]

The library should be named libmysqlclient instead of libperconaserverclient on OS X.

Excerpt from MySQL C API Implementations
https://dev.mysql.com/doc/refman/5.7/en/c-api-implementations.html

On Unix (and Unix-like) sytems, the static library is libmysqlclient.a. The dynamic library is libmysqlclient.so on most Unix systems and libmysqlclient.dylib on OS X.

For distributions that include embedded server libraries, the corresponding library names begin with libmysqld rather than libmysqlclient.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3658