Re: Centos 6.5 Install troubles

On Tue, Jan 28, 2014 at 11:51 AM, Dave <..hidden..> 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
..hidden..
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