vb.org Archive

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)

PlymWS 03-05-2008 05:15 PM

If I create a user through the TS backend, the user is added to the MySQL DB fine. The password is hashed as it's not the same as the plain text.

If I create a user through the hack that user also appears in the MySQL DB fine and the password is visible in plain text.

However the TS-created user can connect but the hack-created user gets a bad login message.

Other than that the hack works perfectly. I'll investigate this as well and let you know if I get anywhere.

Gryphon 03-05-2008 05:27 PM

Hmm, in mySQL 4.0 TS users are plain text. I know that as of 4.1 there was some password changes, but didn't realize it would affect the TS password field. I will have to look into that.

PlymWS 03-05-2008 06:09 PM

There's MD5 hashing on my passwords for some reason. Possibly a change in MySQL 5.

PlymWS 03-05-2008 07:08 PM

I'm pretty sure this is to do with the way MySQL 5 hashes passwords. Just to make sure if someone could post me their TS install folder, minus server.ini and server.log so I can try with that I would appreciate it.

jluerken 03-06-2008 06:55 AM

Quote:

Originally Posted by PlymWS (Post 1457844)
There's MD5 hashing on my passwords for some reason. Possibly a change in MySQL 5.

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/Ap...sword_use.html

Quote:

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 | *BA3E2F47E409A6ABA8AF34A430631A02FE28539E |
| root | *BA3E2F47E409A6ABA8AF34A430631A02FE28539E |
| | |
| | |
| teamspeak | 09a6e3834c6d11c9
This means your teamspeak db is now storing passwords in the old format.
Teamspeak2 needs this to work, it has nothing to do with this hack.

I am quite sure this will work for you.

PlymWS 03-06-2008 07:32 AM

I followed that and got the correct mysql output from the command prompt.

The passwords from the hack are still stored in plain text though and this means they don't connect to the server. I have the following in the database :

tscreateduser - password : 1d427ce2b82bc4e30b2012c6f6df2e6a (tsuser in plain text)
gteamspeakuser - password : tsuser ( stored in plain text )

I'm going to look today at how I might change the PHP to incorporate the new MySQL 5 hashing of passwords.

jluerken 03-06-2008 07:42 AM

There is an option to turn the hashing off. If I am correct its "--disable-hash" but I am not using MySQL 5 and cannot say how this works for a single db.
You can try to check this db with phpMyAdmin and see if you have an option there to turn hashing off.
phpMyAdmin often surprises me which such things :-)

PlymWS 03-06-2008 07:48 AM

I have done the opposite :) I went into phpMyAdmin and used the MD5 function on a plain text password to create a hashed pass. This then works fine. Now to get it to do this automatically with all passwords :)

EDIT:

OK, what I've done is edit gteamspeak.php, Line 98 (password updates) to read
Code:

func_gts_query("UPDATE " . $ts2db['name'] . "ts2_clients SET s_client_name = '" . $ts2info['username'] . "', s_client_password = MD5('" . $ts_password . "') WHERE s_client_name = '" . $ts2info['username'] . "' AND i_client_server_id = '" . $ts2db['serverid'] . "'");
and line 114 (initial user setup) to read

Code:

func_gts_query("INSERT INTO " . $ts2db['name'] . "ts2_clients SET i_client_server_id = '" . $ts2db['serverid'] . "', b_client_privilege_serveradmin = '" . $sa_status . "', s_client_name = '" . $ts2info['username'] . "', s_client_password=md5('" . $ts_password . "'), dt_client_created='" . $createtime . "'");
so that passwords are MD5 encrypted and sent to the DB. This works but the password is displayed as an MD5 string in the password box and the info page lists the password as the MD5 string. Also the Connect/Quick Connect links don't work as the password is called by the product in plain text.

I can live with this for now as I'll just comment out the references and display some text instead and delete the connect links.

I'll work on this further if anyone else wants these features to work.

atlambros83 04-02-2008 02:23 AM

I'm confused...can I not use this mod if I have a teamspeak server setup somewhere like www.defconservers.com ? I'd really like to incorporate my teamspeak server into my forums if at all possible.

swissknife 04-03-2008 09:22 AM

Is the following plugin possible ?

via cron : Check if the teamspeak-user has a forumaccount, if not: ban from the ts ?

Thank you!


All times are GMT. The time now is 03:16 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01364 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
  • (2)bbcode_code_printable
  • (2)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