[imp] IMP 2.2.7/RH 7.1/PostgreSQL
Martín Marqués
martin@bugs.unl.edu.ar
Sat, 1 Dec 2001 10:51:43 -0300
On Vie 30 Nov 2001 23:27, you wrote:
[snip]
>
> The last time I did this was with tarballs on Caldera 1.3.1
> and 2.3.1 boxes. This time I am using the horde postgresql
> set of RPMs with the following from the redhat distribution:
>
> **at top after attempting to add a contact**
> Warning: 4 is not a valid PostgreSQL link resource in
> /var/www/html/horde/imp/lib/db.pgsql on line 82
>
> **at top on a compose window**
> Warning: 5 is not a valid PostgreSQL link resource in
> /var/www/html/horde/imp/lib/db.pgsql on line 113
> v
> ? self, even I'm not sure where I saw this
> Warning: 7 is not a valid PostgreSQL link resource in
> /var/www/html/horde/imp/lib/db.pgsql on line 139
>
> **when opening the preferences this is in "signature" box
> <br>
> <b>Warning</b>: 4 is not a valid PostgreSQL link resource in
> <b>/var/www/html/horde/imp/lib/db.pgsql</b> on line <b>139</b><br>
>
> *this is in "full name" box*
> <br><b>Warning</b>: 6 is not a valid PostgreSQL link resource in
> <b>/var/www/html/horde/imp/lib/db.pgsql</b> on line <b>113</b><br>
>
> *when saving full name in preferences*
> *at first no apparent error "preferences were updated"
> *when opening preferences again same as
> *above, but when trying to save again
> Warning: 5 is not a valid PostgreSQL link resource in
> /var/www/html/horde/imp/lib/db.pgsql on line 222
> Warning: Cannot add header information - headers already sent by (output
> started at /var/www/html/horde/imp/lib/db.pgsql:222) in
> /var/www/html/horde/imp/templates/doctype.inc on line 8
> An error occured; your signature was not updated.
>
> *The contents of /var/www/horde-phplib/local.inc
> *has been edited to reflect the password change
> *and the port number specified in postmaster.opt
This means there are problems witht the database connection. PHPLIB trys to
connect to POstgreSQL but gets a bad connection, so the id is false, and not
a valid link resource.
> relevant snipit of local.inc:
> # gla 11-28-01 set empty tcp port string and set password to match
> postgresql user hordemgr
> /* To use an SQL database, uncomment and edit the following: */
> class HordeDB extends DB_Sql {
> var $Host = 'localhost';
> var $Database = 'horde';
> var $User = 'hordemgr';
> var $Password = 'newpasswd';
> var $Port = '5432';
>
> *The contents of my /var/lib/pgsql/data/postmaster.opts
> *indicates port 5432(from localhost). Here it is
> *(the -i means accept TCP/IP ie., PGALLOWTCPIP=yes,
> *but incoming will be rejected by ipchains):
>
> /usr/bin/postmaster
> -p 5432
> -D /var/lib/pgsql/data
> -B 64
> -b /usr/bin/postgres
> -i
> -N 32
>
> but I'm unable to verify what port it is listening on
> other than the horde/test.ph3 "test horde" indicates
> sessions are working when local.inc is set to use port
> 5432 and doesn't when it is left ' '
> later verified /tmp/.s.PGSQL.5432, but still haven't
> started a telnet daemon long enough to check.
Try making a small php script with the phpinfo() function, and see the output
on your browser.
<?php
phpinfo();
?>
Checkout ipchains output with ipchains -L to se if you have database
connections opened for localhost.
Also check pg_hba.conf and add this if it's not there:
host all 127.0.0.1 255.255.255.255 password
> *****apache runs as user apache data is owned by "hordemgr"
> I don't know if user apache can connect to the horde database
> seems unlikely, but it isn't clear why horde checks out ok,
> and IMP can't access
>
> [root@yin horde]# strings /var/lib/pgsql/data/pg_shadow
> hordemgr
> newpasswd
> hordemgr
> hordemgr#C
> postgres
Thios has nothing to do, because PHP makes the connection with the user and
password given in the PHPLIB files. How apache runs is irrelevant here.
Try what I told you above.
Saludos... :-)
--
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
-----------------------------------------------------------------
>From ashihab@alcahest.com Date: Sat, 1 Dec 2001 18:03:12 +0000
Return-Path: <ashihab@alcahest.com>
Mailing-List: contact imp-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list imp@lists.horde.org
Received: (qmail 10862 invoked from network); 1 Dec 2001 17:59:49 -0000
Received: from host213-123-200-180.in-addr.btopenworld.com (HELO localmail.alcahest.com) (213.123.200.180)
by clark.horde.org with SMTP; 1 Dec 2001 17:59:49 -0000
Received: by localmail.alcahest.com (Postfix, from userid 48)
id B135AB710A; Sat, 1 Dec 2001 18:03:12 +0000 (GMT)
Received: from 192.168.0.3 ( [192.168.0.3])
as user ashihab@galgamish.alcahest.com by intranet.alcahest.com with HTTP;
Sat, 1 Dec 2001 18:03:12 +0000
Message-ID: <1007229792.3c091b609348f@intranet.alcahest.com>
Date: Sat, 1 Dec 2001 18:03:12 +0000
From: Ahmed <ashihab@alcahest.com>
To: imp@lists.horde.org
References: <1006901130.3c04178aa7192@intranet.alcahest.com> <1006969076.3c0520f430980@linux.wg.de> <1007065558.3c0699d6c1fb3@intranet.alcahest.com> <1007208646.3c08c8c63a79e@linux.wg.de>
In-Reply-To: <1007208646.3c08c8c63a79e@linux.wg.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 4.0-cvs
Subject: Re: [imp] Double Compose windows
Jan,
The latest CVS update seems to have cleared the problem up. Thanks.
I have been wondering whether the automatic opening of the compose
window is desirable. When you open the draft message it appears in
the main display window with the "resume" button visible anyway. That
gives you the choice to either discard the message completely or
resume it by opening a compose window.
would it not make more sense to simply open the message like any
other message and leave the choice to the user if they want to resume
that message, via the "resume" button?
Comments?
Ahmed...
Quoting Jan Schneider <jan@horde.org>:
> Zitat von Ahmed <ashihab@alcahest.com>:
>
> > Jan,
> >
> > Browser is IE 5.50.4807.2300 (on win 2000) I've also tried
> konqueror
> > 2.1.1 (KDE 2.12) under linux RH 7.1
> >
> > Further observation:
> >
> > if you click on the recipient field you get a single compose
> window
> > and the message is opened for reading in the main browser as
> well.
> >
> > if you click on the subject field you get 2 compose windows and
> no
> > display in the main window.
>
> This was caused by the td onclick event we introduced a few weeks
> ago. The
> compose window is now opened automatically if the onload event of
> draft
> message fires instead of when you click on the subject or recipient
> in the
> mailbox view.
>
> Jan.
>
> ::::::::::::::::::::::::::::::::::::::::
> AMMMa AG - discover your knowledge
> :::::::::::::::::::::::::::
> Detmolder Str. 25-33 :: D-33604 Bielefeld
> fon +49.521.96878-0 :: fax +49.521.96878-20
> http://www.ammma.de
> ::::::::::::::::::::::::::::::::::::::::::::::
>
> --
> IMP mailing list: http://horde.org/imp/
> Archive: http://marc.theaimsgroup.com/?l=imp&r=1&w=2
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org
>
>
>
>
>From chuck@horde.org Date: Sat, 1 Dec 2001 13:05:35 -0500
Return-Path: <chuck@horde.org>
Mailing-List: contact imp-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list imp@lists.horde.org
Received: (qmail 11836 invoked from network); 1 Dec 2001 18:06:14 -0000
Received: from h00104bc60b3c.ne.mediaone.net (HELO marina.horde.org) (24.91.196.127)
by clark.horde.org with SMTP; 1 Dec 2001 18:06:14 -0000
Received: by marina.horde.org (Postfix, from userid 33)
id 44AC639B4; Sat, 1 Dec 2001 13:05:35 -0500 (EST)
Received: from 192.168.0.113 ( [192.168.0.113])
as user chuck@localhost by marina.horde.org with HTTP;
Sat, 1 Dec 2001 13:05:35 -0500
Message-ID: <1007229935.3c091bef1acbd@marina.horde.org>
Date: Sat, 1 Dec 2001 13:05:35 -0500
From: Chuck Hagenbuch <chuck@horde.org>
To: imp@lists.horde.org
References: <1006901130.3c04178aa7192@intranet.alcahest.com> <1006969076.3c0520f430980@linux.wg.de> <1007065558.3c0699d6c1fb3@intranet.alcahest.com> <1007208646.3c08c8c63a79e@linux.wg.de>
In-Reply-To: <1007208646.3c08c8c63a79e@linux.wg.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 4.0-cvs
Subject: Re: [imp] Double Compose windows
Quoting Jan Schneider <jan@horde.org>:
> This was caused by the td onclick event we introduced a few weeks ago. The
> compose window is now opened automatically if the onload event of draft
> message fires instead of when you click on the subject or recipient in the
> mailbox view.
That's a significant change in behavior, and results in a completely
unnecessary page load. I'd rather try and find a way to fix the javascript. Can
you revert this change?
-chuck
--
Charles Hagenbuch, <chuck@horde.org>
"What was and what may be, lie, like children whose faces we cannot see, in the
arms of silence. All we ever have is here, now." - Ursula K. Le Guin
>From jan@horde.org Date: Sat, 1 Dec 2001 19:36:25 +0100
Return-Path: <jan@horde.org>
Mailing-List: contact imp-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list imp@lists.horde.org
Received: (qmail 13307 invoked from network); 1 Dec 2001 18:37:47 -0000
Received: from mailout01.sul.t-online.com (HELO mailout01.sul.t-online.de) (194.25.134.80)
by clark.horde.org with SMTP; 1 Dec 2001 18:37:47 -0000
Received: from fwd04.sul.t-online.de
by mailout01.sul.t-online.de with smtp
id 16AF1F-0007mR-04; Sat, 01 Dec 2001 19:37:45 +0100
Received: from linux.wg.de (320034214675-0001@[217.225.33.38]) by fmrl04.sul.t-online.com
with esmtp id 16AF17-0To9hoC; Sat, 1 Dec 2001 19:37:37 +0100
Received: from localhost (localhost [127.0.0.1])
by linux.wg.de (8.11.0/8.11.0/SuSE Linux 8.11.0-0.4) with ESMTP id fB1IaQk30119
for <imp@lists.horde.org>; Sat, 1 Dec 2001 19:36:26 +0100
Received: from 192.168.60.1 ( [192.168.60.1])
as user jan@linux by linux.wg.de with HTTP;
Sat, 1 Dec 2001 19:36:25 +0100
Message-ID: <1007231785.3c0923298b0af@linux.wg.de>
Date: Sat, 1 Dec 2001 19:36:25 +0100
From: Jan Schneider <jan@horde.org>
To: imp@lists.horde.org
References: <1006901130.3c04178aa7192@intranet.alcahest.com> <1006969076.3c0520f430980@linux.wg.de> <1007065558.3c0699d6c1fb3@intranet.alcahest.com> <1007208646.3c08c8c63a79e@linux.wg.de> <1007229935.3c091bef1acbd@marina.horde.org>
In-Reply-To: <1007229935.3c091bef1acbd@marina.horde.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 4.0-cvs
X-Sender: 320034214675-0001@t-dialin.net
Subject: Re: [imp] Double Compose windows
Zitat von Chuck Hagenbuch <chuck@horde.org>:
> Quoting Jan Schneider <jan@horde.org>:
>
> > This was caused by the td onclick event we introduced a few weeks ago.
> The
> > compose window is now opened automatically if the onload event of draft
>
> > message fires instead of when you click on the subject or recipient in
> the
> > mailbox view.
>
> That's a significant change in behavior, and results in a completely
> unnecessary page load. I'd rather try and find a way to fix the
> javascript. Can
> you revert this change?
Done.
Jan.
::::::::::::::::::::::::::::::::::::::::
AMMMa AG - discover your knowledge
:::::::::::::::::::::::::::
Detmolder Str. 25-33 :: D-33604 Bielefeld
fon +49.521.96878-0 :: fax +49.521.96878-20
http://www.ammma.de
::::::::::::::::::::::::::::::::::::::::::::::