In Loki We Trust

As the title says, this is just a quick update to let people know that the dnsEditor SVN repo now includes a docs directory that has a schema.sql file, with the DB schema I use, and a named.conf.local. Any improvements to wither are welcome of course, just as any improvements to the base code are welcome.

I’ve released the source for SQL_CLI under the GPL. SQL_CLI is a simple program that allows you to run a set of SQL commands against a given DSN (or DSN-less connection string) using either OLE or ODBC.

It is written in C#, and the code should be easy enough for someone to understand.

It takes three arguments:

• [ole|odbc] - The type of connection to make
• [DSN] - The name of a DSN, or else a DSN-less connection string
• [filename] - A SQL command file - essentially, a file with one SQL command per line

Hopefully some of you should find this useful - I use it for mass imports of data into all sorts of databases.

Source is here:
https://svn.lokkju.com/svn/SQL_CLI/trunk/

The source code for the dnsEditor:Ajaxified is now available. you can get it anonymously at:

https://svn.lokkju.com/svn/dnsEditor/trunk

Yes, it is ugly, but it *does* work.
All of the code is released under GPL, and other licenses are open to negotiation.
I will be commenting more code and cleaning it up as time goes by, and patches are always welcome - if you really want to help, I can also give you subversion access.

And donations are always welcome as well (see that little button on the side? it is there for a purpose…) *grin*.

Have fun…

Just a quick note, I have started back in on the gmaps widget, using the GMap2 structure, and basing it on the API code to prevent future breakage.

Hopefully it should be released in a couple weeks!

I needed a lits of all the asterisk functions, in a html list format, so I whipped up this:

and for all applications, xml format:

Obviously, replace the www-data username with your asterisk username. Also, if you want to change the output details, just change the last bit, where perl outputs the results of the regex.

Have fun.

Check out the new project at GMPrice.com

Well, I'm still doing more work on the GMaps Widget (I wish they would stop changing their code), and on the dnsEditor, but in the meantime I have a some project I recently put into alpha phase.

Please, don't pass this new service around too much - still in very alpha, and I would prefer to keep it light on the bandwidth.

At any rate, GMPrice (Grey Market Price) is a simple little tool for finding the average sold price of an item on ebay - this is very specifically just a "search proxy" - you type the query, it does the search, calculates some results, and returns them to you.

Next steps:

• Right now it only looks at sold items with at least one bid - soon it will count "buy it now" sold items as well.
• It will also eventually display a sold/unsold ratio

Oh yeah, I do need a logo for the Grey Market Price project, so... ideas/submissions are welcome

UPDATE:Source is now available!

So I finally found some more time to work on the dnsEditor interface - and I think I've done most of what was needed for now.
Demo: http://www.lokkju.com/projects/dnsEditor2/dnsEditor.php

Screenshot:

Fixes/Additions:

• Replaced all the +/- links to add/delete items with image buttons
• Implemented Add/Delete Zones
• Added a Refresh Zone List button
• Added a hover tip box
• Implemented multi-server update (through mysql) of modified records. (disabled in demo)
• Automatically update the SOA serial with epoch time on changes

Still to possibly do:

• Add TXT (and perhaps CNAME) abilities, this is actually very quick to do.
• Add SPF generator to TXT records editor.
• Add as you edit help - for instance, describe what the rules are for the feild you are currently in.
• Add a verification function, to verify either a specific zone, or all zones in your DB, and generate a report (similar to dnsreports.com).
• Add authentication, on a per zone, and possibly fine grained control of which records in a zone are allowed to be updated. Would most likely require seperate permissions table.
• Add a database abstration layer for both different RDBMS and different table layout - I would love some suggestions on this. (MAJOR)

More suggestions are always welcome.

Original Post Here

This is the unofficial Google Maps viewer for the OSX Dashboard.
Current version is 0.9c

Download

Version 0.9c Screenshot:

Upcoming Version 1.0a Screenshot:

Future Features:
• Pop-out sidebar for directions support.
• Print Functionality - options include new safari window, handle it within the widget, etc?
• Some sort of route following function be of use (in directions mode)?
• Support for loading your own xml/xsl mapping files.
• Support for google's satellite maps (this is already done, just not enabled).
• Support for TerraServer satellite mapping data - allowing better resolution, though with older photographs, for the satellite view.
• Much better GUI - with design by Daniel Burka of SilverOrange

Update:
Still working on the bug fiexes, as google has switched to a new API - see the newest post on the subject here

Current Bugs
• It will not show the content in the popup pin windows.

I am always open to suggestions and improvements, so feel free to post in the comments section, or email me directly at lokkju@lokkju.com

Normally, when using DB9 Modular ends, you use them with a "standard reversing" Cat5(e) cable - which is really only standard to a very small subset of people. If, like me, you are one of those people who always have the real "standard" Cat5(e) cable around - the stuff used for normal computer networking - then this pin diagram will show you how to create modular ends to turn it into a null modem cable. It is, after all, easier to carry a couple ends then it is a whole seperate serial cable. The other advantage, and the reason I do this, is because this makes it east to have double ended female, or double ended male serial cables - which are hard to find.

Anyway, the table:

Null Modem Cable End "A"

Null Modem Cable End "B"

Bind-DLZ (Dynamically Loadable Zones) is a patch for BIND version 9 that simplifies BIND administration and reduces memory usage and startup time. DLZ allows you to store your zone data in a database. Unlike using scripts, the changes in your database are immediately reflected in BIND's response to DNS queries, so there is no need to reload or restart BIND. You see, BIND "dynamically loads" the "zone" data it needs to answer a query from the database.

Though DLZ is the best thing to happen to DNS (and Bind specifically), it has one major flaw - there is no suitable front end for managing the database that DLZ uses.

Over the past few weeks I have been working on a front end for DLZ, and I think I finally have a decent one. Please note, this is a beta, and demo, only, and the code is for you to look at, not to use, as I am not sure on my licensing yet for this.

At any rate, here is a link to the demo:
http://www.lokkju.com/projects/dnsEditor/SampleEditInterface.php

It currently edits against a mysql database of sample data, which has the exact same table structure as the version I use for production (live) editing of our DNS records.

The two things that currently do not work right are adding and deleting actual domain names (only because I have not figured out the method I want to use, in terms of the GUI), and the SOA record layout is a little funky.