Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Upgrade Enterprise 10.0.0 to 10.2 Immediately Expires Session - Missing Upgrade Instructions #1411

Closed
scadahacker opened this issue Apr 20, 2021 · 15 comments

Comments

@scadahacker
Copy link

As several of us continue to ask, could someone PLEASE post the proper upgrade instructions from 10.0.0 to 10.2 for the Enterprise version?

First, your illustration for the modifications of the Connection Settings in web.config has a misplaced double quote.
-- connectionString="data source=localhost";
should be changed to
-- connectionString="data source=localhost; ...
because the end quote appears towards the end of each line.

I started with a working version of 10.0.0 and its contents. Stopped IIS and then replaced the inetpub\wwwroot directories deleting everything but aspnet_client and Data, and replaced with new 10.2 content. Since there was no Data subdirectory with 10.2, assumed the MDF from 10.0.0 is sufficient. Restarted IIS.

When opening home logon page, session immediately expires with message "Your session has expired, a connection error has occurred, or you are no longer authorized to access that assessment. Please log in again." Happens with any user ... those created with "adduser" or via web page.

Deleted wwwroot contents (except aspnet_client and Data) and reloaded with 10.0.0 code and web.config aligned with v10.0.0 and everything worked fine again.

Advise if you want access to site or content.

@DeltaZ0912
Copy link

DeltaZ0912 commented Apr 22, 2021

I'm having this same problem. Anyone solve it yet? I tried deleting the "data" folder to see if it made a difference. It doesn't. Later tried re-installing the whole thing and got the same error.

@bgbearcatfan
Copy link

We're also experiences the same troubles. This occurs after an upgrade, and also if performing a fresh install.

@bobbybermudez
Copy link

Having same issue with fresh Enterprise install of 10.2 but using the only MDF file we could find from the 10.0.0 release

@scadahacker
Copy link
Author

Just wanted to touch base and see if anyone has solved this problem. Kind of frustrating to have the developers go silent for so long. I am still using 10.0.0 and would really like to upgrade. Let me know if anyone has had any luck on this issue.

@bgbearcatfan
Copy link

Unfortunately, after many hours of troubleshooting, I have made zero progress. The only real option is to use version 10.0 at this point...

@meyerje
Copy link

meyerje commented Jun 3, 2021 via email

@ericmansfield
Copy link

Did you use the AddUser application to create a user without using a mail host? You need to or you will get the error.
https://github.com/cisagov/cset/releases/tag/9.2.2enterprise

@dfcuderek
Copy link

I have the same issue with user logging in. I briefly see initial page where you can create new or choose existing assessment. I have email host so was able to create new users in 10.0 and despite the expiration popup I was able to create users in 10.2. I've also tried adding dbo_owner to the DB user and have also tried using the sa account in the web.config connection string.

@bgbearcatfan
Copy link

Has anyone made any progress with this? I get the same issue (Immediately Expires Session) with the latest 10.3 version as well.

@dfcuderek
Copy link

If you upgrade to 10.3 binary you need to use the 10.3 binary database released by @inlguy which you'll find under releases. I was not able to get around the expired session issue the new DB. However, if you have assessments in your current database you may want to export them because the 10.3 database is a fresh database not an upgrade. To do that you will need to start over and delete everything in your inetpub\wwwroot folder (or whatever folder you stored your site files in) but make sure you maintain the connection strings from the original web.conf. You won't touch the current database files so no need to open SSMS. Once the 10.0 files are back in place and the web.conf connection strings and mail server info is correct then Restart IIS and try to access. You will see "export" next to your assessments. For future assessments, If you don't already, I suggest exporting every completed assessment for backup purposes. I also suggest have a second "Test" CSET site that you can easily create in IIS to test upgrades before performing them (I can give more info on this if needed). I hope this helps.

@bgbearcatfan
Copy link

Thanks for the reply!

Luckily, this is a new project that we were never able to fully get off the ground using 10.0-10.1 versions. So we tried a brand new deployment using the 10.3 binaries and the recently released 10.3 database files, which immediately expires the session (none of the tricks like using dbowner privileges have made any improvement for us). So far we've tried using a combination of sever 2012-2019, and MSSQL 2014-2019.

@ericmansfield
Copy link

Thanks for the reply!

Luckily, this is a new project that we were never able to fully get off the ground using 10.0-10.1 versions. So we tried a brand new deployment using the 10.3 binaries and the recently released 10.3 database files, which immediately expires the session (none of the tricks like using dbowner privileges have made any improvement for us). So far we've tried using a combination of sever 2012-2019, and MSSQL 2014-2019.

Did you use the AddUser application to create a user without using a mail host? You need to or you will get the error.
https://github.com/cisagov/cset/releases/tag/9.2.2enterprise

@ericmansfield
Copy link

Has anyone made any progress with this? I get the same issue (Immediately Expires Session) with the latest 10.3 version as well.

Did you use the AddUser application to create a user without using a mail host? You need to or you will get the error.
https://github.com/cisagov/cset/releases/tag/9.2.2enterprise

1 similar comment
@ericmansfield
Copy link

Has anyone made any progress with this? I get the same issue (Immediately Expires Session) with the latest 10.3 version as well.

Did you use the AddUser application to create a user without using a mail host? You need to or you will get the error.
https://github.com/cisagov/cset/releases/tag/9.2.2enterprise

@martbillinl
Copy link

Closed ticket due to release of 10.3 binary database release fix

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

8 participants