[kronolith] No Data after Migration

[Michael J Rubinsky]

Simon Brereton <simon.brereton at dada.net> wrote:

>> -----Original Message-----
>> From: kronolith-bounces at lists.horde.org [mailto:kronolith-
>> bounces at lists.horde.org] On Behalf Of Jan Schneider
>> Zitat von Simon Brereton <simon.brereton at dada.net>:
>> 
>> >> -----Original Message-----
>> >> From: kronolith-bounces at lists.horde.org [mailto:kronolith-
>> >> bounces at lists.horde.org] On Behalf Of Simon Brereton After
>> installing
>> >> Kronolith 3.0.1 on a clean machine (with Horde 4.0.1), I attempted
>> to
>> >> migrate the data from the hold Horde 3 install like this:
>> >>
>> >>
>> >> Import the horde3 DB and give permissions to the local horde user
>> to
>> >> use it.
>> >>
>> >> mysql -u root -p < /donald/root/horde3.datestamp.sql mysql -u root
>> -p
>> >> -e "grant all privileges on horde3.* to 'horde'@'localhost'
>> >> identified by 'xxxxxxxx';”
>> >> mysql -u root -p
>> >> use horde;
>> >> update kronolith_events set
>> event_creator_id=lower(event_creator_id);
>> >>
>> >>
>> >> In the Horde Configuration tab changed from the clean horde4 DB to
>> >> the imported one.
>> >>
>> >> Horde Configuration – Database
>> >> 	Called the DB horde3 (was previously horde)
>> >>
>> >> Saved the configuration and ran Update DB schema's for all apps
>> which
>> >> worked.  I think this called /usr/bin/horde-db-migrate
>> >>
>> >> After that, I dumped the clean (and empty) DB horde and renamed
>> >> horde3 (the old and now updated one) to horde4.  Then I went back
>> to
>> >> the Horde Configuration tab and changed the name:
>> >>
>> >> Horde Configuration – Database
>> >> 	Called the DB horde4 (was previously horde3)
>> >>
>> >> Now, my address books are fine and have all the data, but the
>> >> calendar data seems to be missing.  However, if I use mysql or
>> >> phpmyadmin I see the kronolith.events has all the events in it.
>> But
>> >> these are not displaying in the calendar.
>> >>
>> >> Creating, editing and deleting new events doesn't seem to be a
>> >> problem.
>> >>
>> >> Have I missed anything (read done something stupid) again?
>> >
>> >
>> > I think I've found it.  In the old schema the calendar_id was the
>> same
>> > as the username/email address.  The new code uses a 22 char
>> > alphanumeric mixed-case string...
>> >
>> > Is that a hash of something so that I can just update that column?
>> 
>> No, it's just a random hash, but such hashes were used in Kronolith 2
>> too, for any calendars but your default calendar.
>
>Right - but right now, that hash is showing up as the default calendar.
>
>To bring back the calendar data I would have to add a new event to each
>calendar, and then replace the current calendar_id (user at domain.com)
>with the hash. (I've tested it and this works).  However, even with my
>limited user-base I'd rather not do that..  Especially if everyone else
>isn't having this issue.

It sounds like either something went wrong for you during share migration, or maybe your not using the share backend that the data is stored in.

--
Mike
Sent from mobile