Re: Centos 6.5 Install troubles

[Pongrácz István <..hidden..>]

Hi,

Hmm, just shoot in the dark, but is that possible to install postgresql 9.x?

Second idea, open your ledgersmb.conf and check the following sections and adjust the path to your environment:

[environment] 
# If the server can't find applications, append to the path 
PATH: /bin:/usr/bin:/usr/local/bin:/usr/local/pgsql/bin



[database] 
# Sets database connection parameters. Note that default_db can be left blank 
# if you want to force people to enter a company name at login. 
port = 5432 
default_db = 
host = localhost 
db_namespace = public 
#contrib_dir PG_CONTRIB_DIR 
#with postgresql-9.1 this stuff is in /usr/share/postgresql/9.1/extension and is injected in database with create extension pg_trgm,btree_gist... 
contrib_dir = /usr/share/postgresql/9.3/extension 
# sslmode can be requi

 
Bye,
István

----------------eredeti üzenet-----------------
Feladó: "Dave" ..hidden.. 
Címzett: "LedgerSMB Mail List" ..hidden.. 
Dátum: Tue, 28 Jan 2014 12:51:07 -0700
-------------------------------------------------
 
 
> 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/ost
> g.clktrk
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden.. 
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> 



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