[kronolith] fresh kronolith install, events not being saved

[Hanser, Kevin]

Ah-ha!  I checked on my buddy's horde/imp/kronolith installation for the
permissions on his horde@localhost user, and then set mine to be the same:

mysql> show grants for horde@localhost;
+---------------------------------------------------------------------------
-----------+
| Grants for horde@localhost
|
+---------------------------------------------------------------------------
-----------+
| GRANT USAGE ON *.* TO 'horde'@'localhost' IDENTIFIED BY PASSWORD
'70067b081cc16b43'  |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON horde.* TO
'horde'@'localhost' |
+---------------------------------------------------------------------------
-----------+

And now it works!

thx

k

> -----Original Message-----
> From: Hanser, Kevin [mailto:kevin@merchantinternetgroup.com]
> Sent: Tuesday, August 27, 2002 10:59
> To: 'Ketut Mahaindra'; 'kronolith@lists.horde.org'
> Subject: RE: [kronolith] fresh kronolith install, events not 
> being saved
> 
> 
> Ok, I issued the following commands to make sure that horde had create
> rights:
> grant create on horde.* to horde@localhost;
> 
> and then checked the grant permissions:
> mysql> show grants for horde@localhost;
> +-------------------------------------------------------------
> --------------
> ----------+
> | Grants for horde@localhost
> |
> +-------------------------------------------------------------
> --------------
> ----------+
> | GRANT USAGE ON *.* TO 'horde'@'localhost' IDENTIFIED BY PASSWORD
> '47874f9178ff36b3' |
> | GRANT CREATE ON horde.* TO 'horde'@'localhost'
> |
> | GRANT CREATE ON horde.horde TO 'horde'@'localhost'
> |
> +-------------------------------------------------------------
> --------------
> ----------+
> 3 rows in set (0.00 sec)
> 
> 
> But it still won't create new events...  Are these the 
> correct permissions
> for the horde user, or am I missing something...?
> 
> thx
> 
> k
> 
> -----Original Message-----
> From: Ketut Mahaindra [mailto:KMahaindra@beijing.sema.slb.com]
> Sent: Tuesday, August 27, 2002 01:52
> To: 'kronolith@lists.horde.org'
> Subject: RE: [kronolith] fresh kronolith install, events not 
> being saved
> 
> 
> I have the same problem before, and I found the solution in 
> the INSTALL file
> 
> Excerpt from kronolith/docs/INSTALL file, line 157 
> --------------- 
> You will also need to make sure that the "horde" user in your 
> database has table-creation privileges, so that the tables that 
> PEAR DB uses to provide portable sequences can be created. 
> --------------- 
> hope it helps 
> -- 
> best regards 
> ito 
> > -----Original Message----- 
> > From: Hanser, Kevin [mailto:kevin@merchantinternetgroup.com] 
> > Sent: Monday, August 26, 2002 11:30 PM 
> > To: 'kronolith@lists.horde.org' 
> > Subject: [kronolith] fresh kronolith install, events not 
> being saved 
> > 
> > 
> > Hello, 
> > I've had horde, IMP and turba working for a couple months 
> > now, and this 
> > weekend I decided to install kronolith as well.  I followed the 
> > instructions, and everything seems to be working ok except I 
> > can't save 
> > events.  I enter all the information for the new event, click 
> > save, and it 
> > goes on as if everything went ok, but the event doesn't show 
> > up anywhere. 
> > No error message is reported, the event just disappears... 
> > 
> > I searched the mailing list archives, and I noticed someone 
> > else had this 
> > same problem, but I didn't see a solution.  The reply to that 
> > post suggested 
> > turning up logging on horde, to see what that produced.  So I 
> > turned the 
> > logging on my horde to LOG_DEBUG, but nothing is shown in the 
> > log when I 
> > save an event :(  Only thing that's in the log is my login... 
> > 
> > My kronolith is configured to use 'sql' as the driver, with 
> > the appropriate 
> > lines uncommented for the mysql database as a backend.  I ran 
> > the create 
> > script, and created the table (I verified that the table was 
> > actually there 
> > by using the mysql manager as the horde user). 
> > 
> > I'm using: Horde 2.1 RC3, Imp 3.1, Kronolith 1.0 
> > System is: RH 7.2 
> > 
> > I checked any system logs I could think might have something 
> > in them, but 
> > don't see any errors there either.  
> > 
> > Where can I look to figure out what's going wrong here..?? 
> > 
> > thx 
> > 
> > Kevin Hanser 
> > System Administrator 
> > Merchant Internet Group, Inc. 
> > ShopsForMe.com 
> > kevin@merchantinternetgroup.com 
> > kevin@shopsforme.com 
> > 
> > 
> > -- 
> > Kronolith mailing list 
> > Frequently Asked Questions: http://horde.org/faq/ 
> > To unsubscribe, mail: kronolith-unsubscribe@lists.horde.org 
> > 
> 
> -- 
> Kronolith mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: kronolith-unsubscribe@lists.horde.org
>