YDBSyslog; Using YottaDB from Lua

[K.S. Bhaskar]

Two recent items of interest are YDBSyslog and significant updates to using YottaDB from Lua.

YDBSyslog is a YottaDB plugin that uses journalctl to export syslog records and load them into a database. You can also run it as a daemon that follows the syslog and loads records in real-time. It produces an Octo DDL, which then allows you to run SQL queries on syslog records. By combining the data from multiple systems in a single database, you can run queries across systems. The README at https://gitlab.com/YottaDB/Util/YDBSyslog/ tells you what you need to know to get started. We will also document YDBSyslog in the Plugins manual (https://docs.yottadb.com/Plugins/). For example:

OCTO> select "_HOSTNAME", "_UID", "MESSAGE" from SYSLOG_DATA where "_COMM" = 'mupip' and ( "_UID" = 349 or "_UID" = 752 ) and "MESSAGE" like '%DBFILEXT%' limit 10;
_HOSTNAME|_UID|MESSAGE
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/nars/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x00000000000001F5 blocks to 0x000000000000025A at transaction 0x04000000000001E9 -- generated from 0x00007F81088A5EC7.
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/usr1/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x000000000000025A blocks to 0x00000000000002BE at transaction 0x040000000000024C -- generated from 0x00007F81088A5EC7.
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/usr1/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x00000000000002BE blocks to 0x0000000000000322 at transaction 0x04000000000002B0 -- generated from 0x00007F81088A5EC7.
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/usr1/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x0000000000000322 blocks to 0x0000000000000386 at transaction 0x0400000000000313 -- generated from 0x00007F81088A5EC7.
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/usr1/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x0000000000000386 blocks to 0x00000000000003EA at transaction 0x0400000000000377 -- generated from 0x00007F81088A5EC7.
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/usr1/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x00000000000003EA blocks to 0x000000000000044F at transaction 0x04000000000003DA -- generated from 0x00007F81088A5EC7.
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/usr1/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x000000000000044F blocks to 0x00000000000004B3 at transaction 0x040000000000043E -- generated from 0x00007F81088A5EC7.
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/usr1/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x00000000000004B3 blocks to 0x0000000000000517 at transaction 0x04000000000004A1 -- generated from 0x00007F81088A5EC7.
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/usr1/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x0000000000000517 blocks to 0x000000000000057B at transaction 0x0400000000000505 -- generated from 0x00007F81088A5EC7.
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/usr1/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x000000000000057B blocks to 0x00000000000005DF at transaction 0x0400000000000568 -- generated from 0x00007F81088A5EC7.
(10 rows)
OCTO>

Following up the recent guest blog post by Berwyn Hoyt on speeding up lua-yottadb, the Programming in Lua documentation (https://docs.yottadb.com/MultiLangProgGuide/luaprogram.html) has been significantly updated with new content. We would like to thank Berwyn for his contributions, and the University of Antwerp Library for sponsoring his work.

Regards
– Bhaskar

--
YottaDB - Rock solid. Lightning fast. Secure. Pick any three.