Topic: Kronolith install per wiki but getting DB errors when creating calendar event

[tstokovaz]

I searched contribs and can't find info on this regarding an install of kronolith on a current SME 7.3 server.

I installed all updates as normal for SME 7.3 and then followed the kronolith wiki in contribs to install the kronolith calender addin.

I used the command "yum --enablerepo=smecontribs install smeserver-kronolith". I didn't install gollem or other groupware addins (do I need to?) 

After the required "signal-event post-upgrade; signal-event reboot" all seemed well. I set permissions for the calendars to be seen and edited.  BUT when I try to use it, i get the following errors when trying to create a calendar event. Even tried all permissions set to allow in the horde administrator

Error  There was an error adding the event: DB Error: no such field : INSERT INTO kronolith_events (event_id, event_uid, event_creator_id, event_title, event_description, event_category, event_location, event_status, event_attendees, event_keywords, event_exceptions, event_modified, event_start, event_end, event_alarm, event_recurtype, calendar_id) VALUES ('5991a046f4466d3a7a735f17e4c2b89a', '20080821120125.weiti0dkjn4@www.turningpnt.org', 'tstokovaz@turningpnt.org', 'test', '', '', '', '2', 'a:0:{}', '', '', 1219341685, '2008-08-21 06:00:00', '2008-08-21 07:00:00', 0, '0', 'tstokovaz@turningpnt.org') [nativecode=1054 ** Unknown column 'event_uid' in 'field list']

Also getting this error when trying to invite another user to the event:

Error retrieving free/busy information for USER: No free/busy url found for USER@turningpnt.org.
(USER equals the person with a valid webmail account invited to the event).

Kronolith-h3 version 2.1.8 release 1.e14 sme and smeserver-kronolith version 1.1 release 11.e14.sme were installed.

I also checked the  logs and they seem to have lots of info being added as a result of Kronolith. My question is whether I did something wrong or if this is a bug that needs reporting? I even set up a test server before trying this but didn't think to test the event creation in a test account. I suspect it is not kronolith itself but am not certain how to proceed. I CAN reproduce this error as I rechecked the test install I did and it has the same problem. Can someone point me the right direction? Everything except Kronolith seems to work fine.

Thanks.

[mrjhb3]

I replied to you off list on your bug report.  It doesn't do any good to file a bug report and also post in the forums.  I created the rpms and have installed them many times with no errors.  I asked you to look in your logs after the signal-event post-upgrade ; signal-event reboot and search for any mysql.init errors.

After the post-upgrade reboot, the appropriate tables are created during the reboot.  Are you certain that the server did reboot?

John

[tstokovaz]

Sorry about posting both places. I am learning the posting rules and expectations.

I looked at the logs and everything looks normal. I am unsure how to proceed. I will try testing it again on my testbox and see if I can figure it out. I definitely did the post-upgrade and reboot. Nothing in the logs indicated anything unusual. I rebooted again ,just in case, and all went as normal. Logs reflected that as well.

Same error message as before when I try to create an event or invite someone.

I tried to reinstall and got errors from the mirrors with a final no new rpms installed as the result. I'll try later.

[mrjhb3]

I just installed a new server, applied all updates to bring it up to 7.3, then did this:
yum --enablerepo=smecontribs install smeserver-kronolith

Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
Installing:
 smeserver-kronolith     noarch     1.1-11.el4.sme   smecontribs        36 k
Installing for dependencies:
 kronolith-h3            noarch     2.1.8-1.el4.sme  smecontribs       1.8 M
 php-pear-HTTP-Request   noarch     1.4.0-1.el4.sme  smecontribs        16 k
 php-pear-Net-Socket     noarch     1.0.6-1.el4.sme  smecontribs       6.4 k
 php-pear-Net-URL        noarch     1.0.14-1.el4.sme  smecontribs       7.2 k

Transaction Summary
=============================================================================

then signal-event post-upgrade ; signal event reboot

Everything installed correctly and kronolith works just fine.  Your error seems to elude that the kronolith database was not created.  If you cd /var/lib/mysql/horde, do you have the six kronolith databases, and are the permissions set to 660 mysql.mysql?

