Horde is broken, won't connect ot database!!!

That won't work on the horde_sessionhandler table since it's of type InnoDB, which doesn't support repair. One can try CHECK TABLE horde_sessionhandler, but the sureset option is to drop the table and recreate it:

> drop table horde_sessionhandler;
> CREATE TABLE horde_sessionhandler (
session_id VARCHAR(32) NOT NULL,
session_lastmodified INT NOT NULL,
session_data LONGBLOB,
PRIMARY KEY (session_id)
) ENGINE = InnoDB;

 

I'm glad you got it working. For future reference, here are some steps that will either fix the problem, or provide more clues:

• Check that the horde_sessionhandler is not corrupted. If it is, the drop and create statements I posted above will resolve this particular issue.
• Verify the horde user has proper permissions on the horde_sessionhandler table. Specifically it should have select, insert, update and delete permissions. If not, then grant them:
  
  Code:

  > GRANT SELECT, INSERT, UPDATE, DELETE ON horde_sessionhandler TO [email protected];
  > FLUSH PRIVILEGES;
  

• Enable logging in Horde. Edit the file /usr/local/cpanel/base/horde/config/conf.php:
  
  Code:

  // change
   $conf['log']['enabled'] = false;
  
  // to
  $conf['log']['enabled'] = true;
  
  // change 
  $conf['log']['priority'] = PEAR_LOG_WARN;
  
  // to
  $conf['log']['priority'] = PEAR_LOG_DEBUG;
  

  Try logging into Horde, then check the file created in /tmp. It will be named some thing like horde_123445.log
  
  
• You can also enable MySQL error logging on the off chance something appears there. Edit /etc/my.cnf to contain:
  
  Code:

  log-error=/var/log/mysql.log
  

  You can place the log whereever you want (some opt for /var/lib/mysql/mysql.log)