superjojo140

Working with local PostgreSQL and pgAdmin on ArchLinux

Daily Usage

Start postgreSQL

$ sudo systemctl start postgresql

superjojo140

Guide to install a LAMP system on on your archlinux system and serve php-based database applications.
LAMP stands for a Linux system with Apache (webserver), MariaDB (database) and PHP (programming language). In this guide we will also install PhpMyAdmin (database admin GUI) to easily manage the SQL tables.

Apache

The Apache HTTP Server is an open-source and free product of the Apache Software Foundation and one of the most widely used web servers on the Internet. In addition to factors such as performance, expandability, security, freedom from license costs and support from a very large community, its long-term availability for a wide variety of operating systems is one of the reasons for its widespread use; it is most frequently used as a LAMP system.

Install packages

superjojo140

Thsi is a guide to reset your local windows password.

⚠️ If you dont exactly understand what you do here, this could break your operating system. Please be carefull!

1. Boot from live system

Boot from another live operating system, for example from a USB stick with Linux or something similar (e.g. http://www.knoppix.org/). You need a console where you can access the hard disk of the computer.

You can also use the Windows installation CD. You can open the command line in the installation screen with SHIFT + F10

superjojo140

Prequisites

See manual at: https://github.com/git-ftp/git-ftp/blob/master/man/git-ftp.1.md

Install git-ftp package: https://github.com/git-ftp/git-ftp/blob/master/INSTALL.md

Direct setup for linux:

curl https://raw.githubusercontent.com/git-ftp/git-ftp/master/git-ftp > /bin/git-ftp
chmod 755 /bin/git-ftp

superjojo140

Reset all user settings for VSCode (Code OSS) on Linux

(Archlinux in my case)
Reset all settings and extensions. Like a fresh and clean VSCode installation.

• Close VSCode
• Remove the ~/.vscode-oss folder and the ~/.config/Code - OSS/ folder

~ is a shorthand for your user folder /home/username but should work on all unix systems

Via Console:

WARNING: This will remove all your settings and installed extensions without any prompt

superjojo140

#!/bin/bash
rm -rf ~/.cache
rm -rf ~/.config/kwinrc ~/.config/kwinrulesrc
rm -rf ~/.local/share/kscreen
reboot

superjojo140

ICAL / ICS Syntax

References

Defined in RFC5545
Nice to read on https://www.kanzaki.com/docs/ical/

Basics

Allways start file with BEGIN:VCALENDAR and end with END:VCALENDAR
Events allways start with BEGIN:VEVENT and end with END:VEVENT and are nested in VCALENDAR
Timezones are mandatory for recurring events and recommended for all events.

superjojo140

1. Create a folder to store the script and the mail logs.

mkdir /somewhere/phpmail
mkdir /somewhere/phpmail/mails

2. Place the logmail.sh script in the phpmail folder
3. Make sure the php process has write access to this folder:

chmod -R 777 /somewhere/phpmail

superjojo140

#!/bin/bash
SERVICE="gammy"
if pgrep -x "$SERVICE" >/dev/null
then
    pkill gammy&
else
    gammy&
fi

superjojo140

Diese Anleitung beschreibt die wichtigsten Schritte einer Arch Linux Installation.

Sie ist stark angelehnt an die Anleitung für Einsteiger, verzichtet jedoch auf viele Erklärungen und Variationen.

Installiert wird hier auf UEFI, als Desktop wird KDE Plasma installiert.

Vorbereitungen

Iso herunterladen http://www.archlinux.org/download/