[imp] Log or a $var_dump to check MySQL prefs connection?

[Mike Coughlan]

Thanks for the post, I'm almost there. I was able to effect the table from
mysql with the params from horde.php to check permissions.  However, I did
notice that the SQL statements from the logs are missing quotes around the
strings.

>From the log:
   8 Query       insert into horde_prefs (uid, scope, pref_name, pref_value)
values(mcoughlan, imp, max_msgs, 40)

At the mysql prompt:
  mysql> insert into horde_prefs (uid, scope, pref_name, pref_value)
    -> values('mcoughlan', 'imp', 'max_msgs', 40);

  Query OK, 1 row affected (0.00 sec)

Seems like quotes are what's needed.  From the mail list, I believe I may
need a newer lib/Prefs/sql.php.

It is most upsetting that horde can't write to MySQL, while mysql.err is
empty.



> -----Original Message-----
> From: TOM GERMIAT [mailto:TOM.GERMIAT@menasha.com]
> Sent: Tuesday, October 23, 2001 4:20 PM
> To: imp@lists.horde.org
> Subject: Re: [imp] Log or a $var_dump to check MySQL prefs connection?
>
>
> Your username and password look as though they might be the
> system root.  You need to make sure you're using an SQL account
> name here with sufficient authority to operate on the horde database.
>
>



>From n2wog@usa.net Date: 23 Oct 2001 17:08:47 EDT
Return-Path: <n2wog@usa.net>
Mailing-List: contact imp-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list imp@lists.horde.org
Received: (qmail 63427 invoked from network); 23 Oct 2001 21:08:44 -0000
Received: from urdvg135.cms.usa.net (204.68.25.135)
  by clark.horde.org with SMTP; 23 Oct 2001 21:08:44 -0000
Received: (qmail 18597 invoked from network); 30 Jan 2001 21:17:55 -0000
Received: from cpdvg100.netaddress.usa.net (165.212.8.100)
  by outbound.postoffice.net with SMTP; 30 Jan 2001 21:17:55 -0000
Received: (qmail 7805 invoked by uid 60001); 23 Oct 2001 21:08:47 -0000
Message-ID: <20011023210847.7804.qmail@cpdvg100.netaddress.usa.net>
Received: from 165.212.8.100 by mx08 for [147.140.158.251] via web-mailer(34FM.0700.21.01) on Tue Oct 23 21:08:47 GMT 2001
Date: 23 Oct 2001 17:08:47 EDT
From: E M Recio <n2wog@usa.net>
To: imp@lists.horde.org
CC: horde@lists.horde.org
X-Mailer: USANET web-mailer (34FM.0700.21.01)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Subject: page_open() error in mailbox.php3

I have searched the horde and imp mailing lists for this problem. I have =
seen
people post this problem, but there has not been a response to it. So I a=
m
asking once again.

I keep getting the following error after running ./secure.sh and going to=

/horde/imp directory with my browser:


Fatal error: Call to undefined function: page_open() in
/var/www/html/horde/imp/mailbox.php3 on line 104

If anyone can shed any light on this situation, it would be greatly
appreciated.

Best Regards,
E. M. Recio =


*******************************************************
* Email: <n2wog@usa.net> ICQ: <458042> AIM: <emrecio> *
* Homepage: < http://polywog.navpoint.com >           *
*******************************************************


____________________________________________________________________
Get free e-mail and a permanent address at http://www.amexmail.com/?A=3D1=