[Guide] T4C MySQL How-To

[Greaver]

T4C MYSQL ODBC How-To​

Episode I: Installing mandatory programs.​

1. You will need to get Mysql and an ODBC Connector.
Links:

You must be registered to see links

and

You must be registered to see links

2. Download the attached t4c_sql.zip and unzip it to c:/

3. Install Mysql, remember to select the option to add it to the PATH when asked.
4. Install ODBC.
5. Did you install them both? if not, go back to number 3.
6. Open your Start Menu, select execute and write cmd in it ( open up a dos box )
7. Once you have a dos box open, type the following.

--> mysql -u root -p

-it will now ask the password you created upon installing Mysql.
NOTE: If you didn’t create a password, remove the -p switch.

Once you are logged in, you will need to create the database.

--> Create database t4c;
--> Grant all privileges on t4c.* to yourdesiredname@localhost identified by 'yourdesiredpassword';

Remember to put the semicolon in the end
Now we proceed with selecting the newly created db.

--> Use t4c;

All set, now we have to insert some info to the database.

--> source c:/t4c.sql;

NOTE: You need to change the location of the source file according to where you have placed it

It will now add all the tables and other stuff into the mysql database, discard any possible warnings, no actual errors should arise.

If all went well, you should now have a valid database to run your T4C Server off. Next you need to setup the ODBC driver.

Episode II: The Infamous ODBC Setup.​

1. Open up your ODBC control panel, this is easiest to achieve by going to start menu, select execute and copy & paste the following in it
--> %SystemRoot%\system32\odbcad32.exe

NOTE: You can also access your ODBC consol via Control Panel-->Administration Tools-->ODBC

2. Select the User DSN tab
3. Click Add
4. Select the newly installed MySQL ODBC 3.51 driver from the list
5. It now ask various information:

-Data Source Name = t4c server
-Description . . . . . = not needed
-Server . . . . . . . . = not needed or localhost
-User . . . . . . . . . . = yourdesiredname (Created in Episode I, without the @localhost)
-Password . . . . . . = yourdesiredpassword (Created in Episode I

6. Select the newly created database from the dropdown list.
7. Click the TEST button to test the connection. It will either say Ok or possibly give you an error if the password/username is wrong.

NOTE: With some ( not all ) Windows XP installations that has SP2 installed the application will hang at this point. This is unfortunate but can be fixed easily by going to start menu, select execute and type
--> netsh winsock reset
Reboot and return to number 1.

Now the ODBC should be ready for use. In the next Episode, we will see how to setup the server itself to use the MySQL ODBC driver.

Episode III: The server setup.​

1. Open your T4C Server console (T4CSetup.cpl )located in the server folder
2. Select Authentication tab
- Make sure the ODBC is selected instead of the Radius.

3. At the bottom of the screen you see the ODBC Authentification box, this is where we will need to put some information:

- Data Source Name = t4c server ( Created in Episode II )
- Database Logging Account = yourdesiredname ( Created in Episode I, without the @localhost)
- Database Password = yourdesiredpassword ( Created in Episode I )
- Table = T4CUsers
- Account Name Field = Account
- Password Field = Password

The Time Credits and Where Statement fields can be left blank.

4. All set? Then move on to Characters tab
5. Here we will need to fill the first 2 boxes:

-Characters Db User name = yourdesiredname, ( Created in Episode I, without the @localhost)
-Characters Db password = yourdesiredpassword ( Created in Episode I )

If everything went well you now have a functional T4C Server with MySQL as its backbone. You will need to create an account so you can log in, you can use phpmyadmin or any other tool that is MySQL compatible.

 

[John_Kane]

Does it matter what version of MySQL that's being used? I'm having problems on MySQL Server 4.1.

Error Message = [Microsoft][ODBC Driver Manager] Connection not open
(CRITICAL),2/13/2007,8:06:28,Crashed when creating TFC_MAIN object.
(CRITICAL),2/13/2007,8:06:28,Crashed during T4C Server initialization. EntryFunction section.
(CRITICAL),2/13/2007,8:06:28,Exception in thread ( Id=3240 )
	DebugLogger information stack: 0 items.

 

[watskeburt]

great work man 1 question
i have Done everything now the problem is where do i create an Account?
example at acces you have database manager i dont know anything about MySQL :S

PS: How do i setup Easyphp or anyother To Connect to MySQL ?
it would be great if u could do that aswell thx alot already for setting up MySQL

 

[Greaver]

Does it matter what version of MySQL that's being used? I'm having problems on MySQL Server 4.1.

Error Message = [Microsoft][ODBC Driver Manager] Connection not open
(CRITICAL),2/13/2007,8:06:28,Crashed when creating TFC_MAIN object.
(CRITICAL),2/13/2007,8:06:28,Crashed during T4C Server initialization. EntryFunction section.
(CRITICAL),2/13/2007,8:06:28,Exception in thread ( Id=3240 )
	DebugLogger information stack: 0 items.

make sure the DSN you made in the ODBC Panel matches the one you have in the server panel ( T4C Server ) be sure to preserve the cases. Also make sure your MySQL is running
I believe it doesnt matter what MySQL version you are running, tho some earlier versions might not want to digest the sql file without complaining

great work man 1 question
i have Done everything now the problem is where do i create an Account?
example at acces you have database manager i dont know anything about MySQL :S

Now, you didnt read to the end did you =)? You need to install a MySQL database manager, there's lots of free and good ones out there. If you have a working webserver with php, get myphpadmin, Sqlyog works too

