postgresql-socket md5 auth
Jason Melbye <[email protected]> Wed, 12 Aug 2015 19:33:17 -0500
| Newsgroups | gmane.lisp.clsql.general |
|---|---|
| Message-ID | <[email protected]> |
SGVsbG8sCgooQXBvbG9naWVzIGlmIHRoaXMgY29tZXMgdGhyb3VnaCB0d2ljZS4gIEkgd2FzIHNv IGVhZ2VyIGxhc3QgbmlnaHQsIEkKYmVsaWV2ZSBJIHNlbnQgbXkgbWVzc2FnZSBiZWZvcmUgYmVp bmcgZnVsbHkgcmVnaXN0ZXJlZCBvbiB0aGUgbWFpbApsaXN0LikKCkkgcmVjZW50bHkgc3RhcnRl ZCBwbGF5aW5nIHdpdGggY2xzcWwuICBJIHdhcyB1bmFibGUgdG8gY29ubmVjdCB0byBhCnBvc3Rn cmVzIGRhdGFiYXNlIHVzaW5nIG1kNSBhdXRoIGFuZCB0aGUgcG9zdGdyZXNxbC1zb2NrZXQgYmFj a2VuZC4KClRoZSBpc3N1ZSBhcHBlYXJzIHRvIGJlIHdpdGggaG93IG1kNXN1bS1zdHJpbmcgY29u dmVydHMgZnJvbSBhIHN0cmluZyB0bwpieXRlcy4gIEluIHRoZSBiYWNrZW5kLCB0aGUgNC1ieXRl IHNhbHQgaXMgY29udmVydGVkIHRvIGEgc3RyaW5nIGFuZAp1c2VkIHdpdGggbWQ1c3VtLXN0cmlu Zy4gIG1kNXN1bS1zdHJpbmcncyByZXN1bHRzIHN1Z2dlc3Qgd2hlbiB0aGUKZnVuY3Rpb24gY29u dmVydHMgdGhlIHN0cmluZyBiYWNrIGludG8gYnl0ZXMsIGl0IG1heSBpbnNlcnQgYWRkaXRpb25h bAp1bmljb2RlIGJ5dGVzLCBjYXVzaW5nIHRoZSBoYXNoIHRvIG5vdCBtYXRjaCB3aGF0IHRoZSBk YXRhYmFzZSBpcwpleHBlY3RpbmcuCgpUaGUgZm9sbG93aW5nIGV4YW1wbGUgaWxsdXN0cmF0ZXMg dGhlIGlzc3VlOgoKOyBUaGlzIGlzIGhvdyBhIDQgYnl0ZSBzZXF1ZW5jZSB3b3VsZCBoYXNoOgpD TC1VU0VSPiAobWQ1Om1kNXN1bS1zZXF1ZW5jZSAobWFwICcodmVjdG9yICh1bnNpZ25lZC1ieXRl IDgpKSAjJ2lkZW50aXR5ICcoMTg3IDExMiAxNjcgNzQpKSkKPT4gIygyMTcgMTM5IDE2MCAxNzkg NDIgMTE1IDcyIDI0MCAxMzAgNzEgMjUzIDIxOSA1MCAxNyAyOSAxNTEpCgo7IENvbnZlcnRpbmcg dGhlIHNlcXVlbmNlIHRvIGEgc3RyaW5nIGFuZCBoYXNoaW5nIGlzIG5vdCB0aGUgc2FtZToKQ0wt VVNFUj4gKG1kNTptZDVzdW0tc3RyaW5nIChtYXAgJ3N0cmluZyAjJ2NvZGUtY2hhciAnKDE4NyAx MTIgMTY3IDc0KSkpCj0+ICMoMjQ0IDEwNyA1NCAyMzkgMjM1IDE3IDE2NyAyMDUgNCAxNzggNDUg MTQyIDg4IDEyNyA4MSAyMzcpCgo7IFdoYXQgY291bGQgaXQgYmUgZG9pbmcgZGlmZmVyZW50bHk/ ICBMZXQncyBzZWUgaG93IHRoZSBzdHJpbmcKOyBjb252ZXJ0cyBiYWNrIGludG8gYnl0ZXM6CkNM LVVTRVI+ICh0cml2aWFsLXV0Zi04OnN0cmluZy10by11dGYtOC1ieXRlcyAobWFwICdzdHJpbmcg Iydjb2RlLWNoYXIgJygxODcgMTEyIDE2NyA3NCkpKQo9PiAjKDE5NCAxODcgMTEyIDE5NCAxNjcg NzQpCgo7IFdlIGNhbiB2ZXJpZnkgbWQ1c3RyaW5nIGRvZXMgdGhpcywgd2hpY2ggd2UgZG9uJ3Qg d2FudDoKQ0wtVVNFUj4gKG1kNTptZDVzdW0tc2VxdWVuY2UgKG1hcCAnKHZlY3RvciAodW5zaWdu ZWQtYnl0ZSA4KSkgIydpZGVudGl0eSAnKDE5NCAxODcgMTEyIDE5NCAxNjcgNzQpKSkKPT4gIygy NDQgMTA3IDU0IDIzOSAyMzUgMTcgMTY3IDIwNSA0IDE3OCA0NSAxNDIgODggMTI3IDgxIDIzNykK CkJlbG93IGlzIGEgcGF0Y2ggdGhhdCB3b3JrcyBmb3IgbWUgbG9jYWxseS4gIEZvciB0aGUgc2Vj b25kICJwYXNzIiBvZgp0aGUgbWQ1IGhhc2hpbmcsIEkga2VlcCB0aGUgc2FsdCBzdG9yZWQgYXMg Ynl0ZXMgYW5kIHVzZSBtZDVzdW0tc2VxdWVuY2UKaW5zdGVhZCBvZiAtc3RyaW5nLgoKSmFzb24K CgotLS0gZGItcG9zdGdyZXNxbC1zb2NrZXQvcG9zdGdyZXNxbC1zb2NrZXQtYXBpLmxpc3Aub3Jp Z2luYWwJMjAxNS0wOC0xMSAyMjoyNjo0NC4xNDU4MjA0MTYgLTA1MDAKKysrIGRiLXBvc3RncmVz cWwtc29ja2V0L3Bvc3RncmVzcWwtc29ja2V0LWFwaS5saXNwCTIwMTUtMDgtMTEgMjM6MDg6Mjcu ODgyOTk5NTA2IC0wNTAwCkBAIC0yMzQsMTAgKzIzNCwyMSBAQAogICAoaW50MzIgcGlkKQogICAo aW50MzIga2V5KSkKIAorOyBQbHVja2VkIGZyb20gY2wtcG9zdGdyZXMKKyhkZWZ1biByZWFkLWJ5 dGVzIChzb2NrZXQgbGVuZ3RoKQorICAiUmVhZCBhIGJ5dGUgYXJyYXkgb2YgdGhlIGdpdmVuIGxl bmd0aCBmcm9tIGEgc3RyZWFtLiIKKyAgOyhkZWNsYXJlICh0eXBlIHN0cmVhbSBzb2NrZXQpCisg IDsgICAgICAgICAodHlwZSBmaXhudW0gbGVuZ3RoKQorICA7ICAgICAgICAgIy4qb3B0aW1pemUq KQorICAobGV0ICgocmVzdWx0IChtYWtlLWFycmF5IGxlbmd0aCA6ZWxlbWVudC10eXBlICcodW5z aWduZWQtYnl0ZSA4KSkpKQorICAgIChyZWFkLXNlcXVlbmNlIHJlc3VsdCBzb2NrZXQpCisgICAg cmVzdWx0KSkKKwogCiAoZGVmdW4gcmVhZC1zb2NrZXQtc2VxdWVuY2UgKHN0cmVhbSBsZW5ndGgg Jm9wdGlvbmFsIChhbGxvdy13aWRlIHQpKQotICAoZGVjbGFyZSAoc3RyZWFtIHN0cmVhbSkKLSAg ICAgICAgICAgKG9wdGltaXplIChzcGVlZCAzKSAoc2FmZXR5IDApKSkKKyAgKGJyZWFrKQorICA7 KGRlY2xhcmUgKHN0cmVhbSBzdHJlYW0pCisgIDsgICAgICAgICAob3B0aW1pemUgKHNwZWVkIDMp IChzYWZldHkgMCkpKQogICAjLShvciBzYi11bmljb2RlIGNjbCkKICAgKGxldCAoKHJlc3VsdCAo bWFrZS1zdHJpbmcgbGVuZ3RoKSkpCiAgICAgKGRvdGltZXMgKGkgbGVuZ3RoIHJlc3VsdCkKQEAg LTI1NCw2ICsyNjUsOCBAQAogICAobGV0ICgoYnl0ZXMgKG1ha2UtYXJyYXkgbGVuZ3RoIDplbGVt ZW50LXR5cGUgJyh1bnNpZ25lZC1ieXRlIDgpKSkpCiAgICAgKGRlY2xhcmUgKHR5cGUgKHNpbXBs ZS1hcnJheSAodW5zaWduZWQtYnl0ZSA4KSAoKikpIGJ5dGVzKSkKICAgICAocmVhZC1zZXF1ZW5j ZSBieXRlcyBzdHJlYW0pCisgICAgKGZvcm1hdCB0ICJhbGxvdy13aWRlOiB+YX4lIiBhbGxvdy13 aWRlKQorICAgIChmb3JtYXQgdCAiYnl0ZXM6IH5hfiUiIGJ5dGVzKQogICAgIChpZiBhbGxvdy13 aWRlCiAgICAgICAgIChzYi1leHQ6b2N0ZXRzLXRvLXN0cmluZyBieXRlcykKICAgICAgICAgKG1h cCAnc3RyaW5nICMnY29kZS1jaGFyIGJ5dGVzKSkpKQpAQCAtNDg3LDEwICs1MDAsMjEgQEAKICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICA6ZGF0YWJhc2UgZGF0YWJhc2UgOnVzZXIgdXNl cgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDpwYXNzd29yZCAob3IgcGFzc3dvcmQg IiIpKSkpCiAKLShkZWZ1biBlbmNyeXB0LW1kNSAocGxhaW50ZXh0IHNhbHQpCi0gIChzdHJpbmct ZG93bmNhc2UKLSAgIChmb3JtYXQgbmlsICJ+e34yLCcwWH59IgotICAgICAgICAgICAoY29lcmNl IChtZDVzdW0tc3RyaW5nIChjb25jYXRlbmF0ZSAnc3RyaW5nIHBsYWludGV4dCBzYWx0KSkgJ2xp c3QpKSkpCis7KGRlZnVuIGVuY3J5cHQtbWQ1IChwbGFpbnRleHQgc2FsdCkKKzsgIChzdHJpbmct ZG93bmNhc2UKKzsgICAoZm9ybWF0IG5pbCAifnt+MiwnMFh+fSIKKzsgICAgICAgICAgIChjb2Vy Y2UgKG1kNXN1bS1zdHJpbmcgKGNvbmNhdGVuYXRlICdzdHJpbmcgcGxhaW50ZXh0IHNhbHQpKSAn bGlzdCkpKSkKKworKGRlZnVuIGJ5dGUtc2VxdWVuY2UtdG8taGV4LXN0cmluZyAoc2VxdWVuY2Up CisgIChzdHJpbmctZG93bmNhc2UgKGZvcm1hdCBuaWwgIn57fjIsJzBYfn0iIChjb2VyY2Ugc2Vx dWVuY2UgJ2xpc3QpKSkpCisKKyhkZWZ1biBlbmNyeXB0LXBhc3N3b3JkLW1kNSAocGFzc3dvcmQg dXNlciBzYWx0KQorICAobGV0ICgocGFzczEgKGJ5dGUtc2VxdWVuY2UtdG8taGV4LXN0cmluZwor CQkobWQ1c3VtLXN0cmluZyAoY29uY2F0ZW5hdGUgJ3N0cmluZyBwYXNzd29yZCB1c2VyKSkpKSkK KyAgICAoYnl0ZS1zZXF1ZW5jZS10by1oZXgtc3RyaW5nCisgICAgIChtZDVzdW0tc2VxdWVuY2Ug KGNvbmNhdGVuYXRlICcodmVjdG9yICh1bnNpZ25lZC1ieXRlIDgpKQorCQkJCSAgIChtYXAgJyh2 ZWN0b3IgKHVuc2lnbmVkLWJ5dGUgOCkpICMnY2hhci1jb2RlIHBhc3MxKQorCQkJCSAgIHNhbHQp KSkpKQogCiAoZGVmdW4gcmVvcGVuLXBvc3RncmVzcWwtY29ubmVjdGlvbiAoY29ubmVjdGlvbikK ICAgIlJlb3BlbiB0aGUgZ2l2ZW4gUG9zdGdyZVNRTCBjb25uZWN0aW9uLiAgQ2xvc2VzIGFueSBl eGlzdGluZwpAQCAtNTMyLDExICs1NTYsMTEgQEAKICAgICAgICAgICAgICAgICAgICAgICAgICAo cG9zdGdyZXNxbC1jb25uZWN0aW9uLXBhc3N3b3JkIGNvbm5lY3Rpb24pIHNhbHQpKSkKICAgICAg ICAgICAgICAgICAgICAgIChmb3JjZS1vdXRwdXQgc29ja2V0KSkKICAgICAgICAgICAgICAgICAg ICAgKDUKLQkJICAgICAoYnJlYWspCi0gICAgICAgICAgICAgICAgICAgICAobGV0ICgoc2FsdCAo cmVhZC1zb2NrZXQtc2VxdWVuY2Ugc29ja2V0IDQgbmlsKSkpCi0gICAgICAgICAgICAgICAgICAg ICAgIChsZXQqICgocHdkMiAoZW5jcnlwdC1tZDUgKHBvc3RncmVzcWwtY29ubmVjdGlvbi1wYXNz d29yZCBjb25uZWN0aW9uKQotICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIChwb3N0Z3Jlc3FsLWNvbm5lY3Rpb24tdXNlciBjb25uZWN0aW9uKSkpCi0gICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAocHdkIChlbmNyeXB0LW1kNSBwd2QyIHNhbHQpKSkK KyAgICAgICAgICAgICAgICAgICAgIChsZXQgKChzYWx0IChyZWFkLWJ5dGVzIHNvY2tldCA0KSkp CisgICAgICAgICAgICAgICAgICAgICAgIChsZXQgKChwd2QgKGVuY3J5cHQtcGFzc3dvcmQtbWQ1 CisJCQkJICAgKHBvc3RncmVzcWwtY29ubmVjdGlvbi1wYXNzd29yZCBjb25uZWN0aW9uKQorCQkJ CSAgIChwb3N0Z3Jlc3FsLWNvbm5lY3Rpb24tdXNlciBjb25uZWN0aW9uKQorCQkJCSAgIHNhbHQp KSkKICAgICAgICAgICAgICAgICAgICAgICAgICAoc2VuZC1lbmNyeXB0ZWQtcGFzc3dvcmQtbWVz c2FnZQogICAgICAgICAgICAgICAgICAgICAgICAgICBzb2NrZXQKICAgICAgICAgICAgICAgICAg ICAgICAgICAgKGNvbmNhdGVuYXRlICdzdHJpbmcgIm1kNSIgcHdkKSkpKQpfX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwpDTFNRTCBtYWlsaW5nIGxpc3QKQ0xT UUxAYjkuY29tCmh0dHA6Ly9saXN0cy5iOS5jb20vY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL2Ns c3FsCg==