Tera API (node.js) and Launcher with pacher for patch 92/100

**uiojilk777** · 17-08-22

First I created the 00_db_schema database and successfully imported 00_db_schema.sql, but when I created 01_db_data or 02_db_data_item_conversions and imported the same name.sql, an error will be reported.

I'm stuck, what should I do? thanks
(4. Select the file ExportSteerData_steeradmin_API.sef and confirm import.)

**TieLay** · 17-08-22

Originally Posted by uiojilk777

First I created the 00_db_schema database and successfully imported 00_db_schema.sql, but when I created 01_db_data or 02_db_data_item_conversions and imported the same name.sql, an error will be reported.

I'm stuck, what should I do? thanks
(4. Select the file ExportSteerData_steeradmin_API.sef and confirm import.)

OMG, U so unlucky U need red this .sql-files and understand:
- 00_db_schema.sql - created need db's tables in box2db, steer3db and teraapi
- 01_db_data and 02_db_data_item_conversions insert records into tables

**uiojilk777** · 17-08-22

Originally Posted by TieLay

OMG, U so unlucky U need red this .sql-files and understand:

Originally Posted by TieLay

- 00_db_schema.sql - created need db's tables in box2db, steer3db and teraapi
- 01_db_data and 02_db_data_item_conversions insert records into tables

