Re: Event notification from another user private calendar

Em 18/02/16 20:18, Michael J Rubinsky escreveu:
>
> Quoting Luis Felipe Marzagao <[email protected]>:
>
>> Em 18/02/2016 18:31, Michael J Rubinsky escreveu:
>>>
>>> Quoting Jens Wahnes <[email protected]>:
>>>
>>>> Michael J Rubinsky wrote:
>>>>
>>>>> Quoting Jens Wahnes <[email protected]>:
>>>>>
>>>>>> On Tue, Feb 16 2016, at 11:49:41 -0200, Luis Felipe Marzagao wrote:
>>>>>>
>>>>>>> Em 15/02/2016 11:47, Luis Felipe Marzagao escreveu:
>>>>>>>> Hello:
>>>>>>>>
>>>>>>>> I´ve just been notified in kronolith (the orange bottom-right box)
>>>>>>>> about
>>>>>>>> an event that was created by another user in his private calendar.
>>>>>>>>
>>>>>>>> I do not have access to that calendar. It´s not listed in my 
>>>>>>>> shared
>>>>>>>> calendars.
>>>>>>>>
>>>>>>>> If I click on the event name at the orange notification box I 
>>>>>>>> get a
>>>>>>>> "Event not found" error (red box). Probably because I don´t have
>>>>>>>> access
>>>>>>>> to that event, as expected, since it´s private for that user.
>>>>>>>>
>>>>>>>> We are using kronolith 4.2.14.
>>>>>>>
>>>>>>> Today it has happened again.
>>>>>>
>>>>>> I didn't notice this on our test server, but since we updated our 
>>>>>> main
>>>>>> server to the latest versions of Horde (including Kronolith 4.2.15),
>>>>>> this is happening to us as well.
>>>>>>
>>>>>> The problem seems to stem from the horde-alarms script being run (a
>>>>>> cronjob in our case). After the update, the horde-alarms script
>>>>>> consumes way more memory than before and takes ages to run (before:
>>>>>> less than a second, after the upgrade: more than a minute).
>>>>>
>>>>> There was a bug in the code that polls each application for 
>>>>> alarms. We
>>>>> weren't actually polling the applications at all in certain cases. 
>>>>> This
>>>>> commit:
>>>>>
>>>>> https://github.com/horde/horde/commit/4b482074340bf4e7ddc469d69172c5c0a2c761f8 
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> fixed the issue, and probably explains the longer execution time, 
>>>>> since
>>>>> each application is now actually polled. I'm not seeing your other
>>>>> issue, but will look into it further.
>>>>
>>>> I did some testing with higher debug levels during a run of the
>>>> horde-alarms script which generated a ton of output which I've been
>>>> wading through.  One thing that caught my attention was a query that
>>>> was logged and looks like this:
>>>>
>>>> SELECT * FROM kronolith_sharesng WHERE share_name = 0 [pid 18524 on
>>>> line 321 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
>>>
>>> This is probably coming from Kronolith_Application::listAlarms().
>>>
>>> As an admin user, execute the following from the admin phpshell page,
>>> using kronolith's scope:
>>>
>>>
>
>>>
>>>
>>> You should see an array of share_names. If I'm right, one of these will
>>> be '0' for some unknown reason.
>>
>> Yep, for me it does. The 23th item:
>>
>> array(24) {
>>   [0]=>
>>   string(23) "0ZiHPQiFsvBP6PWQoSL0iwA"
>>   [1]=>
>>   string(32) "11e3b9f2f49fab07664945d4cede8469"
>>   [2]=>
>>   string(32) "57f3b572c7d8276e65b91e3cd346b172"
>>   [3]=>
>>   string(32) "5bdc6fa2c97cecef501b34c47c14d9f9"
>>   [4]=>
>>   string(2) "ac"
>>   [5]=>
>>   string(4) "acfs"
>>   [6]=>
>>   string(13) "Administrator"
>>   [7]=>
>>   string(3) "aps"
>>   [8]=>
>>   string(3) "cel"
>>   [9]=>
>>   string(3) "daa"
>>   [10]=>
>>   string(2) "em"
>>   [11]=>
>>   string(23) "FmzDcAiFsvBP1WO3OgIwOPA"
>>   [12]=>
>>   string(23) "f_B_EAlE4RdL8ZGJ9IzxuQ5"
>>   [13]=>
>>   string(3) "ibl"
>>   [14]=>
>>   string(4) "lfbm"
>>   [15]=>
>>   string(3) "mes"
>>   [16]=>
>>   string(4) "rabm"
>>   [17]=>
>>   string(5) "rabmj"
>>   [18]=>
>>   string(4) "robm"
>>   [19]=>
>>   string(23) "SZtmkeuHIuoMv74QHovb1A1"
>>   [20]=>
>>   string(4) "veri"
>>   [21]=>
>>   string(4) "vmlr"
>>   [22]=>
>>   string(3) "vsg"
>>   [23]=>
>>   int(0)
>
>
> This means that the share in the database doesn't have a share_name 
> for some reason. Can you see which share that is in the 
> kronolith_sharesng table?
>
>

Apparently, there is no such entry without share_name in my tables. Here 
they are:


mysql> select share_id, share_name from kronolith_shares;
+----------+----------------------------------+
| share_id | share_name                       |
+----------+----------------------------------+
|        1 | lfbm                             |
|        2 | robm                             |
|        3 | 57f3b572c7d8276e65b91e3cd346b172 |
|        4 | cel                              |
|        5 | aps                              |
|        6 | em                               |
|        7 | daa                              |
|        8 | rabm                             |
|        9 | rabmj                            |
|       10 | veri                             |
|       11 | ac                               |
|       13 | mes                              |
|       14 | Administrator                    |
|       16 | 5bdc6fa2c97cecef501b34c47c14d9f9 |
|       17 | 11e3b9f2f49fab07664945d4cede8469 |
|       27 | vmlr                             |
|       22 | ibl                              |
|       23 | vsg                              |
|       26 | acfs                             |
+----------+----------------------------------+
19 rows in set (0.00 sec)


mysql> select share_id, share_name from kronolith_sharesng;
+----------+----------------------------------+
| share_id | share_name                       |
+----------+----------------------------------+
|       29 | 0ZiHPQiFsvBP6PWQoSL0iwA          |
|       17 | 11e3b9f2f49fab07664945d4cede8469 |
|        3 | 57f3b572c7d8276e65b91e3cd346b172 |
|       16 | 5bdc6fa2c97cecef501b34c47c14d9f9 |
|       11 | ac                               |
|       26 | acfs                             |
|       14 | Administrator                    |
|        5 | aps                              |
|        4 | cel                              |
|        7 | daa                              |
|        6 | em                               |
|       28 | FmzDcAiFsvBP1WO3OgIwOPA          |
|       30 | f_B_EAlE4RdL8ZGJ9IzxuQ5          |
|       22 | ibl                              |
|        1 | lfbm                             |
|       13 | mes                              |
|        8 | rabm                             |
|        9 | rabmj                            |
|        2 | robm                             |
|       31 | SZtmkeuHIuoMv74QHovb1A1          |
|       10 | veri                             |
|       27 | vmlr                             |
|       23 | vsg                              |
+----------+----------------------------------+
23 rows in set (0.00 sec)

What else should I check?

Thanks a lot!

>
>

-- 
kronolith mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [email protected]