Re: calendar invites cannot be added to my calendar
Chris Fisichella <[email protected]> Fri, 04 Mar 2016 02:17:05 +0000
| Newsgroups | gmane.comp.horde.kronolith |
|---|---|
| Message-ID | <[email protected]> |
Quoting Michael J Rubinsky <[email protected]>: > Quoting Chris Fisichella <[email protected]>: > >> Quoting Michael J Rubinsky <[email protected]>: >> >>> Quoting Chris Fisichella <[email protected]>: >>> >>>> Quoting Michael J Rubinsky <[email protected]>: >>>> >>>>> Quoting Chris Fisichella <[email protected]>: >>>>> >>>>>> Quoting Michael J Rubinsky <[email protected]>: >>>>>> >>>>>>> Quoting Chris Fisichella <[email protected]>: >>>>>>> >>>>>>>> Quoting Simon B <[email protected]>: >>>>>>>> >>>>>>>>> On 6 Jan 2016 02:02, "Chris Fisichella" >>>>>>>>> <[email protected]> >>>>>>>>> wrote: >>>>>>>>> >>>>>>>>>> Hi, >>>>>>>>>> >>>>>>>>>> I get a very lengthy error message[1] when I attempt to accept a >>>>>>>> >>>>>>>> calendar >>>>>>>>>> invite from someone. Does anyone know how to fix this so I can >>>> >>>> accept >>>>>>>>>> them? >>>>>>>>> >>>>>>>>> What version? >>>>>>>>> >>>>>>>>> What does your horde log say at the moment you accept the >>>>>>>>> invitation? >>>>>>>>> >>>>>>>>> What does the webserver error log say? >>>>>>>>> >>>>>>>>> Are your database schemas up to date? >>>>>>>>> >>>>>>>>> Have you searched the web on the rampage_users portion of the >> >> error? >>>>>>>>> Simon >>>>>>>> >>>>>>>> "It's not really related to the invitation, but to the system that >>>>>> >>>>>> stores >>>>>>>> tags. It looks like a case sensitivity issue. Most likely you have >>>>>> >>>>>> logged >>>>>>>> in as "chris" and now are logging in as "Chris". >>>>>>>> >>>>>>>> -- >>>>>>>> mike >>>>>>>> The Horde Project" >> >> _____________________________________________________________________________________ >>>>>>>> Simon, Mike, >>>>>>>> >>>>>>>> Thanks for replying. >>>>>>>> I am running Kronolith H5 4.2.2. >>>>>>>> >>>>>>>> Where is the Horde log? I also don't know where my webserver log >>>>>>>> is. >>>> >>>> In >>>>>>>> addition, I don't know how to check if my database schemas are up >>>>>>>> to >>>>>>>> date. >>>>>>>> Finally, I did not search for rampage_users. Those are all good >> >> ideas >>>>>> and >>>>>> >>>>>>>> I'll get going on them. >>>>>>>> >>>>>>>> Mike, >>>>>>>> >>>>>>>> I see what you are saying about "Chris". Where is Kronolith picking >>>>>>>> that >>>>>>>> up? My log in to the linux box is >>>>>>>> >>>>>>>> "chris" and I log into Horde as "chris." I looked at the invitation >>>> >>>> and >>>>>>>> it >>>>>>>> says "[email protected]" >>>>>>> >>>>>>> At some point in the past you must have logged in as "Chris", and >> >> this >>>>>>> just happens to be the username that was in use when the Content >>>>>>> system >>>>>>> added your username to the rampage_users table. In your case your >>>>>>> SQL >>>>>>> system is case insensitive, but since the equality checks in PHP >> >> *are* >>>>>>> case sensitive, this screws things up. >>>>>>> >>>>>>> If your authentication backend is case insensitive, you should be >>>>>>> using >>>>>>> the authusername hook to normalize them. See >> >> horde/config/hooks.php. >>>> In >>>> >>>>>>> the meantime, you can alter the entry in the rampage_users table to >> >> be >>>>>>> all lowercase. >>>>>>> >>>>>>> -- >>>>>>> mike >>>>>>> The Horde Project >>>>>>> http://www.horde.org >> >> https://www.facebook.com/hordeprojecthttps://www.twitter.com/hordeproject >>>>>> Hi Mike, >>>>>> >>>>>> That was really cool to see that authusername function, example #2 >>>>>> ready to >>>>>> go. I uncommented it inside of the Horde_xxxx class. I uncommented >>>>>> the >>>>>> closing brace, so I think the function is live. I did some web >>>>>> searching >>>>>> and there is a lot of coverage on making preferences active by >> >> enabling >>>>>> them in the prefs file. Will authusername automatically run? >>>>> >>>>> Yes, it should. You can always verify this by placing something like: >>>>> >>>>> Horde::debug('foo'); in that method. This will output 'foo' into a >>>>> file >>>>> called horde_debug.txt in your tmp directory. >>>>> >>>>>> I am still >>>>>> seeing the error, so I think there is a little more work to do. Would >>>> >>>> you >>>>>> mind pointing me in the right direction? >>>>> >>>>> Well, did you normalize the already-existing entry in the >>>>> rampage_users >>>>> table? >>>>> >>>>> -- >>>>> mike >>>>> The Horde Project >>>>> http://www.horde.org >> >> https://www.facebook.com/hordeprojecthttps://www.twitter.com/hordeproject >>>> Hi Mike, >>>> >>>> That debug trick is really cool! Indeed, the function is running. I am >>>> still getting the error. Does this mean I need to edit the >>>> rampage_users >>>> table? I have never done that. It sounds like a mysql effort. Do I have >>>> to >>>> do that, or can the hook do that for me? >>> >>> Well, yes. The hook normalizes the username to lowercase, but the entry >>> in the rampage table is mixed case. You need to update the entry in the >>> rampage table: >>> >>> UPDATE rampage_users SET user_name='chris' WHERE user_name='Chris'; >>> >>> -- >>> mike >>> The Horde Project >>> http://www.horde.org >>> https://www.facebook.com/hordeprojecthttps://www.twitter.com/hordeproject >> >> Hi Mike, >> Sorry for the delay in my reply. There was some over head in digging up >> the >> mysql login information. This is what I did: >> #mysql -u mysql -p >> <ented my password> >> mysql>SHOW DATABASES; >> mysql>USE horde_db; >> mysql>SHOW TABLES; >> ... >> rampage_users >> .... >> mysql>UPDATE rampage_users SET user_name='chris' WHERE user_name='Chris'; >> Query OK, 0 rows affecte (0.00 sec) >> Rows matched: 1 changed: 0 warning: 0 >> mysql>SELECT * FROM rampage_users >> user_id user_name >> 5 <long alphanumeric> >> 1 Aministrator >> 3 chris >> 4 e---- >> 2 f----- >> 6 s---- >> mysql>exit >> >> I don't see the 'Chris' login. > > Correct, because you changed it to 'chris'. > >> When I go into Calendar I get a red "Permission Denied" reminder. I don't >> see anything is /var/log/syslog. I noticed all of my appointments and >> reminders are gone for the month of March, except for yesterday and >> today. >> April looks okay. > > The rampage tables have nothing to do with permissions to calendars. My > guess is your share tables probably have the incorrect username as well. > >> Do you have any advice to offer? >> >> Thanks, >> Chris >> -- >> kronolith mailing list >> Frequently Asked Questions: http://wiki.horde.org/FAQ >> To unsubscribe, mail: [email protected] > > -- > mike > The Horde Project > http://www.horde.org > https://www.facebook.com/hordeprojecthttps://www.twitter.com/hordeproject Hi Mike, You are right. mysql>select * from kronolith_sharesng; yielded **two** lines with [Cc]hris on them: 3 | 1XlF_fkYyg2-D5MCv9G28g1 | chris | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Calendar of chris | | #35f62b | NULL | | 4 | 5ucOd10l_emHPVY6UekOyw1 | ebay | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Calendar of ebay | NULL | #088ec8 | NULL | | 5 | W3SVHy2qcXtAjnSujCE4kw1 | Chris | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Calendar of Chris Fisichella | NULL | #aa34fd | NULL | mysql>delete from kronolith_sharesng where user_id=5; I'm not sure I got the column heading "user_id" right. I am working from memory, but that deleted the "Chris" row. Now, when I go into the calendar, I don't get the permission denied message. Also, I can get invites from people and they are successfully handled by the kronolith program. Thank you for all the help and the advice. I never would have thought to poke around in mysql to fix the problem. Best Regards, Chris -- kronolith mailing list Frequently Asked Questions: http://wiki.horde.org/FAQ To unsubscribe, mail: [email protected]