Re: [DAViCal-general] Upgrade davical on FreeBSD

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

Hi Andrew,

Andrew McMillan wrote:
> On Thu, 2010-01-28 at 09:16 +0100, Matthias Fechner wrote:
>   
>> ok, I executed the commands I checked the session table and it was empty 
>> after it.
>> If I connect to the database via web I see in the errorlog:
>> [Thu Jan 28 08:45:15 2010] [error] [client 88.217.56.106] rscds: WARN: 
>> Login ERR: Other than one session record matches. 0
>>
>> Maybe I forgot something in the restore of data.
>> I execute the copy command on the following tables (in the order it is 
>> shown here):
>> usr
>> caldav_data
>> calendar_item
>> principal
>> property
>> session
>>
>> Maybe something in the database is broken?
>> If you like I can sent a dump of the database to you.
>>     
>
> There are lots more tables than that!  You should restore the whole
> database.
>
>   
sorry, I think you misunderstood me here, I will try to explain more in 
detail, what I did:
1. Deleted the old database
2. Created the database again with the script: dba/create-database.sh 
(version 0.9.8)
3. Loaded my old data (tables above) into my database, the lines look 
like this one (created by pg_dump on the old database):
COPY usr (user_no, active, email_ok, joined, updated, last_used, 
username, password, fullname, email, config_data, date_format_type, 
locale) FROM stdin;
1001    t       \N      2007-12-09 22:29:08.137328+01   \N      
2009-12-29 23:48:01.048109+01   idefix  **foobar Matthias Fechner        
id...@fe...      \N      E       de_DE
\.

I only execute the COPY commands for the tables I mentioned above.

If you see a better way to get my old data into a clear new database 
please let me know.

If I take version 0.9.6.2 to access the new database it works.
If I take version 0.9.8 to access the new database it fails at the login.

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