Category Archives: my thoughts

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.

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.

Info

Hi all,

Nothing has been posted recently on my site, but there is a reason – currently I am trying to write three big post’s about very interesting stuff.

So stay tuned

PHP coding at night :)

Yesterday I was programming late at night (4 am) and all the time I had a problem with authentication when switching between web sites.
This morning I looked at the code and found out that I made a simple mistake – a typo in the code.
My advice – do not sit, and code late at night. 😉

ClearOS 6.x MultiWan

Today i have had a problem with 3 external internet connection. What i did at the very beginning of configuring it was that I haven’t choose which interface is the PRIMARY and which is BACKUP.

At the very beginning i have only one external wan so there where no problems but, after some time i have had second and about 3 month ago third external wan.

When one interface was down whole traffic did not know which other interface he had to choose 😉

Today i have set it up properly and voila everything works as planned.

CentOS 7 on HP Compaq 6710b and 16GB micro sd card

Yesterday i have installed CentOS 7 on my old HP Compaq 6710b laptop. I don’t wanted to remove my current OS (ubuntu) because I did’nt know if I find all software which i am using, so i decided to install it on 16GB micro sd card (!).

After install i have done this:

  1. add EPEL repo
  2. add RPMForge repo
  3. add NUX-Dextop repo (for remmina)
  4. add Google repo (for Google Chrome)
  5. add Adobe repo (for flashplayer)

After two days of working on it (Geany, GIMP, OpenVPN, Remmina) I must say that everything is working fine.