Re: permission denied users/members

[kevin b. <kev...@bi...>]

kevin bailey wrote:

> thanks for all the help - with a newsgroup like this sql-ledger is going 
> to be huge!!!
> 
> i now have sql-ledger working on my debian woody machine - i will post 
> up some notes during the week.
> 

here are the notes - i have cut and pasted the instructions - and added 
some comments in amongst them,

kev


Debian Installation
unpack into /var/www/sql-ledger
install postgresql (Dselect)

install apache

# this did not seem to be necessary
install libpg-dev (Dselect)


# other packages required

libdib-perl libdbd-pg-perl libpgperl


# should be /etc/postgresql/postmaster.conf
modify /etc/postgresql/postmaster.init

PGALLOWTCPIP=yes

# this produced an error when restarting postgres - i left it out cos 
this port seems to be the default anyway.
PGPORT=5432

create a user for managing SQL-Ledger databases
from root
su postgres
$ createuser
name of user- (create a postgres user who is also a Linux user
this user will be an account manager. Enable this user to create db and 
users)

# not required cos of the packages installed earlier. 
---------------------------------------
install DBI

perl Makefile.PL

make

make test

login as root

make install

$ export POSTGRES_INCLUDE=/usr/include/postgresql
$ export POSTGRES_LIB=/var/lib/postgres
install DBD-Pg

login as account manager (above)

perl Makefile.PL

make

make test

login as root

make install

#--------------------------------------------------------------------------------------

change /etc/apache/httpd.conf and add
AddHandler cgi-script .pl
ScriptAlias /sql-ledger/ /var/www/sql-ledger/
<Directory /var/www/sql-ledger>
   Options ExecCGI Includes FollowSymlinks
</Directory> restart apache


# the apahce server on woody runs under the user www-data - so use
chown www-data: users templates users/members

the ':' menas that the default group for www-data is set.


Make sure the web server has write permission to write to the following

users/
templates/
users/members

# chown nobody:nogroup users templates users/members



# i found the file was not created automatically - i 'touched' it and 
then set the ownership to www-data
users/members might not exist. Not to worry, the file will be created
when you use admin.pl for the first time.
Of course, the permission has to be set correctly for the users directory.


# finally the settings in pg_hba.conf were too restrictive and i set 
them to
host         all         127.0.0.1     255.0.0.0           trust

obviously this should be tighter but it was late at the time!!!


 From browser enter http://my_domain/sql-ledger/admin.pl
Login as the postgres user (account manager) you have created (above)
Create a DB
Create users

then enter http://my_domain/sql-ledger/login.pl
Login as one of the users you have just created