[kronolith] RE: DB Error: connect failed: [nativecode=Access denied for user:

[M Jenck]

Hi All,

 

A little more information!

 

I changed the username and password to a root level access and it worked
fine.  What specific permissions do I need to give to horde at localhost to
avoid the permission denied?

 

Any help greatly appreciated.

 

Mike

 

-----Original Message-----
From: M Jenck [mailto:mp at jenck.net] 
Sent: Monday, July 19, 2004 12:05 PM
To: 'kronolith at lists.horde.org'
Subject: DB Error: connect failed: [nativecode=Access denied for user: 

 

Hi All,

 

Here is a copy of my horde.log, config.php, and my mysql session (showing
grants). 

 

I realize it is a permission error. I just don't know what other permissions
I need to modify to get kronolith to connect.

 

Thanks in advance for any help.

 

Mike

 

Jul 19 10:29:48 HORDE [info] [horde] clean session [on line 882 of "D:\My
Documents\MyWebsite\Jenck_net\horde\lib\Horde.php"]

Jul 19 10:29:48 HORDE [info] [horde] Login success for Mike [192.168.0.4] to
Horde [on line 48 of "D:\My Documents\MyWebsite\Jenck_net\horde\login.php"]

Jul 19 10:29:48 HORDE [alert] [kronolith] DB Error: connect failed:
[nativecode=Access denied for user: 'horde at localhost' (Using password: YES)]
** Array [on line 454 of "D:\My
Documents\MyWebsite\Jenck_net\horde\kronolith-1.1.2\lib\Driver\sql.php"]

 

>From my config file

--> \kronolith-1.1.2\config\conf.php

 

$conf['calendar']['driver'] = 'sql';

 

// What MCAL driver is being used? 'mstore' is the local file driver,

// and is the only one with extensive testing. There is also an ICAP

// driver, and theoretically an ICAP server, but Kronolith has not

// been tested with them.

//$conf['calendar']['params']['driver'] = 'mstore';  <-- same error if this
is commented out or valid

 

// The mstore driver requires a username and a password that is in 

// /etc/mpasswd in order to access local calendars.

//$conf['calendar']['params']['username'] = '';

//$conf['calendar']['params']['password'] = '';

 

// This is an example configuration for an sql driver, in this case MySQL.

$conf['calendar']['params']['phptype'] = 'mysql';

$conf['calendar']['params']['hostspec'] = 'localhost';

$conf['calendar']['params']['username'] = 'horde';

$conf['calendar']['params']['password'] = 'd8u8l9c9e';

$conf['calendar']['params']['database'] = 'horde';

$conf['calendar']['params']['table'] = 'kronolith_events';

 

 

--> from mysql session

 

C:\WebSite\mysql\bin>mysql -u horde -pd8u8l9c8e horde

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 19 to server version: 3.23.55-max-nt

 

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

 

mysql> show grants for horde;

+---------------------------------------------------------------------------
------------------+

| Grants for horde@%              |

+---------------------------------------------------------------------------
------------------+

| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON
horde.kronolith_events TO 'horde'@'%' |

+---------------------------------------------------------------------------
------------------+

1 row in set (0.00 sec)

 

mysql> show grants for horde at localhost;

+---------------------------------------------------------------------------
--------------------------+

| Grants for horde at localhost                      |

+---------------------------------------------------------------------------
--------------------------+

| GRANT USAGE ON *.* TO 'horde'@'localhost' IDENTIFIED BY PASSWORD
'5c2544940b6cbae4'                 |

| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON `horde`.* TO
'horde'@'localhost'              |

| GRANT SELECT, INSERT, UPDATE, DELETE ON horde.horde_users TO
'horde'@'localhost'                    |

| GRANT SELECT, INSERT, UPDATE, DELETE ON horde.horde_prefs TO
'horde'@'localhost'                    |

| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON
horde.kronolith_events TO 'horde'@'localhost' |

+---------------------------------------------------------------------------
--------------------------+

5 rows in set (0.00 sec)

 

mysql>