TERA 92/100 Steer Server + Box Server (Item Claim System)

Steer server is designed to manage administrator rules (integration to a WebApp and a Box Server). The Box Server is required to implement the Item Claim system. Requires Python 2.6 (x86) and MySQL 5.7 to work.

Download: https://disk.yandex.ru/d/7fkO7LbzYPrjtw

Installation

1. Install the Python 2.6 to directory C:\Python26.
2. Unpack the python-2.6-Lib.zip archive into the C:\Python26 directory.
3. Unpack the box.zip and steer.zip archives to your TERA Server directory.

Create Database

1. Open Navicat or HeidiSQL and connect to your MySQL server.
2. Create two databases named box2db and steer3db.
   Important! Specify the utf8 encoding with collation utf8_unicode_ci when creating the database.
3. Import sql files from the directory box\DB to database box2db in the following order:
   - BOX_schema_2.16.1.db50.sql
   - BOX_sp_2.16.1.db50.sql
   - BOX_data_2.16.1.db50.sql
   - BOX_update_2.16.1.db50.sql.
4. Import sql files from the directory steerserver\DB to database steer3db in the following order:
   - STEER_schema_3.3.1.db15.sql
   - STEER_sp_3.3.1.db15.sql
   - STEER_data_3.3.1.db15.sql
   - STEER_update_3.3.1.db15.sql.

Configuration

1. Open the file box\BoxConfig.ini and set the db_user and db_passwd parameters according to your database settings.
2. Open the file steerserver\SteerConfig.ini and set all db_user and db_passwd parameters according to your database settings.
3. Open the file boxadminweb\boxadminweb.ini and change the value of the nation_code parameter as en.
4. Open the file steerweb\steeradminweb.ini and change the value of the nation_code parameter as en.

Servers Starting

1. To start the Box Server API, run the 1_Box.bat file in the box directory.
2. To start the Steer Server, run the .bat files in the steer directory in order.
3. To start the Box Web Admin, run the Start.bat file in the boxadminweb directory.
4. To start the Steer Web Admin, run the Start.bat file in the steerweb directory.
   
   Box Web Admin panel: http://127.0.0.1:8070/ or http://YOUR_SERVER_IP:8070/
   Steer Web Admin panel: http://127.0.0.1:8060/ or http://YOUR_SERVER_IP:8060/
   Logins: boxadmin and steeradmin
   Password: password

Import the Translation

1. Unpack the archive steer_translation_EN_RU.zip to any directory.
2. Go to the Steer Web panel and select 언어 데이터 가져오기 from the 가져오기/내보내기 menu:
   https://i.imgur.com/sd7FGFS.png
3. Click File upload button and select the file L10N_DisplayGroup_steeradmin_en.csv.
4. Click File upload button and select the file L10N_Function_steeradmin_en.csv.

Integration WebApp 100.02 with Steer Server

1. Download the patch https://disk.yandex.ru/d/Kbl7mL85m7UQ1w.
2. Unpack the patch to the WebApp\bin directory.
3. Open the file WebApp\AppResource\WebAppConfig.xml and change like that:
   
   Code:

   ---

     <SteerServer addr="127.0.0.1" port="8105" />
  <Admin id="gadmin" />
  <DbSync option="execute" />

   ---

4. Restart WebApp ApplicationPool or IIS Service.
5. Login to Steer Web and set new password for the user gadmin:
   
   Spoiler:

   https://i.ibb.co/6FqNpzT/Captura.png
   Now you can enter WebApp panel with login gadmin and your password set via Steer.

Installation of FCGI Gateway and FCGI WebServer (optional)

Spoiler:

1. Unpack the fcgi_gw.zip and fcgi_webapi.zip archives to your TERA server directory.
2. To start the FCGI Gateway, run the Start.bat file in the fcgi_gw directory.
3. To start the FCGI WebServer (nginx), run the Start.bat file in the fcgi_webapi directory.
4. The FCGI Web API will be available by default at: http://127.0.0.1:8020/
   To send an Item Box to a player, you need to send a POST request in JSON to the /make_box.json endpoint.
   Then send a GET request to the /box_noti endpoint so that the user receives a Item Claim notification.
   
   FCGI Web API reference description available here: https://disk.yandex.ru/i/-SVs5f3nk5vklg
   Requests scheme:
   
   Spoiler:

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

Integration FCGI Gateway with TeraAPI (deprecated)
The latest version of Tera API no longer requires FCGI integration for the Item Claim system to work.

Spoiler:

Integration with old version of Tera API:

1. Make sure that the Box System and the FCGI Gateway Web Server are configured correctly (see previous steps).
2. Go to the Box Web panel and create Service Items that will be sent when the premium is activated.
3. Open the config file config\chronoScroll.js and customize the boxContext section according to your preferences. Service Item ids must be specified as item_id.
4. Open your .env config file and change parameter API_PORTAL_FCGI_GW_WEBAPI_ENABLE to true.
   Change parameter API_PORTAL_FCGI_GW_WEBAPI_URL if necessary.
