There are lots of tutorials online that show you how to move, or migrate if you will, your TeamSpeak 3 server from Windows to Linux, but there’s no guide that shows the other way around. One could say that this process is simply the same, only executed backwards. However, since most of them are outdated, for example most guides let you execute SQL queries to replace all the linux directory standards with windows standard which is no longer needed, I felt the need to write this up-to-date tutorial, in which I will explain how to move a Teamspeak 3 server from Linux to Windows. The process is no rocket science, so don’t worry.
In this particular tutorial, I will be moving TeamSpeak 22.214.171.124 on Ubuntu Server 12.04.5 LTS to TeamSpeak 3.0.11 on Windows Server 2008 R2. You can even migrate between versions, i.e. TeamSpeak 126.96.36.199 to TeamSpeak 3.0.11. That’s right, there’s no need to do an in-place update before you can migrate…. Now, let’s get going!
First, we need to copy the following files from our TeamSpeak 3 Linux server to our new Windows machine: licensekey.dat – Only applicable if you own a TeamSpeak 3 license. query_ip_whitelist.txt – Whitelisted IPs for the query interface query_ip_blacklist.txt – Blacklisted IPs for the query interface files/ – Any Icons, Avatars and files that were uploaded to the server. Be sure to copy the entire folder including any subfolders and files inside. ts3server.sqlitedb – The database, this file is the most important one and contains all the information about virtual servers, users, permissions, channels, groups etc. All Settings of the server instance and its virtual servers are contained in this file. Source: https://support.teamspeakusa.com/index.php?/Knowledgebase/Article/View/315/16/i-want-to-move-my-server-to-another-machine-which-files-should-i-copy
Hold your horses! In my introduction above, I mentioned that you can migrate between TeamSpeak versions withouth having to do an in-place update before. However, this *only* holds if you’re using a SQLite database, which is the case by default. This is because as of TeamSpeak Server 3.0.11, the MySQL database plugin has been replaced by a MariaDB plugin. Which means that if you were using a MySQL database for your TeamSpeak server, you need to migrate it to MariaDB, else your database will be incompatible with the latest TeamSpeak Server version. As SQLite is used by default, this is outside the scope of my tutorial and thus I will not be covering this. Here’s a free hint though: Read doc/update_mysql_to_mariadb.txt for instructions on how to update. Also note that the default character set for the database is now ‘utf8mb4’, which means the server needs to be at least MySQL 5.5.3 or MariaDB 5.5. Let’s continue :)
1) Login to your Linux server, navigate to your TeamSpeak 3 installation folder and copy the files listed above to your new Windows machine using your favorite method, i.e. flash-disk etc, to a temporary directory, for example C:\TS3Migration
Have you ever faced the problem where a legacy DOS or Windows 95 & 98 runs perfectly on Windows XP/Vista/7/8, with or without compatibility mode, but refuses to print? This is because legacy DOS or Windows 95 & 98 programs expect your printer to be connected to a LPT1 port, which is usually not the case anymore nowadays. If you want to enable printing to an USB or Network Printer for these legacy DOS or Windows 95 & 98 programs, follow these steps:
1) First, make sure you can print from within Windows to the desired printer, by printing a test page.
2) Next, go to Control Panel –> Printers All of your printers should be listed, including the printer you want to set up for DOS printing.
3) Right-Click on the name of the printer that you want to set up for DOS printing and choose “Properties” from the pop-up context menu.
4) Click on the “Ports” Tab at the top of the Printer Properties Window.
5) Make a note of the exact name of your current printer port.
6) Select the “Enable Printer Pooling” checkbox. i.e. be sure that the box is checked.
7) Scroll up and/or down through all of your listed ports and click the “LPT1” port to place a checkmark in it. Note: You should now have both LPT1 and your default printer port (from step 5) selected
8) Click “Apply” and “Ok”.
There you go! You should now be able to print from your legacy DOS/Windows 95 & 98 programs to your USB/Network printer The above steps essentially trick Windows to act as though the USB/Ethernet printer is connected to LPT1. No need to use expensive third party tools such as Printfil or DOS2USB… this will do the trick as well!
The Arcadyan VGV7519, also known as the KPN Experia Box v8, features an USB port, which can be used to turn your USB printer into a network printer. However, simply connecting your USB printer the USB port onto the router is not enough; Windows will not recognize the printer as a network printer. Instead, you have to install the printer manually, as if it was connected as a local printer. In this guide, I’ll explain how to setup your USB printer with the Arcadyan VGV7519 / Experia Box v8 and how to connect to your printer.
First, make sure your USB printer is connected to the USB port of your router and power on your printer.
Secondly, open a webbrowser and go to the web interface of your router by entering the IP address of your router into your web browser’s address bar. If you’re unsure what the IP address of your router is, try the default IP which is 192.168.2.254. If that doesn’t work, i.e. the web interface of your router does not show up, you can find it’s IP address by open the Network and Sharing Center in the Windows Control Panel; Click the name of your Internet connection, in my case Wireless Network Connection (TELUS2410).
Click the Details button to view more information about the connection.
Look for the IPv4 Default Gateway IP address in the details window. Type this IP address into your web browser’s address bar.
Type this IP address into your web browser’s address bar. The router’s web interface should now show up. Login using the administrator password, which is default either ‘admin’, ‘1234’ or blank (i.e. do not fill in anything).
Once logged in to the router’s web interface, go to Extras –> USB –> Enable USB function
Next, go to ‘Printer Server’ and check whether the Enable LPD-LPR Printer Server function is enabled. Also take note of the LPR queue name, which is ‘printer’ by default.
The web interface already reveals a little bit what we’re going to do next, as it says: “In order to do so, you need to set up a “local printer” using a “Standard TCP/IP Port” on each computer you wish to print from. The IP address of printer server is 192.168.2.254, and host name is router.” Let’s get going!
Choose Control Panel from the Start menu.
Click on Add a printer in the menu bar.
Click on Add a local printer.
Select Create a new port. Select Standard TCP/IP port from the drop-down menu and click Next.
In the Hostname or IP Address field, fill in the IP Address of your router. This is the same IP address you’ve entered earlier in your web browser to visit the web interface of your router, by default 192.168.2.254 The Port name field will automatically complete. De-select the checkbox for the Query the printer and automatically select the driver to use option and click Next.
Windows will now detect the remote host. This could take several minutes.
You will now be prompted to configure the TCP/IP port. Select Custom and click Settings… to open the configuation dialog.
Select LPR as the Protocol Provide the Queue Name from your router’s web interface, which is ‘printer’ by default. Check the LPR Byte Counting Enabled option, and make sure that SNMP Status Enabled is unchecked. Click OK.
Update your printer drivers from Microsoft by first selecting the Windows Update button before selecting a printer model. This could take several minutes.
Select the driver appropriate for the model of printer being installed. After selecting the driver from the list, click Next.
In case Windows detects that a driver is already installed for this printer, click the bullet next to Use the driver that is currently installed (recommended)
Enter a printer name that you would like to use and click Next.
Make sure the bullet is selected beside Do not share this printer
Click to put a check mark beside of Set as the default printer (if you do wish to make it your default printer)
Click Finish. Your printer should now be set up and ready to use.
The software listed below is completely free, is completely legal, and I use each of them personally. The list below is constantly updated as I find new useful software and is aimed at Windows users.
AOMEI Backupper Standard Can be used to backup individual files and folders, but also to backup partitions and complete disks as well as clone partitions and disks. Also has an option to create a boot CD to deploy backup images to bare metal in case of disaster recovery. Scheduling backups with e-mail notifications are supported as well. http://www.backup-utility.com/download.html
Macrium Reflect Free Alternative to AOMEI Backupper. The free version has more limitations than AOMEI Backupper Standard; File and Folder backup and e-mail notifications are not included in the free version. http://www.macrium.com/reflectfree.aspx
Acronis True Image Acronis True Image is perhaps the gold standard in imaging software but Acronis themselves do not offer a free version of the software. There are however, special ‘lite’ versions with stripped down functionality that are specially created for hard drive manufacturers Western Digital and Seagate. As long as you have a hard drive by one of those companies installed on your system (internal or external), you can use this ‘lite’ version of Acronis True Image for FREE. In case you own a Western Digital hard drive: http://support.wdc.com/product/downloaddetail.asp?swid=119 In case you own a Seagate hard drive: http://www.seagate.com/gb/en/support/downloads/discwizard/ If you are unsure what kind of hard drive brand you’ve installed in your computer, you can download Speccy to find out: http://www.piriform.com/speccy/download/standard
RogueKiller RogueKiller can find/remove most of the basic malwares (rogues, trojans, …) and some advanced threats like ZeroAccess or TDSS that behave more like rootkits, based on generic ways to find malwares by their behaviour (heuristics) and on classic anti-malware analysis (signature finding) http://www.adlice.com/softwares/roguekiller/
CCleaner CCleaner is a free Registry and junk-clearing utility for keeping your system clean and optimized. https://www.piriform.com/ccleaner/download/slim (Protip: Have CCleaner automatically clean your PC when it boots, so you don’t forget to do so yourself!)
MiniTool Partition Wizard Home Edition MiniTool Partition Wizard Home Edition is a comprehensive disk partition manager and includes features as Merge Partition, Move/Resize Partition, Copy Partition, Create Partition, Split Partition, Delete Partition, Format Partition, and Convert File System. http://www.minitool.com/partition-manager/partition-wizard-home.html
Ninite Installs and Updates All Your Programs at Once. It says “No” to toolbars or other junk, always installs the latest version of an app, installs the right 32-bit or 64-bit version for a PC, installs apps in the PC’s language, skips apps that are already up-to-date and upgrades an app if it’s out of date https://ninite.com/
Mail PassView Mail PassView is a small password-recovery tool that reveals the passwords and other account details for all major e-mail clients http://nirsoft.net/utils/mailpv.html
ProduKey ProduKey is a small utility that displays the ProductID and the CD-Key of Microsoft Office (Microsoft Office 2003, Microsoft Office 2007), Windows (Including Windows 7 and Windows Vista), Exchange Server, and SQL Server installed on your computer. http://www.nirsoft.net/utils/product_cd_key_viewer.html
BareTorrent A torrent client that does just that: Download torrents. No bloatware, no unnecessary features. Great alternative to uTorrent or qBittorrent. http://baretorrent.org/
TeamViewer An alternative to Microsoft’s Remote Desktop Connection (RDP). Doesn’t require any port forwarding and will work behind most, if not all, company firewalls as it uses port 80. Great tool for remote support purposes. http://www.teamviewer.com/
7-Zip 7-Zip is an excellent alternative to WinRAR/WinZip and can (un)pack just about any archive format http://www.7-zip.org/
CCCP The Combined Community Codec Pack is a simple playback pack for Windows with the goal of supporting the majority of video formats in use today. CCCP is an excellent alternative to the bloated and outdated K-Lite Codec Packs http://www.cccp-project.net/
Gixen The best free webbased eBay sniping tool! eBay Sniper
In this tutorial I am going to show you how to root your Asus Transformer TF101 or Asus Transformer Prime TF201, running the latest version of Ice Cream Sandwich (ICS), which at the time of writing is 188.8.131.52 for the TF101 and 184.108.40.206 for the Prime TF201. The only way to root your tablet running 220.127.116.11 or 18.104.22.168 WITHOUT unlocking your bootloader, is to downgrade to an older firmware version, get root, upgrade back to the latest firmware version available and restore our root access using OTA Root Keeper. The benefit of this method is that you will not void your warranty, as your bootloader will remain locked. This whole process will take about 30 minutes to complete and will keep your data intact. I created this tutorial all by myself after I successfully rooted my Transformer Prime TF201 running 22.214.171.124 and a Transformer TF101 of a friend of mine running 126.96.36.199.
Rooting (and downgrading) is a complicated process. I’ve tried to make this tutorial as easy to follow as possible. It contains lots of screenshots, which are in Dutch (Nederlands) by the way, but I also assume you have basic computer knowledge. If you don’t even know what ‘rooting’ is, then this is not for you! In this tutorial I will be rooting my Transformer Prime TF201, but the process for the Transformer TF101 is exactly the same. Just make sure you don’t mix up the firmware numbers. I also would like to point out that I am not responsible for any possible damage that this process may cause to your tablet. Downgrading and rooting Android devices is highly experimental and may turn your device into worthless brick. Proceed at your own risk!! Last but not least: English is not my first language, so please excuse any spelling errors I’ve made below.
-Make sure your Transformer is FULLY Charged -Make sure your Transformer is NOT Docked -Make sure your Transformer’s bootloader is LOCKED, i.e. you are NOT running a custom ROM or have ClockworkMod flashed. -Make sure your firmware build number is equal to 188.8.131.52 if you have a Transformer TF101 or 184.108.40.206 if you have a Transformer Prime TF201 -Only use the ORIGINAL USB Cable, WITHOUT any USB extension cables -Take your time, don’t rush things and be patient. -Follow the instructions precisely and all will be OK!
Preparation: Backup Apps&Data
Let’s start by making a backup of our apps and data in case something goes wrong. Open up the Asus Back-up app. Accept the Terms of Agreement and click on ‘Start’.
In the right upper corner select ‘Data & Application’ as ‘Back-uptype’, click ‘Select all’ and click ‘Back-up’. The time it takes before the backup finishes depends on the amount of apps you have installed on your tablet. Just be patient.
Preparation: Download & Copy older firmware
Before we continue, we need to verify which exact firmware version our Transformer tablet is running. To do so go into ‘Settings’ –> ‘About Tablet’ and scroll down until the ‘Build- number’ appears, like so:
As you can see, my tablet is running the latest version of ICS available, which at the time of writing is 220.127.116.11 for the Prime TF201. But also note the ‘WW’ in front of the number, which means ‘WorldWide’. This is important because Asus releases different types of firmware versions for different countries. For example, Transformer tablets in the USA will have an ‘US’ prefix instead of the ‘WW’ prefix. When downgrading (or flashing a new ROM onto) your tablet, it is very important to make sure you have the correct corresponding firmware type. In other words: Do NOT flash a ‘US’ type firmware on your tablet if it originally was a ‘WW’ type tablet.This WILL cause problems!
Now that we know which firmware type our tablet has, in my case that’s ‘WW’, we need to download an older firmware for our tablet to be able to gain root access. This is needed because the latest firmware version we’re running (18.104.22.168) does not contain any exploits that we can use to gain root access directly. This is because Asus patches those exploits with every firmware update they release. However, older firmware versions do contain exploits to gain root access and thus we need to downgrade to one of those older firmware versions first before we can gain root access. If you have an Transformer TF101, I recommend downloading firmware version 22.214.171.124, which can be found here: WWversion: https://freek.ws/transformer/TF101/WW_epad-user-126.96.36.199.zip USversion: https://freek.ws/transformer/TF101/US_epad-user-188.8.131.52.zip Again, make sure to download the correct corresponding firmware type for your tablet, as explained above!
After you’ve downloaded the corresponding older firmware version for your tablet, you’ll end up with a .zip file. Unzip the .zip file, which will leave you with a ‘META-INF’ folder and a ‘blob’ file. You can delete the ‘META-INF’ folder; we only need the ‘blob’ file.
Connect your Transformer tablet to your computer using the original USB cable and copy the ‘blob’ file into the root of the INTERNAL STORAGE of your Tranformer (NOT the SDCard), like so:
Preparation: Change tablet settings
Before we can downgrade our tablet, we need to change some settings in our tablet. Before you continue, please disconnect the tablet from your computer! On your tablet, go to Settings –> Developer Options –> Click OK at the message that pops up –> place a checkmark at ‘USB debugging’ –> Click OK at the message that pops up. Also go to Settings –> Security –> place a check mark at ‘Unknown Sources’ –> Click OK at the message that pops up. Lastly, go to Settings –> Accounts & Synchronization –> Uncheck (remove) the check mark at ‘Start Asus Sync’.
Download ‘Downgrade Tool’
We now need to download a tool which will downgrade the firmware for us. This tool is no more than an automated version of a downgrade exploit invented by Wolf849 (1) and can be found here: https://www.freek.ws/downgrade_tool (2)
Once downloaded, you will end up with another .ZIP file. Again unzip this file and you’ll end up with a bunch of files. This .ZIP file also contains the Drivers we need to use in the next step!
Preparation: Install Drivers
Now connect your tablet to your computer again, using the original USB cable. Windows now probably will l complain a ‘Device driver software was not successfully installed’ in the right bottom corner of your screen.
To solve this, go ‘Start’, right click on ‘Computer’ –> ’Properties’.
In the new screen that pops-up (assuming that you’re running Windows 7) click on ‘Device Manager’, in the left upper corner.
You will now see a device called ‘Asus Android Composite ADB Interface’ listed under ‘Other devices’ with a yellow exclamation mark. Right click on it and select ‘Update driver’.
In the new screen that pops-up, select ‘Browse my computer for driver software’.
In the next screen, browse to the ..\Drivers\Android folder which was included in the .zip file you’ve downloaded above and click ‘Next’.
Your computer should now install the correct drivers for your tablet. If all went well, you should see this screen:
Click ‘Close’ and check if the ‘Asus Android Composite ADB Interface’ is now listed under ‘Asus Android Devices’ instead of ‘Other devices’, like so:
Preparation: Kill unwanted apps
Before we can downgrade, we need to make sure the apps ‘Asus Sync’ and ‘Splashtop Remote’ are not running. To do so (do NOT disconnect your tablet from your computer!) on your tablet go to Settings –> Apps –> All –> Search for ‘com.asus.pcsynclauncher’ and ‘Splashtop Remote’. Make sure to ‘Force stop’ both apps. To do so, click on them and press ‘Force stop’.
After Force stopping, the ‘force stop’ button will be greyed out which means the app is no longer running in the background.
We are now finally ready to downgrade our tablet. Open (by double clicking) ‘viperMOD Primer Tool v4.5 – Modded by bpear_v3.exe’ . You will see this screen: We need option 1, so press 1 on your keyboard and hit the Enter button to continue. NOTE: Although it says ‘Downgrade unrooted US Prime to .15’, this also works for WW Prime and also for US and WW TFT101. Don’t worry :)
You’ll get this screen: Hit the Enter button to continue. You’ll get this screen: Once again, hit the Enter button to continue. The downgrade process will now begin. DO NOT DISCONNECT YOUR TABLET FROM YOUR COMPUTER DURING THIS PROCESS! Disconnecting your tablet during the downgrade or rooting process can break your tablet and turn it into a unless (but very expensive) brick!
If all goes according to plan your tablet will reboot first, then the older firmware we’ve copied earlier (the ‘blob’ file) will be copied to the correct system folders (this can take up to 10 minutes, BE PATIENT!!) and then your tablet will reboot once again running the older firmware. While rebooting, the tablet will stop for a while displaying the Asus EEE Logo with a progress bar; Don’t worry – the bar will move in 1 minute or so. Just be patient! If the downgrading process has finished, you’ll see this screen: Hit the Enter button, followed by pressing 8 and hitting the Enter button to exit.
To verify if your tablet has indeed been downgraded successfully, go into Settings à About tablet and verify the ‘Build-number’. It should say ‘184.108.40.206’ if you have a Transformer TF101 or ‘220.127.116.11’ if you have a Transformer Prime TF201, like so: If that’s the case, we can proceed by rooting our tablet. If not, then you’ve done something wrong. Please start from the beginning and make sure you exactly follow each and every step precisely.
You’ll end up with another .zip file. Again unzip this .zip file somewhere and you’ll end up again with a bunch of files and folders.
Before we can root our tablet, we need to make sure again that the apps ‘Asus Sync’ and ‘Splashtop Remote’ are NOT running. Please see above on how to do this.
We now can finally root our tablet. Open (by double clicking) ‘viperMOD PrimeTime v4.5.exe’ . You will see this screen: We need option 1, so press 1 on your keyboard and hit the Enter button to continue. NOTE: Although it says ‘Root (only method for Prime on ICS v9.x.x.11)’, this also works for the Asus Transformer TF101 running 18.104.22.168 and Transformer Prime TF201 running 22.214.171.124. Don’t worry :) However, whatever you do, do NOT flash recovery if you’re NOT on a Prime. That option is ONLY for Prime TF201!!
Let’s continue. You’ll now get this screen: Hit the Enter button to continue.
You’ll get this screen: Once again, hit the Enter button to continue. The rooting process will now begin. Once again, DO NOT DISCONNECT YOUR TABLET FROM YOUR COMPUTER DURING THIS PROCESS!
If all goes according to plan some files will be transferred to your tablet first, the exploit will be used to gain root access and BusyBox will be installed. Finally your tablet will reboo and once rebooted it will be rooted! If the rooting process has finished, you’ll see this screen:
Hit the Enter button, followed by pressing 7 and hitting the Enter button to exit.
Protect Root with OTA RootKeeper
To verify that your tablet has indeed been rooted, go into the market, download ‘OTA RootKeeper’ and open it. On opening, a SuperUser prompt will popup asking if ‘OTA RootKeeper’ is allowed to get root permissions. Hit ‘Allow’ If correctly, OTA RootKeeper will confirm that your device is rooted: Now before we continue, it is important that we protect our root access. Like I said before, with every new firmware update Asus releases, they patch any exploits which will gain us root access. So to make sure we can safely upgrade to a newer firmware version (in our case 126.96.36.199 or 188.8.131.52), we need to protect our root access BEFORE upgrading. If you don’t do this, you will lose your root access and you can start all over again. I hope you understand the importance of this app, so whatever you do, DO NOT UNINSTALL OTA ROOTKEEPER! To protect your root access, press the ‘Protect root’ button in OTA RootKeeper. It’ll take just a few seconds. Once it has finished protecting our root access, you should see this:
Upgrade to latest firmware
Now we’re ready to upgrade back to the latest firmware available, in our case 184.108.40.206 for the TF101 or 220.127.116.11 for the Prime TF201 To do so, on your tablet, go to ‘Settings’ –> ‘About tablet’ –> ‘Update systemfirmware’. It should now say a new update is available and start downloading it. If it doesn’t say there’s an update available, just wait a couple of hours and try again. It should show up eventually. If still doesn’t show up after 24 hours, make sure you flashed the correct version of firmware (ie. WW if your tablet is a WW version). You can check the download progress in the notification area, in the right down corner of your tablet. If it has finished downloading, a notification will be placed in the notification area, in the right down corner of your tablet. Click on it and this screen will appear: Now hit Install and your tablet will upgrade to the latest firmware as it normally would do.
Restore Root using OTA RootKeeper
Finally, once the upgrade has finished, open OTA RootKeeper and restore your root access.
Congratulations! You’ve now successfully rooted your Transformer TF101 or Transformer Prime TF201 tablet, running the latest available firmware (18.104.22.168 or 22.214.171.124)! That wasn’t so hard, was it ;) ?