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
@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 . . .
And with that, it seems I may have littered my path with a few too many errors
to recover from.
I will try again on the other side of some sleep and perhaps my client's
deadlines.
--
Hugh Esco
http://www.CampaignFoundations.com/
if( $insurance->rationing() ) { $people->die(); }
------------------------------------------------------------------------------
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
