osdse

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
osdse [2025/03/20 12:24] – [PostgreSQL] davidosdse [2025/04/03 11:40] (current) – [Python] david
Line 46: Line 46:
 ufw status ufw status
 </code> </code>
 +
 +==== GitHub ====
 +As user (if interaction with git repos is required):
 +  * https://docs.github.com/en/authentication/connecting-to-github-with-ssh/generating-a-new-ssh-key-and-adding-it-to-the-ssh-agent
 +  * https://docs.github.com/en/authentication/connecting-to-github-with-ssh/adding-a-new-ssh-key-to-your-github-account
 +<code bash>
 +ssh-keygen -t ed25519 -C "david@osdse.roman-halliday.com"
 +
 +vi ~/.ssh/id_ed25519.pub
 +</code>
 +
  
 ===== Python ===== ===== Python =====
 If you need multiple versions/more control, go for [[https://github.com/pyenv/pyenv|pyenv]]. But in most cases the latest stable will be fine (right how that's 3.12). If you need multiple versions/more control, go for [[https://github.com/pyenv/pyenv|pyenv]]. But in most cases the latest stable will be fine (right how that's 3.12).
 +
 +==== Basic (one python) ====
  
 Ubuntu searching python versions Ubuntu searching python versions
Line 64: Line 77:
 </code> </code>
  
 +Optional (make the word python still point to python3):
 +<code bash>
 +sudo apt-get install python-is-python3
 +
 +# Test
 +python --version
 +</code>
 +
 +==== pyenv (multiple python versions) ====
 +
 +Prerequisite for ''pyenv'' to build some things:
 +<code bash>
 +sudo apt-get install build-essential
 +</code>
 +
 +Install ''pyenv'' (not an ubuntu package):
 +<code bash>
 +curl https://pyenv.run | bash
 +</code>
 +
 +Make the changes to ''.bashrc'' as suggested.
 +
 +Then install the python version you wish to have:
 +<code bash>
 +pyenv install 3.11
 +</code>
 +
 +View python versions:
 +<code bash>
 +pyenv versions
 +</code>
  
 ===== PostgreSQL ===== ===== PostgreSQL =====
Line 103: Line 147:
 See: [[server_configuration:mysql|]] See: [[server_configuration:mysql|]]
  
 +===== Apache =====
 +See: [[server_configuration:apache|Apache2 Configuration]]
 +
 +<code bash>
 +sudo apt-cache search apache2 | grep php
 +sudo apt-cache search php | grep mysql
 +sudo apt-cache search php | grep pgsql
 +</code>
 +
 +Apache, PHP and connectivity for MySQL & PostgreSQL:
 +<code bash>
 +sudo apt-get install apache2 libapache2-mod-php php-mysql php-pgsql
 +</code>
 +
 +Python: wsgi
 +<code bash>
 +sudo apt-cache search apache2 | grep wsgi
 +</code>
 +
 +Apache, Python:
 +<code bash>
 +sudo apt-get install apache2 libapache2-mod-wsgi-py3
 +</code>
 +
 +<code bash>
 +sudo ufw app list
 +
 +sudo ufw allow 'Apache Full'
 +
 +sudo ufw status
 +</code>
 +
 +<code bash>
 +# certbot                : Generates certificates
 +# python3-certbot-apache : Automates the apache part
 +sudo apt-get install certbot python3-certbot-apache
 +
 +sudo certbot --apache
 +</code>
 +
 +==== Website & Data Viewer ====
 +
 +<code bash>
 +cd /var/www/html
 +sudo vi index.html
 +
 +</code>
 +<file html index.html>
 +<!DOCTYPE html>
 +<html lang="en">
 +
 +<head>
 +  <meta charset="utf-8">
 +  <meta name="viewport" content="width=device-width, initial-scale=1">
 +  <title>Home: osdse.roman-halliday.com</title>
 +  <link rel="stylesheet" href="styles.css">
 +</head>
 +
 +<body>
 +  <h1>Home : osdse.roman-halliday.com</h1>
 +  <p>See the sample data:</p>
 +  <ul>
 +          <li>Explore: <a href="sample_data_explore/">explore</a> (username: <code>simple_shop_adminer_reader</code> password: <code>simple_shop_adminer_reader_password</code>)</li>
 +          <li>Docs: https://github.com/d-roman-halliday/simple_shop_data_generator</li>
 +  </ul>
 +</body>
 +
 +</html>
 +</file>
 +
 +Adminer User on DB:
 +<code bash>
 +sudo -i -u postgres psql
 +</code>
 +<code sql>
 +CREATE USER simple_shop_adminer_reader  WITH ENCRYPTED PASSWORD 'simple_shop_adminer_reader_password';
 +
 +\c simple_shop;
 +
 +-- Grant privileges for simple_shop_adminer_reader (read-only access)
 +GRANT CONNECT ON DATABASE simple_shop TO simple_shop_adminer_reader;
 +GRANT USAGE ON SCHEMA public TO simple_shop_adminer_reader;
 +GRANT pg_read_all_data TO simple_shop_adminer_reader;
 +</code>
 +
 +Adminer:
 +<code bash>
 +sudo mkdir -p sample_data_explore
 +cd sample_data_explore
 +sudo wget https://github.com/adminerevo/adminerevo/releases/download/v4.8.4/editor-4.8.4.php
 +sudo vi index.php
 +</code>
 +
 +<file php index.php>
 +<?php
 +function adminer_object() {
 +
 +  class AdminerSoftware extends Adminer {
 +
 +    function name() {
 +      // custom name in title and heading
 +      return 'Postgres Test Adminer Editor';
 +    }
 +
 +    function database() {
 +      // database name, will be escaped by Adminer
 +      return 'simple_shop';
 +    }
 +
 +    function loginForm() {
 +      echo "<table cellspacing='0' class='layout'>\n";
 +      echo $this->loginFormField('username', '<tr><th>' . lang('Username') . '<td>', '<input type="hidden" name="auth[driver]" value="pgsql"><input type="hidden" name="auth[server]" value="127.0.0.1"><input name="auth[username]" id="username" value="' . h($_GET["username"]) . '" autocomplete="username" autocapitalize="off">' . script("focus(qs('#username'));"));
 +      echo $this->loginFormField('password', '<tr><th>' . lang('Password') . '<td>', '<input type="password" name="auth[password]" autocomplete="current-password">' . "\n");
 +      echo "</table>\n";
 +      echo "<p><input type='submit' value='" . lang('Login') . "'>\n";
 +      echo checkbox("auth[permanent]", 1, $_COOKIE["adminer_permanent"], lang('Permanent login')) . "\n";
 +    }
 +
 +  }
 +
 +  return new AdminerSoftware;
 +}
 +
 +include './editor-4.8.4.php';
 +
 +</file>
 ====== Junk ====== ====== Junk ======
  
  • osdse.1742473476.txt.gz
  • Last modified: 2025/03/27 15:42
  • (external edit)