Is this project still alive? I notice that Patrick no longer works for MySQL and the URL to the project is a dead link.

Patrick,

Do you have any updates on FederatedX? It does not work with 5.1 . I really need improvements to the default federated engine. I would even pay a modest sum to get this working.

Thanks, Justin Noel AppBeacon.com

I am also getting this same error with MySQL 5.1.29-rc:

System: EL5 64bit

mysql> install plugin federated soname 'ha_federated.so'; ERROR 1126 (HY000): Can't open shared library '/usr/lib/mysql/plugin/ha_federated.so' (errno: 22 undefined symbol: dynstr_append_mem)

This looks to me that the latest 5.1.28 might've added changes to the server that cause this error. I'd have to compile this myself against the latest to see what the problem is. Thank you for letting me know about this, and sorry for your troubles.

At attempt at getting that directory listing to display more clearly:

[code] nettest1:/usr/local/mysql_mysql-5.1.28_rc/lib/mysql/plugin $ ls -l total 3432 -rw-r--r-- 1 root mysql 33386 Oct 7 15:40 ha_blackhole.a -rwxr-xr-x 1 root mysql 917 Oct 7 15:40 ha_blackhole.la lrwxrwxrwx 1 root mysql 21 Oct 7 15:40 ha_blackhole.so -> ha_blackhole.so.0.0.0 lrwxrwxrwx 1 root mysql 21 Oct 7 15:40 ha_blackhole.so.0 -> ha_blackhole.so.0.0.0 -rwxr-xr-x 1 root mysql 30474 Oct 7 15:40 ha_blackhole.so.0.0.0 -rw-r--r-- 1 root mysql 33410 Oct 7 15:40 ha_example.a -rwxr-xr-x 1 root mysql 903 Oct 7 15:40 ha_example.la lrwxrwxrwx 1 root mysql 19 Oct 7 15:40 ha_example.so -> ha_example.so.0.0.0 lrwxrwxrwx 1 root mysql 19 Oct 7 15:40 ha_example.so.0 -> ha_example.so.0.0.0 -rwxr-xr-x 1 root mysql 30827 Oct 7 15:40 ha_example.so.0.0.0 -rw-r--r-- 1 root mysql 1472220 Oct 7 15:40 ha_innodb.a -rwxr-xr-x 1 root mysql 896 Oct 7 15:40 ha_innodb.la lrwxrwxrwx 1 root mysql 18 Oct 7 15:40 ha_innodb.so -> ha_innodb.so.0.0.0 lrwxrwxrwx 1 root mysql 18 Oct 7 15:40 ha_innodb.so.0 -> ha_innodb.so.0.0.0 -rwxr-xr-x 1 root mysql 1184770 Oct 7 15:40 ha_innodb.so.0.0.0 -rw-r--r-- 1 root mysql 3500 Oct 7 15:40 libdaemon_example.a -rwxr-xr-x 1 root mysql 952 Oct 7 15:40 libdaemon_example.la lrwxrwxrwx 1 root mysql 26 Oct 7 15:40 libdaemon_example.so -> libdaemon_example.so.0.0.0 lrwxrwxrwx 1 root mysql 26 Oct 7 15:40 libdaemon_example.so.0 -> libdaemon_example.so.0.0.0 -rwxr-xr-x 1 root mysql 8310 Oct 7 15:40 libdaemon_example.so.0.0.0 -rw-r--r-- 1 root mysql 363598 Oct 7 16:12 libfederatedx_engine.a -rwxr-xr-x 1 root mysql 919 Oct 7 16:12 libfederatedx_engine.la lrwxrwxrwx 1 root mysql 29 Oct 7 16:12 libfederatedx_engine.so -> libfederatedx_engine.so.0.0.0 lrwxrwxrwx 1 root mysql 29 Oct 7 16:12 libfederatedx_engine.so.0 -> libfederatedx_engine.so.0.0.0 -rwxr-xr-x 1 root mysql 277296 Oct 7 16:12 libfederatedx_engine.so.0.0.0 -rw-r--r-- 1 root mysql 3510 Oct 7 15:40 mypluglib.a -rwxr-xr-x 1 root mysql 900 Oct 7 15:40 mypluglib.la lrwxrwxrwx 1 root mysql 18 Oct 7 15:40 mypluglib.so -> mypluglib.so.0.0.0 lrwxrwxrwx 1 root mysql 18 Oct 7 15:40 mypluglib.so.0 -> mypluglib.so.0.0.0 -rwxr-xr-x 1 root mysql 7049 Oct 7 15:40 mypluglib.so.0.0.0

