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

[Samuel Nicolary]

On Mon, 19 Jul 2004, M Jenck wrote:

> 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.

I usually run the following as the mysql root user:

grant select,insert,update,delete on horde.* to horde at localhost;
flush privileges;
flush privileges;

Flush twice for good luck... 

-- 
Sam Nicolary

> -----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>
> 
> --
> Kronolith mailing list - Join the hunt: http://horde.org/bounties/#kronolith
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: kronolith-unsubscribe at lists.horde.org
>