Re: [SL] Need Help w/Debian Install

[John F. <jf...@au...>]

kevin bailey wrote:
> 
> hi there,
> 
> i've successfully installed SL on debian - i think the instructions are
> not quite right so i made some notes - i'm in a rush at the moment but
> i'll attach the notes as they are - if they need correcting then please
> do so and post them up.
> 
> i run woody as far as i remember i used standard packages including
> postgresql.
> 
> the notes are originally from the sql-ledger install instructions - my
> added comments are after the '#' marks
> 
> ----------------------------------8<------------------------------------
> Debian Installation
> unpack sql-ledger into /var/www/sql-ledger
> 
> install postgresql (Dselect)
> 
> install apache
> 
> # this did not seem to be necessary
> install libpg-dev (Dselect)
> 
> # these were the debina packages i installed
> 
> libdib-perl libdbd-pg-perl libpgperl
> 
> modify /etc/postgresql/postmaster.init
> # should be /etc/postgresql/postmaster.conf
> 
> PGALLOWTCPIP=yes
> 
> PGPORT=5432
> # this produced an error when restarting postgres - i left it out cos
> this port seems to be the default anyway.
> 
> 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)
> 
> # section 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
> 
> # and of not required
> bit--------------------------------------------------------------------
> 
> 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 ':' means 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
> 
> 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.
> # i found the file was not created automatically - i 'touched' it and
> then set the ownership to www-data
> 
> # 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
> 
> ----------------------------------8<------------------------------------
Thanks for the info. I figured out my own solution about 10 minutes
after I yelled for help. (just about par,HUH!) I needed to change my
host permissions own all of the allowd network hosts from ident to
passward and/or crypt. This allows all of my staff members to log in
from anywhere. It was a postgres problem, not SL. BTW; this also cleared
up 3 other problems with other software that was not working with
postgres. Thanks for the tips!

-- 
John Foster