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" ledger...@1001111.com
Címzett: "LedgerSMB Mail List" ledger-smb-users@lists.sourceforge.net
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
> Ledger-smb-users@lists.sourceforge.net
> 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
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
