Re: [SL] Need Help w/Debian Install

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

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<------------------------------------

HTH

kev bailey


JC Boursiquot wrote:
> I am still running the version before last for SL on a woody box.  I have
> no problem so far.
> 
> I will attempt to update my system tonight and will email you.  If your
> problem persist, I will try my best to assist you.  Make sure you have the
> correct version of Postgressql installed.
> 
> I beleive the version of Postgressql that you need is not on the package
> list like you said, I downloaded the latest Postgressql source and compile
> a deb file using checkinstall.
> 
> Until later....  have a nice day.
> 
> 
>>Jonas Smedegaard wrote:
>>I am a Debian user and there are as yet no .deb installation files
>>available. I have managed to get SL installed and it seems to run up to
>>the point where I try to create databases or login to the accounting
>>system. I tried SL several versions ago & decided to wait for it to
>>mature. I want to try it now to see if will meet my needs. Is there any
>>body here with experience with Debian that I can correspond with to get
>>SL working? I have it installed on a Woody box that is currently up to
>>date. I also do not normally use postgres but MySQL, which is easier to
>>manage but does not perform transaction accounting. I need to swithc
>>over and currently not sure where the error is. It seems to be that SL
>>will communicate with the postgresql server but is refused admittance
>>to the database that I created using psql command line  instructions. I
>>did create a postrgres user that is also a linux user and I added the
>>www-data user to postgres as well. I did read & follow the Debian
>>installation instructions in the FAQ. The error that I get is below;
>>
>>Error!
>>
>>IDENT authentication failed for user 'fred'
>>--
>>John Foster
>>
> 
> 
> 
> 
> 
> 
> JC Boursiquot, Chief Architect
> TekMD, Incorporated
> Tel.  908-412-8511
> Fax   908-412-8581
> Pager 908-323-1200
> 
> 
> 
> 
> 
>