secretdataz / athena-web-service Goto Github PK
View Code? Open in Web Editor NEWLightweight REST service emulator for Korean Ragnarok Online client
Lightweight REST service emulator for Korean Ragnarok Online client
I have successfully installed the web-service using. php artisan key:generate and migrate which created the sql tables correctly.
Also, changed the externalsettings_kr.lub or qm to use
AccountLinkedUserDataUrl = {
Save = "http://127.0.0.1/raweb/public/userconfig/save",
Load = "http://127.0.0.1/raweb/public/userconfig/load"
}
TwitterDataUrl = {
Auth = "127.0.0.1:3000",
Upload = "127.0.0.1:3000"
}
EmblemDataUrl = {
Upload = "http://127.0.0.1/raweb/public/emblem/upload",
Download = "http://127.0.0.1/raweb/public/emblem/download"
}
And run a tcpdump on the server which outputs..
Upon login:
Request: POST /raweb/public/userconfig/load HTTP/1.1/
Response: Internal Server Error
which leads to emblem upload:
Request: POST /raweb/public/emblem/upload HTTP/1.1/
Response: Internal Server Error
Question is, what could be the possible reason why the server is responding internal server 500?
php artisan migrate
Migration table created successfully.
Migrating: 2020_05_13_154802_create_user_configs_table
In Connection.php line 671:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; c
heck the manual that corresponds to your MariaDB server version for the right syntax to use nea
r 'json not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine' at line 1
(SQL: create table `user_configs` (`account_id` int unsigned not null, `world_name` varchar(255
) not null, `data` json not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' en
gine = InnoDB)
In Connection.php line 458:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; c
heck the manual that corresponds to your MariaDB server version for the right syntax to use nea
r 'json not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine' at line 1
I have successfully upload and download emblem and it's showing on my client.
However, it doesn't work for other player or users. Is this because of same_ip config? It's true by default.
Using latest commit.
Upon login, the POST /public/userconfig/load replies with a 401 Unauthorized response.
-- I have already changed the 'allowed_worlds' => ['TestServer'],
POST /public/emblem/upload or download returns OK response however emblem doesn't show.
-- Not sure if (1) has to be OK for emblem to show.
I noticed that upon failing for userconfig it falls down to a different server which is 112.175.128.140 (see image below)
Moreover, I noticed that the fallback packet to 112.175.x IP sends a lot of information which includes GID, AuthToken as shown below. (left -fallback ip | right is webservice IP)
When trying to use artisan migrate, I am having problems with the key size.
Operating System: CentOS 7.
PHP 7.3
In Connection.php line 671:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key len
gth is 767 bytes (SQL: alter table `user_configs` add unique `user_configs_account_id_world_nam
e_unique`(`account_id`, `world_name`))
In Connection.php line 464:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key len
gth is 767 bytes
the user_config table was created, but the guild_emblem was not.
Excuse me, I would like to ask, besides modifying the two files of .env and athena.php, what else needs to be modified?
And rathena, do you need to make any changes?
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.