Building postgresql 7.1.2

Ashley_Gould · September 19, 2001, 4:07am

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,
line 1.
make: *** [createdb] Error 255

Any help would be much appriciated.

ashley

Teo_de_Hesselle · September 19, 2001, 5:37am

Ashley Gould wrote:

/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,
line 1.
make: *** [createdb] Error 255

Any help would be much appriciated.

Were you running the postgres system at the time?

Tï¿½o de Hesselle, | Kites rise highest against
Unix Systems Administrator | the wind – not with it.
|
University of Technology, Sydney | – Winston Churchill

hsinclai · September 19, 2001, 1:26pm

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, HaroldOn 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,
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

Ashley_Gould · September 19, 2001, 6:16pm

In my attempt to demonstrate to Pavel I had built DBD::Pg correctly, I
inadvertantly ran ‘make’ again in my postgresql build directory, and low
and behold:

make[3]: Entering directory
/usr/local/build/postgresql-7.1.2/src/pl/plperl' make -f Makefile all make[4]: Entering directory /usr/local/build/postgresql-7.1.2/src/pl/plperl’

Cannot build PL/Perl because libperl is not a shared library.
Skipped.
make[4]: Leaving directory
`/usr/local/build/postgresql-7.1.2/src/pl/plperl’

Thanks, Pavel, for getting me to reset my brain.

So I get to rebuild perl. Any advice is welcome. Should I build 5.6.1?
How do I build libperl as a shared library?

Ah well, back to the manuals.

ashleyOn Wed, Sep 19, 2001 at 07:29:53PM +0200, Sebek Pavel wrote:

Ashley Gould 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’)

How did you rebuild DBD-Pg? Did you delete “makefile” and again run
“perl Makefile” and again set POSTGRES_INCLUDE and

POSTGRES_LIB?

ps

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,
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