Install success on Ubuntu 6.06.1 Dapper

[Bruce Hohl <..hidden..>]

Thank you Chris and Seneca for your guidance and help
in getting LedgerSMB installed via a deb package on
Ubuntu 6.06.1 Dapper.  In case this is useful to
anyone else here is what I did:

=============================================
Install of Ledger-SMB on Ubuntu Dapper 6.06.1 
=============================================

1- Used Synaptic to install following and
dependencies: 
    Apache2 2.0.55
    PostgreSQL 8.1.4
    postgresql-client 7.5.16.1
    wwwconfig-common 0.0.44
    Perl 5.8.7
    libdbd-pq-perl 1.43
    libdbi-perl 1.50
    libmime-lite-perl 3.01
    libmodule-build-perl 0.26
    libhtml-parser-perl 3.48
    libversion-perl 0.52


2- Download
liblocale-maketext-lexicon-perl_0.62-1_all.deb from:
   
http://packages.ubuntulinux.org/edgy/perl/liblocale-maketext-lexicon-perl

    move to /opt/ledgersmb
    # mkdir /opt/ledger-smb
    # mv
liblocale-maketext-lexicon-perl_0.62-1_all.deb
/opt/ledgersmb


3- Download ledgersmb-1.1.99b3-debs.tar.gz from:
    http://sourceforge.net/project/showfiles.php? \
   
group_id=175965&package_id=208359&release_id=465891

   move to /opt and extract:
    # mv ledgersmb-1.1.99b3-debs.tar.gz /opt
    # tar -zxvf ledgersmb-1.1.99b3-debs.tar.gz
    # mv /opt/ledgersmb-1.1.99b3-debs/* /opt/ledgersmb
    # rmdir /opt/ledgersmb-1.1.99b3-debs

   
4- Install packages with dselect:
    # dselect
    [1] Access
        Mounted File System
        Q1 - none
        Q2 - /opt/ledgersmb
        Q3 - scan
        Answer none to final four questions

    [2] Update

    [3] Select
        Use + to select package(s)

    [4] Install

    [5] Quit

   
5- edit /etc/ledger-smb/ledger-smb.conf
    change made as follows:
    set "latex :"
    set "DBPassword = admin"


6- PostgreSQL setup:
    [1] Set DB access:
        /etc/postgresql/8.1/main/pg_hba.conf
        local   all   all                   trust

    [2] Create ledgersmb user
        # su postgres
        $ createuser -P ledgersmb
        password = admin
        superuser = y
    
    [3] Create PostgrSQL database
        # su postgres
        $ createlang plpgsql template1
        $ createdb -U ledgersmb ledgersmb

    [4] Set up the users tables using provided file:
        $ psql -U ledgersmb ledgersmb
        ledgersmb=# \i
/usr/share/ledgersmb/sql/Pg-central.sql

    [5] Set the admin password:
        $ psql -U ledgersmb ledgersmb
        ledgersmb=# update users_conf set password =
md5('admin');
        

7- Company and User setup:
   Connect to: http://localhost/ledger-smb/admin.pl

    [1] To set up a company:
        Click "Pg Database Administration" link.
        Host = localhost
        Port = 5432
        User = ledgersmb
        Password = admin
        Connect to = template1
        Superuser = ledgersmb
        Password = admin
        Click "Create Dataset"

    [2] Create Dataset = abc_company
        Chart of Accounts = US_Manufacturing
        Click "Continue"
        If successful a success page will appear.
        Click "Continue" to return to admin.pl

    [3] Click "Add User"
        Login = jsmith
        Password = jsmith
        Name = Joe Smith
        Company = ABC Company

        Driver = Pg
        Host = localhost
        Dataset = abc_company
        Port = 5432
        User = ledgersmb
        Password = admin

        Account type = Administrator
        Click "Save"
        
8- Login access: 
    Local:
    http://localhost/ledger-smb/login.pl
    login with user "jsmith" created above

    Local network:
   
http://<IP_or_hostname_where_installed>/ledger-smb/login.pl
    login with user "jsmith" created above


 
____________________________________________________________________________________
Any questions? Get answers on any topic at www.Answers.yahoo.com.  Try it now.