Problem
You would like to access a host set up with nginx after adding your own vhost configuration file in /etc/nginx/conf.d/myfile.smth, but you get Connection refused.
Solution
Make sure that your nginx configuration file has the .conf extension as /etc/nginx/conf.d/myfile.conf.
Problem
You have a folder with many gzipped files that you want to unzip at the same time.
Solution
1ls -al | grep gz | awk '{ print $9}' | xargs gunzip
Problem
You are trying to use docker-compose to get some services up with docker but you see an error like the following:
|
1 |
Cannot create container for service xxx: invalid mode: /path/to/volume/ |
Solution
This is more than likely caused by a typo in your yml file, so go back and check carefully for any typos and correct them.
Problem
Using docker-compose up (or build), displays the following error message (even though the same command used to work previously):
|
1 |
ERROR: Couldn't connect to Docker daemon at http+docker://localunixsocket - is it running? |
Solution
This is quite possible caused by permissions issue, as one of the folders files that docker is trying to use is owned by a different user/group from the one trying to use the docker-compose commands. Try to find the file/folder with the different permissions and change it to your user name and group, or use change the files by using something like:
|
1 |
chown -R me:me . |
Problem
You are trying to run the ps command in a docker container (ie ps ax), but you get:
|
1 |
bash: ps: command not found |
Solution
Taken from the answer here
1apt install procps
Problem
You have a MySQL table that does not have any timestamp information (creating, updating) and you want to add a column that automatically adds a timestamp every time the record is created.
Solution
Add the column for timestamp that creates a timestamp every time a new record is created (INSERT) by using the following:
|
1 |
ALTER TABLE table_name ADD created_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP |
More information here
Problem
You would like to know the IP Address of a running Docker container.
Solution
Use the following to find out the IP Address by replacing the container_name with the actual container name:
|
1 |
docker inspect -f '{{ .NetworkSettings.IPAddress }}' container_name |
Trying to set up minikube you get the following error:
Error setting up kubeconfig: writing kubeconfig: Error writing file : open : no such file or directory
Unset the KUBECONFIG to solve the issue (unset KUBECONFIG) as described https://pubci.com/2017/01/01/why-not-tryout-kubernetes-locally-via-minikube/
Problem
You would like to change the options in your application’s php.ini file (ie maximum upload file size), which is hosted in dreamhost.
Solution
Dreamhost is using a file called phprc which is installed in your home directory (~/phprc).
More information here
Edit this file and change the setting you would like.
Problem
You would like to have a list with all the tables in an MySQL database, sorted with their sizes (actual table and indices).
Solution
You could run the following query to give you a list of all the tables sorted by size:
|
1 2 3 4 5 6 |
SELECT table_schema AS database_name, table_name AS table_name, round(((data_length + index_length) / 1024 / 1024), 2) AS size_mb FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC; |
Take from the answer here