Mailing-List: contact cloudstack-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Received-SPF: pass (athena.apache.org: local policy)
From: Hugo Trippaers <HTrippaers@schubergphilis.com>
To: 'Rohit Yadav' <bhaisaab@apache.org>, "cloudstack-dev@incubator.apache.org"
	<cloudstack-dev@incubator.apache.org>
Subject: RE: [DISCUSS] Fixing cloud-setup-databases
Thread-Topic: [DISCUSS] Fixing cloud-setup-databases
Thread-Index: AQHOCEDNvU+791jZIUKxY9MKelY62Zh017/g
Date: Mon, 11 Feb 2013 16:27:00 +0000
Message-ID: <6DE00C9FDF08A34683DF71786C70EBF02F6C1C4A@SBPOMB402.sbp.lan>
References: 
 <CANLSSBWxmb+Y5qRTVTqeSUy-TAm4m8La=k5dYy5CrBmsbP9rtw@mail.gmail.com>
In-Reply-To: 
 <CANLSSBWxmb+Y5qRTVTqeSUy-TAm4m8La=k5dYy5CrBmsbP9rtw@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

Hey Rohit,

As far as I know these are two disctict use cases.=20

The maven deploy db is just for developers or at least people who are just =
working from source directly, and should provide a convenient way for devel=
opers to refresh their test database or deploy a new schema.

The cloud-setup-databases is a tool that is used the sysadmins to setup a d=
atabase after they have deployed the packages. It has several purposes, set=
up db.properties, configure encryption and load a database (if the supplied=
 database is empty).

In my view both should remain for these purposes, but they should be in-syn=
c and also the upgrade sql script should be in sync with these changes.

Cheers,

Hugo

> -----Original Message-----
> From: rohityadav89@gmail.com [mailto:rohityadav89@gmail.com] On Behalf
> Of Rohit Yadav
> Sent: Monday, February 11, 2013 11:15 AM
> To: cloudstack-dev@incubator.apache.org
> Subject: [DISCUSS] Fixing cloud-setup-databases
>=20
> DatabaseCreator was introduce for 4.1 so both maven deploydb target and
> cloud-setup-databases would use that.
> Following does not run on maven's deploydb:
> cloudbridge_db.sql
> schema-level.sql
> server-setup.sql
>=20
> Following runs only from maven's deploydb:
> com.cloud.upgrade.DatabaseUpgradeChecker
>=20
> Following runs only from cloud-setup-databases:
> com.cloud.test.DatabaseConfig
>=20
> Pl. advise if we need to run those as part of maven's deploydb, or cloud-
> setup-database or both?
>=20
> Regards.