WordPress.org

Ready to get started?Download WordPress

Forums

Error during MySQL Plugin Install (22 posts)

  1. DeeJay176
    Member
    Posted 2 years 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.

  2. RichardWPG
    Member
    Posted 2 years ago #

    What version is your WordPress and also what version is your mysql?

  3. DeeJay176
    Member
    Posted 2 years 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

  4. DeeJay176
    Member
    Posted 2 years 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

  5. DeeJay176
    Member
    Posted 2 years 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?

  6. Artem Livshits
    Member
    Posted 2 years 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

  7. Artem Livshits
    Member
    Posted 2 years 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:

    1. Used Amazon Linux AMI.
    2. 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
    3. Followed the instructions in the INSTALL-BINARY file
    4. tar xzf mysql-5.5.20-linux2.6-x86_64.tar.gz
    5. sudo mv mysql-5.5.20-linux2.6-x86_64 /usr/local/
    6. cd /usr/local/
    7. sudo chown -R mysql:mysql mysql-5.5.20-linux2.6-x86_64
    8. sudo ln -s mysql-5.5.20-linux2.6-x86_64 mysql
    9. sudo mysql/scripts/mysql_install_db --user=mysql
    10. sudo cp clouse-1.0b.1.1-linux-x64/ha_clouse-5.5.20.so /usr/local/mysql/lib/plugin/
    11. sudo cp clouse-1.0b.1.1-linux-x64/clouse.so /usr/local/mysql/lib/plugin/
    12. sudo chown mysql:mysql /usr/local/mysql/lib/plugin/*
    13. Configured ClouSE variables in /etc/my.cnf
    14. Started mysqld
    15. mysql -u root
    16. mysql> install 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

  8. DeeJay176
    Member
    Posted 2 years 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

  9. Artem Livshits
    Member
    Posted 2 years 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

  10. DeeJay176
    Member
    Posted 2 years 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.

  11. Artem Livshits
    Member
    Posted 2 years 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

  12. gurumark
    Member
    Posted 2 years 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

  13. DeeJay176
    Member
    Posted 2 years 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.

  14. DeeJay176
    Member
    Posted 2 years 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

  15. gurumark
    Member
    Posted 2 years ago #

    Thanks DeeJay176, I will give it a go and see.

  16. ds123
    Member
    Posted 1 year 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)

  17. Artem Livshits
    Member
    Posted 1 year ago #

    Please see my reply to this post in the other forum.

  18. ds123
    Member
    Posted 1 year 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?

  19. madra
    Member
    Posted 1 year 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.

  20. Artem Livshits
    Member
    Posted 1 year 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.

  21. albert.dvlp
    Member
    Posted 1 year 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?

  22. Artem Livshits
    Member
    Posted 1 year 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.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags