sql-ledger-users — SQL-Ledger users

RE: [SQL-Ledger-users] Problems with logging in to sql-ledger

[David R. <dr...@ri...>]

I moved the modules from site-perl to just the i386-linux and set the
permissions to a=r for all modules, a=rx for all directories related to the
DBD/DBI modules, and still, to no avail, I get the same error. I even tried
adding a -I line to specifically direct the login.cgi to the proper
directories and it still fails. This is really driving me INSANE! I have no
idea what the problem is at this point, I'm sure it's something really
stupid that I am missing. I'm using Slackware 7.1, maybe there's some
specific issues there? I'm almost tempted to reinstall Perl. I'd try this
with ActiveState ActivePerl, but I cannot find any PPM support for DBD::Pg.
I've been stuck on this for 3 days now! 

Is there any way to increase debugging output from what's shown below?

To quote the original error message from Apache's error_log:

> > install_driver(Pg) failed: Can't locate loadable object for module
DBD::Pg
> > in @INC (@INC contains: utils /usr/lib/perl5/i386-linux /usr/lib/perl5
> > /usr/lib/perl5/site_perl/i386-linux /usr/lib/perl5/site_perl .) at (eval
> 1)
> > line 3
> > Compilation failed in require at (eval 1) line 3.
> > Perhaps a module that DBD::Pg requires hasn't been fully installed
> >  at /usr/local/apache/htdocs/sql-ledger/login.cgi line 66
> > [Mon Jan 29 09:19:20 2001] [error] [client 192.168.3.179] Premature end
of
> > script headers: /usr/local/apache/htdocs/sql-ledger/login.cgi


-----Original Message-----
From: ufo...@ea... [mailto:ufo...@ea...]
Sent: Tuesday, January 30, 2001 8:32 PM
To: 'sql...@li...'
Subject: RE: [SQL-Ledger-users] Problems with logging in to sql-ledger


If you poke around in your perl dir, you'll see a a "1386-linux" and a
"site-perl/i386-linux".  Be sure that you have the modules in the first
one.  What I did after I found the problem was jsut to copy the modules
to that dir.  I think this also is affecting Ian.  So Ian, please check
this also.

			Wes

[SQL-Ledger-users] use of sql-ledger

[<ke...@dk...>]

Hi!

I have translated sql-ledger into danish, and I have now tried out
this translated version. Some report on this use:

I did the accounting for my small company for the year of 2000,
and I have almost finished it, but i still miss some ex post
transactions. It was all in all about 100 sources, with about
200 transactions.

I only used the general ledger part of the system, no need for 
receivables nor payables.

I found the correcting facilities quite nice, and I managed
to clean up my bank accounts so the match the banks statements.
The correcting facilities also meant that I could enter a transaction
partly, and kind of mark it as unfinished, and then later fix them,
eg get the right date or the right source. Or even put them on differrent
accounts, when I found out that my accountant normally used other accounts
for these kinds of expenses.

Some errors encountered: On the balance report, the "Retained Earnings"
was not translated, and the date in the heading was in English.
Also the DR/CR was quite English, and the (read figure) is an English
notation for red figures. I would have preferred just a "-"

Some things I am missing is:

1. a report with all accounts and all transactions
2. a report with all transactions, numbered, and then on which
   accounts they were posted.
3. Possibility to use "," as the decimal point.

The two reports is what I normally get from my accountant, eg
I got it for my 1999 statement.
   
Some things that would have made my life easier:

1. when I enter a new transaction, that all items be filled out
   with the latest transaction. Very often I have two transactions with
   the same date, on the same accounts, but with different amounts.
   Or a series of transactions on the same bank account. Or the dates
   only vary a little such as the day of the month. AMybe the only thing not
   to prefill is the amount. Or maybe do, it could also be a series of
   monthly payments.

2. Nah, 1. was the most important. All in all I liked sql-ledger.
   Now lets see what my accountant says. And I will make a talk today
   to about 70 people here in Copenhagen about sql-ledger.

Kind regards
Keld Simonsen

RE: [SQL-Ledger-users] Problems with logging in to sql-ledger

[<ufo...@ea...>]

If you poke around in your perl dir, you'll see a a "1386-linux" and a
"site-perl/i386-linux".  Be sure that you have the modules in the first
one.  What I did after I found the problem was jsut to copy the modules
to that dir.  I think this also is affecting Ian.  So Ian, please check
this also.

			Wes

On Tue, 30 Jan 2001, David Rippel wrote:

> Well, for what it is worth, the make test for DBD::Pg works fine. Where
> should the perl modules be installed? Thanks for your help.
>
> -----Original Message-----
> From: ufo...@ea... [mailto:ufo...@ea...]
> Sent: Monday, January 29, 2001 7:56 PM
> To: Sql-Ledger-Users (E-mail)
> Subject: Re: [SQL-Ledger-users] Problems with logging in to sql-ledger
>
>
> I had  similar problem, and I believe it was because the perl modules
> were installed in the wrong dir.
>
> 				Good Luck,
> 				        Wes
>
>
> >On Mon, 29 Jan 2001, David Rippel wrote:
>
> > I've got everything working up to this point, but when I go to my
> login.cgi
> > and attempt to authenticate, here's what shows up in my error_log (from
> > apache)
> >
> >
> > install_driver(Pg) failed: Can't locate loadable object for module DBD::Pg
> > in @INC (@INC contains: utils /usr/lib/perl5/i386-linux /usr/lib/perl5
> > /usr/lib/perl5/site_perl/i386-linux /usr/lib/perl5/site_perl .) at (eval
> 1)
> > line 3
> > Compilation failed in require at (eval 1) line 3.
> > Perhaps a module that DBD::Pg requires hasn't been fully installed
> >  at /usr/local/apache/htdocs/sql-ledger/login.cgi line 66
> > [Mon Jan 29 09:19:20 2001] [error] [client 192.168.3.179] Premature end of
> > script headers: /usr/local/apache/htdocs/sql-ledger/login.cgi
> >
> >
> > I've done a full make install for both DBI and DBD::Pg, and all the tests
> > complete successfully. The paths for the postgres libs are in my global
> > ldconfig. There is a valid user for the system and no errors are coming
> from
> > the database end (in other words, I don't think it's getting that far).
> Any
> > ideas?
> >
> > Thanks,
> > David.
> >
> >
>
> ____________________________________________________________________________
> ____
> >From a different solar system, many many galaxies away...
>
>
>

________________________________________________________________________________
From a different solar system, many many galaxies away...

RE: [SQL-Ledger-users] Problem in Line 63 of login.cgi

[Ian <ia...@in...>]

Ok, I've tried that...
<snip a copy of ls -l>
drwxr-xrwx   2 accounti accounti     1024 Jan 29 10:38 admin
-rwxr-xr-x   1 1000     1000        34377 Nov 20 15:50 admin.cgi
-rwxr-xr-x   1 1000     1000        28390 Oct 25 21:54 ap.cgi
-rwxr-xr-x   1 1000     1000        26747 Oct 27 13:39 ar.cgi
-rwxr-xr-x   1 1000     1000         9372 Oct 27 16:05 ca.cgi
-rw-rw----   1 1000     1000          993 Jan 22 18:09 copyright
-rwxr-xr-x   1 1000     1000        15179 Jan  7 20:46 ct.cgi
-rwxr-xr-x   1 1000     1000        14000 Oct 25 22:10 gl.cgi
-rw-r--r--   1 1000     1000        18240 Jan  9  1999 gnu.html
-rwxr-xr-x   1 1000     1000        16761 Oct 25 22:35 ic.cgi
-rwxr-xr-x   1 1000     1000        33392 Oct 25 23:27 ir.cgi
-rwxr-xr-x   1 1000     1000        34021 Oct 25 23:57 is.cgi
drwxrwxr-x   7 accounti accounti     1024 Jan  3 14:29 locale
-rwxr-xr-x   1 1000     1000         8133 Jan 29 08:19 login.cgi
-rwxr-xr-x   1 1000     1000        13809 Sep 10 17:27 rp.cgi
-rw-r--r--   1 1000     1000          809 Jun 21  2000 sql-ledger.gif
drwxrwxr-x   3 accounti accounti     1024 Nov 20 22:14 templates
drwx--x--x   2 nobody   nobody       1024 Jan 29 16:46 users
drwxr-xr-x   2 1000     1000         1024 Jul 24  2000 utils
</snip>

Ok, that's been done, now here's the relevant lines from the error_log file
from apache.

<snip>
Can't locate users/ian.config in @INC (@INC contains: utils
/usr/lib/perl5/5.00503/i386-linux /usr/lib/perl5/5.00503
/usr/lib/perl5/site_perl/5.005/i386-linux /usr/lib/perl5/site_perl/5.005 .)
at /home/httpd/html/sql-ledger/login.cgi line 63.
</snip>


Any Help?

Ian
-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of Dieter
Simader
Sent: Monday, January 29, 2001 4:23 PM
To: sql...@li...
Subject: Re: [SQL-Ledger-users] Problem in Line 63 of login.cgi


This is a permission problem. If your server runs as nobody.nogroup set it
to

drwx--x--x   2 nobody nogroup        1024 Jan 23 19:15 users/


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Mon, 29 Jan 2001, Ian (the webguy) wrote:

>
> Hi.
>      I've been having problems with a RedHat Install of the SQL-Ledger
> program.  I've followed instructions that have been provided in the FAQ
> (There were some changes going from RH 7 back to 6--mainly which package
to
> use), and I'm still coming up with HTTP 500 Errors.  When I look in the
> apache log, it gives me an 'premature end of script headers' on line 63.
>      I haven't touched any of the source code, so I'm going to take a
> random guess and say that it's in the install.  I've looked in the users
> directory (line 63 looks for the /users/{username}.config file), and I
have
> no files (which is probably the reason why it's spitting out 500's).  What
> goes into the /users/ directory?  Where is the code (which file) that
> writes to the /users/{username}.config file?  What is suppossed to be in
> the file, and are there any quick and easy fixes around this?
>
>
> Thanks for your help in advance,
> Ian
> ----
> Ian W., CNE, CNA, EMT-B.
> Webmaster, Internationalsportsagency.com
> A division of Remani International
>
> "Network Administration:  It's a dirty job, but someone made me do it."
>
>

RE: [SQL-Ledger-users] evaluation of sql-ledger

[Scott T. <st...@ne...>]

The Wireless Application Protocol (WAP) is an open, global specification
which gives mobile users with wireless devices the opportunity to easily
access and interact with information and services. The protocol is developed
by WAP Forum http://www.wapforum.org/, an organization of some of the most
powerful Internet and telecom companies.


-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of R.
Ransbottom
Sent: Tuesday, January 30, 2001 3:28 AM
To: 'sql...@li...'
Subject: RE: [SQL-Ledger-users] evaluation of sql-ledger


On Mon, 29 Jan 2001, Ing. Antonio A. Gallardo wrote:

> I apologize and you are right about that. But maybe WAP can be the
solution.

What is WAP?

RE: [SQL-Ledger-users] Problems with logging in to sql-ledger

[David R. <dr...@ri...>]

Well, for what it is worth, the make test for DBD::Pg works fine. Where
should the perl modules be installed? Thanks for your help.

-----Original Message-----
From: ufo...@ea... [mailto:ufo...@ea...]
Sent: Monday, January 29, 2001 7:56 PM
To: Sql-Ledger-Users (E-mail)
Subject: Re: [SQL-Ledger-users] Problems with logging in to sql-ledger


I had  similar problem, and I believe it was because the perl modules
were installed in the wrong dir.

				Good Luck,
				        Wes


>On Mon, 29 Jan 2001, David Rippel wrote:

> I've got everything working up to this point, but when I go to my
login.cgi
> and attempt to authenticate, here's what shows up in my error_log (from
> apache)
>
>
> install_driver(Pg) failed: Can't locate loadable object for module DBD::Pg
> in @INC (@INC contains: utils /usr/lib/perl5/i386-linux /usr/lib/perl5
> /usr/lib/perl5/site_perl/i386-linux /usr/lib/perl5/site_perl .) at (eval
1)
> line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a module that DBD::Pg requires hasn't been fully installed
>  at /usr/local/apache/htdocs/sql-ledger/login.cgi line 66
> [Mon Jan 29 09:19:20 2001] [error] [client 192.168.3.179] Premature end of
> script headers: /usr/local/apache/htdocs/sql-ledger/login.cgi
>
>
> I've done a full make install for both DBI and DBD::Pg, and all the tests
> complete successfully. The paths for the postgres libs are in my global
> ldconfig. There is a valid user for the system and no errors are coming
from
> the database end (in other words, I don't think it's getting that far).
Any
> ideas?
>
> Thanks,
> David.
>
>

____________________________________________________________________________
____
From a different solar system, many many galaxies away...

RE: [SQL-Ledger-users] evaluation of sql-ledger

[R. R. <ri...@me...>]

On Mon, 29 Jan 2001, Ing. Antonio A. Gallardo wrote:

> I apologize and you are right about that. But maybe WAP can be the solution.

What is WAP?

RE: [SQL-Ledger-users] evaluation of sql-ledger

[Craig J. <cr...@sm...>]

Hi Antonio,
Until Dieter said that he had wap planned as an interface I hadn't=20
thought about it, But it defenatly gets my vote. Then it would mean I ca=
n=20
access sql-ledger without having to boot up my laptop. Or those times I =

don't have my laptop available while out of the office.
Regards
  Craig Jansen (CeeJay Computer Services)
   PH: 64 21 144 1851	FAX: 64 6 323 2060
   http://www.cjcs.yi.org


Original Message dated 1/30/01, 5:48:22 PM
Author: "Ing. Antonio A. Gallardo" <ag...@ma...>
Re: RE: [SQL-Ledger-users] evaluation of sql-ledger:

I apologize and you are right about that. But maybe WAP can be the=20
solution. What you think about?
Antonio Gallardo

[Ing. Antonio A. Gallardo]  -----Mensaje original-----

RE: [SQL-Ledger-users] evaluation of sql-ledger

[Ing. A. A. G. <ag...@ma...>]

I apologize and you are right about that. But maybe WAP can be the =
solution.
What you think about?
=20
Antonio Gallardo

[Ing. Antonio A. Gallardo]  -----Mensaje original-----
De: sql...@li...
[mailto:sql...@li...]En nombre de Kurt =
Seel
Enviado el: S=E1bado, 27 de Enero de 2001 10:58 a.m.
Para: sql...@li...
Asunto: Re: [SQL-Ledger-users] evaluation of sql-ledger



Craig Jansen wrote:=20

 =20

Hi Antonio,=20


It is true the GUI interface to applications is by far more inviting to =
a
lot of people. MS aside (I Don't Use Any MS Products) :)

 Kudos. I am glad that I am not the only one trying to do this :-)=20

While 95% of the terminals in my office are running X-Windows and are
capable of graphical web browsing I also have a number of "OLD" Wyse =
dumb
terminals

 Ah, the original lite (or light, as in green) client.=20

which are currently being used for stock control & order entry. In the =
long
term I plan on getting SQL-Ledger to integrate with with my current =
stock
control software. The only role of these terminals is for employees who =
have
no need for me to spend money on setting them up with a fully fledged =
PC. I
may upgrade them to X-Terms one day but at this point in time it's =
easier
for me to develop something for SQL-Ledger in my spare time.

 What does linx do with sql-ledger? I would guess if can do frames=20
it's got a chance ...=20

 =20

I also have a client who has a string of these type of terminals on his =
shop
floor. I currently have him interested in setting up a Linux box with
SQL-Ledger in the future.=20


Hope that sheds some light on why I'm developing a "Terminal" frontend. =
:)=20


Regards=20


Craig Jansen (CeeJay Computer Services=20


PH: 64 21 144 1851 FAX: 64 6 323 2060=20


http://www.cjcs.yi.org <http://www.cjcs.yi.org/> =20
 =20




  _____ =20


Original Message dated 1/27/01, 8:23:26 PM=20


Author: "Ing. Antonio A. Gallardo" <ag...@ma...>=20


Re: RE: [SQL-Ledger-users] evaluation of sql-ledger:=20


  _____ =20


Please explain why you are creating a terminal frontend to SQL-Ledger. =
I
think that Web based Applications is the new wave of office products. =
Let
see at MS .net project for example.=20
 =20
 =20
=20

--=20

 In theory, there is no difference between theory

and practice. In practice, however, there is.

 - Albert Einstein
 =20

RE: [SQL-Ledger-users] evaluation of sql-ledger

[Ing. A. A. G. <ag...@ma...>]

MySQL revisited again.

Pleased check what happens when you put more than 2 Millions of rows on =
a
MySQL DB and then try the same on PostgreSQL, then we can talk about =
truly
DB performance.

FYI one of the largest DB in the world is a 60 GB DB on Japan and this =
DB
dont choice MySQL because his lack performance on a very large DB. This =
DB
run on PostgreSQL.

Antonio Gallardo.



-----Mensaje original-----
De: sql...@li...
[mailto:sql...@li...]En nombre de Kim =
C.
Callis
Enviado el: S=E1bado, 27 de Enero de 2001 04:25 a.m.
Para: sql...@li...
Asunto: Re: [SQL-Ledger-users] evaluation of sql-ledger


"Ing. Antonio A. Gallardo" wrote:

>
>
> Hi Craig!
>
> Please explain why you are creating a terminal frontend to =
SQL-Ledger.
> I think that Web based Aplications is the new wave of office =
products.
> Let see at MS .net project for example.
>
> If you want, you can do anything with SQL-Ledger source. But the goal
> to archive is to create a account application Web-based.
>
> PHP is great, and maybe he will save us many problems about UI. =
Please
> Dieter explain us why you dont choose PHP in the develop of
> SQL-Ledger.
>
> I think that MySQL is a low-end DBMS. PostgreSQL is more powerfull =
and
> we will approach the powerful features of PostgreSQL. Dieter again,
> please answer us what you think about that.
>
> I will be glad to open a discussion about the Roadmap of SQL-Ledger =
to
> all the users.
>

I am curious about two of your above statements... First off, I think
that it is applaudable that Craig is attempting to create a curses
interface to SQL-Ledger. An application should be designed in such a =
way
that allows it to be modified to meet the needs of any end user. Take =
an
application like Quickbooks (since we are on an accounting path here!).
This is a nice application for some, but by no means does it really =
meet
the needs of all. Unfortunately, there is no real quick and easy way to
modify it to be useful. I think Craig gave a very valid explaination of
why he is doing such a modification.

Secondly, I was curious to hear about how you qualify your view of =
MySQL
being a "low -end" DBMS. The lacking feature of MySQL at one time was
handling transactions. Of course that was prior to 3.23, because that
requirement has been put in to production. From a benchmark =
perspective,
MySQL is in fact faster than PostgreSQL, by a significant margin. Of
course this was due to a transaction mechanism which easily made MySQL
faster. Nevertheless, although I am by no leaps and bounds a MySQL
evangelist, I will say that MySQL does a nice job of holding it's own.

Re: [SQL-Ledger-users] Problems with logging in to sql-ledger

[<ufo...@ea...>]

I had  similar problem, and I believe it was because the perl modules
were installed in the wrong dir.

				Good Luck,
				        Wes


>On Mon, 29 Jan 2001, David Rippel wrote:

> I've got everything working up to this point, but when I go to my login.cgi
> and attempt to authenticate, here's what shows up in my error_log (from
> apache)
>
>
> install_driver(Pg) failed: Can't locate loadable object for module DBD::Pg
> in @INC (@INC contains: utils /usr/lib/perl5/i386-linux /usr/lib/perl5
> /usr/lib/perl5/site_perl/i386-linux /usr/lib/perl5/site_perl .) at (eval 1)
> line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a module that DBD::Pg requires hasn't been fully installed
>  at /usr/local/apache/htdocs/sql-ledger/login.cgi line 66
> [Mon Jan 29 09:19:20 2001] [error] [client 192.168.3.179] Premature end of
> script headers: /usr/local/apache/htdocs/sql-ledger/login.cgi
>
>
> I've done a full make install for both DBI and DBD::Pg, and all the tests
> complete successfully. The paths for the postgres libs are in my global
> ldconfig. There is a valid user for the system and no errors are coming from
> the database end (in other words, I don't think it's getting that far). Any
> ideas?
>
> Thanks,
> David.
>
>

________________________________________________________________________________
From a different solar system, many many galaxies away...

Re: [SQL-Ledger-users] Version 1.2.7 setup.cgi

[Paul A. <pau...@pa...>]

This is a very common issue. Maybe a FAQ can help. Phil, edit your
/etc/httpd/conf/httpd.conf file and make sure you have a line like this:

AddHandler cgi-script .cgi .pl

This will enable you to execute the .cgi files.
-pa

----- Original Message -----
From: Burness, Phil <pbu...@fo...>
To: <sql...@li...>
Sent: Monday, January 29, 2001 7:03 AM
Subject: [SQL-Ledger-users] Version 1.2.7 setup.cgi


> I have followed all the notes in the Readme file, and the instructions for
> using with RH7.0 in the FAQ, however whenever I access
> sql-ledger/admin/setup.cgi all I get displayed is :-content-type:
text/html
>
> Anybody know why?
> Phil
>
> PS
> I created a small perl script in the same directory to display the
> environment variables ( set with the same permissions etc. as the
setup.cgi
> script) and it runs OK.
>
>

Re: [SQL-Ledger-users] Problem in Line 63 of login.cgi

[Dieter S. <dsi...@sq...>]

This is a permission problem. If your server runs as nobody.nogroup set it
to

drwx--x--x   2 nobody nogroup        1024 Jan 23 19:15 users/


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Mon, 29 Jan 2001, Ian (the webguy) wrote:

> 
> Hi.
>      I've been having problems with a RedHat Install of the SQL-Ledger
> program.  I've followed instructions that have been provided in the FAQ
> (There were some changes going from RH 7 back to 6--mainly which package to
> use), and I'm still coming up with HTTP 500 Errors.  When I look in the
> apache log, it gives me an 'premature end of script headers' on line 63.  
>      I haven't touched any of the source code, so I'm going to take a
> random guess and say that it's in the install.  I've looked in the users
> directory (line 63 looks for the /users/{username}.config file), and I have
> no files (which is probably the reason why it's spitting out 500's).  What
> goes into the /users/ directory?  Where is the code (which file) that
> writes to the /users/{username}.config file?  What is suppossed to be in
> the file, and are there any quick and easy fixes around this?
> 
> 
> Thanks for your help in advance,
> Ian
> ----
> Ian W., CNE, CNA, EMT-B.
> Webmaster, Internationalsportsagency.com
> A division of Remani International
> 
> "Network Administration:  It's a dirty job, but someone made me do it."
> 
> 

RE: [SQL-Ledger-users] Re: Problems with logging in to sql-ledger

[David R. <dr...@ri...>]

Andre -

Thanks for the advice, however, after checking all of the permissions, I
still am getting the same error (see original message below). Any other
ideas - anyone? All help is most appreciated.

- David

-----Original Message-----
From: Andre Felipe Machado [mailto:and...@te...]
Sent: Monday, January 29, 2001 12:56 PM
To: sql...@li...
Subject: [SQL-Ledger-users] Re: Problems with logging in to sql-ledger


Hello,
I am a newbie, but I struggled with similar problem.
Well, your dbd:pg and dbi installations found "utils" at @inc include 
path. Fine. But I guess that your problem is with directory and file 
permissions to Apache.
Try to set utils subdirectory, and its files, to user and group 
nobody.nobody (or nobody.nogroup at some distributions) default Apache 
user and group settings permissions.
Also, check for executable and read write permission.
Good luck.
Andre Felipe Machado


>>>>>>>>>>>>>>>>>> Mensagem anterior <<<<<<<<<<<<<<<<<<

No dia 29/01/01, 12:21:14, David Rippel <dr...@ri...> escreveu o 
seguinte sobre o tema [SQL-Ledger-users] Problems with logging in to 
sql-ledger:


> I've got everything working up to this point, but when I go to my 
login.cgi
> and attempt to authenticate, here's what shows up in my error_log (from
> apache)


> install_driver(Pg) failed: Can't locate loadable object for module 
DBD::Pg
> in @INC (@INC contains: utils /usr/lib/perl5/i386-linux /usr/lib/perl5
> /usr/lib/perl5/site_perl/i386-linux /usr/lib/perl5/site_perl .) at (eval 
1)
> line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a module that DBD::Pg requires hasn't been fully installed
>  at /usr/local/apache/htdocs/sql-ledger/login.cgi line 66
> [Mon Jan 29 09:19:20 2001] [error] [client 192.168.3.179] Premature end 
of
> script headers: /usr/local/apache/htdocs/sql-ledger/login.cgi


> I've done a full make install for both DBI and DBD::Pg, and all the tests
> complete successfully. The paths for the postgres libs are in my global
> ldconfig. There is a valid user for the system and no errors are coming 
from
> the database end (in other words, I don't think it's getting that far). 
Any
> ideas?

> Thanks,
> David.

[SQL-Ledger-users] Problem in Line 63 of login.cgi

[Ian \(t. webguy\) <ia...@in...>]

Hi.
     I've been having problems with a RedHat Install of the SQL-Ledger
program.  I've followed instructions that have been provided in the FAQ
(There were some changes going from RH 7 back to 6--mainly which package to
use), and I'm still coming up with HTTP 500 Errors.  When I look in the
apache log, it gives me an 'premature end of script headers' on line 63.  
     I haven't touched any of the source code, so I'm going to take a
random guess and say that it's in the install.  I've looked in the users
directory (line 63 looks for the /users/{username}.config file), and I have
no files (which is probably the reason why it's spitting out 500's).  What
goes into the /users/ directory?  Where is the code (which file) that
writes to the /users/{username}.config file?  What is suppossed to be in
the file, and are there any quick and easy fixes around this?


Thanks for your help in advance,
Ian
----
Ian W., CNE, CNA, EMT-B.
Webmaster, Internationalsportsagency.com
A division of Remani International

"Network Administration:  It's a dirty job, but someone made me do it."

[SQL-Ledger-users] Re: Problems with logging in to sql-ledger

[Andre F. M. <and...@te...>]

Hello,
I am a newbie, but I struggled with similar problem.
Well, your dbd:pg and dbi installations found "utils" at @inc include=20
path. Fine. But I guess that your problem is with directory and file=20
permissions to Apache.
Try to set utils subdirectory, and its files, to user and group=20
nobody.nobody (or nobody.nogroup at some distributions) default Apache=20
user and group settings permissions.
Also, check for executable and read write permission.
Good luck.
Andre Felipe Machado


>>>>>>>>>>>>>>>>>> Mensagem anterior <<<<<<<<<<<<<<<<<<

No dia 29/01/01, 12:21:14, David Rippel <dr...@ri...> escreveu o=
=20
seguinte sobre o tema [SQL-Ledger-users] Problems with logging in to=20
sql-ledger:


> I've got everything working up to this point, but when I go to my=20
login.cgi
> and attempt to authenticate, here's what shows up in my error_log (fro=
m
> apache)


> install_driver(Pg) failed: Can't locate loadable object for module=20
DBD::Pg
> in @INC (@INC contains: utils /usr/lib/perl5/i386-linux /usr/lib/perl5=

> /usr/lib/perl5/site_perl/i386-linux /usr/lib/perl5/site_perl .) at (ev=
al=20
1)
> line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a module that DBD::Pg requires hasn't been fully installed
>  at /usr/local/apache/htdocs/sql-ledger/login.cgi line 66
> [Mon Jan 29 09:19:20 2001] [error] [client 192.168.3.179] Premature en=
d=20
of
> script headers: /usr/local/apache/htdocs/sql-ledger/login.cgi


