10-03-2008
Accessing Databse through OS Authentication
I have defined the connectivity details to the oracle database in a file env.ksh as follows
DBNAME=$INST_NAME
USERID="use_x"
PASSWORD="cccccc"
When ever i want to connect to the database from a shellscript ,i am running this file from the shell script as follows
# Export the environment varibles.
. /app/gsl/bin/env.ksh
Due to security reasons , we need to implement the OS authentication mechanism so that user id password should not be maintained in a file.
Instead , when the user logs into unix he should be able to access oracle without specifying the userid/password.
can anybody let me know how to achieve that.
cheers
Ravi.
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
i have oracle database startup problem.
i have installed oracle8i(8.1.7) on windowsXP i have configured everything properly but i m unable to start database automatically and for this when i checked services of database it shows starting not started so i have to start it manually.Can u plz tell... (3 Replies)
Discussion started by: vandana
3 Replies
2. UNIX for Dummies Questions & Answers
Hi,
This may be a stupid question, but I want to get a confirmation from experts.
After some painful attempts I was able to successfully dual boot RH Linux 7.3 with the Win XP hp factor install. (I used Partition Magic 8 from WinXP for creating the ext3 partitions)
I have now a nice grub... (3 Replies)
Discussion started by: Vishnu
3 Replies
3. Programming
i am including
#include<sqlext.h>
#include<sql.h>
while writing a program for database connection in c++ (not visual c++)
the compiler is giving error in both
my question is while allocating the environment or while creating a database connection in c++ which header files do we need
... (4 Replies)
Discussion started by: ramneek
4 Replies
4. UNIX for Advanced & Expert Users
how to upload system information(unix box) to MySql database's(running in another unix box) respective tables using a script only..i.e once script runs all the informations like hostid,hostna,disks,cpu etc get stored to respective tables of MySql database.... (2 Replies)
Discussion started by: shubhendu.pyne
2 Replies
5. UNIX for Advanced & Expert Users
Hello Community!
Anyone knows how can I access the switch for monitoring the traffic on my LAN?
The switch is a Linksys sr2024
Thanks in advance (1 Reply)
Discussion started by: ncatdesigner
1 Replies
6. Debian
Hello,
I wont to connect a MySQL database to debian:
I have installed libmyodbc package and after i have configured /etc/odbcinst.ini:
Description = MySQL driver
Driver = /usr/lib/odbc/libmyodbc.so
Setup = /usr/lib/odbc/libodbcmyS.so
and /etc/odbc.ini :
Description =... (0 Replies)
Discussion started by: linux31
0 Replies
7. Shell Programming and Scripting
i have written a shell script that reads a csv file and inserts tokenized strings into the database.
the problem comes when the csv file has cyrillic characters.
how do i set the parameters in my shell script(korn shell) so that any characters can be inserted into the database. (3 Replies)
Discussion started by: vkca
3 Replies
8. UNIX Desktop Questions & Answers
I have an application desigend in PHP and MySQl running on apache web server that I is running on a Amazon EC2 server Centos. I want to implement the master-master and master slave replication and high availability disaster recovery on this application database.
For this I have created two... (0 Replies)
Discussion started by: Palak Sharma
0 Replies
LEARN ABOUT DEBIAN
mysql_import_combined_log2
mysql_import_combined_log.pl(1) General Commands Manual mysql_import_combined_log.pl(1)
NAME
mysql_import_combined_log.pl - Imports an Apache combined log into a MySQL database.
SYNOPSIS
mysql_import_combined_log.pl -d <database name> -t <table name> [-h <host name>] [-u <user name>] [-p <password>] [-f <filename>]
OPTIONS
--host|-h <host name>
The host to connect to. Default is localhost.
--database|-d <database name>
The database to use. Required.
--username|-u <username>
The user to connect as.
--password|-p <password>
The user's password.
--table|-t <table name>
The name of the table in which to insert data.
--logfile|-f <file name>
The file to read from. If not given, data is read from stdin.
--help|-?
Print out this help message.
--version
Print out the version of this software.
AUTHOR
Aaron Jenson
Updated to work under Perl 5.6.1 by Edward Rudd
MAN PAGE CREATED BY
Michael A. Toth <lirul.lists@gmail.com> - based on content of script
COMMENTS
This man page was written using xml2man (1) by the same author.
Manuals User mysql_import_combined_log.pl(1)