[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Centos 6.5 Install troubles



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

------------------------------------------------------------------------------
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