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;
–
– Dumping data for table `turba_objects`
–
*******************************************************************
Then use the following commands :
mysql horde create database horde;
3) mysql>\q
/scripts/fullhordereset
—————————————
Fatal error: Call to undefined function: _() in /usr/local/cpanel/base/horde/config/registry.php on line 86
If you get this error while entering into horde , following is the fix:
touch /var/cpanel/usecpphp
OR
rm -f /usr/local/cpanel/cpanel;
/scripts/upcp
———————————————–
Also touch /var/cpanel/usecpphp is solution for error –
“Notice: Undefined index: direct_access in
/usr/local/cpanel/base/horde/imp/templates/menu/menu.inc on line 53″
