How to Open System Log file?

Ignition
,
1

Hi All,

I just want to know how to open the exported system logs file (IDB File Type).

I tried to open it using SQLite but no luck. It says could not open database file.

Thanks.

2

SQLite3 ?

1 Like
3

Hi pturmel,

Thanks for your reply.

I tried SQLite and SQLite Studio but it doesn’t recognize .idb as a file.

It says the file is not a database.

4

I pointed to SQLite3 because the version likely matters. Did you try SQLite version 3 ?

1 Like
5

I’m using SQLite Version 3.12.2
and SQLiteStudio 3.3.3.

6

Are you sure the file downloaded completely from the gateway? IIRC, a truncated file won’t open.

2 Likes
7

Hi PTurmel,

Thanks again for your reply.

Is there a proper way to open it? Like change the file type to .sqlite?

On SQLiteStudio(3.3.3) > Add Database (Ctrl+O) > Database Type SQLite 3 Selected. > Browse IDB File from ignition gateway system logs (can’t able to browse since sqlite only supports .db , .sdb, .sqllite.

I also tried to change the file type so it can browse and select it but still no luck.

8

SQLiteStudio worked just fine for me:

image
image966×658 51.6 KB

You can choose ‘All Files’ in the file chooser to bypass the simple check for ‘known’ SQLite formats:
image

2 Likes
9

Opening using sqlite3 system_logs.idb seems to also work okay too if you’re on Linux…

https://asciinema.org/a/4c3Dn5Wwf7jf4uguUgcuyvJYF

1 Like
10

Hi All,

Thanks PGriffith, PTurmel, and KCollins1 for your inputs.

The exported .idb file from Ignition Gateway doesn’t work. What I did was I went to the Ignition folder and get a copy of the system_logs.idb and it works. I’m not sure why does the exported file from Gateway doesn’t work.

Anyway, Thanks a lot!

1 Like
11

Had same issue - thanks for the suggestion!