On Tue, Jan 28, 2014 at 11:51 AM, Dave <ledger...@1001111.com> wrote:
> Hello All,
> New to the list but I have been running LedgerSMB 1.2 for years.
>
> New Centos 6.5 install. Postgres 8.4, pg-contrib, Apache 2.x, and
> ledgersmb 1.3.36
> all installed via yum.
>
> I can get to the setup.pl screen, connect to the database and create a
> database, however,
> there are lots of errors.
>
> In the following section from dblog_stderr, pg_config says $libdir=
> /usr/lib/pgsql and in that directory
> pg_trgm.so, tsearch2.so and tablefunc.so are all found
>
> I tried hardcoding the directories (/usr/lib/pgsql/pg_trgm.so
> /usr/lib/pgsql/pg_trgm) but still the same error
>
> ####################################################
> psql:/usr/share/pgsql/contrib/pg_trgm.sql:9: ERROR: could not access file
> "$libdir/pg_trgm": No such file or directory
>
> --5 identical lines
>
> psql:/usr/share/pgsql/contrib/pg_trgm.sql:38: ERROR: function
> similarity_op(text, text) does not exist
> psql:/usr/share/pgsql/contrib/pg_trgm.sql:44: NOTICE: type "gtrgm" is not
> yet defined
> DETAIL: Creating a shell type definition.
> psql:/usr/share/pgsql/contrib/pg_trgm.sql:44: ERROR: could not access
> file "$libdir/pg_trgm": No such file or directory
> psql:/usr/share/pgsql/contrib/pg_trgm.sql:49: ERROR: type gtrgm does not
> exist
> psql:/usr/share/pgsql/contrib/pg_trgm.sql:55: ERROR: function
> gtrgm_in(cstring) does not exist
> psql:/usr/share/pgsql/contrib/pg_trgm.sql:61: ERROR: could not access
> file "$libdir/pg_trgm": No such file or directory
>
> --5 identical lines
>
> psql:/usr/share/pgsql/contrib/pg_trgm.sql:91: ERROR: type gtrgm does not
> exist
> psql:/usr/share/pgsql/contrib/pg_trgm.sql:105: ERROR: operator does not
> exist: text % text
> psql:/usr/share/pgsql/contrib/pg_trgm.sql:111: ERROR: could not access
> file "$libdir/pg_trgm": No such file or directory
> psql:/usr/share/pgsql/contrib/pg_trgm.sql:116: ERROR: could not access
> file "$libdir/pg_trgm": No such file or directory
> psql:/usr/share/pgsql/contrib/pg_trgm.sql:121: ERROR: could not access
> file "$libdir/pg_trgm": No such file or directory
> psql:/usr/share/pgsql/contrib/pg_trgm.sql:132: ERROR: operator does not
> exist: text % text
> psql:/usr/share/pgsql/contrib/tsearch2.sql:24: ERROR: could not access
> file "$libdir/tsearch2": No such file or directory
>
> -- ~30 identical lines
> sql:/usr/share/pgsql/contrib/tsearch2.sql:465: ERROR: function
> token_type() does not exist
> LINE 17: token_type() as t
> ^
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
> psql:/usr/share/pgsql/contrib/tsearch2.sql:508: ERROR: could not access
> file "$libdir/tsearch2": No such file or directory
> psql:/usr/share/pgsql/contrib/tsearch2.sql:513: ERROR: could not access
> file "$libdir/tsearch2": No such file or directory
> psql:/usr/share/pgsql/contrib/tsearch2.sql:520: ERROR: function
> rewrite_accum(tsquery, tsquery[]) does not exist
> psql:/usr/share/pgsql/contrib/tablefunc.sql:9: ERROR: could not access
> file "$libdir/tablefunc": No such file or directory
>
> --10 identical lines
>
> psql:/usr/share/pgsql/contrib/tablefunc.sql:88: ERROR: could not access
> file "$libdir/tablefunc": No such file or directory
>
Ok, you need to locate your tablefunc.sql and point to that directory in
your ledgersmb.conf.
>
> -- I believe the following are unimportant since I am on 8.4
>
> psql:sql/Pg-database.sql:2: ERROR: syntax error at or near "EXTENSION"
> LINE 1: CREATE EXTENSION tablefunc;
> ^
> psql:sql/Pg-database.sql:3: ERROR: syntax error at or near "EXTENSION"
> LINE 1: CREATE EXTENSION pg_trgm;
> ^
> psql:sql/Pg-database.sql:4: ERROR: syntax error at or near "EXTENSION"
> LINE 1: CREATE EXTENSION btree_gist;
>
Correct. Those fail on pre-9.1 and that's by design.
> ^
> psql:sql/Pg-database.sql:36: NOTICE: CREATE TABLE will create implicit
> sequence "account_heading_id_seq" for serial column "account_heading.id"
> psql:sql/Pg-database.sql:36: NOTICE: CREATE TABLE / PRIMARY KEY will
> create implicit index "account_heading_pkey" for table "account_heading"
>
> -- Lots of these, until
>
> psql:sql/Pg-database.sql:3276: NOTICE: CREATE TABLE / PRIMARY KEY will
> create implicit index "menu_acl_pkey" for table "menu_acl"
> psql:sql/Pg-database.sql:3532: ERROR: function connectby(text, text,
> text, text, text, integer, text) does not exist
> LINE 5: FROM (connectby('menu_node'::text, 'id'::text, 'parent'::t...
>
Right. This is caused by the tablefunc extension not loading. On 8.4 the
only extension that's really really important (in the sense of breaking db
load) is tablefunc. We are not depending on this in 1.4, but that's still
in beta.
So the first step is to locate tablefunc.sql and try to point the
ledgersmb.conf to it. If that fails, you could load it in template1 and
then create your db and everything would work (but upgrades still might
not, so we'd need to find and fix whatever the problem is).
Best Wishes,
Chris Travers
> ^
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
> psql:sql/Pg-database.sql:3536: ERROR: current transaction is aborted,
> commands ignored until end of transaction block
> psql:sql/Pg-database.sql:3550: ERROR: current transaction is aborted,
> commands ignored until end of transaction block
>
> And many, many of these until
>
> psql:sql/Pg-database.sql:4776: ERROR: current transaction is aborted,
> commands ignored until end of transaction block
>
> #################################################################################
>
> At this point the website displays the choose your country page.
>
> Any ideas will be welcomed.
>
> Dave
>
>
> ------------------------------------------------------------------------------
> WatchGuard Dimension instantly turns raw network data into actionable
> security intelligence. It gives you real-time visual feedback on key
> security issues and trends. Skip the complicated setup - simply import
> a virtual appliance and go from zero to informed in seconds.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
> _______________________________________________
> Ledger-smb-users mailing list
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more.shtml
------------------------------------------------------------------------------
WatchGuard Dimension instantly turns raw network data into actionable
security intelligence. It gives you real-time visual feedback on key
security issues and trends. Skip the complicated setup - simply import
a virtual appliance and go from zero to informed in seconds.
http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