So Tera-API shouldn't be installed first?
I follow the top-down steps of GitHub (https://github.com/justkeepquiet/tera-api)
Can you provide a detailed tutorial? thanks

**TieLay** · 17-08-22

Originally Posted by uiojilk777

So Tera-API shouldn't be installed first?
I follow the top-down steps of GitHub (https://github.com/justkeepquiet/tera-api)
Can you provide a detailed tutorial? thanks

- create dabases box2db, steer3db and teraapi like codepage in UTF8 and step by step tutorial O U can download my version TERA_SERVER, extract from archive folder .\TERA_SERVER\BackUpDATA and execute MySQL*.SQL files in HeidiSQL that connected to MySQL - it's files what me use in my gameServer and all works perfectly - they all includes full MySQL DB pack for normal work, but U need correct only one record in teraapi DB thet about server configuration, if you's IP different then 172.16.200.119

**miggo** · 17-08-22

Could someone make a compilation of everything updated from the tera version 100 server whit all update? there are so many things that for us new users it is very complex. there are many comments and many news.

**fitnessguy0** · 18-08-22

Originally Posted by hsdn

You need to create the file tw.json in tera-api\src\locales\shop directory (you can just copy en.json to tw.json).
After that, when you select Chinese (TW) in the launcher, the items in Shop should be displayed in Chinese.

thx again，，，it works now。。
but lots of items are no name or unknown appeared in Tera Shop.

and most of them are display right the name...

Is ur Sql file missing some tranlation?

通过我的 NOH-AN00 上的 Tapatalk发言

**TieLay** · 18-08-22

Originally Posted by fitnessguy0

s ur Sql file missing some tranlation?

通过我的 NOH-AN00 上的 Tapatalk发言

If u visit teralore then U seen some items haven't normal name and descriptions on all languages but usable, like items/stuff/equip geting from VIP boxes

**hsdn** · 18-08-22

Originally Posted by fitnessguy0

thx again，，，it works now。。
but lots of items are no name or unknown appeared in Tera Shop.

and most of them are display right the name...

Yes, I told you about this:

Originally Posted by hsdn

But I notices you that not all items added to the Shop based on the sample database will have names in TW/CN, because they were added from EUR DC.

The Shop database included as an example was created on the basis of the EUR DC. You need to independently add products to the catalog based on TW client, unfortunately, I can't help with this, it takes a lot of time.

**Zexuce** · 18-08-22

use new api but cant run arb_gw server, its something wrong.

Code:

[2022/08/18 19:27:58.411] build : Sep 16 2020, 17:25:33, LOG_LEVEL : 5[2022/08/18 19:27:58.411] Process URL [http://192.168.200.3:8080/api][2022/08/18 19:27:58.411] Host: [192.168.200.3] Port: 8080 /api/[2022/08/18 19:27:58.430] Resolving result 192.168.200.3:8080[2022/08/18 19:27:58.430] Process URL [http://192.168.200.3:8080/][2022/08/18 19:27:58.443] Host: [192.168.200.3] Port: 8080 /[2022/08/18 19:27:58.443] Resolving result 192.168.200.3:8080[2022/08/18 19:27:58.443] Start request to host [192.168.200.3:8080] f6e26c[2022/08/18 19:27:58.443] REST Socket closed. Reconnect [f6e26c][2022/08/18 19:27:58.460] Host: [192.168.200.3] Port: 8080[2022/08/18 19:27:58.460] Resolving result 192.168.200.3:8080[2022/08/18 19:28:00.507] Socket reconnection failed with Unable to connect because the target computer actively refused.[2022/08/18 19:28:00.507] Socket closed with the operation completed successfully. [f6e26c][2022/08/18 19:28:00.507] **** SLOW Call 2078[/systemApi/RequestAPIServerStatusAvailable][2022/08/18 19:28:00.520] RequestAPIServerStatusAvailable [2022/08/18 19:28:00.520] RequestAPIServerStatusAvailable failed -1[][2022/08/18 19:28:00.536] REST CheckServer failed

**uiojilk777** · 18-08-22

Originally Posted by TieLay

- create dabases box2db, steer3db and teraapi like codepage in UTF8 and step by step tutorial O U can download my version TERA_SERVER, extract from archive folder .\TERA_SERVER\BackUpDATA and execute MySQL*.SQL files in HeidiSQL that connected to MySQL - it's files what me use in my gameServer and all works perfectly - they all includes full MySQL DB pack for normal work, but U need correct only one record in teraapi DB thet about server configuration, if you's IP different then 172.16.200.119

thanks please tell me where can i find your version TERA_SERVER? and what is the tutorial O U？

**hsdn** · 18-08-22

Originally Posted by Zexuce

use new api but cant run arb_gw server, its something wrong.

You need to use 127.0.0.1 instead of 192.168.200.3 on config_arb_gw.txt in parameters rest_url and rest_url_auth, since the api only binds on address 127.0.0.1.

**Brat05** · 18-08-22

Originally Posted by uiojilk777

thanks please tell me where can i find your version TERA_SERVER? and what is the tutorial O U？

SERVER Please use the Tera level 100 version released on this board.
You can find all the relevant tutorials in this posting
Please read carefully the information posted by hsdn and the responses of other friends

**Riku09** · 18-08-22

Hello ! im trying to use the packer but i have this error, anyone can help me ?

**uiojilk777** · 18-08-22

Thank you for your hint, I successfully configured Steer Server + Box Server after referring to TieLay's reply, and found TieLay's version TERA_SERVER in Tera level 100 version, and I am currently researching and using it.

- - - Updated - - -

Originally Posted by hsdn

You need to use 127.0.0.1 instead of 192.168.200.3 on config_arb_gw.txt in parameters rest_url and rest_url_auth, since the api only binds on address 127.0.0.1.

I have set 127.0.0.1 instead of 192.168.200.3 on config_arb_gw.txt in parameters rest_url and rest_url_auth, the following message appears when running the file tera-api.bat，please what should i do? thanks!
[2022-08-19 01:19:22.594] (info) Logger: Log file: C:\tera-api\logs\log_2022-08-19_01-19-22_728.log
[2022-08-19 01:19:22.724] (warn) Steer: Not configured or disabled. QA authorization for Admin Panel is used.
[2022-08-19 01:19:22.830] (error) Hub: Error: connect ECONNREFUSED 127.0.0.1:11001
[2022-08-19 01:19:22.855] (info) Datasheet: Loaded: en:strSheetAccountBenefit, elements: 49
[2022-08-19 01:19:22.861] (info) Datasheet: Loaded: ru:strSheetAccountBenefit, elements: 49
[2022-08-19 01:19:22.867] (info) Datasheet: Loaded: en:strSheetDungeon, elements: 264
[2022-08-19 01:19:22.874] (info) Datasheet: Loaded: ru:strSheetDungeon, elements: 264
[2022-08-19 01:19:23.048] (info) Datasheet: Loaded: en:strSheetCreature, elements: 19233
[2022-08-19 01:19:23.192] (info) Datasheet: Loaded: ru:strSheetCreature, elements: 19233
[2022-08-19 01:19:23.232] (info) Database: Connected.
[2022-08-19 01:19:23.411] (info) Arbiter API: Listening at: 127.0.0.1:8080
[2022-08-19 01:19:23.411] (error) Portal API: Error: listen EACCES: permission denied 0.0.0.0:80
[2022-08-19 01:19:23.411] (info) Gateway API: Listening at: 127.0.0.1:8040
[2022-08-19 01:19:23.411] (info) Admin Panel: Listening at: *:8050
[2022-08-19 01:19:23.412] (info) CL: Process closed.

**hsdn** · 18-08-22

@uiojilk777 You need to start servers in the following order:

1. hub and hub_gw <-- first
2. Steer Server services
3. Box Server services
4. TERA API
5. REST (Nexusserver, MatchServer, XigncodeProxy)
6. TopographyServer
7. arb_gw and ArbiterServer
8. WorldServer (PartyMatching, BattleField, DungeonServer)

[2022-08-19 01:19:23.411] (error) Portal API: Error: listen EACCES: permission denied 0.0.0.0:80

Also, this error indicates that port 80, which is necessary for the API to work, is not available for listening (perhaps it is already used with some service using port 80, or it is forbidden by the firewall).

Tera API (node.js) and Launcher with pacher for patch 92/100

Thread Tools

packer

Advertisement