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

Installing LSMB 1.3: initiate.pl Failed!

Subject: Installing LSMB 1.3: initiate.pl Failed!
From: Iserv-appbox <..hidden..>
Date: Mon, 22 Feb 2010 20:26:07 +0100

Hi,

I'm trying to install LSMB 1.3 beta3 on Debian Lenny (in a vserver environment).
LSMB and postgresql-server are on different vservers.

Step: "Automated PostgreSQL Database Setup" Failed!

In the end I did manage to let it do something, but it is unclear
what exactly was done and which next steps are needed.

Here is what I did:

The initiate.pl failed because:
    - 1. There was no ledgersmb.conf
    - 2. initiate.pl insisted to connect to the local PostgreSQL socket.
    - 3. The database to connect to didn't exist.
    - 4. postgresql-contrib missing

1. ledgersmb.conf
=================
This was easily solved by copying the ledgersmb.conf.default to
ledgersmb.conf and adapting it to your needs.
This step is missing in the INSTALL doc however!

2. initiate.pl insisted to connect to the local PostgreSQL socket.
==================================================================
It seems that initiate.pl ignores the "host" variable in ledgersmb.conf:

[database]
host = pgsql1.tux4u.lan

Initiate.pm bailed out at line 104:
my $dbconnect = "dbi:Pg:user=$username password=$password";

Since there was no "host" parameter I modified this to:
my $dbhost = "pgsql1.tux4u.lan";
my $dbconnect = "dbi:Pg:user=$username password=$password host=$dbhost";

This quick and dirty bypass worked!
However:
- What is the proper solution?
- Is a separate PostgreSQL server no longer supported in LSMB 1.3?


3. The database to connect to didn't exist
==========================================
initiate.pl complained there was no database "lsmb13".
True!
I was not instructed by the INSTALL doc to create this!
Why should I create database before running initiate.pl?
I could connect to template1 eventually.


4. postgresql-contrib missing
=============================
After creation of database "lsmb13" initiate.pl showed up a nice form.
What the administrator was supposed to do was a bit misty however.
Is this form the replacement for "createdb ledgersmb, Pg-central.sql" in LSMB 1.2?

What is the meaning of the tick-boxes "Charts Account" and "Gifi Account"?

I left the "Path of Contrib Files" blank, because I had no idea. Wrong!

It turned out that contrib was discussed in the next section of the INSTALL doc.
It's not stated in the INSTALL doc, but you have to install Debian Package
"postgresql-contrib".
I installed postgresql-contrib on the postgresql-server, but that didn't work
(as expected) because the sql-files are needed by initiate.pl at the LSMB server.

Package "postgresql-contrib" depends on the server package "postgresql-8.3" however.
Since that was not what I wanted, I simply copied over the contrib sql-files
from the postgresql-server to lsmb-server. If just the sql-files are needed,
that must do the job, right?


What happened?
==============
So in the end initiate.pl was put to work, but the outcome is confusing.
An sql protocol appeared on the screen followed by silence. (attached)
No confirmation message, no success greeting, just silence.
So, what happened? Did initiate.pl succeed, or crashed it halfway?

I looked in the created "ledgersmb" database.
A "role_view" was made. No more to see.
Is this OK?

ledgersmb=> \d
            List of relations
   Schema |   Name    | Type |  Owner
--------+-----------+------+---------
   public | role_view | view | dbadmin
(1 row)

ledgersmb=> \?
ledgersmb=> \d role_view
                 View "public.role_view"
      Column     |           Type           | Modifiers
---------------+--------------------------+-----------
   roleid        | oid                      |
   member        | oid                      |
   grantor       | oid                      |
   admin_option  | boolean                  |
   rolname       | name                     |
   rolsuper      | boolean                  |
   rolinherit    | boolean                  |
   rolcreaterole | boolean                  |
   rolcreatedb   | boolean                  |
   rolcatupdate  | boolean                  |
   rolcanlogin   | boolean                  |
   rolconnlimit  | integer                  |
   rolpassword   | text                     |
   rolvaliduntil | timestamp with time zone |
   rolconfig     | text[]                   |
View definition:
   SELECT m.roleid, m.member, m.grantor, m.admin_option, a.rolname, a.rolsuper, a.rolinherit,
a.rolcreaterole, a.rolcreatedb, a.rolcatupdate, a.rolcanlogin, a.rolconnlimit, a.rolpassword,
a.rolvaliduntil, a.rolconfig
     FROM pg_auth_members m
     JOIN pg_authid a ON m.roleid = a.oid;


What next?
==========
- The next steps in the INSTALL doc instruct to install some contrib sql-files in template1.
   Is this still needed, or is this replaced by initiate.pl?

- Do I have to create a company database and load a template COA, or is there a gui?

I'm a bit stuck how to proceed from here on...

Marjan Waldorp,
tux4u.nl

SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE OPERATOR
CREATE FUNCTION
CREATE FUNCTION
CREATE TYPE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE OPERATOR CLASS
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE OPERATOR CLASS
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE TYPE
CREATE TYPE
CREATE TYPE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
SET
CREATE DOMAIN
CREATE DOMAIN
CREATE DOMAIN
CREATE DOMAIN
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE TYPE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE TYPE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE OPERATOR CLASS
CREATE TYPE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE TYPE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE AGGREGATE
CREATE FUNCTION
CREATE FUNCTION
CREATE OPERATOR CLASS
CREATE OPERATOR CLASS
CREATE OPERATOR CLASS
CREATE OPERATOR CLASS
BEGIN
CREATE SEQUENCE
CREATE FUNCTION
CREATE AGGREGATE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE VIEW
CREATE TABLE
CREATE TABLE
COMMENT
CREATE INDEX
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
CREATE TABLE
CREATE TABLE
COMMENT
COMMENT
CREATE INDEX
CREATE TABLE
COMMENT
COMMENT
ALTER TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
 setval 
--------
      7
(1 row)

CREATE TABLE
COMMENT
CREATE TABLE
COMMENT
CREATE TABLE
CREATE TABLE
CREATE TABLE
COMMENT
ROLLBACK
CREATE TYPE
CREATE TYPE
CREATE TYPE
CREATE TYPE
CREATE TYPE
CREATE TYPE
COMMENT
CREATE TYPE
CREATE TYPE
CREATE TYPE
CREATE TYPE
CREATE TYPE
CREATE TYPE
CREATE TYPE
CREATE TYPE
CREATE TYPE
CREATE TYPE
CREATE TYPE
DROP VIEW
CREATE TYPE
CREATE TYPE
CREATE TYPE
CREATE TYPE
CREATE VIEW
CREATE TYPE
CREATE TYPE
CREATE TYPE
BEGIN
ROLLBACK
BEGIN
ROLLBACK
BEGIN
ROLLBACK
BEGIN
ROLLBACK

Follow-Ups:
- Re: Installing LSMB 1.3: initiate.pl Failed!
  - From: WK

Prev by Date: Re: booking taxes when invoice is paid
Next by Date: Re: Installing LSMB 1.3: Spreadsheet::ParseExcel Failed!
Previous by thread: LedgerSMB 1.2.20 release 1 available for download
Next by thread: Re: Installing LSMB 1.3: initiate.pl Failed!
Index(es):
- Date
- Thread