[imp] DB Error: connect failed

[Hammad]

Thanks I created the php script and saw the horde was unable to login so I
played around with the mysql user settings and it works now. Thanks for
pointing me in the right direction.
Kevin A

> -----Original Message-----
> From: Hammad [mailto:hammad@brisksolutions.com]
> Sent: Tuesday, December 03, 2002 2:44 PM
> To: kevina@MAV.COM
> Subject: RE: [imp] DB Error: connect failed
>
>
> Check if you php has been compile with mysql support. If so, make
> a test php
> file and connect to your database. You can use the following php
> code if you want.
>
>   $query = "select * from horde_prefs";
>   $db = mysql_connect("localhost","dbuser","dbpasswd") or
> die("Could not conne
> ct");
>   mysql_select_db("database_name",$db);
>   $result=mysql_query($query,$db) or die("Bad Query: ".mysql_error());
>   mysql_close($db);
>
> If you get an error: Could not connect, investigate according to
> that why php is
> not able to connect. If you get undefined function
> 'mysql_connect' then your php
> is not compiled with mysql support, you can also check by calling
> phpinfo()
> function.
>
> -Hammad
>
>
> > Quoting Kevin Arnold <kevina@MAV.COM>:
> >
> > > Yes I can connect to the database as root mysql -u root -p  and
> > I can also
> > > connect to it with the horde credentials
> > > mysql -u horde -p "hordepassword" on the server.
> > > Any other suggestions?
> > > Kevin A
> > >
> > > > -----Original Message-----
> > > > From: imp-bounces@lists.horde.org
> [mailto:imp-bounces@lists.horde.org]On
> > > Behalf Of Hammad
> > > Sent: Tuesday, December 03, 2002 1:48 PM
> > > To: kevina@mav.com
> > > Cc: imp@lists.horde.org
> > > Subject: Re: [imp] DB Error: connect failed
> > >
> > >
> > > Did you check if you database is UP? Test you DB connection
> > > without using IMP.
> > >
> > > -Hammad
> > >
> > >
> > > Quoting Kevin Arnold <kevina@MAV.COM>:
> > >
> > > > I have just installed Horde and Imp. I have verified my setup
> > > with test.php
> > > > page and all passed. How ever when I try and log into Horde/Imp
> > > I receive
> > > > DB
> > > > Error: connect failed [line 102 of
> > > > /opt/apache/htdocs/horde/lib/Prefs/sql.php] I have searched this
> > mailing
> > > > list and Goggle, yahoo for a solutions or something that will
> > > point me in
> > > > the right direction, and have seen others with the same problem but
> no
> > > > solutions. I'm using IMP 3.1 with Horde 2.1, MySQL 3.23.52,
> > > Apache 1.3.27.
> > > > I
> > > > have setup horde.php for use with sql and have created the
> > > horde database
> > > > with the scripts provided by Horde 2.1. Also edited
> > > registry.php to use IMP
> > > > for authentication.
> > > > Can anybody think of a possible reason for this error.
> > > > Thanks much
> > > >
> > > > Kevin A
> > > > kevina@mav.com
> > > >
> > > >
> > > > --
> > > > IMP mailing list
> > > > Frequently Asked Questions: http://horde.org/faq/
> > > > To unsubscribe, mail: imp-unsubscribe@lists.horde.org
> > > >
> > >
> > >
> > >
> > > --
> > > IMP mailing list
> > > Frequently Asked Questions: http://horde.org/faq/
> > > To unsubscribe, mail: imp-unsubscribe@lists.horde.org
> >
> >
> 
>