Received: from agate.sge.net (agate.sge.net [152.91.14.27]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9F0flr45254 for ; Sun, 14 Oct 2001 20:41:47 -0400 (EDT) (envelope-from Ben.Westgarth@facs.gov.au) Received: from kunzite.sge.net (fosters.sge.net [152.91.9.15]) by agate.sge.net (Postfix) with ESMTP id 4EF204C522 for ; Mon, 15 Oct 2001 10:41:32 +1000 (EST) Received: from thorium1.sge.net (thorium1.sge.net [10.1.2.35]) by kunzite.sge.net (Postfix) with SMTP id 608743B132 for ; Mon, 15 Oct 2001 10:41:27 +1000 (EST) Received: FROM cascade.sge.net BY thorium1.sge.net ; Mon Oct 15 10:41:07 2001 +1000 Received: by cascade.sge.net (Postfix, from userid 5) id 16B2C42916; Mon, 15 Oct 2001 10:43:23 +1000 (EST) Received: from nodnsquery(172.16.151.1) by cascade.sge.net via csmap (V6.0) id srcAAAghaOWP; Mon, 15 Oct 01 10:43:23 +1000 Received: from facs.gov.au (unknown [10.18.20.57]) by bixbyite.sge.net (Postfix) with SMTP id A6768A6401; Mon, 15 Oct 2001 10:40:57 +1000 (EST) Received: by facs.gov.au(Lotus SMTP MTA v4.6.7 (934.1 12-30-1999)) id CA256AE6.0003C9C3 ; Mon, 15 Oct 2001 10:41:22 +1000 X-Lotus-FromDomain: FACS To: hodges@xprt.net Cc: pgsql-php@postgresql.org Message-ID: Date: Mon, 15 Oct 2001 10:38:51 +1000 Subject: Re: encryption for postgres Mime-Version: 1.0 Content-type: multipart/mixed; Boundary="0__=D4DGsWJJ4IGqcpFFtFmPFPLDyqQJlQ5StqWfHAiRCVigD7iny5UnRXR8" Content-Disposition: inline From: Ben.Westgarth@facs.gov.au X-Archive-Number: 200110/62 X-Sequence-Number: 615 --0__=D4DGsWJJ4IGqcpFFtFmPFPLDyqQJlQ5StqWfHAiRCVigD7iny5UnRXR8 Content-type: text/plain; charset=us-ascii Content-Disposition: inline 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 --0__=D4DGsWJJ4IGqcpFFtFmPFPLDyqQJlQ5StqWfHAiRCVigD7iny5UnRXR8 Content-type: application/octet-stream; name="att1.eml" Content-Disposition: attachment; filename="att1.eml" Content-transfer-encoding: base64 UmVjZWl2ZWQ6IGZyb20gYml4YnlpdGUuc2dlLm5ldCAoWzEwLjE4LjkuMV0p IGJ5IGZhY3MuZ292LmF1IChMb3R1cyBTTVRQIE1UQSB2NC42LjcgICg5MzQu MSAxMi0zMC0xOTk5KSkgd2l0aCBTTVRQIGlkIENBMjU2QUU2LjAwMDBGNDdC OyBNb24sIDE1IE9jdCAyMDAxIDEwOjEwOjI1ICsxMDAwDQpSZWNlaXZlZDog ZnJvbSBrcnlwdG9uaXRlMi5zZ2UubmV0IChrcnlwdG9uaXRlMi5zZ2UubmV0 IFsxMC4xLjIuMjBdKQ0KCWJ5IGJpeGJ5aXRlLnNnZS5uZXQgKFBvc3RmaXgp IHdpdGggRVNNVFAgaWQgNUZFOTNBNjQwMQ0KCWZvciA8QmVuLldlc3RnYXJ0 aEBmYWNzLmdvdi5hdT47IE1vbiwgMTUgT2N0IDIwMDEgMTA6MDk6NTEgKzEw MDAgKEVTVCkNClJlY2VpdmVkOiBmcm9tIG9saXZpbmU0LnNnZS5uZXQgKG9s aXZpbmU0LnNnZS5uZXQgWzEwLjEuMi4zM10pDQoJYnkga3J5cHRvbml0ZTIu c2dlLm5ldCAoUG9zdGZpeCkgd2l0aCBTTVRQIGlkIDc2Nzc2M0NGMTMNCglm b3IgPEJlbi5XZXN0Z2FydGhAZmFjcy5nb3YuYXU+OyBNb24sIDE1IE9jdCAy MDAxIDEwOjA5OjUxICsxMDAwIChFU1QpDQpSZWNlaXZlZDogRlJPTSBjb29w ZXJzLnNnZS5uZXQgQlkgb2xpdmluZTQuc2dlLm5ldCA7IE1vbiBPY3QgMTUg MTA6MDk6NTAgMjAwMSArMTAwMA0KUmVjZWl2ZWQ6IGJ5IGNvb3BlcnMuc2dl Lm5ldCAoUG9zdGZpeCwgZnJvbSB1c2VyaWQgNSkNCglpZCBFMDJBRjcxMjlE OyBNb24sIDE1IE9jdCAyMDAxIDEwOjEyOjUxICsxMDAwIChFU1QpDQpSZWNl aXZlZDogZnJvbSBub2Ruc3F1ZXJ5KDE1Mi45MS4xNC4yNikgYnkgYm9hZ3Mu c2dlLm5ldCB2aWEgY3NtYXAgKFY2LjApDQoJaWQgc3JjQUFBVTRhcUJNOyBN b24sIDE1IE9jdCAwMSAxMDoxMjo1MSArMTAwMA0KUmVjZWl2ZWQ6IGZyb20g cG9zdGdyZXNxbC5vcmcgKHdlYm1haWwucG9zdGdyZXNxbC5vcmcgWzIxNi4x MjYuODUuMjhdKQ0KCWJ5IGlvbGl0ZS5zZ2UubmV0IChQb3N0Zml4KSB3aXRo IEVTTVRQIGlkIDNDNDVGQkQxMg0KCWZvciA8QmVuLldlc3RnYXJ0aEBmYWNz Lmdvdi5hdT47IE1vbiwgMTUgT2N0IDIwMDEgMTA6MDk6NDggKzEwMDAgKEVT VCkNClJlY2VpdmVkOiBmcm9tIHBvc3RncmVzcWwub3JnICh3ZWJtYWlsLnBv c3RncmVzcWwub3JnIFsyMTYuMTI2Ljg1LjI4XSkNCglieSBwb3N0Z3Jlc3Fs Lm9yZyAoOC4xMS4zLzguMTEuNCkgd2l0aCBTTVRQIGlkIGY5RU5BZnIyODAx OTsNCglTdW4sIDE0IE9jdCAyMDAxIDE5OjEwOjQxIC0wNDAwIChFRFQpDQoJ KGVudmVsb3BlLWZyb20gcGdzcWwtcGhwLW93bmVyK002MTFAcG9zdGdyZXNx bC5vcmcpDQpSZWNlaXZlZDogZnJvbSB4cHJ0Lm5ldCAoWzIwOS4xMDIuMTI0 LjIwXSkNCglieSBwb3N0Z3Jlc3FsLm9yZyAoOC4xMS4zLzguMTEuNCkgd2l0 aCBFU01UUCBpZCBmOUVNb0VyMjQzNjcNCglmb3IgPHBnc3FsLXBocEBwb3N0 Z3Jlc3FsLm9yZz47IFN1biwgMTQgT2N0IDIwMDEgMTg6NTA6MTQgLTA0MDAg KEVEVCkNCgkoZW52ZWxvcGUtZnJvbSBob2RnZXNAeHBydC5uZXQpDQpSZWNl aXZlZDogZnJvbSByN20zajYgKHBkeC1wcHAxMzYucG9wMS5uZXQgWzIwOS4x MDIuMTI1LjE4Nl0pDQoJYnkgeHBydC5uZXQgKDguOS4zLzguOS4zL0RlYmlh biA4LjkuMy0yMSkgd2l0aCBFU01UUCBpZCBQQUEyMzUwNw0KCWZvciA8cGdz cWwtcGhwQHBvc3RncmVzcWwub3JnPjsgU3VuLCAxNCBPY3QgMjAwMSAxNTo1 MDowMyAtMDcwMA0KWC1BdXRoZW50aWNhdGlvbi1XYXJuaW5nOiB4cHJ0Lm5l dDogSG9zdCBwZHgtcHBwMTM2LnBvcDEubmV0IFsyMDkuMTAyLjEyNS4xODZd IGNsYWltZWQgdG8gYmUgcjdtM2o2DQpGcm9tOiBob2RnZXNAeHBydC5uZXQN ClRvOiBwZ3NxbC1waHBAcG9zdGdyZXNxbC5vcmcNCkRhdGU6IFN1biwgMTQg T2N0IDIwMDEgMTU6NTA6MjAgLTA3MDANCk1JTUUtVmVyc2lvbjogMS4wDQpD b250ZW50LXR5cGU6IHRleHQvcGxhaW47IGNoYXJzZXQ9VVMtQVNDSUkNCkNv bnRlbnQtdHJhbnNmZXItZW5jb2Rpbmc6IDdCSVQNClN1YmplY3Q6IFtQSFBd IGVuY3J5cHRpb24gZm9yIHBvc3RncmVzDQpNZXNzYWdlLUlEOiA8M0JDOUI0 M0MuODk3MS5DQTNEQUZAbG9jYWxob3N0Pg0KWC1tYWlsZXI6IFBlZ2FzdXMg TWFpbCBmb3IgV2luMzIgKHYzLjEyYykNClByZWNlZGVuY2U6IGJ1bGsNClNl bmRlcjogcGdzcWwtcGhwLW93bmVyQHBvc3RncmVzcWwub3JnDQoNCkkgbmVl ZCB0byBzYXZlIHVzZXIgaWRzIGFuZCBwYXNzd29yZHMgdG8gYmUgdXNlZCBm b3IgYWNjZXNzDQp0byByZWNvcmRzIGluIGEgZGF0YWJhc2UuICBUaGUgcGFz c3dvcmRzIHNob3VsZCBiZSBlbmNyeXB0ZWQNCmJlZm9yZSBzYXZpbmcuICBB cmUgdGhlcmUgYnVpbHRpbiBvciBzdGFuZGFyZCBwaHAgZnVuY3Rpb25zDQp0 byBkbyBlbmNyeXB0aW9uL2RlY3J5cHRpb24gb3IgZG9lcyBvbmUgbmVlZCB0 byBhZGQgYSBsaWJyYXJ5DQp0byBhIHN0YW5kYXJkIHBocCBpbnN0YWxsIChS ZWRIYXQgNy4xKS4NCg0KQ2hlZXJzLCBUb20NClRvbSBIb2RnZXMsIGhvZGdl c0B4cHJ0Lm5ldCBvciB0b21faG9kZ2VzQHlhaG9vLmNvbQ0KSUNRIDEwMTQ5 NjIxLCBZYWhvb01lc3NlbmdlciB0b21faG9kZ2VzDQpNYWlsOiAxNDMxNCBT VyBBbGxlbiBCbHZkLCAjMzE3OyBCZWF2ZXJ0b24gT1IgOTcwMDUgVVNBDQoN Ci0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLShlbmQgb2YgYnJvYWRjYXN0 KS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KVElQIDM6IGlmIHBvc3Rp bmcvcmVhZGluZyB0aHJvdWdoIFVzZW5ldCwgcGxlYXNlIHNlbmQgYW4gYXBw cm9wcmlhdGUNCnN1YnNjcmliZS1ub21haWwgY29tbWFuZCB0byBtYWpvcmRv bW9AcG9zdGdyZXNxbC5vcmcgc28gdGhhdCB5b3VyDQptZXNzYWdlIGNhbiBn ZXQgdGhyb3VnaCB0byB0aGUgbWFpbGluZyBsaXN0IGNsZWFubHkNCg== --0__=D4DGsWJJ4IGqcpFFtFmPFPLDyqQJlQ5StqWfHAiRCVigD7iny5UnRXR8--