Server setup log:
22:20:02.425 local KDC set up
22:20:11.512 Beginning setup migration extras
22:20:11.513 Debug mode enabled: NO
22:20:12.643 25 jul. 2012
22:20:12.644 Mac OS X 10.8 (12A269)
22:20:12.644 Server 2.0.23 (12S307)
22:20:12.645 Starting extras with arguments:
--sourceRoot /Library/Server/Previous --targetRoot / --purge 0 --language nl --sourceVersion 10.7.4 --sourceType System
22:20:13.537 Setup extra failed:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/001-migrationExtraServerRestore.pl
RESULT CODE: 1
STDOUT: Did not supply a valid language for the --language parameter, needs to be one of [en|fr|de|ja]
--purge <0 | 1> "1" means remove any files from the old system after you've migrated them, "0" means leave them alone.
--sourceRoot <path> The path to the root of the system to migrate
--sourceType <System | TimeMachine> Gives the type of the migration source, whether it's a runnable system or a
Time Machine backup.
--sourceVersion <ver> The version number of the old system (like 10.6, 10.7 or 10.8). Since we support migration from 10.6-10.8.
--targetRoot <path> The path to the root of the new system.
--language <lang> A language identifier, such as "en." Long running scripts should return a description of what they're doing
("Migrating Open Directory users"), and possibly provide status update messages along the way. These messages
need to be localized (which is not necessarily the server running the migration script).
This argument will identify the Server Assistant language. As an alternative to doing localization yourselves
send them in English, but in case the script will do this it will need this identifier.
STDERR:
22:20:15.312 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/01_PostgreSQLSetup.rb
RESULT CODE: 0
STDOUT:
STDERR:
22:20:38.446 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/05_postgresmigrator.rb
RESULT CODE: 0
STDOUT:
STDERR:
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.
psql:/Library/Server/PostgreSQL/Migration/pg_upgrade_dump_db.sql:3884: WARNING: => is deprecated as an operator name
DETAIL: This name may be disallowed altogether in future versions of PostgreSQL.
22:20:38.480 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/20_nfsconfigmigrator.sh
RESULT CODE: 0
STDOUT:
STDERR:
22:20:38.584 Setup extra failed:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/30-afctlmigrator.pl
RESULT CODE: 1
STDOUT: Did not supply a valid language for the --language parameter, needs to be one of [en|fr|de|ja]
--purge <0 | 1> "1" means remove any files from the old system after you've migrated them, "0" means leave them alone.
--sourceRoot <path> The path to the root of the system to migrate
--sourceType <System | TimeMachine> Gives the type of the migration source, whether it's a runnable system or a
Time Machine backup.
--sourceVersion <ver> The version number of the old system (like 10.5.8 or 10.6). Since we support migration from 10.5, 10.6,
and other 10.7 installs, it's useful to know this information, and it would be easier for me to figure
it out once and pass it on to each script than to have each script have to figure it out itself.
--targetRoot <path> The path to the root of the new system. Pretty much always "/"
--language <lang> A language identifier, such as "en." Long running scripts should return a description of what they're doing
("Migrating Open Directory users"), and possibly provide status update messages along the way.
STDERR:
22:20:38.640 Setup extra failed:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/30-ftpconfigmigrator.pl
RESULT CODE: 1
STDOUT: Did not supply a valid language for the --language parameter, needs to be one of [en|fr|de|ja]
--purge <0 | 1> "1" means remove any files from the old system after you've migrated them, "0" means leave them alone.
--sourceRoot <path> The path to the root of the system to migrate
--sourceType <System | TimeMachine> Gives the type of the migration source, whether it's a runnable system or a
Time Machine backup.
--sourceVersion <ver> The version number of the old system (like 10.6, 10.7 or 10.8). Since we support migration from 10.6, 10.7,
and other 10.8 installs.
--targetRoot <path> The path to the root of the new system.
--language <lang> A language identifier, such as "en." Long running scripts should return a description of what they're doing
("Migrating Open Directory users"), and possibly provide status update messages along the way. These messages
need to be localized (which is not necessarily the server running the migration script).
This argument will identify the Server Assistant language. As an alternative to doing localization yourselves
send them in English, but in case the script will do this it will need this identifier.
STDERR:
22:20:38.740 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/30-ipfwmigrator
RESULT CODE: 0
STDOUT:
STDERR: 2012-07-25 22:20:38.698 30-ipfwmigrator[3245:707] user6Rules == nil path = /Library/Server/Previous//private/etc/ipfilter//ip6fw.conf
2012-07-25 22:20:38.735 30-ipfwmigrator[3245:707] Saving merged rules file...
2012-07-25 22:20:38.737 30-ipfwmigrator[3245:707] Saving merged IPv6 rules file...
22:20:38.798 Setup extra failed:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/30-natconfigmigrator.pl
RESULT CODE: 1
STDOUT: --targetRoot is the key for value /
--sourceRoot is the key for value /Library/Server/Previous
--purge is the key for value 1
--sourceVersion is the key for value 10.7.4
--sourceType is the key for value System
--language is the key for value nl
sourceVersion := 10.7.4
Did not supply a valid language for the --language parameter, needs to be one of [en|fr|de|ja]
--purge <0 | 1> "1" means remove any files from the old system after you've migrated them, "0" means leave them alone.
--sourceRoot <path> The path to the root of the system to migrate
--sourceType <System | TimeMachine> Gives the type of the migration source, whether it's a runnable system or a
Time Machine backup.
--sourceVersion <ver> The version number of the old system (like 10.6 or 10.7). Since we support migration from 10.6, 10.7,
and other 10.8 installs.
--targetRoot <path> The path to the root of the new system.
--language <lang> A language identifier, such as "en." Long running scripts should return a description of what they're doing
("Migrating Open Directory users"), and possibly provide status update messages along the way. These messages
need to be localized (which is not necessarily the server running the migration script).
This argument will identify the Server Assistant language. As an alternative to doing localization yourselves
send them in English, but in case the script will do this it will need this identifier.
STDERR: sh: : No such file or directory
22:20:38.836 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/30-Network-migration.sh
RESULT CODE: 0
STDOUT: NetworkMigration: SourceRoot = "/Library/Server/Previous"
NetworkMigration: TargetRoot = "/"
NetworkMigration: SourceConfigPath = "/Library/Server/Previous/private/etc/nat/autoportmap.plist"
NetworkMigration: TargetConfigLocation = "//Library/Server/Network/Config/"
NetworkMigration: copying "/Library/Server/Previous/private/etc/nat/autoportmap.plist" to "//Library/Server/Network/Config/"
STDERR:
22:20:38.930 Setup extra failed:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/30-serverperflogconfigmigrator.pl
RESULT CODE: 1
STDOUT: Did not supply a valid language for the --language parameter, needs to be one of [en|fr|de|ja]
--purge <0 | 1> "1" means remove any files from the old system after you've migrated them, "0" means leave them alone.
--sourceRoot <path> The path to the root of the system to migrate
--sourceType <System | TimeMachine> Gives the type of the migration source, whether it's a runnable system or a
Time Machine backup.
--sourceVersion <ver> The version number of the old system, 10.7.
--targetRoot <path> The path to the root of the new system.
--language <lang> A language identifier, such as "en." Long running scripts should return a description of what they're doing
("Migrating Open Directory users"), and possibly provide status update messages along the way. These messages
need to be localized (which is not necessarily the server running the migration script).
This argument will identify the Server Assistant language. As an alternative to doing localization yourselves
send them in English, but in case the script will do this it will need this identifier.
STDERR:
22:20:39.036 Setup extra failed:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/30-snmpconfigmigrator.pl
RESULT CODE: 1
STDOUT: Did not supply a valid language for the --language parameter, needs to be one of [en|fr|de|ja]
--purge <0 | 1> "1" means remove any files from the old system after you've migrated them, "0" means leave them alone.
--sourceRoot <path> The path to the root of the system to migrate
--sourceType <System | TimeMachine> Gives the type of the migration source, whether it's a runnable system or a
Time Machine backup.
--sourceVersion <ver> The version number of the old system (like 10.6, 10.7 or 10.8). Since we support migration from 10.6, 10.7,
and other 10.8 installs.
--targetRoot <path> The path to the root of the new system.
--language <lang> A language identifier, such as "en." Long running scripts should return a description of what they're doing
("Migrating Open Directory users"), and possibly provide status update messages along the way. These messages
need to be localized (which is not necessarily the server running the migration script).
This argument will identify the Server Assistant language. As an alternative to doing localization yourselves
send them in English, but in case the script will do this it will need this identifier.
STDERR:
22:20:39.105 Setup extra failed:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/30-xsannotificationsmigrator.pl
RESULT CODE: 1
STDOUT: --targetRoot is the key for value /
--sourceRoot is the key for value /Library/Server/Previous
--purge is the key for value 1
--sourceVersion is the key for value 10.7.4
--sourceType is the key for value System
--language is the key for value nl
sourceVersion := 10.7.4
Did not supply a valid language for the --language parameter, needs to be one of [en|fr|de|ja]
--purge <0 | 1> "1" means remove any files from the old system after you've migrated them, "0" means leave them alone.
--sourceRoot <path> The path to the root of the system to migrate
--sourceType <System | TimeMachine> Gives the type of the migration source, whether it's a runnable system or a
Time Machine backup.
--sourceVersion <ver> The version number of the old system (like 10.6, 10.7 or 10.8). Since we support migration from 10.6, 10.7,
and other 10.8 installs.
--targetRoot <path> The path to the root of the new system.
--language <lang> A language identifier, such as "en." Long running scripts should return a description of what they're doing
("Migrating Open Directory users"), and possibly provide status update messages along the way. These messages
need to be localized (which is not necessarily the server running the migration script).
This argument will identify the Server Assistant language. As an alternative to doing localization yourselves
send them in English, but in case the script will do this it will need this identifier.
STDERR:
22:20:39.184 Setup extra failed:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/50-vpnconfigmigrator.pl
RESULT CODE: 1
STDOUT: Did not supply a valid language for the --language parameter, needs to be one of [en|fr|de|ja]
--purge <0 | 1> "1" means remove any files from the old system after you've migrated them, "0" means leave them alone.
--sourceRoot <path> The path to the root of the system to migrate
--sourceType <System | TimeMachine> Gives the type of the migration source, whether it's a runnable system or a
Time Machine backup.
--sourceVersion <ver> The version number of the old system (like 10.6 or 10.7). Since we support migration from 10.6, 10.7,
and other 10.8 installs.
--targetRoot <path> The path to the root of the new system.
--language <lang> A language identifier, such as "en." Long running scripts should return a description of what they're doing
("Migrating Open Directory users"), and possibly provide status update messages along the way. These messages
need to be localized (which is not necessarily the server running the migration script).
This argument will identify the Server Assistant language. As an alternative to doing localization yourselves
send them in English, but in case the script will do this it will need this identifier.
STDERR:
22:20:39.282 Setup extra failed:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/58_jabbermigrator.pl
RESULT CODE: 1
STDOUT: Did not supply a valid language for the --language parameter, needs to be one of [en|fr|de|ja]
--purge <0 | 1> "1" means remove any files from the old system after you've migrated them, "0" means leave them alone.
--sourceRoot <path> The path to the root of the system to migrate
--sourceType <System | TimeMachine> Gives the type of the migration source, whether it's a runnable system or a
Time Machine backup.
--sourceVersion <ver> The version number of the old system (like 10.6.x or 10.7). Since we support migration from 10.6,
10.7, and other 10.8 installs, it's useful to know this information, and it would be easier for me to figure
it out once and pass it on to each script than to have each script have to figure it out itself.
--targetRoot <path> The path to the root of the new system. Pretty much always "/"
--language <lang> A language identifier, such as "en." Long running scripts should return a description of what they're doing
("Migrating Open Directory users"), and possibly provide status update messages along the way. These messages
need to be localized (which is not necessarily the server running the migration script).
This argument will identify the Server Assistant language. As an alternative to doing localization yourselves
send them in English, but in case the script will do this it will need this identifier.
STDERR:
22:21:06.777 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/58_webconfigmigrator.rb
RESULT CODE: 0
STDOUT:
STDERR:
22:21:06.982 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/60_swupdateconfigmigrator
RESULT CODE: 0
STDOUT: swupdate:upgradeStatus = 0
STDERR:
22:21:07.019 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/62_wikiCreatorMigrator
RESULT CODE: 0
STDOUT:
STDERR:
22:21:07.392 Setup extra failed:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/65_mail_migrator.pl
RESULT CODE: 1
STDOUT: Did not supply a valid language for the --language parameter, needs to be one of [en|fr|de|ja]
--purge <0 | 1> "1" means remove any files from the old system after you've migrated them, "0" means leave them alone.
--sourceRoot <path> The path to the root of the system to migrate
--sourceType <System | TimeMachine> Gives the type of the migration source, whether it's a runnable system or a
Time Machine backup.
--sourceVersion <ver> The version number of the old system (like 10.6.7 or 10.7). Since we support migration from 10.6, 10.7,
and other 10.8 installs.
--targetRoot <path> The path to the root of the new system.
--language <lang> A language identifier, such as "en." Long running scripts should return a description of what they're doing
("Migrating Open Directory users"), and possibly provide status update messages along the way. These messages
need to be localized (which is not necessarily the server running the migration script).
This argument will identify the Server Assistant language. As an alternative to doing localization yourselves
send them in English, but in case the script will do this it will need this identifier.
STDERR:
22:21:09.744 Setup extra failed:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/70_calendarmigrator.py
RESULT CODE: 2
STDOUT:
STDERR: Usage: 70_calendarmigrator.py [options]
70_calendarmigrator.py: error: option --language: invalid choice: 'nl' (choose from 'en', 'fr', 'de', 'ja')
22:21:09.840 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/80-devicemgrmigration.sh
RESULT CODE: 0
STDOUT:
STDERR:
22:21:10.864 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/80_radiusconfigmigrator.pl
RESULT CODE: 0
STDOUT: 80_radiusconfigmigrator.pl: Migrating RADIUS configuration...
80_radiusconfigmigrator.pl: Migrating certificate parameters into eap.conf...
80_radiusconfigmigrator.pl: RADIUS migration complete
STDERR: 80_radiusconfigmigrator.pl: command failed: /usr/sbin/radiusconfig -getconfigxml "/Library/Server/Previous/private/etc/raddb" 1> /var/tmp/radxml.yIzVyI
22:21:11.105 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/95-migrate_netboot.pl
RESULT CODE: 0
STDOUT: 95-migrate_netboot.pl: Migrating DHCP and NetBoot configuration...
95-migrate_netboot.pl: migrating etc/bootpd.plist
95-migrate_netboot.pl: migrating private/tftpboot
95-migrate_netboot.pl: DHCP is disabled for all interfaces
95-migrate_netboot.pl: netboot_enabled not found in bootpd.plist
95-migrate_netboot.pl: DHCP and NetBoot are both disabled in //etc/bootpd.plist: not loading //System/Library/LaunchDaemons/bootps.plist
95-migrate_netboot.pl: DHCP and NetBoot migration complete
STDERR:
22:21:20.592 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/98-wikimigrator.rb
RESULT CODE: 0
STDOUT:
STDERR: Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:61 751b7180 +18ms] -[PGCConnection connect] with [user=collab dbname=collab]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:320 751b7180 +6ms] Executing update [SET bytea_output TO escape]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:320 751b7180 +0ms] Executing update [BEGIN]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +2ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +3ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:148 751b7180 +0ms] Updating schema...
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:233 751b7180 +0ms] Executing query [SELECT * FROM entity_acls WHERE entity_uid_fk = '19A307C1-82BC-45C7-845A-21839FB222C7']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=0/updated=0
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [CSConfig:54 751b7180 +0ms] Reading plist at /Library/Server/Wiki/Config/collabd.plist
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +1ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +32ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/15.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
ALTER TABLE entity ADD COLUMN theme_name varchar;
UPDATE entity_type SET fields = fields || hstore('theme_name', 'themeName') WHERE name = 'com.apple.Entity';
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +2ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
15
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:118 751b7180 +0ms] Executing migration block #16
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:360 751b7180 +0ms] Adding blogGUID to the entity table...
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:233 751b7180 +0ms] Executing query [ALTER TABLE entity ADD COLUMN blog_uid_fk uuid]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:233 751b7180 +0ms] Executing query [UPDATE entity_type SET fields = fields || hstore('blog_uid_fk', 'blogGUID'), field_refs = field_refs || hstore('blogGUID', 'com.apple.entity.Blog') WHERE name = 'com.apple.Entity']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:233 751b7180 +0ms] Executing query [SELECT uid, ownedby_uid_fk FROM entity WHERE is_blog_enabled = true]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=0/updated=0
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
16
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/17.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
ALTER TABLE entity_changesets DROP COLUMN change_delta;
CREATE TABLE user_activity (user_uid_fk uuid NOT NULL, action varchar NOT NULL, entity_uid_fk uuid NOT NULL, entity_revision int NOT NULL, data bytea, action_time timestamp NOT NULL DEFAULT now());
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +37ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
17
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/18.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
ALTER TABLE user_activity ADD parent_uids uuid[];
UPDATE user_activity ua SET parent_uids=(SELECT parent_uids::uuid[] FROM entity WHERE uid=ua.entity_uid_fk);
ALTER TABLE user_activity ALTER parent_uids SET NOT NULL;
CREATE INDEX idx_useractivity_parents ON user_activity(parent_uids);
CREATE INDEX idx_useractivity_user ON user_activity(user_uid_fk);
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +52ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
18
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/19.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
ALTER TABLE entity ADD banner_image_uid_fk uuid;
UPDATE entity_type SET fields = fields || hstore('banner_image_uid_fk','bannerImageGUID'), field_refs = field_refs || hstore('bannerImageGUID', 'com.apple.entity.FileData') WHERE name='com.apple.Entity';
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
19
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/20.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
ALTER TABLE search_index ADD entity_type_fk varchar;
UPDATE search_index SET entity_type_fk=(SELECT entity_type_fk FROM entity WHERE uid=entity_uid_fk);
ALTER TABLE search_index ALTER entity_type_fk SET NOT NULL;
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
20
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/21.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
ALTER TABLE entity ADD container_uid_fk uuid REFERENCES entity(uid);
ALTER TABLE entity DISABLE TRIGGER USER;
UPDATE entity
SET container_uid_fk=(
SELECT e2.uid
FROM entity e2
WHERE e2.uid=ANY(entity.parent_uids::uuid[])
AND e2.entity_type_fk IN ('com.apple.entity.Project', 'com.apple.entity.User', 'com.apple.entity.Blog')
ORDER BY position(e2.uid::text in array_to_string(entity.parent_uids, ',')) DESC
LIMIT 1
) WHERE container_uid_fk IS NULL;
ALTER TABLE entity ENABLE TRIGGER USER;
CREATE INDEX idx_entity_container_uid_fk ON entity(container_uid_fk);
ALTER TABLE user_activity ADD container_uid_fk uuid;
UPDATE user_activity SET container_uid_fk=( SELECT e2.container_uid_fk FROM entity e2 WHERE e2.uid=user_activity.entity_uid_fk ) WHERE container_uid_fk IS NULL;
CREATE INDEX idx_user_activity_container_uid_fk ON user_activity(container_uid_fk);
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +8ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
21
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/22.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
UPDATE entity_type SET fields = fields || hstore('container_uid_fk','containerGUID') WHERE name='com.apple.Entity';
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
22
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/23.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
CREATE OR REPLACE FUNCTION trg_update_entity_parents() RETURNS trigger AS $trg_update_entity_parents$
BEGIN
IF TG_OP='UPDATE' THEN
IF NEW.parent_uids IS NOT NULL AND OLD.ownedby_uid_fk=NEW.ownedby_uid_fk THEN
RETURN NEW;
END IF;
END IF;
NEW.owner_entity_type_fk := (SELECT entity_type_fk FROM entity parent_entity_record WHERE NEW.ownedby_uid_fk = parent_entity_record.uid);
NEW.parent_uids := calculate_entity_parents(NEW.uid, NEW.ownedby_uid_fk);
UPDATE entity
SET parent_uids=NEW.parent_uids||ARRAY[uid::varchar]
WHERE uid <> NEW.uid
AND ownedby_uid_fk = NEW.uid;
NEW.container_uid_fk := (
SELECT e2.uid
FROM entity e2
WHERE e2.uid::varchar=ANY(NEW.parent_uids)
AND e2.entity_type_fk IN ('com.apple.entity.Project', 'com.apple.entity.User', 'com.apple.entity.Blog')
ORDER BY position(e2.uid::text in array_to_string(NEW.parent_uids, ',')) DESC
LIMIT 1
);
RETURN NEW;
END;
$trg_update_entity_parents$ LANGUAGE plpgsql;
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
23
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/24.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
CREATE TABLE preview_queue (entity_uid_fk uuid NOT NULL REFERENCES entity(uid), entity_url_path varchar);
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +3ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
24
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/25.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
ALTER TABLE entity ADD preview_uid_fk uuid;
UPDATE entity_type SET fields = fields || hstore('preview_uid_fk','previewGUID'), field_refs = field_refs || hstore('previewGUID', 'com.apple.entity.FileData') WHERE name='com.apple.Entity';
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
25
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/26.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
ALTER TABLE search_index ADD is_deleted boolean;
UPDATE search_index SET is_deleted=(SELECT is_deleted FROM entity WHERE uid=entity_uid_fk);
ALTER TABLE search_index ALTER is_deleted SET NOT NULL;
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
26
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/27.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
ALTER TABLE preview_queue ADD session_uid_fk uuid;
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
27
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/28.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
DROP TABLE search_results;
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
28
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/29.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
CREATE OR REPLACE FUNCTION uniquify_filename(_longname varchar) RETURNS varchar AS $uniquify_filename$
DECLARE
_m text[];
BEGIN
SELECT INTO _m * FROM regexp_matches(_longname, E'-([0-9]+)\\.([^\\.]+)$') LIMIT 1;
IF _m IS NOT NULL THEN
RETURN regexp_replace(_longname, E'-([0-9]+)\\.([^\\.]+)$', '-'||((_m[1]::int+1)::text)||'.'||_m[2]);
END IF;
SELECT INTO _m * FROM regexp_matches(_longname, E'-([0-9]+)$') LIMIT 1;
IF _m IS NOT NULL THEN
RETURN regexp_replace(_longname, E'-([0-9]+)$', '-'||((_m[1]::int+1)::text));
END IF;
SELECT INTO _m * FROM regexp_matches(_longname, E'\\.([^\\.]+)$') LIMIT 1;
IF _m IS NOT NULL THEN
RETURN regexp_replace(_longname, E'\\.([^\\.]+)$', E'-2.\\1');
END IF;
RETURN _longname || '-2';
END;
$uniquify_filename$ LANGUAGE plpgsql IMMUTABLE;
CREATE INDEX idx_entity_filename ON entity(long_name) WHERE entity_type_fk='com.apple.entity.File' AND NOT is_hidden AND NOT is_deleted;
CREATE TABLE filename_reservation ( unused boolean );
CREATE OR REPLACE FUNCTION trg_update_entity_filename() RETURNS trigger AS $trg_update_entity_filename$
DECLARE
_safetynet int;
BEGIN
IF NEW.entity_type_fk <> 'com.apple.entity.File' THEN
RETURN NEW;
END IF;
-- IF TG_OP='UPDATE' THEN
-- IF NEW.long_name IS NOT NULL AND OLD.long_name=NEW.long_name THEN
-- RETURN NEW;
-- END IF;
-- END IF;
_safetynet := 50;
LOCK TABLE filename_reservation IN EXCLUSIVE MODE;
WHILE _safetynet > 0 AND EXISTS (SELECT true FROM entity WHERE uid <> NEW.uid AND long_name=NEW.long_name AND entity_type_fk='com.apple.entity.File' AND NOT is_hidden AND NOT is_deleted LIMIT 1) LOOP
NEW.long_name := uniquify_filename(NEW.long_name);
_safetynet := _safetynet-1;
END LOOP;
RETURN NEW;
END;
$trg_update_entity_filename$ LANGUAGE plpgsql;
CREATE TRIGGER update_entity_filename
BEFORE INSERT OR UPDATE ON entity
FOR EACH ROW
EXECUTE PROCEDURE trg_update_entity_filename();
UPDATE entity SET long_name=long_name WHERE entity_type_fk='com.apple.entity.File' AND NOT is_hidden AND NOT is_deleted;
DROP INDEX idx_entity_filename;
CREATE UNIQUE INDEX idx_entity_filename ON entity(long_name) WHERE entity_type_fk='com.apple.entity.File' AND NOT is_hidden AND NOT is_deleted;
CREATE OR REPLACE FUNCTION trg_update_entity_filename() RETURNS trigger AS $trg_update_entity_filename$
DECLARE
_safetynet int;
BEGIN
IF NEW.entity_type_fk <> 'com.apple.entity.File' THEN
RETURN NEW;
END IF;
IF TG_OP='UPDATE' THEN
IF NEW.long_name IS NOT NULL AND OLD.long_name=NEW.long_name THEN
RETURN NEW;
END IF;
END IF;
_safetynet := 50;
LOCK TABLE filename_reservation IN EXCLUSIVE MODE;
WHILE _safetynet > 0 AND EXISTS (SELECT true FROM entity WHERE uid <> NEW.uid AND long_name=NEW.long_name AND entity_type_fk='com.apple.entity.File' AND NOT is_hidden AND NOT is_deleted LIMIT 1) LOOP
NEW.long_name := uniquify_filename(NEW.long_name);
_safetynet := _safetynet-1;
END LOOP;
RETURN NEW;
END;
$trg_update_entity_filename$ LANGUAGE plpgsql;
DROP TRIGGER update_entity_filename ON entity;
CREATE TRIGGER update_entity_filename
BEFORE INSERT OR UPDATE ON entity
FOR EACH ROW
EXECUTE PROCEDURE trg_update_entity_filename();
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +4ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
29
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/30.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
CREATE OR REPLACE FUNCTION trg_update_entity_filename() RETURNS trigger AS $trg_update_entity_filename$
DECLARE
_safetynet int;
BEGIN
IF NEW.entity_type_fk <> 'com.apple.entity.File' THEN
RETURN NEW;
END IF;
IF TG_OP='UPDATE' THEN
IF NEW.long_name IS NOT NULL AND OLD.long_name=NEW.long_name THEN
RETURN NEW;
END IF;
END IF;
_safetynet := 50;
LOCK TABLE filename_reservation IN EXCLUSIVE MODE;
WHILE _safetynet > 0 AND EXISTS (SELECT true FROM entity WHERE uid <> NEW.uid AND long_name=NEW.long_name AND entity_type_fk='com.apple.entity.File' AND NOT is_hidden AND NOT is_deleted LIMIT 1) LOOP
NEW.long_name := uniquify_filename(NEW.long_name);
_safetynet := _safetynet-1;
END LOOP;
RETURN NEW;
END;
$trg_update_entity_filename$ LANGUAGE plpgsql;
DROP TRIGGER update_entity_filename ON entity;
CREATE TRIGGER update_entity_filename
BEFORE INSERT OR UPDATE ON entity
FOR EACH ROW
EXECUTE PROCEDURE trg_update_entity_filename();
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
30
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/31.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
ALTER TABLE entity RENAME theme_name TO theme_info;
UPDATE entity_type SET fields=(fields - 'theme_name'::text)||hstore('theme_info','themeInfo') WHERE name='com.apple.Entity';
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
31
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/32.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
DROP TABLE IF EXISTS entity_tag;
DROP TABLE IF EXISTS entity_tags;
CREATE TABLE entity_tag (
entity_uid_fk uuid NOT NULL,
tags varchar[] NOT NULL DEFAULT '{}'
);
CREATE INDEX idx_entity_tag_tags ON entity_tag(tags);
INSERT INTO entity_tag SELECT uid, tags FROM entity;
ALTER TABLE entity DROP tags;
UPDATE entity_type SET fields=(fields-'tags'::text) WHERE name='com.apple.Entity';
]
NOTICE: table "entity_tag" does not exist, skipping
NOTICE: table "entity_tags" does not exist, skipping
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +3ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
32
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/33.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
CREATE UNIQUE INDEX idx_entity_tag_entity ON entity_tag(entity_uid_fk);
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
33
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/34.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
CREATE TABLE entity_preview (
entity_uid_fk uuid NOT NULL PRIMARY KEY REFERENCES entity(uid),
preview_uid_fk uuid NOT NULL
);
INSERT INTO entity_preview SELECT uid, preview_uid_fk FROM entity WHERE preview_uid_fk IS NOT NULL;
UPDATE entity_type SET fields=(fields-'preview_uid_fk'::text) WHERE name='com.apple.Entity';
ALTER TABLE entity DROP preview_uid_fk;
]
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "entity_preview_pkey" for table "entity_preview"
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +2ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
34
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/35.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
DROP TABLE IF EXISTS serverhome_guids;
CREATE TEMP TABLE serverhome_guids ON COMMIT DROP AS
WITH serverhomeu AS (SELECT uid FROM entity WHERE tiny_id='serverhomeu' AND NOT is_perm_deleted)
SELECT uid, entity_type_fk AS type
FROM entity
WHERE (container_uid_fk=(SELECT uid FROM serverhomeu) OR
parent_uids BETWEEN ARRAY[(SELECT uid FROM serverhomeu)]::varchar[] AND (ARRAY[(SELECT uid FROM serverhomeu)]||ARRAY[NULL::uuid])::varchar[])
AND 1=(SELECT revision FROM entity WHERE tiny_id='serverhome' AND NOT is_perm_deleted)
;
DELETE FROM search_index WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM entity_acls WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM preview_queue WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM relationship WHERE source_uid_fk IN (SELECT uid FROM serverhome_guids) OR target_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM entity_comment WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM notification WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM subscription WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM user_activity WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM user_entity_favorites WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM user_entity_read_status WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM user_entity_watched WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM user_entity_updates WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM entity_lock WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM entity_changesets WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM entity_private_attrs WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM entity_attrs WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM entity_tag WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM session WHERE user_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.User');
DELETE FROM user_activity WHERE user_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.User');
DELETE FROM user_entity_favorites WHERE user_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.User');
DELETE FROM user_entity_read_status WHERE user_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.User');
DELETE FROM user_entity_watched WHERE user_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.User');
DELETE FROM user_entity_updates WHERE user_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.User');
DELETE FROM file_entity WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.File');
DELETE FROM filedata_entity WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.FileData');
DELETE FROM page_entity WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.Page');
DELETE FROM user_entity WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.User');
DELETE FROM document_entity WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type IN ('com.apple.entity.Page', 'com.apple.entity.File'));
DELETE FROM blog_entity WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.Blog');
DELETE FROM entity_preview WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM entity WHERE uid IN (SELECT uid FROM serverhome_guids);
]
NOTICE: table "serverhome_guids" does not exist, skipping
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +25ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=7
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
35
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/36.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
UPDATE entity e
SET blog_uid_fk=(SELECT uid FROM entity b WHERE b.ownedby_uid_fk=e.uid AND b.entity_type_fk='com.apple.entity.Blog' LIMIT 1)
WHERE e.blog_uid_fk IS NULL
AND (e.entity_type_fk='com.apple.entity.User' OR e.entity_type_fk='com.apple.entity.Project')
;
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +3ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=2
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
36
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/37.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
ALTER TABLE entity DROP banner_image_uid_fk;
UPDATE entity_type SET fields=(fields - 'banner_image_uid_fk'::text), field_refs=(field_refs - 'bannerImageGUID'::text) WHERE name='com.apple.Entity';
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
37
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/38.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
CREATE INDEX idx_user_activity_user_time ON user_activity(user_uid_fk, action_time DESC);
CREATE INDEX idx_user_activity_container_time ON user_activity(container_uid_fk, action_time DESC);
CREATE INDEX idx_entity_type ON entity(entity_type_fk);
CREATE TYPE last_activity AS (user_uid_fk uuid, action_time timestamp);
DROP INDEX idx_user_activity_container_uid_fk;
DROP INDEX idx_useractivity_user;
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +3ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
38
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/39.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
UPDATE entity_acls SET external_id=regexp_replace(external_id,'^groups:(.+)', E'\\1') WHERE external_id LIKE 'groups:%';
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
39
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/40.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
CREATE INDEX idx_user_activity_action_time ON user_activity(action_time DESC);
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
40
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/41.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
DROP FUNCTION IF EXISTS uuid_v4();
CREATE FUNCTION uuid_v4() RETURNS uuid AS $uuid_v4$
BEGIN
RETURN lpad(to_hex((random()*255)::int)::text,2,'0') ||
lpad(to_hex((random()*255)::int)::text,2,'0') ||
lpad(to_hex((random()*255)::int)::text,2,'0') ||
lpad(to_hex((random()*255)::int)::text,2,'0') || '-' ||
'4' || to_hex((random()*15)::int)::text ||
lpad(to_hex((random()*255)::int)::text,2,'0') || '-' ||
(ARRAY['8','9','a','b'])[1 + floor(4*random())] || to_hex((random()*15)::int)::text ||
lpad(to_hex((random()*255)::int)::text,2,'0') || '-' ||
lpad(to_hex((random()*255)::int)::text,2,'0') ||
lpad(to_hex((random()*255)::int)::text,2,'0') || '-' ||
lpad(to_hex((random()*255)::int)::text,2,'0') ||
lpad(to_hex((random()*255)::int)::text,2,'0') ||
lpad(to_hex((random()*255)::int)::text,2,'0') ||
lpad(to_hex((random()*255)::int)::text,2,'0') ||
lpad(to_hex((random()*255)::int)::text,2,'0') ||
lpad(to_hex((random()*255)::int)::text,2,'0');
END;
$uuid_v4$ LANGUAGE plpgsql;
INSERT INTO entity (uid, tiny_id, entity_type_fk, is_hidden, long_name, short_name, createdby_user_fk, updatedby_user_fk, ownedby_uid_fk, container_uid_fk)
SELECT uuid_v4(), ue.tiny_id||'blog', 'com.apple.entity.Blog', true, ue.long_name, ue.short_name, ue.uid, ue.uid, ue.uid, ue.uid
FROM entity ue
WHERE entity_type_fk='com.apple.entity.User'
AND blog_uid_fk IS NULL
;
UPDATE entity
SET blog_uid_fk=(SELECT e.uid FROM entity e WHERE e.entity_type_fk='com.apple.entity.Blog' AND e.ownedby_uid_fk=entity.uid LIMIT 1)
WHERE entity_type_fk='com.apple.entity.User'
AND blog_uid_fk IS NULL
;
INSERT INTO blog_entity (entity_uid_fk) SELECT uid FROM entity WHERE entity_type_fk='com.apple.entity.Blog' AND uid NOT IN (SELECT entity_uid_fk FROM blog_entity);
]
NOTICE: function uuid_v4() does not exist, skipping
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +5ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=2
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
41
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/42.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
DROP TRIGGER update_changeset_moddates ON entity_changesets;
DROP FUNCTION trg_update_changeset_moddates();
DROP TRIGGER update_comment_moddates ON entity_comment;
DROP FUNCTION trg_update_comment_moddates();
UPDATE entity_type SET fields=((fields - 'child_update_time'::text) - 'child_updatedby_user_fk'::text) WHERE name='com.apple.Entity';
ALTER TABLE entity DROP child_update_time;
ALTER TABLE entity DROP child_updatedby_user_fk;
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
42
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/43.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
-- Make file/filedata constraints deferrable so that we can batch FileEntity/FileDataEntity creation during file upload without getting caught by the circular reference.
UPDATE pg_constraint SET condeferrable='t' WHERE conname='filedata_entity_icon_uid_fk_fkey';
UPDATE pg_trigger SET tgdeferrable = 't' WHERE tgconstraint=(SELECT oid FROM pg_constraint WHERE conname='filedata_entity_icon_uid_fk_fkey');
UPDATE pg_constraint SET condeferrable='t' WHERE conname='file_entity_data_uid_fk_fkey';
UPDATE pg_trigger SET tgdeferrable = 't' WHERE tgconstraint=(SELECT oid FROM pg_constraint WHERE conname='file_entity_data_uid_fk_fkey');
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=4
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
43
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +7ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/44.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
-- Relax constraints for project creation.
UPDATE pg_constraint SET condeferrable='t' WHERE conname='project_entity_detail_page_fk_fkey';
UPDATE pg_trigger SET tgdeferrable = 't' WHERE tgconstraint=(SELECT oid FROM pg_constraint WHERE conname='project_entity_detail_page_fk_fkey');
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=4
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
44
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/45.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
CREATE INDEX idx_user_activity_entity_time ON user_activity(entity_uid_fk, action_time DESC);
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +11ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
45
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/46.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
CREATE INDEX idx_searchindex_numcontent ON search_index(cast(content as numeric)) where content similar to '[0-9]+';
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +18ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
46
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/47.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
DROP INDEX idx_search_index_literal;
CREATE INDEX idx_search_index_literal ON search_index(substring(content,1,1000));
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +16ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
47
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/48.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
INSERT INTO user_activity (user_uid_fk, action, entity_uid_fk, entity_revision, action_time, parent_uids, container_uid_fk)
SELECT cs.change_user_fk AS user_uid_fk,
CASE cs.change_type
WHEN 'create' THEN 'com.apple.activity.EntityCreated'
WHEN 'edit' THEN 'com.apple.activity.EntityUpdated'
END AS action,
cs.entity_uid_fk,
cs.entity_revision,
cs.change_time AS action_time,
e.parent_uids::uuid[],
e.container_uid_fk
FROM entity_changesets cs
LEFT OUTER JOIN entity e ON (e.uid=cs.entity_uid_fk)
WHERE cs.change_type IN ('create', 'edit')
AND e.uid IS NOT NULL
AND cs.change_user_fk NOT IN (SELECT uid FROM entity WHERE entity_type_fk='com.apple.entity.User' and short_name='serverhomeu')
AND NOT (cs.entity_uid_fk IN (SELECT entity_uid_fk FROM page_entity WHERE is_detail_page) AND cs.change_type='create')
AND e.entity_type_fk IN ('com.apple.entity.Page', 'com.apple.entity.File', 'com.apple.entity.Project')
;
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
48
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/49.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
DROP FUNCTION IF EXISTS trg_update_entity_parents() CASCADE;
CREATE FUNCTION trg_update_entity_parents() RETURNS trigger AS $trg_update_entity_parents$
BEGIN
IF TG_OP='UPDATE' THEN
IF NEW.parent_uids IS NOT NULL AND NEW.container_uid_fk IS NOT NULL AND OLD.ownedby_uid_fk=NEW.ownedby_uid_fk THEN
RETURN NEW;
END IF;
END IF;
NEW.owner_entity_type_fk := (SELECT entity_type_fk FROM entity parent_entity_record WHERE NEW.ownedby_uid_fk = parent_entity_record.uid);
NEW.parent_uids := calculate_entity_parents(NEW.uid, NEW.ownedby_uid_fk);
UPDATE entity
SET parent_uids=NEW.parent_uids||ARRAY[uid::varchar]
WHERE uid <> NEW.uid
AND ownedby_uid_fk = NEW.uid;
NEW.container_uid_fk := (
SELECT e2.uid
FROM entity e2
WHERE e2.uid::varchar=ANY(NEW.parent_uids) AND e2.uid <> NEW.uid
AND e2.entity_type_fk IN ('com.apple.entity.Project', 'com.apple.entity.User', 'com.apple.entity.Blog')
ORDER BY position(e2.uid::text in array_to_string(NEW.parent_uids, ',')) DESC
LIMIT 1
);
RETURN NEW;
END;
$trg_update_entity_parents$ LANGUAGE plpgsql;
CREATE TRIGGER update_entity_parents BEFORE INSERT OR UPDATE ON entity FOR EACH ROW EXECUTE PROCEDURE trg_update_entity_parents();
CREATE TEMP TABLE working_uids_49 ON COMMIT DROP AS SELECT uid FROM entity WHERE uid=container_uid_fk;
UPDATE entity SET parent_uids=NULL WHERE uid IN (SELECT uid FROM working_uids_49) AND uid=container_uid_fk;
]
NOTICE: drop cascades to trigger update_entity_parents on table entity
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +5ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=2
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
49
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/50.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
DROP INDEX IF EXISTS idx_entity_tag_tags;
CREATE INDEX idx_entity_tag_tags ON entity_tag(tags) WHERE tags IS NOT NULL AND tags <> '{}'::varchar[];
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
50
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/51.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
DELETE FROM user_activity WHERE entity_uid_fk IN (SELECT uid FROM entity WHERE entity_type_fk not IN ('com.apple.entity.Page', 'com.apple.entity.File', 'com.apple.entity.Project'));
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
51
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/52.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
CREATE TEMP TABLE orphaned_detail_page_uids (uid uuid) ON COMMIT DROP;
INSERT INTO orphaned_detail_page_uids
SELECT p.detail_page_fk
FROM entity pe
LEFT OUTER JOIN project_entity p ON (p.entity_uid_fk=pe.uid)
LEFT OUTER JOIN page_entity dp ON (dp.entity_uid_fk=p.detail_page_fk)
LEFT OUTER JOIN entity dpe ON (dpe.uid=p.detail_page_fk)
WHERE p.detail_page_fk IS NOT NULL
AND pe.entity_type_fk='com.apple.entity.Project'
AND NOT dp.is_detail_page
AND pe.uid=dpe.container_uid_fk
;
INSERT INTO orphaned_detail_page_uids
SELECT u.detail_page_fk
FROM entity ue
LEFT OUTER JOIN user_entity u ON (u.entity_uid_fk=ue.uid)
LEFT OUTER JOIN page_entity dp ON (dp.entity_uid_fk=u.detail_page_fk)
LEFT OUTER JOIN entity dpe ON (dpe.uid=u.detail_page_fk)
WHERE u.detail_page_fk IS NOT NULL
AND ue.entity_type_fk='com.apple.entity.User'
AND NOT dp.is_detail_page
AND ue.uid=dpe.container_uid_fk
;
UPDATE page_entity SET is_detail_page=true WHERE entity_uid_fk IN (SELECT uid FROM orphaned_detail_page_uids);
UPDATE entity SET revision=revision+1 WHERE uid IN (SELECT uid FROM orphaned_detail_page_uids);
SET bytea_output TO escape;
CREATE TEMP TABLE orphaned_detail_page_revs_to_bump ON COMMIT DROP AS
SELECT uid
FROM entity_changesets
WHERE entity_uid_fk IN (SELECT uid FROM orphaned_detail_page_uids)
AND entity_revision > 1
;
UPDATE entity_changesets
SET entity_revision=entity_revision+1
WHERE uid IN (SELECT uid FROM orphaned_detail_page_revs_to_bump)
;
INSERT INTO entity_changesets (uid, entity_uid_fk, entity_revision, change_user_fk, change_action, change_type, change_fields, change_time, change_data_bin)
SELECT uuid_v4(),
o.uid,
2,
oe.updatedby_user_fk,
'UPDATE',
'system-fixdetailpage',
ARRAY['isDetailPage'],
clock_timestamp(),
'gaxpc0RldGFpbFBhZ2XD' /* This is base64-encoded MsgPack for { isDetailPage => true } */
FROM orphaned_detail_page_uids o
LEFT OUTER JOIN entity oe ON (o.uid=oe.uid)
;
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +4ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
52
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:118 751b7180 +0ms] Executing migration block #53
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:233 751b7180 +0ms] Executing query [SELECT entity_uid_fk, data_uri FROM filedata_entity WHERE data_uri LIKE E'%\\%%']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=0/updated=0
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
53
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/54.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
DROP FUNCTION IF EXISTS trg_update_entity_parents() CASCADE;
CREATE FUNCTION trg_update_entity_parents() RETURNS trigger AS $trg_update_entity_parents$
BEGIN
IF TG_OP='UPDATE' THEN
IF NEW.parent_uids IS NOT NULL AND NEW.container_uid_fk IS NOT NULL AND OLD.ownedby_uid_fk=NEW.ownedby_uid_fk THEN
RETURN NEW;
END IF;
END IF;
NEW.owner_entity_type_fk := (SELECT entity_type_fk FROM entity parent_entity_record WHERE NEW.ownedby_uid_fk = parent_entity_record.uid);
NEW.parent_uids := calculate_entity_parents(NEW.uid, NEW.ownedby_uid_fk);
UPDATE entity
SET parent_uids=NEW.parent_uids||ARRAY[uid::varchar]
WHERE uid <> NEW.uid
AND ownedby_uid_fk = NEW.uid;
NEW.container_uid_fk := (
SELECT e2.uid
FROM entity e2
WHERE e2.uid::varchar=ANY(NEW.parent_uids) AND e2.uid <> NEW.uid
AND e2.entity_type_fk IN ('com.apple.entity.Project', 'com.apple.entity.User')
ORDER BY position(e2.uid::text in array_to_string(NEW.parent_uids, ',')) DESC
LIMIT 1
);
RETURN NEW;
END;
$trg_update_entity_parents$ LANGUAGE plpgsql;
CREATE TRIGGER update_entity_parents BEFORE INSERT OR UPDATE ON entity FOR EACH ROW EXECUTE PROCEDURE trg_update_entity_parents();
CREATE TEMP TABLE working_uids_54 ON COMMIT DROP AS SELECT uid FROM entity WHERE container_uid_fk IN (SELECT uid FROM entity WHERE entity_type_fk='com.apple.entity.Blog');
UPDATE entity SET container_uid_fk=NULL WHERE uid IN (SELECT uid FROM working_uids_54) AND container_uid_fk IN (SELECT uid FROM entity WHERE entity_type_fk='com.apple.entity.Blog');
]
NOTICE: drop cascades to trigger update_entity_parents on table entity
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +2ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
54
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/55.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
CREATE LOCAL TEMP TABLE x_ents_to_hide ON COMMIT DROP AS
SELECT uid
FROM entity
WHERE entity_type_fk='com.apple.entity.User'
AND short_name in ('authenticated', 'unauthenticated', 'serverhomeu')
;
UPDATE entity SET is_hidden=true WHERE uid IN (SELECT uid FROM x_ents_to_hide) OR container_uid_fk IN (SELECT uid FROM x_ents_to_hide) OR ownedby_uid_fk IN (SELECT uid FROM x_ents_to_hide);
DELETE FROM search_index WHERE entity_uid_fk IN (SELECT uid FROM x_ents_to_hide);
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +3ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
55
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/56.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
DELETE FROM user_activity WHERE entity_uid_fk IN (SELECT uid FROM entity WHERE entity_type_fk='com.apple.entity.Blog');
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
56
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/57.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
CREATE TABLE search_stat (
uid uuid NOT NULL,
action varchar NOT NULL,
action_time timestamp NOT NULL DEFAULT clock_timestamp(),
user_uid_fk uuid NOT NULL,
query_text varchar,
sort_text varchar,
range int[],
result_index int,
result_uid_fk uuid,
result_snippets hstore
);
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +17ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
57
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:118 751b7180 +0ms] Executing migration block #58
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:205 751b7180 +0ms] Executing query [INSERT INTO session (uid, user_uid_fk, auth_token) SELECT uuid_v4(), entity_uid_fk, $1 FROM user_entity WHERE external_id='unauthenticated' RETURNING uid] with params [(
"pkOEoSzOIeS7HglOPNUxlCfTg5I/m/+2+On3SrMC1Zc="
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [INSERT INTO preview_queue (entity_uid_fk, session_uid_fk) SELECT entity_uid_fk, $1 FROM page_entity] with params [(
"55365b12-499a-ac40-147c-8b7699782657"
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
58
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/59.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
DROP TEXT SEARCH CONFIGURATION IF EXISTS english_nostop;
DROP TEXT SEARCH DICTIONARY IF EXISTS english_nostop;
CREATE TEXT SEARCH DICTIONARY public.english_nostop (template=pg_catalog.snowball, language=english);
CREATE TEXT SEARCH CONFIGURATION english_nostop (copy=pg_catalog.english);
ALTER TEXT SEARCH CONFIGURATION english_nostop ALTER MAPPING FOR asciiword, asciihword, hword_asciipart, word, hword, hword_part WITH english_nostop, english_stem;
ALTER DATABASE collab SET default_text_search_config=english_nostop;
]
NOTICE: text search configuration "english_nostop" does not exist, skipping
NOTICE: text search dictionary "english_nostop" does not exist, skipping
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +3ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
59
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/60.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
CREATE TABLE user_readall_time (
user_uid_fk uuid PRIMARY KEY REFERENCES user_entity(entity_uid_fk),
readall_time timestamp NOT NULL DEFAULT now()
);
CREATE TEMP TABLE temp_readall AS
SELECT DISTINCT ON (user_uid_fk) user_uid_fk, read_time
FROM user_entity_read_status u
GROUP BY user_uid_fk, read_time
HAVING count(*) > 1
ORDER BY user_uid_fk, read_time DESC
;
INSERT INTO user_readall_time (user_uid_fk, readall_time) SELECT user_uid_fk, read_time FROM temp_readall;
DELETE FROM user_entity_read_status WHERE ARRAY[user_uid_fk::text, read_time::text] IN (SELECT ARRAY[user_uid_fk::text, read_time::text] FROM temp_readall);
]
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "user_readall_time_pkey" for table "user_readall_time"
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +8ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
60
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/61.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
UPDATE entity_acls SET external_id=replace(external_id, 'group:group:', 'group:') WHERE external_id LIKE 'group:group:';
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
61
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/62.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
CREATE TABLE user_entity_unread_status (
user_uid_fk uuid NOT NULL REFERENCES user_entity(entity_uid_fk),
entity_uid_fk uuid NOT NULL REFERENCES entity(uid),
unread_time timestamp NOT NULL DEFAULT now()
);
CREATE INDEX idx_ueus_user ON user_entity_unread_status(user_uid_fk);
CREATE INDEX idx_ueus_entity ON user_entity_unread_status(entity_uid_fk);
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +11ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
62
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/63.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
DELETE FROM user_activity
WHERE user_uid_fk=(SELECT uid FROM entity WHERE entity_type_fk='com.apple.entity.User' and short_name='serverhomeu')
AND action='com.apple.activity.EntityCreated'
;
DELETE FROM user_activity
WHERE entity_uid_fk IN (SELECT entity_uid_fk FROM page_entity WHERE is_detail_page)
AND action='com.apple.activity.EntityCreated'
;
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
63
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/64.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
/*
* Migration #66 needs to be run for #64 to work, copying it here. It will run again as #66, harmlessly.
*/
CREATE OR REPLACE FUNCTION trg_update_entity_filename() RETURNS trigger AS $trg_update_entity_filename$
DECLARE
_safetynet int;
BEGIN
IF NEW.entity_type_fk <> 'com.apple.entity.File' THEN
RETURN NEW;
END IF;
IF TG_OP='UPDATE' THEN
IF NEW.long_name IS NOT NULL AND OLD.long_name=NEW.long_name AND NEW.is_hidden=OLD.is_hidden AND NEW.is_deleted=OLD.is_deleted THEN
RETURN NEW;
END IF;
END IF;
_safetynet := 50;
LOCK TABLE filename_reservation IN EXCLUSIVE MODE;
WHILE _safetynet > 0 AND EXISTS (SELECT true FROM entity WHERE uid <> NEW.uid AND long_name=NEW.long_name AND entity_type_fk='com.apple.entity.File' AND NOT is_hidden AND NOT is_deleted LIMIT 1) LOOP
NEW.long_name := uniquify_filename(NEW.long_name);
_safetynet := _safetynet-1;
END LOOP;
RETURN NEW;
END;
$trg_update_entity_filename$ LANGUAGE plpgsql;
DROP TRIGGER update_entity_filename ON entity;
CREATE TRIGGER update_entity_filename
BEFORE INSERT OR UPDATE ON entity
FOR EACH ROW
EXECUTE PROCEDURE trg_update_entity_filename();
/*
* End migration #66
*/
SET bytea_output TO escape;
UPDATE entity_changesets
SET change_type='unhide'
WHERE change_fields=ARRAY['isHidden']
AND change_type <> 'unhide'
AND change_data_bin='gahpc0hpZGRlbsI=' -- Base64-encoded MsgPack for { isHidden => false }
;
UPDATE entity_changesets
SET change_type='hide'
WHERE change_fields=ARRAY['isHidden']
AND change_type <> 'hide'
AND change_data_bin='gahpc0hpZGRlbsM=' -- Base64-encoded MsgPack for { isHidden => true }
;
CREATE TEMP TABLE hidden_uids ON COMMIT DROP AS
SELECT DISTINCT ON (entity_uid_fk) entity_uid_fk, change_data_bin
FROM entity_changesets
LEFT OUTER JOIN entity ON (entity.uid=entity_uid_fk)
WHERE change_fields='{isHidden}'
AND entity.entity_type_fk IN ('com.apple.entity.File','com.apple.entity.Page')
AND NOT entity.owner_entity_type_fk IN ('com.apple.entity.User','com.apple.entity.Blog')
ORDER BY entity_uid_fk, change_time DESC
;
UPDATE entity
SET is_hidden=false, revision=revision+1
WHERE uid IN (SELECT entity_uid_fk FROM hidden_uids WHERE change_data_bin='gahpc0hpZGRlbsM=')
;
INSERT INTO entity_changesets (uid, entity_uid_fk, entity_revision, change_user_fk, change_action, change_type, change_fields, change_time, change_data_bin)
SELECT uuid_v4(),
hu.entity_uid_fk,
he.revision,
he.updatedby_user_fk,
'UPDATE',
'system-fixhidden',
ARRAY['isHidden'],
clock_timestamp(),
'gahpc0hpZGRlbsI='
FROM hidden_uids hu
LEFT OUTER JOIN entity he ON (hu.entity_uid_fk=he.uid)
WHERE hu.change_data_bin='gahpc0hpZGRlbsM='
;
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +3ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
64
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/65.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
DROP TABLE IF EXISTS serverhome_guids;
CREATE TEMP TABLE serverhome_guids ON COMMIT DROP AS
WITH serverhomeu AS (SELECT uid FROM entity WHERE tiny_id='serverhomeu' AND NOT is_perm_deleted)
SELECT uid, entity_type_fk AS type
FROM entity
WHERE (container_uid_fk=(SELECT uid FROM serverhomeu) OR
parent_uids BETWEEN ARRAY[(SELECT uid FROM serverhomeu)]::varchar[] AND (ARRAY[(SELECT uid FROM serverhomeu)]||ARRAY[NULL::uuid])::varchar[])
AND 1=(SELECT revision FROM entity WHERE tiny_id='serverhome' AND NOT is_perm_deleted)
;
DELETE FROM search_index WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM entity_acls WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM preview_queue WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM relationship WHERE source_uid_fk IN (SELECT uid FROM serverhome_guids) OR target_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM entity_comment WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM notification WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM subscription WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM user_activity WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM user_entity_favorites WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM user_entity_read_status WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM user_entity_watched WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM user_entity_updates WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM entity_lock WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM entity_changesets WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM entity_private_attrs WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM entity_attrs WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM entity_tag WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM session WHERE user_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.User');
DELETE FROM user_activity WHERE user_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.User');
DELETE FROM user_entity_favorites WHERE user_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.User');
DELETE FROM user_entity_read_status WHERE user_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.User');
DELETE FROM user_entity_watched WHERE user_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.User');
DELETE FROM user_entity_updates WHERE user_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.User');
DELETE FROM file_entity WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.File');
DELETE FROM filedata_entity WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.FileData');
DELETE FROM page_entity WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.Page');
DELETE FROM user_entity WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.User');
DELETE FROM document_entity WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type IN ('com.apple.entity.Page', 'com.apple.entity.File'));
DELETE FROM blog_entity WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids WHERE type='com.apple.entity.Blog');
DELETE FROM entity_preview WHERE entity_uid_fk IN (SELECT uid FROM serverhome_guids);
DELETE FROM entity WHERE uid IN (SELECT uid FROM serverhome_guids);
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +6ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
65
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/66.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
CREATE OR REPLACE FUNCTION trg_update_entity_filename() RETURNS trigger AS $trg_update_entity_filename$
DECLARE
_safetynet int;
BEGIN
IF NEW.entity_type_fk <> 'com.apple.entity.File' THEN
RETURN NEW;
END IF;
IF TG_OP='UPDATE' THEN
IF NEW.long_name IS NOT NULL AND OLD.long_name=NEW.long_name AND NEW.is_hidden=OLD.is_hidden AND NEW.is_deleted=OLD.is_deleted THEN
RETURN NEW;
END IF;
END IF;
_safetynet := 50;
LOCK TABLE filename_reservation IN EXCLUSIVE MODE;
WHILE _safetynet > 0 AND EXISTS (SELECT true FROM entity WHERE uid <> NEW.uid AND long_name=NEW.long_name AND entity_type_fk='com.apple.entity.File' AND NOT is_hidden AND NOT is_deleted LIMIT 1) LOOP
NEW.long_name := uniquify_filename(NEW.long_name);
_safetynet := _safetynet-1;
END LOOP;
RETURN NEW;
END;
$trg_update_entity_filename$ LANGUAGE plpgsql;
DROP TRIGGER update_entity_filename ON entity;
CREATE TRIGGER update_entity_filename
BEFORE INSERT OR UPDATE ON entity
FOR EACH ROW
EXECUTE PROCEDURE trg_update_entity_filename();
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
66
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/67.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
UPDATE entity e
SET blog_uid_fk=(SELECT uid FROM entity b WHERE b.ownedby_uid_fk=e.uid AND b.entity_type_fk='com.apple.entity.Blog' LIMIT 1)
WHERE e.blog_uid_fk IS NULL
AND (e.entity_type_fk='com.apple.entity.User' OR e.entity_type_fk='com.apple.entity.Project')
;
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
67
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/68.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
UPDATE entity e
SET blog_uid_fk=(SELECT uid FROM entity b WHERE b.ownedby_uid_fk=e.uid AND b.entity_type_fk='com.apple.entity.Blog' LIMIT 1)
WHERE (e.blog_uid_fk IS NULL OR e.blog_uid_fk=e.uid)
AND (e.entity_type_fk='com.apple.entity.User' OR e.entity_type_fk='com.apple.entity.Project')
;
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
68
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:106 751b7180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/69.sql
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [/**
* Copyright (c) 2010-2012, Apple Inc. All rights reserved.
*
* IMPORTANT NOTE: This file is licensed only for use on Apple-branded
* computers and is subject to the terms and conditions of the Apple Software
* License Agreement accompanying the package this file is a part of.
* You may not port this file to another platform without Apple's written consent.
*
* IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature
* of the Apple Software and is subject to the terms and conditions of the Apple
* Software License Agreement accompanying the package this file is part of.
**/
CREATE OR REPLACE FUNCTION trg_update_entity_filename() RETURNS trigger AS $trg_update_entity_filename$
DECLARE
_safetynet int;
BEGIN
IF NEW.entity_type_fk <> 'com.apple.entity.File' THEN
RETURN NEW;
END IF;
IF TG_OP='UPDATE' THEN
IF NEW.long_name IS NOT NULL AND OLD.long_name=NEW.long_name AND NEW.is_hidden=OLD.is_hidden AND NEW.is_deleted=OLD.is_deleted THEN
RETURN NEW;
END IF;
END IF;
_safetynet := 50;
LOCK TABLE filename_reservation IN EXCLUSIVE MODE;
WHILE _safetynet > 0 AND EXISTS (SELECT true FROM entity WHERE uid <> NEW.uid AND long_name=NEW.long_name AND entity_type_fk='com.apple.entity.File' AND NOT is_hidden AND NOT is_deleted LIMIT 1) LOOP
NEW.long_name := uniquify_filename(NEW.long_name);
_safetynet := _safetynet-1;
END LOOP;
NEW.short_name := uniquify_filename(NEW.short_name);
RETURN NEW;
END;
$trg_update_entity_filename$ LANGUAGE plpgsql;
DROP TRIGGER update_entity_filename ON entity;
CREATE TRIGGER update_entity_filename
BEFORE INSERT OR UPDATE ON entity
FOR EACH ROW
EXECUTE PROCEDURE trg_update_entity_filename();
UPDATE entity
SET short_name=long_name
WHERE entity_type_fk='com.apple.entity.File'
AND (short_name IS NULL OR short_name <> long_name)
;
]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:289 751b7180 +0ms] Executing update [UPDATE global_settings SET value_int = $1 WHERE key = 'com.apple.setting.schema_version'] with params [(
69
)]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:442 751b7180 +0ms] Schema updates completed.
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:320 751b7180 +0ms] Executing update [COMMIT]
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +10ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Info>: [SchemaMigrator:449 751b7180 +0ms] Database changed, performing a VACUUM FULL ANALYZE
Jul 25 22:21:18 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:320 751b7180 +0ms] Executing update [VACUUM FULL ANALYZE]
Jul 25 22:21:19 macserver.local wikiadmin[3565] <Debug>: [PGCConnection:181 751b7180 +822ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Info>: [MigrationController:702 751b7180 +8ms] Rebuilding search index...
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:61 751b7180 +0ms] -[PGCConnection connect] with [user=collab dbname=collab]
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:320 751b7180 +7ms] Executing update [SET bytea_output TO escape]
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:233 751b7180 +0ms] Executing query [SELECT true FROM entity WHERE false]
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:181 751b7180 +1ms] Query result is [PGRES_TUPLES_OK] rows returned=0/updated=0
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Info>: [CSConfig:54 751b7180 +23ms] Reading plist at /Library/Server/Wiki/Config/collabd.plist
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [CSConnectionPool:95 751b7180 +0ms] Opening DB connection
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:61 751b7180 +0ms] -[PGCConnection connect] with [dbname=collab application_name=wikiadmin client_encoding=utf-8 options='-c bytea_output=escape' user=collab]
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:233 751b7180 +3ms] Executing query [SELECT oid FROM pg_type WHERE typname='hstore']
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:181 751b7180 +1ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:388 751b7180 +0ms] Executing scalar query [SELECT array_agg(uid::varchar) FROM entity]
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:181 751b7180 +1ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:320 751b7180 +0ms] Executing update [CREATE TABLE search_index_scratch_20120725T222119 AS SELECT * FROM search_index LIMIT 0]
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:181 751b7180 +3ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [CSWorkerPool:151 751b7180 +151ms] All workers finished, continuing
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:320 751b7180 +0ms] Executing update [BEGIN]
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:456 751b7180 +0ms] Executing count query [SELECT true FROM search_index_scratch_20120725T222119 LIMIT 1]
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=0/updated=0
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Info>: [CSPGSearchService:338 751b7180 +0ms] No rows in search_index_scratch_20120725T222119, leaving existing search_index alone.
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:320 751b7180 +0ms] Executing update [DROP TABLE search_index_scratch_20120725T222119]
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:181 751b7180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:320 751b7180 +0ms] Executing update [COMMIT]
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:181 751b7180 +21ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:320 751b7180 +0ms] Executing update [SET maintenance_work_mem TO '1GB']
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:181 751b7180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:320 751b7180 +0ms] Executing update [VACUUM FULL ANALYZE search_index]
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:181 751b7180 +52ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [CSConnectionPool:291 751b7180 +0ms] Closing DB connection
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:469 751b7180 +0ms] -[PGCConnection close]
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Debug>: [PGCConnection:469 751b7180 +0ms] -[PGCConnection close]
Jul 25 22:21:19 macserver.local wikiadmin[3567] <Info>: [MigrationController:728 751b7180 +0ms] Done
22:21:20.945 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/99-wiki_config_migrator.py
RESULT CODE: 0
STDOUT: Maximum verbosity
Merged //Applications/Server.app/Contents/ServerRoot/private/etc/collabd/collabd.plist .default and /Library/Server/Previous/private/etc/collabd/collabd.plist into //Library/Server/Wiki/Config/collabd.plist
Merged //Applications/Server.app/Contents/ServerRoot/private/etc/collabd/collabcored.p list.default and /Library/Server/Previous/private/etc/collabd/collabcored.plist into //Library/Server/Wiki/Config/collabcored.plist
Source path: /Library/Server/Previous/private/etc/collabd/filter_whitelist.plist doesn't exist
Merged //Applications/Server.app/Contents/ServerRoot/private/etc/collabd/webauthd.plis t.default and /Library/Server/Previous/private/etc/collabd/webauthd.plist into //Library/Server/Wiki/Config/webauthd.plist
Got status for wiki from serveradmin as wiki:state = "STOPPED"
Wiki is not running ... skipping
STDERR:
22:21:21.038 Setup extra failed:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/111-alfconfigmigrator.pl
RESULT CODE: 1
STDOUT: Did not supply a valid language for the --language parameter, needs to be one of [en|fr|de|ja]
--purge <0 | 1> "1" means remove any files from the old system after you've migrated them, "0" means leave them alone.
--sourceRoot <path> The path to the root of the system to migrate
--sourceType <System | TimeMachine> Gives the type of the migration source, whether it's a runnable system or a
Time Machine backup.
--sourceVersion <ver> The version number of the old system (like 10.6 or 10.7). Since we support migration from 10.6, 10.7,
and other 10.8 installs.
--targetRoot <path> The path to the root of the new system.
--language <lang> A language identifier, such as "en." Long running scripts should return a description of what they're doing
("Migrating Open Directory users"), and possibly provide status update messages along the way. These messages
need to be localized (which is not necessarily the server running the migration script).
This argument will identify the Server Assistant language. As an alternative to doing localization yourselves
send them in English, but in case the script will do this it will need this identifier.
STDERR:
22:21:21.093 Setup extra failed:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/111-syslogconfigmigrator.pl
RESULT CODE: 1
STDOUT: Did not supply a valid language for the --language parameter, needs to be one of [en|fr|de|ja]
--purge <0 | 1> "1" means remove any files from the old system after you've migrated them, "0" means leave them alone.
--sourceRoot <path> The path to the root of the system to migrate
--sourceType <System | TimeMachine> Gives the type of the migration source, whether it's a runnable system or a
Time Machine backup.
--sourceVersion <ver> The version number of the old system (like 10.6 or 10.7). Since we support migration from 10.6, 10.7,
and other 10.8 installs.
--targetRoot <path> The path to the root of the new system.
--language <lang> A language identifier, such as "en." Long running scripts should return a description of what they're doing
("Migrating Open Directory users"), and possibly provide status update messages along the way. These messages
need to be localized (which is not necessarily the server running the migration script).
This argument will identify the Server Assistant language. As an alternative to doing localization yourselves
send them in English, but in case the script will do this it will need this identifier.
STDERR:
22:21:21.109 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/MigrationUtilities.pm
RESULT CODE: 0
STDOUT:
STDERR:
22:21:23.874 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/UpdateDefaultGroup.sh
RESULT CODE: 0
STDOUT: accounts:attributes:dsAttrTypeStandard\:RecordType:_array_index:0 = "dsRecTypeStandard:Groups"
accounts:attributes:dsAttrTypeStandard\:RecordName:_array_index:0 = "workgroup"
accounts:attributes:dsAttrTypeStandard\:GeneratedUID:_array_index:0 = "F597ADA5-9238-46B8-8999-8DD27BAEB24C"
accounts:attributes:dsAttrTypeStandard\:NestedGroups:_array_index:0 = "ABCDEFAB-CDEF-ABCD-EFAB-CDEF0000003D"
accounts:attributes:dsAttrTypeStandard\:AppleMetaRecordName:_array_index:0 = "cn=workgroup,cn=groups,dc=macserver,dc=local"
accounts:attributes:dsAttrTypeStandard\:AppleMetaNodeLocation:_array_index:0 = "/LDAPv3/127.0.0.1"
STDERR: 2012-07-25 22:21:23.824 serveradmin[3620:707] servermgr_calendar: checkMailAccessForServiceUser did not find a user
2012-07-25 22:21:23.825 serveradmin[3620:707] getting service list
2012-07-25 22:21:23.851 serveradmin[3620:707] NSScanner: nil string argument
2012-07-25 22:21:23.852 serveradmin[3620:707] NSScanner: nil string argument
22:21:24.493 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/UpgradeUsers
RESULT CODE: 0
STDOUT:
STDERR:
22:21:24.505 Starting extras with arguments:
22:21:24.788 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/30-serverTuning.sh
RESULT CODE: 0
STDOUT: 12300 allow tcp from any to any established
12301 allow ip from any to any proto tcp out
12302 allow tcp from any to any dst-port 22
12302 allow udp from any to any dst-port 22
12303 allow udp from any to any dst-port 68
12304 allow udp from any to any out keep-state
12305 allow tcp from any to any dst-port 53 out keep-state
12305 allow ip from any to any proto udp dst-port 53 out keep-state
12306 allow udp from any to any in frag
12307 allow tcp from any to any dst-port 311
12308 allow tcp from any to any dst-port 625
12309 allow icmp from any to any icmptypes 8
12310 allow icmp from any to any icmptypes 0
12311 allow igmp from any to any
01000 allow ip from any to any via lo0
01010 deny ip from any to 127.0.0.0/8
01020 deny ip from 224.0.0.0/4 to any in
01030 deny tcp from any to 224.0.0.0/4 in
65534 deny ip from any to any
net.inet.ip.fw.enable: 1 -> 0
01000 allow ipv6 from any to any via lo0
01100 allow ipv6 from any to ff02::/16
65000 deny ipv6 from any to any
net.inet6.ip6.fw.enable: 1 -> 0
net.inet.tcp.delayed_ack: 3 -> 2
STDERR:
22:21:24.920 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/60-setup_alerts.sh
RESULT CODE: 0
STDOUT:
STDERR:
22:21:25.103 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/61-setup_amavisd.sh
RESULT CODE: 0
STDOUT:
STDERR:
22:21:25.177 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/62-setup_spamassassin.sh
RESULT CODE: 0
STDOUT:
STDERR:
22:21:26.635 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/63-setup_clamav.sh
RESULT CODE: 0
STDOUT:
STDERR:
22:21:27.954 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/65-setup_dovecot.sh
RESULT CODE: 0
STDOUT: conf.d/10-auth.conf -> ../conf.d/10-auth.conf
conf.d/10-director.conf -> ../conf.d/10-director.conf
conf.d/10-logging.conf -> ../conf.d/10-logging.conf
conf.d/10-mail.conf -> ../conf.d/10-mail.conf
conf.d/10-master.conf -> ../conf.d/10-master.conf
conf.d/10-ssl.conf -> ../conf.d/10-ssl.conf
conf.d/15-lda.conf -> ../conf.d/15-lda.conf
conf.d/20-imap.conf -> ../conf.d/20-imap.conf
conf.d/20-lmtp.conf -> ../conf.d/20-lmtp.conf
conf.d/20-managesieve.conf -> ../conf.d/20-managesieve.conf
conf.d/20-pop3.conf -> ../conf.d/20-pop3.conf
conf.d/90-acl.conf -> ../conf.d/90-acl.conf
conf.d/90-plugin.conf -> ../conf.d/90-plugin.conf
conf.d/90-quota.conf -> ../conf.d/90-quota.conf
conf.d/90-sieve.conf -> ../conf.d/90-sieve.conf
conf.d/auth-checkpassword.conf.ext -> ../conf.d/auth-checkpassword.conf.ext
conf.d/auth-deny.conf.ext -> ../conf.d/auth-deny.conf.ext
conf.d/auth-ldap.conf.ext -> ../conf.d/auth-ldap.conf.ext
conf.d/auth-master.conf.ext -> ../conf.d/auth-master.conf.ext
conf.d/auth-od.conf.ext -> ../conf.d/auth-od.conf.ext
conf.d/auth-passwdfile.conf.ext -> ../conf.d/auth-passwdfile.conf.ext
conf.d/auth-sql.conf.ext -> ../conf.d/auth-sql.conf.ext
conf.d/auth-static.conf.ext -> ../conf.d/auth-static.conf.ext
conf.d/auth-submit.conf.ext -> ../conf.d/auth-submit.conf.ext
conf.d/auth-system.conf.ext -> ../conf.d/auth-system.conf.ext
conf.d/auth-vpopmail.conf.ext -> ../conf.d/auth-vpopmail.conf.ext
dovecot-db.conf.ext -> ../dovecot-db.conf.ext
dovecot-dict-sql.conf.ext -> ../dovecot-dict-sql.conf.ext
dovecot-ldap.conf.ext -> ../dovecot-ldap.conf.ext
dovecot-sql.conf.ext -> ../dovecot-sql.conf.ext
dovecot.conf -> ../dovecot.conf
partition_map.conf -> ../partition_map.conf
STDERR: Print: Entry, "service_initialized", Does Not Exist
grep: /Library/Server/Mail/Config/postfix/main.cf: No such file or directory
1+0 records in
1+0 records out
256 bytes transferred in 0.000039 secs (6587373 bytes/sec)
22:21:28.075 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/80-devicemgrcommon.sh
RESULT CODE: 0
STDOUT:
STDERR:
22:21:28.087 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/AccountsConfigServiceSetup.sh
RESULT CODE: 0
STDOUT:
STDERR:
22:21:28.133 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/AdaptiveFirewallSetup.sh
RESULT CODE: 0
STDOUT:
STDERR:
22:21:28.568 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/AddAppServerUserToAppServerGroups.sh
RESULT CODE: 0
STDOUT:
STDERR:
22:21:28.656 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/CopyUninstallExtras.sh
RESULT CODE: 0
STDOUT:
STDERR:
22:21:29.027 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/DisableBootP.sh
RESULT CODE: 0
STDOUT:
STDERR:
22:21:29.035 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/DisableWatchDog.sh
RESULT CODE: 0
STDOUT:
STDERR:
22:21:29.243 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/GenerateRNDCKey.sh
RESULT CODE: 0
STDOUT:
STDERR: wrote key file "/private/etc/rndc.key"
22:21:29.261 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/InstallServerPaths.sh
RESULT CODE: 0
STDOUT:
STDERR:
22:21:29.272 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/ITDictionarySymLink.sh
RESULT CODE: 0
STDOUT:
STDERR:
22:21:29.601 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/MarkServerFolderAsLocalizable.sh
RESULT CODE: 0
STDOUT:
STDERR:
22:21:29.646 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/PasswordResetSetupExtras.sh
RESULT CODE: 0
STDOUT: Creating the password reset preferences folder
Creating the password reset preferences folder [DONE]
Copying default config plists
Copying default config plists [DONE]
Creating password reset log file
Creating password reset log file [DONE]
STDERR:
22:21:32.639 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/phpsetup
RESULT CODE: 0
STDOUT: Running PEAR installer
[PEAR] Archive_Tar - installed: 1.3.7
[PEAR] Console_Getopt - installed: 1.3.0
[PEAR] Structures_Graph- installed: 1.0.4
[PEAR] XML_Util - installed: 1.2.1
[PEAR] PEAR - installed: 1.9.4
Wrote PEAR system config file at: /private/etc/pear.conf
You may want to add: /usr/lib/php to your php.ini include_path
STDERR:
22:21:32.917 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/ServerEventAgentSetup.sh
RESULT CODE: 0
STDOUT: {
service = "com.apple.ServerEventAgent";
}
STDERR:
22:21:33.169 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/SetAFPClientCount.sh
RESULT CODE: 0
STDOUT:
STDERR:
22:21:33.352 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/SetAFPEncoding.rb
RESULT CODE: 0
STDOUT:
STDERR:
22:21:33.669 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/SetDefaultNFSThreadCount.sh
RESULT CODE: 0
STDOUT:
STDERR:
22:21:33.705 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/SMARTMonitorSetup.sh
RESULT CODE: 0
STDOUT: {
service = "com.apple.disks.smart.status";
}
STDERR:
22:21:33.725 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/smbsetup.sh
RESULT CODE: 0
STDOUT:
STDERR:
22:21:33.927 Setup extra succeeded:
path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/CommonE xtras/webCommonSetup
RESULT CODE: 0
STDOUT:
STDERR:
22:21:33.928 Setup extra failed with code 1 at path: /Applications/Server.app/Contents/ServerRoot/System/Library/ServerSetup/Migrati onExtras/001-migrationExtraServerRestore.pl
22:21:56.024 touching SetupRegComplete
22:21:56.041 touching ServerSetupDone
22:21:56.041 touching PromotionDone