Hi Alex,
I continued debugging a bit and found DB::Connect to fail using the
DSN: "pgsql://mail:[EMAIL PROTECTED]/mail"
So the missing extension refers to "pgsql" I assume? How can this be?
The example 01connect.phpt script delivered with pear WORKS as I
stated before ...
Thanks
Chris
Saturday
Hi Paul,
pdt> Sounds like the user you use to access the DB doesn't have sufficient
pdt> grants to insert rows in the prefs table. Recheck (maybe grant FULL
pdt> access just for testing) and try again...
I checked permissions and the mail user is granted FULL permissions.
Thanks
Chris
--
Hi Alex,
AL> Chris, normally you should have nothing to do. It is expected to have
AL> empty tables at start, of course, like file prefs.
AL> Could you check with psql that you have something like:
=>> \d userprefs
This is what it returned for me:
mail=# \d userprefs
Table "userpr
> I finally tracked down the problem to the fact, that squirrel is
> trying to cache the user preferences in dbPrefs.php and obviously
> fails, as there is NO record in the prefs table.
>
> It a new install and the address and user preferences tables are as
> empty as they get created due to the d
> Hi,
>
> I finally tracked down the problem to the fact, that squirrel is
> trying to cache the user preferences in dbPrefs.php and obviously
> fails, as there is NO record in the prefs table.
>
> It a new install and the address and user preferences tables are as
> empty as they get created due
Hi,
I finally tracked down the problem to the fact, that squirrel is
trying to cache the user preferences in dbPrefs.php and obviously
fails, as there is NO record in the prefs table.
It a new install and the address and user preferences tables are as
empty as they get created due to the doc/db-b
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hey Alex,
first of all, thanks for your help!
AL> Ok Chris, then if you try your script with a non existent user, you should
AL> get something like:
AL> PHP Warning: pg_pconnect() unable to connect to PostgreSQL server: FATAL:
AL> user "foo" does
> Hey Alex,
>
> well, ok, DSN 8-) ... I tested the following script:
>
> SNIP
Ok Chris, then if you try your script with a non existent user, you should
get something like:
PHP Warning: pg_pconnect() unable to connect to PostgreSQL server: FATAL:
user "foo" does no
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hey Alex,
well, ok, DSN 8-) ... I tested the following script:
SNIP
- --TEST--
DB_pgsql::connect test
- --FILE--
connection)) {
print "\$dbh is connected\n";
}
?>
- --EXPECT--
$dbh is an object
$dbh is connected
*
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi,
>
> I'm trying to setup squirrelmail use PostgreSQL for addressbook and
> preferences but have no success with it ...
>
> Even so I created a database, added the tables as instructed in the
> docs and checked that PEAR DB has access to post
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I'm trying to setup squirrelmail use PostgreSQL for addressbook and
preferences but have no success with it ...
Even so I created a database, added the tables as instructed in the
docs and checked that PEAR DB has access to postgreSQL, I keep get
11 matches
Mail list logo
