LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 01-07-2010, 01:13 AM   #1
prak86
LQ Newbie
 
Registered: Dec 2009
Posts: 21

Rep: Reputation: 15
How to remove installed plugin


Hi
Currently i am working in nagios and i have installed check_mysql_health plugin in the nagios monitoring server and after installing this plugin, i removed the MySQL in my system and installed another version of MySQL and now also my plugin is showing the error as

[root@wipro libexec]# ./check_mysql_health --hostname wipro --username root --password root123 --mode connection-time

CRITICAL - cannot connect to information_schema. install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: . /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.7/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl/5.8.7 /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8) at (eval 13) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, Sponge.
at ./check_mysql_health line 1506

I have MySQL 5.0.8 in my machine. Can anyone explain me whats going wrong for me or can anyone let me know how to remove the installed plugin.

Last edited by prak86; 01-07-2010 at 01:17 AM.
 
Old 01-07-2010, 02:00 AM   #2
rajnikant.sharma
LQ Newbie
 
Registered: May 2008
Location: Ahmedabad, India
Posts: 2

Rep: Reputation: 0
Are you able to install this plugin again? if yes then , please install it, other wise you have to do some changes in its configuration file
 
Old 01-07-2010, 02:58 AM   #3
Lee_Ball
Member
 
Registered: Jul 2005
Location: Manchester (UK)
Distribution: Fedora CentOS
Posts: 132

Rep: Reputation: 18
You mentioned you installed another verison of MySQL. Have you changed the password to match the one in you check_mysql_health?
 
Old 01-11-2010, 04:17 AM   #4
centosboy
Senior Member
 
Registered: May 2009
Location: london
Distribution: centos5
Posts: 1,137

Rep: Reputation: 116Reputation: 116
Quote:
Originally Posted by prak86 View Post
Hi
Currently i am working in nagios and i have installed check_mysql_health plugin in the nagios monitoring server and after installing this plugin, i removed the MySQL in my system and installed another version of MySQL and now also my plugin is showing the error as

[root@wipro libexec]# ./check_mysql_health --hostname wipro --username root --password root123 --mode connection-time

CRITICAL - cannot connect to information_schema. install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: . /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.7/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl/5.8.7 /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8) at (eval 13) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, Sponge.
at ./check_mysql_health line 1506

I have MySQL 5.0.8 in my machine. Can anyone explain me whats going wrong for me or can anyone let me know how to remove the installed plugin.


You might have to do a small bit of work to get this working.


I also done a reinstall of mysql and it installed in a different location and now DBD::mysql will not work because it cant find /usr/local/mysql/lib/libmysqlclient.so.

So you will probably need to sym link the old location to the new or rebuild the DBD::mysql perl module.
 
Old 01-20-2010, 04:44 AM   #5
prak86
LQ Newbie
 
Registered: Dec 2009
Posts: 21

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by Lee_Ball View Post
You mentioned you installed another verison of MySQL. Have you changed the password to match the one in you check_mysql_health?
After installing another version of mysql only i installed nagios itself.

still if i want to match the password means, can u explain how to do it.
 
Old 01-20-2010, 04:46 AM   #6
prak86
LQ Newbie
 
Registered: Dec 2009
Posts: 21

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by centosboy View Post
You might have to do a small bit of work to get this working.


I also done a reinstall of mysql and it installed in a different location and now DBD::mysql will not work because it cant find /usr/local/mysql/lib/libmysqlclient.so.

So you will probably need to sym link the old location to the new or rebuild the DBD::mysql perl module.

Can u pls explain me in detail how to do this sym link as i was new to linux.
 
Old 01-20-2010, 05:08 AM   #7
centosboy
Senior Member
 
Registered: May 2009
Location: london
Distribution: centos5
Posts: 1,137

Rep: Reputation: 116Reputation: 116
Quote:
Originally Posted by prak86 View Post
Can u pls explain me in detail how to do this sym link as i was new to linux.

can you reinstall DBD::mysql perl module?

Code:
yum install perl-DBD-MySQL
 
Old 01-20-2010, 05:13 AM   #8
prak86
LQ Newbie
 
Registered: Dec 2009
Posts: 21

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by centosboy View Post
can you reinstall DBD::mysql perl module?

Code:
yum install perl-DBD-MySQL
In my vm yum commands wont work as there is no network connectivity, it shows the error

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Could not retrieve mirrorlist http://mirrorlist.centos.org/?releas...h=i386&repo=os error was
[Errno 4] IOError: <urlopen error (-3, 'Temporary failure in name resolution')>
Error: Cannot find a valid baseurl for repo: base


can to tell me the link so that i can get it download from my workstation and try to install it?
 
Old 01-20-2010, 05:19 AM   #9
prak86
LQ Newbie
 
Registered: Dec 2009
Posts: 21

Original Poster
Rep: Reputation: 15
Hi,
I got the rpm files for this. Should i make any configuration change while installing this rpm file?
 
Old 01-21-2010, 04:14 AM   #10
centosboy
Senior Member
 
Registered: May 2009
Location: london
Distribution: centos5
Posts: 1,137

Rep: Reputation: 116Reputation: 116
Quote:
Originally Posted by prak86 View Post
Hi,
I got the rpm files for this. Should i make any configuration change while installing this rpm file?
No.
Just installing it should be ok....
But read below also as there are options.

Your old mysql installation has the libmysqlclient.so module installed in the lib directory.
Your new installation does too but it is in a different location.
The perl DBD::mysql installation when installed from source or cpan looks for this module at /usr/local/mysql/lib/libmysqlclient.so.
YOu didnt really say how you installed the newest version of mysql, but at a guess i would say if you searched for the libmysqlclient.so within that installation, it would be in a different location. Maybe something like /usr/local/mysql-5.1.39-linux-x86_64-glibc23/lib/libmysqlclient.so.
So there are a number of solutions to this. One is to symlink the new installation directory to a name like mysql.


Firstly, check the location of the old installation if it still exists.

Secondly , change into the directory of the new installation.

Code:
[root@xxxx ~]# ls -la | grep mysql*
drwxr-xr-x  2 root root       4096 Jan 21 09:07 mysql-1234
do this


Code:
ln -s mysql-1234 mysql
and then check


Code:
root@xxxx testmysql]# ls -la
total 16
drwxr-xr-x  3 root root 4096 Jan 21 09:09 .
drwxr-x--- 41 root root 4096 Jan 21 09:08 ..
lrwxrwxrwx  1 root root   10 Jan 21 09:09 mysql -> mysql-1234
drwxr-xr-x  2 root root 4096 Jan 21 09:09 mysql-1234
then just make sure you can cd mysql/lib/ and in here you should see the libmysqlclient.so.

if you cant, then create a symlink so that it links to whereever it is.

Find mysqlclient.so using locate if need be.
 
Old 01-21-2010, 05:17 AM   #11
prak86
LQ Newbie
 
Registered: Dec 2009
Posts: 21

Original Poster
Rep: Reputation: 15
Hi,
I installed MySQL-client-community-5.0.87-0.rhel5.i386.rpm and MySQL-server-community-5.0.87-0.rhel5.i386.rpm and
after that i am able to access the Mysql

When i tried to install perl-DBD-MySQL-3.0007-2.el5.i386.rpm file, it shows the failed dependency error for libmysqlclient.so .
and also there is no directory in my vm named as mysql in /usr/local/

If i search for libmysqlclient.so but the response for that file is zero.i downloaded the rpm file for libmysqlclient.so and tried
to install perl-DBD-MySQL then this shows lot of failed dependency error.


i tried the code

[root@localhost ~]# ls -la | grep mysql*
-rw------- 1 root root 839 Jan 21 15:03 .mysql_history


is this is the right thing to come?

then also i followed

[root@localhost ~]# ln -s mysql_history mysql

[root@localhost ~]# ls -la
total 307632

rwxrwxrwx 1 root root 13 Jan 21 15:25 mysql -> mysql_history
-rw------- 1 root root 839 Jan 21 15:03 .mysql_history


Let me know where i goes wrong.

Last edited by prak86; 01-21-2010 at 05:19 AM.
 
Old 01-21-2010, 05:41 AM   #12
centosboy
Senior Member
 
Registered: May 2009
Location: london
Distribution: centos5
Posts: 1,137

Rep: Reputation: 116Reputation: 116
Quote:
Originally Posted by prak86 View Post
Hi,
I installed MySQL-client-community-5.0.87-0.rhel5.i386.rpm and MySQL-server-community-5.0.87-0.rhel5.i386.rpm and
after that i am able to access the Mysql

When i tried to install perl-DBD-MySQL-3.0007-2.el5.i386.rpm file, it shows the failed dependency error for libmysqlclient.so .
and also there is no directory in my vm named as mysql in /usr/local/

If i search for libmysqlclient.so but the response for that file is zero.i downloaded the rpm file for libmysqlclient.so and tried
to install perl-DBD-MySQL then this shows lot of failed dependency error.


i tried the code

[root@localhost ~]# ls -la | grep mysql*
-rw------- 1 root root 839 Jan 21 15:03 .mysql_history


is this is the right thing to come?

then also i followed

[root@localhost ~]# ln -s mysql_history mysql

[root@localhost ~]# ls -la
total 307632

rwxrwxrwx 1 root root 13 Jan 21 15:25 mysql -> mysql_history
-rw------- 1 root root 839 Jan 21 15:03 .mysql_history


Let me know where i goes wrong.

Oh goodness. Remove that link.
My fault..i have explained this badly.

run rm -rf mysql in the directory you created the symlink.

you shouldnt be using rpm to install the DBD-mysql perl module.
Use yum instead. The rpm you are trying to install is pretty old. Any reason you are installing that one??

perl-DBD-mysql-4.013-1.el5.rf --> is the version yum would install.

if you are still having issues, give me your msn or yahoo id and i will talk to you in realtime.
i fear you arent understanding what im saying on here....
 
Old 01-25-2010, 12:55 AM   #13
prak86
LQ Newbie
 
Registered: Dec 2009
Posts: 21

Original Poster
Rep: Reputation: 15
Hi

Thank you for your guidace still now i resolved this problem when i tried with anoter vm in this i installed the same
version that comes along with the centos package which is working fine for me and now i am able to monitor mysql using nagios.

meanwhile i learned something on working with centos with u.

keep the good work going on.
 
Old 01-25-2010, 10:35 AM   #14
centosboy
Senior Member
 
Registered: May 2009
Location: london
Distribution: centos5
Posts: 1,137

Rep: Reputation: 116Reputation: 116
Quote:
Originally Posted by prak86 View Post
Hi

Thank you for your guidace still now i resolved this problem when i tried with anoter vm in this i installed the same
version that comes along with the centos package which is working fine for me and now i am able to monitor mysql using nagios.

meanwhile i learned something on working with centos with u.

keep the good work going on.
thats great if you learnt something. exactly what this forum is for.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Easy debian way to remove the totem plugin player? frenchn00b Debian 5 08-05-2009 05:03 PM
Flash plugin for MozFirefox says it's installed but isn't! ChrisScott Linux - Software 3 11-19-2006 09:49 AM
Remove Mozilla plugin request? Vgui Linux - Software 1 12-14-2005 08:53 PM
XMMS not playing even if plugin is installed juan18 Linux - Software 17 06-16-2004 07:55 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 04:29 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration