Horde Broken?

[deeplist]

I don't know if anybody else is having similar issues. I upgraded and everything functions fine except for Horde. The mail server is still working because I can retreive my mail via IMAP using a different service, but Horde doesnt want to validate anymore. I know it will only be a matter of time before people start complaining. Any suggestions or solutions at this point?

 

[deeplist]

Well, this has been a really disappointing evening. My clients are upset because they can't log into their Horde accounts to check their mail.

Could somebody point me in a direction of what to check or look for? I would really like to get this mail issue resolved as soon as possible. I really regret updating Plesk at this time.

 

[deeplist]

okay, well could somebody post their conf.php file from:

/etc/psa-horde/horde/

 

[105547111]

<?php
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: horde/config/conf.xml,v 1.74.2.41 2006/08/04 17:13:25 jan Exp $
/**
* Plesk predefined configuration for Horde3
**/

$conf['debug_level'] = E_ERROR;
$conf['max_exec_time'] = 0;
$conf['use_ssl'] = 2;
$conf['server']['name'] = $_SERVER['SERVER_NAME'];
$conf['server']['port'] = $_SERVER['SERVER_PORT'];
$conf['compress_pages'] = true;
$conf['umask'] = 077;
$conf['session']['name'] = 'Horde3';
$conf['session']['cache_limiter'] = 'nocache';
$conf['session']['timeout'] = 0;
$conf['cookie']['domain'] = $_SERVER['SERVER_NAME'];
$conf['cookie']['path'] = '/';
$conf['sql']['persistent'] = false;
$conf['sql']['hostspec'] = 'localhost';
$conf['sql']['username'] = 'horde';
$conf['sql']['socket'] = '/var/lib/mysql/mysql.sock';
$conf['sql']['protocol'] = 'unix';
$conf['sql']['database'] = 'horde';

// get password from /etc/psa/.webmail.shadow
if (!($fd = fopen("/etc/psa/.webmail.shadow", "r"))) {
echo "<script>alert('Unable to get webmail password!')</script>";
exit();
}
fscanf($fd, "%s", $buff);
fclose($fd);

$conf['sql']['password'] = preg_replace("/\n/", "", $buff);
$conf['sql']['charset'] = 'utf8';
$conf['sql']['phptype'] = 'mysql';
$conf['auth']['admins'] = array();
$conf['auth']['checkip'] = true;
$conf['auth']['checkbrowser'] = true;
$conf['auth']['alternate_login'] = false;
$conf['auth']['redirect_on_logout'] = false;

$conf['auth']['driver'] = 'composite';
$conf['auth']['params']['drivers'] = array(
'imp' => array('driver' => 'application',
'params' => array('app' => 'imp')),
'mimp' => array('driver' => 'application',
'params' => array('app' => 'mimp')));

$conf['auth']['params']['loginscreen_switch'] = '_horde_select_loginscreen';
if (!function_exists('_horde_select_loginscreen')) {
function _horde_select_loginscreen()
{
@define(HORDE_BASE,'/usr/share/psa-horde');
require_once HORDE_BASE . '/lib/Horde/Browser.php';
$browser = new Browser();
if ($browser->isMobile() && $GLOBALS['registry']->applications['mimp']){
return 'mimp';
}
return 'imp';
}
}

$conf['signup']['allow'] = false;
$conf['log']['priority'] = PEAR_LOG_ERR;
$conf['log']['ident'] = 'HORDE';
$conf['log']['params'] = array();
$conf['log']['name'] = '/var/log/psa-horde/psa-horde.log';
$conf['log']['params']['append'] = true;
$conf['log']['type'] = 'file';
$conf['log']['enabled'] = true;
$conf['log_accesskeys'] = false;
$conf['prefs']['params']['driverconfig'] = 'horde';
$conf['prefs']['driver'] = 'sql';
$conf['datatree']['params']['driverconfig'] = 'horde';
$conf['datatree']['driver'] = 'sql';
$conf['group']['driver'] = 'datatree';
$conf['cache']['default_lifetime'] = 1800;
$conf['cache']['params']['dir'] = Horde::getTempDir();
$conf['cache']['params']['gc'] = 86400;
$conf['cache']['driver'] = 'file';
$conf['mailer']['params']['host'] = 'localhost';
$conf['mailer']['params']['auth'] = '0';
$conf['mailer']['type'] = 'smtp';
$conf['vfs']['params']['vfsroot'] = '/tmp';
$conf['vfs']['type'] = 'file';
$conf['sessionhandler']['type'] = 'none';
$conf['mime']['magic_db'] = ' /usr/share/misc/magic';
$conf['problems']['email'] = 'webmaster@example.com';
$conf['problems']['maildomain'] = 'example.com';
$conf['problems']['tickets'] = false;
$conf['menu']['apps'] = array();
$conf['menu']['always'] = false;
$conf['menu']['links']['help'] = 'all';
$conf['menu']['links']['help_about'] = true;
$conf['menu']['links']['options'] = 'authenticated';
$conf['menu']['links']['problem'] = 'never';
$conf['menu']['links']['login'] = 'all';
$conf['menu']['links']['logout'] = 'authenticated';
$conf['hooks']['permsdenied'] = false;
$conf['hooks']['username'] = false;
$conf['hooks']['preauthenticate'] = false;
$conf['hooks']['postauthenticate'] = false;
$conf['hooks']['authldap'] = false;
$conf['portal']['fixed_blocks'] = array();
$conf['accounts']['driver'] = 'null';
$conf['imsp']['enabled'] = false;
$conf['kolab']['enabled'] = false;
$conf['token']['params']['driverconfig'] = 'horde';
$conf['token']['driver'] = 'sql';
$conf['css']['cached'] = true;
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */

 

