The username is the salt.
--
Robert Abernethy IV
Dynamic Edge, Inc.
734.975.0460
> I am trying to figure out exactly how to set someone's password when
> using MD5 passwords in postgres. I am trying to automate some
> features, and still can't figure out what I am doing wrong. MD5 of
> the
, Inc.
734.975.0460
> "Rob Abernethy IV" <[EMAIL PROTECTED]> writes:
> > Can you tell postgres *NOT* to use a salt when calculating the MD5
> > digest?
>
> No, and you wouldn't want to. The salt is an essential security
> feature.
Can you tell postgres *NOT* to use a salt when calculating the MD5 digest? I
found that it prepends the username to the password before making the calculation.
--
Robert Abernethy IV
Dynamic Edge, Inc.
734.975.0460
> Perl also came up with the same digest as Java.
>
> --
> Robert Abernethy IV
>
Perl also came up with the same digest as Java.
--
Robert Abernethy IV
Dynamic Edge, Inc.
734.975.0460
> How does postgres calculate the MD5 version of a password to store
> in the database during user creation? I am trying to set up a
> postgres JDBCRealm to work with Tomcat. The problem is
How does postgres calculate the MD5 version of a password to store in the
database during user creation? I am trying to set up a postgres JDBCRealm to
work with Tomcat. The problem is that the resulting digest from Java is
different then the digest stored in the database for the same word.
cl
Is there any problem with this line from my pg_hba.conf file:
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
local all all 0.0.0.0 0.0.0.0 md5
I get this error when I try to connect:
LOG: parse_hba: invalid syntax in pg_hba.conf file at line 90, token "0.0.0.0"
FATAL: Mis
Does anyone have a good recipe for a view that will display users/gruops in a
way that can be used with Tomcat's JDBCRelam configuration? In other words,
instead of seeing a *list* of users in a group (grolist), I'd like to see a
separate row for every group/user combination.
group | user
---
buf.st_uid != getuid())
> {
> postmaster_error("bad permissions on private key file
> (%s)", fnbuf);ExitPostmaster(1);
>
> so my guess is that you have to remove group/other permissions on the
> file.
>
> -----------
I cannot get the postmaster to start up in SSL mode. I receive the following
error:
bad permissions on private key file (/var/lib/pgsql/data/server.key)
I've checked the permissions and everything seems to be fine.
ls -al
total 56
drwx--6 postgres postgres 4096 Dec 18 17:17 .
drwxr-
