sql-ledger-users

Problems with 1.4.?

[Jess <je...@oz...>]

Hi Dieter,

Just to make this clear straight of the bat prior to version 1.4 of
SQL-Ledger I had no problems running SQL-Ledger in the 1.2.* variety.

I clean installed SQL ledger.

Now I cleaned out all the SQL tables and downloaded SQL-Ledger 1.4.4 from
your Web Site unpacked it and recreated the tables from the acc-PG.sql file.
I removed any traces of the previous SQL-LEDGER 1.2.* which was working.
I then move the SQL-Ledger directory with the login.pl and sql-ledger.conf
file and all subdirectories to the web document root called
/www/websites/bookmen/sqll  I also created any directories that where called
in the sql-ledger.conf file so that it could find anything it was looking
for.
I read the FAQ and the README and it said to:

SETUP A USER:
-------------
Load your web browser and enter the URL
http://localhost/cgi-bin/sql-ledger/admin.pl and add a user. If you specify
a different database then the one you just created
in the previous step, make sure the database and tables exist.
(see previous step) LOAD THE ACCOUNTING PROGRAM:
----------------------------
Load your web browser and enter the URL
http://localhost/cgi-bin/sql-ledger/login.pl


Now there is no http://localhost/cgi-bin/sql-ledger/admin.pl in that
directory there is only login.pl and am.pl

If I open the admin.pl in the "bin/mozilla" directory the is no shebang line
or "require" command for the .conf file on any of these files which leads me
to believe that these files are read into a calling .pl file probably
login.pl.

How do you add or create a user?    What .pl file in what directory needs to
be run and what needs to be entered in the Browser URL to call it?

There is something fundamental I am not aware of that must be causing these
problems?
Your assistence is needed.

SQL Ledger is being run on W2K Pro with PG 703 and perl5, apache 1.3.14.

Regards Jess

Re: Problems with 1.4.?

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

symlink admin.pl to login.pl


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, 10 Jun 2001, Jess wrote:
> 
> Now there is no http://localhost/cgi-bin/sql-ledger/admin.pl in that
> directory there is only login.pl and am.pl

Re: Problems with 1.4.?

[Jess <je...@oz...>]

Hi Dieter,
What is a symlink? I don't believe that exists in Windows 2000 Pro does it.?
How can I set it up to work under W2K-Pro?

Thankyou for your help.

Regards Jess




----- Original Message -----
From: "Dieter Simader" <dsi...@sq...>
To: <sql...@li...>
Sent: Sunday, 10 June, 2001 2:00 AM
Subject: Re: Problems with 1.4.?


> symlink admin.pl to login.pl
>
>
> 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, 10 Jun 2001, Jess wrote:
> >
> > Now there is no http://localhost/cgi-bin/sql-ledger/admin.pl in that
> > directory there is only login.pl and am.pl
>
>
>

Re: Problems with 1.4.?

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

A symlink is a link to another file. To substitute for the symlinks you
can do the following.

Thanks to Martin Lillepuu who patched 1.4.5 to work with Win2K

Here is a manual patch.

Edit login.pl and am.pl and change the first line
#!/usr/bin/perl to #!c:/perl/bin/perl.exe

Substitute c:/perl/bin with wherever your perl is installed. I suppose
#!perl will work too as long as the path is included in the PATH
environment variable

copy login.pl to admin.pl

copy am.pl to
ap.pl
ar.pl
ca.pl
rp.pl
ct.pl
gl.pl
ic.pl
ir.pl
is.pl
menu.pl


Edit SL/Form.pm and change line 158 to

    exec "c:/perl/bin/perl.exe", $argv;


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, 10 Jun 2001, Jess wrote:

> Hi Dieter,
> What is a symlink? I don't believe that exists in Windows 2000 Pro does it.?
> How can I set it up to work under W2K-Pro?
> 
> Thankyou for your help.
> 
> Regards Jess

Re: Problems with 1.4.?

[Andrew S. <an...@ne...>]

On windoze, I've always had good luck getting the windows "shortcut"
concept to work in the place of unix symlinks.  I don't know how to
create shortcuts from the DOS command line, but they are easy enough
to create with the UI.

a

Dieter Simader wrote:
> 
> A symlink is a link to another file. To substitute for the symlinks you
> can do the following.
> 
> Thanks to Martin Lillepuu who patched 1.4.5 to work with Win2K
> 
> Here is a manual patch.
> 
> Edit login.pl and am.pl and change the first line
> #!/usr/bin/perl to #!c:/perl/bin/perl.exe
> 
> Substitute c:/perl/bin with wherever your perl is installed. I suppose
> #!perl will work too as long as the path is included in the PATH
> environment variable
> 
> copy login.pl to admin.pl
> 
> copy am.pl to
> ap.pl
> ar.pl
> ca.pl
> rp.pl
> ct.pl
> gl.pl
> ic.pl
> ir.pl
> is.pl
> menu.pl
> 
> Edit SL/Form.pm and change line 158 to
> 
>     exec "c:/perl/bin/perl.exe", $argv;
> 
> 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, 10 Jun 2001, Jess wrote:
> 
> > Hi Dieter,
> > What is a symlink? I don't believe that exists in Windows 2000 Pro does it.?
> > How can I set it up to work under W2K-Pro?
> >
> > Thankyou for your help.
> >
> > Regards Jess

