[horde] Login Problems - Base Horde Module

Tue Nov 25 23:19:28 PST 2003

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
>