Aikataulu – Linuxin keskitetty hallinta – ict4tn011-9 – loppukevät 2016

Hallitse palvelimiasi ja työasemiasi Pupetilla. Kuvaile tavoitetila, ja anna Pupetin tehdä tarvittavat säädöt ja asetukset. Pupettia käyttävät mm. Google, Mozilla ja Wikipedia. USA:n valtio suojaa Windows- ja Linux-työasemansa Pupetilla (US Government Security Baseline).

Posted in Uncategorized | Tagged , , , , , , , , , , , | 20 Comments

Aikataulu – Linux projekti ict4tn018-6 – Loppukevät 2016

Tavoite: julkaise oma vapaisiin ohjelmistoihin perustuva projekti. Experimentally, you can join in English, too. Read on.

Posted in Uncategorized | Tagged , , , , , | 66 Comments

Aikataulu – Linux palvelimena ict4tn003-19 – loppukevät 2016

Linuxin perusteet hallussa ja haasteita etsimässä? Linux palvelimena -kurssilla opit Ratkomaan ongelmia viileän rauhallisesti Sorminäppäryyttä Linuxissa Monia kiehtovia työkaluja (ks. aikataulu)

Posted in Uncategorized | Tagged , , , , , , , , , , , | 26 Comments

Flask Templates

Making nice web pages is fastest with templates. Flask web development framework uses Jinja2 templates, my favorite template engine. Base template contains the common parts: HTML boilerplate, navigation, headers and footers. The actual pages extend the base template. This way, … Continue reading

Posted in Uncategorized | Tagged , , | Comments Off on Flask Templates

PostgreSQL Install and One Table Database – SQL CRUD tutorial for Ubuntu

PostgreSQL is a popular database used often with Python Django, Python Flask and many other frameworks. It’s known for reliability and being very ACID. In this tutorial, you’ll learn to Install PostgreSQL Server and Client on Ubuntu Create, read, update … Continue reading

Posted in Uncategorized | Tagged , , , , , , , | Comments Off on PostgreSQL Install and One Table Database – SQL CRUD tutorial for Ubuntu

Fix Vagrant Locale Bug – Disable "AcceptEnv LANG LC_*" in sshd_config

Vagrant makes it very easy to provision virtual machines for testing. Incorrect locales are a common problem with some boxes. For example, PostgreSQL ‘createuser’ migth complain about locales, but only when used over ‘vagrant ssh’.

Posted in Uncategorized | Tagged , , , , , , , , | Comments Off on Fix Vagrant Locale Bug – Disable "AcceptEnv LANG LC_*" in sshd_config

Install PostgreSQL on Ubuntu – New user and database in 3 commands

Installing PostgreSQL is trivially easy. You just have to use the same name for linux user, database user and the database name.

Posted in Uncategorized | Tagged , , , , , , , , | Comments Off on Install PostgreSQL on Ubuntu – New user and database in 3 commands

Two Common MySQL Tricks: LAST_INSERT_ID() and Trash

Create a new database item, then open it for editing: LAST_INSERT_ID(). Undo is better than “are you sure”. Mark items deleted, then empty trash when sure. Read the basics first: MySQL Install and One Table Database – SQL CRUD tutorial … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | Comments Off on Two Common MySQL Tricks: LAST_INSERT_ID() and Trash

MySQL Install and One Table Database – SQL CRUD tutorial for Ubuntu

MySQL is the most popular multi-user database. In this tutorial, you’ll learn to Install MySQL Server and Client on Ubuntu Automate MySQL login Create, read, update and delete data (CRUD)

Posted in Uncategorized | Tagged , , , , , , , , , | Comments Off on MySQL Install and One Table Database – SQL CRUD tutorial for Ubuntu