[horde] Login Problems - Base Horde Module

Ahmed El-Daly daly1 at hotmail.com
Thu Nov 27 05:20:08 PST 2003 

After running home thinking that this is definetely the solution, I was only 
disappointed by the result. With so many people that have installed this, 
there must be a few that have encountered this and solved it. Guys what have 
you done to make this work?

Here is my /var/www/html/lib/auth/sql.php file:

<?php
/*
* $Horde: horde/lib/Auth/sql.php,v 1.21.2.7 2003/02/18 00:33:02 jan Exp $
*/

$conf['sql']['phptype'] = 'mysql';
$conf['sql']['hostspec'] = 'localhost';
$conf['sql']['protocol'] = 'unix';
$conf['sql']['username'] = 'horde';
$conf['sql']['password'] = '';
$conf['sql']['database'] = 'HORDE_DB';

==============SNIP=============================
==== Did not change anything below this line =================
?>


>From: Mike Bydalek <mbydalek at zivix.com>
>To: horde at lists.horde.org
>Subject: RE: [horde] Login Problems - Base Horde Module
>Date: Wed, 26 Nov 2003 00:19:28 -0700
>
>This is the section you need to be concerned about:
>
>$conf['sql']['phptype'] = 'mysql';
>
>// Request persistent connections?
>$conf['sql']['persistent'] = false;
>
>// What protocol will we use to connect to the database.  The default
>// is tcp, but if you wish to use UNIX sockets, change it to 'unix'.
>$conf['sql']['protocol'] = 'tcp';
>
>// If you are using UNIX sockets, you may need to specify the socket's
>// location.
>// $conf['sql']['socket'] = '/var/lib/mysql/mysql.sock';
>
>// What port is the database server running on? Not required for all
>// databases.
>// $conf['sql']['port'] = 5432;
>
>// What hostname is the database server running on, or what is the
>// name of the system DSN to use?
>$conf['sql']['hostspec'] = 'localhost';
>
>// What username do we authenticate to the database server as?
>$conf['sql']['username'] = 'MY_USER';
>
>// What password do we authenticate to the database server with?
>$conf['sql']['password'] = 'MY_USER_PASS';
>
>// What database name/tablespace are we using?
>$conf['sql']['database'] = 'HORDE_DB';
>
>// What charset does the database use internally?
>$conf['sql']['charset'] = 'iso-8859-1';
>
>Make sure those are all setup correctly and that you're not using sockets 
>when
>you mean tcp, and vice-versa.  Also, log in to mysql with the user horde is 
>to
>see if it's a privilege problem.
>
>What does the log say?  Anything useful?  Try a different authentication 
>method
>to rule out Horde or mySQL, like ftp.  Then just use an FTP login/password. 
>  If
>it works, mysql is borked.  If it still doesn't work, then it could be a 
>Horde
>problem.
>
>-Mike
>
>Quoting Ahmed El-Daly <daly1 at hotmail.com>:
>
> > I opened port 3306 on the firewall and now can issue telnet 
>webserver.com
> > 3306 and I get this:
> >
> > (
> >  3.23.58
> >         BDlv,s!G?o
> >
> > Seems that it is connecting to something. I do not know how to issue 
>commands
> > in this telnet session. Is that what you meant by connecting via tcp
> > connection?
> >
> > -----Original Message-----
> > From: Andrew Morgan [mailto:morgan at orst.edu]
> > Sent: November 25, 2003 12:57
> > To: Ahmed El-Daly
> > Cc: bashar at dhakacom.com; horde at lists.horde.org
> > Subject: Re: [horde] Login Problems - Base Horde Module
> >
> >
> > Have you tried connecting to mysql by hand, using the same username and
> > password as defined in Horde?  Make sure you are connecting over the tcp
> > port to localhost, as you have defined in your horde.php file.  Perhaps
> > you haven't configured mysql to listen on a tcp port, only the standard
> > unix socket?
> >
> > 	Andy
> >
> > On Tue, 25 Nov 2003, Ahmed El-Daly wrote:
> >
> > > Thank you very much for replying so quickly. The test.php results are 
>all
> > > ok. What i find in the horde log file is access denied for the mySQL
> > > database. I did read about md5 encryption issue, so I set the password 
>to
> > > blank for testing, but the error still persists.
> > >
> > >
> > > >From: "Bashar" <bashar at dhakacom.com>
> > > >Reply-To: "Bashar" <bashar at dhakacom.com>
> > > >To: "Ahmed El-Daly" <daly1 at hotmail.com>
> > > >Subject: Re: [horde] Login Problems - Base Horde Module
> > > >Date: Tue, 25 Nov 2003 19:28:57 +0800
> > > >
> > > >Do you have MySQL Support for PHP? See your test.php file and check 
>it
> > out.
> > > >
> > > >PHP Module Capabilities
> > > >   a.. Ctype Support: Yes
> > > >   b.. DOM XML Support: Yes
> > > >   c.. FTP Support: Yes
> > > >   d.. Gettext Support: Yes
> > > >   e.. Iconv Support: Yes
> > > >   f.. IMAP Support: Yes
> > > >   g.. LDAP Support: Yes
> > > >   h.. Mbstring Support: Yes
> > > >   i.. MCAL Support: No
> > > >   j.. Mcrypt Support: No
> > > >   k.. MIME Magic Support: Yes
> > > >   l.. MySQL Support: Yes
> > > >   m.. OpenSSL Support: No
> > > >   n.. PostgreSQL Support: Yes
> > > >   o.. XML Support: Yes
> > > >----- Original Message -----
> > > >From: "Ahmed El-Daly" <daly1 at hotmail.com>
> > > >To: <horde at lists.horde.org>
> > > >Sent: Tuesday, November 25, 2003 4:23 PM
> > > >Subject: [horde] Login Problems - Base Horde Module
> > > >
> > > >
> > > > > Hi,
> > > > >
> > > > >
> > > > >
> > > > > I am writing this email after spending 2 12 hour days trying to 
>make
> > > > > this work. I am having a problem which I see many people seem to 
>have
> > > > > had, but none of the solutions worked for me. Whenever I try 
>logging
> > in,
> > > > > I come back to the login sreen.
> > > > >
> > > > >
> > > > >
> > > > > I am running mySQL and I have included my horde.php file here. I 
>read a
> > > > > post about problems with mySQL and md5 encypted passwords, so I 
>set the
> > > > > password for horde to blank.
> > > > >
> > > > >
> > > > >
> > > > > Any help would be very appreciated.
> > > > >
> > > > >
> > > > >
> > > > > <?php
> > > > >
> > > > > /*
> > > > >
> > > > >  * $Horde: horde/config/horde.php.dist,v 1.47.2.33 2003/05/19 
>17:56:12
> > > > > slusarz Exp $
> > > > >
> > > > >  */
> > > > >
> > > > >
> > > > >
> > > > > $conf['debug_level'] = E_ALL;
> > > > >
> > > > > $conf['max_exec_time'] = 0;
> > > > >
> > > > > $conf['session_name'] = 'Horde';
> > > > >
> > > > > $conf['cache_limiter'] = 'nocache';
> > > > >
> > > > > $conf['session_timeout'] = 0;
> > > > >
> > > > > $conf['use_ssl'] = 2;
> > > > >
> > > > > $conf['compress_pages'] = true;
> > > > >
> > > > > $conf['umask'] = 077;
> > > > >
> > > > > $conf['tmpdir'] = null;
> > > > >
> > > > > $conf['auth']['driver'] = 'sql';
> > > > >
> > > > > $conf['auth']['params'] = array();
> > > > >
> > > > > $conf['auth']['params']['phptype'] = 'mysql';
> > > > >
> > > > > $conf['auth']['params']['hostspec'] = 'localhost';
> > > > >
> > > > > $conf['auth']['params']['username'] = 'horde';
> > > > >
> > > > > $conf['auth']['params']['password'] = '';
> > > > >
> > > > > $conf['auth']['params']['database'] = 'horde';
> > > > >
> > > > > $conf['auth']['params']['table'] = 'horde_users';
> > > > >
> > > > >
> > > > >
> > > > > $conf['log']['enabled'] = true;
> > > > >
> > > > > $conf['log']['type'] = 'file';
> > > > >
> > > > > $conf['log']['name'] = '/tmp/horde.log';
> > > > >
> > > > > $conf['log']['priority'] = LOG_NOTICE;
> > > > >
> > > > > $conf['log']['ident'] = 'HORDE';
> > > > >
> > > > > $conf['log']['params'] = array();
> > > > >
> > > > > $conf['prefs']['driver'] = 'none';
> > > > >
> > > > > $conf['prefs']['params'] = array();
> > > > >
> > > > > $conf['cache']['driver'] = 'none';
> > > > >
> > > > > $conf['cache']['params'] = array();
> > > > >
> > > > > $conf['mailer']['type'] = 'sendmail';
> > > > >
> > > > > $conf['mailer']['params'] = array();
> > > > >
> > > > > $conf['vfs']['type'] = 'file';
> > > > >
> > > > > $conf['vfs']['params']['vfsroot'] = '/tmp';
> > > > >
> > > > > $conf['sessionhandler']['type'] = 'none';
> > > > >
> > > > > $conf['problems']['enabled'] = false;
> > > > >
> > > > > $conf['problems']['email'] = 'webmaster at example.com';
> > > > >
> > > > > $conf['user']['online_help'] = true;
> > > > >
> > > > > $conf['css']['cached'] = true;
> > > > >
> > > > > $conf['menu']['floating_bar'] = false;
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > Horde mailing list
> > > > > Frequently Asked Questions: http://horde.org/faq/
> > > > > To unsubscribe, mail: horde-unsubscribe at lists.horde.org
> > >
> > > _________________________________________________________________
> > > MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
> > > http://join.msn.com/?page=features/virus
> > >
> > >
> > > --
> > > Horde mailing list
> > > Frequently Asked Questions: http://horde.org/faq/
> > > To unsubscribe, mail: horde-unsubscribe at lists.horde.org
> > >
> >
> >
> > --
> > Horde mailing list
> > Frequently Asked Questions: http://horde.org/faq/
> > To unsubscribe, mail: horde-unsubscribe at lists.horde.org
> >
>
>--
>Horde mailing list
>Frequently Asked Questions: http://horde.org/faq/
>To unsubscribe, mail: horde-unsubscribe at lists.horde.org

_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail

More information about the horde mailing list