If nobody uploads the client and the server and makes a short video guide of how everything works, we will not achieve a drastic change.
Guide plis!
- - - Updated - - -
How do I solve this?ERROR: [DBNETLIB] [ConnectionOpen (Connect ()).] SQL Server does not exist or access to it has been denied.Init mysql success!Error! init mssql fail!13:50:34 [INFO] init MYSQL failed!Press a key to continue . . .
If nobody uploads the client and the server and makes a short video guide of how everything works, we will not achieve a drastic change.
well this are the client which is configured for my server, but it is easy to change
95.216.39.168 - /client/
Text guide is much faster to understand and convenient to use because people are able to skip parts they already know or did more easily. Youtube's player is very sluggish and unprecise when one wants to see a specific part. Few lines of text can sum up the content of a 30 minute video sometimes.
Here is argeus99notes, + mine, i think it gives all the necessary steps to get a server working in localhost without any issues.
It is a bit messy, but way enough imo.
What i did
Install SQL Server 2008 R2 (no express) With SSMS
Install the latest Java JRE
Install complementary tools (Notepad ++, 7zip, VC, Net Framework, Navicat, sqlncli etc)
1. Enable mixed mode and use “U6SjJk3ZyQhrv5tq” as “sa” password in SQL Server installation
2. Open SSMS and login with “sa” account, then restore the databases from “DB_Bak_Old” folder (PlanetDB_2800, SharedDB, WebAppDB etc)
3. UnZip TERA_SERVER, TERA_API and Xampp folder to a root folder like C:\ or D:\
4. Goto C:\TeraAPI\grails-4.0.3\TeraAPI and delete “build” folder
5. Create a .bat with this arguments into TeraAPI “grailsw.bat run-app --port=8080” (without quotes)
6. Now go to C:\TERA_SERVER\test_te_server\arb_gw and change SERVERIP to your server IP, leave port as is
rest_url=http://SERVERIP:8080/api
rest_url_auth=http://SERVERIP:8080/
7. Go to C:\TERA_SERVER\test_te_server\Executable\Bin, open DeploymentConfig.xml and edit the ips 47.93.47.124 and 192.168.99.232 to your server IP
8. Go to C:\xampp\htdocs\81\server and edit serverlist.xml and serverlist.tw and change 47.93.47.124 to your server IP, make sure the port is 7801
9. Go to C:\xampp\htdocs\81\tera open LauncherloginForm and edit lines 39, 84 and 170 with your server ip, leave port 8080 and 81 as is Eg: http://SERVERIP:8080/tera/GetAccountInfoByUserNo, http://SERVERIP:8080/tera/LauncherLoginAction and SERVERIP:81/reg/
Here I finished the configuration, now how to start the server
Open Xampp and start mysql and apache server, then goto TeraApi folder and start the .bat that we created at point 5
When TeraApi finish to load then start
hub
hub_gw
arb_gw
ArbiterServer
StartTopography
WordlServer
At this point is enough for playing and questing but without dungeons. Remember for Arbiter, Topography, and world’s server you need to wait till “server ready” status in every1
If you want dungeons and battlegrounds then start everything else (DungeonOther, dungeon server, party matching, battlefield and nexus server)
Connection to MSSQL with laragon's usin windows auth
Connection to SQL with laragon : root 123456 on localhost:3306
D:\TERA_SERVER\test_te_server\Executable\Bin\Datasheet\CreateCharData.xml
The buffs from the start are SQL side
/@command
ex. /@nocool on/off (no skills cooldown)
/@invincible [on/off] (enable/disable damage taken)
/@invisible [on/off] (mobs do not attack)
/@critical [on/off] (every hit is 100% crit)
/@level # (1-70) (set to your desired level)
/@set_money # (up to 100M ) (1000000000000)
Clé SQL Server 2016 - B9GQY-GBG4J-282NY-QRG4X-KQBCR
Makes sure TCP/IP is activated in SQL Server 2016 configuration manager
Need windows in english
Could you specify that more? What tools are actually needed to run the server and edit databases? And does it require being installed on C?Install complementary tools (Notepad ++, 7zip, VC, Net Framework, Navicat, sqlncli etc)
you dont need very specific tools.. like in the text said...
VcRedist ... Net Framework.. (mostly already installed on systems)
For Editing files.. Notepad++ or any other Editor...
7zip or Winrar as you want to unpack files...
Navicat for connection to the My/Ms Sql Database .. or any other DB Manager .. like (SqlWorkbench etc.)
it doesnt require to be on a specific path...
the REQUIRED thing is SYSTEM OS LANGUAGE has to be English !!!
if its not English the ArbiterServer will crash with dump files !!!
So on my side, Xampp is on D: partition.
I use Hex workshop to edit launcher IP, u can also use resource hacker those can be installed wherever you want.
For the net frameworks, I don't actually know which is needed, i didn't needed to install a specific one.
I personally didn't took navicat as i already have laragon
Haven't downloaded sqlncli either, its not necessary to get it for server to run.
As additional info i can give, arbiter and topography require administrator privileges to run.
So to sum it up :
-MSSQL 2008 or 2016 are working
-SSMS needed to import the server databases
-Resource hacker or Hex workshop to hexedit the launcher0716.exe with the correct IP
-Any tool to connect to databases (phpmyadmin, laragon with its integrated HeidiSQL) if u want to create accounts directly in database (you can also create accounts by going to 127.0.0.1:81/reg) and filling the form
That is all you need to get the server running
I'm currently stuck at getting the arbiter server to connect to the ODBC, or at least that's what it looks like. I've gotten everything set up correctly so far, but even searching on google for a while didn't help too much with this particular error. The closest I've gotten to a solution is setting up a ODBC data source through the control panel.
SQLError [statement : ][rc=0][sqlState=IM002][nativeError=0][errorMsg=[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
I can upload preconfigured VM with Tera (and also BNS-MUL-Soulworker-Vindictus) from Tap#3121 (discord)
Full server eats about 14GB of RAM
If someone interested in this of course
good friend argeus99 could reorganize which are the mirror files with which the server can be raised is so messy, I don't know which ones are published in the post ????
Last edited by zendo1; 31-01-21 at 08:41 PM.
VM with fully preconfigured (just click .bat files one by one) servers which includes Tera (14 GB of RAM), Blade & Soul, MU Legend, Soulworker and Vindictus
This one for the VM:
Game Server 01
Game Server 02
Game Server 03
Game Server 04
Game Server 05
Game Server 06
Download and unzip all the .zip files into one folder, then open VMWare Workstation (I have 16 PRO version) and click "Open virtual machine". Select the .vmx in the folder where you unpacked the game server.
This one for running the games:
Game client
This one for requirements and what you have to do in order to play:
Tutorial
Archive password - TT
14GB? Holy shit, guess I have to wait till my 32GB RAM upgrade then.