February 2018 - blog.icod.de

Top 25 most downloaded files on c64g.com

24. February 2018

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 […]

Angular Development Server behind Nginx with Go API

16. February 2018

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 […]

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

13. February 2018

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;

}

Create MySQL Database and User – the proper way

9. February 2018

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 […]