Menu
▾
▴
sql-ledger-users
|
From: Julien L. <jul...@it...> - 2002-04-02 17:39:34
|
Hi everybody,
sorry to bother you with such a basic question, but I can't seem to get
SQL-Ledger working. I followed the steps outlined in the README file,
but now all I can get is an internal server error (with Apache on Linux,
everything compiled by ourselves and running well for over a year).
The exact error message in the error log is:
Unknown error
Compilation failed in require at /usr/local/sql-ledger/admin.pl line 86.
[Tue Apr 2 12:19:57 2002] [error] [client 192.168.1.103] Premature end
of script headers: /usr/local/sql-ledger/admin.pl
when I try to configure the database or the same message with login.pl
when I try to login with an existing user (I can add users).
Permissions, etc. seem to be correct as far as I can tell, because
everything runs up to this point.
I tried with Mozilla 0.9.9, Netscape 4.7x and Lynx too, because the
error occurs on a "require" line. I printed the content of this require
line and everything seems normal ("bin/mozilla/login.pl" for example,
which exists and is readable).
Any help would be *greatly* appreciated since I cannot even begin to try
out the software without this!
Thanks in advance,
Julien Lajeunesse
|
|
From: klavs k. <kl...@vs...> - 2002-04-03 07:28:48
|
Hi Julien,
I just installed sql-ledger too.. I found that the following add-on to
the readme would have gotten me through the process:
If you just installed postgresql (as rpm only?) then do:
createuser sqlledger -W
> say yes to both questions and select a password.
edit /etc/rc.d/init.d/postgresql (RH/MDK specific)
so that the pg_ctl gets an extra option "-o -i" to tell postmaster
process to listen on standard tcp port 5432.
edit /var/lib/pgsql/data/pg_hba.conf and add line=20
> host all 127.0.0.1 255.255.255.255 password
(this works if your httpd and postgresql are on the same server
otherwise put your webservers IP instead of 127.0.0.1)
I had done all the other stuff, mentioned in the readme.
After this, I could log in create a new dataset and a user for this
dataset and voila.
I hope it helps..
=20
--=20
Regards,
Klavs Klavsen
-------------| This mail has been sent to you by: |------------
Klavs Klavsen - Open Source Consultant=20
kl...@vs... - http://www.vsen.dk
Get PGP key from www.keyserver.net - Key ID: 0x586D5BCA=20
Fingerprint =3D A95E B57B 3CE0 9131 9D15 94DA E1CD 641E 586D 5BCA
--------------------[ I believe that... ]-----------------------
It is a myth that people resist change. People resist what other
people make them do, not what they themselves choose to do...
That's why companies that innovate successfully year after year
seek their peopl's ideas, let them initiate new projects and
encourage more experiments. -- Rosabeth Moss Kanter
|
|
From: Julien L. <jul...@it...> - 2002-04-04 07:19:38
|
Hi Klavs, On Wed, Apr 03, 2002 at 09:28:56AM +0200, klavs klavsen wrote: > I just installed sql-ledger too.. I found that the following add-on to > the readme would have gotten me through the process: > > If you just installed postgresql (as rpm only?) then do: > > [snip technical details] Postgresql was installed from the RPMs, I did the modifications you mentionned (though it doesn't seem to make much difference, I was already able to connect via tcp/ip (telnet localhost 5432)). Unfortunately I still have the same Internal Server Error when trying to login or click on "Create Dataset". By the way, the versions currently installed are: perl 5.6.0 (from rpms) apache 1.3.17 (compiled with lots of extras ;) postgresql 7.0.3 (from rpms) Thanks again for the help, I'm still investigating the probleme on my own in the meantime! Regards, Julien |
|
From: klavs k. <kl...@vs...> - 2002-04-04 08:02:56
|
On Wed, 2002-04-03 at 19:24, Julien Lajeunesse wrote:
> Hi Klavs,
>=20
> Postgresql was installed from the RPMs, I did the modifications you
> mentionned (though it doesn't seem to make much difference, I was
> already able to connect via tcp/ip (telnet localhost 5432)).
are you running Redhat? which version of distro?
> Unfortunately I still have the same Internal Server Error when trying to
> login or click on "Create Dataset".
>=20
> By the way, the versions currently installed are:
> perl 5.6.0 (from rpms)
> apache 1.3.17 (compiled with lots of extras ;)
> postgresql 7.0.3 (from rpms)
I'm running RedHat 7.2, Perl 5.6.1 (they upgraded to it - look in
updates), apache 1.3.22 (you should upgrade) and postgresql 7.2 - all
from redhat rpms.
=20
> Thanks again for the help, I'm still investigating the probleme on my
> own in the meantime!
your welcome.
The response you get in your apache logs, just means that the perl script d=
oesn't respond with correct html.
Try running the perl-script from the command prompt and see if you get
any error messages.. (this is the problem with cgi-perl - error messages
are thrown away). Otherwise you could install mod_perl module - just for
a while, mod-perl cathes the errormsgs and logs them to apache's
errorlog - because the perl is embedded in the apache process..(be aware
that mod_perl might cause problems with sql-ledger - atleast on the
second run of a perl-script :-)=20
=20
--=20
Regards,
Klavs Klavsen
-------------| This mail has been sent to you by: |------------
Klavs Klavsen - OpenSource Consultant=20
kl...@vs... - http://www.vsen.dk
Get PGP key from www.keyserver.net - Key ID: 0x586D5BCA=20
Fingerprint =3D A95E B57B 3CE0 9131 9D15 94DA E1CD 641E 586D 5BCA
--------------------[ I believe that... ]-----------------------
It is a myth that people resist change. People resist what other
people make them do, not what they themselves choose to do...
That's why companies that innovate successfully year after year
seek their peopl's ideas, let them initiate new projects and
encourage more experiments. -- Rosabeth Moss Kanter
|
|
From: Julien L. <jul...@it...> - 2002-04-04 14:36:16
|
On Thu, Apr 04, 2002 at 10:02:58AM +0200, klavs klavsen wrote: > On Wed, 2002-04-03 at 19:24, Julien Lajeunesse wrote: > > Postgresql was installed from the RPMs, I did the modifications you > > mentionned (though it doesn't seem to make much difference, I was > > already able to connect via tcp/ip (telnet localhost 5432)). > are you running Redhat? which version of distro? It was originally a RedHat 7.0, but has been heavily patched/updated over time, so I would say it's now the equivalent of a 7.1 and more. > > By the way, the versions currently installed are: > > perl 5.6.0 (from rpms) > > apache 1.3.17 (compiled with lots of extras ;) > > postgresql 7.0.3 (from rpms) > I'm running RedHat 7.2, Perl 5.6.1 (they upgraded to it - look in > updates), apache 1.3.22 (you should upgrade) and postgresql 7.2 - all > from redhat rpms. Unfortunately I'm kinda "locked" for the apache and postgresql for various configuration reasons (notably drivers to postgres for an older systems which seem to work only with 7.0.x). Since this is an internal server it was not so critical to update to newer versions. I'll try it on a different one though, where I can update those. > Try running the perl-script from the command prompt and see if you get > any error messages.. I'll also try this if the new versions aren't any help. > [mod_perl causing problemes with SQL-Ledger] I only have mod_cgi installed, could it cause any problem? Once again, many many thanks! Julien |
|
From: Julien L. <jul...@it...> - 2002-04-04 22:04:14
|
On Thu, Apr 04, 2002 at 10:02:58AM +0200, klavs klavsen wrote: > I'm running RedHat 7.2, Perl 5.6.1 (they upgraded to it - look in > updates), apache 1.3.22 (you should upgrade) and postgresql 7.2 - all > from redhat rpms. Upgrading perl and postgres solved the problem, which is somehow strange because both were "recent" (younger than 10 months) and already installed from RPMs (only apache had a strange home-made compilation/configuration)... So thanks again Klavs and everybody who helped, and for Tom, you can find the packages at rpmfind.net, I downloaded the packages called "RedHat 7.2 Updates for i386" to have the latest version of everything, except for postgres I downloaded the packages from "RawHide 1.0". Also, be sure to download perl-DBD-Pg and perl-DBI. Once more, thank you! Julien |
|
From: klavs k. <kl...@vs...> - 2002-04-05 09:05:17
|
Hi Julien,
I just installed sql-ledger too.. I found that the following add-on to
the readme would have gotten me through the process:
If you just installed postgresql (as rpm only?) then do:
createuser sqlledger -W
> say yes to both questions and select a password.
edit /etc/rc.d/init.d/postgresql (RH/MDK specific)
so that the pg_ctl gets an extra option "-o -i" to tell postmaster
process to listen on standard tcp port 5432.
edit /var/lib/pgsql/data/pg_hba.conf and add line=20
> host all 127.0.0.1 255.255.255.255 password
(this works if your httpd and postgresql are on the same server
otherwise put your webservers IP instead of 127.0.0.1)
I had done all the other stuff, mentioned in the readme.
After this, I could log in create a new dataset and a user for this
dataset and voila.
I hope it helps..
=20
--=20
Regards,
Klavs Klavsen
-------------| This mail has been sent to you by: |------------
Klavs Klavsen - Open Source Consultant=20
kl...@vs... - http://www.vsen.dk
Get PGP key from www.keyserver.net - Key ID: 0x586D5BCA=20
Fingerprint =3D A95E B57B 3CE0 9131 9D15 94DA E1CD 641E 586D 5BCA
--------------------[ I believe that... ]-----------------------
It is a myth that people resist change. People resist what other
people make them do, not what they themselves choose to do...
That's why companies that innovate successfully year after year
seek their peopl's ideas, let them initiate new projects and
encourage more experiments. -- Rosabeth Moss Kanter
|
Thanks for helping keep SourceForge clean.
X