Gasboy SiteOmat Maintenance Manual - Manual (Page 228)

224
SiteOmat Setup and Maintenance Manual – MDE 4817G
The system is running under embedded Linux OS. Due to this In order to have an access to the
machine we have to log into the system via “Putty” as shown below: FCC IP (default :
192.168.1.104) + SSH protocol + Port 22.
Figure 8-30. Logging into the System via “Putty”
Note : The connection is using ssh protocol it means a secure Shell, due to this reason a login is
requested (user : root, pass : ortech).
The system store the DB under two directories:
I. FCC DB files can be found under /usr/local/orpak/db
II. BOS DB files can be found under /usr/local/orpak/bos/db
The examples that are shown below are made with the FCC DB but the handling of the BOS DB is
exactly the same.
8-7.1. Getting Inside the Directory of the DB Files & Start a Session of SQLite
In order to get into the directory type the following command: “cd /user/local/orpak/db/”
To show the entire file that exists in the directory type the command “ls -1”
At this point the user should be inside the directory of which all the DB files (of the fcc) are stored.
To “work” on a specific files & perform sql quires type “sqlite3” + name of the db file, for example
“sqlite3 DATA.DB”