5,838
edits
MX on Linux: Difference between revisions
m
→Installing Adminer, PhpLiteAdmin, or PhpMyAdmin
m (→Adding a web server: cut and paste) |
|||
| Line 404: | Line 404: | ||
Cumulus MX includes two SQLite databases, one is the [[Weather Diary]], the other's use is not documented (see [[Cumulusmx.db]]). You might want to install phpLiteAdmin (the significant part of that name is in the middle) to read those SQLite databases using <tt>sudo apt install phpliteadmin</tt>. | Cumulus MX includes two SQLite databases, one is the [[Weather Diary]], the other's use is not documented (see [[Cumulusmx.db]]). You might want to install phpLiteAdmin (the significant part of that name is in the middle) to read those SQLite databases using <tt>sudo apt install phpliteadmin</tt>. | ||
ExportMySQL.exe and CumulusMX.exe (see [[Cumulus_MX#Executables]] for details) both create SQL for updating tables in a MySQL database, such as the one our MariaDB software package we have installed can create; so maybe we want to install a package that lets us back up and manipulate tables in this database. PHPMyAdmin is not the only tool that can be used to manipulate your MySQL like database (that is the significance of the "My" bit in the middle of the tools's name), and you may prefer to load a different tool, perhaps '''adminer''' that works using a drill down approach. However, let me assume that you are happy to use '''PHPMyAdmin''' and I will describe how to install that. Start the install with <tt>sudo apt install phpmyadmin -y</tt>. (Alternatively install a drill down package with <tt>sudo apt install adminer</tt> and I leave you to work out the commands needed after that). | ExportMySQL.exe and CumulusMX.exe (see [[Cumulus_MX#Executables]] for details) both create SQL for updating tables in a MySQL database, such as the one our MariaDB software package we have installed can create; so maybe we want to install a package that lets us back up and manipulate tables in this database. | ||
PHPMyAdmin is not the only tool that can be used to manipulate your MySQL like database (that is the significance of the "My" bit in the middle of the tools's name), and you may prefer to load a different tool, perhaps '''adminer''' that works using a drill down approach. | |||
However, let me assume that you are happy to use '''PHPMyAdmin''' and I will describe how to install that. Start the install with <tt>sudo apt install phpmyadmin -y</tt>. (Alternatively install a drill down package with <tt>sudo apt install adminer</tt> and I leave you to work out the commands needed after that). | |||
The PhpMyAdmin installer will ask some questions. Use your tab key to select <Yes> when it asks whether you want to configure with '''dbconfig-common'''. | The PhpMyAdmin installer will ask some questions. Use your tab key to select <Yes> when it asks whether you want to configure with '''dbconfig-common'''. | ||
| Line 416: | Line 420: | ||
You can view any index.php or PHPMyAdmin web page in your browser by prefixing the address with your Pi URL e.g. '''http://192.168.1.xy/phpmyadmin''' where x and y are digits you look up as mentioned before where FTP of MX distribution was described. In this case you will see a PHP MyAdmin log on page where you type username and password (as you may not have added any other user yet, the user will be root). | You can view any index.php or PHPMyAdmin web page in your browser by prefixing the address with your Pi URL e.g. '''http://192.168.1.xy/phpmyadmin''' where x and y are digits you look up as mentioned before where FTP of MX distribution was described. In this case you will see a PHP MyAdmin log on page where you type username and password (as you may not have added any other user yet, the user will be root). | ||
== Restarting Apache == | == Restarting Apache == | ||