I'm following the instructions from: INSTALL file.
I've loaded English_General.sql accounts


When following section: Generate A Custom Roles SQL Statement File
running:
sed -e 's/<?lsmb dbname ?>/sysconcept_smb/g' 
/usr/local/ledgersmb/sql/modules/Roles.sql >
/usr/local/ledgersmb/sysconcept_smb_roles.sql
completed OK

but
psql -U postgres -d sysconcept_smb -f 
/usr/local/ledgersmb/sysconcept_smb_roles.sql

I got few errors:
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:63: ERROR:  syntax error at 
or near "note_id_seq" at character 23
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:63: LINE 1: GRANT ALL ON 
SEQUENCE note_id_seq TO "lsmb_sysconcept_smb__c...
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:63:

Line 63 is:
GRANT ALL ON SEQUENCE note_id_seq TO "lsmb_sysconcept_smb__create_contact";



The errors below I think have something to do with admin.sql security.sql 
templates.

psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1082: ERROR:  relation 
"chart_id_seq" does not exist

psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1390: ERROR:  function 
admin__add_user_to_role(text, text) does not exist
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1392: ERROR:  function 
admin__remove_user_from_role(text, text) does not exist
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1394: ERROR:  function 
admin__add_function_to_group(text, text) does not exist
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1396: ERROR:  function 
admin__remove_function_from_group(text, text) does not exist
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1398: ERROR:  function 
admin__get_roles_for_user(integer) does not exist
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1400: ERROR:  function 
admin__save_user(integer, integer, text, text) does not exist
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1402: ERROR:  function 
admin__create_group(text) does not exist
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1404: ERROR:  function 
admin__delete_user(text) does not exist
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1406: ERROR:  function 
admin__list_roles(text) does not exist
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1408: ERROR:  function 
admin__delete_group(text) does not exist

How to go about it?
How to proceed with installation? 

-- 
Joseph

------------------------------------------------------------------------------
Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9&#45;12, 2009. Register now&#33;
http://p.sf.net/sfu/devconf
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

Reply via email to