The correct way to copy data is not to extract to a CSV and import with some tool, to manually create INSERT queries, or to try filtering the pg_dump output. You should use the COPY function included in postgres, as such: psql -c “COPY (SELECT * FROM my_table WHERE created_at > ‘2012-05-01’) TO STDOUT;” source_db […]
Following up on my previous post with the same topic, for Hyper-V, this is how to get DNS names for your VirtualBox guest VM’s into your hosts file on a Windows host. First things first, you need the VirtualBox Guest Additions installed for the host to tell OS level information about the guest, just as […]
So, running a couple of Hyper-V machines, and needing to determine their local IP addresses to connect to them. As long as the Hyper-V Integration Services are installed (apt-get install hyperv-daemons on Debian-based distributions), PowerShell on the host machine will have access to the IP addresses of the client machine. Without the Integration Services, PowerShell […]
I recently had need of a service that would return your exact query to you for web client (or proxy) development purposes, in a case where using Fiddler, Wireshark, tcpdump et.al. was proving difficult for various reasons. The solution became the C-Net Echo Service, available at https://echo.c-net.org/ (and over plain HTTP if you need it). […]
curl: (60) SSL certificate problem: unable to get local issuer certificateMore details here: https://curl.haxx.se/docs/sslcerts.html So curl fails to access sites over https, even if ca-certificates is installed in your Docker container? You need to force a certificate rehash. Why this is not done by default escapes me. /usr/bin/c_rehash curl should be happy now. Enjoy!
Just wrote this thing. Putting it here, in case anyone needs it. perl -e ‘my @c = ((‘a’..’z’), (‘A’..’Z’), (0..9)); for(1..128) {print $c[int(rand($#c+1))]}’ It creates random passwords, with the length specified by the number following “1..”, which is 128, in this example. Example outputs: lFcQYCtPl653r9D3cSfcFyeLJlbdDNPrxeIjkf6c77CjBRgtTRHKKL824La4giNLJkza66CzlecoOExPeuEJyQAnHFOQpcPsPbRiycSttCXwGhYK40BfQFlLWJapPltu HQVfvdUrkOOExPAiH5ry7u177TjgsDnfW4FlVuDeU3f833kPAe9z4XKZuKhqYaTZAd7wzuAgX8eTWM79TgDymNJWZ8RNRa30DuNSd5xCZ6rkMS00q35R4jWxR7Ztzbfn dCAlGY0KfNlPfp9D2DuhNHM8oqXFijXrjaRWxidzydzjUF61i0sAitCiZUiOrBsZwToqWXXMbxxjo6kKOIb5MxFQPkuIfsteavxd6gX2I7sQhJh4MmztondoikQ4Pb6i
After installing the latest stable version of docker-ce (5:18.09.0~3-0~raspbian-stretch as of the time of writing), Docker would take ages to start after a reboot. Commands would even time out waiting for it. /var/log/daemon.log shows a gap of almost 4 minutes between the attempt to start the Docker Application Container Engine and the first log line […]
Introducing a new Cathedral Networks service. The console friendly pastebin that supports binary files. We needed one, so now it exists. Take a look at https://paste.c-net.org/
Tasked with recovering files you don’t have access to through the web interface, you can always find these through the file system if you’re the operator. You could, of course, give yourself access, but let’s save that for another time. Right now we want the files our users removed and/or can’t find. We start by […]
If you use Cygwin to mainly manipulate files in your regular Windows filesystem, under /cygdrive/…, you have probably seen this message more than a few times: “The permissions on <node> are incorrectly ordered, which may cause some entries to be ineffective” You have also likely seen “NULL SID” as the top entry in permission lists. […]