Обсуждение: installing on user account
I don't have root access here at work, and I wanted to run a jabber server to communicate with other folks here. I choose PostgreSQL as db backend. It is already installed, but it's not starting on boot. I don't have the password for the postgres user, so I'm running the postmaster daemon as my own user. $export PGDATA=$HOME/usr/var/postgres $initdb these went ok. Then I started following the jabberd2 installation instructions from here: http://jabberd.jabberstudio.org/2/docs/section04_5.html They said "createdb -U postgres -E UNICODE jabberd2", I ran "createdb -E UNICODE jabberd2" instead. Then "createuser -P -U postgres jabberd2", I ran "createuser -P jabberd2". No problem so far. Next step would be to run psql to issue a \i command to setup the jabberd2 database. They said "psql -U jabberd2 jabberd2", but I received the following error: $psql -U jabberd2 jabberd2 psql: FATAL: IDENT authentication failed for user "jabberd2" I also tried appending a -W argument to that command. It asked for the password, I gave the password from the createuser command, and the same error ocurred. If I enter with my own user (psql jabberd2), and issue a \du, I see: User name | User ID | Attributes -----------+---------+---------------------------- jabberd2 | 100 | nttx | 1 | superuser, create database (2 rows) My setup: $postgres --version postgres (PostgreSQL) 7.3.6-RH $cat /etc/redhat-release Red Hat Enterprise Linux WS release 3 (Taroon Update 2) $uname -a Linux 2.4.21-15.ELsmp #1 SMP Thu Apr 22 00:09:01 EDT 2004 x86_64 x86_64 x86_64 GNU/Linux Any ideas? Well, I have one: I'll to install PostgreSQL on my account, and run that instead. -- Rodolfo Borges
Am Freitag, 4. August 2006 17:57 schrieb Rodolfo Borges: > $psql -U jabberd2 jabberd2 > psql: FATAL: IDENT authentication failed for user "jabberd2" You need to read up on configuring the client authentication. If you don't have root access, ident is probably not a good choice. In particular ... > I also tried appending a -W argument to that command. > It asked for the password, I gave the password from the createuser > command, and the same error ocurred. ... if you expect to use password authentication, you need to change the client authentication mechanism away from ident and toward passwords. -- Peter Eisentraut http://developer.postgresql.org/~petere/
On 8/4/06, Peter Eisentraut <peter_e@gmx.net> wrote: > Am Freitag, 4. August 2006 17:57 schrieb Rodolfo Borges: > > $psql -U jabberd2 jabberd2 > > psql: FATAL: IDENT authentication failed for user "jabberd2" > > You need to read up on configuring the client authentication. If you don't > have root access, ident is probably not a good choice. In particular ... But that's a postgres global setting, not a database-specific setting, right? So, I would need root access to change it. Back from lunch now, I'll proceed with the installation of my own postgres on my $HOME. > > I also tried appending a -W argument to that command. > > It asked for the password, I gave the password from the createuser > > command, and the same error ocurred. > > ... if you expect to use password authentication, you need to change the > client authentication mechanism away from ident and toward passwords. Thanks for the tip. -- Rodolfo Borges
I installed postgresql on my account, and now it works ok. Thanks again. On 8/4/06, Rodolfo Borges <rodolfo.borges@gmail.com> wrote: > On 8/4/06, Peter Eisentraut <peter_e@gmx.net> wrote: > > Am Freitag, 4. August 2006 17:57 schrieb Rodolfo Borges: > > > $psql -U jabberd2 jabberd2 > > > psql: FATAL: IDENT authentication failed for user "jabberd2" > > > > You need to read up on configuring the client authentication. If you don't > > have root access, ident is probably not a good choice. In particular ... > > But that's a postgres global setting, not a database-specific setting, right? > So, I would need root access to change it. > > Back from lunch now, I'll proceed with the installation of my own > postgres on my $HOME. > > > > I also tried appending a -W argument to that command. > > > It asked for the password, I gave the password from the createuser > > > command, and the same error ocurred. > > > > ... if you expect to use password authentication, you need to change the > > client authentication mechanism away from ident and toward passwords. > > Thanks for the tip. > > -- > Rodolfo Borges > -- Rodolfo Borges