5. Restart tera-api.
   
   Spoiler:

   https://www.youtube.com/watch?v=JqotAPZGdTo

Screenshots

Spoiler:

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

https://i.imgur.com/6p3AwFl.png

Official documentation available here: https://forum.ragezone.com/f797/tera...ation-1206071/

BOX_sp_2.16.1.db50.sql gives 173 errors in navicat

Quote:

---

Originally Posted by vileninja

BOX_sp_2.16.1.db50.sql gives 173 errors in navicat

---

You need to follow the order when importing files, as the instructions.

Quote:

---

Originally Posted by hsdn

You need to follow the order when importing files, as the instructions.

---

I ran BOX_sp_2.16.1.db50.sql as the 2nd sql

I also get 92 errors on the STEER_sp_3.3.1.db15.sql I also ran this one as the 2nd sql

BOX_schema_2.16.1.db50.sql imported without errors?
I have no problem when importing a database using HeidiSQL.

Quote:

---

Originally Posted by hsdn

BOX_schema_2.16.1.db50.sql imported without errors?

---

Yes it did

I checked now, there are no problems when importing. The database must be encoded utf8_unicode_ci, not utf8_general_ci.

Character set is uft8mb3 and collation is utf8_,unicode_ci and I get the errors with navicat16

Importing databases is working fine from navicat and heidi sql

I'm stuck at "Integration WebApp 100.02 with the Steer Server" the provided password is not working for me, tried lower and upper case without luck

For those people who has the same problem as me, check this.

https://i.ibb.co/6FqNpzT/Captura.png
@hsdn thanks for your support!

Quote:

---

Originally Posted by vileninja

Character set is uft8mb3 and collation is utf8_,unicode_ci and I get the errors with navicat16

---

Use utf8, then uf8_unicode_ci

https://postimg.cc/mc0nHs2G

Tested on 92.03...

https://postimg.cc/JykLgKsM

Quote:

---

Originally Posted by argeus99

Importing databases is working fine from navicat and heidi sql

I'm stuck at "Integration WebApp 100.02 with the Steer Server" the provided password is not working for me, tried lower and upper case without luck

---

You can try change password of gadmin user in Steer Web panel.

Quote:

---

Originally Posted by Robson26

Use utf8, then uf8_unicode_ci

https://postimg.cc/mc0nHs2G

Tested on 92.03...

https://postimg.cc/JykLgKsM

---

I don't have one called just uft8

https://postimg.cc/9zz4Kgny

So i am running into a block when creating the DB, i dont have a flat out the option to choose: utf8_unicode_ci
I only have these encodings and i am clueless as to which to choose:

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

Quote:

---

Originally Posted by dziobus

So i am running into a block when creating the DB, i dont have a flat out the option to choose: utf8_unicode_ci
I only have these encodings and i am clueless as to which to choose:

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

---

Keep in mind is on MySQL not MSSQL

Quote:

---

Originally Posted by vileninja

I don't have one called just uft8

https://postimg.cc/9zz4Kgny

---

That's because i'm using Navicat Premium and it works for me.

OK so managed to make the DB and imports worked without issues but when starting the box api i get this:
https://i.imgur.com/P36n3Yz.png
EEDIT: nvm, after startingthe first part of the game server it jumped to "server ready" lol

Quote:

---

Originally Posted by dziobus

nvm, after startingthe first part of the game server it jumped to "server ready" lol

---

Yes, you need to start the tera server hub and hub_gw first.

Different issue, but perhaps i am doing something wrong:

I cannot access the pages: 127.0.0.1:8060 or 127.0.0.1:8070.
When going to the WebApp ip i used to go to: 127.0.0.1:5000 i get to the login screen but none of the logins work.

Any suggestions?

Quote:

---

Originally Posted by dziobus

Different issue, but perhaps i am doing something wrong:

I cannot access the pages: 127.0.0.1:8060 or 127.0.0.1:8070.
When going to the WebApp ip i used to go to: 127.0.0.1:5000 i get to the login screen but none of the logins work.

Any suggestions?

---

You start boxadminweb and steerweb servers?
And for login to WebApp with Steer, you need set password for gadmin user in Steer Web Panel.

Quote:

---

Originally Posted by hsdn

You start boxadminweb and steerweb servers?
And for login to WebApp with Steer, you need set password for gadmin user in Steer Web Panel.

---

Yes i started the box api and the steer bat files in order and they all say "Server ready". How do i access the steer web panel?
According the manual the steer web panel should be at: 127.0.0.1:8060 but i cannot access that page for some reason.

Correct, but also you need to start web services:
- To start the Box Web Admin, run the Start.bat file in the boxadminweb directory.
- To start the Steer Web Admin, run the Start.bat file in the steerweb directory.

Quote:

---

Originally Posted by hsdn

Correct, but also you need to start web services:
- To start the Box Web Admin, run the Start.bat file in the boxadminweb directory.
- To start the Steer Web Admin, run the Start.bat file in the steerweb directory.

---

Well...that did the tick LOL....After uploading the translations, do i need to restart IIS?

EDIT: restarted IIs, translations work, reset gadmin password, it works...so so far I think everything is worky worky <3

Thank you for the help with my annoying questions.

Quote:

---

Originally Posted by dziobus

Well...that did the tick LOL....After uploading the translations, do i need to restart IIS?

---

Not needed, just refresh web page. And this web services not IIS, it is python.

Quote:

---

Originally Posted by Robson26

That's because i'm using Navicat Premium and it works for me.

---

I'm also using navicat premium 16 and I do t have a option. I'll try with Heidi sql

Quote:

---

Originally Posted by vileninja

I'm also using navicat premium 16 and I do t have a option. I'll try with Heidi sql

---

Weird!! for me there are places to add...
Mine is Navicat Premium 15.

https://postimg.cc/Wt7WwK2g

They changed the standard to utf84mb utf8_general_ci but that one does not work either. Not even Heidi SQL has it.


If I run this as a query it fails with a error

CREATE DATABASE mydb
CHARACTER SET utf8
COLLATE utf8_general_ci;

Quote:

---

Originally Posted by vileninja

They changed the standard to utf84mb utf8_general_ci but that one does not work either. Not even Heidi SQL has it.


If I run this as a query it fails with a error

CREATE DATABASE mydb
CHARACTER SET utf8
COLLATE utf8_general_ci;

---

HeidiSQL
https://i.imgur.com/Bki7hR5.png

Works fine:

Code:

---

CREATE DATABASE box2db CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE DATABASE steer3db CHARACTER SET utf8 COLLATE utf8_unicode_ci;

---

Quote:

---

Originally Posted by hsdn

HeidiSQL
https://i.imgur.com/Bki7hR5.png

Works fine:

Code:

---

CREATE DATABASE box2db CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE DATABASE steer3db CHARACTER SET utf8 COLLATE utf8_unicode_ci;

---

---

What MySQL version?

- - - Updated - - -

https://postimg.cc/67Dzr2jy
That's what I get with CREATE DATABASE box2db CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Quote:

---

Originally Posted by vileninja

What MySQL version?

---

MySQL 5.7.38

- - - Updated - - -

Quote:

---

Originally Posted by vileninja

https://postimg.cc/67Dzr2jy
That's what I get with CREATE DATABASE box2db CHARACTER SET utf8 COLLATE utf8_unicode_ci;

---

Check your query.

Ok i had a typo in the query. The only way for it to allow me to make the database that way is with
CREATE DATABASE steer3db CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE DATABASE box2db CHARACTER SET utf8 COLLATE utf8_unicode_ci;

BUT it still dont let me import the sql

[SQL] Query BOX_sp_2.16.1.db50 start
[ERR] 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
[ERR] -- Script was generated by Devart dbForge Studio for MySQL, Version 4.50.342.0
-- Script date 2011-11-11 오후 1:43:57
-- Server version: 5.1.41-3ubuntu12.10
-- Client version: 4.1

