Perl Installing, Uninstalling


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Perl Installing, Uninstalling
# 1  
Old 08-22-2005
Perl Installing, Uninstalling

I have some problems with mysql, and maybe perl installation faults.
I have installed perl by source. I followed default configuration (e.g. ./configure, make, make install).
I have installed perl just because it was required for mysql's installation.

But now I have some problems.

If I will uninstall perl, and reinstall it as package, what may will happen???? Smilie

Or its better to uninstall mysql first, uninstall perl,
and then reinstall them???????

The problems that i have to handle are:
at webmin, servers , mysql, provides the following warning

Warning: The Perl modules DBI and DBD::mysql are not installed on your system, so Webmin will not be able to reliably access your MySQL database. Click here to install them now.

and the link is broken.

and i copy/pasted a database from redhat to solaris, and i cant open ISM tables. always provides errono : 138, and I tried many things, but nothing.
I tried isamchk , but nothing.
I tried from mysql tool from my pc (windows xp), nothing again.

I'm the same guy with Solaris 7 sparc 5 thread, for more information.

Maybe some will say:
Throw away the god damn machine.
Smilie

I cant say that they are wrong in their believes.Smilie

Thanks.
# 2  
Old 08-22-2005
DBD::mysql is a perl module which it sounds like you need to install. You should be able to install it quite happily without uninstalling/re-instaling perl.

If have already setup security on your mysql server then you'll have to install it manually. You can get it from www.cpan.org. Read the README first.
# 3  
Old 08-24-2005
I believe the problem is huge Smilie

So, so far, I have installed successfully DBI.
But, I'm trying to install DBD, and the pain begins Smilie .

I've tried to install many distributions with many ways of compilation.

I'm posting the last compilation, and the following errors.

# perl Makefile.PL --libs="-L/usr/local/mysql/lib/mysql -L/usr/local/lib -lmysqlclient -lz -lposix4 -lgen -lsocket -lnsl -lm" --cflags=-I/usr/local/mysql/include/mysql/
I will use the following settings for compiling and testing:

