Install Issues with L-ane Point of Sale
 

Hi,

My name is cody. I am a "semi newbie" to linux and am ready to (Notice Emotican) :banghead:. For a hobby, I Work with Point Of Sale Software. I am trying to setup L-ane Point of sale (www.l-ane.net) to work with my Ubuntu Studio 9.04. I converted my .rpms to .debs using alien. I am really stuck when I get to the Postgres setup and Perl PG. ( this link)

It says to create a database user called register, im not sure how to do that.
Please help,

It would be VERY MUCH appreciated!

Hi and welcome to LQ! :)
Does this help?
http://www.ubuntugeek.com/howto-setu...-pgadmin3.html
cheers,
jdk

Problem with Install
 

When i tried installing postgresql, i got this message

Package postgresql-8.2 is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
E: Package postgresql-8.2 has no installation candidate
cody@djcampbell:~$


now what do i do?

I went to Postgresql.org, downloaded the latest .bin file, i intstalled it. Now how do I add users, create databases, using the pgadmin. L-ane comes with a data set (filename: lane-dataset-2003-10-19.sql.gz) how do i use this?

Below this line is what i am trying to follow (Setup for Lane POS)

---------------------------------------------------------------------------

RegisterCurses-dirtySetup
$Id: registerCurses-dirtySetup,v 1.1 2001/08/27 21:27:35 jason Exp $

L'anePOS v1.0.3 (Early-release: 2001-Q1)
Copyright 2000, 2001 Burrell Business Systems.
Contains portions of L'ane BMS, Copyright 1995-2001 Burrell Business Systems.

This software is distributed under the terms of the GPL. See COPYING.

=========
Overview
=========
This document gives a "quick and dirty" outline to setup a stand-alone
PC as a register in a L'anePOS system.

The following steps are required:
1. Install and configure the hardware and Linux.
2. Install the PostgreSQL server on the database server or "master"
register.
3. Install the required client packages on the registers (at least
PostgreSQL Pg and Curses Perl modules).
4. Create a location for the L'anePOS installation (ie /pos).
5. Un-tar the desired L'anePOS packages
(at least lanepos.tgz, lane-docs.tgz, lane-dataset.sql.gz).
6. As root, run fix.perms from LanePOS/register/.
7. Create a new database in PostgreSQL on the server or master
register (ie createdb lanedemo).
8. Create a user posmgr on each register (registerCurses runs as this
user).
9. Add an entry in PostgreSQL's pg_hba.conf for each terminal. You
will likely need to use "trust" authentication for the terminals.
10. Install the basic dataset, or build your own dataset
(ie zcat lane-dataset.sql.gz | psql lanedemo)
11. Make sure an entry for laneserv exists in DNS (or /etc/hosts w/o DNS)
12. Add the following line to the register's startup scripts (where 5
is the virtual terminal number where the register program will
start):

open -c 5 -s /pos/LanePOS/register/autostart

(If you modify the default database or default server hostname, edit
LanePOS/register/autostart and rerun fix.perms)

That should be most of the required steps in a brief manner. Visit the
web site if you have questions: http://l-ane.sf.net/ .

Instead of talking in bits & pieces, let me "attempt" to explain the question i have. Postgresql can be downloaded in many ways, and it comes in many packages. Theres the base postgresql, postgresql plus, etc. I do not know which one to use. To quote the Initial Software Setup,

Steps

1)Install & Configure postgresql

a. install the client and server packages
b. create a database user register

This program has about 3 different sets of instructions. They all are supposed to do the same thing, get this pain-in-the-freaking-butt up & running.

Please excuse me if I give info in bits in pieces, im kinda new :)