Differences

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

--- cbsnet [2025/12/11 12:12] – added metabase reno
+++ cbsnet [2025/12/17 14:13] (current) – reno
@@ Line 105: / Line 105: @@
 Where '1' is the id number
 </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 =====
@@ Line 131: / Line 139: @@
 </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]].