Local DB fails to install with error "Expected end-of-line" after upgrade to SGOS 7.4.10 or above

Products

• ProxySG Software - SGOS
• ISG Proxy

Issue/Introduction

Edge SWG fails to install local DB file with an error like below:

ERROR: (line 8745): Expected end-of-line: '['

Line number and character in '' may be different depending on the local DB file content. 

Environment

• Edge SWG is running 7.4.10 and above 
• Local DB is enabled in Edge SWG

Cause

Starting from SGOS 7.4.10.1, Edge SWG allowed characters in Local DB got extended. Refer to the release notes snippet below:

If Local DB file has URL with comments and there is no space/tab separator between those, it may cause the error on DB installation. A sample DB line that may error is below:

example.com;Example URL

where example.com is URL and ";Example URL" is a comment to it. 

Resolution

Error message will indicate a line number is the local DB file that require attention. Please review those lines and add space or tab separator between URLs and comments so they look like below:

example.com ;Example URL