vb.org Archive - Integration with vBulletin - gTeamSpeak

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)

OK thanks for having looked at this. I was under the impression that I was alone having this issue.

Just one more question: By investigation what do you mean? You asked the TS guys or you saw by yourself that you had the same problem than me?

No worries ;)

Quote:

Originally Posted by Cybershaolin (Post 1750119)

By investigation what do you mean? You asked the TS guys or you saw by yourself that you had the same problem than me?

Both, and also chatting with a few friends that are far more advanced than me and code in thier dreams.:)

It appears that you have done everything right and the problem is with the server application not the user ;)

Quote:

Originally Posted by LeatherNeck (Post 1749799)

Excellent work, working like a charm on 3.8.1:D

Hope it's ok, but a lot of people have trouble getting TS to work on linux with mysql, so here is how I did it (tested on Centos5 and mysql 5 ;) )

Add the following to the very bottom of your server.ini

Code:

[DBEXPRESS]

sqldir=mysql_sql/

Drivername=mysql

Database=*************

Hostname=127.0.0.1

User_name=**********

Password=*****************************

GetDriverFunc=getSQLDriverMYSQL

VendorLib=FULL/SERVER/PATH/TO/LIBS/libmysqlclient_r.so.10.0.0

LibraryName=FULL/SERVER/PATH/TO/LIBS/libsqlmy.so

Active=1

WITH THIS YOU NEED TO RUN AT THE MYSQL PROMPT
mysql>

Code:

SET PASSWORD FOR

'TheTSdbUser'@'localhost' = OLD_PASSWORD('***************');

ATACHED ARE THE LIBS NEEDED TO CONNECT TO MYSQL

I have done exactly the same on my server, and it works, now im moving servers, copied all files from my old server, changed the database user / pass, en now i get:

Code:

-------------- log started at 23-02-09 15:29 -------------

---------------------------------------------------------------

23-02-09 15:29:57,ALL,Info,server,        Server init initialized

23-02-09 15:29:57,ALL,Info,server,        Server version: 2.0.24.1 Linux

23-02-09 15:29:57,ERROR,All,SQL,        Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password

23-02-09 15:29:57,ERROR,All,SERVER,        Start_Server: unable to open database

----------------------------------------------------------

I am 100% sure my user/pass is correct, and my config and files are eactly the same as my old working server.

any idea what i could be missing?

I'm confused a bit, my TS is not on the same server as my vB, it is hosted by a third party and I do not have access to the server.ini to edit.

My confusing is that in your Features list it says;

Optionally connect to a remote TeamSpeak database if TeamSpeak is not hosted on the same db as your vBulletin.

Yet under Support it says;

For best results and performance, have your TeamSpeak server use your vBulletin database as it's database.

Then you have the Setup mySQL info which ends with;
Make sure these tables exist and that your TeamSpeak server is actively using your mySQL database properly before even downloading the gTeamSpeak modification.

So my question is, can I use your mod or not, it seems that in the feature it would fit my need, yet later it says I must edit the files or not to download.

Thank you for your comments and mod, I hope it can work for my site.

RE: Optionally connect to a remote TeamSpeak database...;
If you have purchased TeamSpeak hosting from a voice comm service provider, it is highly unlikely they will grant you database access.

RE: For best results and performance...;
If they share the database it doesn't have to make a slow external connection.

RE: Make sure these tables exist...;
By default TeamSpeak does not use a MySQL database, this is something people who host their own TeamSpeak servers do before even downloading the mod. On top of that, if the MySQL database is remote, you have to take steps to know the authentication information and you have to add the ip of the requesting service to MySQL.

This requirement ensures that the user has at least completed the necessary steps unrelated to this mod, because without them this mod will just add confusion.

so.... the answer is no then.

Perhaps you should add your first response (If you have purchased TeamSpeak hosting from a voice comm service provider, it is highly unlikely they will grant you database access.) to the Features list so that ppl in my position are not downloading the mod by mistake.

But thank you for your hard work & mod anyway,
Ed

does not work in .8.1?

Works fine, not much about it should be version dependent.

Quote:

Originally Posted by relaxiha (Post 1767710)

does not work in .8.1?

in reply to your pm m8

Quote:

hello
may you help me for install gTeamSpeak - TeamSpeak User Management ?
i can't install

You have

Quote:

VendorLib=/usr/lib/libmysqlclient_r.so.10.0
LibraryName=./libsqlmy.so

you need to change this to:

Example:

Quote:

VendorLib=/home/relaxiha/tss2_rc2/libmysqlclient_r.so.10.0 (the EXACT location on your server)
LibraryName=/home/relaxiha/tss2_rc2/libsqlmy.so the EXACT location on your server)

This works perfectly in 3.8.1, but as i stated, I am running this on CENTOS 5 and mysql 5

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01394 seconds Memory Usage 1,746KB 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 (3)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)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: