[horde] fatal error in horde conection to a db
Enrique Llanos V.
ellanosv at gmail.com
Thu Jan 12 07:54:01 PST 2006
Hi dudes, i have installed horde in a testing server a few days ago
and it all went ok, now that i have installed it on a non testing
server i had this error[0] twice. i can't find the error itself so i
would really appreciate any assistance from your side in order to get
this intallation to work, lots of thanks in advance.
(i apologize in advance for the huge mail)
My installation is on a FreeBSD 5.3-RELEASE-p23 (up to date)
mysql-client-4.1.16 Multithreaded SQL database (client)
mysql-server-4.1.16 Multithreaded SQL database (server)
-------------------------------------
horde/config/conf.php
<?php
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: horde/config/conf.xml,v 1.74.2.14 2005/08/23 17:14:42 mrubinsk Exp $
$conf['debug_level'] = E_ALL;
$conf['max_exec_time'] = 0;
$conf['use_ssl'] = 2;
$conf['server']['name'] = $_SERVER['SERVER_NAME'];
$conf['server']['port'] = $_SERVER['SERVER_PORT'];
$conf['compress_pages'] = true;
$conf['umask'] = 077;
$conf['session']['name'] = 'Horde';
$conf['session']['cache_limiter'] = 'nocache';
$conf['session']['timeout'] = 0;
$conf['cookie']['domain'] = $_SERVER['SERVER_NAME'];
$conf['cookie']['path'] = '/horde';
$conf['sql']['persistent'] = false;
$conf['sql']['hostspec'] = 'localhost/localhost';
$conf['sql']['username'] = 'horde';
$conf['sql']['password'] = 'MY_PASSWORD_TO_HORDE_MYSQL_DB':
$conf['sql']['protocol'] = 'unix';
$conf['sql']['database'] = 'horde';
$conf['sql']['charset'] = 'iso-8859-1';
$conf['sql']['phptype'] = 'mysql';
$conf['auth']['admins'] = array('Administrator');
$conf['auth']['checkip'] = true;
$conf['auth']['params']['username'] = 'Administrator';
$conf['auth']['params']['requestuser'] = false;
$conf['auth']['driver'] = 'auto';
$conf['signup']['allow'] = true;
$conf['signup']['approve'] = false;
$conf['signup']['preprocess'] = false;
$conf['signup']['queue'] = false;
$conf['log']['priority'] = PEAR_LOG_NOTICE;
$conf['log']['ident'] = 'HORDE';
$conf['log']['params'] = array();
$conf['log']['name'] = '/var/log/horde.log';
$conf['log']['params']['append'] = true;
$conf['log']['type'] = 'file';
$conf['log']['enabled'] = true;
$conf['log_accesskeys'] = false;
$conf['prefs']['params']['driverconfig'] = 'horde';
$conf['prefs']['driver'] = 'sql';
$conf['datatree']['params']['driverconfig'] = 'horde';
$conf['datatree']['driver'] = 'sql';
$conf['group']['driver'] = 'datatree';
$conf['cache']['default_lifetime'] = 1800;
$conf['cache']['params']['dir'] = Horde::getTempDir();
$conf['cache']['driver'] = 'file';
$conf['token']['driver'] = 'none';
$conf['mailer']['params']['sendmail_path'] = '/usr/sbin/sendmail';
$conf['mailer']['params']['sendmail_args'] = '-oi';
$conf['mailer']['type'] = 'sendmail';
$conf['vfs']['params']['vfsroot'] = '/tmp';
$conf['vfs']['type'] = 'file';
$conf['sessionhandler']['type'] = 'none';
$conf['mime']['magic_db'] = '/usr/share/misc/magic.mime';
$conf['geoip']['datafile'] = '/usr/local/share/GeoIP/GeoIP.dat';
$conf['problems']['email'] = 'postmaster@$MY_DOMAIN';
$conf['menu']['always'] = true;
$conf['menu']['links']['help'] = 'all';
$conf['menu']['links']['options'] = 'authenticated';
$conf['menu']['links']['problem'] = 'all';
$conf['menu']['links']['login'] = 'all';
$conf['menu']['links']['logout'] = 'authenticated';
$conf['hooks']['username'] = false;
$conf['hooks']['preauthenticate'] = false;
$conf['hooks']['postauthenticate'] = false;
$conf['hooks']['authldap'] = false;
$conf['kolab']['enabled'] = false;
$conf['imsp']['enabled'] = false;
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */
--------------------------------------
horde/imp/config/config.php
$servers['imap'] = array(
'name' => 'MY_SERVER_NAME',
'server' => 'localhost',
'hordeauth' => true,
'protocol' => 'imap/notls',
'port' => 143,
'folders' => '',
'namespace' => '',
'maildomain' => 'MY_DOMAIN_NAME',
'smtphost' => 'localhost',
'smtpport' => 25,
'realm' => '',
'preferred' => '',
'dotfiles' => false,
'hierarchies' => array()
);
--------------------------------------
ERROR MESSAGE: (after finishing configuring horde)
[0]
A fatal error has occurred
DB Error: connect failed
[line 1329 of /var/www/horde/lib/Horde/DataTree/sql.php]
Details (also in Horde's logfile):
object(db_error)(8) {
["error_message_prefix"]=>
string(0) ""
["mode"]=>
int(1)
["level"]=>
int(1024)
["code"]=>
int(-24)
["message"]=>
string(24) "DB Error: connect failed"
["userinfo"]=>
string(123) " [nativecode=Client does not support authentication
protocol requested by server; consider upgrading MySQL client] **
Array"
["backtrace"]=>
array(16) {
[0]=>
array(6) {
["file"]=>
string(28) "/usr/local/share/pear/DB.php"
["line"]=>
int(888)
["function"]=>
string(10) "pear_error"
["class"]=>
string(8) "db_error"
["type"]=>
string(2) "->"
["args"]=>
array(5) {
[0]=>
string(24) "DB Error: connect failed"
[1]=>
int(-24)
[2]=>
int(1)
[3]=>
int(1024)
[4]=>
string(114) " [nativecode=Client does not support
authentication protocol requested by server; consider upgrading MySQL
client]"
}
}
[1]=>
array(6) {
["file"]=>
string(30) "/usr/local/share/pear/PEAR.php"
["line"]=>
int(557)
["function"]=>
string(8) "db_error"
["class"]=>
string(8) "db_error"
["type"]=>
string(2) "->"
["args"]=>
array(4) {
[0]=>
int(-24)
[1]=>
int(1)
[2]=>
int(1024)
[3]=>
string(114) " [nativecode=Client does not support
authentication protocol requested by server; consider upgrading MySQL
client]"
}
}
[2]=>
array(6) {
["file"]=>
string(35) "/usr/local/share/pear/DB/common.php"
["line"]=>
int(1849)
["function"]=>
string(10) "raiseerror"
["class"]=>
string(4) "pear"
["type"]=>
string(2) "::"
["args"]=>
array(7) {
[0]=>
NULL
[1]=>
int(-24)
[2]=>
NULL
[3]=>
NULL
[4]=>
string(114) " [nativecode=Client does not support
authentication protocol requested by server; consider upgrading MySQL
client]"
[5]=>
string(8) "DB_Error"
[6]=>
bool(true)
}
}
[3]=>
array(6) {
["file"]=>
string(34) "/usr/local/share/pear/DB/mysql.php"
["line"]=>
int(249)
["function"]=>
string(10) "raiseerror"
["class"]=>
string(8) "db_mysql"
["type"]=>
string(2) "->"
["args"]=>
array(5) {
[0]=>
int(-24)
[1]=>
NULL
[2]=>
NULL
[3]=>
NULL
[4]=>
string(100) "Client does not support authentication protocol
requested by server; consider upgrading MySQL client"
}
}
[4]=>
array(6) {
["file"]=>
string(28) "/usr/local/share/pear/DB.php"
["line"]=>
int(556)
["function"]=>
string(7) "connect"
["class"]=>
string(8) "db_mysql"
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
array(15) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["username"]=>
string(5) "horde"
["password"]=>
string(16) "MY_PASSWORD_TO_HORDE_MYSQL_DB"
["protocol"]=>
string(4) "unix"
["hostspec"]=>
string(19) "localhost/localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(5) "horde"
["persistent"]=>
bool(false)
["charset"]=>
string(10) "iso-8859-1"
["driverconfig"]=>
string(5) "horde"
["group"]=>
string(11) "horde.perms"
["table"]=>
string(14) "horde_datatree"
["table_attributes"]=>
string(25) "horde_datatree_attributes"
}
[1]=>
bool(false)
}
}
[5]=>
array(6) {
["file"]=>
string(41) "/var/www/horde/lib/Horde/DataTree/sql.php"
["line"]=>
int(1327)
["function"]=>
string(7) "connect"
["class"]=>
string(2) "db"
["type"]=>
string(2) "::"
["args"]=>
array(2) {
[0]=>
array(12) {
["persistent"]=>
bool(false)
["hostspec"]=>
string(19) "localhost/localhost"
["username"]=>
string(5) "horde"
["password"]=>
string(16) "MY_PASSWORD_TO_HORDE_MYSQL_DB"
["protocol"]=>
string(4) "unix"
["database"]=>
string(5) "horde"
["charset"]=>
string(10) "iso-8859-1"
["phptype"]=>
string(5) "mysql"
["driverconfig"]=>
string(5) "horde"
["group"]=>
string(11) "horde.perms"
["table"]=>
string(14) "horde_datatree"
["table_attributes"]=>
string(25) "horde_datatree_attributes"
}
[1]=>
array(1) {
["persistent"]=>
bool(false)
}
}
}
[6]=>
array(6) {
["file"]=>
string(41) "/var/www/horde/lib/Horde/DataTree/sql.php"
["line"]=>
int(68)
["function"]=>
string(8) "_connect"
["class"]=>
string(12) "datatree_sql"
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[7]=>
array(6) {
["file"]=>
string(37) "/var/www/horde/lib/Horde/DataTree.php"
["line"]=>
int(1180)
["function"]=>
string(12) "datatree_sql"
["class"]=>
string(12) "datatree_sql"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
&array(10) {
["persistent"]=>
bool(false)
["hostspec"]=>
string(19) "localhost/localhost"
["username"]=>
string(5) "horde"
["password"]=>
string(16) "MY_PASSWORD_TO_HORDE_MYSQL_DB"
["protocol"]=>
string(4) "unix"
["database"]=>
string(5) "horde"
["charset"]=>
string(10) "iso-8859-1"
["phptype"]=>
string(5) "mysql"
["driverconfig"]=>
string(5) "horde"
["group"]=>
string(11) "horde.perms"
}
}
}
[8]=>
array(6) {
["file"]=>
string(37) "/var/www/horde/lib/Horde/DataTree.php"
["line"]=>
int(1221)
["function"]=>
string(7) "factory"
["class"]=>
string(8) "datatree"
["type"]=>
string(2) "::"
["args"]=>
array(2) {
[0]=>
&string(3) "sql"
[1]=>
&array(10) {
["persistent"]=>
bool(false)
["hostspec"]=>
string(19) "localhost/localhost"
["username"]=>
string(5) "horde"
["password"]=>
string(16) "MY_PASSWORD_TO_HORDE_MYSQL_DB"
["protocol"]=>
string(4) "unix"
["database"]=>
string(5) "horde"
["charset"]=>
string(10) "iso-8859-1"
["phptype"]=>
string(5) "mysql"
["driverconfig"]=>
string(5) "horde"
["group"]=>
string(11) "horde.perms"
}
}
}
[9]=>
array(6) {
["file"]=>
string(43) "/var/www/horde/lib/Horde/Perms/datatree.php"
["line"]=>
int(46)
["function"]=>
string(9) "singleton"
["class"]=>
string(8) "datatree"
["type"]=>
string(2) "::"
["args"]=>
array(2) {
[0]=>
&string(3) "sql"
[1]=>
&array(10) {
["persistent"]=>
bool(false)
["hostspec"]=>
string(19) "localhost/localhost"
["username"]=>
string(5) "horde"
["password"]=>
string(16) "MY_PASSWORD_TO_HORDE_MYSQL_DB"
["protocol"]=>
string(4) "unix"
["database"]=>
string(5) "horde"
["charset"]=>
string(10) "iso-8859-1"
["phptype"]=>
string(5) "mysql"
["driverconfig"]=>
string(5) "horde"
["group"]=>
string(11) "horde.perms"
}
}
}
[10]=>
array(6) {
["file"]=>
string(34) "/var/www/horde/lib/Horde/Perms.php"
["line"]=>
int(347)
["function"]=>
string(14) "perms_datatree"
["class"]=>
string(14) "perms_datatree"
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[11]=>
array(6) {
["file"]=>
string(34) "/var/www/horde/lib/Horde/Perms.php"
["line"]=>
int(367)
["function"]=>
string(7) "factory"
["class"]=>
string(5) "perms"
["type"]=>
string(2) "::"
["args"]=>
array(1) {
[0]=>
&string(8) "datatree"
}
}
[12]=>
array(6) {
["file"]=>
string(37) "/var/www/horde/lib/Horde/Registry.php"
["line"]=>
int(187)
["function"]=>
string(9) "singleton"
["class"]=>
string(5) "perms"
["type"]=>
string(2) "::"
["args"]=>
array(0) {
}
}
[13]=>
array(6) {
["file"]=>
string(37) "/var/www/horde/lib/Horde/Registry.php"
["line"]=>
int(103)
["function"]=>
string(8) "registry"
["class"]=>
string(8) "registry"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
&int(0)
}
}
[14]=>
array(6) {
["file"]=>
string(27) "/var/www/horde/lib/base.php"
["line"]=>
int(34)
["function"]=>
string(9) "singleton"
["class"]=>
string(8) "registry"
["type"]=>
string(2) "::"
["args"]=>
array(0) {
}
}
[15]=>
array(4) {
["file"]=>
string(36) "/var/www/horde/admin/setup/index.php"
["line"]=>
int(13)
["args"]=>
array(1) {
[0]=>
string(27) "/var/www/horde/lib/base.php"
}
["function"]=>
string(12) "require_once"
}
}
["callback"]=>
NULL
}
-----------------------------------------------------
--
BSc. Enrique Llanos V.
-----------------
http://ellv.blogspot.com
-------------------------------------
Investigacion y Desarrollo
-------------------------------------
Somos LINUX, seamoslo SIEMPRE
More information about the horde
mailing list