Howto: TeamSpeak 3 server in pfSense 2.x(Now with scripts amd64) v1.3

opjohnny

Log never spit out the privilege key.

After rebooting 3 logs were produced. They are…


#2```
2015-01-15 00:14:38.024153|INFO    |ServerLibPriv |   | TeamSpeak 3 Server  (1970-01-01 00:00:00)
2015-01-15 00:14:38.032010|INFO    |ServerLibPriv |   | SystemInformation: FreeBSD 8.3-RELEASE-p16 FreeBSD 8.3-RELEASE-p16 #0: Mon Aug 25 08:25:41 EDT 2014     root@pf2_1_1_i386.pfsense.org:/usr/obj.i386/usr/pfSensesrc/src/sys/pfSense_SMP.8 i386 Binary: 32bit
2015-01-15 00:14:38.097830|INFO    |DatabaseQuery |   | dbPlugin name:    SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
2015-01-15 00:14:38.099106|INFO    |DatabaseQuery |   | dbPlugin version: 3.6.21
2015-01-15 00:14:38.124190|INFO    |DatabaseQuery |   | checking database integrity (may take a while)
2015-01-15 00:14:38.251693|CRITICAL|DatabaseQuery |   | setSQLfromFile( file:sql/update_1.sql) failed


I tried connecting from my main rig(behind pfSense) using the LAN IP of my pfSense box, and also the DNS have pointed to my external IP to make people's lives easier when they connect to my TS3 server.

At this point I realized I needed to fix my TS port forwards because they were resolving to my main rig's LAN IP.  Changed that to my pfSense LAN IP.

I figured since I did that, and since those 3 logs didn't produce they key, I might as well stop/start the TS server.  I tried `/usr/local/etc/rc.d/teamspeak3-server stop` which produced…

$ /usr/local/etc/rc.d/teamspeak3-server stop
/usr/local/etc/rc.d/teamspeak3-server: WARNING: $teamspeak3_enable is not set properly - see rc.conf(5).
Cannot 'stop' teamspeak3. Set teamspeak3_enable to YES in /etc/rc.conf or use 'onestop' instead of 'stop'.


So I replaced "stop" with "onestop" which seems to have done the trick.  I then tried the start command and got a similar error, corrected it to onestart.  This produced a fourth log…

#4```
2015-01-15 00:21:22.625060|INFO    |ServerLibPriv |   | TeamSpeak 3 Server  (1970-01-01 00:00:00)
2015-01-15 00:21:22.636595|INFO    |ServerLibPriv |   | SystemInformation: FreeBSD 8.3-RELEASE-p16 FreeBSD 8.3-RELEASE-p16 #0: Mon Aug 25 08:25:41 EDT 2014     root@pf2_1_1_i386.pfsense.org:/usr/obj.i386/usr/pfSensesrc/src/sys/pfSense_SMP.8 i386 Binary: 32bit
2015-01-15 00:21:22.643734|INFO    |DatabaseQuery |   | dbPlugin name:    SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
2015-01-15 00:21:22.644223|INFO    |DatabaseQuery |   | dbPlugin version: 3.6.21
2015-01-15 00:21:22.647119|INFO    |DatabaseQuery |   | checking database integrity (may take a while)
2015-01-15 00:21:22.778871|CRITICAL|DatabaseQuery |   | setSQLfromFile( file:sql/update_1.sql) failed

Did I do something wrong? Followed the guide step-by-step making sure I was typing in all commands correctly. I did steps 1 through 4 via webGUI command, then switched over to puTTy/SSH because I had to perform that install command from /root/. Then I rebooted. This is on a full install, version details are…

2.1.5-RELEASE (i386)
built on Mon Aug 25 07:44:26 EDT 2014
FreeBSD 8.3-RELEASE-p16

And just for good measure, here is the install log…

Checking for required files...
All required files have been found in /root
Archive Extracting...
Extraction completed successfully!

Moving pfsense to /usr/local/lib/ ...
Move completed successfully!

Creating "teamspeak" user...
Created user successfully!