> I've done a full make install for both DBI and DBD::Pg, and all the te=
sts
> complete successfully. The paths for the postgres libs are in my globa=
l
> ldconfig. There is a valid user for the system and no errors are comin=
g=20
from
> the database end (in other words, I don't think it's getting that far)=
.=20
Any
> ideas?

> Thanks,
> David.

[SQL-Ledger-users] Problems with logging in to sql-ledger

[David R. <dr...@ri...>]

I've got everything working up to this point, but when I go to my login.cgi
and attempt to authenticate, here's what shows up in my error_log (from
apache)


install_driver(Pg) failed: Can't locate loadable object for module DBD::Pg
in @INC (@INC contains: utils /usr/lib/perl5/i386-linux /usr/lib/perl5
/usr/lib/perl5/site_perl/i386-linux /usr/lib/perl5/site_perl .) at (eval 1)
line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a module that DBD::Pg requires hasn't been fully installed
 at /usr/local/apache/htdocs/sql-ledger/login.cgi line 66
[Mon Jan 29 09:19:20 2001] [error] [client 192.168.3.179] Premature end of
script headers: /usr/local/apache/htdocs/sql-ledger/login.cgi


I've done a full make install for both DBI and DBD::Pg, and all the tests
complete successfully. The paths for the postgres libs are in my global
ldconfig. There is a valid user for the system and no errors are coming from
the database end (in other words, I don't think it's getting that far). Any
ideas?

Thanks,
David.

[SQL-Ledger-users] Version 1.2.7 setup.cgi

[Burness, P. <pbu...@fo...>]

I have followed all the notes in the Readme file, and the instructions for
using with RH7.0 in the FAQ, however whenever I access
sql-ledger/admin/setup.cgi all I get displayed is :-content-type: text/html

Anybody know why?
Phil

PS 
I created a small perl script in the same directory to display the
environment variables ( set with the same permissions etc. as the setup.cgi
script) and it runs OK.

Re: [SQL-Ledger-users] dir templates moved from default location

[Dieter S. <dsi...@sq...>]

Changing the path from "templates" to "../templates" breaks the code.

You could have simply turned off all the Options for the templates
directory in your httpd.conf file.  This is much safer than fiddling with
the path.

The same goes for the users directory to prevent prying eyes from seeing
that plain text password.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Wed, 28 Feb 2001, warez69 wrote:

> there is a reson.
> for security reason "follow symbolic links disabled in cgi dirs. so i've
> just changed path to "templates" in setup.cgi frpm "templates" to
> "../templates" and it work for me perfectly.
> send me e-mail if you 'll need futher information about it.
> kindest regards.
> Alexander Moloksher.
> 
> 
> ----- Original Message -----
> From: "Jody Brown" <jo...@sa...>
> To: <sql...@li...>
> Sent: Sunday, January 28, 2001 6:25 AM
> Subject: Re: [SQL-Ledger-users] dir templates moved from default location
> 
> 
> > is there any reason you cant simply symlink it?
> > ln -s /var/www/html/templates /var/www/html/sql-ledger/templates
> >
> > user <us...@co...> said:
> >
> > > Hello there.
> > > i just installed sql-ledger for the first time. everything seems to
> > > work  well. but i need to move dir "templates" from
> > > /var/www/html/sql-ledger to var/www/html/templates.
> > >
> > > where exactly i should change path to it, so software will recognize new
> > > directory as templates dir. must be glbal varieble for templates dir
> > > somewhere.
> > >
> > > please help me out. i really stucked there.
> > >
> > > kindest regards.
> > > Alexander Moloksher
> > >
> > > us...@co...
> > >
> > >
> >
> >
> >
> > --
> >
> >
> >
> >
> >
> 
> 

RE: [SQL-Ledger-users] evaluation of sql-ledger

[Dieter S. <dsi...@sq...>]

It's in internal use/testing. There are a few more things I have to tidy
up before I release it.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Sat, 27 Jan 2001 mp...@ma... wrote:

> Can you give us some information about the how and maybe if were lucky
> then when(like its in design phase, were coding, internal testing etc)?
> 
> Scott
> On Sat, 27 Jan 2001, Dieter Simader wrote:
> > I should mention here that the new version (not yet released) seperates
> > the backend code from the display. It will be possible to use sql-ledger
> > from a browser such as Netscape, MS Explorer, ... and lynx for now, a
> > console and wap interface is also planned. 
> 
> 

Re: [SQL-Ledger-users] evaluation of sql-ledger

[Donald T. <dt...@bm...>]

Or you can use links, a lynx-based browser with frame support.
Links is text WWW browser, similar to Lynx. Links displays tables, downloads
on background and uses HTTP/1.1 keepalive connections.

See http://freshmeat.net/projects/links/?highlight=links for more info.

