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

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