Moving script "ts3server.sh" to /usr/local/lib/teamspeak3-server_freebsd-x86
Moving completed successfully!

Setting permissions on /usr/local/lib/teamspeak3-server_freebsd-x86
Permissions successful!

Setting permissions on /usr/local/lib/teamspeak3-server_freebsd-x86/ts3server.sh
Permissions successful!

Moving script "teamspeak3-server" to /usr/local/etc/rc.d/
Moving completed successful!

Setting permissions on /usr/local/etc/rc.d/teamspeak3-server
Permissions successful!

Moving script "run_teamspeak3-server.sh" to /usr/local/etc/rc.d/
Moving completed successful!

Setting permissions on /usr/local/etc/rc.d/run_teamspeak3-server.sh
Permissions successful!

Backing up original system file /etc/rc.reboot
Backup successful!

Editing /etc/rc./reboot
Editing completed successfully!

Backing up original system file /etc/rc.shutdown
Backup successful!

Editing /etc/rc./shutdown
Editing completed successfully!

After checking the output for errors remember to reboot!

ETA: One of your four files doesn't have a file extension. Is this intentional? It's the "teamspeak3-server" file.

ETA1: There's also this in case you were wanting to see it…

$ ps aux|grep team
root   41709  0.0  0.3  3468  1280  ??  S     6:42PM   0:00.00 grep team

ETA2: The "start" and "stop" commands are working normally now. No "add one-" errors. Weird. Logs are still spitting out the same, ending with that critical SQL error.

tong

ps aux|grep team

Gives this result:

root 81623 0.0 0.0 9068 1468 u0 S+ 6:39PM 0:00.00 grep team

Still no log folder however. And I'm beating my head on the firewall rule… Not sure i have it 100% right!

Btw, did this fresh on a new install, followed all the directions to a T.

Might be just me and my inexperience so far.

opjohnny

@tong:

ps aux|grep team

Gives this result:

root 81623 0.0 0.0 9068 1468 u0 S+ 6:39PM 0:00.00 grep team

Still no log folder however. And I'm beating my head on the firewall rule… Not sure i have it 100% right!

Btw, did this fresh on a new install, followed all the directions to a T.

Might be just me and my inexperience so far.

Are you sure you're checking the /usr/local/lib/teamspeak3-server_freebsd-x86/logs/ directory?

In the webGUI go to Diagnostics > Edit File. Click Browse to view folder list. Single-left-click usr, then local, then lib, then teamspeak3-server_freebsd-x86, then logs. Are you not seeing the /teamspeak3-server_freebsd-x86/ folder in /usr/local/lib/?

tong

@opjohnny:

Are you sure you're checking the /usr/local/lib/teamspeak3-server_freebsd-x86/logs/ directory?

In the webGUI go to Diagnostics > Edit File. Click Browse to view folder list. Single-left-click usr, then local, then lib, then teamspeak3-server_freebsd-x86, then logs. Are you not seeing the /teamspeak3-server_freebsd-x86/ folder in /usr/local/lib/?

Yup, no log folder exists. Directory structure stops at /teamspeak3-server_freebsd-x86/, inside I have 5 folders: doc, redist, serverquerydocs, sql, tsdns. There's 9 files also but no log folder.

opjohnny

@tong:

Yup, no log folder exists. Directory structure stops at /teamspeak3-server_freebsd-x86/, inside I have 5 folders: doc, redist, serverquerydocs, sql, tsdns. There's 9 files also but no log folder.

When you first run the command to install TS3 server it spits out a log via cmd prompt. Did you check to see every step was successful? Did you reboot pfSense after that?

Beyond that I'm out of ideas. I'm still trying to figure out why I'm getting that SQL error which I think is not only keeping it from spitting out my key, but also keeping the server from starting/running properly. I think it has something to do with TS thinking there is an update when there isn't one, according to a google search of that specific error.

tong

@opjohnny:

When you first run the command to install TS3 server it spits out a log via cmd prompt. Did you check to see every step was successful? Did you reboot pfSense after that?

