[kronolith] calendar invites cannot be added to my calendar

Tue Mar 1 14:53:48 UTC 2016

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/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5751 bytes
Desc: S/MIME Signature
URL: <http://lists.horde.org/archives/kronolith/attachments/20160301/381214b4/attachment.bin>