Centos Install Trouble

Message: 5
Date: Tue, 28 Jan 2014 12:51:07 -0700
From: Dave <..hidden..>
Subject: [Ledger-smb-users] Centos 6.5 Install troubles
To: LedgerSMB Mail List <..hidden..>
Message-ID: <..hidden..>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

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

-- 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;
^
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...
^
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

Dear Dave,

I think you have to take a look in your ledgersmb.conf file. At line 100

For Ubuntu I made this instruction:

Configuration Postgresql with LedgerSMB

Open configure file: /usr/local/ledgersmb/ledgersmb.conf by typing:

sudo gedit /usr/local/ledgersmb/ledgersmb.conf

The config file will appear. Change line line 100 “contrib_dir = /usr/share/pgsql/extension into /usr/share/postgresql/9.1/extension

I do not know Centos.

Hope this may help.

Greetings

Frans