[deeplist]

Okay, I tried resetting all my values in the config file back to the defaults from the post you made and it didn't do any good. However, I do appreciate you posting that. Thank you.

 

[105547111]

Sorry to hear that

Damn this Plesk 8.1 got more holes in it than a bullseye target at a shooting range!

 

[Cancel]

What error shows Horde webpage?

 

[deeplist]

At the time it showed nothing it would attempt to log in and then after a while it would return and say "login failed" and that is as far as it would go.

We did manage to find out that the cause was an IMAP misconfiguration. After IMAP was configured correctly, the problem with Horde was resolved instantly.

Just a heads up in case somebody else may be having the same problem.

 

[by88]

Same problem here with plesk 8.1 + php5 + mysql5.

All is working fine but horde does not authenticate users.

What was the IMAP misconfiguration you have found?

Thank You in advance for you help.

 

[deeplist]

Well, I had my server tech fix the issue because I was tired of messing with it. You can email him here: sam@activelobby.net

His rate is $15 per hour and I guarantee that he can resolve your issues in no time.

Also, how well is php5 and mysql5 working out on your plesk box? I was affraid to upgrade my php and mysql for fear that it would cause plesk to break.

 

[blutkind]

This is NOT an IMAP issue AT ALL.. That's kind of bs from your dev. It's a SIMPLE fix. SSH into your server or go into windows, whatever it may be, find your dandy way to C:\WINDOWS\php.ini or /etc/php.ini find the line session.auto_start = 1 change that 1 to a 0 restart apache, have a good day webmail should work.

 

[jbrouhard]

I'm having the exact same problem as I've posted in another thread.

I checked my php.ini, but session.auto_start = 0 is already set and i cannot log in using webmail.

I could almost guarantee this has to do with either IMAP or it's Horde itself.

 

[blutkind]

Post back some portions of /usr/local/psa/var/log/maillog it should show "LOGIN ...." paste about 10-15 lines of that here i'll take a look.

 

[jbrouhard]

please note that the timer on the server is a little off. Approximately 3pm my time (1500 on the server) i started using the Thunderbird mail client.

