Differences

This shows you the differences between two versions of the page.

--- cbsnet [2025/12/09 12:11] – [Brewer Log Form] reno
+++ cbsnet [2025/12/17 14:13] (current) – reno
@@ Line 68: / Line 68: @@
 </konsole>
 </hidden>
 ===== Brewer Log Form =====
@@ Line 105: / Line 106: @@
 </hidden>
+==== Error in log forms ====
+Archived and error logs can be found in <key>/var/cache/brewer-log/logs</key>.\\
+Error logs are identified by the prefix of the file name <key>ERROR_*</key>.\\
+Some common log issues
+  - Too many <key>,</key>. This is usually found when right before the comment line or comments including commas
+  - The use of a <key>;</key>. semicolon are not supported
+  - Comments too long. The max length for the comment is 500 characters.
+===== Metabase =====
+Metabase is an open source program that is able to read from a database and plot/display it in a friendly interface. The CBSN version can be found [[http://metabase.cbsn.hiitravel.ca|here]].
+<hidden To check the status of metabase>
+<konsole>
+cbsnet@Thinkbrew:~$ su root
+Password:
+root@Thinkbrew:/home/cbsnet# systemctl status metabase
+● metabase.service - Metabase server
+     Loaded: loaded (/etc/systemd/system/metabase.service; disabled; vendor pre>
+     Active: active (running) since Sun 2025-12-07 20:22:44 GMT; 3 days ago
+   Main PID: 32791 (java)
+      Tasks: 160 (limit: 37964)
+     Memory: 2.8G
+        CPU: 45min 41.735s
+     CGroup: /system.slice/metabase.service
+             └─32791 /usr/bin/java -jar /home/cbsnet/metabase/metabase.jar
+</konsole>
+This indicates metabase is running properly. </hidden>
+<hidden How to restart metabase>
+<konsole>
+cbsnet@Thinkbrew:~$ su root
+Password:
+root@Thinkbrew:/home/cbsnet# systemctl restart metabase
+</konsole>
+</hidden>
+\\
+===== Backups =====
+  - Drive Backups are managed by [[https://github.com/linuxmint/timeshift|timeshift]].
+    - Monthly Backup
+      - Backup are made on the 1st of each month at 00:00:00 UTC
+      - up to 3 copies are saved at one time
+    - Weekly Backup
+      - Backup are made on each Sunday at 21:00:00 UTC
+      - up to 2 copies are saved at one time
+  - Database backups are managed by the db_backup.sh
+    - Database base backup are done every Tuesday and at 04:00:00 UTC
+    - Up to 9 copies are saved at one time
+    - Database that are being backed up are
+      - brewerdata
+      - brewer_db
+      - brewer_security
+      - brewerpart
+      - metabase
+\\
+===== Database =====
+There are currently 5 database (as of Dec 17, 2025) running on cbsnet via mariadb (Version 10.5.29-MariaDB-0+deb11u1 Debian 11)
+  - brewerdata - this database is primary used to host the IDEAS database and includes all the brewer data. The best way to view this data is via [[https://metabase.cbsn.hiitravel.ca|metabase]].
+  - brewer_db - this database is used to for hosting the brewer log form data.
+  - brewer_security - this database is used to host the user information needed for the brewer log form
+  - brewerpart - This database is used to host the brewer parts database. This is what brewparts.exe uses
+  - metabase - This database is used to host the config and different views used for [[https://metabase.cbsn.hiitravel.ca|metabase]].