By default Readysell 8 testing environments :
Hot Fix staging has database r8hotfixstaging in RS server
Adhoc 1 and 2 have database r8adhoc1 and r8adhoc2 in RS server
Feature Staging 1 and 2 have database r8featurestaging1 and r8featurestaging1 in RS server
Stable has r8stable database in RS server
Demo (TBA)
Cloud and Cloud (Admin) - not used anymore, refer to new shortcut for Cloud WVD
How to use different database with one of those Readysell 9 test instance, for example :
With FeatureStaging2 test instance need to use database readysell_wb from DevServerNuc*1 server IP 192.168.20.123
*1)special DevServerNUC - 18/02/2021- there is an issue due to port forwarding, need a special steps :
a. Run Heidi from RS server, connect to 192.168.20.123 port 3306 with valid username password
b. Error with will pop up and note the new IP address (error : can’t connect to 192.168.20.122)
c. Run Heidi from DevServerNuc
d. Run this script :
CREATE USER 'root'@'192.168.20.122' IDENTIFIED BY 'root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.20.122';
SELECT * FROM mysql.user;
2. Make a copy of Database.config on FeatureStaging2 server and rename to Database_wb.config (C:\Readysell8\Readysell.Server.FeatureStaging2)
3. Change in Database_wb.config : server=192.168.20.123;port=3306;user id=root;password=[xxx];database=readysell_wb
4. Rename Database.config to Database_original.config
5. Rename Database_wb.config to Database.config
6. Repeat steps 2-5 for FeatureStaging2 Win (C:\Readysell8\Readysell.Win.FeatureStaging2)
7. Repeat steps 2-5 for client Readysell on workstation :
a.
b. Might need to test and do step *1) - blue colour text- from this workstation
Setup is done, now continue with configuration :
Manual update database : /wiki/spaces/INT/pages/765886504
Make sure service is running
Run Readysell client from workstation
If need to to deploy and update to another version :
a. Set Task (Schedule time is relative)
b. Set System Type
c. Hot fix staging service port 8225 ; AdHoc1 8255 ; Adhoc2 8265 ; FeatureStaging 8245 ; FeatureStaging2 8275 ; Stable 8215
(when entered to Readysell System should be Port - 1 )
d. RS server IP address 192.168.20.3
e. Restart service
f. Upgrade schedule will trigger the upgrade Readysell and update database
IMPORTANT !!!
Change to database which database name is NOT r8hotfixstaging, r8adhoc1, r8adhoc2, r8featurestaging1, r8featurestaging2, or r8stable ; Readysell 8 Test instance will become Production mode.
Add /Environment Test to workstation shortcut
or Change the database name to list above
Make sure the Readysell 8 Test instance running with RED color ribbon
/wiki/spaces/INT/pages/765886504