Look under Advanced Options to setup TS as an external database.

Not sure what I'm doing wrong here, but I added this to the bottom of the server.ini file and of course, edited the necessary fields.

[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=database_name
Hostname=localhost
User_name=database_username
Password=database_password
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmy.so
Active=1


Now, I get this:

root@server [/home/teamspeak/public_html/tss2_rc2]# ./teamspeak2-server_startscript start
WARNING ! For security reasons we advise: DO NOT RUN THE SERVER AS ROOT
!!!!!!!!!!!
starting the teamspeak2 server
Error starting daemon. Aborted


Even if I try to run as teamspeak user, I get this:

teamspeak@server [~/public_html/tss2_rc2]# ./teamspeak2-server_startscript start
starting the teamspeak2 server
Error starting daemon. Aborted


My permissions

Chadi check the server.log file. The error is logged there

sorry forgot about that


24-08-07 23:16:41,ALL,Info,server, Server init initialized
24-08-07 23:16:41,ALL,Info,server, Server version: 2.0.23.19 Linux
24-08-07 23:16:41,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load ./libmysqld.a
24-08-07 23:16:41,ERROR,All,SERVER, Start_Server: unable to open database



This is what I have (with orange actual info, which I know is correct)

Your problem has nothing to do with this hack at all.
You simply have problems connecting to the mysql database.
Even without this hack you would have the problem

The library cannot be loaded!

This is what I have
The library you have to load depends on the operating system and the mysql version you're running!

Fix this first before trying to use this hack!

I cannot find any download for libsqlmy.so via Google.

Like I said, this has nothing to do with this hack. Please check out www.goteamspeak.com

Thank you for helping out jluerken, you have answered these questions better than I could have.

I rent a teamspeak from a hosting company. Will this mod work with the remote ts?

Yes you can enter a remote ServerIP but your Teamspeak Host needs two things:

1. TS must be installed in a mysql database. Normally hosters do not do so, they use the standard sqllite.
2. The remote TS must allow TCP Query. This should be working but some TS Hosters disable this with a firewall for whatevery reason.

btw. with vB 3.5 we got the product installation feature so before asking if a product will work for you or not, simply make a db backup, install and and test it. If its not working remove the product with a single click again.

I did not use a firewall on the remote TS/MySQL database, yet the TCP queries apparently just did not get through (this was using a Linux version of the server, which was tested and shown to be working). Mystified. Worse yet, when trying to run Teamspeak on this remote Windows 2000 Server installation, upon attempting to start the TS server, I see the tray icon appear for a split second, then it disappears and the TS server will not load. I looked for an error log but it does not even generate one so I can't find out what the trouble is. When I change the server.ini file back to using SQLite, the TS server starts normally. My MySQL database and permissions, and file permissions are all "grant all" for the MySQL database user, the database itself works fine by itself. I'm getting aggravated with Teamspeak already, I cannot believe these flaws have not been fixed after so many years of TS being in existence now. Please help!!!! :eek::eek::eek::eek::(

This has nothing to do with this hack. You should ask for support at www.goteamspeak.com

Linux:
Accessing the mysql remotely has most of the times nothing to do with the rights for a db.
You should check you "skip-networking" variable in your my.cnf (/etc/my.cnf).
Change it to "#skip-networking" and restart the mysql server.

Windows:
I've never tested a mysql and ts2 installation on windows and do not see a need for doing so but
it could be the same issue like described above.

If you have >= Mysql 4.1 you MUST change the password hashing for the TS database to the old format
cause the ts libraries cannot use the new one.

i become this error:

Sure you get it cause you use the wrong statements. Check out this

http://forum.goteamspeak.com/showthr...&highlight=4.1

i have changed the entries but i become the same error...

this error comes when i filled out the password field

sorry for my bad english :D



the first person who has entered a password he becomes the "i_client_id" "0"

every other persons become the same id and this is the duplicate

i have found the error....

for field "i_client_id" must activate "auto_increment"

it works

but is this correct for all other functions?

This is correct. Auto increment is ok

I really would appreciate someone helping me to get TS at least installed right. Its been a nightmare.
---------------------------------------------------------------
-------------- log started at 30-08-07 14:58 -------------
---------------------------------------------------------------
30-08-07 14:58:54,ALL,Info,server, Server init initialized
30-08-07 14:58:54,ALL,Info,server, Server version: 2.0.23.19 Linux
30-08-07 14:58:54,ERROR,All,SERVER, VirtualServer Startup(1) Exception: EDatabaseError.dbExpress Error: Operation Not Supported
30-08-07 14:58:54,ALL,Info,server, Server init finished
30-08-07 14:58:54,ERROR,Info,server, Unable to createpid file, stopping daemon
30-08-07 14:58:54,ALL,Info,server, Server shutdown initialized
30-08-07 14:58:54,ALL,Info,server, Stopping VirtualServer id:0 with port:8767
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 30-08-07 14:59 --------------
---------------------------------------------------------------

File: read_servers.sql

SELECT * FROM ts2_servers WHERE i_server_id > 0;

I tried starting it in root user mode, it works just not in teamspeak user mode

chadi this is a vbhacks site. for teamspeak support visit www.goteamspeak.com

I can't get teamspeak to start after making these changes. if I remove it from the .ini it starts up again. .log is showing that it is failing on

-------------- log started at 29-09-07 13:15 -------------
---------------------------------------------------------------
29-09-07 13:15:11,ALL,Info,server, Server init initialized
29-09-07 13:15:11,ALL,Info,server, Server version: 2.0.23.19 Linux
29-09-07 13:15:11,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load /usr/lib/libmysqlclient$
29-09-07 13:15:11,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 29-09-07 13:15 --------------
---------------------------------------------------------------

I have both the % wildcard and the IP to my shell server which houses my TS and IRC server in cPanel of the server that houses my vB forum.

I'm assuming using libmysqlclient_r.so.14.0.0 is ok as that is what is in my /usr/lib there is no 10.0.0 in the folder.

I downloaded 10.0.0 and now that loads. But it is still failing. Now I receive DatabaseError.dbExpress Error: Invalid Username/Password but the .ini settings
are the same as my vbulletin config file.

for anyone who doesn't have 10.0.0 on your server..

Hi Gryphon,

I am using your hack now for a few month and its great.
I found out that people register to use the teamspeak, but never write a forum thread/post.

It would be nice to add a feature to this hack that checks this.

Example:
Group A must have X threads/posts within Y days.
If a user tries to connect to the teamspeak server the hack should check if the set minimum thread/post value for the set timeframe is reached and allow/disallow access.

Do you think you can integrate this?

Which MySQL Version do you have?
If 4.1x or higher pls. check that you set the old password hashing method for the teamspeak database cause the teamspeak libraries cannot handle the new system.

How do you do that? Yes, I'm using 4.1.22

Options added.

If you get an error about client authentication version when connecting to MySQL then it may be because your server is using the new
password format, while your mysql client (or PHP script, or JDBC code) is using the old password format. See: http://dev.mysql.com
/doc/mysql/en/Application_password_use.html.

You can change a new password to an old password like this:
bash shell>mysql -u root -p
passwort: rootpw

mysql> USE mysql
mysql> update user set password = old_password('passwordhere') where user = 'teamspeak'; flush privileges;
Query OK, 1 row affected (0.04 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select user, password from user;
+-------+-------------------------------------------+
| user | password |
+-------+-------------------------------------------+
| root | *BA3E2F47E409A6ABA83D219D70631A02FE28539E |
| root | *BA3E2F47E409A6ABA83D219D70631A02FE28539E |
| | |
| | |
| teamspeak | 09a6e3834c6d11c9 |
+-------+-------------------------------------------+
5 rows in set (0.00 sec)


In this case root has a new, longer password. While the teamspeak user has the shorter, old password format. In PHP something like mys
ql_connect('localhost', 'teamspeak', 'passwordhere') should now successfully create a connection.

Replace "teamspeak" with the user you start your teamspeak server with.

Attention:

1. Never use ROOT to start your teamspeak server
2. Always update teamspeak with the latest server library
3. This is basic teamspeak knowledge and has nothing to do with this hack.
4. Don't forget to change some .sql statement if you use teamspeak with mysql instead of the sqllite system, otherwise it will not work

Get your teamspeak running before you install this hack!

Great news, thanks.
I will test the update later on and give you Feedback gryphon

vBulletin also has tools which could have been used as well to manipulate access control without these added options. By creating a usergroup which has access to the teamspeak signup and then create a usergroup promotion with the post/reputation/days registered ect. to promote them to that usergroup.

But it was only 10 lines of code I had already done for another project so it was a simple update ;)

No its not the same. Promoting a user if he has for example 30 posts is something different than checking if the user has written 30 posts within the last X days.
Thats what I was looking for.

Not check the post amount but check the post amount for the last x days :D

Did you get it now? Sorry that I did not describe it better in my initial posting

I see, what I added will not do that. I may look into doing what you are asking, however I am unsure how soon I can do that.

Nice plugin!

But why is it that you need it to switch to MySQL? o_O

It should be possible to do all this via the TCP interface.

Not sure if I have made an install mistake but I cannot access this and do not see the Navbar entry? I have selected the Navbar and quick link entry but neither show. If I add the gteamspeak.php path manually I get a message that I am not authorised to view this,,,

Any help?

The navbar and quicklink entries are style dependant, if there are any modifications to the style they probably won't get added properly.

When going to gteamspeak.php and you get the message that you are not authorized to view, you need to setup the usergroup access permissions and custom profilefield, though, admin should be enabled by default.

There isn't really much I can do to help without knowing how your board is setup or what you did to setup the mod, just make sure you go over all instructions and settings carefully, this mod isn't plug n' play, it takes some setup time.

Hi Gryphon,

Great mod but I'm having the PHP 5 / MySQL 5 compatability issue where you enter your password to create the account but it just refreshes the screen and never proceeds (and doesn't create the table entry)

I have Teamspeak working just dandy on SQL and so I know that's not the problem so I'm wondering if it's a PHP compatability issue. Any chance you can point me at where the user creation section of the script is, I'm going to have a crack at fixing it but am having a blonde moment and can't see it.

Cheers,

Iratus

Hi Iratus,

can you please do the following?
Empty the server.log file, start your server and try to manage it via this mod.
Wait for the error and then post the content of your server.log file here?

/jluerken

It isn't erroring in the TS log, that's what's making me think that it's some type of PHP error, IE it's never getting as far as the SQL

and just for congruity to show I'm hooking into sql properly

Just for reference

PHP Version 5.2.3
Apache 2.2.3
MySQL 5.0.27
(So typical of Linux that staying on top of security updates has screwed me :) )

I was taking Gryphons advice that he wouldn't support it to a seperate database so I could have a problem with the connection but as it uses the same login details as TS itself I can't see where the problem is. Shall I just try connecting it to my VBulletin Database and creating the tables there and see if that works? I was trying to avoid it because I'd have to do the password compatibility change on the VBulletin dba account.

I am not positive of the differences in PHP 4/5 and MySQL 4/5 so unfortunately I can not help much in that regard. I am unsure why this would be happening and it will require that someone who does know help answer this and I will implement a possible compatibility fix if needed.

In installed this on my TS server that was allready running a Mysqldb, and it works like a charm! thanks for the great mod!

Ohw, and I am using php5/mysql5, and found no errors what so ever

Will this hack work if I'm connecting to MYSQL using dbxODBC instead of dbxmda which costs 70-150 bucks. My 30 days just ran out and I see on goteamspeak they have alternative methods of connecting TS to MySQL using odbc.

Thanks,
xTerMn8R
www.superskunkracing.org