5,838
edits
MX on Linux: Difference between revisions
m
→Databases built into Cumulus MX: added a comparison between admin interface and phpliteadmin
m (→Which Raspberry Pi to buy: add references to support forum posts and image article) |
m (→Databases built into Cumulus MX: added a comparison between admin interface and phpliteadmin) |
||
| Line 487: | Line 487: | ||
==Databases built into Cumulus MX== | ==Databases built into Cumulus MX== | ||
You do not need to know what is in | You do not need to know what is in these databases to use MX. | ||
Cumulus MX includes two SQLite databases; | Cumulus MX includes two SQLite databases; | ||
#The first database was added by Steve Loft, but he never documented what it is used for (see [[Cumulusmx.db]]) and in the support forum when someone asked, nobody was able to answer. | #The first database was added by Steve Loft, but he never documented what it is used for (see [[Cumulusmx.db]]) and in the support forum when someone asked, nobody was able to answer. | ||
#*If you do find out what the first database is used for, please update the Wiki article on it! | #*If you do find out what the first database is used for, please update the Wiki article on it! | ||
#The second database is the [[Weather Diary]] added by Mark Crossley | #The second database is the Weather Diary [[Weather Diary|documented here]] added by Mark Crossley. Also see [https://cumulus.hosiene.co.uk/viewtopic.php?f=37&t=17919 in the support forum] for a topic comparing the differences between Cumulus 1 and Cumulus MX weather diaries. | ||
#* The [[MX Administrative Interface|Admin Interface]] provides a page to view or edit the weather diary. | #* The [[MX Administrative Interface|Admin Interface]] provides a page to view, or edit, a single date in the weather diary. You can install another tool that edits SQLite databases if you want (see next section). | ||
===Editing the Weather Diary=== | |||
You can install phpLiteAdmin (the significant part of that name is in the middle) to read (you can display the whole table very easily) and edit (via a friendly GUI) either, or both, of those SQLite databases. | |||
Install it using <tt>sudo apt install phpliteadmin</tt>. You will need to follow the instructions in '''/usr/share/phpliteadmin/phpliteadmin.php''' to define the path to the database you want to read, as both databases have the wrong extension to be found automatically. | |||
I find the admin interface is not reliable for updating the weather diary; it often fails to store an update, without giving any error either on the editing screen or in the MXDiags file. So, I prefer to use phpliteadmin for making changes to the Weather Diary database now. I can use it from a browser on any of my devices. | |||
== Adding a web server and a database server == | == Adding a web server and a database server == | ||