Pengguna router mikrotik seperti seri RB750 biasanya akan mengalami kebingungan jika ingin menyimpan log web apa yang dibuka oleh client karena keterbatasan disk yang ada sehingga akhirnya log hanya bisa dilihat secara real time.<\/p>\n
Jika pengguna mikrotik ingin menyimpan semua log, maka pengguna mikrotik membutuhkan 1 CPU yang diinstall linux, setelah linux terinstall, lalu install rsyslog di linux agar log dari client<\/em> mikrotik dapat disimpan, disini saya rekomendasikan linux ubuntu.<\/p>\n Cara setting di mikrotik dan linux ubuntu bisa di lihat di https:\/\/github.com\/kurniawandata\/cilog<\/a>.<\/p>\n Untuk source code php untuk melihat log di database Syslog yang saya buat, berikut source code-nya yang bisa disimpan di document root<\/em> di web server.<\/p>\n Oleh Kurniawan<\/p>\n Founder X-code<\/p>\n","protected":false},"excerpt":{"rendered":" Pengguna router mikrotik seperti seri RB750 biasanya akan mengalami kebingungan jika ingin menyimpan log web apa yang dibuka oleh client karena keterbatasan disk yang ada sehingga akhirnya log hanya bisa dilihat secara real time. Jika pengguna mikrotik ingin menyimpan semua Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[15],"tags":[],"_links":{"self":[{"href":"https:\/\/xcode.or.id\/blog\/index.php\/wp-json\/wp\/v2\/posts\/283"}],"collection":[{"href":"https:\/\/xcode.or.id\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xcode.or.id\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xcode.or.id\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xcode.or.id\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=283"}],"version-history":[{"count":17,"href":"https:\/\/xcode.or.id\/blog\/index.php\/wp-json\/wp\/v2\/posts\/283\/revisions"}],"predecessor-version":[{"id":378,"href":"https:\/\/xcode.or.id\/blog\/index.php\/wp-json\/wp\/v2\/posts\/283\/revisions\/378"}],"wp:attachment":[{"href":"https:\/\/xcode.or.id\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xcode.or.id\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xcode.or.id\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<?php\r\n\/\/ oleh Kurniawan\r\n\/\/ trainingxcode@gmail.com\r\n\/\/ xcode.or.id\r\n$dbhost = 'localhost'; \r\n$dbuser = 'root'; \r\n$dbpass = ''; \r\n$dbname = 'Syslog'; \r\n\r\n$conn = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);\r\nif (!$conn) {\r\n die ('Tidak bisa terkoneksi ke MySQL: ' . mysqli_connect_error()); \r\n }\r\n $sql = 'SELECT DeviceReportedTime, Message, SysLogTag FROM SystemEvents ORDER BY DeviceReportedTime DESC';\r\n $query = mysqli_query($conn, $sql);\r\n if (!$query) {\r\n die ('SQL Error: ' . mysqli_error($conn));\r\n }\r\n echo '<table border=\"1\">\r\n \t <thead>\r\n\t <tr>\r\n\t\t<th>Tanggal & jam<\/th>\r\n\t\t<th>IP Address<\/th>\r\n\t\t<th align=\"left\">Web yang dibuka oleh client mikrotik<\/th>\r\n\t <\/tr>\r\n <\/thead>\r\n <tbody>';\r\n\t\t\r\n while ($row = mysqli_fetch_array($query))\r\n {\r\n\t echo '<tr>\r\n\t <td>'.$row['DeviceReportedTime'].'<\/td>\r\n\t\t<td>'.$row['SysLogTag'].'<\/td>\r\n\t\t<td class=\"right\">'.$row['Message'].'<\/td>\r\n\t\t<\/tr>';\r\n }\r\n echo '\r\n\t<\/tbody>\r\n <\/table>';\r\n\r\nmysqli_free_result($query);\r\nmysqli_close($conn);\r\n?>\r\n<\/pre>\n