cflags (User's choice) = -I/usr/local/mysql/include/mysql/
embedded (mysql_config ) =
libs (User's choice) = -L/usr/local/mysql/lib/mysql -L/usr/local/lib -lmysqlclient -lz -lposix4 -lgen -lsocket -lnsl -lm
mysql_config (guessed ) = mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ps-protocol (default ) = 1
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testsocket (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Note (probably harmless): No library found for -lmysqlclient
Using DBI 1.48 (for perl 5.008005 on sun4-solaris) installed in /usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris/auto/DBI/
Writing Makefile for DBD::mysql

So far one "harmless" warning.


but,

#make

cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/Mysql.pm blib/lib/Mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
gcc -c -I/usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris/auto/DBI/ -I/usr/local/mysql/include/mysql/ -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"3.0002_1\" -DXS_VERSION=\"3.0002_1\" -fPIC "-I/usr/local/lib/perl5/5.8.5/sun4-solaris/CORE" dbdimp.c
/usr/local/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris/auto/DBI//Driver.xst > mysql.xsi
/usr/local/bin/perl /usr/local/lib/perl5/5.8.5/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/5.8.5/ExtUtils/typemap mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 224
Warning: duplicate function definition 'rows' detected in mysql.xs, line 557
................
................
................
ld: fatal: relocation error: R_SPARC_32: file dbdimp.o: symbol <unknown>: offset 0xef17a60b is non-aligned

ld: fatal: relocation error: R_SPARC_32: file mysql.o: symbol <unknown>: offset 0xef17a62b is non-aligned

collect2: ld returned 1 exit status
make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1



Smilie

Also I want to mention that, I searched for libmysqlclient libraries, and I found something in :

# ls -l /usr/local/mysql/lib/mysql/
total 3284
-rw-r--r-- 1 root other 19704 Aug 3 09:21 libdbug.a
-rw-r--r-- 1 root other 34416 Aug 3 09:23 libheap.a
-rw-r--r-- 1 root other 12972 Aug 3 09:22 libmerge.a
-rw-r--r-- 1 root other 302668 Aug 3 09:22 libmyisam.a
-rw-r--r-- 1 root other 22900 Aug 3 09:23 libmyisammrg.a
-rwxr-xr-x 1 root other 811 Aug 3 09:20 libmysqlclient.la
-rw-r--r-- 1 root other 344780 Aug 8 14:46 libmysqlclient.old
-rw-r--r-- 1 root other 353096 Aug 3 09:20 libmysqlclient_r.a
-rwxr-xr-x 1 root other 855 Aug 3 09:20 libmysqlclient_r.la
-rw-r--r-- 1 root other 123876 Aug 3 09:21 libmystrings.a
-rw-r--r-- 1 root other 256980 Aug 3 09:21 libmysys.a
-rw-r--r-- 1 root other 116508 Aug 3 09:22 libnisam.a
-rw-r--r-- 1 root other 5212 Aug 3 09:23 libvio.a


Happiness Smilie

Thanks again.
# 4  
Old 08-25-2005
Quote:
# perl Makefile.PL --libs="-L/usr/local/mysql/lib/mysql -L/usr/local/lib -lmysqlclient -lz -lposix4 -lgen -lsocket -lnsl -lm" --cflags=-I/usr/local/mysql/include/mysql/
Do you really need so many options? Most of the time, compiling without any option should be fine (you may need a few in case you would like to run the test suite before installing, but I will usually skip it), because the parameters are provided by mysql_config, which gives all the values needed.

May be we get back to the basics. Post what you see with

perl Makefile.PL

and the results of "make".
# 5  
Old 08-25-2005
Hello cbkihong .

I followed your advice.

But.

It provides me the same error as above.

Now I'm thinking if the specific destribution of DBD::mysql module, is really compatible with mysql-4.0.21, DBI-1.48, and general with Solaris 7, sparc 5.

I don't know. I'm trying several distributions of DBD, like DBD-mysql-2.1012,
DBD-mysql-2.1018, DBD-mysql-2.1021, DBD-mysql-2.9008, and DBD-mysql-3.0002_1.

Some of them, like DBD-mysql-3.0002_1, provides me different errors. For instance it cant recognize e specific string (I'm sorry, I dont remeber now).
Another distribution makes the makefile, with some warnings, but when I execute 'make test' (after 'make'), it provides many failures.

Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/00base.t 255 65280 5 4 80.00% 4-5
t/10dsnlist.t 255 65280 9 18 200.00% 1-9
t/20createdrop.t 255 65280 5 10 200.00% 1-5
t/30insertfetch.t 255 65280 11 22 200.00% 1-11
t/40bindparam.t 255 65280 28 56 200.00% 1-28
t/40blobs.t 255 65280 11 22 200.00% 1-11
t/40listfields.t 255 65280 16 32 200.00% 1-16
t/40nulls.t 255 65280 11 22 200.00% 1-11
t/40numrows.t 255 65280 25 50 200.00% 1-25
t/50chopblanks.t 255 65280 35 70 200.00% 1-35
t/50commit.t 255 65280 30 60 200.00% 1-30
t/ak-dbd.t 255 65280 90 180 200.00% 1-90
t/akmisc.t 255 65280 351 702 200.00% 1-351
t/dbdadmin.t 255 65280 20 40 200.00% 1-20
t/insertid.t 255 65280 12 24 200.00% 1-12
t/mysql.t 255 65280 68 136 200.00% 1-68
t/mysql2.t 255 65280 ?? ?? % ??
# 6  
Old 08-25-2005
Your directory listing of /usr/local/mysql/lib/mysql/ shows the problem. There is no libmysqlclient.a or libmysqlclient.so DBD::mysql is looking for one of these 2 files.
# 7  
Old 08-25-2005
I'm searching for a package which installs those files.
Because those files don't exist in my system.

I found in google for mysql-shares-comet package, but I cannot find a link tou download it.
An remember. I cannot use rpm's.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need help in installing perl *.pm files

Hi, I need to install Sys::HostAddr inorder to run the following command: perl -le 'use Sys::Hostaddr; print Sys::HostAddr->new->main_ip' I tried installing this package using CPAN by using the following command: $ sudo perl -MCPAN -e shell cpan> install Sys::HostAddr But still I am... (2 Replies)
Discussion started by: royalibrahim
2 Replies

2. Shell Programming and Scripting

Installing perl module

Hi, I want to install WWW:Mechanize module. Followed the following steps: 1. wget http://www.cpan.org/authors/id/C/CO/CORION/Bundle- WWW-Mechanize-Shell-0.29.tar.gz perl Makefile.PL make make test make install (Got the below message) Appending installation info to... (1 Reply)
Discussion started by: Anjan1
1 Replies

3. Red Hat

installing perl modules

Hi All, I have a customer asking me to install these perl modules on redhat 4 ent: File::Temp Getopt::Long DBD::mysql Mail::Mailer DBD::DB2 Any idea how can I install those modules. Thanks for any comment you may add. (3 Replies)
Discussion started by: itik
3 Replies

4. Shell Programming and Scripting

Installing Perl/Tk in x86_64

Hi, experts, I am trying to intall Perl/Tk module (Tk-804.028 ) into Perl5.6.1, however, the directory structure seems to be different from i386 than x86_64 and the installation keeps failing. Is this a known/common issue? Or does anyone has any workaround for this? ~* Dniz *~ (0 Replies)
Discussion started by: dniz
0 Replies

5. UNIX for Dummies Questions & Answers

installing perl modules

I resulted to using /usr/sfw/bin/gmake to install my perl modules until i ran into a problem installing perl/Tk Tk-804.028 gmake: Entering directory `/export/home/Tk-804.028/pod' Sorry no HTML building yet gmake: Leaving directory `/export/home/Tk-804.028/pod' I dont unstand what the error... (2 Replies)
Discussion started by: jameskay
2 Replies

6. Shell Programming and Scripting

Installing Perl Module

Hi All, When I tried to install Math::Pari module in a AIX 5.3 server,I am getting the following error. # pwd /usr/local/bin # cd Math-Pari-2.010709 # perl Makefile.PL Did not find GP/PARI build directory around. Do you want to me to fetch GP/PARI automatically? (If you do not, you... (2 Replies)
Discussion started by: surjithss
2 Replies

7. Shell Programming and Scripting

Installing Perl DBI and DBD

Hi, i have some queries on installing the Perl DBI and the DBD Oracle. I know that i have to install the DBI first. I have the source files in a folder in my home directory.The commands to install arecd /home/DBI Perl Makefile.PL make make installI would like to know, after executing these... (4 Replies)
Discussion started by: new2ss
4 Replies

8. Shell Programming and Scripting

Can I use a Perl Module without installing it?

I am trying to write a program that will use templates, so I figured I would use the Text::Template CPAN module... ...only problem is that I cant force my "clients" to install this module, cause they are clueless. Is there anyway that I can NOT install it for the whole machine, but install it... (1 Reply)
Discussion started by: jjinno
1 Replies

9. Shell Programming and Scripting

Installing Perl Modules

I have a script that uses the File::Listing module. I am trying to install it, but I read the ReadMe and it states that the following modules should be installed first: URI MIME-Base64 HTML-Parser libnet Digest-MD5 Compress-Zlib I am very new to Perl and would apprciate anyone's input on... (1 Reply)
Discussion started by: ssmiths001
1 Replies

10. Shell Programming and Scripting

Re-Installing Perl

I changed a few perl modules that it seems I should not have... Any way that I can re-install perl from scratch? (1 Reply)
Discussion started by: frustrated1
1 Replies
Login or Register to Ask a Question