[Maria-discuss] mariadb-mysql command-line problem on CentOS 5.5 i386
I saw a comment today from Eric Koh on the Knowledgebase article for the mysql Command-line Client: http://kb.askmonty.org/v/mysql-command-line-client --------------------------------------------------------------------- mariadb-mysql command-line problem on CentOS 5.5 i386 I tried these 2 RPMs MariaDB-client-5.1.42-68.el5.i386.rpm MariaDB-client-5.1.49-82.el5.i386.rpm I get this message when starting the mysql client mysql: symbol mysql_get_server_name, version libmysqlclient_16 not defined in file libmysqlclient.so.16 with link time reference running ldconfig/rebooting doesnt help. The RPMs for the server are fine though. I am thus using MariaDB-server and MariaDB-shared together with MySQL-client-community --------------------------------------------------------------------- Anyone know what might be going on here? Thanks. -- Daniel Bartholomew Monty Program - http://askmonty.org
Hi, Daniel! On Aug 23, Daniel Bartholomew wrote:
I saw a comment today from Eric Koh on the Knowledgebase article for the mysql Command-line Client: http://kb.askmonty.org/v/mysql-command-line-client
--------------------------------------------------------------------- mariadb-mysql command-line problem on CentOS 5.5 i386 I tried these 2 RPMs
MariaDB-client-5.1.42-68.el5.i386.rpm MariaDB-client-5.1.49-82.el5.i386.rpm
I get this message when starting the mysql client mysql: symbol mysql_get_server_name, version libmysqlclient_16 not defined in file libmysqlclient.so.16 with link time reference
running ldconfig/rebooting doesnt help.
The RPMs for the server are fine though. I am thus using MariaDB-server and MariaDB-shared together with MySQL-client-community ---------------------------------------------------------------------
Anyone know what might be going on here?
Eh. I'd reply that comments to mysql-command-line-client page on kb is not an appropriate place for comments like that. Anyway, quick grepping shows that mysql_get_server_name() is something present in the mariadb tree and not present in the mysql tree. So, obviously he is trying to use mysql command line client from mariadb with libmysqlclient.so from mysql. Why and how is a different question. May be some rpm is not installed, or wrong rpm is installed, or mysql's libmysqlclient.so is found before maria's libmysqlclient.so. It's for him to find out. Regards, Sergei
Hi, To figure out which library is being linked in dynamically (ie, the wrong one) use the 'ldd' tool. ldd $(which mysql) | grep mysql or ldd /path/to/the/binary | grep mysql for example: [justin.swanhart@mybox ~]$ ldd $(which mysql)|grep mysql libmysqlclient.so.15 => /usr/lib64/mysql/libmysqlclient.so.15 (0x00000035a7800000) --Justin On Mon, Aug 23, 2010 at 3:06 PM, Sergei Golubchik <serg@askmonty.org> wrote:
Hi, Daniel!
On Aug 23, Daniel Bartholomew wrote:
I saw a comment today from Eric Koh on the Knowledgebase article for the mysql Command-line Client: http://kb.askmonty.org/v/mysql-command-line-client
--------------------------------------------------------------------- mariadb-mysql command-line problem on CentOS 5.5 i386 I tried these 2 RPMs
MariaDB-client-5.1.42-68.el5.i386.rpm MariaDB-client-5.1.49-82.el5.i386.rpm
I get this message when starting the mysql client mysql: symbol mysql_get_server_name, version libmysqlclient_16 not defined in file libmysqlclient.so.16 with link time reference
running ldconfig/rebooting doesnt help.
The RPMs for the server are fine though. I am thus using MariaDB-server and MariaDB-shared together with MySQL-client-community ---------------------------------------------------------------------
Anyone know what might be going on here?
Eh. I'd reply that comments to mysql-command-line-client page on kb is not an appropriate place for comments like that.
Anyway, quick grepping shows that mysql_get_server_name() is something present in the mariadb tree and not present in the mysql tree. So, obviously he is trying to use mysql command line client from mariadb with libmysqlclient.so from mysql. Why and how is a different question. May be some rpm is not installed, or wrong rpm is installed, or mysql's libmysqlclient.so is found before maria's libmysqlclient.so. It's for him to find out.
Regards, Sergei
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
On Mon, 23 Aug 2010 15:17:15 -0700 Justin Swanhart <greenlion@gmail.com> wrote: Justin> Hi, Justin> Justin> To figure out which library is being linked in dynamically (ie, Justin> the wrong one) use the 'ldd' tool. Justin> Justin> ldd $(which mysql) | grep mysql Justin> or Justin> ldd /path/to/the/binary | grep mysql Justin> Justin> for example: Justin> [justin.swanhart@mybox ~]$ ldd $(which mysql)|grep mysql Justin> libmysqlclient.so.15 Justin> => /usr/lib64/mysql/libmysqlclient.so.15 (0x00000035a7800000) I'll incorporate this into response, since it's a good troubleshooting tip and I'm thinking this error will be encountered a lot (or at least more than once) as people transition from MySQL to MariaDB. My current plan is to create a troubleshooting article for the Knowledgebase and then link to it in a reply to the original comment on the mysql client page. Thanks! -- Daniel Bartholomew Monty Program - http://askmonty.org
On Mon, 23 Aug 2010 22:33:25 -0400 Daniel Bartholomew <dbart@askmonty.org> wrote: Daniel> My current plan is to create a troubleshooting article for the Daniel> Knowledgebase and then link to it in a reply to the original Daniel> comment on the mysql client page. Here's the article I created for the Knowledgebase: http://kb.askmonty.org/v/824 Thanks! -- Daniel Bartholomew Monty Program - http://askmonty.org
On Tue, 24 Aug 2010 00:06:35 +0200 Sergei Golubchik <serg@askmonty.org> wrote: Sergei> Hi, Daniel! Hello! Sergei> On Aug 23, Daniel Bartholomew wrote: Daniel> Daniel> I saw a comment today from Eric Koh on the Knowledgebase Daniel> article for the mysql Command-line Client: Daniel> http://kb.askmonty.org/v/mysql-command-line-client Daniel> Daniel> --------------------------------------------------------------------- Daniel> mariadb-mysql command-line problem on CentOS 5.5 i386 Daniel> I tried these 2 RPMs Daniel> Daniel> MariaDB-client-5.1.42-68.el5.i386.rpm Daniel> MariaDB-client-5.1.49-82.el5.i386.rpm Daniel> Daniel> I get this message when starting the mysql client mysql: Daniel> symbol mysql_get_server_name, version libmysqlclient_16 not Daniel> defined in file libmysqlclient.so.16 with link time reference Daniel> Daniel> running ldconfig/rebooting doesnt help. Daniel> Daniel> The RPMs for the server are fine though. I am thus using Daniel> MariaDB-server and MariaDB-shared together with Daniel> MySQL-client-community Daniel> --------------------------------------------------------------------- Daniel> Daniel> Anyone know what might be going on here? Sergei> Eh. I'd reply that comments to mysql-command-line-client page Sergei> on kb is not an appropriate place for comments like that. Yeah, I was planning on putting something along those lines into the reply. Sergei> Anyway, quick grepping shows that mysql_get_server_name() is Sergei> something present in the mariadb tree and not present in the Sergei> mysql tree. So, obviously he is trying to use mysql command Sergei> line client from mariadb with libmysqlclient.so from mysql. Why Sergei> and how is a different question. May be some rpm is not Sergei> installed, or wrong rpm is installed, or mysql's Sergei> libmysqlclient.so is found before maria's libmysqlclient.so. Sergei> It's for him to find out. Ok, I thought something like that might be going on, but you found some proof. :) Thanks! -- Daniel Bartholomew Monty Program - http://askmonty.org
On Tue, Aug 24, 2010 at 1:06 AM, Sergei Golubchik <serg@askmonty.org> wrote:
Eh. I'd reply that comments to mysql-command-line-client page on kb is not an appropriate place for comments like that.
Actually, if I understood Monty's vision correctly, that *is* a good place to ask questions. (There used to be a big "Ask a question here" link, where did that go?) What Daniel did with the question is how the process is supposed to work. Good writing btw, resulted in a nice and in depth article! henrik -- henrik.ingo@avoinelama.fi +358-40-5697354 www.openlife.cc
participants (4)
-
Daniel Bartholomew -
Henrik Ingo -
Justin Swanhart -
Sergei Golubchik