Beyond that I'm out of ideas. I'm still trying to figure out why I'm getting that SQL error which I think is not only keeping it from spitting out my key, but also keeping the server from starting/running properly. I think it has something to do with TS thinking there is an update when there isn't one, according to a google search of that specific error.

Remove or Install?
Enter I/i for Install. R/r for Remove.i
Install

Checking for required files...
All required files have been found in /root
Archive Extracting...
Extraction completed successfully!

Moving pfsense to /usr/local/lib/ ...
Move completed successfully!

Creating "teamspeak" user...
Created user successfully!

Moving script "ts3server.sh" to /usr/local/lib/teamspeak3-server_freebsd-x86
Moving completed successfully!

Setting permissions on /usr/local/lib/teamspeak3-server_freebsd-x86
Permissions successful!

Setting permissions on /usr/local/lib/teamspeak3-server_freebsd-x86/ts3server.sh
Permissions successful!

Moving script "teamspeak3-server" to /usr/local/etc/rc.d/
Moving completed successful!

Setting permissions on /usr/local/etc/rc.d/teamspeak3-server
Permissions successful!

Moving script "run_teamspeak3-server.sh" to /usr/local/etc/rc.d/
Moving completed successful!

Setting permissions on /usr/local/etc/rc.d/run_teamspeak3-server.sh
Permissions successful!

Backing up original system file /etc/rc.reboot
Backup successful!

Editing /etc/rc./reboot
Editing completed successfully!

Backing up original system file /etc/rc.shutdown
Backup successful!

Editing /etc/rc./shutdown
Editing completed successfully!

After checking the output for errors remember to reboot!

There you go, no Log folder

tong

pfSense 2.1.5-RELEASE-pfSense (amd64)

Does it matter if I'm using the 64bit ? Could that be my problem?

kevev

I fixed the issue in the old scripts.

Be sure to uninstall the old version with the 1.0 script using the Removel option before uploading and installing from the new 1.1 scripts!

Let me know if the new version works or has issues. :)

tong

@kevev:

I fixed the issue in the old scripts.

Be sure to uninstall the old version with the 1.0 script using the Removel option before uploading and installing from the new 1.1 scripts!

Let me know if the new version works or has issues. :)

Thanks kevev, but I'm still at stuck at the same issue, no log folder. Only thing i can think of is that I'm using the 64bit version of pfsense.

Did it on a brand new fresh install just in case too. Still no dice.

kevev

That's not good. Try it on a 32bit system or wait till I post the 64bit install scripts.

@tong:

@kevev:

I fixed the issue in the old scripts.

Be sure to uninstall the old version with the 1.0 script using the Removel option before uploading and installing from the new 1.1 scripts!

Let me know if the new version works or has issues. :)

Thanks kevev, but I'm still at stuck at the same issue, no log folder. Only thing i can think of is that I'm using the 64bit version of pfsense.

Did it on a brand new fresh install just in case too. Still no dice.

tong

@kevev:

That's not good. Try it on a 32bit system or wait till I post the 64bit install scripts.

I'll wait, it will give me time to play with this box and learn stuff that i need to know on how to use it.

opjohnny

Just got home from work. I'll run the 1.0 script uninstall/1.1 script install and report back with my findings.

opjohnny

I ran the uninstall but still see the following in /root/….

pfsense-teamspeak-install.sh

run_teamspeak3-server.sh

teamspeak3-server

teamspeak3-server_freebsd-x86-3.0.11.2.tar.gz

ts3server.sh

Am I supposed to delete those before doing the new script install?

Also, do I re-follow all steps in the first post for the new script install?

opjohnny

Deleted all those TS related files from /root/ except the official archive. Uploaded script files to /root/. Ran installer script via puTTy. Output…

Checking for required files...
All required files have been found in /root
Archive Extracting...
Extraction completed successfully!

Moving pfsense to /usr/local/lib/ ...
Move completed successfully!

Creating "teamspeak" user...
Created user successfully!

Setting permissions on /usr/local/lib/teamspeak3-server_freebsd-x86
Permissions successful!