----- Original Message -----
From: "Fleet Teachout" <fl...@pa...>
To: <sql...@li...>
Sent: Sunday, January 28, 2001 6:31 AM
Subject: Re: [SQL-Ledger-users] evaluation of sql-ledger


> At 09:47 1/28/01 +0100, you wrote:
> >Why not make sql-ledger available in a frame-free version, and then make
> >it easier for non-mouse applications? Like having shurtcut keys.
> >Then sql-ledger could be quite versatile out of the box with lynx etc.
>
> Right on!
>
> - fleet -

Re: [SQL-Ledger-users] evaluation of sql-ledger

[Fleet T. <fl...@pa...>]

At 09:47 1/28/01 +0100, you wrote:
>Why not make sql-ledger available in a frame-free version, and then make
>it easier for non-mouse applications? Like having shurtcut keys.
>Then sql-ledger could be quite versatile out of the box with lynx etc.

Right on!

					- fleet -

Re: [SQL-Ledger-users] evaluation of sql-ledger

[<ke...@dk...>]

On Sun, Jan 28, 2001 at 12:24:51AM +0000, Craig Jansen wrote:
>            >Ah, the original lite (or light, as in green) client. 
> Pretty much, I have a Wy120 (Black and White), a Wy50+ (Green) and 2 
> Wy99gt (Green) Terminals.
>  >What does linx do with sql-ledger? I would guess if can do frames 
>  >it's got a chance ... 
> Lynx works ok with it. The only problem is Lynx doesn't support frames 
> and make navigation a tedious process & time consuming.

Why not make sql-ledger available in a frame-free version, and then make
it easier for non-mouse applications? Like having shurtcut keys.
Then sql-ledger could be quite versatile out of the box with lynx etc.

Kind regards
keld

Re: [SQL-Ledger-users] dir templates moved from default location

[warez69 <wa...@bi...>]

there is a reson.
for security reason "follow symbolic links disabled in cgi dirs. so i've
just changed path to "templates" in setup.cgi frpm "templates" to
"../templates" and it work for me perfectly.
send me e-mail if you 'll need futher information about it.
kindest regards.
Alexander Moloksher.


----- Original Message -----
From: "Jody Brown" <jo...@sa...>
To: <sql...@li...>
Sent: Sunday, January 28, 2001 6:25 AM
Subject: Re: [SQL-Ledger-users] dir templates moved from default location


> is there any reason you cant simply symlink it?
> ln -s /var/www/html/templates /var/www/html/sql-ledger/templates
>
> user <us...@co...> said:
>
> > Hello there.
> > i just installed sql-ledger for the first time. everything seems to
> > work  well. but i need to move dir "templates" from
> > /var/www/html/sql-ledger to var/www/html/templates.
> >
> > where exactly i should change path to it, so software will recognize new
> > directory as templates dir. must be glbal varieble for templates dir
> > somewhere.
> >
> > please help me out. i really stucked there.
> >
> > kindest regards.
> > Alexander Moloksher
> >
> > us...@co...
> >
> >
>
>
>
> --
>
>
>
>
>

Re: [SQL-Ledger-users] dir templates moved from default location

[warez69 <wa...@bi...>]

i've done with great success. what i've done is just changed path to
template directory in user.conf file from "templates" to "../templates"
which is reflect my current relative path to templates directory.also ive
cganged in setup.cgi file path to "templates" to "../templates". So next
user will automaticaly save their settings with correct path to templates.
this is a very good idea to move html executabales from cgi stuff away for
security reasons. cause i've disabled text and html contents view and
execution in main cgi directory of sql-ledger.
kindest regards.
Alexander Moloksher
IT consultant.
----- Original Message -----
From: "Dieter Simader" <dsi...@sq...>
To: <sql...@li...>
Sent: Sunday, January 28, 2001 4:45 AM
Subject: Re: [SQL-Ledger-users] dir templates moved from default location


> The templates directory is part of the sql-ledger tree and cannot be
> moved. You can symlink to another directory though.
>
> sql-ledger/templates => /var/www/html/templates
>
>
> Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
> DWS Systems Inc.     Accounting Software       Fax: 478-5281
> =========== On a clear disk you can seek forever ===========
>
> On Sun, 28 Jan 2001, user wrote:
>
> > Hello there.
> > i just installed sql-ledger for the first time. everything seems to
> > work  well. but i need to move dir "templates" from
> > /var/www/html/sql-ledger to var/www/html/templates.
> >
> > where exactly i should change path to it, so software will recognize new
> > directory as templates dir. must be glbal varieble for templates dir
> > somewhere.
> >
> > please help me out. i really stucked there.
> >
> > kindest regards.
> > Alexander Moloksher
> >
> > us...@co...
> >
>
>
>