Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Guide] T4C MySQL How-To

Status
Not open for further replies.
Newbie Spellweaver
Joined
Feb 4, 2006
Messages
96
Reaction score
3
T4C MYSQL ODBC How-To​

Episode I: Installing mandatory programs.

1. You will need to get Mysql and an ODBC Connector.
Links: and
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.
 

Attachments

You must be registered for see attachments list
Last edited:
Newbie Spellweaver
Joined
Oct 17, 2006
Messages
9
Reaction score
0
Does it matter what version of MySQL that's being used? I'm having problems on MySQL Server 4.1.

Code:
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.
 
Newbie Spellweaver
Joined
Jul 10, 2006
Messages
95
Reaction score
0
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
 
Newbie Spellweaver
Joined
Feb 4, 2006
Messages
96
Reaction score
3
Does it matter what version of MySQL that's being used? I'm having problems on MySQL Server 4.1.

Code:
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 ;)

watskeburt said:
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?
 
Newbie Spellweaver
Joined
Mar 26, 2007
Messages
8
Reaction score
0
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.

Code:
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..!
 
Junior Spellweaver
Joined
Oct 3, 2004
Messages
137
Reaction score
0
Re: T4C MySQL How-To

Code:
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)
 
Last edited:
Junior Spellweaver
Joined
Feb 6, 2007
Messages
155
Reaction score
3
Re: T4C MySQL How-To

great thanks, so adding this to t4c stuff
 
Evil Scottish Overlord
Legend
Joined
May 18, 2007
Messages
5,833
Reaction score
5,250
Re: T4C MySQL How-To

Hm, I'll sticky this thread since it is quite a good tutorial for those who still play T4C.
 
Newbie Spellweaver
Joined
Dec 22, 2008
Messages
10
Reaction score
0
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.
 
Newbie Spellweaver
Joined
Feb 4, 2006
Messages
96
Reaction score
3
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
 
Joined
Feb 16, 2004
Messages
3
Reaction score
0
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...
 
Initiate Mage
Joined
Apr 1, 2011
Messages
4
Reaction score
0
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 ;)
 
Newbie Spellweaver
Joined
Feb 4, 2006
Messages
96
Reaction score
3
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.
 
Initiate Mage
Joined
Apr 1, 2011
Messages
4
Reaction score
0
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
 
Newbie Spellweaver
Joined
Feb 4, 2006
Messages
96
Reaction score
3
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 =)
 
Last edited:
Status
Not open for further replies.
Back
Top