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 PHP
ifx_connect
IFX_CONNECT(3) 1 IFX_CONNECT(3)
ifx_connect - Open Informix server connection
SYNOPSIS
resource ifx_connect ([string $database], [string $userid], [string $password])
DESCRIPTION
ifx_connect(3) establishes a connection to an Informix server.
In case a second call is made to ifx_connect(3) with the same arguments, no new link will be established, but instead, the link identifier
of the already opened link will be returned.
The link to the server will be closed as soon as the execution of the script ends, unless it's closed earlier by explicitly calling
ifx_close(3).
PARAMETERS
All of the arguments are optional, and if they're missing, defaults are taken from values supplied in php.ini (ifx.default_host for the
host (Informix libraries will use INFORMIXSERVER environment value if not defined), ifx.default_user for user, ifx.default_password for the
password (none if not defined).
o $database
- The database name, as a string.
o $userid
- The username, as a string.
o $password
- The password, as a string.
RETURN VALUES
Returns a connection identifier on success, or FALSE on error.
EXAMPLES
Example #1
Connect to a Informix database
<?php
$conn_id = ifx_connect ("mydb@ol_srv1", "imyself", "mypassword");
?>
SEE ALSO
ifx_pconnect(3), ifx_close(3).
PHP Documentation Group IFX_CONNECT(3)