TERA Steer Server + Box Server (Item Claim System)

[vileninja]

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?

 

[vileninja]

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

 

[TieLay]

Python version is?

 

[vileninja]

Python version is?

2.6 32bit

 

[hsdn]

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.

 

[vileninja]

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.

 

[TieLay]

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

And import was without errors or skip lines?

 

[vileninja]

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?

 

[angerthosenear]

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!

 

[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)

 

[angerthosenear]

@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!

 

[vileninja]

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...

 

[fitnessguy0]

I downloaded the 100 version from here

https://forum.ragezone.com/f797/tera-level-100-version-1205489/

Is that version contained item claim systerm that u said?

 

[Archgeus]

I downloaded the 100 version from here

https://forum.ragezone.com/f797/tera-level-100-version-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

 

[fitnessguy0]

Sloved。。。。。

 

[Archgeus]

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.

You must be registered to see links

Same thing but for Robyson v92.03 VM

 

[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.

You must be registered to see links

UPDATE: Still doesnt work at all. I used the patch given above by @argeus99 and it still persists. this is the error still

You must be registered to see links

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.

 

[Archgeus]

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.

You must be registered to see links

UPDATE: Still doesnt work at all. I used the patch given above by @argeus99 and it still persists. this is the error still

You must be registered to see links

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

 

[voxelkitten]

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

 

[mesmoro]

can anyone help me with this error?