RE: Version 1.4.4 installation problems (desperate by now)

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Try a:
postgres -c "/usr/bin/pg_ctl -0 '-i' -D  $PGDATA -p  /usr/bin/postmaster
start >/dev/null 2>&1

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of Oscar
Buijten
Sent: Tuesday, June 19, 2001 11:29 AM
To: sql...@li...
Subject: Re: Version 1.4.4 installation problems (desperate by now)

Hi Steve,

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

In my "/etc/init.d/postgresql" I have the following line to start the
postmaster.

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.

Can you please advise me?

Thanks,

Oscar

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

DBI->connect(dbname=faicom;host=192.168.1.12;port=5432) failed:
PQconnectPoll() -- connect() failed: Connection refused
        Is the postmaster running (with -i) at '192.168.1.12'
        and accepting connections on TCP/IP port '5432'?
 at SL/User.pm line 110

----- Message d'origine -----
De : "Steve Doerr" <sd...@sw...>
À : <sql...@li...>
Envoyé : mardi 19 juin 2001 18:05
Objet : Re: Version 1.4.4 installation problems (desperate by now)

> Hi Oscar.
>
> Do you have postgres starting with the -i flag (tcp/ip connection)?
>
> try from the command line:
> psql -d yourdbname -h 127.0.0.1
>
> If you can't make a tcp/ip connection through the localhost, you need to
start
> the postmaster with the -i flag.
>
> Good luck,
> Steve
>
> Oscar Buijten wrote:
>
> > Bloody ...  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" <lis...@no...>
> > À : <os...@el...>
> > Envoyé : mardi 19 juin 2001 15:26
> > Objet : Re: Version 1.4.4 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... make sure the database type in the user record is
'Pg'
> > (note the uppercase 'p')... this was it for me...
> > >
> > > greetz & hope it helps
> > >
> > > Flavio
> > >
> > > On Tue, 19 Jun 2001 15:00:55 +0200 "Oscar Buijten" <os...@el...>
> > wrote:
> > >
> > > > Hi,
> > > >
> > > > I am trying to install V1.4.4 for many days now. I keep having
errors
> > and trat to be desparate.
> > > > I would Higly appreciate a bit of help. Please see below all the
details
> > (let me know if more is required)
> > > >
> > > > Main error visible is: http://192.168.1.12/sql-ledger/login.pl
provoking
> > an Internal server Error after submitting a User ID and Passwd
> > > >
> > > > I am running Mandrake 8.0 on a standard Intel PII machine.
> > > > Apache: Apache-AdvancedExtranetServer/1.3.19 Server at euro.host
Port 80
> > > > SQL is Postgress 7.0xxxx as it comes with Mandrake 8.0
> > > >
> > > > In order to install BDI and DBD:pg I have used (after trying to
install
> > from the sources):
> > > > perl-DBI-1.14-4mdk.i586.rpm
> > > > and
> > > > perl-DBD-Pg-0.91-2mdk.i586.rpm
> > > > (One of the issues I had installing the DBD::Pg sources were the
> > environment varaiables.
> > > > POSTGRES_INCLUDE=/usr/include
> > > > PGDATA=/var/lib/pgsql/data
> > > > POSTGRES_LIB=/usr/lib/pgsql
> > > >
> > > > Of which the include one is the issue according to me. I can't find
any
> > other include directories..... that could relate to Postgresql.
> > > >
> > > > Tail of apache error log gives:
> > > > Unknown error
> > > > Compilation failed in require at /var/www/sql-ledger/login.pl line
65.
> > > > [Tue Jun 19 13:55:49 2001] [error] [client 192.168.1.4] Premature
end of
> > script headers: /var/www/sql-ledger/login.pl
> > > >
> > > >
> > > > Changing the first line of login.pl to #!/usr/bin/perl -w gives the
> > following result in the httpd error_log
> > > >
> > > > Use of uninitialized value in split at /var/www/sql-ledger/login.pl
line
> > 53.
> > > > Use of uninitialized value in read at SL/Form.pm line 44.
> > > > Unknown error
> > > > Compilation failed in require at /var/www/sql-ledger/login.pl line
65.
> > > > [Tue Jun 19 14:03:42 2001] [error] [client 192.168.1.4] Premature
end of
> > script headers: /var/www/sql-ledger/login.pl
> > > >
> > > >
> > > > The creation of the databases went fine and I can acces, modify
without
> > any problems using webmin.
> > > >
> > > > So in short, I need Heeeeeeeeeeeeeeeelp.
> > > >
> > > > Thanks in advance, to you, kind person helping me out.
> > > >
> > > > Regards,
> > > >
> > > > Oscar
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
________________________________________________________________________
> > > >
> > > > Oscar Buijten
> > > >
> > > > Tel:     +33.4.67.57.97.45
> > > > Fax:    +33.4.67.57.97.46
> > > > GSM: +33.6.20.84.15.22
> > > > Email: os...@el...
> > > >
> > > > http://www.elbie.com
> > > >
> > >
> > >
> > > --
> > > http://no-way.org/~fcu/
> > >
>
>
>