[horde] DB Error
Bill Graham
grahamcw at hurleybulldogs.com
Tue Dec 13 10:53:33 PST 2005
Did you allow access in Mysql from the other machine try mysql
--host=yourmysqlhost -u horde -p
see if you can connect from the horde/imp server Quoting Mário Sérgio
Candian <mscandian at freebsdbrasil.com.br>:
> 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 THISLINE. */
>
>
> --
> 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
>
--
Bill Graham
Systems Administrator
Hurley Public Schools
Hurley,SD 57036
USA
grahamcw at hurleybulldogs.com
----------------------------------------------------------------
This electronic mail sent from Hurley Public Schools - Hurley, South Dakota
http://www.hurleybulldogs.com
NOTICE: This E-mail (including attachments) is covered by the
Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is
confidential and may be legally privileged. If you are not the intended
recipient, you are hereby notified that any retention, dissemination,
distribution, or copying of this communication is strictly prohibited.
Please reply to the sender that you have received the message in error,
then delete it. Thank you.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 1375 bytes
Desc: PGP Public Key
Url : http://lists.horde.org/archives/horde/attachments/20051213/e1592d44/attachment.bin
More information about the horde
mailing list