Showing entries 11 to 20 of 28
« 10 Newer Entries | 8 Older Entries »
Displaying posts with tag: dns (reset)
Working with IP's in MySQL and MariaDB - Part 2

Use DNS directly from your database

mysql> SELECT lookup('localhost');
+---------------------+
| lookup('localhost') |
+---------------------+
| 127.0.0.1 |
+---------------------+
1 row in set (0.00 sec)

mysql> SELECT reverse_lookup('127.0.0.1');
+-----------------------------+
| reverse_lookup('127.0.0.1') |
+-----------------------------+
| localhost |
+-----------------------------+
1 row in set (0.00 sec)


This is how you install these functions.

  1. Build udf_example.so which is in your mysql source. (make udf_example.so)
  2. Copy the udf_example.so file from your build directory to your plugin_dir.
  3. Create the lookup and reverse_lookup functions
mysql> CREATE …
[Read more]
MySQL: Disable DNS Lookups

In a small environment, there's very little reason to rely on DNS resolution inside MySQL. You can disable it by adding skip-name-resolve to your my.cnf or by using the --skip-name-resolve command line argument. Remember that if you disable DNS lookups, you will need to set permissions using IP addresses rather than host names!

Clear Windows DNS Server Cache From the CLI

Clearing the Windows DNS Server cache from the command line is an easy task.

C:\> dnscmd . /clearcache

The . indicates the local DNS server. You can use this command to clear the cache of remote DNS servers by replacing the . with the hostname or IP address of the remote server.


[Read more]
Don’t forget to monitor your nameservers

As I mentioned in a past article I got my IPv6 connectivity working so started working on setting up various IPv6 services. One of these was to setup my name server so it also worked on IPv6. This worked fine, but recently I lost my IPv6 connectivity but thought no more about it. I’m trying [...]

Tech Messages | 2010-05-14

A special extended edition of Tech Messages for 2010-04-29 through 2010-05-14:

[Read more]
MySQL – IP vs DNS

A MySQL is running happily on a machine situated in a land far far away. I grant access to a user@machine_aaaaaa (grant select on db.* to ‘user’@'machine_aaaaa’ identified by ‘password’; flush privileges;), send an email to the user saying it should run fine and happily go off my way. Mistake!

It seems this user can’t connect to the mysql gets access denied:
Access denied for user ‘user’@'machine_bbbbb’ (using password: YES)

Note that the machine the user is being seen from is totally different from the one I set up in the grant!! WHY?

run a reverse lookup on the ip of machine_aaaaa, turns out it shows machine_bbbbb. So I figure a big bad guy messed up /etc/hosts, I was right! `cat /etc/hosts` just to find an entry for machine_aaaaa blehh

Ok, solution is to remove the entry from /etc/hosts (after finding out it wasn’t even necessary and wasn’t even supposed to be there in the first …

[Read more]
NoSQL vs MySQL

No I did NOT post the following comment

This is ridiculous. You didn't test MySQL, you tested a failing DNS lookup on authentication.

resulting in the follow up post :


My previous post Redis, Memcache, Tokyp Tyrant, MySQL comparison had a flaw as pointed out by this comment. The MySQL was taking a huge time for doing a reverse DNS lookup.

But as always ... Everything is just a Freaking dns problem :)

Technorati Tags: dns dnsproblem mysql

[Read more]
Four short links: 5 October 2009
  1. Brown Cloud Marketing -- advertorial "interviewing" GM of a company offering "DNS in the cloud". This might be a worthwhile service, but the way he markets it (by saying open source is "freeware" and the market leader is "legacy") reveals a rich vein of bozo. Freeware legacy DNS is the internet's dirty little secret (actually, it's the reason we have a functioning DNS), Nominum software was written 100 percent from the ground up, and by having software with source code that is not open for everybody to look at, it is inherently more secure. (security through obscurity is equating clothing with being naked yet blind). The Internet kindly did the poor man's homework: screenshot of a cross-site scripting …
[Read more]
The Story Repeats

I covered this one before .. but as it struck twiced today .. I think it's worth repeating. Both my collegue Karl and Trent ran into the same problem , within hours hours of eachother, a missing or failing reverse dns mapping that caused performance issues .. and a lot of log entries..

Karl denies having a second life in Perth but I`m not really sure about that ...

But I guess they both have to agree... Everything is a fscking DNS problem.
(I noticed other people using that spelling this weekend, on stage in the Janson)

Technorati Tags: dns dns problem

[Read more]
Installing PowerDNS (With MySQL Backend) And Poweradmin On CentOS 5.2

Installing PowerDNS (With MySQL Backend) And Poweradmin On CentOS 5.2

This article shows how you can install the PowerDNS nameserver (with MySQL backend) and the Poweradmin control panel for PowerDNS on a CentOS 5.2 system. PowerDNS is a high-performance, authoritative-only nameserver - in the setup described here it will read the DNS records from a MySQL database (similar to MyDNS), although other backends such as PostgreSQL are supported as well. Poweradmin is a web-based control panel for PowerDNS.

Showing entries 11 to 20 of 28
« 10 Newer Entries | 8 Older Entries »