Thread: Unix Scripts linking with Postgres

Dear All,

I have set-up my postgres db to require user authentication when a user
wishes to enter the db.
This works wonderfully.

I have programs written in Java, Ansi C and CGI which integrate with the
database and pass user names and
passwords to the database using the pgConnect function. However, I also
have several unix scripts which must
be able to gain access into the database in a similar manner i.e. make a
connection with no user interaction.

Is there anyway I can do this within a Unix Script?

Thanks for your Assistance.
--

Best Regards,
Luke.

* Luke Tudor - RSG <ltt@pml.ac.uk> [010116 14:50]:
> Dear All,
>
> I have set-up my postgres db to require user authentication when a user
> wishes to enter the db.
> This works wonderfully.
>
> I have programs written in Java, Ansi C and CGI which integrate with the
> database and pass user names and
> passwords to the database using the pgConnect function. However, I also
> have several unix scripts which must
> be able to gain access into the database in a similar manner i.e. make a
> connection with no user interaction.
>
> Is there anyway I can do this within a Unix Script?

I assume you mean from a shell script (i.e bash or similar).

What flavour CGI do you write? I've got perl scripts connecting
fine from the command line; there's nothing special about
CGI environments in that respect.

Of course from a user point of view, any account that can read the script
can suss out the password, which may not be what you want.

--
Rasputin
Jack of All Trades :: Master of Nuns

    Hi all,

    How did u change it? I changed the last two lines from my pg_hda.conf (
"trust" to "crypt") but it didn't work.
    I did the following after "su -l postgres"
    1-> createdb postgres
    2-> chmod 600 pg_pwd
    3-> psql
    4-> alter user postgres with password postgres_pw
    5-> \q
    6-> changed the file pg_hda.conf as described later
    7-> /etc/rc.d/init.d/postgresql restart

    After this when I try to use "psql -u -d postgres" or "psql -u", it
says that connection to database failed and failed authentication.
    Thanks in advance,

    Orlando

Luke Tudor - RSG wrote:
>
> Dear All,
>
> I have set-up my postgres db to require user authentication when a user
> wishes to enter the db.
> This works wonderfully.
>
> I have programs written in Java, Ansi C and CGI which integrate with the
> database and pass user names and
> passwords to the database using the pgConnect function. However, I also
> have several unix scripts which must
> be able to gain access into the database in a similar manner i.e. make a
> connection with no user interaction.
>
> Is there anyway I can do this within a Unix Script?
>
> Thanks for your Assistance.
> --
>
> Best Regards,
> Luke.