Click the "Known Issue" link #851 in the Errata section:
http://fsck.com/rt2/NoAuth/Errata.html?Release=2.0.7
and try out the explanation there if using Pg with Unix Domain Sockets.

If you run Pg with the -i flag then you should be able to connect to the database with no problem via the loopback interface on 127.0.0.1

Go to your Postgres data directory and check the file pg_hba.conf which controls access... refer to the uncommented lines at the bottom of the file.

Hope this helps, Harold








On Tue, 18 Sep 2001 21:07:53 -0700, Ashley Gould <agould@aslab.com> wrote:

> 
> I'm trying to build postgresql 7.1.2 so that RT can accept attachments
> over 8k.  This is on SuSE 7.2.  I'm using the perl RPMs: perl 5.6.0.
> 
> This is how I am configuring the build:
> ishi:/usr/local/build/postgresql-7.1.2 # ./configure --with-perl --enable-syslog
> 
> I see no warnings in the config.log about problems with perl.
> The compile goes ok, and I can connect to the database with psql.  I can
> reload my pg_dumpall from my old db, and can see all the RT data.
> 
> But I cannot connect to the db from RT.  It is as if I did not compile
> the perl hooks.
> 
> In frustration I started over with a clean database.  I rebuilt RT
> 2.0.7.  I rebuilt perl modules:
> DBD-Pg-1.01 (even passes 'make test')
> DBI-1.19
> DBIx-DataSource-0.02
> DBIx-SearchBuilder-0.41
> 
> But I cannot 'make install' RT:
> 
> ishi:/usr/local/build/rt # make install
> mkdir -p /usr/local/rt2/bin
> mkdir -p /usr/local/rt2/WebRT/data
> mkdir -p /usr/local/rt2/WebRT/sessiondata
> mkdir -p /usr/local/rt2/etc
> mkdir -p /usr/local/rt2/lib
> mkdir -p /usr/local/rt2/WebRT/html
> mkdir -p /usr/local/rt2/local/WebRT/html
> /usr/bin/perl   tools/initdb 'Pg' '/usr/local/pgsql' 'localhost' '5432
> ' 'postgres' 'rt2' create
> Now creating a database for RT.
> Enter the Pg password for postgres: 
> Creating Pg database rt2.
> DBI->connect(dbname=template1;host=localhost;port=5432  ) failed:
> PQconnectPoll() -- connect() failed: Connection refused at
> /usr/lib/perl5/site_perl/5.6.0/DBIx/DataSource/Driver.pm line 74
> PQconnectPoll() -- connect() failed: Connection refused at
> /usr/lib/perl5/site_perl/5.6.0/DBIx/DataSource/Driver.pm line 74,
> <STDIN> line 1.
> make: *** [createdb] Error 255
> 
> 
> Any help would be much appriciated.
> 
> ashley
> 
> _______________________________________________
> rt-users mailing list
> rt-users@lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users


