TERA Steer Server + Box Server (Item Claim System)

[2356579199]

Login failed!!!
ID? password?

Box Web Admin panel:

You must be registered to see links

or http://YOUR_SERVER_IP:8070/
Steer Web Admin panel:

You must be registered to see links

or http://YOUR_SERVER_IP:8060/
Logins: boxadmin and steeradmin
Password: password

 

[hnzero]

ajaxHandler.py It should be that this file encoding does not support UTF-8?It should be that this file encoding does not support UTF-8, is there an updated file?

 

[hsdn]

ajaxHandler.py It should be that this file encoding does not support UTF-8?It should be that this file encoding does not support UTF-8, is there an updated file?
View attachment 199238

You need to set "code_page=utf-8" and "nation_code=en" in the steeradminweb.ini and boxadminweb.ini config files.

 

[hnzero]

You need to set "code_page=utf-8" and "nation_code=en" in the steeradminweb.ini and boxadminweb.ini config files.

This is half Chinese and half English. Didn't it update well there?

 

[hsdn]

This is half Chinese and half English. Didn't it update well there?

The shop database that comes with the API is an example. It was created based on the EUR datacenter, so when using a TW client or TW datacenter, some of the items will not have names (sets of items differ for different regions). You need to add items to the shop that are used by the TW client yourself.

 

[hnzero]

code_page=gb2312

Successful one, the other has problems. （Box System code_page=gb2312）

 

[hsdn]

Successful one, the other has problems. （Box System code_page=gb2312）
View attachment 235518

You need to use code_page=utf-8 at all. Also make sure box and steer database is created with the utf8 encoding and utf8_unicode_ci collation (refer to the manual on the first page).

 

[Kuralsizvs]

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:

You must be registered to see links

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:
   You must be registered to see links
   or
   You must be registered to see links
   
   Steer Web Admin panel:
   You must be registered to see links
   or
   You must be registered to see links
   
   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:
   View attachment 233879
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.

i am getting this error boxserver

 

[hsdn]

i am getting this error boxserver

View attachment 236238

The error says that there is no version information in the box2db database.
Make sure you have imported all *.sql files in the given order.

 

[Kuralsizvs]

The error says that there is no version information in the box2db database.
Make sure you have imported all *.sql files in the given order.

I installed it in order like you, but the upgrade db is empty, it doesn't load it.
please wait i will delete and upload again.

 

[hsdn]

View attachment 236239

I installed it in order like you, but the upgrade db is empty, it doesn't load it.
please wait i will delete and upload again.

You need to import the file BOX_data_2.16.1.db50.sql, it contains information of the database version.

 

[Kuralsizvs]

You need to import the file BOX_data_2.16.1.db50.sql, it contains information of the database version.

why

 

[hsdn]

why

View attachment 236242

The problem may be caused by an invalid collation specified when creating the database. Note that when creating the database, you must specify utf8_unicode_ci, not utf8_general_ci. Check the SteerServer console log for errors.

 

[Kuralsizvs]

The problem may be caused by an invalid collation specified when creating the database. Note that when creating the database, you must specify utf8_unicode_ci, not utf8_general_ci. Check the SteerServer console log for errors.

box and steer worked for me

it worked but what should be the execution order.
1.HUB
2.HUB_GW
3.1. BoxAPI
4.steerserver full
5.boxadminweb
6.steerweb
7.Tera-Api
8.Topography
9.ARB_GW
10.ArbiterServer
11.Wordl

is this right the way i run it?
if not correct please tell the exact order

 

[Archgeus]

box and steer worked for me

it worked but what should be the execution order.
1.HUB
2.HUB_GW
3.1. BoxAPI
4.steerserver full
5.boxadminweb
6.steerweb
7.Tera-Api
8.Topography
9.ARB_GW
10.ArbiterServer
11.Wordl

is this right the way i run it?
if not correct please tell the exact order

Check here at step 9

 

[Robyson]

I keep it that way and for me it's great...

 

[outlanderzor]

I'm sharing this in case someone else comes across the same problem I experienced.