Another option is to learn some SQL, you can use this but change it accordingly ;p ( Episode I tells ya how to connect to your MySQL via Dos box )

--> INSERT INTO T4Cusers (Account,Password,Account_type,Expired,FullName,Email,CreationDate) VALUES ('LOGIN','PASSWORD','Normal','00-00-0000','FULLNAME','EMAIL','00-00-0000');

I know nuthing about easyphp so I cant help ya with that, but it comes with a manual doesnt it?

 

[Lex84]

Re: T4C MySQL How-To

Does it matter what version of MySQL that's being used? I'm having problems on MySQL Server 4.1.

Error Message = [Microsoft][ODBC Driver Manager] Connection not open
(CRITICAL),2/13/2007,8:06:28,Crashed when creating TFC_MAIN object.
(CRITICAL),2/13/2007,8:06:28,Crashed during T4C Server initialization. EntryFunction section.
(CRITICAL),2/13/2007,8:06:28,Exception in thread ( Id=3240 )
    DebugLogger information stack: 0 items.

try to set the data source name to" t4c server" low case (not "T4C Server") without double quotes..both T4C setup.cpl and ODBC panel

I had the same error, resolved..!

 

[Greaver]

Re: T4C MySQL How-To

*bumb*

 

[Roton]

Re: T4C MySQL How-To

SQL Error:
SQL State     = 08001
Native error  = 17
Error Message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
(CRITICAL),1/19/2008,19:07:47,Crashed when creating TFC_MAIN object.
(CRITICAL),1/19/2008,19:07:47,Crashed during T4C Server initialization. EntryFunction section.
(CRITICAL),1/19/2008,19:07:47,Exception in thread ( Id=3416 )
	DebugLogger information stack: 0 items.

Any ideas? Trying to connect to a REMOTE MySQL Server on the network. Ports are set properly, database setup, etc. It's opening the connection, just not getting in.



--FIXED: I set the user on the network MySQL to name@MACHINE. (Example: Boob@MyPC) instead of (Example: Boob@192.168.10.1)

 

[Vegnagun]

Re: T4C MySQL How-To

great thanks, so adding this to t4c stuff

 

[Greaver]

Re: T4C MySQL How-To

this needs a *bumb* since its way down to 3rd page already, no1 reads that far =p

 

[Junkers]

Re: T4C MySQL How-To

