Getting Horde to work after ART PHP upgrade

mary · Unread post by **mary** » Fri Jul 14, 2006 1:49 pm

Hello folks -- I have found these forums full of useful advice over the past couple of years, and for the first time, have not been able to find the solution to the problem I face.

I upgraded yesterday to Scott's new version of PHP following the instructions at http://www.atomicrocketturtle.com/Jooml ... ew/141/29/ for my FC3/Plesk 7.5.4 server. After restarting the various services, Horde evidently died immediately. It was not until this morning that the, for lack of a better term, hordes caught up with me voicing their complaints. The psa-horde log contains no entries from after the upgrade.

Do I need to grab a new php-pear package? If so, any suggestions as to which one? Failing that, is there a reasonable way to roll back to PHP 4.4? The problems with lack of Horde access to QMail outweigh the benefits of the new PHP version.

Thanks!

Unread post by **scott** » Fri Jul 14, 2006 3:28 pm

Can you be more specific? Internally Horde is just a PHP front end to IMAP. The main components it depends on are php-imap, courier-imap, and php-pear. A failure in any one of those can cause horde to not work, the manner in which it breaks would narrow it down to the specific component.

mary · Unread post by **mary** » Thu Jul 27, 2006 12:13 pm

Scott,

Thanks for the pointers. I poked further into what was going on, but remain stumped. I tried uninstalling and then reinstalling psa-horde. This gave the following messages:

Code: Select all

Running Transaction
Installing: psa-horde 100 % done 1/1
ERROR 1146 (42S02) at line 11: Table 'horde.horde_prefs' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'horde.horde_prefs' doesn't exist

Installed: psa-horde.noarch 0:3.0.5-fc3.build75050824.12
Complete!

The symptoms are:

The URL webmail.domain.com no longer redirects to the Horde login. Instead it points to the TLD of the domain.
As a result of the above, none of the Horde pages are accessible.
Following advice from the Plesk forums, I ran /usr/local/psa/admin/bin/websrvmng -a to reset httpd.include. Restarted Apache; no go.

Thanks!
Mary

Unread post by **scott** » Thu Jul 27, 2006 4:43 pm

Looks like your horde database is missing tables. You'll want to talk to sw-soft support about that

mary · Unread post by **mary** » Thu Jul 27, 2006 8:24 pm

So far, sw-soft hasn't a clue. The strange thing is that Horde was functional less than 10 minutes before the yum update that loaded PHP 5, and it was dead less than 5 minutes later.

Unread post by **scott** » Thu Jul 27, 2006 10:52 pm

no rpm update I can think of would cause those to tables to get deleted. Maybe you've got some drives going bad?

mary · Unread post by **mary** » Tue Aug 01, 2006 4:04 pm

For anyone stumbling across this thread in the future: problem solved. Installing Plesk 8.0.1 fixed Horde access.