Posted 1 year ago #
ERROR 1126 (HY000): Can't open shared library '/usr/lib64/mysql/plugin/ha-clouse-5.5.20.so' (errno: 13 cannot open shared object file: No such file or directory)
Get this error when trying to install the MySql plugin. Not working on my ec2 config using the standard linux x64 ami.
Posted 1 year ago #
What version is your WordPress and also what version is your mysql?
Posted 1 year ago #
Good morning. We're running WP 3.3.2 and mysql version is 5.5.20 according to the mysql interface when asked.
Any help is greatly appreciated as this plugin will be the final touches on our migration to EC2. Thanks in advance
Posted 1 year ago #
mysql> install plugin clouse soname 'ha_clouse-5.5.20.so';
ERROR 1126 (HY000): Can't open shared library '/usr/lib64/mysql/plugin/ha_clouse-5.5.20.so' (errno: 13 undefined symbol: my_pthread_fastmutex_init)
This is a more detailed error message (the original got cut off)
I was thinking of trying an earlier version of the x64 linux binary
Posted 1 year ago #
I tried the 1.0b.1.0 version as well, same error, my_pthread_fast_mutex_init error when trying to install the plugin for MySQL.
Oblaksoft offers an ami binary with ClouSE already installed, but how could I know that configuration? In other words, when I build a server instance, I know everything I've loaded and every tweak I've made. How can I ensure that the ami from this group is in the proper condition for a production site? Does the fact that amazon stores the ami lend credibility to it?
Posted 1 year ago #
Hi DeeJay176,
Let me try to reproduce the problem and I'll get back to you.
The AMI is built by OblakSoft and is just the standard Amazon Linux AMI with MySQL 5.5.19 (and ClouSE) installed.
Artem
Posted 1 year ago #
I tried MySQL 5.5.20 x64 with ClouSE 1.0b.1.1 and was able to run it. Here are the steps that I did:
wget http://downloads.mysql.com/archives/mysql-5.5/mysql-5.5.20-linux2.6-x86_64.tar.gztar xzf mysql-5.5.20-linux2.6-x86_64.tar.gzsudo mv mysql-5.5.20-linux2.6-x86_64 /usr/local/cd /usr/local/sudo chown -R mysql:mysql mysql-5.5.20-linux2.6-x86_64sudo ln -s mysql-5.5.20-linux2.6-x86_64 mysqlsudo mysql/scripts/mysql_install_db --user=mysqlsudo cp clouse-1.0b.1.1-linux-x64/ha_clouse-5.5.20.so /usr/local/mysql/lib/plugin/sudo cp clouse-1.0b.1.1-linux-x64/clouse.so /usr/local/mysql/lib/plugin/sudo chown mysql:mysql /usr/local/mysql/lib/plugin/*mysql -u rootinstall plugin clouse soname 'ha_clouse-5.5.20.so';It installed successfully.
It looks like the MySQL binaries that you use were compiled with MY_PTHREAD_FASTMUTEX undefined, which doesn't match the 'official' build (the ones that are available from mysql.com).
Let me know if this doesn't resolve your issues.
Artem
Posted 1 year ago #
Thank you Artem I will have a chance to try this over the weekend. I believe I used the standard yum install packages. Very much appreciated that you spent the time to do this. +1
Posted 1 year ago #
You're welcome. Let me know if you have any problems with it and we'll figure out a way to make it work :-)
Artem
Posted 1 year ago #
mysql> install plugin clouse soname 'ha_clouse-5.5.20.so';
ERROR 1126 (HY000): Can't open shared library '/usr/lib64/mysql/plugin/ha_clouse-5.5.20.so' (errno: 2 undefined symbol: my_pthread_fastmutex_init)
Still get this after following your instructions to the letter except for 1 step. Step #9 required I cd into the mysql directory and execute the command from there (omitting the mysql/)
All steps worked up until the plugin install.
Posted 1 year ago #
Interesting.
Can you give me SSH access to the box to snoop around? Let's take it offline, send me an email to [ email redacted ].
Artem
Posted 10 months ago #
install plugin clouse soname 'ha_clouse-5.5.24.so';
ERROR 1126 (HY000): Can't open shared library '/usr/lib/mysql/plugin/ha_clouse-5.5.24.so' (errno: 2 /usr/lib/mysql/plugin/ha_clouse-5.5.24.so: undefined symbol: my_pthread_fastmutex_init)
I get the same error message. I use UBUNTU 12.04 LTS 32 bit and I use clouse-1.0b.1.2-linux-x86 version of the plugin.
mysql> SELECT version();
+-------------------------+
| version() |
+-------------------------+
| 5.5.24-0ubuntu0.12.04.1 |
Thanks,
Mark
Posted 10 months ago #
Hi Gurumark
The problem is the base AMI's from AWS don't have the correct base compile to work with ClouSE. You need to pull down the original MySQL libraries and compile them locally. Then the .so files recognize the fastmutex symbol.
I'm not using ubuntu, but similar to:
Got MySQL 5.5.20 tar from mysql.com:
wget http://downloads.mysql.com/archives/mysql-5.5/mysql-5.5.20-linux2.6-x86_64.tar.gz
Followed the instructions in the INSTALL-BINARY file:
tar xzf mysql-5.5.20-linux2.6-x86_64.tar.gz
sudo mv mysql-5.5.20-linux2.6-x86_64 /usr/local/
cd /usr/local/
sudo chown -R mysql:mysql mysql-5.5.20-linux2.6-x86_64
sudo ln -s mysql-5.5.20-linux2.6-x86_64 mysql
sudo mysql/scripts/mysql_install_db --user=mysql
If you do this procedure, make sure you're then running the correct MySQL and are using the correct plugin directory. It will most likely change.
Let me know if this helps, the rest of the config should be more or less same as before.
Posted 10 months ago #
Gurumark, you may not be able to run the last step (install) from the directory indicated... I recall now I had to run the install from inside the mysql/scripts directory
Posted 10 months ago #
Thanks DeeJay176, I will give it a go and see.
Posted 7 months ago #
i have this same error and i have spent a ton of time compiling and installing mysql 5.5.24 ...32 bit ....
i am getting these errors on the last step Artem can you please help? would i make a difference if i installed 5.5.20 instead of 5.5.24 ?
mysql> install plugin clouse soname 'ha_clouse-5.5.24.so';
ERROR 1126 (HY000): Can't open shared library '/usr/local/mysql5/lib/plugin/ha_clouse-5.5.24.so' (errno: 13 /usr/local/mysql5/lib/
plugin/ha_clouse-5.5.24.so: undefined symbol: my_pthread_fastmutex_init)
Posted 7 months ago #
Please see my reply to this post in the other forum.
Posted 7 months ago #
amazing i've been going at this for the last 3 days and finally got it thanks to you telling me about the compiling flag ..can you please include this information in your directions to install?
Posted 4 months ago #
Does the plugin really need to use fast mutex?
It's not included in the Debian installs of mySQL and, according to mySQL themselves, is about to be deprecated:
'fast' mutex implementation has several shortcomings and provides no measurable performance benefit. Since nowadays most platforms offer support for adaptive locks, MySQL's 'fast' mutex is going to be removed in MySQL 6.0.
I don't really want to be having to take my server offline and go through the hassles of recompiling a custom install of mySQL [no doubt breaking other stuff in the process], just to be able to use a WP plugin.
Posted 4 months ago #
Hi Madra,
You don't need to build your own MySQL to work with ClouSE: just download an official build from http://www.mysql.com and it will work with ClouSE.
Does the plugin really need to use fast mutex?
The plugin does not use fast mutex at all, but it must be compiled with the same flags as the MySQL binaries. The official MySQL builds that are distributed by Oracle do get compiled with the fast mutex and so does ha_clouse*.so.
Please post further questions to this forum.
Posted 3 months ago #
Hi, I followed the instruction to install MySQL from http://www.mysql.com, however at step 15, when I log into mysql, it shows the old version of MySQL installed earlier. How do I change it to the new version?
Posted 2 months ago #
Hi Albert,
It's possible that your MySQL server startup scripts still point to the old installation. The exact steps for deploying startup scripts varies for different Linux distros, however most should work if you copy mysql.server from support-files to /etc/init.d/ and make links to it in /etc/rcN.d/ dirs. For RedHat-based systems, you can use chkconfig --add mysql.server to automatically make links in /etc/rcN.d/ dirs; for Debian-based systems you can use update-rc.d mysql.server defaults for that purpose.
This topic has been closed to new replies.
