On Mon, Dec 14, 2009 at 11:14 PM, Hugh Esco
<[email protected]>wrote:
> Did not reach the finish line.
> I'm wondering if I need pg 8.3, instead of 8.1.
>
> -- Hugh
>
> first glitch in install so far: perl Makefile.PL gets me: Can't locate
> inc/Module/Install.pm in @INC
>
Added to INSTALL doc.
>
> @INC includes .
>
> but $LSMB_INSTALL_DIR includes no inc/
>
> well I found this:
> /usr/local/share/perl/5.8.8/inc/Module/Install.pm,
> however perl -v says v5.10.0 and no similiar animal exists.
>
> that's a funny name for a module, but
> cpan[2]> install inc::Module::Install
> did the trick.
>
> unimpeded progress until this one blew up in my face:
>
> $ psql -U postgres -d ymd_lsmb_13 -f
> /usr/local/ledgersmb13/sql/coa/us/chart/General.sql
> BEGIN
> psql:/usr/local/ledgersmb13/sql/coa/us/chart/General.sql:5: ERROR:
> function account_heading_save("unknown", "unknown", "unknown", "unknown")
> does not exist
> HINT: No function matches the given name and argument types. You may need
> to add explicit type casts.
>
> So I skipped for the moment loading the CoA.
>
> Then I see the following errors when invoking this:
>
> $ psql -U postgres -d ymd_lsmb_13 -f ymd_lsmb_13_roles.sql
>
> psql:ymd_lsmb_13_roles.sql:31: ERROR: function eca__list_notes(integer)
> does not exist
> INSERT 0 1
>
> <snip>
>
> GRANT
> psql:ymd_lsmb_13_roles.sql:63: ERROR: syntax error at or near
> "note_id_seq" at character 23
> psql:ymd_lsmb_13_roles.sql:63: LINE 1: GRANT ALL ON SEQUENCE note_id_seq TO
> "lsmb_ymd_lsmb_13__cont...
> psql:ymd_lsmb_13_roles.sql:63: ^
> GRANT
>
> <snip>
>
> CREATE ROLE
> psql:ymd_lsmb_13_roles.sql:1397: ERROR: function
> admin__add_user_to_role(text, text) does not exist
> psql:ymd_lsmb_13_roles.sql:1399: ERROR: function
> admin__remove_user_from_role(text, text) does not exist
> psql:ymd_lsmb_13_roles.sql:1401: ERROR: function
> admin__add_function_to_group(text, text) does not exist
> psql:ymd_lsmb_13_roles.sql:1403: ERROR: function
> admin__remove_function_from_group(text, text) does not exist
> psql:ymd_lsmb_13_roles.sql:1405: ERROR: function
> admin__get_roles_for_user(integer) does not exist
> psql:ymd_lsmb_13_roles.sql:1407: ERROR: function admin__save_user(integer,
> integer, text, text) does not exist
> psql:ymd_lsmb_13_roles.sql:1409: ERROR: function admin__create_group(text)
> does not exist
> psql:ymd_lsmb_13_roles.sql:1411: ERROR: function admin__delete_user(text)
> does not exist
> psql:ymd_lsmb_13_roles.sql:1413: ERROR: function admin__list_roles(text)
> does not exist
> psql:ymd_lsmb_13_roles.sql:1415: ERROR: function admin__delete_group(text)
> does not exist
> GRANT
>
> <snip>
>
> GRANT
> psql:ymd_lsmb_13_roles.sql:1425: ERROR: relation "user_listable" does not
> exist
> GRANT
>
> <snip>
>
> GRANT
> psql:ymd_lsmb_13_roles.sql:1449: ERROR: function user__get_all_users()
> does not exist
> CREATE ROLE
> GRANT
> CREATE ROLE
> psql:ymd_lsmb_13_roles.sql:1464: ERROR: function voucher__delete(integer)
> does not exist
> psql:ymd_lsmb_13_roles.sql:1467: ERROR: function batch_delete(integer)
> does not exist
>
> Next obstacle makes me wonder if I should have upgraded to pg 8.3:
>
> psql -U postgres -d ymd_lsmb_13 -t -c "INSERT INTO entity (name,
> entity_class, created) VALUES ('lsmb', 3, NOW()) RETURNING name,
> entity_class, created;"
> ERROR: syntax error at or near "RETURNING" at character 76
> LINE 1: ... entity_class, created) VALUES ('lsmb', 3, NOW()) RETURNING ...
> ^
> Trying it this way:
>
> psql -U postgres -d ymd_lsmb_13 -t -c "INSERT INTO entity (name,
> entity_class, created) VALUES ('lsmb', 3, NOW());"
> ERROR: null value in column "control_code" violates not-null constraint
>
> gives me another error . . .
>
Hmm. Looks like the use of initiate.pl was not documented in the INSTALL
file.
The easiest way to set this up is using Sadash's contributed interface for
database setup. Direct your browser to
http://[lsmb-url-dir]/initiate.pland enter your database superuser
credentials. Then initialize a database
on that screen. That works pretty well, actually.
Best Wishes,
Chris Travers
------------------------------------------------------------------------------
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
