Installing Perl DBI and DBD


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Installing Perl DBI and DBD
# 1  
Old 03-12-2008
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 are
Code:
cd /home/DBI
Perl Makefile.PL
make
make install

I would like to know, after executing these commands, where is it installed? And also, if i installed it using my login id, when another person logs in, would that id be able to use these DBI modules?
# 2  
Old 03-12-2008
in /usr/lib/perl5/5.8.8/ by default, at least on my Fedora 8. Another person will be able to use them, yes.
Two quick checks you can perform :
Code:
perl -e 'use DBI; print $DBI::VERSION,"\n";'
perl -e 'use DBD::Oracle; print $DBD::Oracle::VERSION,"\n";'

# 3  
Old 03-13-2008
If you are not root or the permission of the default installation directory (that is usually somewhere in /usr, but that location varies from installation to installation) does not allow writing by your user, installing will fail and you should see error message while "make install", so it is easy to spot.

You will need to pass additional parameter to "perl Makefile.PL" to override the default installation location such as when installing with user privilege. I think it is something like (I have not installed modules as a user for so long)

perl Makefile.PL PREFIX=/home/blablabla/libs

If you are just a normal user and do not have root, I guess you can only install it in your home directory and others will not be able to use it.

ExtUtils::MakeMaker - perldoc.perl.org
# 4  
Old 03-17-2008
Hi all,

i managed to install it as root user, and any one can use the modules. Thanks.

Hi cbkihong,

you mentioned that installation location varies,how can i find out where did my installation went to ?
# 5  
Old 03-18-2008
I normally find it out with something like this:

Code:
cbkihong@cbkihong:~$ perl -MDBD::mysql -e 'print $INC{"DBD/mysql.pm"}, "\n"'
/usr/local/lib/perl/5.8.0/DBD/mysql.pm

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl DBI error

Hi All, I installed DBI module in a non INC location and using it in my script via "use lib". But it throw the below error at the "use DBI" step. Please help Usage: DBI::_install_method(dbi_class, meth_name, file, attribs=Nullsv) at /xx/xxx/xxxxx/xxxxx/oracle/lib/DBI.pm/oracle/lib/DBI.pm line... (2 Replies)
Discussion started by: prasperl
2 Replies

2. Windows & DOS: Issues & Discussions

Installing MySql DBD in dtrawberry perl

Hi Guys, I am trying to install DBI and DBD-MYSQL for strawberry perl. But i am not able to install. :wall: DBD-MYSQL >> makefile.pl gives error as 'Access denied for user 'ODBC'@'localhost' (using password: NO)'. (7 Replies)
Discussion started by: vasanth.vadalur
7 Replies

3. Shell Programming and Scripting

perl: help with DBI

Hi there, I have a bit of code similar to below (which ive actually got from perldoc, but mine is similar enough) $sth = $dbh->prepare(q{ SELECT region, sales FROM sales_by_region }); $sth->execute; my ($region, $sales); # Bind Perl variables to columns: $rv =... (4 Replies)
Discussion started by: hcclnoodles
4 Replies

4. UNIX for Advanced & Expert Users

Perl's DBI Module on OS X - uninstallable?

i've been struggling with installing the Perl DBI & DBD modules all weekend, and I'm getting close, but no cigar as of yet. When I run the perl script db.pl I get the following mismatch error: Mon Apr 19 09:43:29 EDT 2010 /Library/Perl/DBD-mysql-4.011 -> peterv@MBP17.local<515>$: db.pl | tee... (0 Replies)
Discussion started by: peterv6
0 Replies

5. Programming

perl dbi to oracle getting disconnect_all for oracle dbi help

hi i am trying to connect to an oracle database using dbi and i get this :: Driver has not implemented the disconnect_all method. at /opt/perl/lib/site_perl/5.8.0/sun4-solaris/DBI.pm line 575 END failed--call queue aborted. for all i know, the script was working earlier, but has... (1 Reply)
Discussion started by: poggendroff
1 Replies

6. UNIX for Advanced & Expert Users

Error during installing DBD-mysql-4.005

Hi, Iam not able to install DBD-mysql-4.005 into my Sun machine as the error comes - perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config I will use the following settings for compiling and testing: cflags (mysql_config ) = -I/usr/local/mysql/include/mysql ... (2 Replies)
Discussion started by: aditya.ece1985
2 Replies

7. UNIX and Linux Applications

help: error in installing perl module DBD::mysql

Hi, I am trying to install perl module DBD::mysql and don't know how to resolve the following: # make test PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/00base.............ok 3/5install_driver(mysql) failed: Can't load... (3 Replies)
Discussion started by: Yogesh Sawant
3 Replies

8. Shell Programming and Scripting

perl DBI/DBD Module -in cygwin

Hi all, I am trying to install the DBI module in perl using perl -MCPAN -e shell install 'DBI' --It is installing into the nuild directory properly but when it try to make it is saying NOT OK -I tried to copy the module manually to the /lib/perl5/vendor_perl ... (3 Replies)
Discussion started by: jambesh
3 Replies

9. UNIX for Advanced & Expert Users

perl-DBD-Oracle

I am trying to install perl-DBD-Oracle-1.16-1.2.rpm on Suse (SLE 9), like rpm -Uvh perl-DBD-Oracle-1.16-1.2.rpm but I keep getting the following error message error: Failed dependencies: libclntsh.so.10.1 is needed by perl-DBD-Oracle-1.16-1.2.el4 libnnz10.so is needed by... (1 Reply)
Discussion started by: hassan1
1 Replies

10. UNIX for Advanced & Expert Users

perl module DBD-Oracle

I am trying to install Oracle perl module(DBD-Oracle). MY oracle server runs on solaris 8 while the machine am tring to install DBD-Oracle runs Suse linux 9(SLE 9) Oracle client library including sqlplus are NFS mount on my suse linux machine from my solaris oracle server but when I run make on... (1 Reply)
Discussion started by: hassan1
1 Replies
Login or Register to Ask a Question

Featured Tech Videos