21 Jun 2019 @ 8:49 AM 

Partially taken from here, but some info is outdated, some missing, because I was unable to finish setup with those manual.

So, what we have?
Freshly installed Centos 7 and root access.
Steps need to be done:

  1. yum -y update
  2. yum localinstall -y https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
  3. yum --disablerepo=mysql80-community --enablerepo=mysql57-community install mysql-community-server mysql-devel
  4. systemctl start mysqld.service
  5. systemctl enable mysqld.service

More »

Posted By: lvlind
Last Edit: 21 Jun 2019 @ 09:31 AM

EmailPermalinkComments (0)
Tags
Tags: , , , ,
Categories: Uncategorized
 20 Apr 2017 @ 9:18 AM 

The most common problem with postgresql – it uses ASCII charset by default, and if you want to create database in UTF8, you can see the error “(UTF8) is incompatible with the encoding of the template database”.

Use these few easy steps to solve it:

  1. su - postgres
  2. psql
  3. UPDATE pg_database SET datistemplate = FALSE WHERE datname = 'template1';
  4. DROP DATABASE template1;
  5. CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING = 'UTF8';
  6. UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template1';
  7. \c template1
  8. VACUUM FREEZE;

Now you can use template1 for creation of your database.

Posted By: lvlind
Last Edit: 20 Apr 2017 @ 09:18 AM

EmailPermalinkComments (0)
Tags
 06 Oct 2016 @ 3:44 PM 

If you need http/2 enabled at your CPanel server, you need to do few things:

1. Install nghttp2


cd /usr/src/
wget https://github.com/nghttp2/nghttp2/releases/download/v1.15.0/nghttp2-1.15.0.tar.gz
tar -xvzf nghttp2-1.15.0.tar.gz
cd nghttp2-1.15.0
./configure --prefix=/opt/nghttp2
make
make install
echo "/opt/nghttp2/lib" >> /etc/ld.so.conf.d/custom-libs.conf
ldconfig

More »

Posted By: lvlind
Last Edit: 06 Oct 2016 @ 04:09 PM

EmailPermalinkComments (0)
Tags

 Last 50 Posts
Change Theme...
  • Users » 1
  • Posts/Pages » 35
  • Comments » 0
Change Theme...
  • VoidVoid « Default
  • LifeLife
  • EarthEarth
  • WindWind
  • WaterWater
  • FireFire
  • LightLight

About



    No Child Pages.

Need Help?



    No Child Pages.

Check your IP



    No Child Pages.