Preparing for new community release 1.8.004

[Ralf_Becker_Stylite]

I just committed a new community release 1.8.004.

It contains a couple of database schema updates, unlike regular minor
version updates. Unfortunately this cant be helped for the intended
fixes to work. SO YOU HAVE TO VISIT SETUP AND RUN THE OFFERED UPDATES!

The new version contains 3 major parts:

a) backported security features from Trunk:

• more secure password hashing types: sha512_crypt, sha256_crypt
• enable automatic migration to sha512_crypt, if accounts in SQL or LDAP
  (but only on Linux, as OpenLDAP has not native support for it)
• session listing without the need of a listable session directory

b) numerous CalDAV and CardDAV fixes (EGroupware 1.8.004 is now far more
standard compliant then 1.8.002!)

• show calendars and addressbooks selected to sync under user calendar-
  or addressbook-home-set allowing clients to automatic detect them
• CalDAV scheduling support allows clients eg. to show free busy status
  of invited participants
• client can choose the url for new events or contacts (standard
  requirement!)
• allow clients to store attributes (eg. calendar colors) via PROPPATCH
• store unknown attributes (eg. location based alarms) in custom fields
  in InfoLog
• CardDAV works now with LDAP backend
• ability to log and display CalDAV/CardDAV traffic without access to
  commandline of server

–> CalDAV/CardDAV is now recommended over SyncML, which will be no
longer supported in the next major release!

c) many bugfixes in all modules since 1.8.002, see complete list below

==> if you have a svn installation, please update and report you
experiences (daily snapshot from 1. April will also work).

Thanks for helping us testing the new community release.

Here’s now the complete changelog:

• SyncML: re-added accidently removed accounts addressbook

• CalDAV/CardDAV/GroupDAV new user preference to log requests and
  responses to Apache error-log

• wiki: fix SQL for makro WantedPages

• wiki: bugfix for ->fatal error/exception if search is started with no
  searchstring<- now we return everything / all entrys on a missing search
  string

• wiki: bugfix for ->fatal error/exception when inserting new webdav
  links in HTML mode<-

• API: fixed a reported deprecated warning on logout when using CAS

• felamimail: handle IE (8) problem regarding toggling editor modes in
  compose window

• Filemanager: allow WebDAVs (https) via PEAR HTTP_WebDAV_Client

• API/Login: using tabindex to control tab succession on/in loginscreen.

• Calendar/iCal/CalDAV: if no end(-time) is given in iCal we use the
  default lenght from user prefs

• Calendar/iCal/CalDAV: if no end(-time) is given in iCal we use the
  default lenght from user prefs

• Calendar: fixed tz-aliases to NOT use Etc/GMT* but Olson identifiers

• CalDAV: fixed Outlook needs Microsoft specific x-property to recognice
  all-day events as such

• Addressbook/CardDAV: fixed Apple iOS and OS X addressbook messed up
  phone numbers (Mobile is now mobile for both and iPhone is matched to
  EGroupware private cell)

• Addressbook: disable custom field tabs, if contact is stored in LDAP,
  which does not support CFs

• Notifications: fixed not correctly reset timezone after notifying
  users from other timezones

• Filemanager/Admin: ability to check virtual filesystem (Admin >> Check
  virtual filesystem) and some code to prefent double creation of directories

• News: fixed SQL error happening with multiple translations

• PostgreSQL/Setup/EMailAdmin: fixed Setup >> Configuration was not
  storing anything

• timesheet: fixed wrong sum for timesheets;

• InfoLog/CalDAV: fixed wrong timezone used for iCal generation

• Calendar: mail all participants was attaching iCal with wrong time(zone)

• Admin/Addressbook: fixed wrong timezone in created and modified times
  for contacts and accounts

• eMail: fix bug regarding language strings with single quotes in
  Javascript;

• Calendar: update timezones to 2011n from Lightning

• API: fix account-selection-method “selectbox” containing selected
  account double (eg. in Admin >> Manage groups)

• Home: only display apps user has rights to (were not checked for
  calendar, email, infolog, news_admin or if user changes positions on
  home, before gotten app-rights removed)

• Wiki/PostgreSQL: whitespace before database-type caused creation of
  index on egw_wiki_pages.wiki_body limiting article length to 32k -->
  re-install wiki or drop index egw_wiki_pages_body

• SiteMgr: fixed every block had identical id=“Mod” validation error

• SiteMgr: remove CKeditor SCAYT (spell-check-as-you-type) tags, which
  dont validate

• SiteMgr: properly escape block-titles containing special chars

• SiteMgr: allow to set meta description on category level by using
  {description} tag instead of {slogan} or {sitedesc}, proper escaping of
  all placeholders

• Projectmanager: add /usr/share/fonts to open_basedir to allow JpGraph
  for ganttchars access to default font location

• Admin: fixed import of already hashed passwords

• Update to 1.8.004: REQUIRES TO VISIT SETUP for schema updates

• CalDAV: implemented calendar proxy support and cleaned up principals tree

• GroupDAV/KDE assume KDE 4.7+ uses native Akonadi resource, while below
  pre-Akonadi GroupDAV resource is used: unfortunately both have
  contradicting requirements

• CalDAV/GroupDAV/InfoLog: making synced InfoLog types configurable and
  moved getctag method to infolog_bo in preparation of InfoLog eSync support

• CalDAV: no METHOD:PUBLISH for CalDAV outside the inbox

• CalDAV/CardDAV/GroupDAV new user preference to log requests and
  responses to Apache error-log

• Addressbook/CardDAV: Add index for contact_modified to improve
  performance of ctag generation on big installtions

• CardDAV: Hack for iOS 5.0.1 addressbook to stop asking directory
  gateway permissions with depth=1, which might fail on installs with huge
  addressbooks

• CalDAV/CardDAV: show addressbooks/calendars selected to sync in prefs
  under users addressbook-/calendar-home-set (incl. account addressbook,
  if enabled)

• CalDAV/CardDAV: /addressbook-accounts/ and PROPPATCH for
  addressbooks/calendars for every namespace but CalDAV, CardDAV or
  Calendarserver (displayname or *-describtion are ok)

• CalDAV: allow to create private events on OS X iCal, fixing DAV header
  for new shared folders

• CalDAV/CardDAV: continous display (like tail -f) of logs inside EGroupware

• CalDAV/CardDAV/GroupDAV: as all clients dislike not getting an ETag
  for a PUT, we sending it again even not storing byte-by-byte

• CalDAV/CardDAV: fixed typo preventing sync, if logging to Apache
  error-log was switched on

• CardDAV/GroupDAV/Addressbook: do NOT check for api version, as it
  caused accounts created during setup to have no carddav_name and
  therefore fail in CardDAV/GroupDAV (shown as “/addressbook/” in
  collection list!)

• CardDAV/GroupDAV/Addressbook: do NOT check for api version, as it
  caused accounts created during setup to have no carddav_name and
  therefore fail in CardDAV/GroupDAV (shown as “/addressbook/” in
  collection list!)

• CardDAV: fixed sometimes not working creation of new contacts from the
  device, if accounts are stored in LDAP

• CalDAV/CardDAV: /addressbook-accounts/ and PROPPATCH for
  addressbooks/calendars for every namespace but CalDAV, CardDAV or
  Calendarserver (displayname or *-describtion are ok)

• Addressbook/CardDAV: fixed Apple iOS and OS X addressbook messed up
  phone numbers (Mobile is now mobile for both and iPhone is matched to
  EGroupware private cell)

• Addressbook/CardDAV: fixed sync all in one addressbook changed AB to
  personal, use default addressbook for new contacts if synced, otherwise
  use always synced personal AB

• CardDAV/Addressbook: storing Apple AB type company
  (X-ABShowAs:COMPANY) as EGroupware fileAs company

• CardDAV/GroupDAV/Addressbook: works now with LDAP backend (account
  only or all contacts), fixed not working update of accounts (SQL and
  LDAP), changed ctag generation to work with LDAP too

• CalDAV/GroupDAV: return empty collection, as iCal under iOS 5 had
  problems with returning “404 Not found” status

• CalDAV: no METHOD:PUBLISH for CalDAV outside the inbox

• CalDAV: fixed wrong VTIMEZONE component generated (has to be in UTC),
  probably fixes bug #2984: Problem with VTIMEZONE component generated for NZ

• CalDAV: fixed group-invitations got lost (urn:uuid url lost one char
  with each new import)

• Calendar/iCal/CalDAV: if no end(-time) is given in iCal we use the
  default lenght from user prefs

• CalDAV: fixed Outlook needs Microsoft specific x-property to recognice
  all-day events as such

• CalDAV: allow to create private events on OS X iCal, fixing DAV header
  for new shared folders

• Calendar/CalDAV/eSync: fixed etag generation to NOT query maximum
  user-modification date for each entry, fixed etag and ctag for eSync to
  only use recurance master, as ActiveSync event does not contain extra
  participant data for exceptions (virtual and real)

