Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 48E5A200BC3 for ; Fri, 18 Nov 2016 23:00:45 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 47A0D160B04; Fri, 18 Nov 2016 22:00:45 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 92C49160B03 for ; Fri, 18 Nov 2016 23:00:44 +0100 (CET) Received: (qmail 16683 invoked by uid 500); 18 Nov 2016 22:00:43 -0000 Mailing-List: contact dev-help@fineract.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@fineract.incubator.apache.org Delivered-To: mailing list dev@fineract.incubator.apache.org Delivered-To: moderator for dev@fineract.incubator.apache.org Received: (qmail 17748 invoked by uid 99); 17 Nov 2016 01:48:08 -0000 X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.979 X-Spam-Level: * X-Spam-Status: No, score=1.979 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_HELO_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=ayacast.onmicrosoft.com DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ayacast.onmicrosoft.com; s=selector1-thitsaworks-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=1ZcJRase5QKKiEOOsSwjP9pqFT8e4alUd9+5tugORlM=; b=OfLY8Nnyy9z1FHAYmdk37GtoSlNLE8KyuOwJHul2MqMVG3CkCkGQulZ+tZ6tvka9FAv2BFwsv8SPC8F1gtcTChTsXKwyZFPsAZYeMgRO36wK5z5fAWDDWXyQPGrXCDKBvtisFsgoMLt5sAz7q1Stii8nWG02+NiRbQhghPRxMh0= From: Thynn Win To: "'mifos-developer@lists.sourceforge.net'" , "dev (dev@fineract.incubator.apache.org)" Subject: Mifos upgrade (Multi tenant env) and how to handle schema changes (if any) Thread-Topic: Mifos upgrade (Multi tenant env) and how to handle schema changes (if any) Thread-Index: AdJAa8MQn4hAbXZrRbe5cEginwAdUg== Date: Thu, 17 Nov 2016 01:47:36 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=thynn.win@thitsaworks.com; x-originating-ip: [71.167.9.4] x-microsoft-exchange-diagnostics: 1;CY4PR19MB0902;7:KcFk0jiVVBqw5ZAVXT71ke8P+cev7KnxtZvTGCpoXzy87PFCRMTu6w0EMp/1k0NsPBdfbxwY5CCEbxugwEJOaJXw+8Tn/Sl4tsOgbeS54bYYqVTrEwYIWiyO2KwuZObD+jJi6GLp8LBQgZ4lENETwa3VWOzXypMxtYSy7VVH9Gv5KqNt50ipLeDmzThzX/67Dv+Lo4e3qMPoeS684XL1DHFgBGlpJyBycaDA07taEZyuwCBOWmCcLmuJWs0sNIUMCVtfY47ZWKID3EF1vsQN5S7ez1IYlE75hj4Sr2CBcfTX3fRS2MV0HpKppf/WQ9P1aeQbW2/yV5y3g/MSWrKtke9ij3rLgSvhO0nMlwo7Tm0= x-ms-office365-filtering-correlation-id: 76f62501-fefe-40ae-73e0-08d40e8bb4dd x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001);SRVR:CY4PR19MB0902; x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:(158342451672863)(21748063052155); x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(6060326)(6040281)(601004)(2401047)(8121501046)(5005006)(10201501046)(3002001)(6041223)(6061324)(6043046);SRVR:CY4PR19MB0902;BCL:0;PCL:0;RULEID:;SRVR:CY4PR19MB0902; x-forefront-prvs: 01294F875B x-forefront-antispam-report: SFV:NSPM;SFS:(10009020)(6009001)(7916002)(199003)(189002)(53754006)(101416001)(97736004)(68736007)(106356001)(122556002)(189998001)(5001770100001)(33656002)(2906002)(3660700001)(3280700002)(99286002)(92566002)(76576001)(3846002)(105586002)(77096005)(107886002)(2900100001)(86362001)(66066001)(7696004)(6116002)(8676002)(102836003)(9686002)(74316002)(50986999)(7846002)(54356999)(7736002)(790700001)(87936001)(81156014)(8936002)(6506003)(81166006)(5660300001)(491001);DIR:OUT;SFP:1101;SCL:1;SRVR:CY4PR19MB0902;H:CY4PR19MB0903.namprd19.prod.outlook.com;FPR:;SPF:None;PTR:InfoNoRecords;A:1;MX:1;LANG:en; received-spf: None (protection.outlook.com: thitsaworks.com does not designate permitted sender hosts) spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: multipart/alternative; boundary="_000_CY4PR19MB0903C2A6C0666BFCACF0DE0FEFB10CY4PR19MB0903namp_" MIME-Version: 1.0 X-OriginatorOrg: thitsaworks.com X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Nov 2016 01:47:36.0885 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 016bae49-9fb2-449e-b368-94c076e8fbdb X-MS-Exchange-Transport-CrossTenantHeadersStamped: CY4PR19MB0902 archived-at: Fri, 18 Nov 2016 22:00:45 -0000 --_000_CY4PR19MB0903C2A6C0666BFCACF0DE0FEFB10CY4PR19MB0903namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi all, We are planning to upgrade from 16.03.03 to 16.09.01 (windows env). We woul= d like to know if the upgrade scripts are run at the re-start of tomcat ser= ver and will the data structure changes be applied to all tenant databases?= Suppose we have 5 tenants using the same application server but a differen= t database server for their tenant databases. We understand the application= will be upgraded with new war files but would like to know - 1) whether the data structure (dll statements) changes will be applied to a= ll tenants also 2) how to find out which release has database changes and which not. This w= ay, we can pay attention to which release has structure changes and also ve= rify them after the upgrade. For instance: We see that 16.08.01 has a feature for capturing client addre= ss and we assume it will have some database structure changes. If you could provide us advise or directions on how the upgrade generally w= ork in multi-tenant environment and how we can verify the changes, we would= appreciate it. Thank you, Thynn --_000_CY4PR19MB0903C2A6C0666BFCACF0DE0FEFB10CY4PR19MB0903namp_--