Archive for November, 2008

sudo yum install perl-DBD-mysql for { install_driver(mysql) failed: Can’t locate DBD/mysql.pm }

Posted in Linux, mysql, Technical with tags , , , , on November 25, 2008 by saffrongeek

mysqlreport makes a friendly report of important MySQL status values. mysqlreport transforms the values from SHOW STATUS into an easy-to-read report that provides an in-depth understanding of how well MySQL is running. mysqlreport is a better alternative (and practically the only alternative) to manually interpreting SHOW STATUS.

Also super-smack and other benchmark suites are a best idea but all gets you to a problem like “install_driver(mysql) failed: Can’t locate DBD/mysql.pm in @INC (@INC co” or something related to perl DBI.

Solutions is to try the below in your command prompt as super root.

[saffrongeek@nerd1 etc]$ cd /home/saffrongeek/Desktop/mysqlreport-3.5
[saffrongeek@nerd1 mysqlreport-3.5]$ ls
COPYING  mysqlreport  mysqlreportdoc.html  mysqlreportguide.html
[saffrongeek@nerd1 mysqlreport-3.5]$ ./mysqlreport -r 10 > report.txt
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 7) 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, Gofer, Pg, Proxy, Sponge.
at ./mysqlreport line 249
[saffrongeek@nerd1 mysqlreport-3.5]$ sudo yum update DBD
Password:
Setting up Update Process
Could not find update match for DBD
No Packages marked for Update
[saffrongeek@nerd1 mysqlreport-3.5]$ sudo yum install perl-DBD-mysql
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
–> Running transaction check
—> Package perl-DBD-MySQL.i386 0:4.005-2.fc8.1 set to be updated
–> Finished Dependency Resolution

Dependencies Resolved

=============================================================================
Package                 Arch       Version          Repository        Size
=============================================================================
Installing:
perl-DBD-MySQL          i386       4.005-2.fc8.1    fedora            143 k

Transaction Summary
=============================================================================
Install      1 Package(s)
Update       0 Package(s)
Remove       0 Package(s)

Total download size: 143 k
Is this ok [y/N]: y
Downloading Packages:
(1/1): perl-DBD-MySQL-4.0 100% |=========================| 143 kB    00:11
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing: perl-DBD-MySQL               ######################### [1/1]

Installed: perl-DBD-MySQL.i386 0:4.005-2.fc8.1
Complete!
[saffrongeek@nerd1 mysqlreport-3.5]$ ./mysqlreport -r 10 > report.txt
mysqlreport is writing relative reports to ‘/tmp/W8PwFrYYsU’.
[saffrongeek@nerd1 mysqlreport-3.5]$ sudo yum install perl-DBD-mysql perl-DBI
Setting up Install Process
Parsing package install arguments
Requested dep: perl-DBD-mysql is provided by installed package
Package perl-DBI – 1.58-2.fc8.i386 is already installed.
Nothing to do
[saffrongeek@nerd1 mysqlreport-3.5]$

sudo: /etc/sudoers is mode 0777, should be 0440

Posted in Linux, Technical with tags , , on November 24, 2008 by saffrongeek

OS : Linux Flavor : Fedora 8

I dont know how this error came but got something to do with myself trying to get a root view yesterday evening , half sleepy. The below would solve the trouble:-

[saffrongeek@nerd1 ~]$ sudo chmod 0644 /home/saffrongeek /.dmrc
sudo: /etc/sudoers is mode 0777, should be 0440
[saffrongeek@nerd1 ~]$ cd /etc/
[saffrongeek@nerd1 etc]$ su root
Password:
[root@nerd1 etc]# chmod 440 sudoers
[root@nerd1 etc]# ls -l sudoers
-r–r—– 1 root root 3211 2008-04-29 17:18 sudoers

public key import

Posted in Linux, Technical with tags , on November 19, 2008 by saffrongeek

RPM files available are signed with a private key, as part of checking its genuines. Like in RSA algorithm, you need to use public key to check the package genuines. For this case, when you try Software installer, it sometimes fails for package doesnt pass the genuine test. How to move ahead, import the public key.

Usually, find for the public key , as came with your linux distro and import it. ( => find / -name “*GPG*” and then import with rpm –import *GPG* )

Note: hope you got a copy of the distr cd’s with you. 🙂

FYI: http://en.wikipedia.org/wiki/Public-key_cryptography

Installing MYSQL in Fedora 9

Posted in Linux, mysql, Technical with tags , , , , on November 19, 2008 by saffrongeek

Scenario: ( MYSQL CRASHED , for me , amidst 5GB data import as I got a power failure in between and UPS going off in 20 minutes.)
Prevention: Getting the CPU battery extra backup till it writes the last of the query to filesystem.

Download the mysql recent version from mysql website at http://dev.mysql.com/downloads/mysql/
Best is to download the below:
MySQL-client-community-5.0.67-0.rhel5.i386.rpm
MySQL-server-community-5.0.67-0.rhel5.i386.rpm
MySQL-shared-compat-5.0.67-0.rhel5.i386.rpm
MySQL-devel-community-5.0.67-0.rhel5.i386.rpm
MySQL-shared-community-5.0.67-0.rhel5.i386.rpm

Now let us see what all we got in our box:
[root@nerd1 /]# rpm -qa | grep -i mysql

MySQL-server-standard-4.1.22-0.rhel4
mysql-administrator-5.0r12-1fc5
MySQL-devel-standard-4.1.22-0.rhel4
MySQL-client-standard-4.1.22-0.rhel4
mysql-query-browser-5.0r12-1fc5
mysql-migration-toolkit-5.0r12-1fc5
mysql-gui-tools-5.0r12-3.fc8
MySQL-shared-compat-4.1.22-0.rhel4

Remove each one with ‘rpm -e filename’ at shell prompt for eg:- [….]#rpm -e MySQL-server-standard-4.1.22-0.rhel4
If want a neat way, and do not want any dependency checks and related issues, try yum command.
————————————————————–
Remove option 1
————————————————————–
[root@nerd1 /]# rpm -e mysql-gui-tools-5.0r12-3.fc8
error: Failed dependencies:
mysql-gui-tools = 5.0r12 is needed by (installed) mysql-administrator-5.0r12-1fc5.i386
mysql-gui-tools = 5.0r12 is needed by (installed) mysql-query-browser-5.0r12-1fc5.i386
mysql-gui-tools = 5.0r12 is needed by (installed) mysql-migration-toolkit-5.0r12-1fc5.i386
[root@nerd1 /]# rpm -e MySQL-server-standard-4.1.22-0.rhel4
[root@nerd1 /]# rpm -e mysql-administrator-5.0r12-1fc5
error: Failed dependencies:
mysql-administrator is needed by (installed) mysql-gui-tools-5.0r12-3.fc8.i386
[root@nerd1 /]# rpm -e MySQL-client-standard-4.1.22-0.rhel4
[root@nerd1 /]# rpm -e MySQL-devel-standard-4.1.22-0.rhel4
[root@nerd1 /]# rpm -e mysql-migration-toolkit-5.0r12-1fc5
[root@nerd1 /]# rpm -e MySQL-shared-compat-4.1.22-0.rhel4
[root@nerd1 /]# rpm -e mysql-query-browser-5.0r12-1fc5
error: Failed dependencies:
—————————————————————

—————————————————————
Remove option 2
—————————————————————

[root@nerd1 Desktop]# yum remove ‘*mysql*’
Setting up Remove Process
fedora                    100% |=========================| 2.1 kB    00:00
updates                   100% |=========================| 2.6 kB    00:00
skype                     100% |=========================|  951 B    00:00
Resolving Dependencies
–> Running transaction check
—> Package mysql-administrator.i386 0:5.0r12-1fc5 set to be erased
—> Package mysql-query-browser.i386 0:5.0r12-1fc5 set to be erased
—> Package mysql-gui-tools.i386 0:5.0r12-3.fc8 set to be erased
–> Finished Dependency Resolution

Dependencies Resolved

=============================================================================
Package                 Arch       Version          Repository        Size
=============================================================================
Removing:
mysql-administrator     i386       5.0r12-1fc5      installed         8.8 M
mysql-gui-tools         i386       5.0r12-3.fc8     installed          19 k
mysql-query-browser     i386       5.0r12-1fc5      installed         6.6 M

Transaction Summary
=============================================================================
Install      0 Package(s)
Update       0 Package(s)
Remove       3 Package(s)

Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Erasing   : mysql-administrator          ######################### [1/3]
Erasing   : mysql-query-browser          ######################### [2/3]
Erasing   : mysql-gui-tools              ######################### [3/3]

Removed: mysql-administrator.i386 0:5.0r12-1fc5 mysql-gui-tools.i386 0:5.0r12-3.fc8 mysql-query-browser.i386 0:5.0r12-1fc5
Complete!
—————————————————————————–

Now try ,
[root@nerd1 mysql_related]# yum remove ‘*mysql*’
and,
[root@nerd1 mysql_related]# yum remove ‘*Mysql*’

The result assures you , all went smooth. Now let us begin, but two more checks.
[root@nerd1 mysql_related]# rm -Rf  /var/lib/mysql/*.*
[root@nerd1 mysql_related]# rm -Rf  /var/lock/subsys/mysql/*.*

( above steps help avoid issues like “Starting MySQL……………….Manager of pid-file quit w[FAILED]pdating file” later )

Now let us begin installing the rpms community server, client as below:

