"92.03" on VMware

[dziobus]

The VM works great and all. Couple of things:

1. The pre-installed Navicat is expired. It detects a "hardware change" and invalidates the license when the VM is started. Not sure if others have that issue, its a minor issue like how Notepad++ is in Portuguese by default...

2. The databases seem to be filled with lots of tester logins. While I can go into the SQL tables and delete these logins, it'd be nice if there was an SQL query or the VM was re-uploaded with FRESH and CLEAN account/login tables...

2. When a new account/character is created and logs in. It's got like 6 or more 30-day buffs automatically applied. Some of these are XP boosts and such that makes leveling up "normally" very very fast. I'd like to disable and remove these buffs from my character(s) and account(s), but cannot figure out how.

I've tried using admin commands for /@clearbuff to remove these, but it doesn't seem to work for these special 30-day buffs. I've also tried searching the SQL accounts to set the timers to 1min or something, but cannot find them there either. Please kindly help?

If i am not mistaking those buffs are part of a world event (festival) there is a post here on forums that explains it more (think in this thread even). But after turning offf the event you might need to clear the table with the buffs too.

 

[Archgeus]

The VM works great and all. Couple of things:

1. The pre-installed Navicat is expired. It detects a "hardware change" and invalidates the license when the VM is started. Not sure if others have that issue, its a minor issue like how Notepad++ is in Portuguese by default...

2. The databases seem to be filled with lots of tester logins. While I can go into the SQL tables and delete these logins, it'd be nice if there was an SQL query or the VM was re-uploaded with FRESH and CLEAN account/login tables...

2. When a new account/character is created and logs in. It's got like 6 or more 30-day buffs automatically applied. Some of these are XP boosts and such that makes leveling up "normally" very very fast. I'd like to disable and remove these buffs from my character(s) and account(s), but cannot figure out how.

I've tried using admin commands for /@clearbuff to remove these, but it doesn't seem to work for these special 30-day buffs. I've also tried searching the SQL accounts to set the timers to 1min or something, but cannot find them there either. Please kindly help?

I suggest you to start with clean databases

If you just want to get rid completely of those buffs then just clean HoldAbnormality db at PlanetDB_2800 and then restart the server

 

[Murasama]

The VM works great and all. Couple of things:

1. The pre-installed Navicat is expired. It detects a "hardware change" and invalidates the license when the VM is started. Not sure if others have that issue, its a minor issue like how Notepad++ is in Portuguese by default...

Yep, normal behavior for how Navicat is licensed. I'm not sure if selecting the moved or copied option when first starting up the VM, makes any difference for the assigned hardware ID. I think there is a key generator inside the Navicat directory where you can try to create a new one (but I haven't tried it myself).

2. The databases seem to be filled with lots of tester logins. While I can go into the SQL tables and delete these logins, it'd be nice if there was an SQL query or the VM was re-uploaded with FRESH and CLEAN account/login tables...

Alternatively, argeus99 has a post which provides instructions on how to create clean databases (he beat me to it)

 

[slayerjerman]

Thank you all for your quick replies! It is absolutely most appreciated!! Time to give these things a try!

 

[Robyson]

Thank you all for your quick replies! It is absolutely most appreciated!! Time to give these things a try!

Maybe this can help solve the problem with Navicat...

https://forum.ragezone.com/f799/solved-navicat-1206210/



EDIT: Clean MySQL and MSSQL Database...

You must be registered to see links

 

[shadow66]

I just made an update pack for those who are using this game version from the Robson's VM

You must be registered to see links

Content.

arb_gw
Item Claim System
TERA API (Node JS)
Updated Xampp with clean API and box/steer databases

Installation,

Take in mind the following steps apply only if you has the default vm image without modifications

1. Replace config_arb_gw.txt from arb_gw folder to C:\TERA_SERVER\TeraServer\arb_gw
2. Extract Xampp folder and put it on disk D: (remember to backup the existing xampp)
3. Delete TeraAPI folder from disk D:, then extract TeraAPI.rar there
4. Install node-v13.14.0-x64.msi from the update pack
5. Extract ItemClaim System.rar to disk D:
5. Install python-2.6.msi from the ItemClaim System folder and follow the first two installation steps from here
6. Remember to change the server_info from the accountdb database in order to make work the SLS
7. Open DeploymentConfig.xml, edit and set <ExternalIp getFromNetworkDevice="true" value="127.0.0.1" />

Now for start the new API just go to disk D, TeraAPI and start tera-api.bat (now you can delete the old grails api and uninstall java)

Follow the Server Starting from here to start the Item Claim System

And for last but not least, edit with resource hacker the new provided launcher in order to make it work with the new api system

after follow your step by step i still getting error
Breakdown occurred during communication. Please check server status. [436208617]

and what about that?

Remember to change the server_info from the accountdb database in order to make work the SLS

another one things client crash wont load:

 

[kesz24]

yesterday i run the server normally no problem at all

but now my arb_gw sudden close right after i open it

the log :

[2022/08/09 18:41:53.404] Process URL [

You must be registered to see links

ip/api][2022/08/09 18:41:53.415] Host: [my ip] Port: 8080 /api/
[2022/08/09 18:41:53.425] Resolving result my ip
[2022/08/09 18:41:53.435] Process URL [

You must be registered to see links

ip/]
[2022/08/09 18:41:53.444] Host: [my ip] Port: 8080 /
[2022/08/09 18:41:53.453] Resolving result my ip
[2022/08/09 18:41:53.460] Start request to host [my ip] 471544
[2022/08/09 18:41:53.479] REST Socket closed. Reconnect [471544]
[2022/08/09 18:41:53.489] Host: [my ip] Port: 8080
[2022/08/09 18:41:53.499] Resolving result my ip
[2022/08/09 18:41:53.519] Socket reconnection failed with A socket operation was attempted to an unreachable host
[2022/08/09 18:41:53.531] Socket closed with The operation completed successfully [471544]
[2022/08/09 18:41:53.545] RequestAPIServerStatusAvailable
[2022/08/09 18:41:53.554] RequestAPIServerStatusAvailable failed -1[]
[2022/08/09 18:41:53.567] REST CheckServer failed


am i missing something ?

 

[hexaDoc]

yesterday i run the server normally no problem at all

but now my arb_gw sudden close right after i open it

the log :

[2022/08/09 18:41:53.404] Process URL [

You must be registered to see links

ip/api][2022/08/09 18:41:53.415] Host: [my ip] Port: 8080 /api/
[2022/08/09 18:41:53.425] Resolving result my ip
[2022/08/09 18:41:53.435] Process URL [

You must be registered to see links

ip/]
[2022/08/09 18:41:53.444] Host: [my ip] Port: 8080 /
[2022/08/09 18:41:53.453] Resolving result my ip
[2022/08/09 18:41:53.460] Start request to host [my ip] 471544
[2022/08/09 18:41:53.479] REST Socket closed. Reconnect [471544]
[2022/08/09 18:41:53.489] Host: [my ip] Port: 8080
[2022/08/09 18:41:53.499] Resolving result my ip
[2022/08/09 18:41:53.519] Socket reconnection failed with A socket operation was attempted to an unreachable host
[2022/08/09 18:41:53.531] Socket closed with The operation completed successfully [471544]
[2022/08/09 18:41:53.545] RequestAPIServerStatusAvailable
[2022/08/09 18:41:53.554] RequestAPIServerStatusAvailable failed -1[]
[2022/08/09 18:41:53.567] REST CheckServer failed


am i missing something ?

[2022/08/09 18:41:53.567] REST CheckServer failed
API seems to not be running, thus arb_gw can't go further as its check for connectivity.

 

[justin1982]

the download keeps failing on me right at the end. tried 4 times on 2 different browsers says couldnt download no permissions, also does this come with what i need if i ever do get it to download? or do i still have to get vmware seperatly?

 

[Robyson]

the download keeps failing on me right at the end. tried 4 times on 2 different browsers says couldnt download no permissions, also does this come with what i need if i ever do get it to download? or do i still have to get vmware seperatly?

Log into your google drive account and try to download again, it's working for me.

 

[justin1982]

tried on another pc with anotehr google account, same thing. makes it to the end then says failed., ill try again another time

 

[Robyson]

The VM has been updated...

- Windows Server 2012 R2
- Sql Server 2008 R2

Steer Server + Box Server (Item Claim System) added.
Reactivated dungeons, with scrolls and teleports.
Registration web and translated Launcher.
MySQL and MSSQL Sqls are clean.
VMware used 16

Warning: 32gb of ram is required.

Link on home page...

Have fun!!



EDIT: Please!! update the browser, i forgot to update...
You can add Chrome, Firefox or any other.
So you don't have problems with Steer Web Admin panel:

You must be registered to see links

and Box Web Admin panel:

You must be registered to see links

 

[peteryoo]

I cannot active Dreadspire dungeon .
Could you give a comment
Which file I check .
Dungeon_constraint and teleportlist teleportdata areaillisionTower_xml.
And more Shoud i check it?

 

[finaln1]

How do I set up an externally accessible online server?
The Local Server has already tested successfully.
But I don't know how to set up an online server.
I already know the public IP address and port forwarding method.
I would appreciate it if you could tell me how to modify the internal file of the server.
Thank you.

 

[Robyson]

@finaln1 check the tutorial, it will help you https://forum.ragezone.com/f797/release-tera-v92-03-retail-1193481/index29.html#post9073186

I cannot active Dreadspire dungeon .
Could you give a comment
Which file I check .
Dungeon_constraint and teleportlist teleportdata areaillisionTower_xml.
And more Shoud i check it?

@peteryoo The ids for this dungeon are 9034, 9885 or 9886 being Normal and Hard mode, if have time i will check.

For more information you can consult this...

- DungeonConstraint.xml
- DungeonMatching.xml
- EventMatching.xml
- TeleportData.xml
- NewWorldMapData.xml
- AreaData_XXX.xml
- TerritoryData_XXX.xml
- DungeonData_XXX.xml
- NpcData_XXX.xml

 

[daim2604]

Hi.
thanks alot for this.
But when i try to log in,
i got
responseText:undefined,
url:undefined,
status:0,
readystate:0 and statusText:error: Access is denied.
Please help!

 

[peteryoo]

more detail describe please!

 

[dziobus]

more detail describe please!

Like Robyson said, you need to search for the Dreadspire ID's in the following files:
- DungeonConstraint.xml
- DungeonMatching.xml
- EventMatching.xml
- TeleportData.xml
- NewWorldMapData.xml
- AreaData_XXX.xml
- TerritoryData_XXX.xml
- DungeonData_XXX.xml
- NpcData_XXX.xml

Then uncomment them. Sometimes you might need to search for the korean name of the dungeon to find it. Once you enable what is there for it you need to do the same on the client DC file else you will not be able to use the teleport npc.

 

[daim2604]

i have fixed my problem with status undefined, but now, when i got into the game, pressing the button as shown below doesn't do anything for me. no error even showed up.. please help!


EDIT : NVM, fixed it.. turns out i didn't change the ip in serverlist.. thanks alot. sorry for the trouble.
EDIT again : New problem, World Server Crash and the last thing it logged is, arbiter session destroyed and arbiter session disconnected.
any help is greatly appreciated ! thanks alot!

 

[wandyes]

How to fix this error, please..