Received: from iolite.sge.net (iolite.sge.net [152.91.14.26]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9P5MhP77736 for ; Thu, 25 Oct 2001 01:22:43 -0400 (EDT) (envelope-from Ben.Westgarth@facs.gov.au) Received: from kryptonite2.sge.net (unknown [152.91.9.15]) by iolite.sge.net (Postfix) with ESMTP id 08E90BD7D for ; Thu, 25 Oct 2001 15:22:40 +1000 (EST) Received: from olivine4.sge.net (olivine4.sge.net [10.1.2.33]) by kryptonite2.sge.net (Postfix) with SMTP id 027C73CF02 for ; Thu, 25 Oct 2001 15:22:40 +1000 (EST) Received: FROM cascade.sge.net BY olivine4.sge.net ; Thu Oct 25 15:22:39 2001 +1000 Received: by cascade.sge.net (Postfix, from userid 5) id A992242947; Thu, 25 Oct 2001 15:25:02 +1000 (EST) Received: from nodnsquery(172.16.151.1) by cascade.sge.net via csmap (V6.0) id srcAAABuayxL; Thu, 25 Oct 01 15:25:02 +1000 Received: from facs.gov.au (unknown [10.18.20.57]) by bixbyite.sge.net (Postfix) with SMTP id 5EFF0A6408; Thu, 25 Oct 2001 15:22:38 +1000 (EST) Received: by facs.gov.au(Lotus SMTP MTA v4.6.7 (934.1 12-30-1999)) id CA256AF0.001DC140 ; Thu, 25 Oct 2001 15:25:00 +1000 X-Lotus-FromDomain: FACS From: Ben.Westgarth@facs.gov.au To: "Dan Wilson" Cc: pgsql-php@postgresql.org, "Mo Holkar" Message-ID: Date: Thu, 25 Oct 2001 15:20:44 +1000 Subject: Re: Security Mime-Version: 1.0 Content-type: multipart/mixed; Boundary="0__=FKKjzZSDe56p0GRKQFVbFsrpFa7DxRYwYjlvXPZj6ZubMzC8cNnkief5" Content-Disposition: inline X-Archive-Number: 200110/85 X-Sequence-Number: 638 --0__=FKKjzZSDe56p0GRKQFVbFsrpFa7DxRYwYjlvXPZj6ZubMzC8cNnkief5 Content-type: text/plain; charset=us-ascii Content-Disposition: inline Also, check out: (again not specific to pgsql) a brief introductory article to the whole mish mash of security issues... http://www.onlamp.com/pub/a/php/2001/03/29/php_admin.html from the php manual itself... http://www.php.net/manual/en/security.php Cheers, Ben Westgarth "Dan Wilson" on 25/10/2001 14:02:43 To: pgsql-php@postgresql.org, "Mo Holkar" cc: (bcc: Ben Westgarth/User/FaCS) Subject: Re: [PHP] Security Here are some general security links, but nothing specific to pgsql/php. Web Perversion "Hacking" Demo (Interesting!) http://www.sanctuminc.com/demo/hacking_demo_v1200.html Best Practices for Secure Web Development (PDF) http://members.home.net/razvan.peteanu/best_prac_for_sec_dev4.pdf "How I Hacked PacketStorm" (about SQL injection) http://www.wiretrip.net/rfp/p/doc.asp?id=42&iface=2 -Dan : Hi all, : : Can anyone recommend a good book or online source discussing security : issues in pgsql/php? : : Thanks, : : Mo ---------------------------(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__=FKKjzZSDe56p0GRKQFVbFsrpFa7DxRYwYjlvXPZj6ZubMzC8cNnkief5 Content-type: application/octet-stream; name="att1.eml" Content-Disposition: attachment; filename="att1.eml" Content-transfer-encoding: base64 UmVjZWl2ZWQ6IGZyb20gYml4YnlpdGUuc2dlLm5ldCAoWzEwLjE4LjkuMV0p IGJ5IGZhY3MuZ292LmF1IChMb3R1cyBTTVRQIE1UQSB2NC42LjcgICg5MzQu MSAxMi0zMC0xOTk5KSkgd2l0aCBTTVRQIGlkIENBMjU2QUYwLjAwMUEzNEU1 OyBUaHUsIDI1IE9jdCAyMDAxIDE0OjQ2OjE0ICsxMDAwDQpSZWNlaXZlZDog ZnJvbSBrdWxhbml0ZS5zZ2UubmV0IChrdWxhbml0ZTIuc2dlLm5ldCBbMTAu MS4yLjIyXSkNCglieSBiaXhieWl0ZS5zZ2UubmV0IChQb3N0Zml4KSB3aXRo IEVTTVRQIGlkIDkzOUM0QTY0MDUNCglmb3IgPEJlbi5XZXN0Z2FydGhAZmFj cy5nb3YuYXU+OyBUaHUsIDI1IE9jdCAyMDAxIDE0OjQzOjUxICsxMDAwIChF U1QpDQpSZWNlaXZlZDogZnJvbSB0aG9yaXVtMi5zZ2UubmV0ICh0aG9yaXVt Mi5zZ2UubmV0IFsxMC4xLjIuMzZdKQ0KCWJ5IGt1bGFuaXRlLnNnZS5uZXQg KFBvc3RmaXgpIHdpdGggU01UUCBpZCBCQTJEMjNCMTBGDQoJZm9yIDxCZW4u V2VzdGdhcnRoQGZhY3MuZ292LmF1PjsgVGh1LCAyNSBPY3QgMjAwMSAxNDo0 Mzo1MSArMTAwMCAoRVNUKQ0KUmVjZWl2ZWQ6IEZST00gY2FzY2FkZS5zZ2Uu bmV0IEJZIHRob3JpdW0yLnNnZS5uZXQgOyBUaHUgT2N0IDI1IDE0OjQzOjUx IDIwMDEgKzEwMDANClJlY2VpdmVkOiBieSBjYXNjYWRlLnNnZS5uZXQgKFBv c3RmaXgsIGZyb20gdXNlcmlkIDUpDQoJaWQgOEQ2NzQ0Mjk0ODsgVGh1LCAy NSBPY3QgMjAwMSAxNDo0NjoxNCArMTAwMCAoRVNUKQ0KUmVjZWl2ZWQ6IGZy b20gbm9kbnNxdWVyeSgxNTIuOTEuMTQuMjUpIGJ5IGNhc2NhZGUuc2dlLm5l dCB2aWEgY3NtYXAgKFY2LjApDQoJaWQgc3JjQUFBU1BhcTd3OyBUaHUsIDI1 IE9jdCAwMSAxNDo0NjoxMyArMTAwMA0KUmVjZWl2ZWQ6IGZyb20gcG9zdGdy ZXNxbC5vcmcgKHdlYm1haWwucG9zdGdyZXNxbC5vcmcgWzIxNi4xMjYuODUu MjhdKQ0KCWJ5IGF2ZW50dXJpbmUuc2dlLm5ldCAoOC45LjMvOC45LjMpIHdp dGggRVNNVFAgaWQgT0FBNTg3NjYNCglmb3IgPEJlbi5XZXN0Z2FydGhAZmFj cy5nb3YuYXU+OyBUaHUsIDI1IE9jdCAyMDAxIDE0OjQzOjM5ICsxMDAwIChF U1QpDQpSZWNlaXZlZDogZnJvbSBwb3N0Z3Jlc3FsLm9yZyAod2VibWFpbC5w b3N0Z3Jlc3FsLm9yZyBbMjE2LjEyNi44NS4yOF0pDQoJYnkgcG9zdGdyZXNx bC5vcmcgKDguMTEuMy84LjExLjQpIHdpdGggU01UUCBpZCBmOVA0RXdQNTkw MjE7DQoJVGh1LCAyNSBPY3QgMjAwMSAwMDoxNTowMiAtMDQwMCAoRURUKQ0K CShlbnZlbG9wZS1mcm9tIHBnc3FsLXBocC1vd25lcitNNjM3QHBvc3RncmVz cWwub3JnKQ0KUmVjZWl2ZWQ6IGZyb20gbWFpbC5maWJlci5uZXQgKG1haWwu ZmliZXIubmV0IFsyMTYuODMuMTMwLjRdKQ0KCWJ5IHBvc3RncmVzcWwub3Jn ICg4LjExLjMvOC4xMS40KSB3aXRoIEVTTVRQIGlkIGY5UDQ0RFA1NjU4NA0K CWZvciA8cGdzcWwtcGhwQHBvc3RncmVzcWwub3JnPjsgVGh1LCAyNSBPY3Qg MjAwMSAwMDowNDoxMyAtMDQwMCAoRURUKQ0KCShlbnZlbG9wZS1mcm9tIHBo cFBnQWRtaW5AYWN1Y29yZS5jb20pDQpSZWNlaXZlZDogZnJvbSBkYW53aWxz b24gKGJidWRuaWNrLmVtcGxveWVlcy5maWJlci5uZXQgWzIxNi44My4xMzEu N10pDQoJYnkgbWFpbC5maWJlci5uZXQgKDguMTEuMy84LjExLjMpIHdpdGgg U01UUCBpZCBmOVA0NEI0MjA3NDY7DQoJV2VkLCAyNCBPY3QgMjAwMSAyMjow NDoxMSAtMDYwMCAoTURUKQ0KTWVzc2FnZS1JRDogPDAwNjEwMWMxNWQwOSRl NmVjMDFjMCQwNzgzNTNkOEBkYW53aWxzb24+DQpGcm9tOiAiRGFuIFdpbHNv biIgPHBocFBnQWRtaW5AYWN1Y29yZS5jb20+DQpUbzogPHBnc3FsLXBocEBw b3N0Z3Jlc3FsLm9yZz4sDQoJIk1vIEhvbGthciIgPHBnc3FsQGRpZ2l0YWxt aW5kZ2FtZXMuY29tPg0KUmVmZXJlbmNlczogPDUuMS4wLjE0LjIuMjAwMTEw MjQxNzUyMjkuMDRkYWZlYTBAcG9wLm50bHdvcmxkLmNvbT4NClN1YmplY3Q6 IFJlOiBbUEhQXSBTZWN1cml0eQ0KRGF0ZTogV2VkLCAyNCBPY3QgMjAwMSAy MjowMjo0MyAtMDYwMA0KTUlNRS1WZXJzaW9uOiAxLjANCkNvbnRlbnQtVHlw ZTogdGV4dC9wbGFpbjsNCgljaGFyc2V0PSJpc28tODg1OS0xIg0KQ29udGVu dC1UcmFuc2Zlci1FbmNvZGluZzogN2JpdA0KWC1Qcmlvcml0eTogMw0KWC1N U01haWwtUHJpb3JpdHk6IE5vcm1hbA0KWC1NYWlsZXI6IE1pY3Jvc29mdCBP dXRsb29rIEV4cHJlc3MgNS41MC40NTIyLjEyMDANClgtTWltZU9MRTogUHJv ZHVjZWQgQnkgTWljcm9zb2Z0IE1pbWVPTEUgVjUuNTAuNDUyMi4xMjAwDQpQ cmVjZWRlbmNlOiBidWxrDQpTZW5kZXI6IHBnc3FsLXBocC1vd25lckBwb3N0 Z3Jlc3FsLm9yZw0KDQpIZXJlIGFyZSBzb21lIGdlbmVyYWwgc2VjdXJpdHkg bGlua3MsIGJ1dCBub3RoaW5nIHNwZWNpZmljIHRvIHBnc3FsL3BocC4NCg0K V2ViIFBlcnZlcnNpb24gIkhhY2tpbmciIERlbW8gKEludGVyZXN0aW5nISkN Cmh0dHA6Ly93d3cuc2FuY3R1bWluYy5jb20vZGVtby9oYWNraW5nX2RlbW9f djEyMDAuaHRtbA0KDQpCZXN0IFByYWN0aWNlcyBmb3IgU2VjdXJlIFdlYiBE ZXZlbG9wbWVudCAoUERGKQ0KaHR0cDovL21lbWJlcnMuaG9tZS5uZXQvcmF6 dmFuLnBldGVhbnUvYmVzdF9wcmFjX2Zvcl9zZWNfZGV2NC5wZGYNCg0KIkhv dyBJIEhhY2tlZCBQYWNrZXRTdG9ybSIgKGFib3V0IFNRTCBpbmplY3Rpb24p DQpodHRwOi8vd3d3LndpcmV0cmlwLm5ldC9yZnAvcC9kb2MuYXNwP2lkPTQy JmlmYWNlPTINCg0KLURhbg0KDQoNCg0KOiBIaSBhbGwsDQo6IA0KOiBDYW4g YW55b25lIHJlY29tbWVuZCBhIGdvb2QgYm9vayBvciBvbmxpbmUgc291cmNl IGRpc2N1c3Npbmcgc2VjdXJpdHkgDQo6IGlzc3VlcyBpbiBwZ3NxbC9waHA/ DQo6IA0KOiBUaGFua3MsDQo6IA0KOiBNbw0KDQoNCg0KLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tKGVuZCBvZiBicm9hZGNhc3QpLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tDQpUSVAgMzogaWYgcG9zdGluZy9yZWFkaW5nIHRo cm91Z2ggVXNlbmV0LCBwbGVhc2Ugc2VuZCBhbiBhcHByb3ByaWF0ZQ0Kc3Vi c2NyaWJlLW5vbWFpbCBjb21tYW5kIHRvIG1ham9yZG9tb0Bwb3N0Z3Jlc3Fs Lm9yZyBzbyB0aGF0IHlvdXINCm1lc3NhZ2UgY2FuIGdldCB0aHJvdWdoIHRv IHRoZSBtYWlsaW5nIGxpc3QgY2xlYW5seQ0K --0__=FKKjzZSDe56p0GRKQFVbFsrpFa7DxRYwYjlvXPZj6ZubMzC8cNnkief5--