[CLOUDSTACK-1969] Ubuntu fresh Install- SystemIntegrityChecker looking for "schema-40to410.sql" wrong location and failed to start MS

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.1.0, 4.2.0
• Fix Version/s: 4.2.0
• Component/s: Packaging
• Security Level: Public (Anyone can view this level - this is the default.)
• Environment: Ubuntu 12.04
• Assignee: Unassigned
• Reporter: Rayees Namathponnan
• Created: 08/Apr/13 19:12
• Updated: 22/Aug/13 22:24
• Resolved: 05/Aug/13 22:44

Description

Step 1 : Create new 4.1 build and package on ubuntu 12.04
Step 2 : Run cloudstack-setup-databases and cloudstack-setup-management

Actual Result

Failed to start Management server, "schema-40to410.sql" available in /usr/share/cloudstack-management/setupdb/schema-40to410.sql, but SystemIntegrityChecker script not looking in this location,please see the log

2013-04-08 11:24:55,549 DEBUG [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) Running upgrade Upgrade40to41 to upgrade from 4.0.0-4.1.0 to 4.1.0
2013-04-08 11:24:55,553 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-40to410.sql in the classpath
2013-04-08 11:24:55,553 DEBUG [utils.script.Script] (Timer-1:null) System resource: null
2013-04-08 11:24:55,554 DEBUG [utils.script.Script] (Timer-1:null) Classpath resource: null
2013-04-08 11:24:55,554 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-40to410.sql
2013-04-08 11:24:55,554 DEBUG [utils.script.Script] (Timer-1:null) Current binaries reside at /usr/share/cloudstack-management/webapps/client/WEB-INF/lib
2013-04-08 11:24:55,555 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-40to410.sql in /usr/share/cloudstack-management/webapps/client/WEB-INF/lib/db/schema-40to410.sql
2013-04-08 11:24:55,555 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-40to410.sql in /usr/share/cloudstack-management/webapps/client/WEB-INF/lib/db/schema-40to410.sql
2013-04-08 11:24:55,555 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-40to410.sql in /usr/share/cloudstack-management/webapps/client/WEB-INF/db/schema-40to410.sql
2013-04-08 11:24:55,555 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-40to410.sql in /usr/share/cloudstack-management/webapps/client/db/schema-40to410.sql
2013-04-08 11:24:55,556 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-40to410.sql in /usr/share/cloudstack-management/webapps/db/schema-40to410.sql
2013-04-08 11:24:55,556 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-40to410.sql in /usr/share/cloudstack-management/db/schema-40to410.sql
2013-04-08 11:24:55,556 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-40to410.sql in /usr/share/db/schema-40to410.sql
2013-04-08 11:24:55,556 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-40to410.sql in /usr/db/schema-40to410.sql
2013-04-08 11:24:55,556 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-40to410.sql in /db/schema-40to410.sql
2013-04-08 11:24:55,557 DEBUG [utils.script.Script] (Timer-1:null) Searching in environment.properties
2013-04-08 11:24:55,557 DEBUG [utils.script.Script] (Timer-1:null) environment.properties says scripts should be in /usr/share/cloudstack-common
2013-04-08 11:24:55,557 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-40to410.sql in /usr/share/cloudstack-common/db/schema-40to410.sql
2013-04-08 11:24:55,558 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-40to410.sql in /usr/share/cloudstack-common/db/schema-40to410.sql
2013-04-08 11:24:55,558 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-40to410.sql in /usr/share/db/schema-40to410.sql
2013-04-08 11:24:55,558 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-40to410.sql in /usr/db/schema-40to410.sql
2013-04-08 11:24:55,558 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-40to410.sql in /db/schema-40to410.sql
2013-04-08 11:24:55,559 DEBUG [utils.script.Script] (Timer-1:null) Searching in the current directory
2013-04-08 11:24:55,559 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-40to410.sql in /tmp/cloudstack-management-temp/./db/schema-40to410.sql
2013-04-08 11:24:55,559 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-40to410.sql in /tmp/cloudstack-management-temp/./db/schema-40to410.sql
2013-04-08 11:24:55,559 WARN [utils.script.Script] (Timer-1:null) Unable to find script db/schema-40to410.sql

I manually copied "/usr/share/cloudstack-management/setup/db" to "/usr/share/cloudstack-management/db" and re-run scripts "cloudstack-setup-databases" "cloudstack-setup-management", after this management server start running

Expected Result

MS server should start and should be accessible trough console