[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Ubuntu server on a home network with Apache; PostgreSQL; LedgerSMB -- newbie Step by Step



Any objection to your notes being placed on the web site?

On 1/5/07, David Methot <..hidden..> wrote:
Ubuntu server on a home network with Apache; PostgreSQL; LedgerSMB -- newbie Step by Step

The objective is to use an old unused computer as the business computer which will hold the accounting database. LedgerSMB along with PostgreSQL will allow more than one user the access to the accounting software from anywhere on the network.

Although computer literate, I don't make a living at it... so by the time I learned anything it's obsolete. Command prompts were something I used a long time ago under MS-DOS. Linux is new to me, so the following steps are what made it work on my system. There may be better and easier ways to achieve the same, so if you can help improve this process, please do so. If someone somewhere can use this to setup their own configuration, then the 5 or 6 days of banging my head against the monitor and the few swear words will have more value.
Good Luck

Farmer Dave, a Linux newbie
:-)

-------------------------------------------------------------------------
Ubuntu Server
-------------------------------------------------------------------------
Download and burn on CD Ubuntu's server edition; in this case version 6.10
Make sure the computer is properly hooked up to the router.
Start your computer and configure your Bios to boot on the CD-ROM
If it will not boot using CD-ROM... use Smart Boot Manager. See https://help.ubuntu.com/community/SmartBootManagerHowto
in my case it would still not boot, so I replaced the CD-ROM with the same one I used to burn the CD.

Ubuntu's menu will appear; Select Install to the hard disk
I get an error " [42949372.960000] ACPI:Unable to locate RSDP " and ignore it.
Since I only have 64MB of memory, the install will enter a low memory mode.
Answer to prompts.

At the 'Partition disks' menu, I choose to erase entire disk
At the 'Ubuntu software selection' I choose DNS server.

If new to Linux, check out "An introduction to the Linux command line" at http://www.tuxfiles.org/linuxhelp/cli.html
To get an idea of what the directories are for, check out "Linux's directory structure" at http://www.tuxfiles.org/linuxhelp/linuxdir.html

-------------------------------------------------------------------------
Apache
-------------------------------------------------------------------------
Install Apache

        $ sudo apt-get update
        $ sudo apt-get install apache2
I get the response " could not determine the server's fully qualified domain name, using 127.0.1.1 for ServerName "

If I enter http://192.168.0.102/ in my favorite browser on any other computer on the network, I will reach the apache2-default directory. Try replacing 102 with 102, 103, 104, etc if no connection is established.

-------------------------------------------------------------------------
Various utilities
-------------------------------------------------------------------------
Install C-compiler and other libraries

        $ apt-get install build-essential
        $ sudo ln -s /usr/bin/gcc-4.1 /bin/gcc
        $ sudo apt-get install libreadline5-dev
        $ sudo apt-get install zlib1g-dev

-------------------------------------------------------------------------
PostgreSQL
-------------------------------------------------------------------------
Install PostgreSQL. Here I'm using version 8.1.5; change accordingly for newer version and/or another mirror.

        $ sudo mkdir /usr/temp
        $ cd /usr/temp
        $ sudo wget ftp://ftp.postgresql.org/pub/source/v8.1.5/postgresql-8.1.5.tar.gz
        $ sudo gunzip postgresql-8.1.5.tar.gz
        $ cd /usr/src
        $ sudo tar xf /usr/temp/postgresql-8.1.5.tar

        $ cd postgresql-8.1.5
        $ sudo ./configure

        $ sudo make
        $ sudo make install-strip
        $ sudo make clean
        $ sudo /sbin/ldconfig /usr/local/pgsql/lib
        $ PATH=/usr/local/pgsql/bin:$PATH
        $ export PATH
        $ MANPATH=/usr/local/pgsql/man:$MANPATH
        $ export MANPATH

create os user & initialize db cluster
        $ adduser postgres
enter a password of your liking << postgrespassword >>

        $ sudo su
        $ mkdir /usr/local/pgsql/data
        $ chown postgres /usr/local/pgsql/data
        $ su postgres
        $ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
        $ exit
        $ exit

set-up an auto-start at login script
        $ sudo cp /usr/src/postgresql-8.1.5/contrib/start-scripts/linux /etc/init.d/postgresql.sh
        $ sudo chmod 755 postresql.sh
        $ sudo update-rc.d postgresql.sh defaults
        $ exit

reboot computer

        $ sudo -u postgres /usr/local/pgsql/bin/createdb testdb

if postgresql install was succesful, you should have a response "CREATE DATABASE"

        $ sudo -u postgres /usr/local/pgsql/bin/dropdb testdb

to delete the database

-------------------------------------------------------------------------
CPAN
-------------------------------------------------------------------------
Install CPAN

        $ sudo perl -MCPAN -e shell

if it's the first ime CPAN is used, an initial configuration questionnaire is launched. Otherwise enter the following if you wish to redo the questionnaire.

        cpan> o conf init

The default answer is probably appropriate most times.
Since I want to save space, I won't be keeping the source files.
Parameters for the 'make' command? --> "CC=gcc"
Parameters for the 'make install' command? --> "CC=gcc"

type q to exit the shell
when I ran the shell again... sudo perl -MCPAN -e shell  ... I was asked again to do the inititial confiuration again! which I redid.

        cpan> install HTML::LinkExtor
        cpan> q

-------------------------------------------------------------------------
LedgerSMB
-------------------------------------------------------------------------
Install Ledger SMB. Here I'm using version 1.1.1d; change accordingly for newer version and/or another mirror.

        $ cd /usr/temp
        $ sudo wget http://superb-east.dl.sourceforge.net/sourceforge/ledger-smb/ledger-smb-1.1.1d.tar.gz
        $ sudo gunzip ledger-smb-1.1.1d.tar.gz
        $ cd /usr/src
        $ sudo tar xf /usr/temp/ledger-smb-1.1.1d.tar
        $ cd ledger-smb

        $ sudo perl -w setup.pl

it will try to install DBI and DBD::Pg package if not already done

Create a regular Postgres user. Carefull with the case of the parameters when typing the commands... "-d" is not the same as "-D".

        $ sudo -u postgres /usr/local/pgsql/bin/createuser -S -d -R -P ledger-smb

Enter password for new "ledger-smb" role just created:  << PostgresRolePassword >>

Configure Apache to serve LedgerSMB

        $ cd /etc/apache2
        $ sudo cp /usr/src/ledger-smb/ledger-smb-httpd.conf ledger-smb.conf
        $ sudo nano ledger-smb.conf

modify the paths at 3 places...

        Alias /ledger-smb "/usr/src/ledger-smb/"
        <Directory "/usr/src/ledger-smb">
          AllowOveride All
          AddHandler cgi-script .pl
          Options ExecCGI Includes FollowSymLinks
          Order Allow,Deny
          Allow from all
        </Directory>

        <Directory "/usr/src/ledger-smb/users">
          Order Deny,Allow
          Deny from All
        </Directory>

save & exit

        $ sudo nano apache2.conf

add the following lines somewhere in the text...

        # Ledger-SMB
        Include /etc/apache2/ledger-smb.conf

save & exit

reboot computer

        $ cd /usr/src/ledger-smb
        $ sudo chown -hR www-data:www-data users templates css spool

-------------------------------------------------------------------------
 Set-up a database and tables
-------------------------------------------------------------------------
Load your web browser and connect to
http://192.168.0.102/ledger-smb/admin.pl

This is your first time logging into LedgerSMB. Please set your administrative password

 Select the "Database Administration" link,
 enter the user you created in the previous step.

Host
Port
User    ledger-smb
Password    PostgresRolePassword
Connect to
Superuser
Password

Click on create Dataset



Create users and passwords to work in the created dataset.

Connect your web browser to http://192.168.0.102/ledger-smb/login.pl to start the application

if you get "You have chosen to open login.pl.... open with or save to disk" dialog... clear the browser cache




Your system now has user structure that looks like the following.


system        user                                         password
-------     ----------------------    --------------
Linux           root                                         encrypted
Linux           ubuntu *                                 ubuntuPassword *
Linux           postgres *                              postgrespassword *
Postgresql   postgres * (superuser)
Postgresql   ledger-smb *                         PostgresRolePassword *
Ledger  SMB  admin *                                  adminPasword *
LedgerSMB   ledgerUser1 *                        ledgerUser1Password *
LedgerSMB   ledgerUser2 *                        ledgerUser2Password *

* or whatever names you choosed



--
Low Prices, Wide Selection of Gas Masks
Everyday low price guarantee. We offer special police discounts and an extremely wide selection of gas masks, filters and huge selection of preparedness gear.
http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=24e08df2353d2e6cb9bae3a0e3c8c61e


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users