[horde] unable to connect to sql
TommyM
info at hirtreiter-design.de
Wed Jun 1 14:57:19 PDT 2005
yes my server is running...
i can connect over the shell to mysql and i can also connect to phpmyadmin..
MYSQL is using socket so in the config.php stands this:
$conf['sql']['persistent'] = false;
$conf['sql']['hostspec'] = 'localhost';
$conf['sql']['username'] = 'XXX';
$conf['sql']['password'] = 'XXXX';
$conf['sql']['socket'] = '3306';
$conf['sql']['protocol'] = 'unix';
$conf['sql']['database'] = 'horde';
$conf['sql']['charset'] = 'iso-8859-1';
$conf['sql']['phptype'] = 'mysql';
$conf['auth']['admins'] = array('Administrator', 'oliver');
$conf['auth']['checkip'] = true;
$conf['auth']['alternate_login'] = false;
$conf['auth']['redirect_on_logout'] = false;
$conf['auth']['params']['driverconfig'] = 'horde';
$conf['auth']['params']['encryption'] = 'md5-hex';
$conf['auth']['params']['show_encryption'] = false;
$conf['auth']['driver'] = 'sql';
in my.cnf is this standing:
skip-locking
#
# The skip-networkin option will no longer be set via debconf menu.
# You have to manually change it if you want networking i.e. the server
# listening on port 3306. The default is "disable" - for security reasons.
#skip-networking
#SKIP_NETWORKING
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M
set-variable = max_connections=10000
set-variable = wait_timeout=15
set-variable = interactive_timeout=10
is that right?
"Maciek Borowka" <mborowka at clever-age.com> schrieb im Newsbeitrag
news:200506012311.47337.mborowka at clever-age.com...
Stupid question, but: are you sure your database server is up and running?
Less stupid question: if you are using mySQL and TCP connexion, have you
correcly configured the server (no skip-networking in my.cnf)?
./Maciek
On Wednesday 01 June 2005 23:03, TommyM wrote:
> Hello,
>
> what can i do about this problem.
>
>
>
> Jun 01 21:49:27 HORDE [emergency] [horde] Unable to connect to SQL server.
> [on line 449 of "/usr/share/php/Horde/Auth/sql.php"]
>
> I logged in as an admin and the conf.php has the right informations about
> username, password, localhost, unix.
>
> Can anybody give me a help?
>
>
> Thanks
--
Maciek Borowka http://pl.clever-age.com
Clever Age Polska - Otwarte uslugi informatyczne
Tel: +48 58 30 74 340 GSM: +48 606 525 368
--
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
More information about the horde
mailing list