John

[tstokovaz]

Here are the permissions for the databases in horde. All seem to be set at 660
[root@mail horde]# ls -l
total 12016
-rw-rw----  1 mysql mysql    8644 Nov 18  2006 horde_categories_categories.frm
-rw-rw----  1 mysql mysql       0 Nov 18  2006 horde_categories_categories.MYD
-rw-rw----  1 mysql mysql    1024 Nov 18  2006 horde_categories_categories.MYI
-rw-rw----  1 mysql mysql    8862 Nov 18  2006 horde_categories.frm
-rw-rw----  1 mysql mysql       0 Nov 18  2006 horde_categories.MYD
-rw-rw----  1 mysql mysql    1024 Nov 18  2006 horde_categories.MYI
-rw-rw----  1 mysql mysql    8724 Nov 18  2006 horde_datatree_attributes.frm
-rw-rw----  1 mysql mysql  815604 Aug 26 16:00 horde_datatree_attributes.MYD
-rw-rw----  1 mysql mysql  849920 Aug 26 16:00 horde_datatree_attributes.MYI
-rw-rw----  1 mysql mysql    8966 Nov 18  2006 horde_datatree.frm
-rw-rw----  1 mysql mysql  874924 Aug 26 16:00 horde_datatree.MYD
-rw-rw----  1 mysql mysql  848896 Aug 26 16:00 horde_datatree.MYI
-rw-rw----  1 mysql mysql    8556 Nov 18  2006 horde_datatree_seq.frm
-rw-rw----  1 mysql mysql       5 Aug 26 16:00 horde_datatree_seq.MYD
-rw-rw----  1 mysql mysql    2048 Aug 26 16:00 horde_datatree_seq.MYI
-rw-rw----  1 mysql mysql    8844 Mar 25  2007 horde_histories.frm
-rw-rw----  1 mysql mysql 3393760 Aug 27 07:04 horde_histories.MYD
-rw-rw----  1 mysql mysql 3021824 Aug 27 07:04 horde_histories.MYI
-rw-rw----  1 mysql mysql    8556 Mar 25  2007 horde_histories_seq.frm
-rw-rw----  1 mysql mysql       5 Aug 27 07:04 horde_histories_seq.MYD
-rw-rw----  1 mysql mysql    2048 Aug 27 07:04 horde_histories_seq.MYI
-rw-rw----  1 mysql mysql    8692 Mar 25  2007 horde_prefs.frm
-rw-rw----  1 mysql mysql  630124 Aug 27 07:19 horde_prefs.MYD
-rw-rw----  1 mysql mysql  337920 Aug 27 05:51 horde_prefs.MYI
-rw-rw----  1 mysql mysql    8668 Nov 18  2006 horde_tokens.frm
-rw-rw----  1 mysql mysql       0 Nov 18  2006 horde_tokens.MYD
-rw-rw----  1 mysql mysql    1024 Nov 18  2006 horde_tokens.MYI
-rw-rw----  1 mysql mysql    8752 Mar 25  2007 horde_users.frm
-rw-rw----  1 mysql mysql       0 Mar 25  2007 horde_users.MYD
-rw-rw----  1 mysql mysql    1024 Mar 25  2007 horde_users.MYI
-rw-rw----  1 mysql mysql    8802 Nov 18  2006 horde_vfs.frm
-rw-rw----  1 mysql mysql       0 Nov 18  2006 horde_vfs.MYD
-rw-rw----  1 mysql mysql    1024 Nov 18  2006 horde_vfs.MYI
-rw-rw----  1 mysql mysql    9316 Nov 18  2006 kronolith_events.frm
-rw-rw----  1 mysql mysql   43576 Nov 18  2006 kronolith_events.MYD
-rw-rw----  1 mysql mysql   15360 Nov 18  2006 kronolith_events.MYI
-rw-rw----  1 mysql mysql    8556 Nov 18  2006 kronolith_events_seq.frm
-rw-rw----  1 mysql mysql       5 Nov 18  2006 kronolith_events_seq.MYD
-rw-rw----  1 mysql mysql    2048 Nov 18  2006 kronolith_events_seq.MYI
-rw-rw----  1 mysql mysql    8830 Nov 18  2006 mnemo_memos.frm
-rw-rw----  1 mysql mysql    5072 Nov 18  2006 mnemo_memos.MYD
-rw-rw----  1 mysql mysql    3072 Nov 18  2006 mnemo_memos.MYI
-rw-rw----  1 mysql mysql    8966 Nov 18  2006 nag_tasks.frm
-rw-rw----  1 mysql mysql     876 Nov 18  2006 nag_tasks.MYD
-rw-rw----  1 mysql mysql    3072 Nov 18  2006 nag_tasks.MYI
-rw-rw----  1 mysql mysql    9572 Aug 25 06:46 turba_objects.frm
-rw-rw----  1 mysql mysql  792160 Aug 26 15:04 turba_objects.MYD
-rw-rw----  1 mysql mysql  353280 Aug 26 15:04 turba_objects.MYI
[root@mail horde]#

[mrjhb3]

Somehow you are missing a table.  You should have kronolith_events and kronolith_storage

root@www horde]# ls -la kronolith_*
-rw-rw----  1 mysql mysql 9556 Aug 27 20:23 kronolith_events.frm
-rw-rw----  1 mysql mysql    0 Aug 27 20:23 kronolith_events.MYD
-rw-rw----  1 mysql mysql 1024 Aug 27 20:23 kronolith_events.MYI
-rw-rw----  1 mysql mysql 8660 Aug 27 20:23 kronolith_storage.frm
-rw-rw----  1 mysql mysql    0 Aug 27 20:23 kronolith_storage.MYD
-rw-rw----  1 mysql mysql 1024 Aug 27 20:23 kronolith_storage.MYI

Are you sure you didn't have any errors in /var/log/messages after the post-upgrade and reboot?

To get it to work, you can try this;

Code: [Select]

rpm -e kronolith-h3-2.1.8-1.el4.sme smeserver-kronolith-1.1-11.el4.sme       
cd /var/lib/mysql/horde
rm -rf kron*
mysql
flush tables;
exit
yum --enablerepo=smecontribs install smeserver-kronolith
signal-event post-upgrade ; signal-event reboot

When the server reboots, check /var/log/messages for any mysql.init errors

Look in /var/lib/mysql/horde and verify that you have both tables. If you don't maybe you got a bad download.  Then you could do a

Code: [Select]

yum clean all then the above steps again.

I have done this both ways and kronolith continued to work.  Since you haven't been able to add any events, removing the tables shouldn't cause you to lose any calendar data.

This doesn't diagnose how this happened, since you previously stated that you didn't have any log errors, so I am just trying to get it working for you.

John

[tstokovaz]

Progress seems to be made BUT I was getting this error

The free/busy URL for tmgraw@tphorde.org cannot be retrieved.

After removing kronolith, yum clean all, and reinstalling kronolith it seems to be working now. Sends invitations, posts them on all calendars, etc. Not sure what happened except it happened to both the test system and our production server.

I did enable administration and give show, read, edit, delete rights to authenticated and creator users. Guests have only show and read. Not sure what guests are as the only people accessing this will be account holders. I assume it means a guest is someone of our group wanting to look at another's calendar, etc.

ONE QUESTION- This was on my test system that I was able to follow your directions and fix. Will the flush tables, that you suggested impact anything outside kronolith or other, as yet unused items like mnemo,? Ignorant question I realize; just want to be sure I understand what I am doing.  We have really only used the email function on this system to this point - the default setup in SME.

Thank you so much for your help!!!

[mrjhb3]

Since you already had your users created, and there wasn't a previous way of saving the users free/busy info, there is nothing for horde to read.  If your system is up to date, then you should be able to modify a user, and just click save, so that the free/busy info is written into the ldap database.  I haven't done this in a while, but I did test this and it worked for me.  After you modify a user, you can go to the CLI and type slapcat and verify the user's free/busy info is now in the ldap database.

I don't know about your question about the flush tables.  But, you could remove the kronolith tables, install kronolith and smeserver-kronolith, then post-upgrade and reboot as that will stop mysql anyway and should get the tables loaded on the reboot.

John