February 2018

24. February 201824. February 2018

Top 25 most downloaded files on c64g.com

c64g.com is a Commodore 64 site where you can download games.

This is the the top 25 list of most downloaded files

+---------------------------------------------+----------+-----------+
| filename                                    | filesize | downloads |
+---------------------------------------------+----------+-----------+
| Boulderdash.First_Star.Nova.zip             | 11K      |      2708 |
| Hitler_Diktator.BGS.zip                     | 17K      |      2569 |
| 1942.Elite.+2-BAM.zip                       | 31K      |      2408 |
| Commando.Elite.+5hd-REM.zip                 | 31K      |      2267 |
| Giana_Sisters.Rainbow_Arts.+3-HTL.zip       | 38K      |      1866 |
| Impossible_Mission.Epyx.+5pd-REM.zip        | 44K      |      1728 |
| Wasteland.EA.original.zip                   | 796K     |      1706 |
| International_Karate.System_3.FLT.zip       | 42K      |      1669 |
| Winter_Games.Epyx.original.zip              | 225K     |      1659 |
| Pac-Man.Atari.+1-MHI.zip                    | 7.0K     |      1623 |
| Bubble_Bobble.Firebird.+8pd-REM.zip         | 50K      |      1621 |
| Bruce_Lee.Datasoft.+1-Sharks.zip            | 30K      |      1615 |
| Donkey_Kong.Atari.CRT-original.zip          | 12K      |      1605 |
| 3D_Pacman.Nufekop.zip                       | 14K      |      1586 |
| Boulderdash_01-10..+-5211.zip               | 143K     |      1563 |
| Impossible_Mission.Epyx.SFN_Soft.zip        | 102K     |      1542 |
| Space_Taxi.Muse.HJD.zip                     | 77K      |      1500 |
| Ghostbusters.Activision.Danish_Crackers.zip | 47K      |      1478 |
| Last_Ninja_2.System_3.+3-Ikari.zip          | 289K     |      1469 |
| California_Games.Epyx.d-REM.zip             | 184K     |      1364 |
| Summer_Games.Epyx.Jedi.zip                  | 159K     |      1356 |
| Blue_Max.Synapse.zip                        | 19K      |      1351 |
| Last_Ninja_1.System_3.original.zip          | 268K     |      1350 |
| 1000_Miglia.Simulmondo.F4CG.zip             | 120K     |      1310 |
| Ghostbusters.Activision.ESI.zip             | 31K      |      1289 |
+---------------------------------------------+----------+-----------+

+---------------------------------------------+----------+-----------+

| filename | filesize | downloads |

+---------------------------------------------+----------+-----------+

| Boulderdash.First_Star.Nova.zip | 11K | 2708 |

| Hitler_Diktator.BGS.zip | 17K | 2569 |

| 1942.Elite.+2-BAM.zip | 31K | 2408 |

| Commando.Elite.+5hd-REM.zip | 31K | 2267 |

| Giana_Sisters.Rainbow_Arts.+3-HTL.zip | 38K | 1866 |

| Impossible_Mission.Epyx.+5pd-REM.zip | 44K | 1728 |

| Wasteland.EA.original.zip | 796K | 1706 |

| International_Karate.System_3.FLT.zip | 42K | 1669 |

| Winter_Games.Epyx.original.zip | 225K | 1659 |

| Pac-Man.Atari.+1-MHI.zip | 7.0K | 1623 |

| Bubble_Bobble.Firebird.+8pd-REM.zip | 50K | 1621 |

| Bruce_Lee.Datasoft.+1-Sharks.zip | 30K | 1615 |

| Donkey_Kong.Atari.CRT-original.zip | 12K | 1605 |

| 3D_Pacman.Nufekop.zip | 14K | 1586 |

| Boulderdash_01-10..+-5211.zip | 143K | 1563 |

| Impossible_Mission.Epyx.SFN_Soft.zip | 102K | 1542 |

| Space_Taxi.Muse.HJD.zip | 77K | 1500 |

| Ghostbusters.Activision.Danish_Crackers.zip | 47K | 1478 |

| Last_Ninja_2.System_3.+3-Ikari.zip | 289K | 1469 |

| California_Games.Epyx.d-REM.zip | 184K | 1364 |

| Summer_Games.Epyx.Jedi.zip | 159K | 1356 |

| Blue_Max.Synapse.zip | 19K | 1351 |

| Last_Ninja_1.System_3.original.zip | 268K | 1350 |

| 1000_Miglia.Simulmondo.F4CG.zip | 120K | 1310 |

| Ghostbusters.Activision.ESI.zip | 31K | 1289 |

+---------------------------------------------+----------+-----------+

There is no other reason why some files are colored red and some blue other than the syntax highlighting plugin of this blog.

This makes a list of 25 most downloaded games on c64g.com,
if you take into account rank 26-30.

| Impossible_Mission.Epyx.zip                 | 39K      |      1263 |
| Bruce_Lee.Datasoft.The_Pro.zip              | 43K      |      1246 |
| Turrican.Rainbow_Arts.+7-Sharks.zip         | 247K     |      1237 |
| Mario_Bros_2.Thundersoft.Microman.zip       | 33K      |      1222 |
| Wizard_of_Wor.Commodore.+3dh-REM.zip        | 21K      |      1220 |

| Impossible_Mission.Epyx.zip | 39K | 1263 |

| Bruce_Lee.Datasoft.The_Pro.zip | 43K | 1246 |

| Turrican.Rainbow_Arts.+7-Sharks.zip | 247K | 1237 |

| Mario_Bros_2.Thundersoft.Microman.zip | 33K | 1222 |

| Wizard_of_Wor.Commodore.+3dh-REM.zip | 21K | 1220 |

Boulderdash
Impossible Mission
Ghostbusters
Hitler Diktator
1942
Commando
Giana Sisters
Wasteland
International Karate
Winter Games
Pac-Man
Bubble Bobble
Bruce Lee
Donkey Kong
3D Pacman
Impossible Mission
Space Taxi
Last Ninja 2
California Games
Summer Games
Blue Max
Last Ninja 1
1000 Miglia
Bruce Lee
Turrican

16. February 2018

Angular Development Server behind Nginx with Go API

You’re here because you’d like to know the nginx.conf or rather the vhost conf for nginx in order to serve an Angular dev app on your local host.
Angular listens on port 4200 with ng serve.
In my case I have a keycloak-proxy listening on port 8080.
And my api is on /api/v1/ .
My project is called “dating”.
It’s located at ~/WebstormProjects/dating/ .

So let’s make this simple.

server {
    listen 80;
    listen [::]:80;
    server_name dating.dev.luketic;
    root /home/darko/WebstormProjects/dating/src/;
    index index.html;

    error_log /var/log/nginx/dating.error;

    location / {
        proxy_pass http://localhost:4200;
        proxy_read_timeout 30;
        proxy_connect_timeout 30;
        proxy_redirect off;
        proxy_set_header X-Real-IP          $remote_addr;
        proxy_set_header X-Forwarded-For    $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto  $scheme;
    }

    location /sockjs-node/ {
        proxy_http_version 1.1;
        proxy_set_header Upgrade $http_upgrade;
        proxy_set_header Connection "upgrade";
        rewrite ^/(.*)$  /$1  break;
        proxy_set_header Host localhost;
        proxy_pass http://localhost:4200/;
    }

    location ~ ^/api/v1/.* {
        proxy_pass http://localhost:8080;
        proxy_read_timeout 30;
        proxy_connect_timeout 30;
        proxy_redirect off;
        proxy_set_header Host               $host;
        proxy_set_header X-Real-IP          $remote_addr;
        proxy_set_header X-Forwarded-For    $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto  $scheme;
    }
}

server {

listen 80;

listen [::]:80;

server_name dating.dev.luketic;

root /home/darko/WebstormProjects/dating/src/;

index index.html;

error_log /var/log/nginx/dating.error;

location / {

proxy_pass http://localhost:4200;

proxy_read_timeout 30;

proxy_connect_timeout 30;

proxy_redirect off;

proxy_set_header X-Real-IP $remote_addr;

proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;

proxy_set_header X-Forwarded-Proto $scheme;

}

location /sockjs-node/ {

proxy_http_version 1.1;

proxy_set_header Upgrade $http_upgrade;

proxy_set_header Connection "upgrade";

rewrite ^/(.*)$ /$1 break;

proxy_set_header Host localhost;

proxy_pass http://localhost:4200/;

}

location ~ ^/api/v1/.* {

proxy_pass http://localhost:8080;

proxy_read_timeout 30;

proxy_connect_timeout 30;

proxy_redirect off;

proxy_set_header Host $host;

proxy_set_header X-Real-IP $remote_addr;

proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;

proxy_set_header X-Forwarded-Proto $scheme;

}

So again this is for the DEVELOPMENT server. Production has different settings.

13. February 2018

keycloak: upstream sent too big header while reading response header from upstream

The relevant bits on how to solve this header too big error message

                proxy_buffer_size 64k;
                proxy_buffers 8 64k;
                proxy_busy_buffers_size 64k;

proxy_buffer_size 64k;

proxy_buffers 8 64k;

proxy_busy_buffers_size 64k;

For a whole keycloak listening on default port 8080 example with letsencrypt see below

server {
        listen 80;
        listen [::]:80;
        server_name my.serv.er.name;
        include /etc/nginx/acme.conf;
        location / {
                return 301 https://$host$request_uri;
        }
}


server {
        listen 443 ssl http2;
        listen [::]:443 ssl http2;
        server_name my.serv.er.name;
        ssl_certificate /etc/letsencrypt/live/my.serv.er.name/fullchain.pem;
        ssl_certificate_key /etc/letsencrypt/live/my.serv.er.name/privkey.pem;
        access_log /var/log/nginx/my.serv.er.name.access.log;
        error_log /var/log/nginx/my.serv.er.name.error.log;

        location / {
                proxy_pass http://127.0.0.1:8080;
                proxy_set_header Host               $host;
                proxy_set_header X-Real-IP          $remote_addr;
                proxy_set_header X-Forwarded-For    $proxy_add_x_forwarded_for;
                proxy_set_header X-Forwarded-Proto  $scheme;
                proxy_buffer_size 64k;
                proxy_buffers 8 64k;
                proxy_busy_buffers_size 64k;
        }

}

server {

listen 80;

listen [::]:80;

server_name my.serv.er.name;

include /etc/nginx/acme.conf;

location / {

return 301 https://$host$request_uri;

}

server {

listen 443 ssl http2;

listen [::]:443 ssl http2;

server_name my.serv.er.name;

ssl_certificate /etc/letsencrypt/live/my.serv.er.name/fullchain.pem;

ssl_certificate_key /etc/letsencrypt/live/my.serv.er.name/privkey.pem;

access_log /var/log/nginx/my.serv.er.name.access.log;

error_log /var/log/nginx/my.serv.er.name.error.log;

location / {

proxy_pass http://127.0.0.1:8080;

proxy_set_header Host $host;

proxy_set_header X-Real-IP $remote_addr;

proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;

proxy_set_header X-Forwarded-Proto $scheme;

proxy_buffer_size 64k;

proxy_buffers 8 64k;

proxy_busy_buffers_size 64k;

}

9. February 2018

Create MySQL Database and User – the proper way

I read so much bullshit about how to create a mysql user and database, in most cases it’s not just inefficient but also wrong.

So here is the best and most efficient way to create a MySQL database and user with password:

CREATE DATABASE mydatabase;
GRANT ALL ON mydatabase.* TO 'myuser'@'localhost' IDENTIFIED BY 'mypassword';

1 2	CREATE DATABASE mydatabase; GRANT ALL ON mydatabase.* TO 'myuser'@'localhost' IDENTIFIED BY 'mypassword';

Done.

No FLUSH PRIVILEGES.
No create user, then database then give user access then update password.
Just those 2 lines. Nothing more.