From: Jeremy Buchmann <jeremy@wellsgaming.com>
To: Ernesto A. Lira Castro <lira@ver.megared.net.mx>
To: pgsql-interfaces@postgresql.org
Subject: Re: Security
Date: Sun, 20 May 2001 14:49:33 -0700
Message-ID: <B72D89FD.2DFA%jeremy@wellsgaming.com> (raw)
In-Reply-To: <3B06146E.7759BFD9@ver.megared.net.mx>
> I'm trying to set login & passwords to my system with Perl DBI for
> Postgresql, but i want to have a field on my Postgres's database
> that can be type password!! is that possible?? i see only fields types
> (Char, integer, long . . .) i want some password to be encrypted.
You can use MD5 or SHA perl modules to get a digest of the password and then
get the hex representation of the digest and store that in the database as a
char or varchar.
> And where can i get some information for implementing that security on
> my system!
The MD5 and SHA modules are on cpan.org. I only have experience with the
MD5 module, but it's very simple to use, provided you know a little Perl. I
can show you code if you don't understand the examples provided with the
module.
-- Jeremy [jeremy@wellsgaming.com]
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jeremy@wellsgaming.com, lira@ver.megared.net.mx
Subject: Re: Security
In-Reply-To: <B72D89FD.2DFA%jeremy@wellsgaming.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox