# iptables -I FORWARD -m physdev --physdev-is-bridged -j ACCEPT # ip6tables -I FORWARD -m physdev --physdev-is-bridged -j ACCEPT
Paul Hartman
Things I found useful or interesting.
Sunday, December 19, 2021
QEMU/KVM/virt-manager guest can't access network in bridged mode with iptables
Sound stops working in Linux
If your sound stops working in linux, you may see errors about being unable to connect to ALSA, or mplayer might say "Audio device got stuck!". If you don't want to reboot, killing pulseaudio will usually do the trick:
$ pulseaudio -k
Sunday, April 11, 2021
View all packages installed from overlay in Gentoo Linux
To easily view which packages were installed from which overlay, using app-portage/eix:
eix --installed-in-overlay <optional overlay name>
If you do not specify an overlay name, it will show all packages from all overlays.
Sunday, January 3, 2021
Neo Geo AES Memory Card Management
Thursday, October 8, 2020
SQL Server Management Studio (SSMS) 18.x won't save server passwords
Starting around SSMS 18.x, Microsoft changed the way credentials were stored. This caused any saved passwords from previous versions to stop working in the server connection dialog popup.
To fix this, just delete the servers from the drop-down list. Alternatively, exit SSMS, clear out the saved servers in C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\18.x\UserSettings.xml and then restart.
If you use registered servers, the saved passwords will still work and will automatically be saved into the popup. If not, you'll have to type them in again.
Friday, October 2, 2020
Force Windows to use all available cores to process NGen queue
If it seems like mscorsvw.exe is running forever, you can use this script from the official .NET github repo to force ngen to process the queue using all available CPU power.
Monday, September 21, 2020
PC Engine HuCard Volumes
Hudson
- The Kung Fu
- Bikkuri World
- Victory Run
- Shanghai
- Necromancer
- Kato chan & Ken chan
- R-TYPE I
- Yuu Yuu Jinsei
- R-TYPE II
- Sengoku Mahjong
- Power League
- Mashin Eiyuuden Wataru
- Appare! Gateball
- Sadakichi Seven
- Dungeon Explorer
- Nectaris
- Susa No Ou Densetsu
- Power Golf
- Gunhed
- Power League II
- Super Momotarou Dentetsu
- Doraemon Meikyuu Daisakusen
- Neutopia
- PC Genjin
- Blodia
- Blodia Special
- Maniac Pro Wrestling
- Be Ball
- Momotarou Densetsu Turbo
- Super Star Soldier
- Power League III
- Momotarou Katsugeki
- Aero Blaster
- Bomberman
- Momotarou Densetsu II
- Jackie Chan
- Populous
- Adventure Island
- Power Eleven
- Final Soldier
- PC Genjin 2
- Power League IV
- Neutopia II
- Raiden
- Super Momotarou Dentetsu II
- Doraemon - Nobita No Dorabian Night
- Ninja Ryūkenden
- Paxanadu
- Takahashi Meijin No Shinboukenjima
- Soldier Blade
- Power League V
- Honou No Doukyuuji Dodge Danpei
- Power Sports
- PC Denjin - Punkic Cyborgs
- Momotarou Densetsu Gaiden Daiichi
- Bomberman '93
- Battle Lode Runner
- PC Genjin 3
- Power Tennis
- Power League '93
- Bomberman '94
NCS Masaya
- Gaia No Monsho (Regarded as volume 1 although there is no number on the spine)
- Moto Roader
- Ganbare! Golf Boys
- Shubibinman
- Energy
- Double Dungeons
- Gai Flame
- Hisou Kihei Serd
- Nazo No Mascarade
- Kickball
- Wallaby
- Shubibinman 2
- Moto Roader 2
- Dragon Egg
Irem
- Vigilante
- Mr Heli No Daiboken
- Image Fight
- Ninja Sprit
- Legend of Hero Tonma
- Racing Damashii
- Gekisha Boy
Sunsoft
- Out-Live
- Benkai Gaiden
- City Hunter
- Mahjong Goku Special
- Batman
Nihon Bussan/Nichibutsu
- Mahjong Wars
- F1 Circus
- ?
- F1 Circus 91
- Fighting Run
- Terra Cresta II
- F1 Circus 92
- J-League Greatest Eleven
Face
- Hani In the Sky
- Cyber Cross
- Mahjong Gakuen
- Mahjong Gakuen Mild
- Ryuukyuu
- Hani On The Road
- Fushigi No Yume No Alice (Alice In Wonderdream)
- Cross Wiber
- Metal Stoker
- Time Cruise II
UPL
- Atomic Robo-Kid Special
- Gomola Speed
Cream
- Bullfight
Victor
- Makyo Densetsu
Tengen
- Klax
Big Club/Wolf Team
- Jinmu Denshou
Copy & Paste does not work in Firefox on Google Docs
Please be aware that this is a global setting and allows all websites access to your clipboard, which is a potential privacy/security risk.
Prevent Gentoo Portage from unmerging kernel sources during a world upgrade
[kernels] class = portage.sets.dbapi.OwnerSet world-candidate = False files = /usr/src
Determining the manufacturer and recording medium of a blank CD or DVD
# cdrecord -atip
# dvd+rw-mediainfo /dev/sr0
SQL: Get just the date part of a DATETIME on SQL Server 2005
In Microsoft SQL Server 2008+ there is a DATE type, and getting just the date portion of a DATETIME is as easy as a cast or convert to DATE. But, at my job, we're still using SQL Server 2005. What then?
A common technique is to cast to a float, which gives you a number where the part to the left of the decimal point is the date and the part to the right of the decimal point is the time. Wrap that in a FLOOR function to round down to the nearest whole number and you have effectively truncated the time portion. You can then cast that back to a DATETIME.
I have, however, read that doing it that way can be inefficient as it won't use DATETIME indexes. Another approach that it supposed to be more efficient is to use DATEADD and DATEDIFF like so:
1 | SELECT DATEADD([dd], 0, DATEDIFF([dd], 0, GETDATE())); |
Again, there is no reason to do that unless you are on a Microsoft SQL Server version prior to 2008.