pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Martin Marques <martin@bugs.unl.edu.ar>
To: pgsql-php@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Not finding local variables and libs
Date: Mon, 10 Feb 2003 08:25:15 -0300
Message-ID: <200302100825.15158.martin@bugs.unl.edu.ar> (raw)

Last week I upgraded PostgreSQL to 7.3.1 and PHP to 4.3 last week, and I found 
that the CLI is giving me lots of headaches.
At first, a script that had to recieve mail form a pipe (an alias) and insert 
data into my PostgreSQL database stopped working. Put PEAR::DB on the script 
and found that the connection didn't find that database (not the server, the 
database where it should be inserted the data). If I execute the script from 
the command line "cat some-mail | /usr/local/bin/php/arch.php" it works 
great, but not if it's passed by the mail system.
Today I found out that the administration crons that run on sunday also didn't 
work, even though the same command works from the postgres bash. The postgres 
crontab looks like this:

0  23 * * 0 /usr/local/pgsql/bin/vacuumdb -z -v lismarch
10 23 * * 0 /usr/local/pgsql/bin/vacuumdb -z -v horde
30 23 * * 0 /usr/local/pgsql/bin/vacuumdb -z -v webunl

I got error reports from mail that said this:

Your "cron" job on bugs
/usr/local/pgsql/bin/vacuumdb -z -v lismarch

produced the following output:

ld.so.1: /usr/local/pgsql/bin/psql: fatal: libgcc_s.so.1: open failed: No such 
file or directory
Killed
vacuumdb: vacuum  lismarch failed


I thought it was a PHP problem, but these commands are especifically from 
PostgreSQL, so I guess the problem is there.

-- 
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------




view thread (4+ messages)  latest in thread

Message-ID: <200302100825.15158.martin@bugs.unl.edu.ar>
Permalink:  ../200302100825.15158.martin@bugs.unl.edu.ar/
Also on:    postgresql.org/message-id/200302100825.15158.martin@bugs.unl.edu.ar

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: martin@bugs.unl.edu.ar, pgsql-general@postgresql.org
  Subject: Re: Not finding local variables and libs
  In-Reply-To: <200302100825.15158.martin@bugs.unl.edu.ar>
  References: <200302100825.15158.martin@bugs.unl.edu.ar>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox