store | blogs | forums | twitter | facebook | wiki | downloads | support portal
Atomic Secure Linux
It is currently Sat Aug 30, 2014 10:21 am

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 26 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: relocation error: /usr/lib64/libmyodbc5.so
Unread postPosted: Mon Oct 24, 2011 8:36 am 
Offline
Long Time Forum Regular
Long Time Forum Regular

Joined: Sat Aug 20, 2005 9:30 am
Posts: 2812
Location: The Netherlands
On a server running CentOS 6.0 x86_64, Plesk 10.3.1 and the MySQL 5.1.59-1 packages from the atomic channel I get '500 - Internal Server Error' when trying to access the Application Vault page under Tools & Utilities in Plesk.

In /var/log/sw-cp-server/error_log I find:

Quote:
relocation error: /usr/lib64/libmyodbc5.so: symbol strmov, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference


I found http://serverfault.com/questions/318246 ... nt-r-so-16 about this exact error message which suggests dumping all databases and installing the vendor's MySQL packages.

Apparently the /usr/lib64/libmyodbc5.so file is part of the mysql-connector-odbc package:

Code:
# rpm -qf /usr/lib64/libmyodbc5.so
mysql-connector-odbc-5.1.5r1144-7.el6.x86_64


What do you make of this?

_________________
Lemonbit Internet Dedicated Server Management


Top
 Profile  
 
 Post subject: Re: relocation error: /usr/lib64/libmyodbc5.so
Unread postPosted: Tue Oct 25, 2011 7:02 pm 
Online
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 7889
Location: earth
It seems like maybe the odbc library is using a very specific mysql 5.1 api. The good news is that now that 5.1 is in "client" mode making a client library only package to support it isnt a big deal.

The first part is to determine what version it really needs. So the first thing to do is get your hands on older version(s) of the mysql client packages by grabbing the MySQL-shared-community-5.1.X packages from here:

ftp://mirror.anl.gov/pub/mysql/Downloads/MySQL-5.1/

If I had to guess, its probably looking for 5.1.52.

UPDATE:
So my testing here was purely against Mysql 5.5.17, this will install the compat package mysqlclient16-5.1.59-1.el6.art.x86_64. With that version I do not have this same 500 error. Option 2, --force install that package and see what you get.


Top
 Profile  
 
 Post subject: Re: relocation error: /usr/lib64/libmyodbc5.so
Unread postPosted: Wed Nov 02, 2011 7:15 pm 
Offline
Long Time Forum Regular
Long Time Forum Regular

Joined: Sat Aug 20, 2005 9:30 am
Posts: 2812
Location: The Netherlands
I reverted MySQL to the CentOS packages (5.1.52) and the Application Vault page is working again.

_________________
Lemonbit Internet Dedicated Server Management


Top
 Profile  
 
 Post subject: Re: relocation error: /usr/lib64/libmyodbc5.so
Unread postPosted: Mon Feb 06, 2012 8:34 pm 
Offline
New Forum User
New Forum User

Joined: Mon Feb 06, 2012 8:29 pm
Posts: 4
Location: london
hi,

i tried install mysqlclient16-5.1.59-1.el6.art.x86_64. from the atomic repo but no avail i still receive the near total failure of plesk


and it seems i am not awesome enough to be able to downgrade mysql to a version that plesk will accept,

any chance i could get some way i could like manually replace the files maybe? or another kind of fix?


Top
 Profile  
 
 Post subject: Re: relocation error: /usr/lib64/libmyodbc5.so
Unread postPosted: Tue Feb 07, 2012 9:52 am 
Offline
Forum Regular
Forum Regular

