Need to rebuild VVUSERS2 in an Instance

[mguske]

I am creating a new Instance and I noticed another new Instance did not have the VVUSERS2 logical file.
How do I rebuild it in the Instance's library?
I didn't see any Source in QDDSSRC. Is it somewhere else?

[robert.swanson]

The source code for all the Valence SQL-based tables can be found in file QSQLSRC. The index creation command for VVUSERS2 would be in the source member for VVUSERS. Specifically, this:

CREATE UNIQUE INDEX your_library.VVUSERS_ALL                    
 ON your_library.VVUSERS ( VVLOGINID );                        
                                                          
RENAME INDEX your_library.VVUSERS_ALL TO SYSTEM NAME VVUSERS2;  
                                                          
LABEL ON INDEX your_library.VVUSERS_ALL                        
 IS 'VVUSERS by login ID';                                                                                    ?

If VVUSERS2 didn't get created normally in your new instance, perhaps your 'from' instance VVUSERS table somehow has two records with the same VVLOGINID value.

[mguske]

I do see a duplicate VVLOGINID value in the VVUSERS file, but when I try to delete the record via SQL, I get a "Delete prevented by referential constraint
Q_VVDEV6_VVUSRDFLTS_VVUSRID_00001 in SPACEHRDEV." error.
How do I delete the duplicate record if the Instance won't come up to get into the Users list??

[robert.swanson]

The VVUSRID for the record you're trying to delete in VVUSERS apparently exists in VVUSRDFLTS, so you'll need to delete the record in VVUSRDFLTS first. However you might want to check the VVUSRID for the other duplicate record, as perhaps that one doesn't already exist in VVUSRDFLTS (or elsewhere). If that's the case, delete that record instead.

Ultimately, for whichever VVUSRID you want to remove from VVUSERS, you'll first need to ensure no records exist for that same VVUSRID in the following seven tables:
VVDEVS
VVSESSDATA
VVUSRAPPS
VVUSRAUTH
VVUSRDFLTS
VVUSRENX
VVWEBS200

There must have been some unusual database incident that caused a record violating a foreign key constraint to get into VVUSERS like that. Very unusual!

[mguske]

Yay! That got me in :).
Two more questions, if you don't mind.

1. Where in the configuration files does the red box stuff reside?

image.pngimage.png?

2. Where in the configuration files does this red box string reside:

image.png?
Thanks!
Matt?

[robert.swanson]

Hi Matt,

Most likely those portal customizations are in your Hook.js file...

https://valence6.helpdocsonline.com/getting-started-customizing-the-portal

[mguske]

I need to dig into the Hook.js definitions to customize the files for this particular Instance.

However, I recently copied an existing Instance to a NEW Instance. I defined a new Port#. The URL was added to DNS and I can ping it.
But when I try to fire up the NEW Instance in the browser, I get a "Forbidden - by rule. You do not have permission to access / on this server" error.
Is this a Hook.js issue? I would think it should bring up the Log In screen the same as the copied-from Instance, but I'm not even getting that far.
Any suggestions?

[robert.swanson]

Check the Apache error log for the new instance -- should be the latest error_log file in /www/<new_instance_name>/logs/.

It could be object or IFS authority issues for the new instance, which might show up in the log.

Or it could be something on the Apache configuration for that instance, as that "Forbidden by rule" typically stems from Require, Order/Allow/Deny, or equivalent protection directives. Normally those should be equivalent to the instance you copied from, adjusted for the new library and IFS directory names. But perhaps something didn't get adjusted due to some unique restrictions there, especially if you didn't use a high-authority user profile to perform the instance copy.

?
?
?

[mguske]

I recopied my Instance from a working one. In theory, the Hook.js file should show all the information from the copied Instance - but I don't think I am getting that far because it is not connecting.
In the notes from my predecessor, he noted a "Override.css" file. Where does that live and what does it do?

[sean.lanktree]

Just want to be sure, you used Instance Manager to copy the instance, correct? The file you are looking for resides in: /YOUR_INSTANCE/resources/desktop/themes/css/Portal/overrides.css

[mguske]

Yes, I used Instance Manager to copy my new Instance.
I'm still getting the "Forbidden - by rule" connection error.
The logs in the /www/Instance only shows me starts and stops - no permissions errors.
Is there a way to perform a Trace to see where specifically the connection is failing?

[mguske]

image.png?

Where is "Environment Base" defined in the configuration files when I go to log out of an Instance?