pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
encryption for postgres
6+ messages / 5 participants
[nested] [flat]

* encryption for postgres
@ 2001-10-14 22:50  hodges@xprt.net
  0 siblings, 2 replies; 6+ messages in thread

From: hodges@xprt.net @ 2001-10-14 22:50 UTC (permalink / raw)
  To: pgsql-php

I need to save user ids and passwords to be used for access
to records in a database.  The passwords should be encrypted
before saving.  Are there builtin or standard php functions
to do encryption/decryption or does one need to add a library
to a standard php install (RedHat 7.1).

Cheers, Tom
Tom Hodges, hodges@xprt.net or tom_hodges@yahoo.com
ICQ 10149621, YahooMessenger tom_hodges
Mail: 14314 SW Allen Blvd, #317; Beaverton OR 97005 USA



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: encryption for postgres
@ 2001-10-14 23:40  Joel Burton <joel@joelburton.com>
  parent: hodges@xprt.net
  1 sibling, 1 reply; 6+ messages in thread

From: Joel Burton @ 2001-10-14 23:40 UTC (permalink / raw)
  To: hodges@xprt.net; +Cc: pgsql-php

On Sun, 14 Oct 2001 hodges@xprt.net wrote:

> I need to save user ids and passwords to be used for access
> to records in a database.  The passwords should be encrypted
> before saving.  Are there builtin or standard php functions
> to do encryption/decryption or does one need to add a library
> to a standard php install (RedHat 7.1).

http://www.php.net/manual/en/function.crypt.php

or, for better security,

http://www.php.net/manual/en/function.md5.php

(btw, found this by searching for 'encryption' on the
homepage at php.net.)

-- 

Joel BURTON  |  joel@joelburton.com  |  http://joelburton.com  |  aim: wjoelburton
Independent Knowledge Management Consultant




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: encryption for postgres
@ 2001-10-15 00:38  Ben.Westgarth@facs.gov.au
  0 siblings, 0 replies; 6+ messages in thread

From: Ben.Westgarth@facs.gov.au @ 2001-10-15 00:38 UTC (permalink / raw)
  To: hodges@xprt.net; +Cc: pgsql-php



Hi Tom,

There is a standard function - 'crypt( )' . I'm afraid I can't give you a
detailed run down on how to use it off the top of my head, but the manual covers
it pretty well, and you can also check it out at http://www.php.net

If you need more serious security there are other encryption functions around,
but I think you have to load most of these in as separate modules. I seem to
remember that php builder have done a couple of good articles on such things
(don't quote me on that though).

Cheers,

Ben Westgarth






hodges@xprt.net on 15/10/2001 08:50:20

To:   pgsql-php@postgresql.org
cc:    (bcc: Ben Westgarth/User/FaCS)

Subject:  [PHP] encryption for postgres



I need to save user ids and passwords to be used for access
to records in a database.  The passwords should be encrypted
before saving.  Are there builtin or standard php functions
to do encryption/decryption or does one need to add a library
to a standard php install (RedHat 7.1).

Cheers, Tom
Tom Hodges, hodges@xprt.net or tom_hodges@yahoo.com
ICQ 10149621, YahooMessenger tom_hodges
Mail: 14314 SW Allen Blvd, #317; Beaverton OR 97005 USA

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Attachments:

  att1.eml (application/octet-stream, 2.9K) download

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: encryption for postgres
@ 2001-10-15 00:42  speedboy <speedboy@nomicrosoft.org>
  parent: Joel Burton <joel@joelburton.com>
  0 siblings, 0 replies; 6+ messages in thread

From: speedboy @ 2001-10-15 00:42 UTC (permalink / raw)
  To: pgsql-php

> http://www.php.net/manual/en/function.crypt.php
> 
> or, for better security,
> 
> http://www.php.net/manual/en/function.md5.php

How is md5 more secure?




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: encryption for postgres
@ 2001-10-15 00:44  Mitch Vincent <mvincent@cablespeed.com>
  parent: hodges@xprt.net
  1 sibling, 1 reply; 6+ messages in thread

From: Mitch Vincent @ 2001-10-15 00:44 UTC (permalink / raw)
  To: hodges@xprt.net; pgsql-php

There are such functions for both PHP and PostgreSQL -- check out pgcrypto
in the contrib directory of the tarball for PostgreSQL support and the
mcrypt functions for PHP support... Both link to external libraries..

Note that MD5 and DES encryption might be available without linking to
external libs but those are one-way encryptions....

-Mitch
----- Original Message -----
From: <hodges@xprt.net>
To: <pgsql-php@postgresql.org>
Sent: Sunday, October 14, 2001 6:50 PM
Subject: [PHP] encryption for postgres


> I need to save user ids and passwords to be used for access
> to records in a database.  The passwords should be encrypted
> before saving.  Are there builtin or standard php functions
> to do encryption/decryption or does one need to add a library
> to a standard php install (RedHat 7.1).
>
> Cheers, Tom
> Tom Hodges, hodges@xprt.net or tom_hodges@yahoo.com
> ICQ 10149621, YahooMessenger tom_hodges
> Mail: 14314 SW Allen Blvd, #317; Beaverton OR 97005 USA
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: [PHP] encryption for postgres
@ 2001-10-15 12:41  hodges@xprt.net
  parent: Mitch Vincent <mvincent@cablespeed.com>
  0 siblings, 0 replies; 6+ messages in thread

From: hodges@xprt.net @ 2001-10-15 12:41 UTC (permalink / raw)
  To: pgsql-php; pgsql-novice@postgresql.org

Thanks for all the advice on encryption.  I am just looking
for one way encryption so I will use crypt with either md5
or blowfish, depending on which is available.

Cheers, Tom



^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2001-10-15 12:41 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-10-14 22:50 encryption for postgres hodges@xprt.net
2001-10-14 23:40 ` Joel Burton <joel@joelburton.com>
2001-10-15 00:42   ` speedboy <speedboy@nomicrosoft.org>
2001-10-15 00:44 ` Mitch Vincent <mvincent@cablespeed.com>
2001-10-15 12:41   ` hodges@xprt.net
2001-10-15 00:38 Re: encryption for postgres Ben.Westgarth@facs.gov.au

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