X-Original-To: pgsql-general@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A6233474E44; Mon, 10 Feb 2003 06:27:27 -0500 (EST) Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by postgresql.org (Postfix) with ESMTP id 72BD2475843; Mon, 10 Feb 2003 06:27:26 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id 95332FDF0; Mon, 10 Feb 2003 08:25:20 -0300 (GMT) Received: from bugs (bugs [168.96.132.208]) by bugs.unl.edu.ar (Postfix) with ESMTP id F3A69FB8D; Mon, 10 Feb 2003 08:25:17 -0300 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: Martin Marques To: pgsql-php@postgresql.org Subject: Not finding local variables and libs Date: Mon, 10 Feb 2003 08:25:15 -0300 X-Mailer: KMail [version 1.4] Cc: pgsql-general@postgresql.org MIME-Version: 1.0 Message-Id: <200302100825.15158.martin@bugs.unl.edu.ar> X-Virus-Scanned: by AMaViS snapshot-20020300 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/565 X-Sequence-Number: 37319 Last week I upgraded PostgreSQL to 7.3.1 and PHP to 4.3 last week, and I fo= und=20 that the CLI is giving me lots of headaches. At first, a script that had to recieve mail form a pipe (an alias) and inse= rt=20 data into my PostgreSQL database stopped working. Put PEAR::DB on the scrip= t=20 and found that the connection didn't find that database (not the server, th= e=20 database where it should be inserted the data). If I execute the script fro= m=20 the command line "cat some-mail | /usr/local/bin/php/arch.php" it works=20 great, but not if it's passed by the mail system. Today I found out that the administration crons that run on sunday also did= n't=20 work, even though the same command works from the postgres bash. The postgr= es=20 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 s= uch=20 file or directory Killed vacuumdb: vacuum lismarch failed I thought it was a PHP problem, but these commands are especifically from= =20 PostgreSQL, so I guess the problem is there. --=20 Porqu=E9 usar una base de datos relacional cualquiera, si pod=E9s usar PostgreSQL? ----------------------------------------------------------------- Mart=EDn Marqu=E9s | mmarques@unl.edu.ar Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------