Hm, I'll sticky this thread since it is quite a good tutorial for those who still play T4C.

 

[henriqueam]

Hi,

I'm having some hard time seting my server. If anyone could help me,

my msn is: henriqueam@hotmail.com

Please add me and help to set my server. I have some files and other things to trade if interested.

Thank you.

 

[Ragnar25]

hmm I dont see the guide anymore.... Looks like its cut off. Can you re-post or repair it? Thanks! It is VERY useful!

 

[Greaver]

I did my best to redo it, links might be outdated and I have no idea if the newer versions will work with T4C but someone could try and post the results and possibly links to mysql/odbc

 

[fuinharlz]

If anybody still follows this thread.

I have set up an server with sql dbase and it's all working, but I have ONE lil problem: whenever there's someone logged on the server, NOBODY else can log in! The t4c client returns a "your account is already logged in a server" error, even if the one logged in is using account A, and the one trying to log in is using account B (I'm actually using mysql workbench to create accounts on t4cuser table!)

If anybody knows how to solve it...

 

[Palandran]

Hallo..

i followed the guide above.. but when i start the server he's comming up.. and shut down ..

Error Log:

(CRITICAL),4/1/2011,18:09:28,Creating TFC_MAIN object.
(CRITICAL),4/1/2011,18:09:28,Creating ODBCTrace object.
(Debug3),4/1/2011,18:09:31,Installing performance counters.
(CRITICAL),4/1/2011,18:09:31,Crashed during T4C Server initialization. EntryFunction section.

Pls help .. thanks

 

[Greaver]

Re: T4C MySQL How-To

try to set the data source name to" t4c server" low case (not "T4C Server") without double quotes..both T4C setup.cpl and ODBC panel

I had the same error, resolved..!

Did you try this solution?

Ill modify the guide according to that so we should have fewer issues with it.

 

[Palandran]

Yes i tried, but don't work. :/

 

[Greaver]

Also make sure your mysql server is running.

 

[Palandran]

oke sorry my fail.. MySql Database was not running..

But now I have an other problem.. I don't know how to create an Account.. I tried the Databasemanager in the T4C Server folder.. but don't work..
I tried myphpadmin too, but i'am to stupid for this stuff...

May you have an answer for this?:

(Info),4/5/2009,21:04:59,-+----------------+-
(Info),4/5/2009,21:04:59,Lancement T4C Serveur.
(Debug3),4/5/2009,21:04:59,Charg. Language french, fichier t4c_fr.elng, lngID2
Setting default language to french.

(CRITICAL),4/5/2009,21:05:01,Distribution T4C-Serveur.fr.st pour tout utilisateurs ....
(Debug),4/5/2009,21:05:01,Loading version v125
(Debug3),4/5/2009,21:05:01,SQL ERROR [SQLConnect]:
(Debug3),4/5/2009,21:05:01,SQL State: 00000
(Debug3),4/5/2009,21:05:01,Native Error: 5247444
(Debug3),4/5/2009,21:05:01,Error message:
(CRITICAL),4/5/2009,21:05:01,T4C was shutdown because the ODBC connection is down.
(CRITICAL),4/5/2009,21:05:01,Copy of email sent to Palandran@gmx.at:
(CRITICAL),4/5/2009,21:05:01,<This is an automated message from T4C Server of Merrill Information Systems Inc.>
You can reply directly to this message if you need support about this item.

T4C was unable to establish a connection with the character database.
The server cannot run without a character database and has therefore
been shutdown for a minimum period of 5 minutes.

Please verify your setup and correct the situation as soon as possible.

SQL Error:
SQL State = 08003
Native error = 0
Error Message = [Microsoft][ODBC Driver Manager] Die Verbindung ist nicht geöffnet

 

[Greaver]

Make sure you follow the guide, it seems the server cant find / connect to your database. If the test in ODBC passes it means you have something wrong in your t4c control panel settings ( wrong db, username or username )
Download and instal sglyoq to create accounts =)