“The Next Gen DEX Aggregator on Tezos
Use liquidity from most popular Tezos DEXes from one interface. Change any tokens with best prices and low slippage, in one transaction.”
Category Archives: Tech Tips
Installing postgres (PostgreSQL) database on Ubuntu 22
Installation:
sudo apt update
sudo apt upgrade
sudo apt install postgresql postgresql-contrib postgresql-client-common
Start PostgreSQL service:
sudo systemctl start postgresql.service
Setup
Switch to postgres account; the installation of PostgreSQL automatically created a user account named “postgres
”. Switch to this account for accessing the PostgreSQL database:
sudo -i -u postgres
Create new role
createuser --interactive
Create database
createdb exampledatabasename
Create a new Linux user
sudo adduser exampleusername
Switch to your user
sudo -i -u exampleusername
Connect to database
psql
Check connection information
\conninfo
Distilled from How to Install and Set up PostgreSQL Database on Ubuntu 22.04 on Linux Hint. For more details:
https://linuxhint.com/install-and-setup-postgresql-database-ubuntu-22-04/
PostgreSQL/postgres cheat-sheet: postgres-cheatsheet.md
https://gist.github.com/Kartones/dd3ff5ec5ea238d4c546
Installing PHP extension imagick manually because it’s missing in cPanel/WHM EasyApache 4
We needed imagemagick installed on our server for nextCloud, but imagick is missing/unavailable in EasyApache 4.
Fortunately, we found the following instructions, which worked perfectly for us on our cPanel/WHM server for PHP versions 7.4, 8.0, and 8.1…
Original source:
https://help.bigscoots.com/en/articles/730428-cpanel-easyapache-4-installing-imagemagick-and-imagick-php-extension
Originally written by Justin Catello
This is fairly simple, just copy and paste the following into SSH.
1. Installing imagemagick:
yum -y install ImageMagick-devel ImageMagick-c++-devel ImageMagick-perl
2. Installing the imagemagick PHP extensions for all installed PHP versions.
for phpver in $(whmapi1 php_get_installed_versions|grep -oE '\bea-php.*') ; do
printf "\autodetect" | /opt/cpanel/$phpver/root/usr/bin/pecl install imagick
echo 'extension=imagick.so' >> /opt/cpanel/$phpver/root/etc/php.d/imagick.ini
done
/scripts/restartsrv_httpd
/scripts/restartsrv_apache_php_fpm
3. Test to make sure imagemagick is installed:
/usr/bin/convert --version
4. Test to make sure the PHP extensions loaded:
for phpver in $(whmapi1 php_get_installed_versions|grep -oE '\bea-php.*') ; do
echo "PHP $phpver" ; /opt/cpanel/$phpver/root/usr/bin/php -m |grep imagick
done
PHP 54
imagick
PHP 55
imagick
PHP 56
imagick
PHP 70
imagick
PHP 71
imagick