While I don't claim it was the best way to do it, here is how I was able to get a working system back.
Using an SQL database tool that was provided by my ISP, I poked around and ended up finding that all of the settings are stored in dbo.ModuleSettings.
I issued the following SQL command
select * from dbo.ModuleSettings where SettingName = 'SSLEnabled'
This showed me the following result
| ModuleID |
SettingName |
SettingValue |
| 354 |
SSLEnabled |
True |
From here, I used the ModuleID field
select * from dbo.ModuleSettings where ModuleID = 354
| ModuleID |
SettingName |
SettingValue |
| 354 |
ControlPanelMode |
VIEW |
| 354 |
ControlPanelSecurity |
MODULE |
| 354 |
ControlPanelVisibility |
MIN |
| 354 |
InlineEditorEnabled |
False |
| 354 |
SSLEnabled |
True |
| 354 |
SSLEnforced |
False |
| 354 |
SSLURL |
https://securehost9.< my ISP's SSL URL> |
| 354 |
STDURL |
|
I was able to use the SQL tool provided to clear the SSLEnabled and SSLURL fields
| ModuleID |
SettingName |
SettingValue |
| 354 |
ControlPanelMode |
VIEW |
| 354 |
ControlPanelSecurity |
MODULE |
| 354 |
ControlPanelVisibility |
MIN |
| 354 |
InlineEditorEnabled |
False |
| 354 |
SSLEnabled |
False |
| 354 |
SSLEnforced |
False |
| 354 |
SSLURL |
|
| 354 |
STDURL |
|
Unfortunately, this didn't work at first until I realized that the DotNetNuke application needed to be restarted for this change to take effect. Since I couldn't restart (no access to the admin or host menus), I had to let the process age out. I tried back in an hour and it appears to be working.
When it came back up, I had to do two more steps:
1) I went into the Admin->Site Settings to verify that the fields for SSL Settings were cleared. I had to delete a space character from SSLURL for some reason.
2) Admin->Site Settings at the bottom I had to remove the offensive SSLURL from the Portal Aliases.
Any other tips or suggestions on this would be appreciated.
Kevin