Horde database problem

Aug.26, 2006 in Email Hosting

Hello,

If you are getting following error with the horde for the database then following the below steps :

Error :
A fatal error has occurred:
DB Error: connect failed
[line 108 of /usr/local/cpanel/base/horde/lib/Prefs/sql.php]
Details have been logged for the administrator.

=====================================================

Solution : First create a database file horde.sql as follows :

*******************************************************************

– MySQL dump 9.10
–
– Host: localhost Database: horde
– ——————————————————
– Server version 4.0.18-standard

–
– Table structure for table `horde_categories`
–

CREATE TABLE horde_categories (
category_id int(11) NOT NULL default ‘0′,
group_uid varchar(255) NOT NULL default ”,
user_uid varchar(255) default NULL,
category_name varchar(255) NOT NULL default ”,
category_data text,
category_serialized smallint(6) NOT NULL default ‘0′,
category_updated timestamp(14) NOT NULL,
PRIMARY KEY (category_id),
KEY category_category_name_idx (category_name),
KEY category_group_idx (group_uid),
KEY category_user_idx (user_uid),
KEY category_serialized_idx (category_serialized)
) TYPE=MyISAM;

–
– Dumping data for table `horde_categories`
–

–
– Table structure for table `horde_categories_categories`
–

CREATE TABLE horde_categories_categories (
category_id_parent int(11) NOT NULL default ‘0′,
category_id_child int(11) NOT NULL default ‘0′,
PRIMARY KEY (category_id_parent,category_id_child)
) TYPE=MyISAM;

–
– Dumping data for table `horde_categories_categories`
–

–
– Table structure for table `horde_prefs`
–

CREATE TABLE horde_prefs (
pref_uid varchar(255) NOT NULL default ”,
pref_scope varchar(16) NOT NULL default ”,
pref_name varchar(32) NOT NULL default ”,
pref_value text,
PRIMARY KEY (pref_uid,pref_scope,pref_name)
) TYPE=MyISAM;

–
– Dumping data for table `horde_prefs`
–
–
– Table structure for table `horde_users`
–

CREATE TABLE horde_users (
user_uid varchar(255) NOT NULL default ”,
user_pass varchar(32) NOT NULL default ”,
PRIMARY KEY (user_uid)
) TYPE=MyISAM;

–
– Table structure for table `kronolith_events`
–

CREATE TABLE kronolith_events (
event_id bigint(20) NOT NULL default ‘0′,
calendar_id varchar(255) NOT NULL default ”,
event_description text,
event_location text,
event_keywords text,
event_exceptions text,
event_title varchar(80) default NULL,
event_category varchar(80) default NULL,
event_recurtype varchar(11) default ‘0′,
event_recurinterval varchar(11) default NULL,
event_recurdays varchar(11) default NULL,
event_recurenddate datetime default NULL,
event_start datetime default NULL,
event_end datetime default NULL,
event_alarm int(11) default ‘0′,
event_modified int(11) NOT NULL default ‘0′,
PRIMARY KEY (event_id),
KEY kronolith_calendar_idx (calendar_id)
) TYPE=MyISAM;

–
– Dumping data for table `kronolith_events`
–
–
– Table structure for table `mnemo_memos`
–

CREATE TABLE mnemo_memos (
memo_owner varchar(255) NOT NULL default ”,
memo_id int(11) NOT NULL default ‘0′,
memo_desc varchar(64) NOT NULL default ”,
memo_body text,
memo_category int(11) NOT NULL default ‘0′,
memo_private smallint(6) NOT NULL default ‘1′,
memo_modified int(11) NOT NULL default ‘0′,
PRIMARY KEY (memo_owner,memo_id)
) TYPE=MyISAM;

–
– Table structure for table `nag_tasks`
–

CREATE TABLE nag_tasks (
task_owner varchar(255) NOT NULL default ”,
task_id int(11) NOT NULL default ‘0′,
task_name varchar(64) NOT NULL default ”,
task_desc text,
task_modified int(11) NOT NULL default ‘0′,
task_due int(11) default NULL,
task_priority int(11) NOT NULL default ‘0′,
task_category int(11) NOT NULL default ‘0′,
task_completed smallint(6) NOT NULL default ‘0′,
task_private smallint(6) NOT NULL default ‘1′,
PRIMARY KEY (task_owner,task_id)
) TYPE=MyISAM;

–
– Dumping data for table `nag_tasks`
–

CREATE TABLE turba_objects (
object_id varchar(32) NOT NULL default ”,
owner_id varchar(255) NOT NULL default ”,
object_type varchar(255) NOT NULL default ‘Object’,
object_members blob,
object_name varchar(255) default NULL,
object_alias varchar(32) default NULL,
object_email varchar(255) default NULL,
object_homeaddress varchar(255) default NULL,
object_workaddress varchar(255) default NULL,
object_homephone varchar(25) default NULL,
object_workphone varchar(25) default NULL,
object_cellphone varchar(25) default NULL,
object_fax varchar(25) default NULL,
object_title varchar(255) default NULL,
object_company varchar(255) default NULL,
object_notes text,
PRIMARY KEY (object_id),
KEY turba_owner_idx (owner_id)
) TYPE=MyISAM;