Giter Club home page Giter Club logo

athena-web-service's People

Contributors

dependabot[bot] avatar secretdataz avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar

athena-web-service's Issues

[Sort of Question] Server Reponse Code Error 500

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?

Example of the tcpdump output shown below.
image

php artisan migrate

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


Unauthorized Reply from Server

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.

Several Issues/Question

Using latest commit.

  1. Upon login, the POST /public/userconfig/load replies with a 401 Unauthorized response.
    -- I have already changed the 'allowed_worlds' => ['TestServer'],

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

  3. I noticed that upon failing for userconfig it falls down to a different server which is 112.175.128.140 (see image below)
    image

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

Syntax error or access violation: 1071 Specified key was too long; max key length

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.

Conection Failure

my client
2019-08-28aRagexe

my lua files:

EmblemDataUrl = {
	Upload = "http://xxx.xxx.xxx.xxx:8000/public/upload",
	Download = "http://xxx.xxx.xxx.xxx:8000/public/download"
}

i only got Type 3.

unknown3
unknown2
unknown1

Some questions would like to ask!

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?

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.