How to Create Root Password in MySQL 8

How to Create Root Password in MySQL 8

One of the most frustrating things is installing MySQL and then forgetting what password you set for the root user. This has happened to me on more than one occasion. You can reset the password with the following procedure. (more…)

How To Fix An Endless Adobe Validating Software License Screen

I really enjoy errors in software that occur randomly for no reason. 🙂 One that recently occurred was an installed Adobe application (InDesign) that suddenly failed to start. Reinstalling the software didn’t help. Starting the application would run Adobe Creative Cloud instead where it tried to endlessly validate a software license.
This was fixed by deleting 4 folders:

  • C:\ProgramData\Adobe\SLstore
  • C:\Program Files (x86)\Common Files\Adobe\Adobe PCD
  • C:\Program Files (x86)\Common Files\Adobe\caps
  • C:\Users\[User Name]\AppData\Local\Adobe\OOBE

Once deleted, InDesign was able to run again after I logged into Adobe with my credentials.

A Quick (Not Approved by Xerox) Way To Setup SSL On All uStores

When you have hundreds of stores in uStore, making updates on all of them takes a very long time. This doesn’t matter if your paid by the hour, but if your in a hurry and need everything updated quickly, the manual method is not the best solution. For your information, this method is described below. The procedure can take a few minutes to complete. Multiply that by hundreds of stores and you’ll see the problem.
Manual Method
In the uStore admin site,

  1. Take store offline.
  2. Open Store Setting -> Set Up Store
  3. In the Advanced tab, select the Security Option
  4. Press Save & Place Online

The change can easily be made by modifying a table in the uStore database. This method isn’t recommended by Xerox and I wouldn’t recommend it either to novice database administrators. For experienced users, make a backup of the database before you make any changes. MSSQL doesn’t ask “Are you sure you want to make this change?” when you run SQL queries.
SQL Method
In the uStore database, you will need to modify the Store table. Each store here has an SslOption field which defaults to 0 value (see table below):

SslOption Field
0 Not Secured
1 Secure All
2 Secure Critical Points

Select which SSL option that you want and run the following SQL command:
     UPDATE Store SET SslOption=@SslOption WHERE StatusID=1
     UPDATE Store SET SslOption=2 WHERE StatusID=1
This updates all active stores to SSL option: Secure Critical Points
After the SQL query is run, you need to force a cache refresh. The page for this is on your your uStore at (use the IP of your server):
In Cache update, press the Refresh Localization Cache button, Refresh ACL Cache button, and Refresh General Cache button. Not sure if all of these are needed, but I’ve done this and the stores were fine afterwards. If you don’t do a manual cache refresh, this will eventually occur in uStore, but if someone opens a store in the admin site and makes a modification, you may lose the changes your SQL query made.
And that’s it. Again, if your not an experience database administrator, don’t attempt this.