[kronolith] calendar invites cannot be added to my calendar

[Chris Fisichella]

  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.

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.

Do you have any advice to offer?

Thanks,
Chris