On Fri, Apr 6, 2012 at 1:58 AM, apallik <apal...@ivo.gr> wrote: > > Chris Travers-5 wrote >> >> On Thu, Apr 5, 2012 at 12:10 PM, apallik <apallik@> wrote: >> >>> >>> >>> Just looked through the error log file again and the apache log files and >>> it >>> turns out that the problem occurs with psql command not found. Even >>> though >>> when I do echo$ PATH is see that my path is set correctly and when I call >>> psql from terminal it responds, it seems not to identify the command when >>> called through the Database.pm file that creates the new database. Hope >>> this >>> helps >>> >> It does. >> >> Try setting PATH variables in your ledgersmb.conf. >> >> Best Wishes, >> Chris Travers >> >> ------------------------------------------------------------------------------ >> For Developers, A Lot Can Happen In A Second. >> Boundary is the first to Know...and Tell You. >> Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! >> http://p.sf.net/sfu/Boundary-d2dvs2 >> _______________________________________________ >> Ledger-smb-users mailing list >> Ledger-smb-users@.sourceforge >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >> > > Ok this worked but now I am getting some other error messages and notices. > I'll start with the error messages and try to fix those > > /Library/PostgreSQL/9.1/share/postgresql/extension/pg_trgm.sql: No such file > or directory/Library/PostgreSQL/9.1/share/postgresql/extension/tsearch2.sql: > No such file or directory > /Library/PostgreSQL/9.1/share/postgresql/extension/tablefunc.sql: No such > file or directory > > When I look in the specific directory (.../extension/) I do have all these > files but as pg_trgm--1.0.spl (similar for other files). When I look in the > Database.pm I have > > > my @contrib_scripts = qw(pg_trgm tsearch2 tablefunc); > if($ENV{PG_CONTRIB_DIR}) > { > #postgres 9.1 this is done by create extension pg_trgm btree_gist .. > for my $contrib (@contrib_scripts){ > $rc2=system("psql -f $ENV{PG_CONTRIB_DIR}/$contrib.sql >> > $temp/dblog_stdout 2>>$temp/dblog_stderr"); > > > Is that the problem, eg pg_trgm not being pg_trgm--1.0 ? Also, I have > .control files in the same directory (eg pg_trgm.control). I have also been > looking for the contrib.sql in the same directory but cannot find it, is > this somewhere else? > These are harmless. We use CREATE EXTENSION in the Pg-database.sql to prevent this from being a problem.
Best Wishes, Chris Travers ------------------------------------------------------------------------------ For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
