[horde] trouble with mysql db and php w/IMP
René Lund Jensen
lundeman at email.dk
Mon Oct 1 05:23:55 PDT 2001
You don't have to compile when you update pear.
You can just get the latest pear from CVS and copy that to
your existing pear directory, and you're running...
(Pear is just a collection of php classes).
René Jensen.
lundeman at tbkol.dk
----- Original Message -----
From: "Jesse Wolff" <jesse_wolff at yahoo.com>
To: <horde at lists.horde.org>
Sent: Monday, October 01, 2001 11:30 AM
Subject: Re: [horde] trouble with mysql db and php w/IMP
> I'm not sure if it's a PEAR related issue but if it is...
>
> The PEAR that's included with the latest php distributions isn't current
> enough. This is mentioned on the website
> http://www.horde.org/imp/2.3/supported.php. You'll need the CVS version.
Here
> are a few steps to update PEAR.
>
> Unzip your php distribution (php-4.0.6.tar.gz)
> tar xvf php-4.0.6.tar.gz
>
> Change to the distribution directory and remove the pear directory.
> cd php-4.0.6
> rm -rf pear
>
> Login to the PHP CVS repository. Use phpfi as the password.
> cvs -d :pserver:cvsread at cvs.php.net:/repository login
>
> Get the latest pear CVS tree.
> cvs -d :pserver:cvsread at cvs.php.net:/repository co pear
>
> Now set your configuration options and compile.
>
>
> Quoting Eric Ekong <ekonge at cuaa.edu>:
>
> > At the time I was using the latest. That might not be true anymore.
> > I just checked the version number of php and it is 4.0.6
> >
> > Eric
> > * Jesse Wolff <jesse_wolff at yahoo.com> [010927 16:10]:
> > >
> > > Are you using the latest PEAR from the PHP cvs?
> > >
> > > Jesse.
> > >
> > > Quoting Eric Ekong <eric at unixtechs.org>:
> > >
> > > > Can anyone tell me where these errors are coming from?
> > > >
> > > > ing: Undefined property: connection in
/usr/local/lib/php/DB/mysql.php
> > > > on line 437
> > > >
> > > > Warning: Supplied argument is not a valid MySQL-Link resource in
> > > > /usr/local/lib/php/DB/mysql.php on line 437
> > > >
> > > > Warning: Undefined index: in /usr/local/lib/php/DB/common.php on
line
> > > > 126
> > > >
> > > > Warning: Undefined property: connection in
> > > > /usr/local/lib/php/DB/mysql.php on line 440
> > > >
> > > > Warning: Supplied argument is not a valid MySQL-Link resource in
> > > > /usr/local/lib/php/DB/mysql.php on line 440
> > > >
> > > > Fatal error: Call to undefined function: disconnect() in
> > > > /usr/local/apache/htdocs/horde/lib/Prefs/sql.php on line 276
> > > >
> > > > I have the latest cvs installed as of about 3 weeks ago? I also
have
> > > > PHP 6.0.4 installed. Any ideas?
> > > >
> > > > Eric
> > > > --
> > > > Uptime:
> > > > 5 days, 14:30
> > > >
> > > > --
> > > > Horde mailing list: http://horde.org/horde/
> > > > Frequently Asked Questions: http://horde.org/faq/
> > > > To unsubscribe, mail: horde-unsubscribe at lists.horde.org
> > > >
> > >
> > >
> > >
> > > --
> > > Horde mailing list: http://horde.org/horde/
> > > Frequently Asked Questions: http://horde.org/faq/
> > > To unsubscribe, mail: horde-unsubscribe at lists.horde.org
> >
> > --
> > ///
> > (. .)
> > =======================oOO-(_)-OOo===========================
> > Eric I. Ekong Internet Software Systems Engineer I
> > Dial Systems Ops
> > UUNet, a WorldCom Company
> > 880 Technlogy Drive
> > Ann Arbor, MI 48108-8910
> > erice at uu.net or ekonge at ccaa.edu
> > office phone: 734-214-7435
> > pager:1-888-806-8347
> > =============================================================
> >
> > Uptime:
> > 2:09AM up 6 days, 13:10, 3 users, load averages: 0.03, 0.52, 0.79
> >
> > --
> > Horde mailing list: http://horde.org/horde/
> > Frequently Asked Questions: http://horde.org/faq/
> > To unsubscribe, mail: horde-unsubscribe at lists.horde.org
> >
>
>
>
> --
> Horde mailing list: http://horde.org/horde/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>
>
>
>From admin at networkessence.net Date: Tue, 2 Oct 2001 13:58:33 -0500
Return-Path: <admin at networkessence.net>
Mailing-List: contact horde-help at lists.horde.org; run by ezmlm
Delivered-To: mailing list horde at lists.horde.org
Received: (qmail 26050 invoked from network); 2 Oct 2001 19:03:11 -0000
Received: from www.networkessence.net (HELO ns.networkessence.net) (216.40.211.25)
by clark.horde.org with SMTP; 2 Oct 2001 19:03:11 -0000
Received: (from root at localhost)
by ns.networkessence.net (8.10.2/8.10.2) id f92IwYu29338
for horde at lists.horde.org; Tue, 2 Oct 2001 13:58:34 -0500
From: Alex Leverington <admin at networkessence.net>
Received: from 216.138.91.195 ( [216.138.91.195])
as user admin at 127.0.0.1 by www.networkessence.net with HTTP;
Tue, 2 Oct 2001 13:58:33 -0500
Message-ID: <1002049113.3bba0e59958a6 at www.networkessence.net>
Date: Tue, 2 Oct 2001 13:58:33 -0500
To: horde at lists.horde.org
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
X-Originating-IP: 216.138.91.195
Subject: Login
This problem has probably occured before and I've probably overlooked something
but I can't seem to figure out what it is. I have Imp working perfectly, but I
am unable to get any other features (turba, kronolith, etc) working. I enter
user and password to login but it does nothing but just bring me back to the
login prompt. I have tried authentication settings for sql (mysql), imap, and
mcal, but still had the same problem. I updated from CVS this morning at about
2am (CST). Any suggestions?
here are versions:
Horde: 1.3.5-cvs
IMP: 2.3.7-cvs
Turba: 0.0.3-cvs
Gollem: 0.0.1-cvs
Nic: 0.0.2-cvs
Kronolith: 0.0.3-cvs
Jonah: 0.0.3-cvs
Troll: 0.0.2-cvs
Chora: 0.6.5-cvs
Whups: 0.0.1-cvs
Nag: 0.0.2-cvs
under test.php the only thing not supported is ftp, mcrypt and postgreSQL. (is
mycrypt needed? - if it is, that will make the 9th re-compiling of php in 24
hrs ;)
http://www.networkessence.net/horde/test.php
http://www.networkessence.net/phpinfo.php
My thanks in advanced...I will try to assist with this project as soon as I can
get it working.
Thanks,
Alex Leverington
admin at networkessence.net
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/
>From chuck at horde.org Date: Tue, 2 Oct 2001 15:19:34 -0400
Return-Path: <chuck at horde.org>
Mailing-List: contact horde-help at lists.horde.org; run by ezmlm
Delivered-To: mailing list horde at lists.horde.org
Received: (qmail 27151 invoked from network); 2 Oct 2001 19:20:08 -0000
Received: from h00104bc60b3c.ne.mediaone.net (HELO marina.horde.org) (24.91.198.7)
by clark.horde.org with SMTP; 2 Oct 2001 19:20:08 -0000
Received: by marina.horde.org (Postfix, from userid 33)
id 7EBAB3A05; Tue, 2 Oct 2001 15:19:34 -0400 (EDT)
Received: from 206.243.191.252 ( [206.243.191.252])
as user chuck at localhost by marina.horde.org with HTTP;
Tue, 2 Oct 2001 15:19:34 -0400
Message-ID: <1002050374.3bba134651dc4 at marina.horde.org>
Date: Tue, 2 Oct 2001 15:19:34 -0400
From: Chuck Hagenbuch <chuck at horde.org>
To: horde at lists.horde.org
References: <1002049113.3bba0e59958a6 at www.networkessence.net>
In-Reply-To: <1002049113.3bba0e59958a6 at www.networkessence.net>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
Subject: Re: [horde] Login
Quoting Alex Leverington <admin at networkessence.net>:
> This problem has probably occured before and I've probably overlooked
> something but I can't seem to figure out what it is. I have Imp working
> perfectly, but I am unable to get any other features (turba, kronolith, etc)
> working. I enter user and password to login but it does nothing but just
> bring me back to the login prompt. I have tried authentication settings for
> sql (mysql), imap, and mcal, but still had the same problem. I updated from
> CVS this morning at about 2am (CST). Any suggestions?
Well, how are you configuring $conf['auth']? Have you added users to a sql
system? etc...
-chuck
--
"There is a river of blood between them." - A member of RAWA
(http://www.rawa.org) on the difference between the people of Afghanistan and
the criminal government of Afghanistan.
>From admin at networkessence.net Date: Tue, 2 Oct 2001 14:58:47 -0500
Return-Path: <admin at networkessence.net>
Mailing-List: contact horde-help at lists.horde.org; run by ezmlm
Delivered-To: mailing list horde at lists.horde.org
Received: (qmail 28570 invoked from network); 2 Oct 2001 20:03:24 -0000
Received: from www.networkessence.net (HELO ns.networkessence.net) (216.40.211.25)
by clark.horde.org with SMTP; 2 Oct 2001 20:03:24 -0000
Received: (from root at localhost)
by ns.networkessence.net (8.10.2/8.10.2) id f92JwlQ31693
for horde at lists.horde.org; Tue, 2 Oct 2001 14:58:47 -0500
From: Alex Leverington <admin at networkessence.net>
Received: from 216.138.91.195 ( [216.138.91.195])
as user admin at 127.0.0.1 by www.networkessence.net with HTTP;
Tue, 2 Oct 2001 14:58:47 -0500
Message-ID: <1002052727.3bba1c775fd86 at www.networkessence.net>
Date: Tue, 2 Oct 2001 14:58:47 -0500
To: horde at lists.horde.org
References: <1002049113.3bba0e59958a6 at www.networkessence.net> <1002050374.3bba134651dc4 at marina.horde.org>
In-Reply-To: <1002050374.3bba134651dc4 at marina.horde.org>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
X-Originating-IP: 216.138.91.195
Subject: Re: [horde] Login
Here is what I used:
$conf['auth']['driver'] = 'sql';
$conf['auth']['params'] = array();
$conf['auth']['params']['phptype'] = 'mysql';
$conf['auth']['params']['hostspec'] = 'localhost';
$conf['auth']['params']['username'] = 'webmailmgr';
$conf['auth']['params']['password'] = 'XXXXXX';
$conf['auth']['params']['database'] = 'horde';
$conf['auth']['params']['table'] = 'horde_users';
for imap I used:
- well, IMAP seemed to halfway work:
I got the following errors with imap set:
Warning: Undefined index: conf
in /home/sites/www.networkessence.net/web/horde/nag/lib/base.php on line 45
and some other weird stuff.
I would prefer to use mysql, but it doesn't work at all. I added a username and
password to the table, using cleartext for the password. I would prefer using
mysql as opposed to imap though.
What direction should I look in for the sql problem (I'm fairly sure I could
get all the imap stuff working if need be).
-Alex
Quoting Chuck Hagenbuch <chuck at horde.org>:
> Quoting Alex Leverington <admin at networkessence.net>:
>
> > This problem has probably occured before and I've probably overlooked
> > something but I can't seem to figure out what it is. I have Imp working
> > perfectly, but I am unable to get any other features (turba, kronolith,
> etc)
> > working. I enter user and password to login but it does nothing but just
> > bring me back to the login prompt. I have tried authentication settings for
>
> > sql (mysql), imap, and mcal, but still had the same problem. I updated from
>
> > CVS this morning at about 2am (CST). Any suggestions?
>
> Well, how are you configuring $conf['auth']? Have you added users to a sql
> system? etc...
>
> -chuck
>
> --
> "There is a river of blood between them." - A member of RAWA
> (http://www.rawa.org) on the difference between the people of Afghanistan and
>
> the criminal government of Afghanistan.
>
> --
> Horde mailing list: http://horde.org/horde/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/
>From chuck at horde.org Date: Tue, 2 Oct 2001 16:23:58 -0400
Return-Path: <chuck at horde.org>
Mailing-List: contact horde-help at lists.horde.org; run by ezmlm
Delivered-To: mailing list horde at lists.horde.org
Received: (qmail 29376 invoked from network); 2 Oct 2001 20:24:34 -0000
Received: from h00104bc60b3c.ne.mediaone.net (HELO marina.horde.org) (24.91.198.7)
by clark.horde.org with SMTP; 2 Oct 2001 20:24:34 -0000
Received: by marina.horde.org (Postfix, from userid 33)
id F10E23A05; Tue, 2 Oct 2001 16:23:58 -0400 (EDT)
Received: from 206.243.191.252 ( [206.243.191.252])
as user chuck at localhost by marina.horde.org with HTTP;
Tue, 2 Oct 2001 16:23:58 -0400
Message-ID: <1002054238.3bba225ec90af at marina.horde.org>
Date: Tue, 2 Oct 2001 16:23:58 -0400
From: Chuck Hagenbuch <chuck at horde.org>
To: horde at lists.horde.org
References: <1002049113.3bba0e59958a6 at www.networkessence.net> <1002050374.3bba134651dc4 at marina.horde.org> <1002052727.3bba1c775fd86 at www.networkessence.net>
In-Reply-To: <1002052727.3bba1c775fd86 at www.networkessence.net>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
Subject: Re: [horde] Login
Quoting Alex Leverington <admin at networkessence.net>:
> I would prefer to use mysql, but it doesn't work at all. I added a username
> and password to the table, using cleartext for the password. I would prefer
> using mysql as opposed to imap though.
It works fine. Passwords are md5()ed (use the php function).
-chuck
--
"There is a river of blood between them." - A member of RAWA
(http://www.rawa.org) on the difference between the people of Afghanistan and
the criminal government of Afghanistan.
More information about the horde
mailing list