Koozali.org: home of the SME Server
Obsolete Releases => SME 7.x Contribs => Topic started by: tstokovaz on August 22, 2008, 04:27:07 PM
-
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.
-
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
-
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.
-
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
-
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]#
-
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;
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 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
-
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!!!
-
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