Koozali.org: home of the SME Server

Horde 3.0/IMP upgrade now denying webmail login

JohnnyKH

Horde 3.0/IMP upgrade now denying webmail login
« on: July 19, 2005, 05:36:22 AM »
Okay folks, I'm thoroughly stumped as to how to fix this. After getting error messages which said the following:

I took a look through the /home/httpd/horde/ directories. I looked to be somehow suddenly missing the "kronolith" directories, and I decided to kill 2 birds with 1 stone and use the latest Horde 3.0 "sh" upgrade on my system. Beyond the messages stating those files already existed, it seemed to go just peachy.

Now, however, I cannot login to webmail. Or, for that matter, to the Horde Administration link now created on the SME box. The failure itself in the IMAP log is as follows, directly after trying to login itself:

2005-07-18 20:25:12.011184500 tcpserver: status: 1/260
2005-07-18 20:25:12.011380500 tcpserver: pid 1891 from 127.0.0.1
2005-07-18 20:25:12.026639500 tcpserver: ok 1891 localhost:127.0.0.1:143 :127.0.0.1::33866
2005-07-18 20:25:12.033710500 2005.07.19 03:25:12 LOG5[1891:1024]: Using 'imap' as tcpwrapper service name
2005-07-18 20:25:12.040494500 2005.07.19 03:25:12 LOG5[1891:1024]: stunnel 3.26 on i386-redhat-linux-gnu PTHREAD+LIBWRAP with OpenSSL 0.9.6b [engine] 9 Jul 2001
2005-07-18 20:25:12.041932500 imapfront-auth[1892]: * OK imapfront ready.
2005-07-18 20:25:12.042377500 2005.07.19 03:25:12 LOG5[1891:1024]: imap connected from 127.0.0.1:33866
2005-07-18 20:25:12.044256500 imapfront-auth[1892]: * CAPABILITY IMAP4rev1 SORT THREAD=REFERENCES MULTIAPPEND UNSELECT LITERAL+ IDLE CHILDREN LISTEXT LIST-SUBSCRIBED
2005-07-18 20:25:12.044339500 imapfront-auth[1892]: 00000000 OK CAPABILITY completed
2005-07-18 20:25:12.080084500 imapfront-auth[1892]: 00000001 NO LOGIN failed
2005-07-18 20:25:12.083160500 imapfront-auth[1892]: 00000002 NO LOGIN failed
2005-07-18 20:25:12.086172500 imapfront-auth[1892]: 00000003 NO LOGIN failed
2005-07-18 20:25:12.086577500 imapfront-auth[1892]: * Logging out
2005-07-18 20:25:12.086641500 imapfront-auth[1892]: 00000004 OK LOGOUT completed
2005-07-18 20:25:12.127262500 tcpserver: end 1891 status 0
2005-07-18 20:25:12.127406500 tcpserver: status: 0/260

I've searched through the forums for the way to edit the directory or SQL database, anything to fix it, and I came across a few threads stating to edit the /home/httpd/html/horde/config/horde.php file and update the SQL database password. And here's the kicker ... it's not there. What's more bizarre is that when I perform a "locate" for it, it says it IS there:

[root@heimdall install]# locate horde.php
/home/httpd/html/horde/config/horde.php.dist
/home/httpd/html/horde/config/horde.php
/home/httpd/html/horde/util/css2horde.php

I'm at a loss, and I'm hoping that those people experienced with the upgrade process might have a clue as to what's going on.

I really think this is a simple fix. I know that mail works, because POP3 is just fine. Its the webmail itself that seems to loop out when trying to login. I know it has to be there.

Offline NickR

  • *
  • 283
  • +0/-0
    • http://www.witzendcs.co.uk/
Horde 3.0/IMP upgrade now denying webmail login
« Reply #1 on: July 20, 2005, 09:48:07 AM »
It's not the old turba upgrade bug come to bite again is it?

This is my note for that one:
# This script will fix the 50turba_upgrade_1.1_to_1.2: DBI->connect(horde) failed: Access denied for user: 'horde@localhost' (Using password: YES) at /etc/e-smith/sql/init/50turba_upgrade_1.1_to_1.2 line 43
# problem - you need to be quick to see this as the screen clears immediately afterwards!


# /sbin/e-smith/config setprop horde DbPassword horde
# /sbin/e-smith/signal-event post-upgrade
# /sbin/e-smith/signal-event reboot
--
Nick......

JohnnyKH

