...
| Code Block | ||
|---|---|---|
| ||
BEGIN TRAN DECLARE @ApplicationId INT; SELECT @ApplicationId = ApplicationId FROM dbo.Applications WHERE ApplicationNameClaimSetName = 'Ed-Fi ODS Admin App' DELETE FROM dbo.ClientAccessTokens WHERE EXISTS ( SELECT 1 FROM dbo.ApiClients WHERE ClientAccessTokens.ApiClient_ApiClientId = ApiClients.ApiClientId AND Application_ApplicationId = @ApplicationId ) DELETE FROM dbo.ApiClients WHERE Application_ApplicationId = @ApplicationId DELETE FROM dbo.ApplicationEducationOrganizations WHERE Application_ApplicationId = @ApplicationId DELETE FROM dbo.ProfileApplications WHERE Application_ApplicationId = @ApplicationId DELETE FROM dbo.Applications WHERE ApplicationId = @ApplicationId DELETE FROM dbo.OdsInstances DELETE FROM adminapp.SecretConfigurations COMMIT TRAN |
...
The following JSON code block explains the the parameters required and their intention:
| Code Block | ||||
|---|---|---|---|---|
| ||||
{
//These are the credentials used to access the EdFi_Admin database.
"AdminCredentials":{
"Password":"[dbpassword]",
"UserName":"[dbuser]"
},
// This is the address of the MsSQL server. This can be a DNS or an IP Address.
"HostName":"[the SQL Server: sql.somthing.com]",
// These are the credentials that will be stored encrypted that the Admin App will use to connect to the Ed-Fi ODS API
"ProductionApiCredentials":{
"Password":"[SecurePassword]",
"UserName":"EdFiOdsProductionApi"
},
"AdminAppCredentials":{
"Password":"[SecurePassword]",
"UserName":"EdFiOdsAdminApp"
}
} |
Modify the SQL statement below by providing the User Name and Password for the required fields marked with square brakets "[...]"
Following the steps above open SSMS or Azure Query Editor and execute the following statement against the EdFi_Admin database.
| Code Block | ||||
|---|---|---|---|---|
| ||||
BEGIN TRAN
UPDATE adminapp.AzureSqlConfigurations set field='{"AdminCredentials":{"Password":"PW Specified in Deployment Script","UserName":"SERVER Master UN"},"HostName":"","ProductionApiCredentials":{"Password":"Enter PW","UserName":"EdFiOdsProductionApi"},"AdminAppCredentials":{"Password":"","UserName":"EdFiOdsAdminApp"}}' WHERE Id=1;
COMMIT TRAN |
...
Note: That older versions of Admin app need the presence of “SetupRequired.txt” “SetupRequired” file. This indicates to the first time setup process that it has not run. If the file not present, this means that the first-time setup was completed. Recreating the file will enforce the First time setup process to run again.
To create this file just create text file with the name “SetupRequired.txt” “SetupRequired” and set the content of it to: Placeholder file to let the AdminApp know additional setup of the system is required.
...