LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 07-02-2005, 03:49 PM   #1
Elleroth
LQ Newbie
 
Registered: Jul 2005
Location: Florida
Distribution: Slackware 10.1
Posts: 1

Rep: Reputation: 0
DBD::MySQL + MySQL install problems.


Well, to start off, I have actually installed the module. However, I would like to avoid this minor problem in the future if possible...



I used CPAN to get, configure, compile, and install the DBD::MySQL.

The problem occured when the module went through testing. From what I understood of the error messages, the test section barfed because it couldn't connect to the SQL server because it wanted a password for the root user and thus couldn't run the tests.

To fix this, I simply deactivated the root user's password for localhost and reran CPAN, which compiled and installed the module without any problems.


Now my question for future reference is: Is there any way to let CPAN or PERL know what your root user's password is so that it won't crap out on the test phase? Or better yet, is there a way to specify a specific "test" account to CPAN or the PERL config/make command that accesses only the "test" database of the SQL server??


I'm currently running:

Slackware 10.1

PERL 5.8.6 with:
cpan script version 1.03
CPAN.pm version 1.7601

DBD::MySQL 3.0000

mysql Ver 14.7 Distrib 4.1.11, for slackware-linux-gnu (i486)


Everything listed is pretty much a default package install for Slackware.

Any help's appreciated. )
 
Old 01-16-2006, 04:27 PM   #2
spide21
LQ Newbie
 
Registered: Nov 2005
Distribution: Fedora Core 11
Posts: 23

Rep: Reputation: 15
Post using CPAN

Quote:
Originally Posted by Elleroth
Well, to start off, I have actually installed the module. However, I would like to avoid this minor problem in the future if possible...



I used CPAN to get, configure, compile, and install the DBD::MySQL.

The problem occured when the module went through testing. From what I understood of the error messages, the test section barfed because it couldn't connect to the SQL server because it wanted a password for the root user and thus couldn't run the tests.

To fix this, I simply deactivated the root user's password for localhost and reran CPAN, which compiled and installed the module without any problems.


Now my question for future reference is: Is there any way to let CPAN or PERL know what your root user's password is so that it won't crap out on the test phase? Or better yet, is there a way to specify a specific "test" account to CPAN or the PERL config/make command that accesses only the "test" database of the SQL server??


I'm currently running:

Slackware 10.1

PERL 5.8.6 with:
cpan script version 1.03
CPAN.pm version 1.7601

DBD::MySQL 3.0000

mysql Ver 14.7 Distrib 4.1.11, for slackware-linux-gnu (i486)


Everything listed is pretty much a default package install for Slackware.

Any help's appreciated. )
Hi, if you install mysql (what version ?), make sure your lib*.so and "linked" files are in a directoy, in case you install mysql from RPM check the file path and locate the directory where your RPM install the *.so library. If you did install from source wich is the best solution (in my case) by default everything is installed in /usr/local/mysql.

After you successfully install mysql, add you /usr/mysql/lib/mysql directory to the /etc/ld.so.conf and save it, then load it by running "ldconfig -f /etc/ld.so.conf", and walla!, all your *.so files are accessible from any where in the system.

Note that if you system has Perl and CPAN, then it would be the easiest way to install all the packages you want, just type "cpan from shell". The first time CPAN is executed it will make you some question, just answer them and at the end choose only http servers rather than ftp because the are faster.

After all the questions, just type " install cpan" -->run "install Boundle::CPAN" and it will update your cpan.

Now make sure that you can run mysql_client from any part of the system, if you can't, do this "export PATH=$PATH:PATH_TO_YOU_MYSQL_BASE_DIR/bin" and try again by running mysql or any MySQL bin file.

After every thing is up, run CPAN again, just type "o conf prerequisites_policy ask" -->run "install DB::Mysql"

I hope all of these lines help you
 
Old 03-24-2006, 06:39 AM   #3
psreenivasulureddy
LQ Newbie
 
Registered: Mar 2006
Posts: 4

Rep: Reputation: 0
Configuring mysql 5 problem in Red Hat Linux 3

Hi,

I installed Red Hat Linux 3 in my system which had given Apache, PHP and mysql 3 by default. But, when I tried to give the command '#mysqld' it has given some socket error(mysql.sock). What I did is, I downloaded mysql 5.0 RPM's from the site 'mysql.com' and installed it. And now, when I tried to connect to server, using '#mysqld', the error I got is:

"[ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!"

And when I type the following command,

#rpm -q mysql-server
package mysql-server is not installed.

And

if I try to reinstall using mysql server rpm,
it says that the package is already installed.

Can somebody please help in solving this problem.
I am new to Linux Environment.
Please suggest me to sort out this problem.

If at all repairing this problem is not possible, can somebody suggest how to uninstall mysql, so that I can try it out once again by installing.

sreeni.
 
Old 03-24-2006, 06:48 AM   #4
ethics
Senior Member
 
Registered: Apr 2005
Location: London
Distribution: Arch - Latest
Posts: 1,522

Rep: Reputation: 45
Quote:
"[ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!"
Seems like a clear cut error message you don't seem to be running it as root and it wants you to, find the manual, check the security section like it says, if you don't understand post which bits.

To find the package try

Code:
rpm -qa | grep mysql

Last edited by ethics; 03-24-2006 at 06:54 AM.
 
Old 03-24-2006, 06:53 AM   #5
fakhrul
Member
 
Registered: Mar 2006
Location: Dhaka,Bangladesh
Distribution: Ubuntu 12.10
Posts: 51

Rep: Reputation: 15
do you typed '#mysqld'? i mean do you type the hash ('#') sign? if yes type only mysqld. you have to be root.
to find if mysql is installed type (if you use rpm):

rpm -qa | grep mysql
 
  


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
Bugzilla - MySQL - perl - DBD::mysql install problem Runningonair Linux - Software 8 10-12-2007 12:42 AM
Error compiling perl-DBD-MySQL after upgrading to MySQL 4.1 pitaro920 Linux - Software 1 01-16-2006 04:28 PM
MySQL / DBD / DBI problems drowning Linux - Software 9 09-19-2005 12:01 AM
mysql::DBD make problems - help plz pigsy Linux - Software 15 04-17-2004 02:48 PM
Can't install DBD::mysql or DBD::Pg DogTags Mandriva 2 01-21-2004 07:13 AM


All times are GMT -5. The time now is 04:58 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration