Hi Community,
Not sure if this is the right area to ask for help regarding this issue, so if not, please point me in the right direction.
My issue is that I recently upgraded a site of ours to 8.0.4 and we were unable to access the Host Settings. We then performed the following fix:
-
Connect to your database using MSSQL Management Studio.
-
Expand Databases > [your database name]> Tables.
-
Right click on the dbo.HostSettings table and then the Edit Top 200 Rows option.
-
Once the contents of the table loads locate the SMTPPassword option in the SettingName column.
-
Delete the contents of the SettingValue cell which is your current SMTP Password next to the SMTPPassword cell and click out of that cell to save the changes.
-
Recycle your sites application pool. This must be done server side and not within the website itself.
From here you will be able to access the Host Settings. Follow the remaining steps to complete the process.
-
Log in to your DotNetNuke website as Host.
-
Navigate to Host > Host Settings > Advanced Settings > SMTP Server Settings.
-
Re-enter the password for the SMTP account in the SMTP Password field.
-
Click Update at the bottom of the page.
Afterwards of Step 6, we are able to access the Host Settings, but when we go to input the SMTP password for it, it then gives us the following error message (which is the same error message we were experiencing before performing the above steps)
Error: Host Settings is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Request for ConfigurationPermission failed while attempting to access configuration section 'system.web/machineKey'. To allow all callers to access the data for this section, set section attribute 'requirePermission' equal 'false' in the configuration file where this section is declared. ---> System.Security.SecurityException: Request for ConfigurationPermission failed while attempting to access configuration section 'system.web/machineKey'. To allow all callers to access the data for this section, set section attribute 'requirePermission' equal 'false' in the configuration file where this section is declared. ---> System.Security.SecurityException: Request for the permission of type 'System.Configuration.ConfigurationPermission, System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed. at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet) at System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap, StackCrawlMark& stackMark) at System.Security.CodeAccessPermission.Demand() at System.Configuration.BaseConfigurationRecord.CheckPermissionAllowed(String configKey, Boolean requirePermission, Boolean isTrustedWithoutAptca) --- End of inner exception stack trace --- at System.Configuration.BaseConfigurationRecord.CheckPermissionAllowed(String configKey, Boolean requirePermission, Boolean isTrustedWithoutAptca) at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject) at System.Configuration.BaseConfigurationRecord.GetSection(String configKey) at System.Web.HttpContext.GetSection(String sectionName) at System.Web.Configuration.HttpConfigurationSystem.GetSection(String sectionName) at System.Web.Configuration.HttpConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection(String configKey) at System.Configuration.ConfigurationManager.GetSection(String sectionName) at DotNetNuke.Common.Utilities.Config.GetDecryptionkey() at DotNetNuke.Modules.Admin.Host.HostSettings.UpdateSettings(Object sender, EventArgs e) --- End of inner exception stack trace ---
However, when we refresh the page, it then brings up the Host Settings once more like normal. If we try to input the SMTP password, we get the same result. As well, if we try to export the site template, we get the following error message:
Error: is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Request for the permission of type 'System.Security.Permissions.EnvironmentPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. ---> System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.EnvironmentPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet) at System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap, StackCrawlMark& stackMark) at System.Security.CodeAccessPermission.Demand() at System.Environment.GetLogicalDrives() at SchwabenCode.QuickIO.QuickIOPathInfo.TransferParseResult(QuickIOParsePathResult parsePathResult) at SchwabenCode.QuickIO.QuickIOPathInfo..ctor(String anyFullname, String name) at DotNetNuke.Common.Utilities.FileSystemUtils.AddToZip(ZipOutputStream& ZipFile, String filePath, String fileName, String folder) at DotNetNuke.Modules.Admin.Portals.Template.SerializeFiles(XmlWriter writer, PortalInfo objportal, String folderPath, ZipOutputStream& zipFile) at DotNetNuke.Modules.Admin.Portals.Template.SerializeFolders(XmlWriter writer, PortalInfo objportal, ZipOutputStream& zipFile) at DotNetNuke.Modules.Admin.Portals.Template.cmdExport_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---
We are at a loss on how to fix this. Anyone come across this and if so, how did you fix it?