[root@nerd1 Desktop]# rpm -iv MySQL-server-community-5.0.67-0.rhel3.i386.rpm
…………………………..
Preparing packages for installation…
MySQL-server-community-5.0.67-0.rhel3
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password ‘new-password’
/usr/bin/mysqladmin -u root -h nerd1 password ‘new-password’

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
Starting MySQL..[  OK  ]
Giving mysqld 2 seconds to start
……………………………..

[root@nerd1 Desktop]# rpm -iv MySQL-client-community-5.0.67-0.rhel3.i386.rpm
Preparing packages for installation…
MySQL-client-community-5.0.67-0.rhel3

ok, so seems all went fine.let us check client and test mysql
[root@nerd1 Desktop]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.0.67-community MySQL Community Edition (GPL)

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> CREATE DATABASE servercsa;
Query OK, 1 row affected (0.00 sec)

mysql> quit

————————————————————————
////////////////////////////////////////////////////////////////////////
Check out for the part 2 : Install MySQL GUI Tools
////////////////////////////////////////////////////////////////////////
————————————————————————

in the middle of night , angel turns wild

Posted in drama, memoirs, movie, society with tags , , , , , , , on November 19, 2008 by saffrongeek

Newspaper , I repeat, always miss the punch line and yes, this report also had the something gone missing. Well, it got me a bit to think and share here.. Sorry, you might be thinking ,’what the heck I am talking about?’
ok..ok let me brief the news:
” a aspiring actress, living in MUMBAI , got arrested after confessing for the murder of X, creative head, studio A…”

Didnt she do it? Yes , Of course, she gotta know when the last SMS activity from the X’s cell says so. And yes, she confessed to cops during interrogation.

Her confession seems => ‘ Yes, I just helped in chopping and disposing the body parts. Also dirtied a bit of my fingers, mind you, not hands but just fingers with destroying the left over evidence in my apartment.

There should be some motive , right? Ooops , I forgot to mention, it was not she but her fiancee , Mr. Jay who did the murder. Why? It appears like Jay called up for some bedtime jingles with actress but happen to hear in the background, Mr.X, creative head, explaining some confidential positions she could try in her career.

Man, I bet, damn it, it should have been really inspiring, that too in the middle of night for Jay that he took immediate flight to MUMBAI to give a knock at actress apartment, to see intimate actress and X unwinding with a fag…( sure another, F* preceded )

Hey Jay, HatzZ of to you man. You sorted the puzzle easily, cool. Just with a knife. Whewww!! you rocks man to screw your life for a lady who sleeps with many for building a career.

SO WHAT WAS I COMING to say:
Actress DAD cried foul at investigation, at the moment he got a reporter to report his view. ( Mirror please… )
Her sister reveals another truth . what? ‘She never was not could turn so bold’.
( Hey, seems she is taught that ‘every kill got to have a criminal involved’ )
Her brother confides another top kept secret, ‘ she falls unconscious at the very sight of blood’.
( Excuse me, with respect to ladies, hope actress got the women clock clicking in her.. )

WHATEVER.. we would be fool not to realize that this is the attempt to just put the Mr.fiancee , our knife-star alone for the murder.Man, how could miss-sight-of-blood-unconscious-actress be an angel, when she is xtremely wild and selfish to build a career out of ethics.

Internet Explorer for linux

Posted in Linux, Technical with tags , , on November 18, 2008 by saffrongeek

Well, sometimes when linux geek needs to make sure the cross browser compatible is best , there should be some way IE option in linux and it is pretty easy with the following set ups:

Internet Explorer: http://www.tatanka.com.br/ies4linux/page/Installation

Other related packages links which ie4linux is dependent

http://www.cabextract.org.uk/
http://fedoraproject.org/wiki/AndreasBierfert/Wine

mysql-query-browser : compiling from open source sucks

Posted in mysql, Technical with tags , on November 18, 2008 by saffrongeek

trying to compile mysql-query-browser, when i give …
configure: error: Package requirements (libglade-2.0
gthread-2.0
libxml-2.0 >= 2.6.2
libgtkhtml-3.0
gtkmm-2.4) were not met.
Consider adjusting the PKG_CONFIG_PATH environment variable

I tried all and somewhere suggested steps as below:
1. First build mysql-gui-common
2. then, > cd mysql-query-browser
./configure –with-gtkhtml=libgtkhtml-3.8 && make && make install

Still, it sucks, when this should not have been so messy complicated for a semi-techie leave the normal end user developer.
I came across articles for knowledge enhancement on this , just thought to compile at one place for my own reference and sharing.

Best :: http://ronaldbradford.com/blog/2006/01/18/

Other ::
http://bugs.mysql.com/bug.php?id=27519
http://bugs.mysql.com/bug.php?id=31042

%d bloggers like this: