Re: postgresql-socket md5 auth
Kevin Rosenberg <kevin-HJRc7zDS/[email protected]> Wed, 12 Aug 2015 19:13:08 -0600
| Newsgroups | gmane.lisp.clsql.general |
|---|---|
| Message-ID | <[email protected]> |
VGhhbmsgeW91IGZvciB5b3VyIHJlcG9ydCBhbmQgcGF0Y2guIEnigJlsbCByZXZpZXcgYW5kIGNv bW1pdCBmb3IgdGhlIG5leHQgcmVsZWFzZSBvZiBDTFNRTC4KCktldmluCgo+IE9uIEF1ZyAxMiwg MjAxNSwgYXQgNjozMyBQTSwgSmFzb24gTWVsYnllIDxqYXNvbi5tZWxieWVAZ21haWwuY29tPiB3 cm90ZToKPiAKPiBIZWxsbywKPiAKPiAoQXBvbG9naWVzIGlmIHRoaXMgY29tZXMgdGhyb3VnaCB0 d2ljZS4gIEkgd2FzIHNvIGVhZ2VyIGxhc3QgbmlnaHQsIEkKPiBiZWxpZXZlIEkgc2VudCBteSBt ZXNzYWdlIGJlZm9yZSBiZWluZyBmdWxseSByZWdpc3RlcmVkIG9uIHRoZSBtYWlsCj4gbGlzdC4p Cj4gCj4gSSByZWNlbnRseSBzdGFydGVkIHBsYXlpbmcgd2l0aCBjbHNxbC4gIEkgd2FzIHVuYWJs ZSB0byBjb25uZWN0IHRvIGEKPiBwb3N0Z3JlcyBkYXRhYmFzZSB1c2luZyBtZDUgYXV0aCBhbmQg dGhlIHBvc3RncmVzcWwtc29ja2V0IGJhY2tlbmQuCj4gCj4gVGhlIGlzc3VlIGFwcGVhcnMgdG8g YmUgd2l0aCBob3cgbWQ1c3VtLXN0cmluZyBjb252ZXJ0cyBmcm9tIGEgc3RyaW5nIHRvCj4gYnl0 ZXMuICBJbiB0aGUgYmFja2VuZCwgdGhlIDQtYnl0ZSBzYWx0IGlzIGNvbnZlcnRlZCB0byBhIHN0 cmluZyBhbmQKPiB1c2VkIHdpdGggbWQ1c3VtLXN0cmluZy4gIG1kNXN1bS1zdHJpbmcncyByZXN1 bHRzIHN1Z2dlc3Qgd2hlbiB0aGUKPiBmdW5jdGlvbiBjb252ZXJ0cyB0aGUgc3RyaW5nIGJhY2sg aW50byBieXRlcywgaXQgbWF5IGluc2VydCBhZGRpdGlvbmFsCj4gdW5pY29kZSBieXRlcywgY2F1 c2luZyB0aGUgaGFzaCB0byBub3QgbWF0Y2ggd2hhdCB0aGUgZGF0YWJhc2UgaXMKPiBleHBlY3Rp bmcuCj4gCj4gVGhlIGZvbGxvd2luZyBleGFtcGxlIGlsbHVzdHJhdGVzIHRoZSBpc3N1ZToKPiAK PiA7IFRoaXMgaXMgaG93IGEgNCBieXRlIHNlcXVlbmNlIHdvdWxkIGhhc2g6Cj4gQ0wtVVNFUj4g KG1kNTptZDVzdW0tc2VxdWVuY2UgKG1hcCAnKHZlY3RvciAodW5zaWduZWQtYnl0ZSA4KSkgIydp ZGVudGl0eSAnKDE4NyAxMTIgMTY3IDc0KSkpCj4gPT4gIygyMTcgMTM5IDE2MCAxNzkgNDIgMTE1 IDcyIDI0MCAxMzAgNzEgMjUzIDIxOSA1MCAxNyAyOSAxNTEpCj4gCj4gOyBDb252ZXJ0aW5nIHRo ZSBzZXF1ZW5jZSB0byBhIHN0cmluZyBhbmQgaGFzaGluZyBpcyBub3QgdGhlIHNhbWU6Cj4gQ0wt VVNFUj4gKG1kNTptZDVzdW0tc3RyaW5nIChtYXAgJ3N0cmluZyAjJ2NvZGUtY2hhciAnKDE4NyAx MTIgMTY3IDc0KSkpCj4gPT4gIygyNDQgMTA3IDU0IDIzOSAyMzUgMTcgMTY3IDIwNSA0IDE3OCA0 NSAxNDIgODggMTI3IDgxIDIzNykKPiAKPiA7IFdoYXQgY291bGQgaXQgYmUgZG9pbmcgZGlmZmVy ZW50bHk/ICBMZXQncyBzZWUgaG93IHRoZSBzdHJpbmcKPiA7IGNvbnZlcnRzIGJhY2sgaW50byBi eXRlczoKPiBDTC1VU0VSPiAodHJpdmlhbC11dGYtODpzdHJpbmctdG8tdXRmLTgtYnl0ZXMgKG1h cCAnc3RyaW5nICMnY29kZS1jaGFyICcoMTg3IDExMiAxNjcgNzQpKSkKPiA9PiAjKDE5NCAxODcg MTEyIDE5NCAxNjcgNzQpCj4gCj4gOyBXZSBjYW4gdmVyaWZ5IG1kNXN0cmluZyBkb2VzIHRoaXMs IHdoaWNoIHdlIGRvbid0IHdhbnQ6Cj4gQ0wtVVNFUj4gKG1kNTptZDVzdW0tc2VxdWVuY2UgKG1h cCAnKHZlY3RvciAodW5zaWduZWQtYnl0ZSA4KSkgIydpZGVudGl0eSAnKDE5NCAxODcgMTEyIDE5 NCAxNjcgNzQpKSkKPiA9PiAjKDI0NCAxMDcgNTQgMjM5IDIzNSAxNyAxNjcgMjA1IDQgMTc4IDQ1 IDE0MiA4OCAxMjcgODEgMjM3KQo+IAo+IEJlbG93IGlzIGEgcGF0Y2ggdGhhdCB3b3JrcyBmb3Ig bWUgbG9jYWxseS4gIEZvciB0aGUgc2Vjb25kICJwYXNzIiBvZgo+IHRoZSBtZDUgaGFzaGluZywg SSBrZWVwIHRoZSBzYWx0IHN0b3JlZCBhcyBieXRlcyBhbmQgdXNlIG1kNXN1bS1zZXF1ZW5jZQo+ IGluc3RlYWQgb2YgLXN0cmluZy4KPiAKPiBKYXNvbgo+IAo+IAo+IC0tLSBkYi1wb3N0Z3Jlc3Fs LXNvY2tldC9wb3N0Z3Jlc3FsLXNvY2tldC1hcGkubGlzcC5vcmlnaW5hbAkyMDE1LTA4LTExIDIy OjI2OjQ0LjE0NTgyMDQxNiAtMDUwMAo+ICsrKyBkYi1wb3N0Z3Jlc3FsLXNvY2tldC9wb3N0Z3Jl c3FsLXNvY2tldC1hcGkubGlzcAkyMDE1LTA4LTExIDIzOjA4OjI3Ljg4Mjk5OTUwNiAtMDUwMAo+ IEBAIC0yMzQsMTAgKzIzNCwyMSBAQAo+ICAgKGludDMyIHBpZCkKPiAgIChpbnQzMiBrZXkpKQo+ IAo+ICs7IFBsdWNrZWQgZnJvbSBjbC1wb3N0Z3Jlcwo+ICsoZGVmdW4gcmVhZC1ieXRlcyAoc29j a2V0IGxlbmd0aCkKPiArICAiUmVhZCBhIGJ5dGUgYXJyYXkgb2YgdGhlIGdpdmVuIGxlbmd0aCBm cm9tIGEgc3RyZWFtLiIKPiArICA7KGRlY2xhcmUgKHR5cGUgc3RyZWFtIHNvY2tldCkKPiArICA7 ICAgICAgICAgKHR5cGUgZml4bnVtIGxlbmd0aCkKPiArICA7ICAgICAgICAgIy4qb3B0aW1pemUq KQo+ICsgIChsZXQgKChyZXN1bHQgKG1ha2UtYXJyYXkgbGVuZ3RoIDplbGVtZW50LXR5cGUgJyh1 bnNpZ25lZC1ieXRlIDgpKSkpCj4gKyAgICAocmVhZC1zZXF1ZW5jZSByZXN1bHQgc29ja2V0KQo+ ICsgICAgcmVzdWx0KSkKPiArCj4gCj4gKGRlZnVuIHJlYWQtc29ja2V0LXNlcXVlbmNlIChzdHJl YW0gbGVuZ3RoICZvcHRpb25hbCAoYWxsb3ctd2lkZSB0KSkKPiAtICAoZGVjbGFyZSAoc3RyZWFt IHN0cmVhbSkKPiAtICAgICAgICAgICAob3B0aW1pemUgKHNwZWVkIDMpIChzYWZldHkgMCkpKQo+ ICsgIChicmVhaykKPiArICA7KGRlY2xhcmUgKHN0cmVhbSBzdHJlYW0pCj4gKyAgOyAgICAgICAg IChvcHRpbWl6ZSAoc3BlZWQgMykgKHNhZmV0eSAwKSkpCj4gICAjLShvciBzYi11bmljb2RlIGNj bCkKPiAgIChsZXQgKChyZXN1bHQgKG1ha2Utc3RyaW5nIGxlbmd0aCkpKQo+ICAgICAoZG90aW1l cyAoaSBsZW5ndGggcmVzdWx0KQo+IEBAIC0yNTQsNiArMjY1LDggQEAKPiAgIChsZXQgKChieXRl cyAobWFrZS1hcnJheSBsZW5ndGggOmVsZW1lbnQtdHlwZSAnKHVuc2lnbmVkLWJ5dGUgOCkpKSkK PiAgICAgKGRlY2xhcmUgKHR5cGUgKHNpbXBsZS1hcnJheSAodW5zaWduZWQtYnl0ZSA4KSAoKikp IGJ5dGVzKSkKPiAgICAgKHJlYWQtc2VxdWVuY2UgYnl0ZXMgc3RyZWFtKQo+ICsgICAgKGZvcm1h dCB0ICJhbGxvdy13aWRlOiB+YX4lIiBhbGxvdy13aWRlKQo+ICsgICAgKGZvcm1hdCB0ICJieXRl czogfmF+JSIgYnl0ZXMpCj4gICAgIChpZiBhbGxvdy13aWRlCj4gICAgICAgICAoc2ItZXh0Om9j dGV0cy10by1zdHJpbmcgYnl0ZXMpCj4gICAgICAgICAobWFwICdzdHJpbmcgIydjb2RlLWNoYXIg Ynl0ZXMpKSkpCj4gQEAgLTQ4NywxMCArNTAwLDIxIEBACj4gICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIDpkYXRhYmFzZSBkYXRhYmFzZSA6dXNlciB1c2VyCj4gICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIDpwYXNzd29yZCAob3IgcGFzc3dvcmQgIiIpKSkpCj4gCj4gLShkZWZ1 biBlbmNyeXB0LW1kNSAocGxhaW50ZXh0IHNhbHQpCj4gLSAgKHN0cmluZy1kb3duY2FzZQo+IC0g ICAoZm9ybWF0IG5pbCAifnt+MiwnMFh+fSIKPiAtICAgICAgICAgICAoY29lcmNlIChtZDVzdW0t c3RyaW5nIChjb25jYXRlbmF0ZSAnc3RyaW5nIHBsYWludGV4dCBzYWx0KSkgJ2xpc3QpKSkpCj4g KzsoZGVmdW4gZW5jcnlwdC1tZDUgKHBsYWludGV4dCBzYWx0KQo+ICs7ICAoc3RyaW5nLWRvd25j YXNlCj4gKzsgICAoZm9ybWF0IG5pbCAifnt+MiwnMFh+fSIKPiArOyAgICAgICAgICAgKGNvZXJj ZSAobWQ1c3VtLXN0cmluZyAoY29uY2F0ZW5hdGUgJ3N0cmluZyBwbGFpbnRleHQgc2FsdCkpICds aXN0KSkpKQo+ICsKPiArKGRlZnVuIGJ5dGUtc2VxdWVuY2UtdG8taGV4LXN0cmluZyAoc2VxdWVu Y2UpCj4gKyAgKHN0cmluZy1kb3duY2FzZSAoZm9ybWF0IG5pbCAifnt+MiwnMFh+fSIgKGNvZXJj ZSBzZXF1ZW5jZSAnbGlzdCkpKSkKPiArCj4gKyhkZWZ1biBlbmNyeXB0LXBhc3N3b3JkLW1kNSAo cGFzc3dvcmQgdXNlciBzYWx0KQo+ICsgIChsZXQgKChwYXNzMSAoYnl0ZS1zZXF1ZW5jZS10by1o ZXgtc3RyaW5nCj4gKwkJKG1kNXN1bS1zdHJpbmcgKGNvbmNhdGVuYXRlICdzdHJpbmcgcGFzc3dv cmQgdXNlcikpKSkpCj4gKyAgICAoYnl0ZS1zZXF1ZW5jZS10by1oZXgtc3RyaW5nCj4gKyAgICAg KG1kNXN1bS1zZXF1ZW5jZSAoY29uY2F0ZW5hdGUgJyh2ZWN0b3IgKHVuc2lnbmVkLWJ5dGUgOCkp Cj4gKwkJCQkgICAobWFwICcodmVjdG9yICh1bnNpZ25lZC1ieXRlIDgpKSAjJ2NoYXItY29kZSBw YXNzMSkKPiArCQkJCSAgIHNhbHQpKSkpKQo+IAo+IChkZWZ1biByZW9wZW4tcG9zdGdyZXNxbC1j b25uZWN0aW9uIChjb25uZWN0aW9uKQo+ICAgIlJlb3BlbiB0aGUgZ2l2ZW4gUG9zdGdyZVNRTCBj b25uZWN0aW9uLiAgQ2xvc2VzIGFueSBleGlzdGluZwo+IEBAIC01MzIsMTEgKzU1NiwxMSBAQAo+ ICAgICAgICAgICAgICAgICAgICAgICAgICAocG9zdGdyZXNxbC1jb25uZWN0aW9uLXBhc3N3b3Jk IGNvbm5lY3Rpb24pIHNhbHQpKSkKPiAgICAgICAgICAgICAgICAgICAgICAoZm9yY2Utb3V0cHV0 IHNvY2tldCkpCj4gICAgICAgICAgICAgICAgICAgICAoNQo+IC0JCSAgICAgKGJyZWFrKQo+IC0g ICAgICAgICAgICAgICAgICAgICAobGV0ICgoc2FsdCAocmVhZC1zb2NrZXQtc2VxdWVuY2Ugc29j a2V0IDQgbmlsKSkpCj4gLSAgICAgICAgICAgICAgICAgICAgICAgKGxldCogKChwd2QyIChlbmNy eXB0LW1kNSAocG9zdGdyZXNxbC1jb25uZWN0aW9uLXBhc3N3b3JkIGNvbm5lY3Rpb24pCj4gLSAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAocG9zdGdyZXNx bC1jb25uZWN0aW9uLXVzZXIgY29ubmVjdGlvbikpKQo+IC0gICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAocHdkIChlbmNyeXB0LW1kNSBwd2QyIHNhbHQpKSkKPiArICAgICAgICAgICAgICAg ICAgICAgKGxldCAoKHNhbHQgKHJlYWQtYnl0ZXMgc29ja2V0IDQpKSkKPiArICAgICAgICAgICAg ICAgICAgICAgICAobGV0ICgocHdkIChlbmNyeXB0LXBhc3N3b3JkLW1kNQo+ICsJCQkJICAgKHBv c3RncmVzcWwtY29ubmVjdGlvbi1wYXNzd29yZCBjb25uZWN0aW9uKQo+ICsJCQkJICAgKHBvc3Rn cmVzcWwtY29ubmVjdGlvbi11c2VyIGNvbm5lY3Rpb24pCj4gKwkJCQkgICBzYWx0KSkpCj4gICAg ICAgICAgICAgICAgICAgICAgICAgIChzZW5kLWVuY3J5cHRlZC1wYXNzd29yZC1tZXNzYWdlCj4g ICAgICAgICAgICAgICAgICAgICAgICAgICBzb2NrZXQKPiAgICAgICAgICAgICAgICAgICAgICAg ICAgIChjb25jYXRlbmF0ZSAnc3RyaW5nICJtZDUiIHB3ZCkpKSkKPiBfX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwo+IENMU1FMIG1haWxpbmcgbGlzdAo+IENM U1FMQGI5LmNvbQo+IGh0dHA6Ly9saXN0cy5iOS5jb20vY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZv L2Nsc3FsCj4gCgoKX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X18KQ0xTUUwgbWFpbGluZyBsaXN0CkNMU1FMQGI5LmNvbQpodHRwOi8vbGlzdHMuYjkuY29tL2Nn aS1iaW4vbWFpbG1hbi9saXN0aW5mby9jbHNxbAo=