vb.org Archive - Integration with vBulletin - gTeamSpeak

Page 18 of 33

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Integration with vBulletin - gTeamSpeak - TeamSpeak User Management (https://vborg.vbsupport.ru/showthread.php?t=122221)

RogerChristie

08-28-2007 03:52 PM

Quote:

Originally Posted by jluerken (Post 1326578)

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::(

jluerken

08-28-2007 04:56 PM

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.

heugabel

08-28-2007 05:10 PM

i become this error:

Code:

Invalid SQL:

INSERT INTO ts2.ts2_clients SET i_client_server_id = '1', b_client_privilege_serveradmin = '0', s_client_name = 'test.19', s_client_password='xxxxxxxx', dt_client_created='28082007195255000';

 

MySQL-Fehler : Duplicate entry '0' for key 1

jluerken

08-28-2007 05:21 PM

Quote:

Originally Posted by heugabel (Post 1327487)

i become this error:

Code:

Invalid SQL:

INSERT INTO ts2.ts2_clients SET i_client_server_id = '1', b_client_privilege_serveradmin = '0', s_client_name = 'test.19', s_client_password='xxxxxxxx', dt_client_created='28082007195255000';

 

MySQL-Fehler : Duplicate entry '0' for key 1

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

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

heugabel

08-28-2007 06:03 PM

Quote:

Originally Posted by jluerken (Post 1327493)

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

heugabel

08-28-2007 06:20 PM

i have found the error....

for field "i_client_id" must activate "auto_increment"

it works

but is this correct for all other functions?

jluerken

08-28-2007 06:49 PM

This is correct. Auto increment is ok

Chadi

08-30-2007 03:58 PM

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

jluerken

08-30-2007 09:51 PM

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

SocialNetworkBuzz

09-29-2007 08:18 AM

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.

All times are GMT. The time now is 08:11 PM.

Page 18 of 33

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01415 seconds Memory Usage 1,752KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: