From: Oscar B. <os...@el...> - 2001-06-19 13:03:10
|
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:=20 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 |
From: Oscar B. <os...@el...> - 2001-06-19 14:08:20
|
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 record 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 err= ors and trat to be desparate=2E > > I would Higly appreciate a bit of help=2E Please see below all the detai= ls (let me know if more is required) > > > > Main error visible is: http://192=2E168=2E1=2E12/sql-ledger/login=2Epl p= rovoking 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=2Ehost P= ort 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 find an= y 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] Premature = end of script headers: /var/www/sql-ledger/login=2Epl > > > > > > Changing the first line of login=2Epl 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=2Epl li= ne 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] Premature = 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/ > |
From: Jonas S. <jo...@jo...> - 2001-06-19 14:24:07
|
On Tue, 19 Jun 2001, Oscar Buijten wrote: > Now it says: > > Error! > Database is offline; please try again later Let me try this time - it might be along the same line as last one: host: localhost And while we're at it, put in these as well: Name (PostgreSQL database name) Port (5432 on my setup) User (PostgreSQL login name) Password (PostgreSQL password - empty if you don't need a password) Good luck! - Jonas -- 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: Steve D. <sd...@sw...> - 2001-06-19 14:53:36
|
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, w= hen 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" <oscar@elbie.c= om> > 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 th= e 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.hos= t 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 th= e > 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 l= ine 65. > > > [Tue Jun 19 13:55:49 2001] [error] [client 192.168.1.4] Prematu= re 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/logi= n.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 l= ine 65. > > > [Tue Jun 19 14:03:42 2001] [error] [client 192.168.1.4] Prematu= re 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/ > > |
From: Oscar B. <os...@el...> - 2001-06-19 15:32:01
|
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/ > > > > > > |
From: Ian \(t. webguy\) <ia...@in...> - 2001-06-19 15:52:16
|
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/ > > > > > > |
From: Flavio C. <fc...@no...> - 2001-06-19 13:21:08
|
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/ |