• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Compiling TFS 1.0/1.1 latest source. 64 and 32 bits. Pics and lots of explanation.

Faceless said:
Anyways, Reached the...

Failed to connect to the Database

In my www. I have gotten myself the znote aac and thrown in there, whilst i already did the schema, and i ran the SQL command.
im wondering if i'm missing something in the config file besides the connection credentials? - are there any ports or something im missing?
Click to expand...
Look at Znotes tutorial, or mine, skip to the part where I set up the site and make sure you configure it as it is in the server config.
 
Hmm seems like i did just as you, still getting a fail site instead of a neatlooking znote site :-(

I will throw some code into this post when i get home from job.
 
Hey . Heres the code

Code: 
// Available options: TFS_02, TFS_03
    // TFS 0.2 = TFS_02
    // TFS 0.3 = TFS_03 (If ur using 0.3.6, set $config['salt'] to false)!
    // TFS 0.4 = TFS_03
    $config['TFSVersion'] = 'TFS_03';
   
    $config['site_title'] = 'Znote AAC';
    $config['site_title_context'] = 'Because open communities are good communities. :3';
   
    // ------------------------ \\
    // MYSQL CONNECTION DETAILS \\
    // ------------------------ \\
   
    // phpmyadmin username for OT server: (DONT USE "root" if ur hosting to public.).
    $config['sqlUser'] = 'Otserv';
   
    // phpmyadmin password for OT server:
    $config['sqlPassword'] = '***My OTserv user password here***';
   
    // The database name to connect to. (This is usually same as username).
    $config['sqlDatabase'] = 'Otserv';
   
    // Hostname is usually localhost or 127.0.0.1.
    $config['sqlHost'] = '127.0.0.1';

Anything suspecious?
 
Ninja you are a gift to us from above with all your help!

It seems this didnt help my progress at all though. I might have done something wrong earlier on in the process...

To look at the failure screen it says first i have to add the schema.sql... i did that. (that's all the player, accounts, guilds, and so forth...) (Check)

Secondly, add that huge code block into the SQL (in the otserv database). (Check)

Third... The code

Code: 
    $config['TFSVersion'] = 'TFS_10';
   
    $config['site_title'] = 'Znote AAC';
    $config['site_title_context'] = 'Because open communities are good communities. :3';
   
    // ------------------------ \\
    // MYSQL CONNECTION DETAILS \\
    // ------------------------ \\
   
    // phpmyadmin username for OT server: (DONT USE "root" if ur hosting to public.).
    $config['sqlUser'] = 'Otserv';
   
    // phpmyadmin password for OT server:
    $config['sqlPassword'] = '***my code here***';
   
    // The database name to connect to. (This is usually same as username).
    $config['sqlDatabase'] = 'Otserv';
   
    // Hostname is usually localhost or 127.0.0.1.
    $config['sqlHost'] = 'localhost';

I am out of idea's what i could be doing wrong. I've opened all the ports aswell if that should be the case.
 
Do you have TeamViewer? :p
 
sqlhost to 127.0.0.1
and dont use caps creating names for the user and db(its ok for the password.)
 
We figured it out. Basically i had everything set up as according to the "books" . I had my decision of having my SQL port being custom, made it like Port 4321, and correcting everything to 4321 so it would match. But changing it like that isnt that simple. So we just had to change it back to 3306 :) And everything worked like a charm.

Wasnt easy, but all it took was teamviewer help from Ninja :)
 
Using visual studion express 2013 and the project seems to be incompatibile.
 
Hello, guys.
Thanks friend dominique120, nice tutorial helped me and helps many people.
I managed to successfully compile thanks for the tutorial a big hug and be with God!

Note: I create also OTClient in 32bit Thanks.

Sorry my english.
 
Now I have a different problem, it occurred after following your tutorial seems to be a problem with the linker, but he still managed to generate the executable, the question is will that may be relevant? After all were 133 warnings, do not know if anyone else had this problem, if not may be an isolated case, but if it is less common to need to know to trust my own compilation.

cisg.png
 
