Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
home_server:web_server_setup [2022-11-13 Sun wk45 10:36] – [mariadb binary log files] baumkphome_server:web_server_setup [2024-12-07 Sat wk49 11:13] (current) – [Basic Web Server setup on VM] baumkp
Line 2: Line 2:
 ======Web Server setup====== ======Web Server setup======
 =====Basic Web Server setup on VM===== =====Basic Web Server setup on VM=====
-I am moving away from Ubuntu to Debian. I find the instruction for here are good to setup a basic web server [[https://workaround.org/ispmail|workaround.org]] ISPmail tutorials for a Debian based server.\\+I am moving away from Ubuntu to Debian. I find the instruction for here are good to setup a basic web server Digitalocean's [[https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mariadb-php-lamp-stack-on-debian-11|LAMP on Debian 11]] and Computing for Geeks [[https://computingforgeeks.com/install-lamp-stack-on-debian-linux-system/|LAMP on Debian]].\\
  
 ++++Old, tl;dr;|The main reference used is [[https://www.unixmen.com/how-to-install-lamp-stack-on-ubuntu-16-04/|Unixmen - How To Install LAMP Stack On Ubuntu 16.04]], for the basic web server setup on a virtual machine (VM), However this setup is quite basic and any similar page would probably suffice. Subsequently I found this reference that looks to be more complete for installing Apache2 on Ubuntu 18.04, [[https://www.linode.com/docs/web-servers/lamp/install-lamp-stack-on-ubuntu-18-04/|Linode - Install LAMP Stack on Ubuntu 18.04]].++++ ++++Old, tl;dr;|The main reference used is [[https://www.unixmen.com/how-to-install-lamp-stack-on-ubuntu-16-04/|Unixmen - How To Install LAMP Stack On Ubuntu 16.04]], for the basic web server setup on a virtual machine (VM), However this setup is quite basic and any similar page would probably suffice. Subsequently I found this reference that looks to be more complete for installing Apache2 on Ubuntu 18.04, [[https://www.linode.com/docs/web-servers/lamp/install-lamp-stack-on-ubuntu-18-04/|Linode - Install LAMP Stack on Ubuntu 18.04]].++++
Line 234: Line 234:
  *Nextcloud Stable Server Administration Manual [[https://docs.nextcloud.com/server/stable/admin_manual/maintenance/index.html|Maintenance]]. (This also discusses database management, backup and restore)  *Nextcloud Stable Server Administration Manual [[https://docs.nextcloud.com/server/stable/admin_manual/maintenance/index.html|Maintenance]]. (This also discusses database management, backup and restore)
 ====mariadb binary log files==== ====mariadb binary log files====
 +The mysql binary log files are located here: ''var/log/mysql''.  Some time they fill up the file system and the system then fails to operate.
   * ''sudo mysql -p -u root'' - Login in to mysql, need root password   * ''sudo mysql -p -u root'' - Login in to mysql, need root password
   * ''SHOW BINARY LOGS;'' - to list current binary log files   * ''SHOW BINARY LOGS;'' - to list current binary log files
Line 239: Line 240:
   * ''%%show variables like "sql_log_bin";%%'' - to see current setting of variable ''%%"sql_log_bin"%%''   * ''%%show variables like "sql_log_bin";%%'' - to see current setting of variable ''%%"sql_log_bin"%%''
   * ''%%SET sql_log_bin = 0;%%'' - to set a variable   * ''%%SET sql_log_bin = 0;%%'' - to set a variable
 +  * ''exit'' or ^d - to exit
 +
 ---- ----
 ====Nextcloud OCC Comand==== ====Nextcloud OCC Comand====