Horde 3.0/IMP upgrade now denying webmail login
« Reply #2 on: July 20, 2005, 11:35:50 AM »
Hey, many thanks for a quick reply on this one.

To answer your question, that fix did not work. Used it exactly as you showed it and nothing happened. I am rather happy, though, that I could get back in after the reboot. I was worried that whatever I did might have messed something up worse, but as it stands now I just can't get into Webmail.

And the original message I got, which I neglected to put into my original post, was something like this:

"Unable to exectute file file /home/httpd/html/horde/kronolith/reminder.php"

And the whole directory was missing.

I've been reading-up in the forums for any sort of a fix, and finding a lot of people mentioning some way to change the horde DB password via phpMyAdmin (which I have) and then in some sort of config file. Still can't seem to find out exactly where each item is.

JohnnyKH

Horde 3.0/IMP upgrade now denying webmail login
« Reply #3 on: July 20, 2005, 11:41:12 AM »
Now the only messages I'm getting are:

In general "messages":

Jul 20 02:29:02 heimdall httpd: PHP Warning:  Unknown(): Unable to load dynamic library '/usr/lib/php4/curl.so' - /usr/lib/php4/curl.so: cannot open shared object file: No such file or directory in Unknown on line 0
Jul 20 02:29:02 heimdall httpd: PHP Warning:  Unknown(): Unable to load dynamic library '/usr/lib/php4/domxml.so' - /usr/lib/php4/domxml.so: cannot open shared object file: No such file or directory in Unknown on line 0
Jul 20 02:29:02 heimdall httpd: PHP Warning:  Unknown(): Unable to load dynamic library '/usr/lib/php4/mcrypt.so' - libmcrypt.so.4: cannot open shared object file: No such file or directory in Unknown on line 0
Jul 20 02:29:02 heimdall httpd: PHP Warning:  Unknown(): Unable to load dynamic library '/usr/lib/php4/mhash.so' - libmhash.so.2: cannot open shared object file: No such file or directory in Unknown on line 0
Jul 20 02:29:02 heimdall httpd: PHP Warning:  Unknown(): Unable to load dynamic library '/usr/lib/php4/mmcache.so' - /usr/lib/php4/mmcache.so: cannot open shared object file: No such file or directory in Unknown on line 0
Jul 20 02:29:02 heimdall httpd: PHP Warning:  Unknown(): Unable to load dynamic library '/usr/lib/php4/fileinfo.so' - libmagic.so.1: cannot open shared object file: No such file or directory in Unknown on line 0

And under the IMAP:

2005-07-20 02:26:12.348459500 tcpserver: status: 1/260
2005-07-20 02:26:12.348651500 tcpserver: pid 4205 from 127.0.0.1
2005-07-20 02:26:12.364733500 tcpserver: ok 4205 localhost:127.0.0.1:143 :127.0.0.1::32785
2005-07-20 02:26:12.371960500 2005.07.20 09:26:12 LOG5[4205:1024]: Using 'imap' as tcpwrapper service name
2005-07-20 02:26:12.387384500 imapfront-auth[4207]: * OK imapfront ready.
2005-07-20 02:26:12.459803500 2005.07.20 09:26:12 LOG5[4205:1024]: stunnel 3.26 on i386-redhat-linux-gnu PTHREAD+LIBWRAP with OpenSSL 0.9.6b [engine] 9 Jul 2001
2005-07-20 02:26:12.460201500 2005.07.20 09:26:12 LOG5[4205:1024]: imap connected from 127.0.0.1:32785
2005-07-20 02:26:12.461972500 imapfront-auth[4207]: * CAPABILITY IMAP4rev1 SORT THREAD=REFERENCES MULTIAPPEND UNSELECT LITERAL+ IDLE CHILDREN LISTEXT LIST-SUBSCRIBED
2005-07-20 02:26:12.462049500 imapfront-auth[4207]: 00000000 OK CAPABILITY completed
2005-07-20 02:26:12.518797500 imapfront-auth[4207]: 00000001 NO LOGIN failed
2005-07-20 02:26:12.522096500 imapfront-auth[4207]: 00000002 NO LOGIN failed
2005-07-20 02:26:12.525027500 imapfront-auth[4207]: 00000003 NO LOGIN failed
2005-07-20 02:26:12.525419500 imapfront-auth[4207]: * Logging out
2005-07-20 02:26:12.525482500 imapfront-auth[4207]: 00000004 OK LOGOUT completed
2005-07-20 02:26:12.550802500 tcpserver: end 4205 status 0
2005-07-20 02:26:12.550812500 tcpserver: status: 0/260

Something about the authentication, and possibly some missing components. Again, I yield to the greater experience of those other forum regulars here. I'm ready to be "schooled."

Offline NickR

  • *
  • 283
  • +0/-0
    • http://www.witzendcs.co.uk/
Horde 3.0/IMP upgrade now denying webmail login
« Reply #4 on: July 20, 2005, 12:32:16 PM »
OK, that looks like you don't have all the PHP 4 components that are needed.  Suggest you track down the latest PHP 4 .rpm's on here, install & see if things improve.

Did I understand you correctly that kronlith has gone AWOL? I think this is also someting you should be fixing as ISTR that horde gets huffy if it can't find what it thinks should be there.
--
Nick......

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Horde 3.0/IMP upgrade now denying webmail login
« Reply #5 on: July 24, 2005, 05:29:01 AM »
If your install already had php-4.3.10 installed, then the upgrade will not re-install php.  I only check for:
IS_PHP4310=pic rpmlist | grep -c php-4.3.10
but the rpm's used are:  php-4.3.10-3eo.i386.rpm, etc.  Maybe I'll change this to check for the 3eo versions and if they are not there, prompt the user to install them.  If you have php-4.3.11 or higher installed, I haven't tested this, but others seem to have it working with 4.3.11.  So, if you don't have a problem installing the above mentioned php version, then you should be able to install then, restart the e-smith-httpd process, check your log again for any errors.  

I do notice that it looks like you have turck mmcache installed.  The upgrade script installs phpaccelerator and this might conflict with turck.

Also, if Kronolith is really missing, you should be able to simply re-run the upgrade script and it should re-create the necessary directory structures.

Good Luck,

JB
......

JohnnyKH

Well now what?
« Reply #6 on: July 24, 2005, 08:05:38 PM »
Okay, so I disabled all of the file extensions that I was getting before, expanded the PHP.INI template, restarted Apache and now its just failing:

Jul 24 10:48:58 heimdall httpd: httpd shutdown succeeded
Jul 24 10:48:59 heimdall httpd: httpd startup succeeded
Jul 24 10:49:14 heimdall HORDE[20245]: [imp] FAILED LOGIN 67.189.117.182 to localhost:143[imap/notls] as jherrick [on line 247 of "/home/httpd/html/horde/imp/lib/Auth/imp.php"]

The line its referring to in "imp.php" is as follows, just the error message:

                Horde::logMessage($entry, __FILE__, __LINE__, PEAR_LOG_ERR);

And I am running PHP 4.3.11 on the SME:

[root@heimdall tmp]# php -v
PHP 4.3.11 (cli) (built: May 14 2005 21:13:11)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
    with the ionCube PHP Accelerator v1.3.3r2, Copyright (c) 2001-2002, by Nick Lindridge

Which, from all the posts I've read, means I'll probably have PHP problems but leaves me completely clueless as to why Horde keeps failing. There's no more PHP messages to worry about. I've even gone into the E-mail Settings page and made a change & saved, which stops and restarts all the services. POP/POPS, IMAP/IMAPS, and HTTP/HTTPS are all enabled - nobody's left out.

Sorry guys, I just don't know what's up. Does PHP 4.3.11 kill Horde 3.0? I've read many posts where people say both sides, so I'd like an expert's opinion.

If I should just go back down to PHP 4.3.10, how would I do it? I've searched the forums and nobody says how to remove the newer version/updates. To update, I used the "php4.3.11-upgrade.sh" upgrade script from "Ergozd", and trying to reverse-engineer the thing and make my own script it didn't seem to work. I didn't want to just remove everything without breaking something, so I'd like someone's opinion here as to how to remove the upgrades.

I'm a fish flopping out of the water here, please anybody ... help?

JohnnyKH

Horde 3.0/IMP upgrade now denying webmail login
« Reply #7 on: July 24, 2005, 08:13:01 PM »
By the way, the items I removed was MMCACHE and the extra file extensions for PHP:

50PathsDirectories75curl
50PathsDirectories75domxml
50PathsDirectories75mcrypt
50PathsDirectories75mhash

70DynamicExtension75curl
70DynamicExtension75domxml
70DynamicExtension75mcrypt
70DynamicExtension75mhash
70DynamicExtension75TurckMmcache

85FileInfo
90TurckMmCacheSettings

curl.so
domxml
fileinfo.so
mcrypt.so
mhash.so