• CalDAV/GroupDAV/InfoLog: making synced InfoLog types configurable and
  moved getctag method to infolog_bo in preparation of InfoLog eSync support

• CalDAV/GroupDAV/InfoLog: making synced InfoLog types configurable and
  moved getctag method to infolog_bo in preparation of InfoLog eSync support

• CalDAV/GroupDAV: return empty collection, as iCal under iOS 5 had
  problems with returning “404 Not found” status

• CalDAV: no METHOD:PUBLISH for CalDAV outside the inbox

• CalDAV: fixed wrong VTIMEZONE component generated (has to be in UTC),
  probably fixes bug #2984: Problem with VTIMEZONE component generated for NZ

• InfoLog/CalDAV: allow updates with implicite rights of responsible
  user, InfoLog type is kept on update, deduct not set status of client
  from completed(-percent)

• InfoLog/CalDAV: fixed sub-entries created in WebGUI got identical
  caldav_name as parent and therefore updates of sub-entries did not work
  as expected

• InfoLog/CalDAV: fixed wrong timezone used for iCal generation

• InfoLog/CalDAV: fixed not working toggeling of completed from iOS
  reminder app (only sets COMPLETED, but never STATUS or PERCENT-COMPLETED)

Happy testing

Ralf

Ralf Becker
Director Software Development

Stylite AG

Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

---

This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

[ChristophK]

Hi,

in lightning currently Groupdav produces an Database Error:

[02-Apr-2012 11:14:01] Database error: db::column_data_implode(’ AND ',Array
(
[session_php] => 2977aa7a00e4a8c71b443a45aca94f1f
)
,‘1’,

Array

(

[sessionid] => Array

(

[type] => char

[precision] => 128

[nullable] =>

)
[loginid] => Array
    (
        [type] => varchar
        [precision] => 64
        [nullable] =>
    )

[ip] => Array
    (
        [type] => varchar
        [precision] => 40
        [nullable] =>
    )

[li] => Array
    (
        [type] => int
        [precision] => 4
        [nullable] =>
    )

[lo] => Array
    (
        [type] => int
        [precision] => 4
        [default] => 0
    )

[account_id] => Array
    (
        [type] => int
        [precision] => 4
        [nullable] =>
        [default] => 0
    )

)

nothing known about column 'session_php'! [02-Apr-2012 11:14:01] #0 /raid/www/htdocs/egroupware/phpgwapi/inc/class.egw_db.inc.php(1534): egw_db->halt('db::column_data...') [02-Apr-2012 11:14:01] #1 /raid/www/htdocs/egroupware/phpgwapi/inc/class.egw_db.inc.php(2001): egw_db->column_data_implode(' AND ', Array, true, false, Array) [02-Apr-2012 11:14:01] #2 /raid/www/htdocs/egroupware/phpgwapi/inc/class.egw_session.inc.php(994): egw_db->select('egw_access_log', 'sessionid', Array, 994, '/raid/www/htdoc...') [02-Apr-2012 11:14:01] #3 /raid/www/htdocs/egroupware/phpgwapi/inc/class.egw.inc.php(294): egw_session->verify() [02-Apr-2012 11:14:01] #4 /raid/www/htdocs/egroupware/phpgwapi/inc/class.egw.inc.php(234): egw->verify_session() [02-Apr-2012 11:14:01] #5 /raid/www/htdocs/egroupware/phpgwapi/inc/functions.inc.php(87): egw->wakeup2() [02-Apr-2012 11:14:01] #6 /raid/www/htdocs/egroupware/header.inc.php(118): require_once('/raid/www/htdoc...') [02-Apr-2012 11:14:01] #7 /raid/www/htdocs/egroupware/groupdav.php(39): include('/raid/www/htdoc...') [02-Apr-2012 11:14:01] #8 {main}

Christoph

I just committed a new community release 1.8.004.

It contains a couple of database schema updates, unlike regular minor
version updates. Unfortunately this cant be helped for the intended
fixes to work. SO YOU HAVE TO VISIT SETUP AND RUN THE OFFERED UPDATES!

The new version contains 3 major parts:

a) backported security features from Trunk:

• more secure password hashing types: sha512_crypt, sha256_crypt
• enable automatic migration to sha512_crypt, if accounts in SQL or LDAP
  (but only on Linux, as OpenLDAP has not native support for it)
• session listing without the need of a listable session directory

b) numerous CalDAV and CardDAV fixes (EGroupware 1.8.004 is now far more
standard compliant then 1.8.002!)

• show calendars and addressbooks selected to sync under user calendar-
  or addressbook-home-set allowing clients to automatic detect them
• CalDAV scheduling support allows clients eg. to show free busy status
  of invited participants
• client can choose the url for new events or contacts (standard
  requirement!)
• allow clients to store attributes (eg. calendar colors) via PROPPATCH
• store unknown attributes (eg. location based alarms) in custom fields
  in InfoLog
• CardDAV works now with LDAP backend
• ability to log and display CalDAV/CardDAV traffic without access to
  commandline of server

–> CalDAV/CardDAV is now recommended over SyncML, which will be no
longer supported in the next major release!

c) many bugfixes in all modules since 1.8.002, see complete list below

==> if you have a svn installation, please update and report you
experiences (daily snapshot from 1. April will also work).

Thanks for helping us testing the new community release.

Here’s now the complete changelog:

• SyncML: re-added accidently removed accounts addressbook

• CalDAV/CardDAV/GroupDAV new user preference to log requests and
  responses to Apache error-log

• wiki: fix SQL for makro WantedPages

• wiki: bugfix for ->fatal error/exception if search is started with no
  searchstring<- now we return everything / all entrys on a missing search
  string

• wiki: bugfix for ->fatal error/exception when inserting new webdav
  links in HTML mode<-

• API: fixed a reported deprecated warning on logout when using CAS

• felamimail: handle IE (8) problem regarding toggling editor modes in
  compose window

• Filemanager: allow WebDAVs (https) via PEAR HTTP_WebDAV_Client

• API/Login: using tabindex to control tab succession on/in loginscreen.

• Calendar/iCal/CalDAV: if no end(-time) is given in iCal we use the
  default lenght from user prefs

• Calendar/iCal/CalDAV: if no end(-time) is given in iCal we use the
  default lenght from user prefs

• Calendar: fixed tz-aliases to NOT use Etc/GMT* but Olson identifiers

• CalDAV: fixed Outlook needs Microsoft specific x-property to recognice
  all-day events as such

• Addressbook/CardDAV: fixed Apple iOS and OS X addressbook messed up
  phone numbers (Mobile is now mobile for both and iPhone is matched to
  EGroupware private cell)

• Addressbook: disable custom field tabs, if contact is stored in LDAP,
  which does not support CFs

• Notifications: fixed not correctly reset timezone after notifying
  users from other timezones

• Filemanager/Admin: ability to check virtual filesystem (Admin >> Check
  virtual filesystem) and some code to prefent double creation of directories

• News: fixed SQL error happening with multiple translations

• PostgreSQL/Setup/EMailAdmin: fixed Setup >> Configuration was not
  storing anything

• timesheet: fixed wrong sum for timesheets;

• InfoLog/CalDAV: fixed wrong timezone used for iCal generation

• Calendar: mail all participants was attaching iCal with wrong time(zone)

• Admin/Addressbook: fixed wrong timezone in created and modified times
  for contacts and accounts

• eMail: fix bug regarding language strings with single quotes in
  Javascript;

• Calendar: update timezones to 2011n from Lightning

• API: fix account-selection-method “selectbox” containing selected
  account double (eg. in Admin >> Manage groups)

• Home: only display apps user has rights to (were not checked for
  calendar, email, infolog, news_admin or if user changes positions on
  home, before gotten app-rights removed)

• Wiki/PostgreSQL: whitespace before database-type caused creation of
  index on egw_wiki_pages.wiki_body limiting article length to 32k -->
  re-install wiki or drop index egw_wiki_pages_body

• SiteMgr: fixed every block had identical id=“Mod” validation error

• SiteMgr: remove CKeditor SCAYT (spell-check-as-you-type) tags, which
  dont validate

• SiteMgr: properly escape block-titles containing special chars

• SiteMgr: allow to set meta description on category level by using
  {description} tag instead of {slogan} or {sitedesc}, proper escaping of
  all placeholders

• Projectmanager: add /usr/share/fonts to open_basedir to allow JpGraph
  for ganttchars access to default font location

• Admin: fixed import of already hashed passwords

• Update to 1.8.004: REQUIRES TO VISIT SETUP for schema updates

• CalDAV: implemented calendar proxy support and cleaned up principals tree

• GroupDAV/KDE assume KDE 4.7+ uses native Akonadi resource, while below
  pre-Akonadi GroupDAV resource is used: unfortunately both have
  contradicting requirements

• CalDAV/GroupDAV/InfoLog: making synced InfoLog types configurable and
  moved getctag method to infolog_bo in preparation of InfoLog eSync support

