{"id":228,"date":"2007-09-30T22:33:00","date_gmt":"2007-09-30T22:33:00","guid":{"rendered":"https:\/\/defragged.org\/ossec\/?p=228"},"modified":"2020-07-02T22:33:36","modified_gmt":"2020-07-02T22:33:36","slug":"database-logging","status":"publish","type":"post","link":"https:\/\/defragged.org\/ossec\/2007\/09\/database-logging\/","title":{"rendered":"Database Logging"},"content":{"rendered":"\n<p>Next version of OSSEC will come with support for&nbsp;<a href=\"http:\/\/www.postgresql.org\/\">PostgreSQL<\/a>&nbsp;logs and&nbsp;<a href=\"http:\/\/www.mysql.org\/\">MySQL<\/a>&nbsp;error\/query logs. Since database logging is not something widely done (and even hard to find documentation about), I started in the&nbsp;<a href=\"http:\/\/www.ossec.net\/wiki\/\">OSSEC wiki<\/a>&nbsp;some sections about it. If you are interested in database log analysis, please check out the following pages and help us improve them:<\/p>\n\n\n\n<ul><li><a href=\"http:\/\/www.ossec.net\/wiki\/index.php\/PostgreSQL_Samples\">PostgreSQL log samples<\/a><\/li><li><a href=\"http:\/\/www.ossec.net\/wiki\/index.php\/SQL_Logging#PostgreSQL_Logging\">Configuring PostgreSQL logging<\/a><\/li><li><a href=\"http:\/\/www.ossec.net\/wiki\/index.php\/MySQL_Samples\">MySQL log samples<\/a><\/li><li><a href=\"http:\/\/www.ossec.net\/wiki\/index.php\/SQL_Logging#MySQL_Logging\">Configuring MySQL logging<\/a><\/li><\/ul>\n\n\n\n<p>If you have information about logging on other databases (Oracle, MS SQL, etc), send some information to us so we can add support for them on ossec.<\/p>\n\n\n\n<p><em>*This alpha version of 1.4 has the database support enabled for anyone interested to test:&nbsp;<a href=\"http:\/\/www.ossec.net\/files\/snapshots\/ossec-hids-070930.tar.gz\">http:\/\/www.ossec.net\/files\/snapshots\/ossec-hids-070930.tar.gz<\/a><\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Next version of OSSEC will come with support for&nbsp;PostgreSQL&nbsp;logs and&nbsp;MySQL&nbsp;error\/query logs. Since database logging is not something widely done (and even hard to find documentation about), I started in the&nbsp;OSSEC wiki&nbsp;some sections about it. If you are interested in database log analysis, please check out the following pages and help us improve them: PostgreSQL log [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[9],"_links":{"self":[{"href":"https:\/\/defragged.org\/ossec\/wp-json\/wp\/v2\/posts\/228"}],"collection":[{"href":"https:\/\/defragged.org\/ossec\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/defragged.org\/ossec\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/defragged.org\/ossec\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/defragged.org\/ossec\/wp-json\/wp\/v2\/comments?post=228"}],"version-history":[{"count":1,"href":"https:\/\/defragged.org\/ossec\/wp-json\/wp\/v2\/posts\/228\/revisions"}],"predecessor-version":[{"id":229,"href":"https:\/\/defragged.org\/ossec\/wp-json\/wp\/v2\/posts\/228\/revisions\/229"}],"wp:attachment":[{"href":"https:\/\/defragged.org\/ossec\/wp-json\/wp\/v2\/media?parent=228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/defragged.org\/ossec\/wp-json\/wp\/v2\/categories?post=228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/defragged.org\/ossec\/wp-json\/wp\/v2\/tags?post=228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}