Joined: Mon Apr 10, 2006 12:55 pm
Posts: 672
Try replacing php-mysql with php-mysqlnd (which doesn't require mysqlclient). You do have to remove php-mysql first, tho.

_________________
"Its not a mac. I run linux... I'm actually cool." - scott


Top
 Profile  
 
 Post subject: Re: relocation error: /usr/lib64/libmyodbc5.so
Unread postPosted: Tue Feb 07, 2012 7:32 pm 
Offline
New Forum User
New Forum User

Joined: Mon Feb 06, 2012 8:29 pm
Posts: 4
Location: london
Highland wrote:
Try replacing php-mysql with php-mysqlnd (which doesn't require mysqlclient). You do have to remove php-mysql first, tho.


Looks like thats the way i'm gonna have to go. though wouldn't this perhaps cause issues with plesk?

as when i do yum remove php-mysql it offers to remove plesk and i'm really trying to avoid that as i've had obnoxious amounts of trouble in reinstalling plesk.


i know i being difficult and will resort to shooting plesk in the face if i can't find a way around but well i'd rather not shoot it in the face unless i'm sure it's on it's last legs


Top
 Profile  
 
 Post subject: Re: relocation error: /usr/lib64/libmyodbc5.so
Unread postPosted: Tue Feb 07, 2012 10:12 pm 
Offline
New Forum User
New Forum User

Joined: Mon Feb 06, 2012 8:29 pm
Posts: 4
Location: london
thanks, for your help i found an alternate way around,


also whats causing this is the APS Catalog it REQUIRES the myodbc5 in such a specific way that it would make mass genocide seem reasonable.

if there is a way to kill aps do it it hates you it hates you in ways you can't even fathom.


i followed this chap

Code:
http://serverfault.com/questions/318246/plesk-libmysqlclient-16-not-defined-in-file-libmysqlclient-r-so-16


but you must also remember to not update mysql using the atomic repo until plesk changes aps_catalog to be reasonable


Top
 Profile  
 
 Post subject: Re: relocation error: /usr/lib64/libmyodbc5.so
Unread postPosted: Wed Feb 08, 2012 9:22 am 
Online
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 7889
Location: earth
Which version of mysqlclient16 were you using? mysqlclient16-5.1.59-2 is the latest


Top
 Profile  
 
 Post subject: Re: relocation error: /usr/lib64/libmyodbc5.so
Unread postPosted: Wed Feb 08, 2012 10:32 am 
Offline
New Forum User
New Forum User

Joined: Mon Feb 06, 2012 8:29 pm
Posts: 4
Location: london
scott wrote:
Which version of mysqlclient16 were you using? mysqlclient16-5.1.59-2 is the latest



That looks like the version that installed not sure if it had -2 but was 5.1.59. it outright refused to work even when i hit it with a stick.
it's fine i switched it back to the centos version and it seems happy enough


Top
 Profile  
 
 Post subject: Re: relocation error: /usr/lib64/libmyodbc5.so
Unread postPosted: Wed Feb 08, 2012 10:46 am 
Online
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 7889
Location: earth
I mention that because -2 had the strmov() patch in it. -1 did not. Never ignore the release field in an RPM, its just as important as the version field (moreso when you're dealing with backports)


Top
 Profile  
 
 Post subject: Re: relocation error: /usr/lib64/libmyodbc5.so
Unread postPosted: Wed Feb 08, 2012 10:57 am 
Offline
Forum Regular
Forum Regular

Joined: Mon Apr 10, 2006 12:55 pm
Posts: 672
cavecrashx wrote:
Highland wrote:
Try replacing php-mysql with php-mysqlnd (which doesn't require mysqlclient). You do have to remove php-mysql first, tho.


Looks like thats the way i'm gonna have to go. though wouldn't this perhaps cause issues with plesk?

as when i do yum remove php-mysql it offers to remove plesk and i'm really trying to avoid that as i've had obnoxious amounts of trouble in reinstalling plesk.


i know i being difficult and will resort to shooting plesk in the face if i can't find a way around but well i'd rather not shoot it in the face unless i'm sure it's on it's last legs

Breun posted a way around that in another thread
viewtopic.php?p=32711#p32711

_________________
"Its not a mac. I run linux... I'm actually cool." - scott


Top
 Profile  
 
 Post subject: Re: relocation error: /usr/lib64/libmyodbc5.so
Unread postPosted: Sun Feb 26, 2012 4:24 pm 
Offline
Long Time Forum Regular
Long Time Forum Regular

Joined: Thu Dec 09, 2004 11:19 am
Posts: 2047
scott wrote:
I mention that because -2 had the strmov() patch in it. -1 did not. Never ignore the release field in an RPM, its just as important as the version field (moreso when you're dealing with backports)


Well, I find myself facing this same problem, only at installation:
Clean Centos 6 install, then install ART MySQL 5.5 + PHP 5.3.9, then install Plesk 10.4 and ignore dire warnings about art repo being enabled, I get:

Code:
 Trying to set up APS controller database... Attempting to check APS db connection via ODBC, using /usr/bin/iusql (empty output is good)
/usr/bin/iusql: relocation error: /usr/lib64/libmyodbc5.so: symbol strmov, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference


So I remember this thread and come and take a look to see if it has the answer.

The problem appears to be that mysqlclient16-5.1.59-2 is not in the ART Centos6 (x86_64) repo. Only the -1 and that's what I have installed. I'm assuming this is what the problem is?

_________________
--------------------------------
<advert>
If you want to rent a UK-based VPS that comes with friendly advice and support from a fellow ART fan, please get in touch.
</advert>


Top
 Profile  
 
 Post subject: Re: relocation error: /usr/lib64/libmyodbc5.so
Unread postPosted: Sun Feb 26, 2012 6:49 pm 
Online
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 7889
Location: earth
a ha, good catch! I also noticed the 32-bit library wasnt set up to be duplicates in the 64-bit repo either. It should be going out to all the mirrors now


Top
 Profile  
 
 Post subject: Re: relocation error: /usr/lib64/libmyodbc5.so
Unread postPosted: Sun Feb 26, 2012 6:56 pm 
Offline
Long Time Forum Regular
Long Time Forum Regular

Joined: Thu Dec 09, 2004 11:19 am
Posts: 2047
Thanks Scott.

Once updated, I'll see what happens with upgrading to 5.5 from whatever Centos6 gave me by default, then I'll re-image and have another go starting from 5.5 tomorrow.

(basically I'm attempting to break as many things as possible by doing things in as many ways as possible, to find the least painful way of installing, upgrading and finally migrating).

_________________
--------------------------------
<advert>
If you want to rent a UK-based VPS that comes with friendly advice and support from a fellow ART fan, please get in touch.
</advert>


Top
 Profile  
 
 Post subject: Re: relocation error: /usr/lib64/libmyodbc5.so
Unread postPosted: Sun Apr 08, 2012 4:23 am 
Offline
Forum User
Forum User

Joined: Mon Jan 15, 2007 2:03 am
Posts: 40
Same thing happening to me on a fresh CentOS6 box... Stuck in a loop since I can't reinstall a mysql database that plesk will work with without killing the atomic repo and uninstalling art php and everything else. Anything I can do here? I'm left with a corrupted mysql database, missing the smb_users table and a not working plesk since it can't connect and finish the install properly. Any help appreciated.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 26 posts ]  Go to page 1, 2  Next

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group