Category Archives: how-to

Problem connecting to KVM with Virt-Manager

Recently I have had some issues with connecting from my laptop running Linux OS (Fedora 30, Xubuntu 19.04) from virt-manager to server running KVM. Virt-Manager keeps asking me for root password, which was very annoying.

The solution was simple – first I had to create ssh keys which then I needed to send to my CentOS(7) server running KVM

After that I was able to use Virt-Manager without any asking for password.

How-to install cockpit on CentOS 7

Here is a quick install guide how I setup Cockpit on my CentOS 7 servers:

  1. First update CentOS 7 server
  2. Install cockpit
  3. Change firewall settings
  4. Access CentOS 7 server via Cockpit webpage

And that’s all 😉

How to install MS SQL Server 2017 on CentOS 7

There are many instructions and how-to’s regarding installing MS SQL Server 2017 on CentOS 7 but here are my notes about it:

  1. You should plan how to setup your CentOS 7 system because by default MS SQL Server hold his files in those directories:
    1. SQL Server 2017 file location after install
    2. database and others
    3. Of course this directories can be changed after install, but does anyone change directories for MySQL/PostgreSQL ?
  2. Read carefully documentation provided by Microsoft ®, especially this:
    https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-red-hat?view=sql-server-2017
    https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-performance-best-practices?view=sql-server-2017
    https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-mssql-conf?view=sql-server-2017
  3. Check if your software will work with MS SQL Server running on Linux. Some software will work but you will probably have no support if you run it that way.

Here is how I have setup my CentOS 7 to work with MS SQL Server only

  1. I have created Virtual Machine which has:
    2 x CPU’s
    8 GB of RAM
    100 GB of space
    1 x NIC
  2. Disk partitioning:
    /boot – 1024 MB
    / – 30 GB
    /var – 60 GB
    /tmp – 5 GB
    /var/log – 5 GB
    /swap – 8192 MB
  3. CentOS 7 setup
    1. Update system
    2. Enable EPEL repo (not necessery, but I like to have it)
    3. Download MS SQL Server 2017 repo
    4. Install
    5. Setup
  4. Enabling TCP port on firewall
  5. Connecting from SQL Management Studio
    1. Logon screen
    2. After logon screen

I think this is all … for now 😉 I will try to write something more after I will test it in production.

Prestashop 1.6.x.x contact form problem with sending messages.

Hi,

Yesterday my client told that his Prestashop 1.6.x.x don’t send messages from the contact form. Here is what i have done to solve this:

  1. Edit your Prestashop contact-form.tpl which is located in
  2. Search for <div class=”submit”>

    and add this:
  3. To make it work do:clear cache and recompile your theme → Save and after that undo those options – this worked for me

Apache UserDir in CentOS 7

Quick steps to set it up (I assume you have apache installed):

  1. login as root
  2. edit userdir.conf

  3. restart Apache
  4. setup your directory
    as normal user enter:
  5. if you use SELinux as root enter:
  6. create simple html page

    enter this:
  7. change ownership of file
  8. start your browser and enter this address:

     

    and voila! 😉

Cloning VirtualBox vmdk to vdi

First of all you have to shutdown VirtualBox machine that you wan’t to clone.
After that create new folder where you wan’t to clone existing vmdk machine to vdi

After that run this command in terminal:

Wait until the job is done and… that’s all.

Mounting Windows share in CentOS 7

Today i have to connect to Windows share from CentOS 7. This is how I done it:

then I have created directory in /mnt

after that:

That’s all 🙂

ClearOS 6.x , OpenVPN and Windows 10

Recently I have been in the UK, in a company where many users are connecting to my company server data via VPN and they have told me, that they have problems with OpenVPN client running on Windows 10.

First problem was with OpenVPN client version because, the newest client requires Administrator rights to start. The working version in my case was 32bit and 64bit versions.

The second problem was that after one hour the connection was closing down. Solution for that was easy. I had to only add those two lines

to openvpn config file – and that’s it. After one hour the connection was still up and runnig !

Cheers!