[horde] DB Error

[Mário Sérgio Candian]

Marcelo H. Terres wrote:

> Did you set the new database server in the  horde configuration ???
>
> []
>
> 2005/12/13, Mário Sérgio Candian <mscandian at freebsdbrasil.com.br 
> <mailto:mscandian at freebsdbrasil.com.br>>:
>
>     Hi list,
>
>     I have one question:
>
>     How I need to do, to use the databases of horde in other server?
>
>     I have 2 FreeBSD servers:
>
>     1o - email server (qmail+horde)
>
>     2o - intranet (with the databases)
>
>     I moved the horde database to the 2o server, and when I try to access
>     horde in my browser I get this:
>
>     A fatal error has occurred
>     DB Error: connect failed
>     Details have been logged for the administrator.
>
>     In my horde.log:
>
>     Dec 13 05:30:46 HORDE [emergency] [horde] DB Error: connect failed:
>     [nativecode=Can't connect to local MySQL server through socket
>     '/tmp/mysql.sock' (2)] ** Array [on line 1307 of
>     "/usr/local/www/data-dist/horde/lib/Horde/DataTree/sql.php"]
>
>     but the mysql isnt running in the localhost.
>
>     What I can do to fix it?
>
>     --
>     Atenciosamente,
>     Mario Sergio Candian
>     FreeBSD Brasil LTDA.
>     -
>     "Dreams as if you'll live forever. Live as if you'll die today" --
>     James Dean
>
>     --
>     Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
>     Frequently Asked Questions: http://horde.org/faq/
>     To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>     <mailto:horde-unsubscribe at lists.horde.org>
>
>
>
>
> -- 
> Marcelo H. Terres
> mhterres at gmail.com <mailto:mhterres at gmail.com> 
> !DSPAM:439f0ddd589539908211751! 

Marcelo,

yes... look my conf.php:

$conf['debug_level'] = E_ERROR;
$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'] = true;
$conf['sql']['hostspec'] = '200.170.x.y';
$conf['sql']['username'] = 'horde';
$conf['sql']['password'] = 'horde';
$conf['sql']['protocol'] = 'unix';
$conf['sql']['database'] = 'horde';
$conf['sql']['charset'] = 'iso-8859-1';
$conf['sql']['phptype'] = 'mysql';
$conf['auth']['admins'] = array('freebsdbrasil');
$conf['auth']['checkip'] = true;
$conf['auth']['params']['app'] = 'imp';
$conf['auth']['driver'] = 'application';
$conf['signup']['allow'] = false;
$conf['signup']['approve'] = true;
$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'] = '/tmp/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']['params']['driverconfig'] = 'horde';
$conf['token']['driver'] = 'sql';
$conf['mailer']['params']['localhost'] = '200.170.x.y';
$conf['mailer']['params']['auth'] = 'LOGIN';
$conf['mailer']['params']['username'] = 'horde';
$conf['mailer']['params']['password'] = 'senhahorde';
$conf['mailer']['type'] = 'smtp';
$conf['vfs']['params']['driverconfig'] = 'horde';
$conf['vfs']['type'] = 'sql';
$conf['sessionhandler']['params']['persistent'] = true;
$conf['sessionhandler']['params']['protocol'] = 'unix';
$conf['sessionhandler']['params']['hostspec'] = '200.170.x.y';
$conf['sessionhandler']['params']['username'] = 'horde';
$conf['sessionhandler']['params']['password'] = 'horde';
$conf['sessionhandler']['params']['database'] = 'horde';
$conf['sessionhandler']['type'] = 'mysql';
$conf['problems']['email'] = 'suporte at mydomain.com';
$conf['menu']['always'] = false;
$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;
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */


-- 
Atenciosamente,
Mario Sergio Candian
FreeBSD Brasil LTDA.
-
"Dreams as if you'll live forever. Live as if you'll die today" -- James Dean