Apache denied access problem.

[Jess <je...@oz...>]

On version 1.4.5 of SQL-Ledger.

When I run the admin.pl script I get this error after I press submit with or
without a password.
-----------------
Error!
Permission denied: users/members
-----------------
The file in users/members/ is the default "members" that comes with
SQL-Ledger.

Now this is running under Windoze 2000 Pro but on a FAT32 partition so there
is no direct support for file permissions where the files are.  (This is
just a development system, so I can understand how the security system in
Apache works which is currently eluding me.).
So I believe it is Apache restricting access to this area.  The virtual host
section is set as:
-----------------------------------------
<VirtualHost 192.168.10.13>
ServerAdmin me...@oz...
DocumentRoot /www/websites/bookmen
ServerName 192.168.10.13
ScriptAlias   /cgi-bin/     /www/websites/bookmen/cgi-bin/
    <Directory /www/websites/bookmen>
        Options FollowSymLinks Includes Multiviews
        Order allow,deny
        Allow from all
    </Directory>
Alias    /sqll/    /www/websites/bookmen/sqll/
    <Directory /www/websites/bookmen/sqll>
        Options FollowSymLinks ExecCGI Includes Multiviews
    </Directory>
ErrorLog /www/websites/bookmen/logs/error_log
TransferLog /www/websites/bookmen/logs/access_log
</VirtualHost>
----------------------------------------

/www/websites/bookmen/sqll is the path to SQL-Ledger tree hierarchy.

Can anyone see a problem why I would get :
-----------------
Error!
Permission denied: users/members
-----------------

Regards Jess

RE: Apache denied access problem.

[Alexander O. <ao...@pr...>]

that means that directory is not accessible through apache
you might have to change permissions
start with:
chmod 0777 users/members
chmod 0777 users/members/*

change to 0777 just to make sure that was the problem,
then tweak the permissions to your desired security level

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of Jess
Sent: Thursday, June 14, 2001 3:52 AM
To: sql...@li...
Subject: Apache denied access problem.


On version 1.4.5 of SQL-Ledger.

When I run the admin.pl script I get this error after I press submit with or
without a password.
-----------------
Error!
Permission denied: users/members
-----------------
The file in users/members/ is the default "members" that comes with
SQL-Ledger.

Now this is running under Windoze 2000 Pro but on a FAT32 partition so there
is no direct support for file permissions where the files are.  (This is
just a development system, so I can understand how the security system in
Apache works which is currently eluding me.).
So I believe it is Apache restricting access to this area.  The virtual host
section is set as:
-----------------------------------------
<VirtualHost 192.168.10.13>
ServerAdmin me...@oz...
DocumentRoot /www/websites/bookmen
ServerName 192.168.10.13
ScriptAlias   /cgi-bin/     /www/websites/bookmen/cgi-bin/
    <Directory /www/websites/bookmen>
        Options FollowSymLinks Includes Multiviews
        Order allow,deny
        Allow from all
    </Directory>
Alias    /sqll/    /www/websites/bookmen/sqll/
    <Directory /www/websites/bookmen/sqll>
        Options FollowSymLinks ExecCGI Includes Multiviews
    </Directory>
ErrorLog /www/websites/bookmen/logs/error_log
TransferLog /www/websites/bookmen/logs/access_log
</VirtualHost>
----------------------------------------

/www/websites/bookmen/sqll is the path to SQL-Ledger tree hierarchy.

Can anyone see a problem why I would get :
-----------------
Error!
Permission denied: users/members
-----------------

Regards Jess

Re: Apache denied access problem.

[Jess <je...@oz...>]

Thanks for the reply Alexander.

But as I mentioned below this is on a Windoze 2000 Pro on a FAT32 partition
that does not support file system level permissions, so as far as W2K pro is
concerned all files on a FAT32 are available to anyone who has user access
to that computer.  So in this situation I don't believe W2K is restricting
access to the users/members.

Any other ideas I could persue.

Regards Jess


----- Original Message -----
From: "Alexander Orozco" <ao...@pr...>
To: <sql...@li...>
Sent: Thursday, 14 June, 2001 8:51 PM
Subject: RE: Apache denied access problem.


> that means that directory is not accessible through apache
> you might have to change permissions
> start with:
> chmod 0777 users/members
> chmod 0777 users/members/*
>
> change to 0777 just to make sure that was the problem,
> then tweak the permissions to your desired security level
>
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...]On Behalf Of Jess
> Sent: Thursday, June 14, 2001 3:52 AM
> To: sql...@li...
> Subject: Apache denied access problem.
>
>
> On version 1.4.5 of SQL-Ledger.
>
> When I run the admin.pl script I get this error after I press submit with
or
> without a password.
> -----------------
> Error!
> Permission denied: users/members
> -----------------
> The file in users/members/ is the default "members" that comes with
> SQL-Ledger.
>
> Now this is running under Windoze 2000 Pro but on a FAT32 partition so
there
> is no direct support for file permissions where the files are.  (This is
> just a development system, so I can understand how the security system in
> Apache works which is currently eluding me.).
> So I believe it is Apache restricting access to this area.  The virtual
host
> section is set as:
> -----------------------------------------
> <VirtualHost 192.168.10.13>
> ServerAdmin me...@oz...
> DocumentRoot /www/websites/bookmen
> ServerName 192.168.10.13
> ScriptAlias   /cgi-bin/     /www/websites/bookmen/cgi-bin/
>     <Directory /www/websites/bookmen>
>         Options FollowSymLinks Includes Multiviews
>         Order allow,deny
>         Allow from all
>     </Directory>
> Alias    /sqll/    /www/websites/bookmen/sqll/
>     <Directory /www/websites/bookmen/sqll>
>         Options FollowSymLinks ExecCGI Includes Multiviews
>     </Directory>
> ErrorLog /www/websites/bookmen/logs/error_log
> TransferLog /www/websites/bookmen/logs/access_log
> </VirtualHost>
> ----------------------------------------
>
> /www/websites/bookmen/sqll is the path to SQL-Ledger tree hierarchy.
>
> Can anyone see a problem why I would get :
> -----------------
> Error!
> Permission denied: users/members
> -----------------
>
> Regards Jess
>
>
>
>
>

Re: Apache denied access problem.

[German D. <g_d...@ya...>]

FAT32 and NTFS have different restrictions as you have
mentioned. I encountered the same problem with apache
and yes you have to have full access to the directory
otherwise it will give you error 403. If you go into
the directory where apache keeps its logs files and
check file error.log or error1.log you can see the
actual problem why the file is being locked and
preventing you access. Jerry
--- Jess <je...@oz...> wrote:
> Thanks for the reply Alexander.
> 
> But as I mentioned below this is on a Windoze 2000
> Pro on a FAT32 partition
> that does not support file system level permissions,
> so as far as W2K pro is
> concerned all files on a FAT32 are available to
> anyone who has user access
> to that computer.  So in this situation I don't
> believe W2K is restricting
> access to the users/members.
> 
> Any other ideas I could persue.
> 
> Regards Jess
> 
> 
> ----- Original Message -----
> From: "Alexander Orozco" <ao...@pr...>
> To: <sql...@li...>
> Sent: Thursday, 14 June, 2001 8:51 PM
> Subject: RE: Apache denied access problem.
> 
> 
> > that means that directory is not accessible
> through apache
> > you might have to change permissions
> > start with:
> > chmod 0777 users/members
> > chmod 0777 users/members/*
> >
> > change to 0777 just to make sure that was the
> problem,
> > then tweak the permissions to your desired
> security level
> >
> > -----Original Message-----
> > From: sql...@li...
> >
>
[mailto:sql...@li...]On
> Behalf Of Jess
> > Sent: Thursday, June 14, 2001 3:52 AM
> > To: sql...@li...
> > Subject: Apache denied access problem.
> >
> >
> > On version 1.4.5 of SQL-Ledger.
> >
> > When I run the admin.pl script I get this error
> after I press submit with
> or
> > without a password.
> > -----------------
> > Error!
> > Permission denied: users/members
> > -----------------
> > The file in users/members/ is the default
> "members" that comes with
> > SQL-Ledger.
> >
> > Now this is running under Windoze 2000 Pro but on
> a FAT32 partition so
> there
> > is no direct support for file permissions where
> the files are.  (This is
> > just a development system, so I can understand how
> the security system in
> > Apache works which is currently eluding me.).
> > So I believe it is Apache restricting access to
> this area.  The virtual
> host
> > section is set as:
> > -----------------------------------------
> > <VirtualHost 192.168.10.13>
> > ServerAdmin me...@oz...
> > DocumentRoot /www/websites/bookmen
> > ServerName 192.168.10.13
> > ScriptAlias   /cgi-bin/    
> /www/websites/bookmen/cgi-bin/
> >     <Directory /www/websites/bookmen>
> >         Options FollowSymLinks Includes Multiviews
> >         Order allow,deny
> >         Allow from all
> >     </Directory>
> > Alias    /sqll/    /www/websites/bookmen/sqll/
> >     <Directory /www/websites/bookmen/sqll>
> >         Options FollowSymLinks ExecCGI Includes
> Multiviews
> >     </Directory>
> > ErrorLog /www/websites/bookmen/logs/error_log
> > TransferLog /www/websites/bookmen/logs/access_log
> > </VirtualHost>
> > ----------------------------------------
> >
> > /www/websites/bookmen/sqll is the path to
> SQL-Ledger tree hierarchy.
> >
> > Can anyone see a problem why I would get :
> > -----------------
> > Error!
> > Permission denied: users/members
> > -----------------
> >
> > Regards Jess
> >
> >
> >
> >
> >
> 
> 


__________________________________________________
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/

Re: Apache denied access problem.

[Jess <je...@oz...>]

Hi German,
The access log file for this website is here:
192.168.1.3 - - [15/Jun/2001:01:16:57 +1000] "GET /sqll/login.pl HTTP/1.1"
200 1090
192.168.1.3 - - [15/Jun/2001:01:16:58 +1000] "GET /sqll/sql-ledger.gif
HTTP/1.1" 304 -
192.168.1.3 - - [15/Jun/2001:01:17:14 +1000] "GET /sqll/admin.pl HTTP/1.1"
200 713
192.168.1.3 - - [15/Jun/2001:01:17:14 +1000] "GET /sqll/sql-ledger.gif
HTTP/1.1" 304 -
192.168.1.3 - - [15/Jun/2001:01:17:21 +1000] "POST /sqll/admin.pl HTTP/1.1"
200 119
192.168.1.3 - - [15/Jun/2001:12:46:12 +1000] "GET /sqll/login.pl HTTP/1.1"
200 1090
192.168.1.3 - - [15/Jun/2001:12:46:13 +1000] "GET /sqll/sql-ledger.gif
HTTP/1.1" 304 -
192.168.1.3 - - [15/Jun/2001:12:46:21 +1000] "GET /sqll/admin.pl HTTP/1.1"
200 713
192.168.1.3 - - [15/Jun/2001:12:46:21 +1000] "GET /sqll/sql-ledger.gif
HTTP/1.1" 304 -
192.168.1.3 - - [15/Jun/2001:12:46:24 +1000] "POST /sqll/admin.pl HTTP/1.1"
200 119
There was no entry in the error log file at all.
What does the codes 200 119 & 200 713 mean?

I am not sure what is happening.  What was the change between 1.2.10  and
1.4.* in its security coding.  I remember Dieter saying something about not
needing to use cookies in 1.4.*.

Regards Jess




----- Original Message -----
From: "German Duenas" <g_d...@ya...>
To: <sql...@li...>
Sent: Friday, 15 June, 2001 4:01 PM
Subject: Re: Apache denied access problem.


> FAT32 and NTFS have different restrictions as you have
> mentioned. I encountered the same problem with apache
> and yes you have to have full access to the directory
> otherwise it will give you error 403. If you go into
> the directory where apache keeps its logs files and
> check file error.log or error1.log you can see the
> actual problem why the file is being locked and
> preventing you access. Jerry
> --- Jess <je...@oz...> wrote:
> > Thanks for the reply Alexander.
> >
> > But as I mentioned below this is on a Windoze 2000
> > Pro on a FAT32 partition
> > that does not support file system level permissions,
> > so as far as W2K pro is
> > concerned all files on a FAT32 are available to
> > anyone who has user access
> > to that computer.  So in this situation I don't
> > believe W2K is restricting
> > access to the users/members.
> >
> > Any other ideas I could persue.
> >
> > Regards Jess
> >
> >
> > ----- Original Message -----
> > From: "Alexander Orozco" <ao...@pr...>
> > To: <sql...@li...>
> > Sent: Thursday, 14 June, 2001 8:51 PM
> > Subject: RE: Apache denied access problem.
> >
> >
> > > that means that directory is not accessible
> > through apache
> > > you might have to change permissions
> > > start with:
> > > chmod 0777 users/members
> > > chmod 0777 users/members/*
> > >
> > > change to 0777 just to make sure that was the
> > problem,
> > > then tweak the permissions to your desired
> > security level
> > >
> > > -----Original Message-----
> > > From: sql...@li...
> > >
> >
> [mailto:sql...@li...]On
> > Behalf Of Jess
> > > Sent: Thursday, June 14, 2001 3:52 AM
> > > To: sql...@li...
> > > Subject: Apache denied access problem.
> > >
> > >
> > > On version 1.4.5 of SQL-Ledger.
> > >
> > > When I run the admin.pl script I get this error
> > after I press submit with
> > or
> > > without a password.
> > > -----------------
> > > Error!
> > > Permission denied: users/members
> > > -----------------
> > > The file in users/members/ is the default
> > "members" that comes with
> > > SQL-Ledger.
> > >
> > > Now this is running under Windoze 2000 Pro but on
> > a FAT32 partition so
> > there
> > > is no direct support for file permissions where
> > the files are.  (This is
> > > just a development system, so I can understand how
> > the security system in
> > > Apache works which is currently eluding me.).
> > > So I believe it is Apache restricting access to
> > this area.  The virtual
> > host
> > > section is set as:
> > > -----------------------------------------
> > > <VirtualHost 192.168.10.13>
> > > ServerAdmin me...@oz...
> > > DocumentRoot /www/websites/bookmen
> > > ServerName 192.168.10.13
> > > ScriptAlias   /cgi-bin/
> > /www/websites/bookmen/cgi-bin/
> > >     <Directory /www/websites/bookmen>
> > >         Options FollowSymLinks Includes Multiviews
> > >         Order allow,deny
> > >         Allow from all
> > >     </Directory>
> > > Alias    /sqll/    /www/websites/bookmen/sqll/
> > >     <Directory /www/websites/bookmen/sqll>
> > >         Options FollowSymLinks ExecCGI Includes
> > Multiviews
> > >     </Directory>
> > > ErrorLog /www/websites/bookmen/logs/error_log
> > > TransferLog /www/websites/bookmen/logs/access_log
> > > </VirtualHost>
> > > ----------------------------------------
> > >
> > > /www/websites/bookmen/sqll is the path to
> > SQL-Ledger tree hierarchy.
> > >
> > > Can anyone see a problem why I would get :
> > > -----------------
> > > Error!
> > > Permission denied: users/members
> > > -----------------
> > >
> > > Regards Jess
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Spot the hottest trends in music, movies, and more.
> http://buzz.yahoo.com/
>
>

Re: Apache denied access problem.

[Jess <je...@oz...>]

Hi People,
I am trying to determine why Apache is giving an ERROR! Permission Denied
message when there is no access restriction in the file system which a
standard WIN98 FAT32 Partitioned drive running Windoze 2000 Pro.  As far as
I can tell there is no restriction in Apache httpd.conf file that would
disallow access to the users/members directory or file.

So can Dieter or someone who is more intimate with the Perl Code of
SQL-Ledger tell me where in the code exactly does the admin.pl attempt to
open the "members" file so I can check to see if the is something in the way
the file is called or even using a linux based command that may not exist in
Windoze 2000 pro.

Anyone happy to assist would be welcome.

Regards Jess.


----- Original Message -----
From: "Jess" <je...@oz...>
To: <sql...@li...>
Sent: Friday, 15 June, 2001 5:09 PM
Subject: Re: Apache denied access problem.


> Hi German,
> The access log file for this website is here:
> 192.168.1.3 - - [15/Jun/2001:01:16:57 +1000] "GET /sqll/login.pl HTTP/1.1"
> 200 1090
> 192.168.1.3 - - [15/Jun/2001:01:16:58 +1000] "GET /sqll/sql-ledger.gif
> HTTP/1.1" 304 -
> 192.168.1.3 - - [15/Jun/2001:01:17:14 +1000] "GET /sqll/admin.pl HTTP/1.1"
> 200 713
> 192.168.1.3 - - [15/Jun/2001:01:17:14 +1000] "GET /sqll/sql-ledger.gif
> HTTP/1.1" 304 -
> 192.168.1.3 - - [15/Jun/2001:01:17:21 +1000] "POST /sqll/admin.pl
HTTP/1.1"
> 200 119
> 192.168.1.3 - - [15/Jun/2001:12:46:12 +1000] "GET /sqll/login.pl HTTP/1.1"
> 200 1090
> 192.168.1.3 - - [15/Jun/2001:12:46:13 +1000] "GET /sqll/sql-ledger.gif
> HTTP/1.1" 304 -
> 192.168.1.3 - - [15/Jun/2001:12:46:21 +1000] "GET /sqll/admin.pl HTTP/1.1"
> 200 713
> 192.168.1.3 - - [15/Jun/2001:12:46:21 +1000] "GET /sqll/sql-ledger.gif
> HTTP/1.1" 304 -
> 192.168.1.3 - - [15/Jun/2001:12:46:24 +1000] "POST /sqll/admin.pl
HTTP/1.1"
> 200 119
> There was no entry in the error log file at all.
> What does the codes 200 119 & 200 713 mean?
>
> I am not sure what is happening.  What was the change between 1.2.10  and
> 1.4.* in its security coding.  I remember Dieter saying something about
not
> needing to use cookies in 1.4.*.
>
> Regards Jess
>
>
>
>
> ----- Original Message -----
> From: "German Duenas" <g_d...@ya...>
> To: <sql...@li...>
> Sent: Friday, 15 June, 2001 4:01 PM
> Subject: Re: Apache denied access problem.
>
>
> > FAT32 and NTFS have different restrictions as you have
> > mentioned. I encountered the same problem with apache
> > and yes you have to have full access to the directory
> > otherwise it will give you error 403. If you go into
> > the directory where apache keeps its logs files and
> > check file error.log or error1.log you can see the
> > actual problem why the file is being locked and
> > preventing you access. Jerry
> > --- Jess <je...@oz...> wrote:
> > > Thanks for the reply Alexander.
> > >
> > > But as I mentioned below this is on a Windoze 2000
> > > Pro on a FAT32 partition
> > > that does not support file system level permissions,
> > > so as far as W2K pro is
> > > concerned all files on a FAT32 are available to
> > > anyone who has user access
> > > to that computer.  So in this situation I don't
> > > believe W2K is restricting
> > > access to the users/members.
> > >
> > > Any other ideas I could persue.
> > >
> > > Regards Jess
> > >
> > >
> > > ----- Original Message -----
> > > From: "Alexander Orozco" <ao...@pr...>
> > > To: <sql...@li...>
> > > Sent: Thursday, 14 June, 2001 8:51 PM
> > > Subject: RE: Apache denied access problem.
> > >
> > >
> > > > that means that directory is not accessible
> > > through apache
> > > > you might have to change permissions
> > > > start with:
> > > > chmod 0777 users/members
> > > > chmod 0777 users/members/*
> > > >
> > > > change to 0777 just to make sure that was the
> > > problem,
> > > > then tweak the permissions to your desired
> > > security level
> > > >
> > > > -----Original Message-----
> > > > From: sql...@li...
> > > >
> > >
> > [mailto:sql...@li...]On
> > > Behalf Of Jess
> > > > Sent: Thursday, June 14, 2001 3:52 AM
> > > > To: sql...@li...
> > > > Subject: Apache denied access problem.
> > > >
> > > >
> > > > On version 1.4.5 of SQL-Ledger.
> > > >
> > > > When I run the admin.pl script I get this error
> > > after I press submit with
> > > or
> > > > without a password.
> > > > -----------------
> > > > Error!
> > > > Permission denied: users/members
> > > > -----------------
> > > > The file in users/members/ is the default
> > > "members" that comes with
> > > > SQL-Ledger.
> > > >
> > > > Now this is running under Windoze 2000 Pro but on
> > > a FAT32 partition so
> > > there
> > > > is no direct support for file permissions where
> > > the files are.  (This is
> > > > just a development system, so I can understand how
> > > the security system in
> > > > Apache works which is currently eluding me.).
> > > > So I believe it is Apache restricting access to
> > > this area.  The virtual
> > > host
> > > > section is set as:
> > > > -----------------------------------------
> > > > <VirtualHost 192.168.10.13>
> > > > ServerAdmin me...@oz...
> > > > DocumentRoot /www/websites/bookmen
> > > > ServerName 192.168.10.13
> > > > ScriptAlias   /cgi-bin/
> > > /www/websites/bookmen/cgi-bin/
> > > >     <Directory /www/websites/bookmen>
> > > >         Options FollowSymLinks Includes Multiviews
> > > >         Order allow,deny
> > > >         Allow from all
> > > >     </Directory>
> > > > Alias    /sqll/    /www/websites/bookmen/sqll/
> > > >     <Directory /www/websites/bookmen/sqll>
> > > >         Options FollowSymLinks ExecCGI Includes
> > > Multiviews
> > > >     </Directory>
> > > > ErrorLog /www/websites/bookmen/logs/error_log
> > > > TransferLog /www/websites/bookmen/logs/access_log
> > > > </VirtualHost>
> > > > ----------------------------------------
> > > >
> > > > /www/websites/bookmen/sqll is the path to
> > > SQL-Ledger tree hierarchy.
> > > >
> > > > Can anyone see a problem why I would get :
> > > > -----------------
> > > > Error!
> > > > Permission denied: users/members
> > > > -----------------
> > > >
> > > > Regards Jess
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Spot the hottest trends in music, movies, and more.
> > http://buzz.yahoo.com/
> >
> >
>
>
>

Re: Apache denied access problem.

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

Do you have a members file, if so, where is it?

sql-ledger.conf has a variable

$memberfile = "path/filename";

to specify the location and name for the file.


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, 16 Jun 2001, Jess wrote:

> Hi People,
> I am trying to determine why Apache is giving an ERROR! Permission Denied
> message when there is no access restriction in the file system which a
> standard WIN98 FAT32 Partitioned drive running Windoze 2000 Pro.  As far as
> I can tell there is no restriction in Apache httpd.conf file that would
> disallow access to the users/members directory or file.
> 
> So can Dieter or someone who is more intimate with the Perl Code of
> SQL-Ledger tell me where in the code exactly does the admin.pl attempt to
> open the "members" file so I can check to see if the is something in the way
> the file is called or even using a linux based command that may not exist in
> Windoze 2000 pro.
> 
> Anyone happy to assist would be welcome.
> 
> Regards Jess.
> 
> 

Re: Apache denied access problem.

[Jess <je...@oz...>]

Yes, the one supplied with 1.4.5 called members.default was renamed to
members, the path is:-

|---------- path----------|---file---|
sql-ledger/users/members/members


sql-ledger.conf variable was modified to:
$memberfile = "users/members";

The members file contains:-
-------------------------------------------------------
# members file format is as follows:
# username enclosed in square brackets
# label= line for setting up hash in signon script
# everything up to eof or next [ is read in
# ignore anything past a hash mark and empty lines

[root login]
password=
------------------------------------------------------
Regards Jess

----- Original Message -----
From: "Dieter Simader" <dsi...@sq...>
To: <sql...@li...>
Sent: Sunday, 17 June, 2001 2:31 AM
Subject: Re: Apache denied access problem.


> Do you have a members file, if so, where is it?
>
> sql-ledger.conf has a variable
>
> $memberfile = "path/filename";
>
> to specify the location and name for the file.
>
>
> 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, 16 Jun 2001, Jess wrote:
>
> > Hi People,
> > I am trying to determine why Apache is giving an ERROR! Permission
Denied
> > message when there is no access restriction in the file system which a
> > standard WIN98 FAT32 Partitioned drive running Windoze 2000 Pro.  As far
as
> > I can tell there is no restriction in Apache httpd.conf file that would
> > disallow access to the users/members directory or file.
> >
> > So can Dieter or someone who is more intimate with the Perl Code of
> > SQL-Ledger tell me where in the code exactly does the admin.pl attempt
to
> > open the "members" file so I can check to see if the is something in the
way
> > the file is called or even using a linux based command that may not
exist in
> > Windoze 2000 pro.
> >
> > Anyone happy to assist would be welcome.
> >
> > Regards Jess.
> >
> >
>
>
>
>

Re: Apache denied access problem.

[German D. <g_d...@ya...>]

Jess:  By looking at your error.log it tells me that
the URL is being rerouted and that the old one is no
longer available. On your apache config you need to
provide the new path or as part of your settings in
windows add sql-ledger/users/members as part of your
path. Good luck  Jerry
--- Jess <je...@oz...> wrote:
> Yes, the one supplied with 1.4.5 called
> members.default was renamed to
> members, the path is:-
> 
> |---------- path----------|---file---|
> sql-ledger/users/members/members
> 
> 
> sql-ledger.conf variable was modified to:
> $memberfile = "users/members";
> 
> The members file contains:-
>
-------------------------------------------------------
> # members file format is as follows:
> # username enclosed in square brackets
> # label= line for setting up hash in signon script
> # everything up to eof or next [ is read in
> # ignore anything past a hash mark and empty lines
> 
> [root login]
> password=
>
------------------------------------------------------
> Regards Jess
> 
> ----- Original Message -----
> From: "Dieter Simader" <dsi...@sq...>
> To: <sql...@li...>
> Sent: Sunday, 17 June, 2001 2:31 AM
> Subject: Re: Apache denied access problem.
> 
> 
> > Do you have a members file, if so, where is it?
> >
> > sql-ledger.conf has a variable
> >
> > $memberfile = "path/filename";
> >
> > to specify the location and name for the file.
> >
> >
> > 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, 16 Jun 2001, Jess wrote:
> >
> > > Hi People,
> > > I am trying to determine why Apache is giving an
> ERROR! Permission
> Denied
> > > message when there is no access restriction in
> the file system which a
> > > standard WIN98 FAT32 Partitioned drive running
> Windoze 2000 Pro.  As far
> as
> > > I can tell there is no restriction in Apache
> httpd.conf file that would
> > > disallow access to the users/members directory
> or file.
> > >
> > > So can Dieter or someone who is more intimate
> with the Perl Code of
> > > SQL-Ledger tell me where in the code exactly
> does the admin.pl attempt
> to
> > > open the "members" file so I can check to see if
> the is something in the
> way
> > > the file is called or even using a linux based
> command that may not
> exist in
> > > Windoze 2000 pro.
> > >
> > > Anyone happy to assist would be welcome.
> > >
> > > Regards Jess.
> > >
> > >
> >
> >
> >
> >
> 
> 


__________________________________________________
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/

Re: Apache denied access problem.

[Jess <je...@oz...>]

German,
I have tried putting an absolute path in the sql-ledger.conf and the
relative path as shown below.  Both do not work.

I don't understand what the sql-ledger path has to do with the windows path
it is not windows having problems access the members file it it is Apache
through the Sql-Ledger perl program.  Can you explain further what it is you
believe I need to do.

Regards Jess

----- Original Message -----
From: "German Duenas" <g_d...@ya...>
To: <sql...@li...>
Sent: Sunday, 17 June, 2001 3:57 PM
Subject: Re: Apache denied access problem.


> Jess:  By looking at your error.log it tells me that
> the URL is being rerouted and that the old one is no
> longer available. On your apache config you need to
> provide the new path or as part of your settings in
> windows add sql-ledger/users/members as part of your
> path. Good luck  Jerry
> --- Jess <je...@oz...> wrote:
> > Yes, the one supplied with 1.4.5 called
> > members.default was renamed to
> > members, the path is:-
> >
> > |---------- path----------|---file---|
> > sql-ledger/users/members/members
> >
> >
> > sql-ledger.conf variable was modified to:
> > $memberfile = "users/members";
> >
> > The members file contains:-
> >
> -------------------------------------------------------
> > # members file format is as follows:
> > # username enclosed in square brackets
> > # label= line for setting up hash in signon script
> > # everything up to eof or next [ is read in
> > # ignore anything past a hash mark and empty lines
> >
> > [root login]
> > password=
> >
> ------------------------------------------------------
> > Regards Jess
> >
> > ----- Original Message -----
> > From: "Dieter Simader" <dsi...@sq...>
> > To: <sql...@li...>
> > Sent: Sunday, 17 June, 2001 2:31 AM
> > Subject: Re: Apache denied access problem.
> >
> >
> > > Do you have a members file, if so, where is it?
> > >
> > > sql-ledger.conf has a variable
> > >
> > > $memberfile = "path/filename";
> > >
> > > to specify the location and name for the file.
> > >
> > >
> > > 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, 16 Jun 2001, Jess wrote:
> > >
> > > > Hi People,
> > > > I am trying to determine why Apache is giving an
> > ERROR! Permission
> > Denied
> > > > message when there is no access restriction in
> > the file system which a
> > > > standard WIN98 FAT32 Partitioned drive running
> > Windoze 2000 Pro.  As far
> > as
> > > > I can tell there is no restriction in Apache
> > httpd.conf file that would
> > > > disallow access to the users/members directory
> > or file.
> > > >
> > > > So can Dieter or someone who is more intimate
> > with the Perl Code of
> > > > SQL-Ledger tell me where in the code exactly
> > does the admin.pl attempt
> > to
> > > > open the "members" file so I can check to see if
> > the is something in the
> > way
> > > > the file is called or even using a linux based
> > command that may not
> > exist in
> > > > Windoze 2000 pro.
> > > >
> > > > Anyone happy to assist would be welcome.
> > > >
> > > > Regards Jess.
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Spot the hottest trends in music, movies, and more.
> http://buzz.yahoo.com/
>
>

Re: Apache denied access problem.

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

You answered your own question.

change memberfile to

$memberfile = "users/members/members";
               ^^^^^^^^^^^^^ ^^^^^^^
                   path      filename


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, 17 Jun 2001, Jess wrote:

> Yes, the one supplied with 1.4.5 called members.default was renamed to
> members, the path is:-
> 
> |---------- path----------|---file---|
> sql-ledger/users/members/members
> 
> 
> sql-ledger.conf variable was modified to:
> $memberfile = "users/members";
> 
> The members file contains:-
> -------------------------------------------------------
> # members file format is as follows:
> # username enclosed in square brackets
> # label= line for setting up hash in signon script
> # everything up to eof or next [ is read in
> # ignore anything past a hash mark and empty lines
> 
> [root login]
> password=
> ------------------------------------------------------
> Regards Jess

Re: Apache denied access problem.

[Jess <je...@oz...>]

Aaaaaaaaaahhhhhhhhhh!

I was under the belief that these were paths to the files and SQL-Ledger was
coded to look for the "members" file.
I knew that it did not seem correct the errors that I was getting.  Because
no access restrictions where set.
That is why I wanted to know where exactly in the Perl code did SQL-Ledger
call the members file, so I could see what exactly it was looking for.

So if the file called "membersship.dat" then the
$membersfile variable would be set like this?

$memberfile = "users/members/membersship.dat";
or
$memberfile = "users/membersship.dat";
Depending where you want to store the file!

Put this in the FAQ and Installation instructions so it is clear that the
file itself has to be included in the path for the $memberfile.

I've tried it so it works Peeeerrrrrfectly.

Thank you everyone.

Jess

----- Original Message -----
From: "Dieter Simader" <dsi...@sq...>
To: <sql...@li...>
Sent: Monday, 18 June, 2001 2:53 AM
Subject: Re: Apache denied access problem.


> You answered your own question.
>
> change memberfile to
>
> $memberfile = "users/members/members";
>                ^^^^^^^^^^^^^ ^^^^^^^
>                    path      filename
>
>
> 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, 17 Jun 2001, Jess wrote:
>
> > Yes, the one supplied with 1.4.5 called members.default was renamed to
> > members, the path is:-
> >
> > |---------- path----------|---file---|
> > sql-ledger/users/members/members
> >
> >
> > sql-ledger.conf variable was modified to:
> > $memberfile = "users/members";
> >
> > The members file contains:-
> > -------------------------------------------------------
> > # members file format is as follows:
> > # username enclosed in square brackets
> > # label= line for setting up hash in signon script
> > # everything up to eof or next [ is read in
> > # ignore anything past a hash mark and empty lines
> >
> > [root login]
> > password=
> > ------------------------------------------------------
> > Regards Jess
>
>
>

Premature end of script headers.

[Jess <je...@oz...>]

Hi People,

I am getting an error after I press "save" when adding a user to SQL-Ledger
via the admin.pl program. The log also says it can't find a perl script waba
waba see below.

Any ideas?

Error Log

[Thu Jun 21 12:39:12 2001] [error] [client 192.168.1.3] Premature end of
script headers: /www/websites/bookmen/sqll/admin.pl
[Thu Jun 21 12:39:12 2001] [error] [client 192.168.1.3] Can't open perl
script "action=list_users&path=bin/mozilla&root=root": No such file or
directory



Regards Jess.

Re: Premature end of script headers.

[Oscar B. <os...@el...>]

See if the file is actually inthe right place and heck your file
permissions=2E

----- Message d'origine -----
De : "Jess" <jess@ozscan=2Enet=2Eau>
=C0 : <sql-ledger-users@lists=2Esourceforge=2Enet>
Envoy=E9 : jeudi 21 juin 2001 05:28
Objet : Premature end of script headers=2E


> Hi People,
>
> I am getting an error after I press "save" when adding a user to
SQL-Ledger
> via the admin=2Epl program=2E The log also says it can't find a perl scrip=
t
waba
> waba see below=2E
>
> Any ideas?
>
> Error Log
>
> [Thu Jun 21 12:39:12 2001] [error] [client 192=2E168=2E1=2E3] Premature en=
d of
> script headers: /www/websites/bookmen/sqll/admin=2Epl
> [Thu Jun 21 12:39:12 2001] [error] [client 192=2E168=2E1=2E3] Can't open p=
erl
> script "action=3Dlist_users&path=3Dbin/mozilla&root=3Droot": No such file =
or
> directory
>
>
>
> Regards Jess=2E
>
>
>

Re: Problems with 1.4.?

[Neil J. <ne...@jo...>]

On June  9, 2001 09:04 am, you wrote:
> Hi Dieter,
>
> Just to make this clear straight of the bat prior to version 1.4 of
> SQL-Ledger I had no problems running SQL-Ledger in the 1.2.* variety.
>
> I clean installed SQL ledger.
>
> Now I cleaned out all the SQL tables and downloaded SQL-Ledger 1.4.4 from
> your Web Site unpacked it and recreated the tables from the acc-PG.sql
> file. I removed any traces of the previous SQL-LEDGER 1.2.* which was
> working. I then move the SQL-Ledger directory with the login.pl and
> sql-ledger.conf file and all subdirectories to the web document root called
> /www/websites/bookmen/sqll  I also created any directories that where
> called in the sql-ledger.conf file so that it could find anything it was
> looking for.
> I read the FAQ and the README and it said to:
>
SNIP

I had the same problems trying to move from 1.2 to a fresh install of 1.4.4. 
Grab the latest version (1.4.5), and try it. I had no problems whatsoever 
with 1.4.5.

Neil