Menu
▾
▴
sql-ledger-users
|
From: Oscar B. <os...@el...> - 2001-06-19 17:37:23
|
Hello again dear helpers,
I have been trying several things. Changed this line;
postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster start =
>/dev/null 2>&1
in several ways. Can't get it to work with this.
Have tried to add : su postgres -c 'postmaster -i' to /etc/profile as =
well but no succes either.
When I use; su postgres -c 'postmaster -i' from the command line =
postmaster switches on and I can use the SQL-ledger application.=20
Wooow !!!
So the I can get the application work but would REALLY appreciate some =
help on switching on postgress at boot-time with the -i flag.
Thanks,
Oscar
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=3Dfaicom;host=3D192.168.1.12;port=3D5432) 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...>
=C0 : <sql...@li...>
Envoy=E9 : 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...>
> > =C0 : <os...@el...>
> > Envoy=E9 : 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=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. 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/
> > >
>
>
>
________________________________________________________________________
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
|
|
From: Jonas S. <jo...@jo...> - 2001-06-19 18:05:10
|
On Tue, 19 Jun 2001, Oscar Buijten wrote: > When I use; su postgres -c 'postmaster -i' from the command line > postmaster switches on and I can use the SQL-ledger application. > > Wooow !!! > > So the I can get the application work but would REALLY appreciate some > help on switching on postgress at boot-time with the -i flag. On the unofficial Debian Woody (with PostgreSQL 7.1) there's a separate file called /etc/postgresql/postmaster.init where you have to add the line "PGALLOWTCPIP=yes". Maybe it is similar on your system... - Jonas P.S. Please write _below_ quoted text and only quote what is relevant for your reply (cut off the rest) - for greater reading pleasure :-) -- Jonas Smedegaard <jo...@jo...> http://www.jones.dk/~jonas/ IT-guide dr. Jones <dr...@jo...> http://dr.jones.dk/ +45 40843136 Debian GNU/Linux <js...@de...> http://www.debian.org/ GnuPG(1024D/C02440B8): 9A98 C6EB C098 9ED0 3085 ECA9 9FB0 DB32 C024 40B8 GNU GPL: "The source will be with you... always." |
|
From: Kevin H. <kh...@bi...> - 2001-06-19 18:13:36
|
----- Original Message ----- From: "Jonas Smedegaard" <jo...@jo...> To: <sql...@li...> Sent: Tuesday, June 19, 2001 11:05 AM Subject: RE: Version 1.4.4 installation problems (nearly there now ! ) > On Tue, 19 Jun 2001, Oscar Buijten wrote: > > > When I use; su postgres -c 'postmaster -i' from the command line > > postmaster switches on and I can use the SQL-ledger application. > > > > Wooow !!! > > > > So the I can get the application work but would REALLY appreciate some > > help on switching on postgress at boot-time with the -i flag. > > On the unofficial Debian Woody (with PostgreSQL 7.1) there's a separate > file called /etc/postgresql/postmaster.init where you have to add the line > "PGALLOWTCPIP=yes". Maybe it is similar on your system... > > - Jonas > > P.S. > > Please write _below_ quoted text and only quote what is relevant for your > reply (cut off the rest) - for greater reading pleasure :-) > > -- > Jonas Smedegaard <jo...@jo...> http://www.jones.dk/~jonas/ > IT-guide dr. Jones <dr...@jo...> http://dr.jones.dk/ +45 40843136 > Debian GNU/Linux <js...@de...> http://www.debian.org/ > GnuPG(1024D/C02440B8): 9A98 C6EB C098 9ED0 3085 ECA9 9FB0 DB32 C024 40B8 > > GNU GPL: "The source will be with you... always." > > |
|
From: Tomas K. <to...@bi...> - 2001-06-19 18:20:49
|
> Oscar Buijten wrote: > > Hello again dear helpers, > > I have been trying several things. Changed this line; > postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster > start >/dev/null 2>&1 > in several ways. Can't get it to work with this. > > Have tried to add : su postgres -c 'postmaster -i' to /etc/profile > as well but no succes either. > > When I use; su postgres -c 'postmaster -i' from the command line > postmaster switches on and I can use the SQL-ledger application. > You don't need to modify init.d script if you want to make postgresql listen to tcp all you need is valid configuration file. "tcpip_socket = true" and "port = 5432" options. and postgres listens to tcp port. I did it with postgres build from sources and with postgres on Debian. :) -- Tomas Kuliavas |
|
From: Oscar B. <os...@el...> - 2001-06-20 10:04:24
|
Thanks to all the people replying to my 'crying out for help!' For the person that may benifit from it: To start Postgresql with the -i flag (to enable TCP/IP connections) on Mandrake 8=2E0 do the following: cd /etc/init=2Ed emacs postgresql Look for the line containing: echo -n "Starting postgresql service: " (probably line 82) The next line is then: su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster start >/dev/null 2>&1" Change it to: su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster -o -i start >/dev/null 2>&1" Notice the "-o -i" between postmaster and start=2E I assume the -o means 'options you want to give to the postmaster when starting it'=2E -i enables the TCP/IP connections=2E Enjoy, Oscar ----- Message d'origine ----- De : "Tomas Kuliavas" <tokul@bigfoot=2Ecom> ? : <sql-ledger-users@lists=2Esourceforge=2Enet> Envoy=E9 : mardi 19 juin 2001 20:22 Objet : Re: Version 1=2E4=2E4 installation problems (nearly there now ! ) > > Oscar Buijten wrote: > > > > Hello again dear helpers, > > > > I have been trying several things=2E Changed this line; > > postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster > > start >/dev/null 2>&1 > > in several ways=2E Can't get it to work with this=2E > > > > Have tried to add : su postgres -c 'postmaster -i' to /etc/profile > > as well but no succes either=2E > > > > When I use; su postgres -c 'postmaster -i' from the command line > > postmaster switches on and I can use the SQL-ledger application=2E > > > > You don't need to modify init=2Ed script if you want to make postgresql > listen to tcp > > all you need is valid configuration file=2E > > "tcpip_socket =3D true" and "port =3D 5432" options=2E > > and postgres listens to tcp port=2E I did it with postgres build from > sources and with postgres on Debian=2E :) > -- > Tomas Kuliavas > |
|
From: Steve D. <sd...@sw...> - 2001-06-19 20:50:07
|
Hi Oscar. I'm on Debian, so I do it through the postmaster.init file. I think you need to get what's below into your startup script or check the configuration file for the distribution that you're on. Your docs also might have more info. Sorry I can't be of more assistance. Steve > Try a: > postgres -c "/usr/bin/pg_ctl -0 '-i' -D $PGDATA -p > /usr/bin/postmaster > start >/dev/null 2>&1 > > |
Thanks for helping keep SourceForge clean.
X