Re: [SQL-Ledger-users] Installation problems

[OTR C. <ot...@wi...>]

> 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