Re: [DAViCal-general] Upgrade davical on FreeBSD

[Matthias F. <id...@fe...>]

Hi Andrew,

Am 28.01.2010 14:06, schrieb Andrew McMillan:
> No, that's exactly what I thought you had done, and I think it's the
> wrong way to do it :-)
>
> If it did work, it would only work for the same DAViCal version, so why
> do it at all?

the reason why I was forced to go that way was, I tried to upgrade my 
database with the script dba/update-davical-database but it failed, I 
sent there some time ago an email to the list or to your directly, I 
cannot remember.

After that the database was broken completely and I had to use a backup.
But I created my backup only with pg_dump davical and there it seems 
that some parts of the database were not dumped and I failed to restore it.

So I checked my backup file and found that it is filled by normal sql 
commands (sorry I don't know postgres but I was able to load the data 
into a freshly created database, is very similar to other databases).
I think I tried to restore the database with the psql command what I see 
now was the wrong way :)

> If you really want to go back to a re-created database and add to it,
> then do a GET on each calendar and save it to an .ics file, then create
> the new database, and the principals and so forth, and recreate each
> collection from the .ics file you saved.

But I was now able to get the complete caldav server up again with all 
information in it.
What I did was, started iCal and exported every calendar to an .ical file.

I droped the completed davical database and created it freshly.
Created a new user and configured iCal to connect with this user to the 
database (wow a lot of changes on the webinterface). Create the 
calendars with iCal and imported them.
And now it works with iCal, my iPhone and with Lightning, really great!

Thanks a lot for your help Andrew!

Sorry that I cannot help you further with the failed upgrade of my 
database. The old database was removed from my backup rotation.

Thanks
Matthias

-- 

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs, and the universe trying to
produce bigger and better idiots. So far, the universe is winning." --
Rich Cook