LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   Bugzilla - MySQL - perl - DBD::mysql install problem (https://www.linuxquestions.org/questions/linux-software-2/bugzilla-mysql-perl-dbd-mysql-install-problem-300334/)

Runningonair 03-11-2005 05:36 AM

Bugzilla - MySQL - perl - DBD::mysql install problem
 
I'm trying to install Bugzilla which includes MySQL and requires a number of Perl modules. I can't get DBD::mysql to install. This is what I'm getting..

rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/lib/mysql:/lib" /usr/bin/perl myld cc -shared dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolv
/usr/lib/gcc-lib/i486-suse-linux/3.2.2/../../../../i486-suse-linux/bin/ld: cannot find -lnss_files
collect2: ld returned 1 exit status
chmod 755 blib/arch/auto/DBD/mysql/mysql.so
chmod: failed to get attributes of `blib/arch/auto/DBD/mysql/mysql.so': No such file or directory
make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1
/usr/bin/make -- NOT OK
Running make test
Can't test without successful make
Running make install
make had returned bad status, install seems impossible

I realise there may be better places to post this, so any suggestions would be helpful.

__J 03-11-2005 05:42 AM

Re: Bugzilla - MySQL - perl - DBD::mysql install problem
 
Quote:

Originally posted by Runningonair
I'm trying to install Bugzilla which includes MySQL and requires a number of Perl modules. I can't get DBD::mysql to install. This is what I'm getting..

rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/lib/mysql:/lib" /usr/bin/perl myld cc -shared dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolv
/usr/lib/gcc-lib/i486-suse-linux/3.2.2/../../../../i486-suse-linux/bin/ld: cannot find -lnss_files
collect2: ld returned 1 exit status
chmod 755 blib/arch/auto/DBD/mysql/mysql.so
chmod: failed to get attributes of `blib/arch/auto/DBD/mysql/mysql.so': No such file or directory
make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1
/usr/bin/make -- NOT OK
Running make test
Can't test without successful make
Running make install
make had returned bad status, install seems impossible

I realise there may be better places to post this, so any suggestions would be helpful.

you need to make sure you have libnss_files installed ( wherever that comes from, sorry I have no idea).

whenever you get linker errors ( the "cannot find -lnss_files"), replace the -l with lib and thats what the linker is looking for ( in this case libnss_files). look for it on your system and if it is there, add the path to the directory it is in to /etc/ld.so.conf, then ( as root) run ldconfig and recompile.

Runningonair 03-11-2005 06:06 AM

I've found a libness_files.so.2 in the /lib directory and have done what you suggest, but I don't know how to recompile.

Could you give me a hint?

Thanks

__J 03-11-2005 06:10 AM

I just meant retry to make DBD::mysql. typically, the linker will pick up anything in /lib/ or /usr/lib automagically?? might need to make a couple symlinks if it doesn't work:


ln -s /lib/libnss_files.so.2 /usr/lib/libnss_files.so.2

and that should take care of it.

Runningonair 03-11-2005 07:01 AM

Unfortunately that hasn't worked. Maybe the problem is somewhere else. I'm not fully convinced that mysql is installed properly as I installed it form an rpm which did not complete fully. Having said that, there are a number mysql processes running so it may be fine. I'm not sure how to check.

Thanks for you help.

spide21 01-16-2006 04:14 PM

Try usin CPAN
 
Quote:

Originally Posted by Runningonair
I'm trying to install Bugzilla which includes MySQL and requires a number of Perl modules. I can't get DBD::mysql to install. This is what I'm getting..

rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/lib/mysql:/lib" /usr/bin/perl myld cc -shared dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolv
/usr/lib/gcc-lib/i486-suse-linux/3.2.2/../../../../i486-suse-linux/bin/ld: cannot find -lnss_files
collect2: ld returned 1 exit status
chmod 755 blib/arch/auto/DBD/mysql/mysql.so
chmod: failed to get attributes of `blib/arch/auto/DBD/mysql/mysql.so': No such file or directory
make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1
/usr/bin/make -- NOT OK
Running make test
Can't test without successful make
Running make install
make had returned bad status, install seems impossible

:) I realise there may be better places to post this, so any suggestions would be helpful.

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

psreenivasulureddy 03-24-2006 06:42 AM

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.

ethics 03-24-2006 06:51 AM

http://www.linuxquestions.org/questi...d.php?t=339414

I replied there, it's extremly difficult to keep track of 2 threads practically the same

http://www.linuxquestions.org/questi...d.php?t=300334 and a third one, that you hijacked off someone else, people won't be inclined to help if you make it difficult for them

asaguru 10-12-2007 12:42 AM

DBD::mysql
 
try to install DBD::mysql through CPAN


All times are GMT -5. The time now is 10:30 AM.