LedgerSMB for Debian
--------------------

LedgerSMB can be accessed at http://127.0.0.1/ledgersmb, although initial
set up is required.

To prepare LedgerSMB for use:

  1) As the postgres user, create a database user for LedgerSMB authentication

	$ createuser --no-superuser --createdb --no-createrole \
		-U postgres --pwprompt --encrypted ledgersmb

  Here it will prompt twice for the ledgersmb postgres user 
  password, remember what you enter here for step 5.

  2) Create postgres database for ledgersmb

	$ createdb -U ledgersmb -O ledgersmb -E UNICODE ledgersmb
        $ createlang plpgsql -U postgres ledgersmb

  3) Add databases for all datasets which you want to have available

  For instance, we want a dataset for each of examplecom, exampleorg and 
  examplenet, so...

 	$ createdb -T ledgersmb examplecom
 	$ createdb -T ledgersmb exampleorg
 	$ createdb -T ledgersmb examplenet

  4) Populate the user database and set an admin password (this admin password
  will be used to log into the administrative interface).

  	$ psql -U ledgersmb -d ledgersmb -f \
		/usr/share/ledgersmb/sql/Pg-central.sql 
	$ psql -U ledgersmb -d ledgersmb

        ledgersmb=> UPDATE users_conf SET password = md5('admin-password') \
		WHERE id = 1;

  5) Edit /etc/ledgersmb/ledgersmb.conf

  Scroll down to the very bottom and check your database settings, they 
  will need to be changed.  Insert the ledgersmb postgres user password 
  you used in step 1.

  6) Edit /etc/postgresql/8.x/main/pg_hba.conf so that ledgersmb user may
  connect. Depending on your security infrastructure you can use the METHOD
  md5 or trust.

  Reload postgres so your changes take effect.

  7) Configure apache2

   Check /etc/ledgersmb/ledgersmb-httpd.conf and see if it is what you want 
   - it will usually be fine just the way it is.

   The default configuration will make this accessible to everyone who can 
   get to your ip address on port 80.  If you want to lock it down to 
   localhost, do so now in the forementioned configuration file!

   	$ cd /etc/apache2/conf.d/
	$ ln -s ../../ledgersmb/ledgersmb-httpd.conf

  8) Reload apache2

	$ /etc/init.d/apache2 reload

At this point you can connect to http://127.0.0.1/ledgersmb/admin.pl and login
with the password set in step 4.

If upgrading from LedgerSMB < 1.2.0-rc5, you need to edit 
/etc/ledgersmb/ledgersmb.conf to adjust your configuration to match the new
options and renaming.

If upgrading from LedgerSMB < 1.2.0-beta1 or from SQL-Ledger, read UPGRADE. The
config format, locale names, database schema, and per-user configuration 
locations have been sufficiently changed with 1.2.0-beta1 so as to require
special attention in upgrading.

 -- Elizabeth Krumbach <lyz@princessleia.com>  Tue, 6 Jan 2009 05:38:48 -0500