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) |
||
|
==Databases built into Cumulus MX==
You do not need to know what is in
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.
#*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 [[Weather Diary|documented here]] added by Mark Crossley
#* 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 ==
| |||