--
-- Disable foreign keys
--
/*!40014 SET @old_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

--
-- Set character set the client will use to send SQL statements to the server
--
SET NAMES 'utf8';
--
-- Definition for procedure P_CreateBox
--
DROP PROCEDURE IF EXISTS P_CreateBox;
CREATE PROCEDURE P_CreateBox(
IN in_receiverServiceSN INT,
IN in_receiverUserSN BIGINT,
IN in_receiverGUSID INT,
IN in_receiverCharacterSN INT,
IN in_receiverCharacterName VARCHAR(50),

IN in_senderUserSN BIGINT,
IN in_senderGUSID INT,
IN in_senderCharacterSN INT,
IN in_senderCharacterName VARCHAR(50),

IN in_createEndPointCode INT,
IN in_createDateTime DATETIME,
IN in_externalTransactionKey INT,
IN in_startActivationDateTime DATETIME,
IN in_endActivationDateTime DATETIME,
IN in_activateDurationAfterOpen INT,
IN in_visableFlagBeforeActivation INT,
IN in_boxEventSN INT,

IN in_boxTagInfo TEXT,
IN in_boxServiceItemInfo TEXT,

IN in_boxTransactionSN BIGINT UNSIGNED,
IN in_globalUniqueFunctionID INT UNSIGNED,

OUT out_returnCode INT,
OUT out_boxSN BIGINT
)
MAIN:
BEGIN
-- 변수 정의
DECLARE boxEventSN_ INT DEFAULT NULL;
DECLARE boxSN_ BIGINT DEFAULT 0;
DECLARE boxItemSN_ BIGINT DEFAULT 0;
DECLARE boxTransactionStateCode_ TINYINT UNSIGNED;
DECLARE isUpdateBoxTransactionResult_ TINYINT UNSIGNED DEFAULT 0;

DECLARE boxTagSN_ INT;
DECLARE boxTagSNString_ TEXT;
DECLARE boxTagValue_ TEXT;

DECLARE serviceItemSN_ INT;
DECLARE serviceItemSNString_ TEXT;
DECLARE externalItemKeyString_ TEXT;

DECLARE serviceItemTagSN_ INT;
DECLARE serviceItemTagSNString_ TEXT;
DECLARE serviceItemTagValue_ TEXT;

-- loop에 쓸 변수 선언
DECLARE splitIndex_ INT DEFAULT 1;
DECLARE loopCount_ INT DEFAULT 0;
DECLARE boxTagCount_ INT DEFAULT 0;
DECLARE innerLoopCount_ INT DEFAULT 0;
DECLARE boxServiceItemCount_ INT DEFAULT 0;
DECLARE boxServiceItemTagCount_ INT DEFAULT 0;

SET out_returnCode = 0x17000000;

-- Receiver에 대한 유효성 검사
IF in_receiverServiceSN IS NULL OR in_receiverUserSN IS NULL THEN
SET out_returnCode = out_returnCode + 1700;
LEAVE MAIN;
END IF;

START TRANSACTION;

-- boxTransactionSN 입력이 있는 경우 검사
IF in_boxTransactionSN IS NOT NULL AND in_globalUniqueFunctionID IS NOT NULL THEN
-- 입력된 boxTransactionSN을 이용하여 boxTransactionStateCode를 조회한다.
SELECT boxTransactionStateCode INTO boxTransactionStateCode_
FROM box_transaction
WHERE boxTransactionSN = in_boxTransactionSN LIMIT 1;

-- boxTransactionStateCode_가 NULL인 경우는 존재하지 않는 boxTransactionSN인 경우이므로 에러처리 한다.
IF boxTransactionStateCode_ IS NULL THEN
SET out_returnCode = out_returnCode + 1704;
ROLLBACK;
LEAVE MAIN;
END IF;

-- 1 : 박스 생성을 정상적으로 진행한다.
-- 2 : 이미 사용 된 boxTransactionSN 이므로 에러를 반환 한다.
-- 3 : release된 boxTransactionSN 이므로 에러를 반환 한다.
CASE boxTransactionStateCode_
WHEN 1 THEN
UPDATE box_transaction
SET boxTransactionStateCode = 2,
boxTransactionGlobalUniqueFunctionID = in_globalUniqueFunctionID
WHERE boxTransactionSN = in_boxTransactionSN LIMIT 1;
SET isUpdateBoxTransactionResult_ = 1;
WHEN 2 THEN
SET out_returnCode = out_returnCode + 1705;
ROLLBACK;
LEAVE MAIN;
WHEN 3 THEN
SET out_returnCode = out_returnCode + 1706;
ROLLBACK;
LEAVE MAIN;
END CASE;
END IF;

-- 박스 정보 기록
INSERT box (recei
[SQL] Finished with error

Try to execute this query before importing:

Code:

---

SET GLOBAL log_bin_trust_function_creators = 1;

---

More info about your error: https://stackoverflow.com/questions/...nary-logging-i

Quote:

---

Originally Posted by hsdn

Try to execute this query before importing:

Code:

---

SET GLOBAL log_bin_trust_function_creators = 1;

---

More info about your error: https://stackoverflow.com/questions/...nary-logging-i

---

That fixed it. Thank you

- - - Updated - - -

I can not get the box server or steer to come up soon as they open they close

I am running into a weird issue, I have unpacked the lib directory to python, but I am still getting this:
https://i.gyazo.com/337ed4f20a0a260d...708e775ce2.png




EDIT: Nvm, probably some error when unpacking zip, now it works perfectly.

Quote:

---

Originally Posted by Dakado

I am running into a weird issue, I have unpacked the lib directory to python, but I am still getting this:

---

Try to uninstall all python versions and install only Python 2.6 from my share and unpack Lib as C:\Python26\Lib.

Now my box server is running, but it seems like I cannot import the language pack, it says failed:
https://i.gyazo.com/1216c16af2be2709...ca6f98c84b.png

Quote:

---

Originally Posted by Dakado

Now my box server is running, but it seems like I cannot import the language pack, it says failed:

---

Try to place language csv files on the root level of C:\ drive.

question:

In the box panel, i am not able to search or add an item. Do we need to populate a list somewhere?

Quote:

---

Originally Posted by hsdn

Try to place language csv files on the root level of C:\ drive.

---

Unfortunately that did not helped, still the same problem.


EDIT: Sorry I am retarded, I tried to import it into box server instead of steer server web.

Quote:

---

Originally Posted by dziobus

question:

In the box panel, i am not able to search or add an item. Do we need to populate a list somewhere?

---

You need to create a service item and insert it to box or box template.

Quote:

---

Originally Posted by hsdn

You need to create a service item and insert it to box or box template.

---

So i created the service item, and this is how the box i created looks like, but it does not show in game on the item claim of the character i tested. I see it entered in the box2db ans i see it in the box list:
https://i.imgur.com/LaTp15O.png

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

EDIT: Figured out the issue....Timezone was the problem. LOL Apparently the time zone was set so the box was not activated yet LOL

Question: Is there a way to send Account wide items to item claim if so how?

Working like a charm! tysm for sharing and all your hard work @hsdn
https://i.imgur.com/SnHfJWB.png

Quote:

---

Originally Posted by dziobus

Question: Is there a way to send Account wide items to item claim if so how?

---

Yes, just leave empty Character number and Character name fields.

Quote:

---

Originally Posted by hsdn

Try to uninstall all python versions and install only Python 2.6 from my share and unpack Lib as C:\Python26\Lib.

---

So exists way send to frendzone for Python 3.9?

This has not been tested, I think it will require a change in the source code. But you can just extract python 2.6 to C: drive as shown above. There is no problem in this.

- - - Updated - - -

Added basic information about integration Item Claim
https://forum.ragezone.com/f797/tera...erver-1206086/

What does it mean when box server and steer server just close when you open them?

Quote:

---

Originally Posted by vileninja

What does it mean when box server and steer server just close when you open them?

---

Python and Lib is not installed or installed incorrectly.

@hsdn i set up all like in the guide. when i try to login into both steer and box with respective login/pass i have this error on the screen and can't login:

No message defined as error code exists. [184549126]

Any Tip? ( Tera 100.02 )

Thanks in Advance

Quote:

---

Originally Posted by hsdn

Python and Lib is not installed or installed incorrectly.

---

I have python26 in C drive root and have put the libs in the Lib directory and overwrote the files. I can run a Python console so its defiantly installed.

This is the error

Traceback (most recent call last):
File "BoxAPI.py", line 15, in <module>
from pyCruise.DB import GetDBVersion, CheckDBTimeZone
File "C:\TERA_SERVER\box\pyCruise\DB.py", line 13, in <module>
import MySQLdb
File "C:\Python26\lib\site-packages\MySQLdb\__init__.py", line 19, in <module>
import _mysql
ImportError: DLL load failed: %1 is not a valid Win32 application.

@hsdn i also have this errors like in steer session:

Traceback (most recent call last): File "D:\TERA-Live100_02_TW\steerserver\pyCruise\DB.py", line 65, in CallProc File "C:\Python26\lib\site-packages\MySQLdb\cursors.py", line 268, in callproc self._query(q) File "C:\Python26\lib\site-packages\MySQLdb\cursors.py", line 312, in _query rowcount = self._do_query(q) File "C:\Python26\lib\site-packages\MySQLdb\cursors.py", line 276, in _do_query db.query(q)OperationalError: (1305, 'FUNCTION steer3db.Func_MakeReturnCode does not exist')

but my install folder is: E:\Server\steer\steerserver

O.O where is that Path Cabled In? (D:\TERA-Live100_02_TW\steerserver )

Tks


--- Update:
installed mysql 5.7.33 and the problem is gone.

Quote:

---

Originally Posted by vileninja

I have python26 in C drive root and have put the libs in the Lib directory and overwrote the files. I can run a Python console so its defiantly installed.

This is the error

Traceback (most recent call last):
File "BoxAPI.py", line 15, in <module>
from pyCruise.DB import GetDBVersion, CheckDBTimeZone
File "C:\TERA_SERVER\box\pyCruise\DB.py", line 13, in <module>
import MySQLdb
File "C:\Python26\lib\site-packages\MySQLdb\__init__.py", line 19, in <module>
import _mysql
ImportError: DLL load failed: %1 is not a valid Win32 application.

---

Make sure you have Python 2.6 32bit version and MySQL 5.7 or higher installed.

Cannot access to box system. Please check server status. [436208616]

is what i get when doing anything on the box server

nice work.
i removed my stupid question :D

Any idea about this error https://postimg.cc/w1d6JLWb

Quote:

---

Originally Posted by vileninja

Any idea about this error https://postimg.cc/w1d6JLWb

---

check logs and consoles output, possible U can see errors origin in there...

Quote:

---

Originally Posted by TieLay

check logs and consoles output, possible U can see errors origin in there...

---

the logs nor console say anything about any error

- - - Updated - - -

Only thing in the console is

[17/Jun/2022:01:44:45] ENGINE Bus STARTED
50.82.43.247 - - [17/Jun/2022:01:44:49] "GET /main HTTP/1.1" 200 7981 "http://167.114.208.196:8070/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:101.0) Gecko/20100101 Firefox/101.0"
[17/Jun/2022:01:44:49] ENGINE Started monitor thread 'Monitor'.
50.82.43.247 - - [17/Jun/2022:01:44:49] "POST /getL10NResources HTTP/1.1" 200 11762 "http://127.0.0.1:8070/main" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:101.0) Gecko/20100101 Firefox/101.0"
50.82.43.247 - - [17/Jun/2022:01:44:49] "GET /getCurrentUserInfo HTTP/1.1" 200 184 "http://127.0.0.1:8070/main" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:101.0) Gecko/20100101 Firefox/101.0"
50.82.43.247 - - [17/Jun/2022:01:44:49] "GET /getTopMenuList HTTP/1.1" 200 4546 "http://127.0.0.1:8070/main" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:101.0) Gecko/20100101 Firefox/101.0"
50.82.43.247 - - [17/Jun/2022:01:44:49] "GET /getLeftMenuList HTTP/1.1" 200 164 "http://127.0.0.1:8070/main" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:101.0) Gecko/20100101 Firefox/101.0"
50.82.43.247 - - [17/Jun/2022:01:44:52] "GET /getPageServiceItemTag?sort=serviceItemTagSN&dir=asc&startIndex=0&results=10&key=GetPageServiceItemTag&enableFlag=1 HTTP/1.1" 200 142 "http://127.0.0.1:8070/main" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:101.0) Gecko/20100101 Firefox/101.0"

Check console logs of steer server and box api.

Quote:

---

Originally Posted by hsdn

Check console logs of steer server and box api.

---

There is nothing in the logs that show any errors or anything weird

Quote:

---

Originally Posted by vileninja

There is nothing in the logs that show any errors or anything weird

---

Please make check trough THIS link with instruction by reading !TERA_run.txt , possible problem will gone

Quote:

---

Originally Posted by TieLay

Please make check trough THIS link with instruction by reading !TERA_run.txt , possible problem will gone

---

The server is running and I can connect to the server the box server is the issue.

Quote:

---

Originally Posted by vileninja

The server is running and I can connect to the server the box server is the issue.

---

R U was read file and compare settings?

I can't use that link it's not english. It's wanting me to make a account or something. I also have that file from before and everything is setup and running.

Quote:

---

Originally Posted by vileninja

I can't use that link it's not english. It's wanting me to make a account or something. I also have that file from before and everything is setup and running.

---

get THIS link and push on file icon

Quote:

---

Originally Posted by TieLay

get THIS link and push on file icon

---

This has all been done. I go to the box admin page login and try to do anything it says that message

Hello, where can I find the RU client for the server?
Can i use this: https://disk.yandex.ru/d/mIKWjplKyYiliA?w=1 ?

Oh...its a addon to server,not server?

Quote:

---

Originally Posted by 100Rad

Hello, where can I find the RU client for the server?
Can i use this: https://disk.yandex.ru/d/mIKWjplKyYiliA?w=1 ?

Oh...its a addon to server,not server?

---

Yes U can, switch to Russian in TeraAPI settings,

I have checked every log file and can't seem to figure out why I get box system is not available when doing anything on the box server

Quote:

---

Originally Posted by vileninja

I have checked every log file and can't seem to figure out why I get box system is not available when doing anything on the box server

---

This can happen if the database is imported in an encoding/collation other than utf8_unicode_ci. Check this.

Quote:

---

Originally Posted by hsdn

This can happen if the database is imported in an encoding/collation other than utf8_unicode_ci. Check this.

---

I have imported the database with the query you gave before and it does this still.

Quote:

---

Originally Posted by vileninja

I have imported the database with the query you gave before and it does this still.

---

An import itself is not what he means. He means if the database encdoing originally is set to something else than what is specified.

Quote:

---

Originally Posted by dziobus

An import itself is not what he means. He means if the database encdoing originally is set to something else than what is specified.

---

The encoding is set to what ever it was in the sqls. Unless I'm misunderstanding what your saying

Quote:

---

Originally Posted by vileninja

The encoding is set to what ever it was in the sqls. Unless I'm misunderstanding what your saying

---

You had to create 2 new databases: box2db and steer3db. The encoding for those 2 needs to be utf8 encoding with collation utf8_unicode_ci.
If its not set to that you will get those errors is what he is saying.

Quote:

---

Originally Posted by dziobus

You had to create 2 new databases: box2db and steer3db. The encoding for those 2 needs to be utf8 encoding with collation utf8_unicode_ci.
If its not set to that you will get those errors is what he is saying.

---

That's what they are set to

Quote:

---

Originally Posted by vileninja

That's what they are set to

---

I bet you have installed Mysql latest version and not a mysql 5.7.x .

Actually, collations even UTF8 names will differ between mysql 5.7 and mysql last version. I got the same problem and i installed mysql 5.7 reloading the whole data and it's working.

Thanks again for another release.

Everything seems to be working great, no problems; but I haven't figured out if it's possible to add a permanent account-wide item?

Such as a account-wide mount that players will be able to claim on each character. Is this possible with this? I don't see a way to do this, as even when you create a service item without a character ID it just creates a one-use item claim. Perhaps there's something else I am not seeing?

now i get this with mysql 5.7 No message defined as error code exists. [184549126]

Quote:

---

Originally Posted by LordVenom

Thanks again for another release.

Everything seems to be working great, no problems; but I haven't figured out if it's possible to add a permanent account-wide item?

Such as a account-wide mount that players will be able to claim on each character. Is this possible with this? I don't see a way to do this, as even when you create a service item without a character ID it just creates a one-use item claim. Perhaps there's something else I am not seeing?

---

As hsdn mentioned earlier. for an account item:
just leave empty Character number and Character name fields.

Quote:

---

Originally Posted by dziobus

As hsdn mentioned earlier. for an account item:
just leave empty Character number and Character name fields.

---

I think he mean this https://www.youtube.com/watch?v=YtEUZ7epIW0

In account items tab like how it was for tera collectors edition and founder with terminus (speaking of eme side of course)

Has anyone figured out how to get past this error. No message defined as error code exists. [184549126]

- - - Updated - - -

Nevermind figured it out

Another great release, thanks hsdn.

Quote:

---

Originally Posted by argeus99

I think he mean this https://www.youtube.com/watch?v=YtEUZ7epIW0

In account items tab like how it was for tera collectors edition and founder with terminus (speaking of eme side of course)

---

So far I have tried multiple ways and it won't send to account items tab. Not sure what we need to do to be able to use it

Is there a way to make it so that when you have the account benifit of like found it will automatically send you the regal frost lion?

reinstalled everything on a new server and get this for the boxapi

C:\Python26\lib\site-packages\MySQLdb\__init__.py:34: DeprecationWarning: the sets module is deprecated
from sets import ImmutableSet
2022-07-01 14:11:03-0700 [-] Log opened.
2022-07-01 14:11:03-0700 [-] Box API Server Version 14738
2022-07-01 14:11:03-0700 [-] ServerID [1] Platform Hub [127.0.0.1:11001]
2022-07-01 14:11:03-0700 [-] Log [error] [log/BoxAPI.log]
2022-07-01 14:11:03-0700 [-] DB Connection [127.0.0.1:3306] user [root] catalog [box2db]
2022-07-01 14:11:03-0700 [-] 'Database Version Fetch Failed [1305] [PROCEDURE box2db.P_GetDBVersion does not exist]'
2022-07-01 14:11:03-0700 [-] Traceback (most recent call last):
2022-07-01 14:11:03-0700 [-] File "BoxAPI.py", line 434, in <module>
2022-07-01 14:11:03-0700 [-] Start()
2022-07-01 14:11:03-0700 [-] File "BoxAPI.py", line 396, in Start
2022-07-01 14:11:03-0700 [-] sys.exit(1)
2022-07-01 14:11:03-0700 [-] SystemExit: 1

Python version is?

Quote:

---

Originally Posted by TieLay

Python version is?

---

2.6 32bit

Quote:

---

Originally Posted by vileninja

reinstalled everything on a new server and get this for the boxapi

---

There are no procedure tables in the database. Check if the import is correct.

Quote:

---

Originally Posted by hsdn

There are no procedure tables in the database. Check if the import is correct.

---

That is with a import and a back up of the last one.

Quote:

---

Originally Posted by vileninja

That is with a import and a back up of the last one.

---

And import was without errors or skip lines?

Quote:

---

Originally Posted by TieLay

And import was without errors or skip lines?

---

Yes it went in with no errors or skips

@hsdn i got the database back in and I am running 5.7.37 MYSQL and it gives me the box system can not be accessed at this time. Any idea?

I'm confused with some of the ports used here.

When actually trying to add a box from the web interface I get the following error.
My error shown in boxadminweb.log is:
2022-07-10 01:40:55,571, ERROR, Connect Failed, 127.0.0.1, 8000 :: Traceback (most recent call last): File "D:\TERA-Live100_02_TW\boxadminweb\modules\BoxAdminWebRequester.py", line 174, in SendAndRecv File "<string>", line 1, in connecterror: [Errno 10061] No connection could be made because the target machine actively refused it

Fairly certainly this just means the port 8000 is wrong.
I'm not seeing port 8000 actually defined anywhere else in the config files. And some of the config files seem to be using the same terms for different things?

BoxConfig:
hub_port = 11001 - I assume this is talking about the actual hub.exe process

SteerConfig:
SteerMind hub_port=8105
SteerSession hub_port=8105
SteerCast hub_port=8105
SteerGateway: port=8109, hub_port=8105
SteerHub = 8105

I'm assuming the hub_ports here all reference the SteerHub port defined.

steeradminweb:
steer_gateway_port=8109
hub_gateway_port=8109 - seems weird this is the same and not 8105 for SteerHub?

boxadminweb:
hub_gateway_port=8000 - this feels like it should be 11001 or 8105?
steer_gateway_port=8109


Basically I think the boxadmin hub port needs to be changed? But not 100% where that points to next in the chain.

Thanks!

@angerthosenear You should not change the ports, the ports specified in the configs are correct.
Port 8000 is a hub_gw port, not a platform hub (11001).
Make sure you have Tera Server/hub_gw process running and check config_hub_gw.txt.

Working ports:
8105 - steer hub (uses for SteerServer components and WebApp)
8109 - steer hub gateway (uses for SteerWeb and BoxWeb)
11001 - tera platform hub (uses for Box)
8000 - tera platform hub gateway (uses for BoxWeb)

Quote:

---

Originally Posted by hsdn

@angerthosenear You should not change the ports, the ports specified in the configs are correct.
Port 8000 is a hub_gw port, not a platform hub (11001).
Make sure you have Tera Server/hub_gw process running and check config_hub_gw.txt.

Working ports:
8105 - steer hub (uses for SteerServer components and WebApp)
8109 - steer hub gateway (uses for SteerWeb and BoxWeb)
11001 - tera platform hub (uses for Box)
8000 - tera platform hub gateway (uses for BoxWeb)

---

I didn't edit any ports. Turns out my hub_gw wasn't running for some reason. Maybe it closed during some other process restart. All seems to be working now. Thanks!

I have upgraded to 5.7.38 and it get Cannot access box system error. I dont understand.

File "D:\TERA-Live100_02_TW\boxadminweb\modules\BoxAdminWebRequester.py", line 174, in SendAndRecv
File "<string>", line 1, in connect
error: [Errno 10061] No connection could be made because the target machine actively refused it

2022-07-11 23:05:37,671, DEBUG, getPageServiceItem Response, 436208616

This is in the logs. I dont have a D: drive everything is on C im not sure where its looking for D at.

Figured it out. for some reason hub_gw was not running...

I downloaded the 100 version from here

https://forum.ragezone.com/f797/tera...rsion-1205489/

Is that version contained item claim systerm that u said?

Quote:

---

Originally Posted by fitnessguy0

I downloaded the 100 version from here

https://forum.ragezone.com/f797/tera...rsion-1205489/

Is that version contained item claim systerm that u said?

---

You need to implement the system by yourself following the 1 post of this thread

Sloved。。。。。

I made a patch for include the box, steer and fgci servers for those who download the v100.02 VM provided by @tya0411

What includes

Everything has been pre-configured... box, boxadminweb, steerserver and steerweb
**Laragon with pre-imported box/steer databases
HeidiSQL has been updated to v12

**Keep in mind that the included database are empty, so if you already created a couple of accounts then before you start the item claim server, import both databases as stated in the first post (box2db and steer3db)

What not includes
WebApp patch

Installation

Make a backup of your current laragon installation and rename it to something else
Move ItemClaimPatch.zip to D:\ and extract the content there
Install Python and Lib as described in the first post (step 1 & 2)

Start laragon, API, hub servers and then execute "Start Box & Steer Server.bat" located at server folder; then start everything else

Hope it helps. Enjoy.

Download

Same thing but for @Robyson v92.03 VM

Everything I believe is okay up to the section "Servers Starting" I'm at the Box and Steer panels and I can't log in for some reason on either one. This is the error here for one of them since they both are the same error. https://ibb.co/61RRkXF

UPDATE: Still doesnt work at all. I used the patch given above by @argeus99 and it still persists. this is the error still https://ibb.co/61RRkXF and new problem is that the Steer panel no longer pops up at the login screen only the box panel log in screen shows up. Can someone help me? Thanks you. Still not able to login at all.

Quote:

---

Originally Posted by voxelkitten

Everything I believe is okay up to the section "Servers Starting" I'm at the Box and Steer panels and I can't log in for some reason on either one. This is the error here for one of them since they both are the same error. https://ibb.co/61RRkXF

UPDATE: Still doesnt work at all. I used the patch given above by @argeus99 and it still persists. this is the error still https://ibb.co/61RRkXF and new problem is that the Steer panel no longer pops up at the login screen only the box panel log in screen shows up. Can someone help me? Thanks you. Still not able to login at all.

---

Keep in mind, my patch only works if you are using the premade vm without modifications.

If you changed the mysql password, then you have to change it in the api/box/steerfiles too

I'm using the exact pre-made vm as mentioned and never altered any passwords when setting up. So I have no idea why this is happening. It's been frustrating me since last night and haven't move on from this point :(

can anyone help me with this error?



https://uploaddeimagens.com.br/image...png?1659247104

https://uploaddeimagens.com.br/image...jpg?1659247231