The first time I ran the upgrade script (php4.3.11-upgrade.sh) I didn't look to comment these lines out. I then realized I needed to look through the script, and I commented-out, but this was foolish because they were already on. Removing them and rebuilding the PHP.INI template might have been good, but PHP 4.3.11 is still on. So I'm still a bit clueless.

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Horde 3.0/IMP upgrade now denying webmail login
« Reply #8 on: July 24, 2005, 09:53:18 PM »
So now the issue is with the pear modules.  Searching contribs.org for - php 4.3.11 horde - gives this info listed here:

http://forums.contribs.org/index.php?topic=26751.msg111287#msg111287

The install script does this:
pear install Log
pear install Date
pear install File
pear install Mail
pear ua
pear -d preferred_state=beta install -a Services_Weather

So, I think if you follow the tips on the link and the info from the install script, you may fix your issue.

JB
......

JohnnyKH

Horde 3.0/IMP upgrade now denying webmail login
« Reply #9 on: July 25, 2005, 01:56:08 AM »
No, the issue isn't with pear. The issue is that once Horde 3.0 was installed, Horde stopped working. No part of the login process works, as I've shown above.

Though I tried it before, I tried all the pear installs as shown:

[root@heimdall tmp]# pear install Log
Package 'Log' already installed, skipping
[root@heimdall tmp]# pear install Date
Package 'Date' already installed, skipping
[root@heimdall tmp]# pear install File
Package 'File' already installed, skipping
[root@heimdall tmp]# pear install Mail
Package 'Mail' already installed, skipping
[root@heimdall tmp]# pear ua
[root@heimdall tmp]# pear -d preferred_state=beta install -a Services_Weather
Package 'Services_Weather' already installed, skipping

I did a search for all the PHP files included once before, someone had the file list up here but I can't find that link. Something about "pear -show" or something.

In any case, I needed to get Horde working, so I tried rolling-back to Horde 2.0 using the included "horde20_restore.sh". Whoa', man, now I'm getting about a hundred lines like the first few you see here. And login is STILL failing:

Jul 24 16:48:27 heimdall HORDE[5800]: PHP Warning:  unpack(): Type N: not enough input, need 4, have 3 in /home/httpd/html/horde/lib/Cipher/blowfish.php on line 356
Jul 24 16:48:27 heimdall HORDE[5800]: PHP Warning:  unpack(): Type N: not enough input, need 4, have 3 in /home/httpd/html/horde/lib/Cipher/blowfish.php on line 356
Jul 24 16:48:27 heimdall HORDE[5800]: PHP Warning:  unpack(): Type N: not enough input, need 4, have 2 in /home/httpd/html/horde/lib/Cipher/blowfish.php on line 356
Jul 24 16:48:27 heimdall last message repeated 2 times
Jul 24 16:48:27 heimdall HORDE[5800]: [imp] FAILED LOGIN 67.189.117.182 to localhost:143[imap/notls] as jherrick [on line 282 of "/home/httpd/html/horde/imp/lib/IMP.php"]
Jul 24 16:48:27 heimdall HORDE[5800]: PHP Notice:  (null)(): LOGIN failed (errflg=1) in Unknown on line 0
Jul 24 16:48:27 heimdall last message repeated 2 times
Jul 24 16:48:27 heimdall HORDE[5800]: PHP Notice:  (null)(): Too many login failures (errflg=2) in Unknown on line 0
Jul 24 16:48:27 heimdall HORDE[5800]: PHP Notice:  (null)(): Unexpected untagged message: LOGGING (errflg=1) in Unknown on line 0

This is miserable. Why did I talk about pear, then PHP, with all this? Because after the fact I saw all the posts about PHP 4.3.11 causing problems, and I just wanted to find a script to remove PHP 4.3.11's upgrades and move back to 4.3.10.

So far Ergin's site (http://ergin.dyndns.org/webgui/) and here both don't have any reversal script or discussion as to which items are being put on, or how to remove them again. I just want to go back to 4.3.10 again and have my Horde & IMP work again.

I'm just begging, guys. That's all.

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Horde 3.0/IMP upgrade now denying webmail login
« Reply #10 on: July 25, 2005, 03:34:02 AM »
That's why it's recommended that you test it first, before putting it into production.  

I can assure you that the upgrade script works and the restore to horde_20 works.  I have used it many times and just have done it twice today just for piece of mind.

It also looks like whatever changes you made to horde or imp cont.php, probably imp, are incorrect as well.  When I log into webmail, this is my log:

Jul 24 20:21:45 MYSERVER HORDE[9822]: [imp] Login success for user1@thebennetthome2.com [10.10.10.103] to {localhost:143} [on line 150 of "/home/httpd/html/horde/imp/redirect.php"]

Notice I have no [imap/notls] mentioned.  

But, if you want to remove the php-4.3.11, then I suggest you do this:

rpm -qa | grep php, then when you see the output, do a rpm -e name_of_file to remove it.

I can't even tell you if that will fix the horde 2.0 stuff.  But, if you are certain you have all of the pear modules, then you could try running the most current version of the install script again and see what you get.

That's about all I can add.

JB
......

JohnnyKH

Horde 3.0/IMP upgrade now denying webmail login
« Reply #11 on: July 25, 2005, 04:41:06 PM »
If someone wouldn't mind doing the pear command and listing which pear modules they have that allow Horde 2.0 and 3.0 to work, I'd be darn happy.

mrjhb3, thanks again for being willing to think outside your box and suggest things. Still a newbie and really would like to keep this up and running. SME forums are much nicer than many other ones.

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Horde 3.0/IMP upgrade now denying webmail login
« Reply #12 on: July 25, 2005, 05:25:21 PM »
Quote from: "JohnnyKH"
If someone wouldn't mind doing the pear command and listing which pear modules they have that allow Horde 2.0 and 3.0 to work, I'd be darn happy.

mrjhb3, thanks again for being willing to think outside your box and suggest things. Still a newbie and really would like to keep this up and running. SME forums are much nicer than many other ones.


There are no pear modules needed for horde 2.0. Here is my pear list:


[root@test65 root]# pear list
Installed packages:
===================
Package          Version  State
Archive_Tar      1.3.1    stable
Cache            1.5.5RC3 beta
Console_Getopt   1.2      stable
DB               1.7.6    stable
Date             1.4.3    stable
File             1.2.0    stable
HTTP             1.3.6    stable
HTTP_Request     1.2.4    stable
Log              1.8.7    stable
Mail             1.1.6    stable
Net_SMTP         1.2.6    stable
Net_Socket       1.0.6    stable
Net_URL          1.0.14   stable
PEAR             1.3.5    stable
SOAP             0.9.1    beta
Services_Weather 1.3.2    stable
XML_Parser       1.2.6    stable
XML_RPC          1.3.3    stable
XML_Serializer   0.16.0   beta
XML_Util         1.1.1    stable
......

JohnnyKH

Horde 3.0/IMP upgrade now denying webmail login
« Reply #13 on: July 26, 2005, 05:42:33 AM »
Question:

Now that I've done my Horde rollback, my SME's getting cron daemon mails every 5 minutes stating this:

Could not open input file: /home/httpd/html/horde/kronolith/scripts/reminders.php

Thanks, man, for the listing. I'll try to make some sense of this. I know what I need to do, I'll just have to see how to do it. The whole "pear ua" and then the pear installs doesn't help, as I don't know how to get the software to install things that are shown as "beta" at all. I've tried the "-d" type commands but then I get the "phpize failure" messages. And that leads to a whole bunch of other things, all the way to people discussing the need to go back to PHP 4.3.9.

<sigh> Never should have upgraded.

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Horde 3.0/IMP upgrade now denying webmail login
« Reply #14 on: July 26, 2005, 06:08:52 AM »
Quote from: "JohnnyKH"
Question:

Now that I've done my Horde rollback, my SME's getting cron daemon mails every 5 minutes stating this:

Could not open input file: /home/httpd/html/horde/kronolith/scripts/reminders.php.


To remove the old horde reminders cronjob, remove
/etc/e-smith/templates-custom/etc/crontab/80HordeReminders then do a /sbin/e-smith/expand-template /etc/crontab, then do
/etc/rc.d/rc7.d/S40crond restart
You should now stop getting those emails.

Quote from: "JohnnyKH"

Thanks, man, for the listing. I'll try to make some sense of this. I know what I need to do, I'll just have to see how to do it. The whole "pear ua" and then the pear installs doesn't help, as I don't know how to get the software to install things that are shown as "beta" at all. I've tried the "-d" type commands but then I get the "phpize failure" messages. And that leads to a whole bunch of other things, all the way to people discussing the need to go back to PHP 4.3.9.

<sigh> Never should have upgraded.


You will need to make sure that the devrpm's are installed then do your pear magic, then remove the devrpm's.  If you have a copy of the script, you should be able to find the section where I start installing the pear modules, then the last thing it does is remove the devrpms.

Did you get your webmail functioning?

JB
......