Re: [DOCS] Link to PAM pages broken

2011-10-20 Thread Thom Brown
On 10 October 2011 19:15, Thom Brown  wrote:
> On 10 October 2011 17:52, Thom Brown  wrote:
>> Hi all,
>>
>> I notice that the links to both the Linux PAM page and Solaris PAM
>> page are broken in our documentation.  The bottom of the
>> http://www.postgresql.org/docs/current/static/auth-methods.html page
>> points to http://www.kernel.org/pub/linux/libs/pam/ and
>> http://www.sun.com/software/solaris/pam/.  The former is broken, the
>> latter redirects to some generic Oracle page.
>>
>> I can't find a suitable candidates for substitution.  I found
>> http://linux.die.net/man/8/pam.d and
>> http://dsc.sun.com/solaris/articles/user_auth_solaris3.html but
>> nothing to directly replace them.  Any ideas?
>
> Found a link to a site which contains identical Linux PAM information:
> http://kernel.osuosl.org/pub/linux/libs/pam/Linux-PAM-html/sag-module-reference.html
>
> But even so, I have sent an email to kernel.org notifying them of the
> missing pages.

No response from kernel.org and the link still doesn't work, so we
still have 2 broken links.

-- 
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs


Re: [DOCS] Algorithm for generating md5 encrypted password not found in documentation

2011-10-20 Thread Derrick Rice
On Wed, Oct 19, 2011 at 3:04 PM, Fred Cox  wrote:
>
> On http://www.postgresql.org/docs/9.1/interactive/sql-createrole.html there 
> is mention of a possibility of setting a password for a new role by supplying 
> it in md5 format.  This format doesn't seem to be documented.
> "If the presented password string is already in MD5-encrypted format, then it 
> is stored encrypted as-is"
> Looking at pg_dumpall let me know that the string needs to start with "md5" 
> but a naive running if my password through the command line md5 utility and 
> prefixing "md5" was not correct.

If I recall correctly, it's the username and the password concatenated
and md5'd, then "md5" prepended.

USER=...
PASS=...
MD5=`echo $USER$PASS | md5sum | cut -d' ' -f1`
echo "md5$MD5"

> If the algorithm is documented elsewhere, can it be linked from this page?

 I don't remember where I figured that out, and I cannot find a
reference in the documentation either.  +1 this suggestion.

Derrick

-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs


Re: [DOCS] Algorithm for generating md5 encrypted password not found in documentation

2011-10-20 Thread Derrick Rice
On Thu, Oct 20, 2011 at 9:56 AM, Derrick Rice  wrote:
> If I recall correctly, it's the username and the password concatenated
> and md5'd, then "md5" prepended.
>
> USER=...
> PASS=...
> MD5=`echo $USER$PASS | md5sum | cut -d' ' -f1`
> echo "md5$MD5"

Figures I send the email then discover a small mistake.

It's password first.  So change $USER$PASS to $PASS$USER

-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs