trouble with PostgreSQL 9.2 on FreeBSD 10.0-CURRENT: superuser can not autheticate anymore with md5 password hash set
c.kworr at gmail.com
Tue Aug 13 14:45:57 UTC 2013
13.08.2013 17:30, O. Hartmann wrote:
> For the past I ran PostgreSQL 9.2 servers on FreeBSD 10.0-CURRENT
> successfully. But by now, out of the blue, login as the database's
> supervisor "pgsql" remotely isn't possible any more.
> The appropriate lines in pg_hba.conf are:
> local all pgsql md5
> hostssl all pgsql 0.0.0.0/0 md5
> The funny thing is: when login locally without providing a password
> (swap md5 to trust in the "local" line) and setting the password for
> the role "pgsql" via
> ALTER ROLE pgsql ENCRYPTED PASSWORD 'FooMe";
I guess ENCRYPTED means you are substituting FooMe with md5 hashed
password correctly salted with role name as postgresql requires?
> or doing the same via pgadmin3 from remotely by also swapping md5 to
> trust in the line "hostssl" for global network, it seems I could
> alter/change the password for the supervisor pgsql. But restoring the
> password check by setting back "md5" leaves me locked out!
> By the way, this strange behaviour occurs on ALL(!) PostgreSQL 9.2
> servers running on FreeBSD 10.0-CURRENT boxes.
> Ports databases/postgresql-XXX as well as FreeBSD is as of the latest
> sources and up to date.
> What is going wrong?
Sphinx of black quartz, judge my vow.
More information about the freebsd-questions