Toby Mills Posted August 12, 2020 Share Posted August 12, 2020 Hi guys Since several of us are migrating from 8105m to 82x, you might notice that we used to have a Installation Worksheet in the 8105m Installation and Configuration manual. This is the old installation worksheet This is not really provided in the newer documentation last I looked (which was a while back). So I made up my own. Ill attach the Excel file that is similar to what I use to keep up with Dev / Eval and Prod environments. WF8207_installation_worksheet.xlsx (14.0 KB) Of course all the info contained here is fake or the factory defaults. I thought it might help you guys as you are gearing up for installs. This worksheet is geared toward Windows with SQL Server for a repository, but you could easily alter it for whatever youre using. Feel free to add things like VM names and IP addresses, Tomcat versions, JRE Versions etc. Hope it helps you keep up with the myriad of questions you have to answer. I think I color coded each section to match a different install screen to make it easy to follow along. Kind of helps to know all the pieces youll need to fill in before you get started. When I do my installs, I open a new Worksheet for each machine and then screenshot the heck out of my install steps so I can go back and see what I did (or maybe didnt do). Good luck! Toby Mills, CISSP Link to comment Share on other sites More sharing options...
Lori McClellan Posted August 13, 2020 Share Posted August 13, 2020 Am I missing something The spreadsheet open to cell B22 which has: wfadmin (needs dbo permissions) No cells/grids/tabs Link to comment Share on other sites More sharing options...
Toby Mills Posted August 13, 2020 Author Share Posted August 13, 2020 Hi Lori It should have a whole bunch of rows to fill in. Let me check. I added that bit about needing DBO permissions because the ID you put here needs to be able to drop/create tables and so forth. I was just trying to differentiate it from like admin which is the default WebFOCUS admin id. If I had the spreadsheet open at the time I tried to copy it up, it might have gotten corrupted. Stand by. Thanks! Toby Link to comment Share on other sites More sharing options...
Toby Mills Posted August 13, 2020 Author Share Posted August 13, 2020 Hey Lori It looks okay to me: image.png12611057 70.4 KB Let me try re-attaching it here. WF8207_installation_worksheet.xlsx (14.0 KB) If you want to get me your email address, I can send it to you that way. You can use a direct message instead of the forum if you dont want your email shown to the world. Thanks! Toby Link to comment Share on other sites More sharing options...
Lori McClellan Posted August 13, 2020 Share Posted August 13, 2020 So much better - Thank you Link to comment Share on other sites More sharing options...
Debra Waybright Posted August 18, 2020 Share Posted August 18, 2020 Toby, Thanks for sharing! I will make sure to pass this along to our server guy. We are looking to upgrade to 8207 the beginning of next year. Deb WF 8203 with SQL Server Link to comment Share on other sites More sharing options...
Evelyn Schilling Posted October 18, 2021 Share Posted October 18, 2021 Thanks for sharing Toby. Any chance you have an updated Policy Design Worksheet for Security Hope all is well with you Link to comment Share on other sites More sharing options...
Toby Mills Posted October 19, 2021 Author Share Posted October 19, 2021 Morning Evelyn! I wish I had a more recent Policy Design Worksheet. Is there a particular thing youre looking for I wonder if we could make one ourselves Let me poke around. Link to comment Share on other sites More sharing options...
Evelyn Schilling Posted October 19, 2021 Share Posted October 19, 2021 I have one of Vashti originals from 8.0. If you do not find a copy of her spreadsheet I will send you what I have. Link to comment Share on other sites More sharing options...
Toby Mills Posted October 19, 2021 Author Share Posted October 19, 2021 Ive got the old spreadsheet somplace. It think we could make up a newer sheet by using UOA_PSETs image.png949148 6.68 KB Looks like the permissions will give us the list of things from the factory. Id swear this sort of thing used to be harder to find. Heres DomainBasicUser: opReadComments:PERMIT;opLibrary:PERMIT;opViewPortal:PERMIT;opList:PERMIT;opViewProps:PERMIT;opCreateComments:PERMIT;opShortcut:PERMIT;opDisplayVersionInfo:PERMIT;opInfoSearch:PERMIT;opFavorites:PERMIT;opMagnify:PERMIT;opMobileFavorites:PERMIT;opRecents:PERMIT;opRepositorySearch:PERMIT;opStopRequests:PERMIT;opEditComments:PERMIT;opMobileFavesEmail:PERMIT;opMobileFavesPrint:PERMIT;opMobileFavesSave:PERMIT;opCreateMyFolder:PERMIT;opRun:PERMIT;opRunDef:PERMIT;opRunEnhanced:PERMIT;opOlap:PERMIT;opSaveDef:PERMIT;opCustomizePortal:PERMIT;opParmrpt:PERMIT; I think the hard part about making a report out of this before (like 2016) was that I could never find a list of all the privilege names (which were originally called operations - thats why they all start with op like opList, opRun etc). Theres also the chance that looking under the webfocus82configresource_templates - you might be able to read the XML to make a list. Or - better - maybe just open a case to ask if they have a new one. Ive got a couple of fires going on this week and cant work on building the new sheet. If anybody reading along wants to make a new one up, thatd be great! Wed be happy to see all the default check marks for the various Roles. To mimic the original sheet, youd need a list of privs (aka operations) down the left side, and then go ACROSS role names from UOA_PSETs. Turn on a check mark if the PSET has a PERMIT in it for a given priv. TABLE FILE YOURFILE SUM CHECKMARK BY PRIVILEGE ACROSS ROLE END Thats the gist of it if you can find all the parts. Link to comment Share on other sites More sharing options...
Toby Mills Posted October 19, 2021 Author Share Posted October 19, 2021 Well - I found a list of privileges after a little piecing together. I still havent tied the default Roles to these privs, but this is the hard-to-find part to use in a report. ibss_ops_by_group.xlsx (17.7 KB) Man there are a LOT of privs in there. Maybe some really arent used much. The next thing would be to turn the data in the UOA_PSETs into an individual row per privilege. Then its just MATCHing that dataset together with this one and we should have a report. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now