MySQL-TSDNS

A TSDNS-Server for Teamspeak 3, that uses MySQL for configuration.
For more information how it works, look at Configuration.

Requirements

• nodejs
• npm

Installation

1. Download the Git-Repo (we recommend stable) into a directory of your choice.
2. Run npm install to install the dependencies.
3. Copy the config.dist.json-file to config.json and change it, as your needs.
4. Import the init.sql into your database (structure + testdata). Ensure that you selected a target scheme first.
5. Change the settings in the db, as your needs (see Configuration for more).
6. Run ./mysql_tsdns_startscript start to start the MySQL-TSDNS-server and your are ready. :D

Configuration

MySQL-TSDNS stores all data in the db (name would be silly otherwise).
As a domain is requested, MySQL-TSDNS first read all available tables to look the teamspeak-servers up from the serverTables-Table, then it goes throw every table and searches for the requested domain. If it found something, it gives back the destination and closes the request. If nothing is found, it tries to get a default-server from the serverDefault-Table, if one is specified and active.

If nothing is found again, MySQL-TSDNS returns 404 and closes the request also.
The Teamspeak-Client will show a "Server not found" in this case.

An example setup is shipped with the import of the init.sql-file, which will fit the most usages (just add more servers to the basic-table).

A note to the additionalColumns-Column in the serverTables-Table

This field is used, to tell the programm, that there are special columns in the specified serverTable. At the moment, the only usable special column is lastLookup, which should be an integer as type. If you specified this column, MySQL-TSDNS will save a timestamp in this field, everytime the domain is requested.

License

This software is licensed under the Mozilla Public License v. 2.0. For more information, read the file LICENSE.