Dec 14 14:25:08 adama pop3d: Connection, ip=[207.192.193.222]
Dec 14 14:25:09 adama pop3d: IMAP connect from @ [207.192.193.222]INFO: LOGIN, u ser=jbrouhard, ip=[207.192.193.222]
Dec 14 14:33:17 adama pop3d:
Dec 14 14:33:18 adama pop3d: IMAP connect from @ [207.192.193.222]INFO: LOGIN, u ser=jbrouhard, ip=[207.192.193.222]
Dec 14 14:33:56 adama pop3d:
Dec 14 14:33:57 adama pop3d: IMAP connect from @ [207.192.193.222]INFO: LOGIN, u ser=jbrouhard, ip=[207.192.193.222]
Dec 14 14:43:56 adama pop3d:
Dec 14 14:43:57 adama pop3d: IMAP connect from @ [207.192.193.222]INFO: LOGIN, u ser=jbrouhard, ip=[207.192.193.222]
Dec 14 14:45:12 adama pop3d:
Dec 14 14:45:13 adama pop3d: IMAP connect from @ [207.192.193.222]INFO: LOGIN, u ser=jbrouhard, ip=[207.192.193.222]
Dec 14 14:47:47 adama relaylock: /var/qmail/bin/relaylock: mail from 207.192.193 .222:1339 (cm-207-192-193-222.stjoseph.mo.npgco.com)
Dec 14 14:48:06 adama qmail: 1166129286.395397 new msg 836161
Dec 14 14:48:06 adama qmail: 1166129286.395506 info msg 836161: bytes 664 from < jbrouhard@proximanetworks.com> qp 2491 uid 2020
Dec 14 14:48:06 adama qmail: 1166129286.409410 starting delivery 2: msg 836161 t o remote jbrouhard@chansata.com
Dec 14 14:48:06 adama qmail: 1166129286.409721 status: local 0/10 remote 1/20
Dec 14 14:48:09 adama pop3d:
Dec 14 14:48:10 adama pop3d: IMAP connect from @ [207.192.193.222]INFO: LOGIN, u ser=jbrouhard, ip=[207.192.193.222]
Dec 14 14:48:12 adama qmail: 1166129292.085756 delivery 2: success: 66.235.220.2 44_accepted_message./Remote_host_said:_250_OK_id=1GuxU4-0005Pv-Ht/
Dec 14 14:48:12 adama qmail: 1166129292.085864 status: local 0/10 remote 0/20
Dec 14 14:48:12 adama qmail: 1166129292.085905 end msg 836161
Dec 14 14:48:22 adama pop3d:
Dec 14 14:48:23 adama pop3d: IMAP connect from @ [207.192.193.222]INFO: LOGIN, u ser=jbrouhard, ip=[207.192.193.222]
Dec 14 14:53:35 adama relaylock: /var/qmail/bin/relaylock: mail from 69.64.46.29 :56711 (plesk.com)
Dec 14 14:53:57 adama pop3d:
Dec 14 14:54:00 adama pop3d: IMAP connect from @ [207.192.193.222]INFO: LOGIN, u ser=jbrouhard, ip=[207.192.193.222]
Dec 14 14:55:35 adama qmail: 1166129735.290529 new msg 836163
Dec 14 14:55:35 adama qmail: 1166129735.290640 info msg 836163: bytes 1226 from <anonymous@plesk.com> qp 2520 uid 2020
Dec 14 14:55:35 adama qmail: 1166129735.304540 starting delivery 3: msg 836163 t o local 1-jbrouhard@proximanetworks.com
Dec 14 14:55:35 adama qmail: 1166129735.304871 status: local 1/10 remote 0/20
Dec 14 14:55:35 adama qmail: 1166129735.326828 delivery 3: success: did_1+0+1/
Dec 14 14:55:35 adama qmail: 1166129735.326942 status: local 0/10 remote 0/20
Dec 14 14:55:35 adama qmail: 1166129735.326982 end msg 836163
Dec 14 15:03:56 adama pop3d:
Dec 14 15:03:57 adama pop3d: IMAP connect from @ [207.192.193.222]INFO: LOGIN, u ser=jbrouhard, ip=[207.192.193.222]
Dec 14 15:13:56 adama pop3d:
Dec 14 15:13:57 adama pop3d: IMAP connect from @ [207.192.193.222]INFO: LOGIN, u ser=jbrouhard, ip=[207.192.193.222]
Dec 14 15:23:57 adama pop3d:
Dec 14 15:23:57 adama pop3d: IMAP connect from @ [207.192.193.222]INFO: LOGIN, u ser=jbrouhard, ip=[207.192.193.222]

 

[deeplist]

It is in fact an imap issue. My php.ini variables were already set correctly. At first I figured horde's sessions were messed up, but it wasn't with Horde at all. IMAP was reconfigured and boom, problem solved.

 

[Mathi]

hello,

checking the /etc/hosts file of the following entries

localhost localhost.domain


that was missing in my file (/etc/hosts)

Mathi

 

[jbrouhard]

Originally posted by Mathi
hello,

checking the /etc/hosts file of the following entries

localhost localhost.domain


that was missing in my file (/etc/hosts)

Mathi

Well, i'll be damned. *THAT* was the problem.

Many thanks!

 

[digiter]

Hello.

I've the etc/host correctly configured
127.0.0.1 name1 name2
local_IP name2 name3

but the Horde doesn't autenticate the user before a patch that i made to the imap configuration related to Horde.

i've changed in file
/usr/share/psa-horde/imp/config/server.php

the line

'server' =>'localhost',

with

'server' => 'the_IP_Addres_of_my_Server',

and now the problem is fixed!

I can access at my webmail using

webmail.domainnane.domainext

 

[rviradia]

Thanks, you saved me alot of time and the wait of a swsoft ticket, but 8.1 has given me many problems in general on the 4 clients who wanted to be early adopters, now if someone asks I tell them to wait since it's too buggy!

To help someone with the same problem, I'm including my psa-horde.log so when someone searches for it they find it;

HORDE [error] [imp] FAILED LOGIN xx.xxx.xxx.xxx to localhost:143[imap/notls] as test@xxxxxxxx.com [on line 258 of "/usr/share/psa-horde/imp/lib/Auth/imp.php"]

Originally posted by Mathi
hello,

checking the /etc/hosts file of the following entries

localhost localhost.domain


that was missing in my file (/etc/hosts)

Mathi

 

[jbrouhard]

For security purposes, I've heard of removing the Localhost line is a decent concept, but you need to point 127.0.0.1 to localhost for some very specific apps to work.

IMHO, anytime you do a fresh install or a upgrade, double-check the /etc/hosts file from now on and be sure it exists. if not, then there's a problem