I had a problem to make insert to database like that: I got an error: #1366 – Incorrect string value: ‚\xC4\x99d\xC4\x99 …’ for column ‚Name’ at row 1 After small investigation I found out that each column in mysql has itself encoding. To allow polish encoding in column name I had to set encoding to …
MySql doesn’t accept polish letters [Music no 12] Read More »
In the previous blog post, I show how to create MySQL database on linux server. I was able to access that MySQL, create db, create users and so on. The music application which is no the server is able to use this db. BUT! Nobody can access that database from outside. I am not able …
How to allow remote connection to mysql [Music no 11] Read More »
I had a problem that sometimes somebody hacked my password to my Linux server and run some programs on my Linux server. Every time when I decided to rebuild my Linux distribution on the server and change password to more crazy after a few months this happened again – somebody hacked access to my Linux. …
How to disable SSH login for the root user on Linux? [Music no 10] Read More »
This post is continuation of previous one. I created new folder where I’ll have production code: Then I clone repo to that place I use User Secrets approach. So I need to create specific folder and copy there my secrect.josn To run my application I go to specific folder and just run it :). I …
Set up .NET Core project in Linux with Nginx [Music no 9] Read More »
I wrote this post because I tried to have on one Linux server .NET Core app and MySQL with PhpMyAdmin tool. On the Internet I found how to do it on 16.04, but it doesn’t work as ease as it is written on 18.04. I wrote that post base on articles: https://www.digitalocean.com/community/tutorials/how-to-install-linux-nginx-mysql-php-lemp-stack-in-ubuntu-16-04 and https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-with-nginx-on-ubuntu-16-04. Login …
How To Install Nginx, MySQL, PHP, PhpMyAdmin, .NET Core in Ubuntu 18.04 [Music no 8] Read More »
I moved from www.oktawave.com to https://www.linode.com/.Linode is cheaper and has more RAM and disk space. I followed that instruction https://www.linode.com/docs/getting-started/ to set up a new machine. It is worth to remember to google some promo code to get an extra start some extra dollars for new register users. I decided to follow instructions from my post Hosting two websites …
I want to host two applications on one Linux server. One app for dev, another app for users. The problem which I have is that I try managed with sensitive data like connection string. Both databases (for dev and prod) are available on the Internet. Ideally, I want to write an app on the Windows, …
I’ve already lost loads of time with my project. People could use my app for 2 weeks at least. But I try to improve that to make it better and more generic. All the time I check if everything is up and running on to Linux server. I came up with the idea to host …
Hosting two websites on one linux server [Music no 5] Read More »
Follow those steps if the app is up and running 🙂 Go to putty: sudo apt-get update sudo apt-get install openssh-server unzip curl Debug -> Attach to process Select Connection type: SSH and write Connection target: root@yourservername.com
How to publish site with Visual Studio 2017 to Linux server: sudo apt-get update sudo apt-get install openssh-server unzip curl Y Go to VS2017 and hit publish on project: Set up debug mode on publish: