Re: Zidestore problems after upgrading OGo

> we are running an OGo server with the following specs:
> OS: Debian Sarge
> OGo: Opengroupware 1.0
> OGo-Repository: opengroupware-1.0beta.2-rock
> Database: Postgresql 7.4.7
> Webserver: Apache2 2.0.54
> and LDAP for the authentification.
> Now we want to upgrade the Debian System and the OGo Version. The specs of the 
> new server are:
> OS: Debian Etch
> OGo: Opengroupware1.1 (svn2106)
> OGo-Repository: http://download.opengroupware.og/nightly/packages/debian
> Database: Postgresql 7.5.22
> Webserver: Apache2 2.2.3
> First I backuped the old OGo server:
> 1. copy the folders .libFoundation, news_images, documents, skyfs    
>     from /var/lib/opengroupware.org
> 2. Backup the old database
>     # pg_dump -Ft -f /tmp/OGoBackup.tar -U postgres ogo
> Then I restored the backup on the new server:
> 1. copy the 4 folders to /var/lib/opengroupware.org (removed the existing ones 
> first)
> 2. drop the existing ogo database
> 3. created a new ogo database
> 4. restored the backup of the old database:
>     # pg_restore --verbose --dbname=ogo OGoBackup.tar

Did you convert your LATIN-1 database to UTF-8?  That is required when
moving from 1.0 to trunk.  See the PostgreSQL chapter of WMOGAG.

> I activated these debug options in NSGlobalDomain.plist:
>     PGDebugEnabled = Yes;
>     WOHttpAdaptor_LogStream = Yes;
> This is what shows in the zidestore.log file:
> <?xml version="1.0" encoding="utf-8" ?><D:propfind 
> xmlns:D="DAV:"><D:prop><D:creationdate/><D:getcontentlength/><D:displayname/>
> <D:source/><D:getcontentlanguage/><D:getcontenttype/><D:executable/><D:getlastmodified/>
> <D:getetag/><D:supportedlock/><D:lockdiscovery/><D:resourcetype/></D:prop></D:propfind>
> Aug 29 09:35:54 ogo-zidestore-1.5 [2499]: PostgreSQL72 connection established: 
> <0x0x8395ebc[PGConnection]:  connection=0x0x849e7a8>
> Aug 29 09:35:54 ogo-zidestore-1.5 [2499]: PostgreSQL72 channel 0x0x83e39b4 
> opened (connection=<0x0x8395ebc[PGConnection]:  connection=0x0x849e7a8>)
> Aug 29 09:35:55 ogo-zidestore-1.5 [2499]: PG0x0x866101c SQL: BEGIN TRANSACTION
> Aug 29 09:35:55 ogo-zidestore-1.5 [2499]: PG0x0x866101c SQL: SELECT 
> t1.anniversary, t1.assistant_name, t1.associated_categories, 
> t1.associated_company, t1.associated_contacts, t1.birthday, t1.boss_name, 
> t1.company_id, t1.contact_id, t1.db_status, t1.degree, t1.department, 
> t1.description, t1.dir_server, t1.email_alias, t1.fileas, t1.firstname, 
> t1.freebusy_url, t1.im_address, t1.pop3_account, t1.is_account, 
> t1.is_customer, t1.is_extra_account, t1.is_intra_account, t1.is_locked, 
> t1.is_person, t1.is_private, t1.is_readonly, t1.is_template_user, 
> t1.keywords, t1.login, t1.middlename, t1.name, t1.name_affix, t1.name_title, 
> t1.number, t1.object_version, t1.occupation, t1.office, t1.owner_id, 
> t1.partner_name, t1.password, t1.priority, t1.salutation, t1.sensitivity, 
> t1.sex, t1.show_email2_as, t1.show_email3_as, t1.show_email_as, 
> t1.source_url, t1.template_user_id, t1.url FROM  person t1 WHERE ((1=1) AND 
> (t1.is_account=1)) AND (t1.db_status <> 'archived')
> Aug 29 09:35:55 ogo-zidestore-1.5 [2499]: CmdCtx[tiefert]: couldn't rollback 
> database transaction !
> ### child 2499 (#2) was terminated by signal 6 (uptime=7998s).

This request works for me -

curl --header "Content-Type: text/xml; charset=utf-8" \
     -u adam:************ \
     -X PROPFIND \
     --data-ascii "<?xml version="1.0" encoding="utf-8" ?><D:propfind
xmlns:D="DAV:"><D:prop><D:creationdate/><D:getcontentlength/><D:displayname/><D:source/><D:getcontentlanguage/><D:getcontenttype/><D:executable/><D:getlastmodified/><D:getetag/><D:supportedlock/><D:lockdiscovery/><D:resourcetype/></D:prop></D:propfind>" \
      http://opengroupware.mormail.com/zidestore/so/adam

 - on r2148


-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users