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

NethServer 7 PHP post_max_size and upload_max_filesize

Recently i have faced a problem that i was unable to upload to osTicket file to Knowledge Base larger that 12MB.

Since NethServer 7 is based on CentOS7 i have looked into php.ini file and changed required entries and restarted httpd server but nothing has changed…

Then I realised that since I a using NS7 I have to change somewhere else 😉

So this is what I have done:

And to make sure it’s working:

And now I was able to upload large files.

Thank’s to NethServer Community for this solution!