• CalDAV: no METHOD:PUBLISH for CalDAV outside the inbox

• CalDAV/CardDAV/GroupDAV new user preference to log requests and
  responses to Apache error-log

• Addressbook/CardDAV: Add index for contact_modified to improve
  performance of ctag generation on big installtions

• CardDAV: Hack for iOS 5.0.1 addressbook to stop asking directory
  gateway permissions with depth=1, which might fail on installs with huge
  addressbooks

• CalDAV/CardDAV: show addressbooks/calendars selected to sync in prefs
  under users addressbook-/calendar-home-set (incl. account addressbook,
  if enabled)

• CalDAV/CardDAV: /addressbook-accounts/ and PROPPATCH for
  addressbooks/calendars for every namespace but CalDAV, CardDAV or
  Calendarserver (displayname or *-describtion are ok)

• CalDAV: allow to create private events on OS X iCal, fixing DAV header
  for new shared folders

• CalDAV/CardDAV: continous display (like tail -f) of logs inside EGroupware

• CalDAV/CardDAV/GroupDAV: as all clients dislike not getting an ETag
  for a PUT, we sending it again even not storing byte-by-byte

• CalDAV/CardDAV: fixed typo preventing sync, if logging to Apache
  error-log was switched on

• CardDAV/GroupDAV/Addressbook: do NOT check for api version, as it
  caused accounts created during setup to have no carddav_name and
  therefore fail in CardDAV/GroupDAV (shown as “/addressbook/” in
  collection list!)

• CardDAV/GroupDAV/Addressbook: do NOT check for api version, as it
  caused accounts created during setup to have no carddav_name and
  therefore fail in CardDAV/GroupDAV (shown as “/addressbook/” in
  collection list!)

• CardDAV: fixed sometimes not working creation of new contacts from the
  device, if accounts are stored in LDAP

• CalDAV/CardDAV: /addressbook-accounts/ and PROPPATCH for
  addressbooks/calendars for every namespace but CalDAV, CardDAV or
  Calendarserver (displayname or *-describtion are ok)

• Addressbook/CardDAV: fixed Apple iOS and OS X addressbook messed up
  phone numbers (Mobile is now mobile for both and iPhone is matched to
  EGroupware private cell)

• Addressbook/CardDAV: fixed sync all in one addressbook changed AB to
  personal, use default addressbook for new contacts if synced, otherwise
  use always synced personal AB

• CardDAV/Addressbook: storing Apple AB type company
  (X-ABShowAs:COMPANY) as EGroupware fileAs company

• CardDAV/GroupDAV/Addressbook: works now with LDAP backend (account
  only or all contacts), fixed not working update of accounts (SQL and
  LDAP), changed ctag generation to work with LDAP too

• CalDAV/GroupDAV: return empty collection, as iCal under iOS 5 had
  problems with returning “404 Not found” status

• CalDAV: no METHOD:PUBLISH for CalDAV outside the inbox

• CalDAV: fixed wrong VTIMEZONE component generated (has to be in UTC),
  probably fixes bug #2984: Problem with VTIMEZONE component generated for NZ

• CalDAV: fixed group-invitations got lost (urn:uuid url lost one char
  with each new import)

• Calendar/iCal/CalDAV: if no end(-time) is given in iCal we use the
  default lenght from user prefs

• CalDAV: fixed Outlook needs Microsoft specific x-property to recognice
  all-day events as such

• CalDAV: allow to create private events on OS X iCal, fixing DAV header
  for new shared folders

• Calendar/CalDAV/eSync: fixed etag generation to NOT query maximum
  user-modification date for each entry, fixed etag and ctag for eSync to
  only use recurance master, as ActiveSync event does not contain extra
  participant data for exceptions (virtual and real)

• CalDAV/GroupDAV/InfoLog: making synced InfoLog types configurable and
  moved getctag method to infolog_bo in preparation of InfoLog eSync support

• CalDAV/GroupDAV/InfoLog: making synced InfoLog types configurable and
  moved getctag method to infolog_bo in preparation of InfoLog eSync support

• CalDAV/GroupDAV: return empty collection, as iCal under iOS 5 had
  problems with returning “404 Not found” status

• CalDAV: no METHOD:PUBLISH for CalDAV outside the inbox

• CalDAV: fixed wrong VTIMEZONE component generated (has to be in UTC),
  probably fixes bug #2984: Problem with VTIMEZONE component generated for NZ

• InfoLog/CalDAV: allow updates with implicite rights of responsible
  user, InfoLog type is kept on update, deduct not set status of client
  from completed(-percent)

• InfoLog/CalDAV: fixed sub-entries created in WebGUI got identical
  caldav_name as parent and therefore updates of sub-entries did not work
  as expected

• InfoLog/CalDAV: fixed wrong timezone used for iCal generation

• InfoLog/CalDAV: fixed not working toggeling of completed from iOS
  reminder app (only sets COMPLETED, but never STATUS or PERCENT-COMPLETED)

Happy testing

Ralf

---

This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

[Ralf_Becker_Stylite]

Hi Christoph,

you missed to run db-schema updates via setup (or your Lightning still
uses a session from before the update, eg. empty your session directory).

Ralf

Hi,

in lightning currently Groupdav produces an Database Error:

[02-Apr-2012 11:14:01] Database error: db::column_data_implode(’ AND ',Array
(
[session_php] => 2977aa7a00e4a8c71b443a45aca94f1f
)
,‘1’,

Array

(

[sessionid] =>  Array

(

[type] =>  char

[precision] =>  128

[nullable] =>

)
 [loginid] =>  Array
     (
         [type] =>  varchar
         [precision] =>  64
         [nullable] =>
     )

 [ip] =>  Array
     (
         [type] =>  varchar
         [precision] =>  40
         [nullable] =>
     )

 [li] =>  Array
     (
         [type] =>  int
         [precision] =>  4
         [nullable] =>
     )

 [lo] =>  Array
     (
         [type] =>  int
         [precision] =>  4
         [default] =>  0
     )

 [account_id] =>  Array
     (
         [type] =>  int
         [precision] =>  4
         [nullable] =>
         [default] =>  0
     )

)

nothing known about column 'session_php'! [02-Apr-2012 11:14:01] #0 /raid/www/htdocs/egroupware/phpgwapi/inc/class.egw_db.inc.php(1534): egw_db->halt('db::column_data...') [02-Apr-2012 11:14:01] #1 /raid/www/htdocs/egroupware/phpgwapi/inc/class.egw_db.inc.php(2001): egw_db->column_data_implode(' AND ', Array, true, false, Array) [02-Apr-2012 11:14:01] #2 /raid/www/htdocs/egroupware/phpgwapi/inc/class.egw_session.inc.php(994): egw_db->select('egw_access_log', 'sessionid', Array, 994, '/raid/www/htdoc...') [02-Apr-2012 11:14:01] #3 /raid/www/htdocs/egroupware/phpgwapi/inc/class.egw.inc.php(294): egw_session->verify() [02-Apr-2012 11:14:01] #4 /raid/www/htdocs/egroupware/phpgwapi/inc/class.egw.inc.php(234): egw->verify_session() [02-Apr-2012 11:14:01] #5 /raid/www/htdocs/egroupware/phpgwapi/inc/functions.inc.php(87): egw->wakeup2() [02-Apr-2012 11:14:01] #6 /raid/www/htdocs/egroupware/header.inc.php(118): require_once('/raid/www/htdoc...') [02-Apr-2012 11:14:01] #7 /raid/www/htdocs/egroupware/groupdav.php(39): include('/raid/www/htdoc...') [02-Apr-2012 11:14:01] #8 {main}

Christoph

I just committed a new community release 1.8.004.

It contains a couple of database schema updates, unlike regular minor
version updates. Unfortunately this cant be helped for the intended
fixes to work. SO YOU HAVE TO VISIT SETUP AND RUN THE OFFERED UPDATES!

The new version contains 3 major parts:

a) backported security features from Trunk:

• more secure password hashing types: sha512_crypt, sha256_crypt
• enable automatic migration to sha512_crypt, if accounts in SQL or LDAP
  (but only on Linux, as OpenLDAP has not native support for it)
• session listing without the need of a listable session directory

b) numerous CalDAV and CardDAV fixes (EGroupware 1.8.004 is now far more
standard compliant then 1.8.002!)

• show calendars and addressbooks selected to sync under user calendar-
  or addressbook-home-set allowing clients to automatic detect them
• CalDAV scheduling support allows clients eg. to show free busy status
  of invited participants
• client can choose the url for new events or contacts (standard
  requirement!)
• allow clients to store attributes (eg. calendar colors) via PROPPATCH
• store unknown attributes (eg. location based alarms) in custom fields
  in InfoLog
• CardDAV works now with LDAP backend
• ability to log and display CalDAV/CardDAV traffic without access to
  commandline of server

–> CalDAV/CardDAV is now recommended over SyncML, which will be no
longer supported in the next major release!

c) many bugfixes in all modules since 1.8.002, see complete list below

==> if you have a svn installation, please update and report you
experiences (daily snapshot from 1. April will also work).

Thanks for helping us testing the new community release.

Here’s now the complete changelog:

• SyncML: re-added accidently removed accounts addressbook

• CalDAV/CardDAV/GroupDAV new user preference to log requests and
  responses to Apache error-log

• wiki: fix SQL for makro WantedPages

• wiki: bugfix for ->fatal error/exception if search is started with no
  searchstring<- now we return everything / all entrys on a missing search
  string

• wiki: bugfix for ->fatal error/exception when inserting new webdav
  links in HTML mode<-

• API: fixed a reported deprecated warning on logout when using CAS

• felamimail: handle IE (8) problem regarding toggling editor modes in
  compose window

• Filemanager: allow WebDAVs (https) via PEAR HTTP_WebDAV_Client

• API/Login: using tabindex to control tab succession on/in loginscreen.

• Calendar/iCal/CalDAV: if no end(-time) is given in iCal we use the
  default lenght from user prefs

• Calendar/iCal/CalDAV: if no end(-time) is given in iCal we use the
  default lenght from user prefs

• Calendar: fixed tz-aliases to NOT use Etc/GMT* but Olson identifiers

• CalDAV: fixed Outlook needs Microsoft specific x-property to recognice
  all-day events as such

• Addressbook/CardDAV: fixed Apple iOS and OS X addressbook messed up
  phone numbers (Mobile is now mobile for both and iPhone is matched to
  EGroupware private cell)

• Addressbook: disable custom field tabs, if contact is stored in LDAP,
  which does not support CFs

• Notifications: fixed not correctly reset timezone after notifying
  users from other timezones

• Filemanager/Admin: ability to check virtual filesystem (Admin>> Check
  virtual filesystem) and some code to prefent double creation of directories

• News: fixed SQL error happening with multiple translations

• PostgreSQL/Setup/EMailAdmin: fixed Setup>> Configuration was not
  storing anything

• timesheet: fixed wrong sum for timesheets;

• InfoLog/CalDAV: fixed wrong timezone used for iCal generation

• Calendar: mail all participants was attaching iCal with wrong time(zone)

• Admin/Addressbook: fixed wrong timezone in created and modified times
  for contacts and accounts

• eMail: fix bug regarding language strings with single quotes in
  Javascript;

• Calendar: update timezones to 2011n from Lightning

• API: fix account-selection-method “selectbox” containing selected
  account double (eg. in Admin>> Manage groups)

• Home: only display apps user has rights to (were not checked for
  calendar, email, infolog, news_admin or if user changes positions on
  home, before gotten app-rights removed)

• Wiki/PostgreSQL: whitespace before database-type caused creation of
  index on egw_wiki_pages.wiki_body limiting article length to 32k -->
  re-install wiki or drop index egw_wiki_pages_body

• SiteMgr: fixed every block had identical id=“Mod” validation error

• SiteMgr: remove CKeditor SCAYT (spell-check-as-you-type) tags, which
  dont validate

• SiteMgr: properly escape block-titles containing special chars

• SiteMgr: allow to set meta description on category level by using
  {description} tag instead of {slogan} or {sitedesc}, proper escaping of
  all placeholders

• Projectmanager: add /usr/share/fonts to open_basedir to allow JpGraph
  for ganttchars access to default font location

• Admin: fixed import of already hashed passwords

• Update to 1.8.004: REQUIRES TO VISIT SETUP for schema updates

• CalDAV: implemented calendar proxy support and cleaned up principals tree

• GroupDAV/KDE assume KDE 4.7+ uses native Akonadi resource, while below
  pre-Akonadi GroupDAV resource is used: unfortunately both have
  contradicting requirements

• CalDAV/GroupDAV/InfoLog: making synced InfoLog types configurable and
  moved getctag method to infolog_bo in preparation of InfoLog eSync support

• CalDAV: no METHOD:PUBLISH for CalDAV outside the inbox

• CalDAV/CardDAV/GroupDAV new user preference to log requests and
  responses to Apache error-log

• Addressbook/CardDAV: Add index for contact_modified to improve
  performance of ctag generation on big installtions

• CardDAV: Hack for iOS 5.0.1 addressbook to stop asking directory
  gateway permissions with depth=1, which might fail on installs with huge
  addressbooks

• CalDAV/CardDAV: show addressbooks/calendars selected to sync in prefs
  under users addressbook-/calendar-home-set (incl. account addressbook,
  if enabled)

• CalDAV/CardDAV: /addressbook-accounts/ and PROPPATCH for
  addressbooks/calendars for every namespace but CalDAV, CardDAV or
  Calendarserver (displayname or *-describtion are ok)

• CalDAV: allow to create private events on OS X iCal, fixing DAV header
  for new shared folders

• CalDAV/CardDAV: continous display (like tail -f) of logs inside EGroupware

• CalDAV/CardDAV/GroupDAV: as all clients dislike not getting an ETag
  for a PUT, we sending it again even not storing byte-by-byte

• CalDAV/CardDAV: fixed typo preventing sync, if logging to Apache
  error-log was switched on

• CardDAV/GroupDAV/Addressbook: do NOT check for api version, as it
  caused accounts created during setup to have no carddav_name and
  therefore fail in CardDAV/GroupDAV (shown as “/addressbook/” in
  collection list!)

• CardDAV/GroupDAV/Addressbook: do NOT check for api version, as it
  caused accounts created during setup to have no carddav_name and
  therefore fail in CardDAV/GroupDAV (shown as “/addressbook/” in
  collection list!)

• CardDAV: fixed sometimes not working creation of new contacts from the
  device, if accounts are stored in LDAP

• CalDAV/CardDAV: /addressbook-accounts/ and PROPPATCH for
  addressbooks/calendars for every namespace but CalDAV, CardDAV or
  Calendarserver (displayname or *-describtion are ok)

• Addressbook/CardDAV: fixed Apple iOS and OS X addressbook messed up
  phone numbers (Mobile is now mobile for both and iPhone is matched to
  EGroupware private cell)

• Addressbook/CardDAV: fixed sync all in one addressbook changed AB to
  personal, use default addressbook for new contacts if synced, otherwise
  use always synced personal AB

• CardDAV/Addressbook: storing Apple AB type company
  (X-ABShowAs:COMPANY) as EGroupware fileAs company

• CardDAV/GroupDAV/Addressbook: works now with LDAP backend (account
  only or all contacts), fixed not working update of accounts (SQL and
  LDAP), changed ctag generation to work with LDAP too

• CalDAV/GroupDAV: return empty collection, as iCal under iOS 5 had
  problems with returning “404 Not found” status

• CalDAV: no METHOD:PUBLISH for CalDAV outside the inbox

• CalDAV: fixed wrong VTIMEZONE component generated (has to be in UTC),
  probably fixes bug #2984: Problem with VTIMEZONE component generated for NZ

• CalDAV: fixed group-invitations got lost (urn:uuid url lost one char
  with each new import)

• Calendar/iCal/CalDAV: if no end(-time) is given in iCal we use the
  default lenght from user prefs

• CalDAV: fixed Outlook needs Microsoft specific x-property to recognice
  all-day events as such

• CalDAV: allow to create private events on OS X iCal, fixing DAV header
  for new shared folders

• Calendar/CalDAV/eSync: fixed etag generation to NOT query maximum
  user-modification date for each entry, fixed etag and ctag for eSync to
  only use recurance master, as ActiveSync event does not contain extra
  participant data for exceptions (virtual and real)

• CalDAV/GroupDAV/InfoLog: making synced InfoLog types configurable and
  moved getctag method to infolog_bo in preparation of InfoLog eSync support

• CalDAV/GroupDAV/InfoLog: making synced InfoLog types configurable and
  moved getctag method to infolog_bo in preparation of InfoLog eSync support

• CalDAV/GroupDAV: return empty collection, as iCal under iOS 5 had
  problems with returning “404 Not found” status

• CalDAV: no METHOD:PUBLISH for CalDAV outside the inbox

• CalDAV: fixed wrong VTIMEZONE component generated (has to be in UTC),
  probably fixes bug #2984: Problem with VTIMEZONE component generated for NZ

• InfoLog/CalDAV: allow updates with implicite rights of responsible
  user, InfoLog type is kept on update, deduct not set status of client
  from completed(-percent)

• InfoLog/CalDAV: fixed sub-entries created in WebGUI got identical
  caldav_name as parent and therefore updates of sub-entries did not work
  as expected

• InfoLog/CalDAV: fixed wrong timezone used for iCal generation

• InfoLog/CalDAV: fixed not working toggeling of completed from iOS
  reminder app (only sets COMPLETED, but never STATUS or PERCENT-COMPLETED)

Happy testing

Ralf

---

This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

–
Ralf Becker
Director Software Development

Stylite AG

Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

---

This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers