Re: Version 1.4.4 installation problems (desperate by now)

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hi Steve,

It indeed sems to be that I need to start Postgresql with the -i option=2E
Question is how to do that?

In my "/etc/init=2Ed/postgresql" I have the following line to start the
postmaster=2E

postgres -c "/usr/bin/pg_ctl  -D  $PGDATA -p  /usr/bin/postmaster start
>/dev/null 2>&1

I have tried to add '-i' in several places in this line and to execute it
from the command line, but so far I have not been lucky=2E

Can you please advise me?

Thanks,

Oscar

PS: the error in httpd/error_log indicates the following:

DBI->connect(dbname=3Dfaicom;host=3D192=2E168=2E1=2E12;port=3D5432) failed:
PQconnectPoll() -- connect() failed: Connection refused
        Is the postmaster running (with -i) at '192=2E168=2E1=2E12'
        and accepting connections on TCP/IP port '5432'?
 at SL/User=2Epm line 110

----- Message d'origine -----
De : "Steve Doerr" <sdoerr@swbell=2Enet>
=C0 : <sql-ledger-users@lists=2Esourceforge=2Enet>
Envoy=E9 : mardi 19 juin 2001 18:05
Objet : Re: Version 1=2E4=2E4 installation problems (desperate by now)

> Hi Oscar=2E
>
> Do you have postgres starting with the -i flag (tcp/ip connection)?
>
> try from the command line:
> psql -d yourdbname -h 127=2E0=2E0=2E1
>
> If you can't make a tcp/ip connection through the localhost, you need to
start
> the postmaster with the -i flag=2E
>
> Good luck,
> Steve
>
> Oscar Buijten wrote:
>
> > Bloody =2E=2E=2E  You are a GENIUS !!
> >
> > Now it says:
> >
> > Error!
> > Database is offline; please try again later
> >
> > You know the answer to that as well??
> >
> > Thanks,
> >
> > Oscar
> >
> > ----- Message d'origine -----
> > De : "Flavio Curti" <lists=2Efcu@no-way=2Eorg>
> > =C0 : <oscar@elbie=2Ecom>
> > Envoy=E9 : mardi 19 juin 2001 15:26
> > Objet : Re: Version 1=2E4=2E4 installation problems (desperate by now)
> >
> > > hi
> > >
> > > i had the same problem and were looking for all kind of things, when
it
> > simply was a typo=2E=2E=2E make sure the database type in the user recor=
d is
'Pg'
> > (note the uppercase 'p')=2E=2E=2E this was it for me=2E=2E=2E
> > >
> > > greetz & hope it helps
> > >
> > > Flavio
> > >
> > > On Tue, 19 Jun 2001 15:00:55 +0200 "Oscar Buijten" <oscar@elbie=2Ecom>
> > wrote:
> > >
> > > > Hi,
> > > >
> > > > I am trying to install V1=2E4=2E4 for many days now=2E I keep having
errors
> > and trat to be desparate=2E
> > > > I would Higly appreciate a bit of help=2E Please see below all the
details
> > (let me know if more is required)
> > > >
> > > > Main error visible is: http://192=2E168=2E1=2E12/sql-ledger/login=2E=
pl
provoking
> > an Internal server Error after submitting a User ID and Passwd
> > > >
> > > > I am running Mandrake 8=2E0 on a standard Intel PII machine=2E
> > > > Apache: Apache-AdvancedExtranetServer/1=2E3=2E19 Server at euro=2Eho=
st
Port 80
> > > > SQL is Postgress 7=2E0xxxx as it comes with Mandrake 8=2E0
> > > >
> > > > In order to install BDI and DBD:pg I have used (after trying to
install
> > from the sources):
> > > > perl-DBI-1=2E14-4mdk=2Ei586=2Erpm
> > > > and
> > > > perl-DBD-Pg-0=2E91-2mdk=2Ei586=2Erpm
> > > > (One of the issues I had installing the DBD::Pg sources were the
> > environment varaiables=2E
> > > > POSTGRES_INCLUDE=3D/usr/include
> > > > PGDATA=3D/var/lib/pgsql/data
> > > > POSTGRES_LIB=3D/usr/lib/pgsql
> > > >
> > > > Of which the include one is the issue according to me=2E I can't fin=
d
any
> > other include directories=2E=2E=2E=2E=2E that could relate to Postgresql=
=2E
> > > >
> > > > Tail of apache error log gives:
> > > > Unknown error
> > > > Compilation failed in require at /var/www/sql-ledger/login=2Epl line
65=2E
> > > > [Tue Jun 19 13:55:49 2001] [error] [client 192=2E168=2E1=2E4] Premat=
ure
end of
> > script headers: /var/www/sql-ledger/login=2Epl
> > > >
> > > >
> > > > Changing the first line of login=2Epl to #!/usr/bin/perl -w gives th=
e
> > following result in the httpd error_log
> > > >
> > > > Use of uninitialized value in split at /var/www/sql-ledger/login=2Ep=
l
line
> > 53=2E
> > > > Use of uninitialized value in read at SL/Form=2Epm line 44=2E
> > > > Unknown error
> > > > Compilation failed in require at /var/www/sql-ledger/login=2Epl line
65=2E
> > > > [Tue Jun 19 14:03:42 2001] [error] [client 192=2E168=2E1=2E4] Premat=
ure
end of
> > script headers: /var/www/sql-ledger/login=2Epl
> > > >
> > > >
> > > > The creation of the databases went fine and I can acces, modify
without
> > any problems using webmin=2E
> > > >
> > > > So in short, I need Heeeeeeeeeeeeeeeelp=2E
> > > >
> > > > Thanks in advance, to you, kind person helping me out=2E
> > > >
> > > > Regards,
> > > >
> > > > Oscar
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
________________________________________________________________________
> > > >
> > > > Oscar Buijten
> > > >
> > > > Tel:     +33=2E4=2E67=2E57=2E97=2E45
> > > > Fax:    +33=2E4=2E67=2E57=2E97=2E46
> > > > GSM: +33=2E6=2E20=2E84=2E15=2E22
> > > > Email: oscar@elbie=2Ecom
> > > >
> > > > http://www=2Eelbie=2Ecom
> > > >
> > >
> > >
> > > --
> > > http://no-way=2Eorg/~fcu/
> > >
>
>
>