Tag Cloud
Currently Reading
Latest Book Reviews
- Rancher Deep Dive Posted on March 31, 2023
- Leveraging Kustomize for Kubernetes Manifests Posted on March 24, 2023
- Automating Workflows with GitHub Actions Posted on October 13, 2022
- Deep-Dive Terraform on Azure Posted on August 30, 2022
- Effective DevOps Posted on January 5, 2022 All Book Reviews
Latest Posts
- Reverse DNS in BIND 9.8 Posted on September 4, 2013
- Exporting data in MySQL to an XML file Posted on August 13, 2013
- ZFS on Linux: Kernel updates Posted on July 28, 2013
- lsof alternative in Solaris 11 Posted on June 1, 2013
September 4, 2013
Reverse DNS in BIND 9.8
by Alpha01
I use BIND on my home network, and giving the bast amount of virtual machines I have online, I’ve always find myself wanting to easily look up which machine is using which IP address without having to ssh into the actual vm or check the zone file. Configuring reverse DNS in BIND 9.8 is actually a dead simple process.
First, a separate zone file for PTR records needs to be created, I named mine db.192.168.1.255.
Note: since my network address space is 192.168.1, the actual PTR record will be the network address backgrounds followed by in-addr.arpa..
$TTL 3h
@ IN SOA ns1.rubyninja.org. dnsadmin.rubysecurity.org. (
2013090701 ; serial
3h ; refresh after 3 hours
1h ; retry after 1 hour
1w ; expire after 1 week
1H ) ; negative caching TTL of 1 hour
IN NS ns1.rubyninja.org.
IN NS ns2.rubyninja.org.
14.1.168.192.in-addr.arpa. IN PTR email.rubyninja.org.
Lastly, the zone entry needs to be added to the master named.conf file. Mine looks like this
zone "1.168.192.in-addr.arpa" IN {
type master;
file "etc/zones/db.192.168.1.255";
allow-query { any; };
};
After reloading Bind, you verify reverse DNS works by using the utility of your choice; ie dig, host, nslookup, etc..
nslookup 192.168.1.14
Server: 192.168.1.10
Address: 192.168.1.10#53
14.1.168.192.in-addr.arpa name = email.rubyninja.org.
bind August 13, 2013
Exporting data in MySQL to an XML file
by Alpha01
So I just started reading a new MySQL administration book and starting to learn cool things that I didn’t even know. One cool feature MySQL supports that I wasn’t aware of is the ability to export and import data to and from XML files.
For example the following will export the table City from world database to an XML file.
root@mysql:~# mysql --xml -e 'SELECT * from world.City' > city.xml
To import data from the XML itself can be accomplished using the LOAD XML statement.
(root@localhost) [world] LOAD XML INFILE 'city.xml' INTO TABLE City;
Query OK, 4079 rows affected, 14 warnings (0.81 sec)
Records: 4079 Deleted: 0 Skipped: 0 Warnings: 14
Resources
Tags: [mysql July 28, 2013
ZFS on Linux: Kernel updates
by Alpha01
Just as I would expect, updating both the kernel’s of the machine that is running VirtualBox and its virtual machines and the ZFS enabled Linux virtual machine has completed with absolutely no issues. Originally, I was more concern on updating the host VirtualBox machine’s kernel given that I’ve never really done this in the past using the additional VirtualBox Extension Pack add-on before, while on the other hand I wasn’t to concern regarding the ZFS kernel module, given that it was installed as part of a dkms kernel module rpm. Which regardless of what people think about dkms modules, as a sysadmin that have worked with Linux systems with them (proprietary), it’s certainly a relief knowing that little or no additional work is needed to rebuild the respective module after updating to a newer kernel.
ubuntu virtualbox zfs June 1, 2013
lsof alternative in Solaris 11
by Alpha01
(Warning: output is pretty ugly)
pfiles /proc/*
solaris networking