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
- Install the Python 2.6 to directory C:\Python26.
- Unpack the python-2.6-Lib.zip archive into the C:\Python26 directory.
- Unpack the box.zip and steer.zip archives to your TERA Server directory.
Create Database
- Open Navicat or HeidiSQL and connect to your MySQL server.
- Create two databases named box2db and steer3db.
Important! Specify the utf8 encoding with collation utf8_unicode_ci when creating the database. - 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. - 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
- Open the file box\BoxConfig.ini and set the db_user and db_passwd parameters according to your database settings.
- Open the file steerserver\SteerConfig.ini and set all db_user and db_passwd parameters according to your database settings.
- Open the file boxadminweb\boxadminweb.ini and change the value of the nation_code parameter as en.
- Open the file steerweb\steeradminweb.ini and change the value of the nation_code parameter as en.
Servers Starting
- To start the Box Server API, run the 1_Box.bat file in the box directory.
- To start the Steer Server, run the .bat files in the steer directory in order.
- 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.
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
- Unpack the archive steer_translation_EN_RU.zip to any directory.
- Go to the Steer Web panel and select 언어 데이터 가져오기 from the 가져오기/내보내기 menu:
https://i.imgur.com/sd7FGFS.png - Click File upload button and select the file L10N_DisplayGroup_steeradmin_en.csv.
- Click File upload button and select the file L10N_Function_steeradmin_en.csv.
Integration WebApp 100.02 with Steer Server
- Download the patch https://disk.yandex.ru/d/Kbl7mL85m7UQ1w.
- Unpack the patch to the WebApp\bin directory.
- 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" />
- Restart WebApp ApplicationPool or IIS Service.
- Login to Steer Web and set new password for the user gadmin:
Now you can enter WebApp panel with login gadmin and your password set via Steer.
Installation of FCGI Gateway and FCGI WebServer (optional)
Integration FCGI Gateway with TeraAPI (deprecated)
The latest version of Tera API no longer requires FCGI integration for the Item Claim system to work.
Screenshots
Official documentation available here: https://forum.ragezone.com/f797/tera...ation-1206071/
Re: TERA 92/100 Steer Server + Box Server (Item Claim System)
BOX_sp_2.16.1.db50.sql gives 173 errors in navicat
Re: TERA 92/100 Steer Server + Box Server (Item Claim System)
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.
Re: TERA 92/100 Steer Server + Box Server (Item Claim System)
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
Re: TERA 92/100 Steer Server + Box Server (Item Claim System)
BOX_schema_2.16.1.db50.sql imported without errors?
I have no problem when importing a database using HeidiSQL.
Re: TERA 92/100 Steer Server + Box Server (Item Claim System)
Quote:
Originally Posted by
hsdn
BOX_schema_2.16.1.db50.sql imported without errors?
Yes it did
Re: TERA 92/100 Steer Server + Box Server (Item Claim System)
I checked now, there are no problems when importing. The database must be encoded utf8_unicode_ci, not utf8_general_ci.
Re: TERA 92/100 Steer Server + Box Server (Item Claim System)
Character set is uft8mb3 and collation is utf8_,unicode_ci and I get the errors with navicat16
Re: TERA 92/100 Steer Server + Box Server (Item Claim System)
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!
Re: TERA 92/100 Steer Server + Box Server (Item Claim System)
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
Re: TERA 92/100 Steer Server + Box Server (Item Claim System)
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.
Re: TERA 92/100 Steer Server + Box Server (Item Claim System)
Quote:
Originally Posted by
Robson26
I don't have one called just uft8
https://postimg.cc/9zz4Kgny
Re: TERA 92/100 Steer Server + Box Server (Item Claim System)
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
Re: TERA 92/100 Steer Server + Box Server (Item Claim System)
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
Re: TERA 92/100 Steer Server + Box Server (Item Claim System)
Quote:
Originally Posted by
vileninja
That's because i'm using Navicat Premium and it works for me.