Re[3]: [SM-USERS] Squirrelmail with postgreSQL

[Idefix@GoForIt.de]

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-backend.txt manual.

So, what exactly do I need to do now? I tried adding a record to the
userprefs table with these values: "username: us...@se...,
prefkey: 1, prefval: 0" but it didn't help. Same error!

Thanks
Chris


Wednesday, July 9, 2003, 6:32:19 PM, you wrote:

IGd> -----BEGIN PGP SIGNED MESSAGE-----
IGd> Hash: SHA1

IGd> Hey Alex,

IGd> well, ok, DSN 8-) ... I tested the following script:

IGd> ****************SNIP****************
IGd> - --TEST--
IGd> DB_pgsql::connect test
IGd> - --FILE--
IGd> <?php require "connect.inc";
IGd> if (is_object($dbh)) {
IGd>     print "\$dbh is an object\n";
IGd> }
IGd> if (is_resource($dbh->connection)) {
IGd>     print "\$dbh is connected\n";
IGd> }
?>>
IGd> - --EXPECT--
IGd> $dbh is an object
IGd> $dbh is connected

IGd> ****************SNIP****************

IGd> connect.inc says:

IGd> ****************SNIP****************

IGd> <?php
IGd> $conn = pg_pconnect("user=mail dbname=mail");
IGd> if (!$conn) {
IGd>   echo "An error occured.\n";
IGd>   exit;
IGd> }
?>>
IGd> ****************SNIP****************

IGd> So, as this doesn't show an error, I suppose it works, doesn't it?
IGd> Eh, I run it like this: "php testdb.php"

IGd> - ---

IGd> Best regards,
IGd> Chris


IGd> Wednesday, July 9, 2003, 4:38:56 PM, you wrote:

>>> -----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 getting
>>> this one:
>>>
>>> "Preference database error (extension not found). Exiting abnormally"
>>>
>>>
>>> The DNS string configured is definitely correct.
AL>> DSN :)
AL>> A first guess is you don't have the pgsql support for php4 installed. In
AL>> Debian it's called php4-pgsql. Also make sure you used pgsql as extension
AL>> name in you DSN. How did you check "that PEAR DB has access to
AL>> postgreSQL"?

AL>> HTH,
AL>> Alex.
IGd> -----BEGIN PGP SIGNATURE-----
IGd> Version: GnuPG v1.2.1 (MingW32)

IGd> iD8DBQE/DMIkwxLCEacfbwIRAp9dAKDFsfx/nPh9/XcpcogoPQbqlVDIKACgpi2h
IGd> w35a8w67svO8xHoIsb1LsD8=
IGd> =UgFH
IGd> -----END PGP SIGNATURE-----



IGd> -------------------------------------------------------
IGd> This SF.Net email sponsored by: Parasoft
IGd> Error proof Web apps, automate testing & more.
IGd> Download & eval WebKing and get a free book.
IGd> www.parasoft.com/bulletproofapps
IGd> --
IGd> squirrelmail-users mailing list
IGd> List Address: squ...@li...
IGd> List Archives:  http://sourceforge.net/mailarchive/forum.php?forum_id=2995
IGd> List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users