Message: 5
Date: Tue, 28 Jan 2014 12:51:07 -0700
From: Dave <ledger...@1001111.com>
Subject: [Ledger-smb-users] Centos 6.5 Install troubles
To: LedgerSMB Mail List <ledger-smb-users@lists.sourceforge.net>
Message-ID: <52e80a2b.7040...@1001111.com>
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
------------------------------------------------------------------------------
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