Code: 
1>  wildcardtree.cpp
1>actions.obj : error LNK2001: unresolved external symbol _lua_pushnumber
1>chat.obj : error LNK2001: unresolved external symbol _lua_gettop
1>chat.obj : error LNK2001: unresolved external symbol _lua_type
1>chat.obj : error LNK2001: unresolved external symbol _lua_isnumber
1>chat.obj : error LNK2001: unresolved external symbol _lua_newuserdata
1>chat.obj : error LNK2001: unresolved external symbol _lua_tonumber
1>chat.obj : error LNK2001: unresolved external symbol _lua_settop
1>combat.obj : error LNK2001: unresolved external symbol _lua_pcall
1>configmanager.obj : error LNK2001: unresolved external symbol _luaL_newstate
1>configmanager.obj : error LNK2001: unresolved external symbol _luaL_openlibs
1>configmanager.obj : error LNK2001: unresolved external symbol _luaL_loadfile
1>configmanager.obj : error LNK2001: unresolved external symbol _lua_tolstring
1>configmanager.obj : error LNK2001: unresolved external symbol _lua_close
1>configmanager.obj : error LNK2001: unresolved external symbol _lua_getfield
1>configmanager.obj : error LNK2001: unresolved external symbol _lua_isstring
1>configmanager.obj : error LNK2001: unresolved external symbol _lua_objlen
1>configmanager.obj : error LNK2001: unresolved external symbol _lua_gettable
1>databasemanager.obj : error LNK2001: unresolved external symbol _luaL_register
1>luascript.obj : error LNK2001: unresolved external symbol _lua_pushcclosure
1>luascript.obj : error LNK2001: unresolved external symbol _lua_insert
1>luascript.obj : error LNK2001: unresolved external symbol _lua_remove
1>luascript.obj : error LNK2001: unresolved external symbol _lua_rawgeti
1>luascript.obj : error LNK2001: unresolved external symbol _lua_pushvalue
1>luascript.obj : error LNK2001: unresolved external symbol _lua_rawset
1>luascript.obj : error LNK2001: unresolved external symbol _lua_pushnil
1>luascript.obj : error LNK2001: unresolved external symbol _lua_setfield
1>luascript.obj : error LNK2001: unresolved external symbol _lua_call
1>luascript.obj : error LNK2001: unresolved external symbol _lua_rawget
1>luascript.obj : error LNK2001: unresolved external symbol _lua_createtable
1>luascript.obj : error LNK2001: unresolved external symbol _luaL_ref
1>luascript.obj : error LNK2001: unresolved external symbol _luaL_unref
1>luascript.obj : error LNK2001: unresolved external symbol _lua_pushlstring
1>luascript.obj : error LNK2001: unresolved external symbol _lua_toboolean
1>luascript.obj : error LNK2001: unresolved external symbol _lua_setmetatable
1>luascript.obj : error LNK2001: unresolved external symbol _lua_getmetatable
1>luascript.obj : error LNK2001: unresolved external symbol _lua_isuserdata
1>luascript.obj : error LNK2001: unresolved external symbol _lua_pushboolean
1>luascript.obj : error LNK2001: unresolved external symbol _luaL_newmetatable
1>luascript.obj : error LNK2001: unresolved external symbol _lua_rawseti
1>luascript.obj : error LNK2001: unresolved external symbol _lua_next
1>luascript.obj : error LNK2001: unresolved external symbol _lua_equal
1>luascript.obj : error LNK2001: unresolved external symbol _lua_settable
1>luascript.obj : error LNK2001: unresolved external symbol _lua_pushstring
1>luascript.obj : error LNK2001: unresolved external symbol _lua_replace
1>luascript.obj : error LNK2001: unresolved external symbol _lua_touserdata
1>forgottenserver-master\vc12\Release\theforgottenserver.exe : fatal error LNK1120: 45 unresolved externals
========== Rebuild All: 0 succeeded, 1 failed, 0 skipped ==========
how to fix? compile 32 bit
 
Great tutorial, but is there any benefit of using the 2013 version over the 2010 version of MSVC to compile TFS?
 

Similar threads

zezin009
Compiling TSF 0.3.6 with Dev C++ for Windows in 2023
Replies
3
Views
1K
pelek2002
P
P
  • Question
TFS 1.X+ Help Compiling on Windows (vcpkg)
Replies
0
Views
151
pepito999
P
E
OTC + TFS compatibility
Replies
1
Views
365
Codinablack
Codinablack
S
  • Question
tfs 0.4 tibia 8.6 0xc000007b error
Replies
2
Views
183
staberek
S
Giorox
Naive Dockerized TFS 1.5
Replies
6
Views
1K
iNux
I
Back
Top