Problems installing with Pg

It seems that there is a problem with Pg in 2.0.14?

I’m trying to do a ‘make install’ but having problems connecting to a
postgres server on localhost. I’ve seen similar posts here before but
nothing exactly like this…

Any time there is a DBI->connect(dbname=rt2;host=localhost), the connect
fails. I can define DB_HOST and DB_RT_HOST to be null in the Makefile and
things get farther (the rt2 database gets built), but then towards the
end of the install:

/usr/bin/perl -I//usr/local/rt2/etc -I//usr/local/rt2/lib
//usr/local/rt2/etc/insertdata
DBI->connect(dbname=rt2;host=) failed: connectDBStart() – unknown
hostname: user=rt_user at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Handle.pm line 117
Connect Failed connectDBStart() – unknown hostname: user=rt_user
at //usr/local/rt2/etc/insertdata line 27
make: *** [insert] Error 255

So in this phase, the “host=” argument is hardwired into the DBI->connect
even if I leave it null. If I modify config.pm to put localhost back, I
get the same error connecting that I did before. I did not try to go
modify the code to remove the ‘host=’ argument completely. I thought I
had better ask here first.

Thanks in advance for any advice!

Jarrod A. Smith, Ph.D.
Asst. Director, Center for Structural Biology
Research Asst. Professor, Biochemistry
Vanderbilt University

189 processes: 130 sleeping, 59 running

It seems that there is a problem with Pg in 2.0.14?

I’m trying to do a ‘make install’ but having problems connecting to a
postgres server on localhost. I’ve seen similar posts here before but
nothing exactly like this…

I’m replying with the solution for the archives. A helpful individual
sent me this info in private (Thanks Jose).

The problem was apparently in the DBIx::SearchBuilder module. To fix,
grab version 0.63 or later. As of this writing, these versions are not on
CPAN. I installed version 0.73 from http://fsck.com/pub/rt/devel/ and now
everything works as advertised.

Jarrod Smith

It seems that there is a problem with Pg in 2.0.14?

I’m trying to do a ‘make install’ but having problems connecting to a
postgres server on localhost. I’ve seen similar posts here before but
nothing exactly like this…

Any time there is a DBI->connect(dbname=rt2;host=localhost), the connect
fails. I can define DB_HOST and DB_RT_HOST to be null in the Makefile and
things get farther (the rt2 database gets built), but then towards the
end of the install:

/usr/bin/perl -I//usr/local/rt2/etc -I//usr/local/rt2/lib
//usr/local/rt2/etc/insertdata
DBI->connect(dbname=rt2;host=) failed: connectDBStart() – unknown
hostname: user=rt_user at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Handle.pm line 117
Connect Failed connectDBStart() – unknown hostname: user=rt_user
at //usr/local/rt2/etc/insertdata line 27
make: *** [insert] Error 255

So in this phase, the “host=” argument is hardwired into the DBI->connect
even if I leave it null. If I modify config.pm to put localhost back, I
get the same error connecting that I did before. I did not try to go
modify the code to remove the ‘host=’ argument completely. I thought I
had better ask here first.

Thanks in advance for any advice!

Jarrod A. Smith, Ph.D.
Asst. Director, Center for Structural Biology
Research Asst. Professor, Biochemistry
Vanderbilt University

189 processes: 130 sleeping, 59 running

It seems that there is a problem with Pg in 2.0.14?

I’m trying to do a ‘make install’ but having problems connecting to a
postgres server on localhost. I’ve seen similar posts here before but
nothing exactly like this…

Any time there is a DBI->connect(dbname=rt2;host=localhost), the connect
fails. I can define DB_HOST and DB_RT_HOST to be null in the Makefile and
things get farther (the rt2 database gets built), but then towards the
end of the install:

/usr/bin/perl -I//usr/local/rt2/etc -I//usr/local/rt2/lib
//usr/local/rt2/etc/insertdata
DBI->connect(dbname=rt2;host=) failed: connectDBStart() – unknown
hostname: user=rt_user at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Handle.pm line 117
Connect Failed connectDBStart() – unknown hostname: user=rt_user
at //usr/local/rt2/etc/insertdata line 27
make: *** [insert] Error 255

So in this phase, the “host=” argument is hardwired into the DBI->connect
even if I leave it null. If I modify config.pm to put localhost back, I
get the same error connecting that I did before. I did not try to go
modify the code to remove the ‘host=’ argument completely. I thought I
had better ask here first.

Hello Doc,

All you need to do it take a good at the Makefile (the one in the rt2 distro),
make the the changes required in there and the build will succeed. If you
did modify it, then there must be a mistake you made. Take a keen look at
the following values:

DB_TYPE defines what sort of database RT trys to talk to

DB_TYPE =
DB_HOME =
DB_DBA =
DB_DBA_PASSWORD =
DB_HOST =
DB_PORT =
DB_RT_HOST =
DB_DATABASE =
DB_RT_USER =
DB_RT_PASS =

Rgds

    cheers
   - wash 

Odhiambo Washington, wash@wananchi.com . WANANCHI ONLINE LTD (Nairobi, KE) |
http://ns2.wananchi.com/~wash/ . 1ere Etage, Loita Hse, Loita St., |
GSM: (+254) 722 743 223 . # 10286, 00100 NAIROBI |
“Oh My God! They killed init! You Bastards!”
–from a /. post