Check if the 'lower_case_table_names' variable in your MySQL is set to 1, especially if you're using MySQL on Linux. The Steer Server application utilizes Pascal case notation for table names, and if 'lower_case_table_names' is set to 0, the app will incorrectly report that the table doesn't exist.

To resolve this issue, I made a modification to my container command by setting it to 'mysqld' with the parameter '--lower_case_table_names=1'.

 

[X0RPR0]

When i replace the WebApp.dll or change the login name cannot login to the normal WebAdmin panel anymore,

2023-07-09 12:32 ReportDB에 연결하지 못했습니다. [serverName: TERA测试] [serverNo: 1]
2023-07-09 12:32 DB Connection string is empty.
2023-07-09 12:32 WebApp
2023-07-09 12:32  Line Number : 0
2023-07-09 12:32    at WebApp.DBConnection.TestDbConnectionString(String connStr)
   at WebApp.WebAdminDB.ReLoadServer()

is then spamming the WebApp Error log



Exeption Log:

??-------------AppExceptioin--------------
??Time : 19:51:20
WebAdmin database connection error [connectionString=Data Source={SQL Server};Server=127.0.0.1;Database=WebAppDB;UID=sa;PWD=U6SjJk3ZyQhrv5tq;]

Database Log:

[07.09 11:21] Actual Queries...
[07.09 11:32] Actual Queries...
[07.09 11:55] Actual Queries...
[07.09 12:09] Actual Queries...
[07.09 12:28] Actual Queries...
[07.09 12:32] Actual Queries...
[07.09 13:21] Actual Queries...
[07.09 13:22] Actual Queries...
[07.09 13:31] Actual Queries...

Is anyone able to tell me where i failed ?

I also tried to follow this guide :
(Video) TERA Retail Server Installation | WebApp/Item Claim Setup | Proxy Server Setup

But it wont let me login either.
if i revert the changes and loginto WebTool without steer it wont let me add/edit/search anything besides showing me the Current Server Status

 

[SarahB87]

When i replace the WebApp.dll or change the login name cannot login to the normal WebAdmin panel anymore,

2023-07-09 12:32 ReportDB에 연결하지 못했습니다. [serverName: TERA测试] [serverNo: 1]
2023-07-09 12:32 DB Connection string is empty.
2023-07-09 12:32 WebApp
2023-07-09 12:32  Line Number : 0
2023-07-09 12:32    at WebApp.DBConnection.TestDbConnectionString(String connStr)
   at WebApp.WebAdminDB.ReLoadServer()

is then spamming the WebApp Error log



Exeption Log:

??-------------AppExceptioin--------------
??Time : 19:51:20
WebAdmin database connection error [connectionString=Data Source={SQL Server};Server=127.0.0.1;Database=WebAppDB;UID=sa;PWD=U6SjJk3ZyQhrv5tq;]

Database Log:

[07.09 11:21] Actual Queries...
[07.09 11:32] Actual Queries...
[07.09 11:55] Actual Queries...
[07.09 12:09] Actual Queries...
[07.09 12:28] Actual Queries...
[07.09 12:32] Actual Queries...
[07.09 13:21] Actual Queries...
[07.09 13:22] Actual Queries...
[07.09 13:31] Actual Queries...

Is anyone able to tell me where i failed ?

I also tried to follow this guide :
(Video) TERA Retail Server Installation | WebApp/Item Claim Setup | Proxy Server Setup

But it wont let me login either.
if i revert the changes and loginto WebTool without steer it wont let me add/edit/search anything besides showing me the Current Server Status

It's not much help but I can tell you that your not alone..I have this very same problem. I was advised to change my computer..which i am in the process of doing. I'll keep you informed if i make any progress. See page 3 of video-tera-retail-server-installation-webapp-item-claim-setup-proxy-server-setup.

 

[X0RPR0]

It's not much help but I can tell you that your not alone..I have this very same problem. I was advised to change my computer..which i am in the process of doing. I'll keep you informed if i make any progress. See page 3 of video-tera-retail-server-installation-webapp-item-claim-setup-proxy-server-setup.

Ty currently i just settled on not using steer for Login to the webapp and its dooing the job for now.

I even tried reinstalling everything from zero on a New machine