Re: [SQL-Ledger-users] Installation problems

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

yeap,  AddHandler cgi-script .cgi .pl  was rem-out.... thanks a lot!

----- Original Message ----- 
From: OTR Comm <ot...@wi...>
To: <sql...@li...>
Sent: Thursday, January 04, 2001 2:31 AM
Subject: Re: [SQL-Ledger-users] Installation problems


> > Paul Aviles wrote:
> > 
> > Happy New Year to all!
> > 
> > I have been looking for an application like sql-ledger for months and
> > finally I found it today. After installing DBI, DBD via CPAN and Pg
> > from the RH RPMs I created the database, which I called dbtest. I was
> > also run the sql script with psql < bla, bla with out any issues. I am
> > running the plain Apache that comes with RH so I did not compiled
> > Apache nor Perl. My installation directory is
> > /var/www/html/sql-ledger. I believe the Apache user run the httpd
> > daemon in RH 7.0  All .cgi files are chmod 755 and I modified the
> > httpd.conf file to add:
> > 
> > <directory "/var/www/html/sql-ledger>
> >     Options ExecCGI Includes FollowSymLinks
> > </directory>
> 
> I have my apache config files separated into httpd.conf, access.conf,
> and srm.conf
> 
> I use:
> 
> <Directory /path/to/sql-ledger>
> AllowOverride All
> Options All
> </Directory>
> 
> in my access.conf file.
> 
> In my srm.conf file I have:
> 
> # To use CGI scripts:
> AddHandler cgi-script .cgi .pl
> ...
> # AccessFileName: The name of the file to look for in each directory
> # for access control information.
> 
> AccessFileName .htaccess
> 
> In the .htaccess file, you define where the authentication file is
> (usually a .htpasswd file).
> 
> Here is a .htaccess file that I use in my sql-ledger development area:
> 
> AuthUserFile /path/to/sql-ledger/.htpasswd
> AuthGroupFile /dev/null
> AuthName Services
> AuthType Basic
> require valid-user
> 
> These are very basic options/settings for the .htaccess file.  However,
> they are okay for getting started with sql-ledger.  On my secure servers
> and other areas, I have much more precise options/settings that are
> reflected on my httpd.conf file.
> 
> This .htaccess file lives in the /path/to/sql-ledger directory
> 
> chmod it and .htpasswd to 644
> 
> As you can see, it references a file .htpasswd that lives in the same
> directory.
> 
> When I want to add a user to the .htpasswd file, I cd to
> /path/to/sql-ledger.  Then I just give the following command:
> 
> htpasswd .htpasswd username
> 
> Then you are prompted to enter the password for username.  When you
> enter the password, you are prompted again to enter the password for
> verification.
> 
> Pretty simple!  Do a man htpasswd for more info/options on htpasswd.
> 
> Good Luck,
> Murrah Boswell
> 
> > 
> > This is actually a virtual named server, but I don't think that is an
> > issue since everything else is working OK on the server.
> > 
> > Here is the issue, when I go to
> > www.server.com/sql-ledger/admin/setup.cgi I get the plain text. I know
> > Perl is working fine and if I do a perl -c setup.cgi I get an OK.  I
> > do have some other html perl based applications that run fine and the
> > location of perl is the default /usr/bin/perl. Any ideas?
> > 
> > Also, can someone share some light as to how to protect the
> > directories in Apache using the .htaccess and passwd files? Do I need
> > to make modification to the /etc/httpd/conf/httpd.conf files or just
> > by having the files in the directory it will work?
> > 
> > Thanks a lot.
> > 
> > -pa
> 
> 
>