[/code]

I'm hoping to get some help with installing this plugin. I've setup a new instance of MySQL 5.1.28 RC. I've compliled and installed the FederatedX plugin.

In MySQL, I issue this command: INSTALL PLUGIN federatedx SONAME 'libfederatedx_engine.so';

Unfortunately, I get this response: ERROR 1126 (HY000): Can't open shared library '/usr/local/mysql_mysql-5.1.28_rc/lib/mysql/plugin/libfederatedx_engine.so' (errno: 22 undefined symbol: dynstr_append_mem)

As best I can tell, compiling and installed Federatedx worked properly. Here is a listing of the files in my plugin directory: nettest1:/usr/local/mysql_mysql-5.1.28_rc/lib/mysql/plugin $ ls -l total 3432 -rw-r--r-- 1 root mysql 33386 Oct 7 15:40 ha_blackhole.a -rwxr-xr-x 1 root mysql 917 Oct 7 15:40 ha_blackhole.la lrwxrwxrwx 1 root mysql 21 Oct 7 15:40 ha_blackhole.so -> ha_blackhole.so.0.0.0 lrwxrwxrwx 1 root mysql 21 Oct 7 15:40 ha_blackhole.so.0 -> ha_blackhole.so.0.0.0 -rwxr-xr-x 1 root mysql 30474 Oct 7 15:40 ha_blackhole.so.0.0.0 -rw-r--r-- 1 root mysql 33410 Oct 7 15:40 ha_example.a -rwxr-xr-x 1 root mysql 903 Oct 7 15:40 ha_example.la lrwxrwxrwx 1 root mysql 19 Oct 7 15:40 ha_example.so -> ha_example.so.0.0.0 lrwxrwxrwx 1 root mysql 19 Oct 7 15:40 ha_example.so.0 -> ha_example.so.0.0.0 -rwxr-xr-x 1 root mysql 30827 Oct 7 15:40 ha_example.so.0.0.0 -rw-r--r-- 1 root mysql 1472220 Oct 7 15:40 ha_innodb.a -rwxr-xr-x 1 root mysql 896 Oct 7 15:40 ha_innodb.la lrwxrwxrwx 1 root mysql 18 Oct 7 15:40 ha_innodb.so -> ha_innodb.so.0.0.0 lrwxrwxrwx 1 root mysql 18 Oct 7 15:40 ha_innodb.so.0 -> ha_innodb.so.0.0.0 -rwxr-xr-x 1 root mysql 1184770 Oct 7 15:40 ha_innodb.so.0.0.0 -rw-r--r-- 1 root mysql 3500 Oct 7 15:40 libdaemon_example.a -rwxr-xr-x 1 root mysql 952 Oct 7 15:40 libdaemon_example.la lrwxrwxrwx 1 root mysql 26 Oct 7 15:40 libdaemon_example.so -> libdaemon_example.so.0.0.0 lrwxrwxrwx 1 root mysql 26 Oct 7 15:40 libdaemon_example.so.0 -> libdaemon_example.so.0.0.0 -rwxr-xr-x 1 root mysql 8310 Oct 7 15:40 libdaemon_example.so.0.0.0 -rw-r--r-- 1 root mysql 363598 Oct 7 16:12 libfederatedx_engine.a -rwxr-xr-x 1 root mysql 919 Oct 7 16:12 libfederatedx_engine.la lrwxrwxrwx 1 root mysql 29 Oct 7 16:12 libfederatedx_engine.so -> libfederatedx_engine.so.0.0.0 lrwxrwxrwx 1 root mysql 29 Oct 7 16:12 libfederatedx_engine.so.0 -> libfederatedx_engine.so.0.0.0 -rwxr-xr-x 1 root mysql 277296 Oct 7 16:12 libfederatedx_engine.so.0.0.0 -rw-r--r-- 1 root mysql 3510 Oct 7 15:40 mypluglib.a -rwxr-xr-x 1 root mysql 900 Oct 7 15:40 mypluglib.la lrwxrwxrwx 1 root mysql 18 Oct 7 15:40 mypluglib.so -> mypluglib.so.0.0.0 lrwxrwxrwx 1 root mysql 18 Oct 7 15:40 mypluglib.so.0 -> mypluglib.so.0.0.0 -rwxr-xr-x 1 root mysql 7049 Oct 7 15:40 mypluglib.so.0.0.0

Any help would be greatly appreciated.