Nn web site building blocks

The following tools and web and programming frameworks are all part of Ted's volunteer efforts with ASI web site, and in-progress study of how to configure and customize shopping carts, article and document management pages, and easy-to-read easy-to-adjust web page layouts using CSS and third party, open source frameworks:

• Linux package selection for constrained systems
  

^ MYSQL database server and client

• MYSQL data base install and config (set up)
  
  • MYSQL query syntax and examples
  • MYSQL show variables, show status
  • MYSQL command-line tool, also called MYSQL shell
  • MYSQL shell user guide
  • string quoting in MYSQL, multiple ways of quoting
  • mysqldump of database information_schema requires --skip-lock-tables option
  • MYSQL database back-ups and cron
  • https://dev.mysql.com/doc/refman/5.7/en/create-user.html
  • https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
  - 2017-11-30 -
  • recover, reset mysql root password
  • MYSQL 5.7.3 - MYSQL 5.7.9 bug present during --skip-grant-tables server invocation, work arounds

An important MYSQL database access recovery step is to reset the database server's root password in cases where that is lost. The following statement run in a mysqld_safe --skip-grant-tables session works, while some of the more standard and MYSQL 5.7 documented password change statements fail due to a bug in MYSQL . . .

  mysql> update mysql.user set authentication_string=password('MyNewPass') where user='root';

• PHP set up
  

^ Apache2 web server configuration

• https://wiki.apache.org/httpd/RedirectSSL redirect http to https URLs
  

SSL Self-signed certificate creation and config

• GoDaddy let's encrypt ssl apache article 20245, not helpful
  
• LetsEncrypt certbot and GoDaddy servers, cat /proc/version . . .
  
• acme.sh on Github, CA certificate client
  
• acme.sh how to install
  
• acme.sh how to issue a certificate
  

Sub-domain creation under Ubuntu 16.04 LTS and similar Linux releases

Mediawiki work . . .

• Install and config
  
• Back-up and restore steps
  
• Troubleshooting
  

OpenCart 2.x install and config, 'Wish List' and 'To Do List' . . .

• OpenCart installation and config
  
• OpenCart To-Do and Wish List
  

^ Cascading Style Sheets (CSS)

• Learnlayout dot com, flexbox example
  
• CSS flexbox, old versus new syntax at css-tricks.com
  
• Codepen dot io, Chris Coyier example of fixed and fluid block elements
  
• https://www.w3schools.com/tags/canvas_lineto.asp
  
• https://developer.mozilla.org/en-US/docs/Web/API/WebGL_API/Tutorial/Getting_started_with_WebGL
  

^ 2017-11-27 - Web Page Fonts

• custom web page fonts, Mozilla developers' article
  

^ 2017-11-28 - Javascript tutorials, examples and frameworks

Javascript frameworks . . .
• Mithril Javascript framework, simple application
  
• Mochikit framework . . . found 2017-12-07 in translate.google.com page source
  

Javascript tutorials and examples . . .

• CSS-tricks dot com, make entire div clickable
  

These are the first topics on which Ted wants to gather together notes. Hard to remember all details regarding pitfalls encountered, solutions found, and ideas for improving the configuration and use experience of these softwares . . . - TMH