Moving script "teamspeak3-server.sh" to /usr/local/etc/rc.d/
Moving completed successful!

Setting permissions on /usr/local/etc/rc.d/teamspeak3-server.sh
Permissions successful!

Moving script "rc.conf.local" to /etc/
Moving completed successful!

Setting permissions on /etc/rc.conf.local
Permissions successful!

No reboot reminder, not sure if that was intentional.

Rebooted, changed port forwards to resolve to my pfsense IP instead of my rig's IP.

Checked logs, noticed log sizes I didn't see before. First log had a bunch of info, no issues that I could see. Second log had…a token! Logged in to my server via the LAN IP of my pfSense box and authenticated as admin. Hooray!

Kevev - You are extremely awesome for taking the time to do this. You really saved my ass here, and now I can finally turn my main rig off / stop temporarily hosting my gaming community's ts3. 8)

kevev

Awesome dude. Glad someone got it working. I will update the script to remind users to reboot.

@opjohnny:

Deleted all those TS related files from /root/ except the official archive. Uploaded script files to /root/. Ran installer script via puTTy. Output…
Checking for required files...
All required files have been found in /root
Archive Extracting...
Extraction completed successfully!

Moving pfsense to /usr/local/lib/ ...
Move completed successfully!

Creating "teamspeak" user...
Created user successfully!

Setting permissions on /usr/local/lib/teamspeak3-server_freebsd-x86
Permissions successful!

Moving script "teamspeak3-server.sh" to /usr/local/etc/rc.d/
Moving completed successful!

Setting permissions on /usr/local/etc/rc.d/teamspeak3-server.sh
Permissions successful!

Moving script "rc.conf.local" to /etc/
Moving completed successful!

Setting permissions on /etc/rc.conf.local
Permissions successful!
No reboot reminder, not sure if that was intentional.

Rebooted, changed port forwards to resolve to my pfsense IP instead of my rig's IP.

Checked logs, noticed log sizes I didn't see before. First log had a bunch of info, no issues that I could see. Second log had…a token! Logged in to my server via the LAN IP of my pfSense box and authenticated as admin. Hooray!

Kevev - You are extremely awesome for taking the time to do this. You really saved my ass here, and now I can finally turn my main rig off / stop temporarily hosting my gaming community's ts3. 8)

kevev

I added a 64bit version.

I also updated the x86 version to correct some spelling mistakes and added a reboot reminder. ;)

Let me know if there are issues.

tong

@kevev:

I added a 64bit version.

I also updated the x86 version to correct some spelling mistakes and added a reboot reminder. ;)

Let me know if there are issues.

Can't wait to get home and try the 64bit out… Anything else you want me to try out while this box is still a virgin and not in "production" use?

kevev

I have a cups printing tutorial you can try out. :)

I may write scripts for that one too if there is interest.

@tong:

Can't wait to get home and try the 64bit out… Anything else you want me to try out while this box is still a virgin and not in "production" use?

tong

@kevev:

I have a cups printing tutorial you can try out. :)

I may write scripts for that one too if there is interest.

I can test out to see if it installs and that portion of it, I won't be able to test out is use unfortunately…

How about one for mumble (teamspeak alternative)? Might be a popular option for those that want more users but on the same type of VoIP thing?

tong

@kevev:

I added a 64bit version.

I also updated the x86 version to correct some spelling mistakes and added a reboot reminder. ;)

Let me know if there are issues.

Complete success. Everything went smooth on 64bit as instructed.

Kevev, can you change this:

4.) Run the install script for your architecture

pfsense-teamspeak-install_x86.sh

or

pfsense-teamspeak-install_amd64.sh

to this:

4.) Run the install script for your architecture

./pfsense-teamspeak-install_x86.sh

or

./pfsense-teamspeak-install_amd64.sh

I was beating myself over the head trying to remember the ./ for the install. Like I said I'm a complete newb at this; but by following your directions, it's installed, and running, sweet.

Thank you very much, I hope this helps someone else too.