04-28-2008
Connecting to DB
Is it possible to connect to two databases in a single query with different username and passwords?
provide an example pls
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
if;
sqlplus /nolog <<EOF
conn / as sysdba
spool /tmp/start.out
@/oracle/home/start.sql
spool off
exit
EOF
fi
For this code i am getting error:
Test.sh: syntax error at line 7 : `<<' unmatched (8 Replies)
Discussion started by: dreams5617
8 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I have three ip address say x.x.x.x , y.y.y.y and z.z.z.z
I am connecting to x.x.x.x first and from there i am telnet y.y.y.y and getting into y and from there i am telnet to z
i want to know, can we write a script, which can automatically connect from x to y and from y to z..
is... (1 Reply)
Discussion started by: vasikaran
1 Replies
3. Shell Programming and Scripting
how can i check to number of files and directory containing no data in whole system and display it
if 'home' is to root directory
it contains 10 subdirectory and many files (1 Reply)
Discussion started by: shafique
1 Replies
4. Linux
Hi,
I can ping www.yahoo.com (then domain name server is OK) but I can not navigate by Motzila to www.yahoo.com or any other Web Site.
What can be the problem ? Mozila is configured in preference /advance to go automaticaly on WEB.
We are under RED HAT AS3.
What should I check ?
Many thanks... (1 Reply)
Discussion started by: big123456
1 Replies
5. UNIX for Dummies Questions & Answers
I have just installed Linux and everything looks great, but how do I get my browser (Mozilla) to connect to my internet service provider?
I have a cable connection to Bigpond in Australia, if that means anything - the ISP will not provide support for Linux.
Your help would be greatly... (2 Replies)
Discussion started by: openhead
2 Replies
6. Solaris
If i do a ftp localhost , it works but if i do a ftp x.x.x.x (ip ) it does not work thoug all the services are running what could be the reason for this
bash-3.00# ftp localhost
Connected to localhost.
220-
bash-3.00# ftp 10.63.25.176
Connected to 10.63.25.176.
421 Service not available,... (7 Replies)
Discussion started by: fugitive
7 Replies
7. Shell Programming and Scripting
I am trying to connect to one of the oracle sever using uni through sqlplus
command: sqlplus -s BOXI_ALPH_AUDITOR,Q078_audit$@Q047
But its not getting connected. I tried using some different server using same syntax its working. What differene i found is the password is having no special... (2 Replies)
Discussion started by: gander_ss
2 Replies
8. Shell Programming and Scripting
Hi all,
In my concern they gave a task to me do cran job like
To write a shell script for
To connect a database
it should execute a query
it should save the output of the query
after getting the output it should send a mail to you inbox for every one hour
I can able to... (8 Replies)
Discussion started by: thelakbe
8 Replies
9. Linux
Well im on Fedora, and theres no sub section for Fedora so yea
Well how do you connect to an SSH, while on a windows terminal?
And also to transfer a file from my desktop to a server?
how is this done
scp command is not working for me (3 Replies)
Discussion started by: gangsta
3 Replies
10. Solaris
Hi,
I have been using using internet explorer on windows for connecting with production server using vpn connection.
i want to use same vpn to connect from solaris system to the production server.it is not connecting
is there solution (0 Replies)
Discussion started by: malikshahid85
0 Replies
LEARN ABOUT DEBIAN
dbix::password
Password(3pm) User Contributed Perl Documentation Password(3pm)
NAME
DBIx::Password - Allows you to create a global password file for DB passwords
SYNOPSIS
use DBIx::Password;
my $dbh = DBIx::Password->connect($user);
my $dbh = DBIx::Password->connect_cached($user);
$dbh->getDriver;
DBIx::Password::getDriver($user);
DBIx::Password::checkVirtualUser($user);
DBIx::Password::clearConfig();
DBIx::Password::readConfig("$ENV{HOME}/.my.secret.file");
DESCRIPTION
Don't you hate keeping track of database passwords and such throughout your scripts? How about the problem of changing those passwords on a
mass scale? This module is one possible solution. It stores all your virtual users and data in /etc/dbix-password.conf. For each user you
need to specify the database module to use, the database connect string, the username and the password. You will have to give a name to
this virtual user. You can add as many as you like.
I would recommend that if you are only using this with web applications that you change the final permissions on this package after it is
installed in site_perl such that only the webserver can read it.
A method called getDriver has been added so that you can determine what driver is being used (handy for working out database indepence
issues).
If you want to find out if the virtual user is valid, you can call the class method checkVirtualUser(). It returns true(1) if the
username is valid, and zero if not.
Once your are done you can use the connect method (or the connect_cache method) that comes with DBIx-Password and just specify one of the
virtual users you defined while making the module.
BTW I learned the bless hack that is used from Apache::DBI so some credit should go to the authors of that module. This is a rewrite of
the module Tangent::DB that I did for slashcode.
If your program does not need the system-wide information stored in the /etc/dbix-password.conf file, you may use the clearConfig() and
readConfig() functions to get the data from another source. At any time, readConfig() may also be used to merge the data from another file
into the currently-loaded configuration.
Hope you enjoy it.
HOME
To find out more information look at: http://www.tangent.org/DBIx-Password/
AUTHOR
Brian Aker, brian@tangent.org
SEE ALSO
perl(1). DBI(3).
perl v5.10.0 2009-05-09 Password(3pm)