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

@hsdn ty! now its finally opening up the launcher + account creation is working. BUT i got the SLS error now.

--- nvm forgot to add the server in database "server_info" --

but my API Server always throws these errors
https://gyazo.com/7bbb86cbeabed2f168c5906d28942582

@0x9 I think you don't have a server with id 2800 in the server_info table.

@hsdn you're right, now the error message is gone.

edit:

also got this error on worldserver again and again
https://gyazo.com/979f622f60fa69fb06eec9bc0b8c4d6c

arbiterserver lag ticks:
https://gyazo.com/aa9a1fdc71c02f19104c95a63313b930

server specs: ryzen 5950x, 256GB Ram

@0x9 It is normal behavior. Ignore it.

Do I need to restart the server after setting up QA?

Quote:

---

Originally Posted by hithots

Do I need to restart the server after setting up QA?

---

Yes. Any changes in the server XML's requires a server restart.

Do I need to set up QA in Account DB and then start the server?

Quote:

---

Originally Posted by hithots

Do I need to set up QA in Account DB and then start the server?

---

You set the server to QA mode. You need to enable it in serverconfig.xml
Then anyone on the server can use the QA commands.

Any idea on how to stop the cannot access launcher exe
http://tsrgaming.net/files/launcher_error.jpg

Quote:

---

Originally Posted by vileninja

Any idea on how to stop the cannot access launcher exe
http://tsrgaming.net/files/launcher_error.jpg

---

Yes please any help with this issue would be great.

after updated this API with launcher...is it supports auto update function?

if yes..which files would receive update mention?

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

[2022-07-20 16:29:10.392] info: Log file: C:\tera-api\logs\log_2022-07-20_16-29-10_6504.log
[2022-07-20 16:29:11.027] info: Portal API is listening at: *:80
[2022-07-20 16:29:11.028] info: Arbiter API is listening at: 127.0.0.1:8080
[2022-07-20 16:29:11.056] error: Report database connection error: Access denied for user ''@'localhost' to database 'accountdb'

Please help me

Quote:

---

Originally Posted by hithots

[2022-07-20 16:29:10.392] info: Log file: C:\tera-api\logs\log_2022-07-20_16-29-10_6504.log
[2022-07-20 16:29:11.027] info: Portal API is listening at: *:80
[2022-07-20 16:29:11.028] info: Arbiter API is listening at: 127.0.0.1:8080
[2022-07-20 16:29:11.056] error: Report database connection error: Access denied for user ''@'localhost' to database 'accountdb'

Please help me

---

Remember to change the mysql user & password in the .env file

New API update has been released! Tera Shop + Admin Panel

Download: https://github.com/justkeepquiet/tera-api

Screenshots:

Spoiler:

https://i.imgur.com/KDL8bTN.png

https://i.imgur.com/o19Pp2B.png

https://i.imgur.com/2cuAO22.png

https://i.imgur.com/V8jW44L.png

https://i.imgur.com/4Hh6zJO.png

https://i.imgur.com/R6jDRxM.png

https://i.imgur.com/ap4BIqu.png

https://i.imgur.com/G7u9ZIS.png

https://i.imgur.com/MkVXGYm.png

https://i.imgur.com/q7ftDEt.png

New features and changes:

• Full implementation of the Tera Shop.
• Full implementation of Admin Panel for API features and Tera Shop.
• Added language select in the Launcher.
• Implementation of the promo code system (Tera Shop).
• New server availability check algorithm.
• Integration with the Steer Server and Tera Platform Hub.
• The use of FCGI WebAPI and FCGI Gateway is no longer required.
• Automatic creation of Service Items (Box).
• Improve application console logging and debugging.
• Now a single database for the API is used.
• Lots of improvements and fixes.

Admin Panel features:

• User accounts management.
• Account benefits management.
• User bans management (including IP bans).
• Monitoring of online users with kick functions.
• SLS (server list) management with server check.
• Server list strings management.
• Server maintenance plans management.
• Full management of the Tera Shop and promo codes system.
• Functions for sending the Item Claim boxes.
• Admin tasks management (background queue).
• View logs of API, Shop and boxes.
• View detailed admin operations log.

How to install an update

Spoiler:

Important! We removed database separation, now all tables used by the API are in one database, so if you used a separate database for reports, you need to import it into the accountdb database.

All steps are strictly required!

1. Replace the file package.json with new one and run install.bat file.
2. Completely delete the src directory and add it with a new one from the update.
3. Replace all files in the public\launcher directory with new ones.
4. Replace all files in the config directory with new ones (make your own settings if necessary).
5. Unpack the share\data\tera-icons.zip archive to tera-api\data\tera-icons folder.
6. Import the database structure from the share\db\00_schema.sql file (new tables will be added).
7. Import the database updates from the share\db\updates\00_update.sql.
   If you get errors while importing the 00_update.sql, run the queries from the file manually one by one, ignoring the queries with errors. This step not required for new installations or clean database!
8. Import other database files from the share\db directory for the Shop, Item Claim and other features to work. Example data of Tera Shop (with most items) is in file 03_db_shop_data.sql.
9. Many paramenets in the .env file have been changed, so you can copy the new .env.example file to .env and make your own settings.
10. Open config\admin.js file and change URLs for Admin Panel Quick Menu links.

By default, the admin panel is available on all IP addresses at port 8050, like http://127.0.0.1:8050. You can change this in the .env settings. To enter the admin panel, use login apiadmin and password password. These credentials should be used only for tests, and in production you need to set up integration with the Steer Server.

If you get an error when starting the Launcher, clear the Internet Explorer cache.

Integration with Steer Server

Spoiler:

1. Install and configure the Steer Server.
2. Open Steer Web admin panel.
3. Go to Import/export section and select Import.
4. Select the file share\steer\ExportSteerData_steeradmin_API.sef and confirm import.
5. Go to Manage user section and select Add user.
6. Create new user named like imsadmin.
7. Go to Authority connect section and select Connect user - user group.
8. Select your user on left and click Add user group connection on right section.
9. In new window select group API_AdminPanel_Admin and click add.
10. Open your .env file and set STEER_ENABLE parameter to true.
11. Restart Tera API.

Spoiler:

1.
https://i.imgur.com/1j5WdGB.png

2.
https://i.imgur.com/ejSXSBp.png

3.
https://i.imgur.com/CB2uZIg.png

4.
https://i.imgur.com/m9pOgDO.png

5.
https://i.imgur.com/ZYRKoVr.png

6.
https://i.imgur.com/8XNrpXR.png

7.
https://i.imgur.com/x7t0BDi.png

The Steer Server allows you to flexibly manage permissions to certain sections of the TERA API Admin Panel. For example, you can create a new user and connect it to user group API_AdminPanel_Shop. Users in this group will only have access to Shop management functions. You can also create your own function group.

Enabling TERA Shop and Item Claim Features

Spoiler:

TERA Shop products are configured through the TERA API Admin Panel. The creation of a Service Item in the Box System occurs automatically when a product is added (using the Platform Hub).

1. Install and configure the Steer Server and Box Server (fcgi_gw is not needed).
2. Go to your TERA Server arb_gw directory and open config config_arb_gw.txt.
3. Modify the patamerer web_shop_url value as http://YOUR_API_HOST/tera/ShopAuth?authKey=%s, where YOUR_API_HOST specify your TERA API (Portal API) public host.
4. Go to your TERA Server Bin directory and open DeploymentConfig.xml.
5. Remove or comment the line <Shop url=... /> like this:
   https://i.imgur.com/1HqIrUK.png
6. Open your .env and set the API_PORTAL_SHOP_ENABLE parameter to true.
7. Restart Tera Servers and Tera API.

Thank you for your great contribution in the TERA Community @hsdn

The only thing till now i needed to edit and is not present in your guide is how to edit the default ips for the Web/Box/Steer admin webs

https://i.ibb.co/zHGxcPt/Screenshot-15.png

I Just edit them in ~\Config\admin.js

For the "How to install an update"

Every db import works except this one "00_update.sql." (and yes, i followed the order from your step by step, i just skip it)

https://i.ibb.co/KbHGfhP/Screenshot-14.png

it brings the same error whatever the tool i choose for import it (Navicat, Heidi, etc..)

https://i.ibb.co/DWBhnJd/Screenshot-16.png
https://ibb.co/c3W0dBq
https://ibb.co/c3W0dBq
https://ibb.co/c3W0dBq