[kronolith] calendar invites cannot be added to my calendar
Chris Fisichella
chris at communityrenewables.com
Fri Mar 4 02:17:05 UTC 2016
Quoting Michael J Rubinsky <mrubinsk at horde.org>:
> Quoting Chris Fisichella <chris at communityrenewables.com>:
>
>> Quoting Michael J Rubinsky <mrubinsk at horde.org>:
>>
>>> Quoting Chris Fisichella <chris at communityrenewables.com>:
>>>
>>>> Quoting Michael J Rubinsky <mrubinsk at horde.org>:
>>>>
>>>>> Quoting Chris Fisichella <chris at communityrenewables.com>:
>>>>>
>>>>>> Quoting Michael J Rubinsky <mrubinsk at horde.org>:
>>>>>>
>>>>>>> Quoting Chris Fisichella <chris at communityrenewables.com>:
>>>>>>>
>>>>>>>> Quoting Simon B <simon.buongiorno at gmail.com>:
>>>>>>>>
>>>>>>>>> On 6 Jan 2016 02:02, "Chris Fisichella"
>>>>>>>>> <chris at communityrenewables.com>
>>>>>>>>> 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 "chris at communityrenewables.com"
>>>>>>>
>>>>>>> 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: kronolith-unsubscribe at lists.horde.org
>
> --
> 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
More information about the kronolith
mailing list