search

Sarjuuk / aowow

Database viewer for TrinityCore based on aowow by @LordJZ, based on the JS-Engine of Wowhead
204 stars 217 forks source link

The site is not displaying correctly #424

Closed jzizka91 closed 5 months ago

jzizka91 commented 5 months ago

Hi again,

for some reason, I'm not able to properly display the site. SSL is not currently set up yet and site seems to be configured correctly. Please see the site config below.

Both STATIC_HOST and SITE_HOST is public IP of the web server.

Any idea what could be the issue? I tried a simple PHP app and that worked. What is the difference between STATIC_HOST and SITE_HOST ?

Screenshot 2024-06-13 202223

root@18a0deec6d9d:/var/www/aowow# php aowow --siteconfig

18:18:14          select a numerical index or name to use the corresponding entry

18:18:14          =====  Site  =====
18:18:14          [0]   AOWOW  BATTLEGROUP                        [str]   "Pure Pwnage"
18:18:14          [1]   AOWOW  BOARD_URL                          [str]   "http://www.wowhead.com/forums?board="
18:18:14          [2]   AOWOW  CONTACT_EMAIL                      [str]   "feedback@aowow.org"
18:18:14          [3]   AOWOW  DEBUG                              [opt]   [x]None [ ]Error [ ]Warning [ ]Info
18:18:14          [4]   AOWOW  FORCE_SSL                          [bool]  <Disabled>
18:18:14          [5]   AOWOW  LOCALES                            [mask]  [x]English [ ]French [ ]German [ ]Chinese [ ]Spanish [ ]Russian
18:18:14          [6]   AOWOW  MAINTENANCE                        [bool]  <Disabled>
18:18:14          [7]   AOWOW  NAME                               [str]   "Aowow Database Viewer (ADV)"
18:18:14          [8]   AOWOW  NAME_SHORT                         [str]   "Aowow"
18:18:14          [9]   AOWOW  SCREENSHOT_MIN_SIZE                [int]   200
18:18:14          [10]  AOWOW  SITE_HOST                          [str]   "<WEB_SERVER_PUBLIC_IP>"
18:18:14          [11]  AOWOW  SQL_LIMIT_DEFAULT                  [int]   300
18:18:14          [12]  AOWOW  SQL_LIMIT_NONE                     [int]   0
18:18:14          [13]  AOWOW  SQL_LIMIT_QUICKSEARCH              [int]   10
18:18:14          [14]  AOWOW  SQL_LIMIT_SEARCH                   [int]   500
18:18:14          [15]  AOWOW  STATIC_HOST                        [str]   "<WEB_SERVER_PUBLIC_IP>"
18:18:14          [16]  AOWOW  TTL_RSS                            [int]   60
18:18:14          [17]  AOWOW  USER_MAX_VOTES                     [int]   50
18:18:14          =====  Caching  =====
18:18:14          [18]  AOWOW  CACHE_DECAY                        [int]   25200
18:18:14          [19]  AOWOW  CACHE_DIR                          [str]   <empty>
18:18:14          [20]  AOWOW  CACHE_MODE                         [mask]  [x]filecache [ ]memcached
18:18:14          =====  Account  =====
18:18:14          [21]  AOWOW  ACC_ALLOW_REGISTER                 [bool]  <Enabled>
18:18:14          [22]  AOWOW  ACC_AUTH_MODE                      [opt]   [x]AoWoW [ ]TC auth-table [ ]External script (config/extAuth.php)
18:18:14          [23]  AOWOW  ACC_CREATE_SAVE_DECAY              [int]   604800
18:18:14          [24]  AOWOW  ACC_EXT_CREATE_URL                 [str]   <empty>
18:18:14          [25]  AOWOW  ACC_EXT_RECOVER_URL                [str]   <empty>
18:18:14          [26]  AOWOW  ACC_FAILED_AUTH_BLOCK              [int]   900
18:18:14          [27]  AOWOW  ACC_FAILED_AUTH_COUNT              [int]   5
18:18:14          [28]  AOWOW  ACC_RECOVERY_DECAY                 [int]   300
18:18:14          =====  Session  =====
18:18:14          [29]  AOWOW  SESSION_CACHE_DIR                  [str]   <empty>
18:18:14          [30]  AOWOW  SESSION_TIMEOUT_DELAY              [int]   3600
18:18:14          [31]   PHP   session.gc_divisor                 [str]   "100"
18:18:14          [32]   PHP   session.gc_maxlifetime             [str]   "604800"
18:18:14          [33]   PHP   session.gc_probability             [str]   "1"
18:18:14          =====  Site Reputation  =====
18:18:14          [34]  AOWOW  REP_REQ_BORDER_EPIC                [int]   15000
18:18:14          [35]  AOWOW  REP_REQ_BORDER_LEGE                [int]   25000
18:18:14          [36]  AOWOW  REP_REQ_BORDER_RARE                [int]   10000
18:18:14          [37]  AOWOW  REP_REQ_BORDER_UNCO                [int]   5000
18:18:14          [38]  AOWOW  REP_REQ_COMMENT                    [int]   75
18:18:14          [39]  AOWOW  REP_REQ_DOWNVOTE                   [int]   250
18:18:14          [40]  AOWOW  REP_REQ_PREMIUM                    [int]   25000
18:18:14          [41]  AOWOW  REP_REQ_REPLY                      [int]   75
18:18:14          [42]  AOWOW  REP_REQ_SUPERVOTE                  [int]   2500
18:18:14          [43]  AOWOW  REP_REQ_UPVOTE                     [int]   125
18:18:14          [44]  AOWOW  REP_REQ_VOTEMORE_ADD               [int]   250
18:18:14          [45]  AOWOW  REP_REQ_VOTEMORE_BASE              [int]   2000
18:18:14          [46]  AOWOW  REP_REWARD_ARTICLE                 [int]   100
18:18:14          [47]  AOWOW  REP_REWARD_BAD_REPORT              [int]   0
18:18:14          [48]  AOWOW  REP_REWARD_COMMENT                 [int]   1
18:18:14          [49]  AOWOW  REP_REWARD_DAILYVISIT              [int]   5
18:18:14          [50]  AOWOW  REP_REWARD_DOWNVOTED               [int]   0
18:18:14          [51]  AOWOW  REP_REWARD_GOOD_REPORT             [int]   10
18:18:14          [52]  AOWOW  REP_REWARD_REGISTER                [int]   100
18:18:14          [53]  AOWOW  REP_REWARD_UPLOAD                  [int]   10
18:18:14          [54]  AOWOW  REP_REWARD_UPVOTED                 [int]   5
18:18:14          [55]  AOWOW  REP_REWARD_USER_SUSPENDED          [int]   -200
18:18:14          [56]  AOWOW  REP_REWARD_USER_WARNED             [int]   -50
18:18:14          =====  Google Analytics  =====
18:18:14          [57]  AOWOW  ANALYTICS_USER                     [str]   <empty>
18:18:14          =====  Profiler  =====
18:18:14          [58]  AOWOW  PROFILER_ENABLE                    [bool]  <Disabled>
18:18:14          [59]  AOWOW  PROFILER_QUEUE_DELAY               [int]   3000
18:18:14          [60]  AOWOW  PROFILER_RESYNC_DELAY              [int]   3600
18:18:14          [61]  AOWOW  PROFILER_RESYNC_PING               [int]   5000
18:18:14          =====  Other  =====
18:18:14          [62]   PHP   default_charset                    [str]   "UTF-8"
18:18:14          [63]   PHP   memory_limit                       [str]   "1500M"
18:18:14          [64]   PHP   serialize_precision                [int]   5
18:18:14          [65]         add another php configuration

OS: Ubuntu 24.04 PHP 8.0: revision used: - Browser (in case of JavaScript / display errors): - AzerothCore: no

Sarjuuk commented 5 months ago

I assume STATIC_URL and HOST_URL are the same for you In this case you should append a /static to the url so it points to the aowow/static dir.

Or give it its own static content domain if you are feeling fancy.

jzizka91 commented 5 months ago

I'm getting multiple 404s errors on the webserver. It looks like some resources within the /static dir with query parameters are not found, while others are. Weird.

14/Jun/2024:20:00:13 +0000] "GET /css/aowow.css?1718021801 HTTP/1.1" 404 5055 "http://<PUBLIC_IP>/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" "-"

[14/Jun/2024:21:39:04 +0000] "GET / HTTP/1.1" 200 3672 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" "-"

[14/Jun/2024:21:39:04 +0000] "GET /css/basic.css?1718021801 HTTP/1.1" 404 5055 "http://<PUBLIC_IP>/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" "-"

[14/Jun/2024:21:39:04 +0000] "GET /css/global.css?1718021801 HTTP/1.1" 404 5055 "http://<PUBLIC_IP>/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" "-"

14/Jun/2024:21:39:04 +0000] "GET /css/aowow.css?1718021801 HTTP/1.1" 404 5055 "http://<PUBLIC_IP>/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" "-"

[14/Jun/2024:21:39:04 +0000] "GET /css/locale_enus.css?1718021801 HTTP/1.1" 404 5055 "http://<PUBLIC_IP>/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" "-"

[14/Jun/2024:21:39:04 +0000] "GET /js/jquery-3.7.0.min.js HTTP/1.1" 200 3677 "http://<PUBLIC_IP>/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" "-"

[14/Jun/2024:21:39:04 +0000] "GET /js/basic.js?1718021802 HTTP/1.1" 404 5055 "http://<PUBLIC_IP>/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" "-"

[14/Jun/2024:21:39:04 +0000] "GET /css/home.css?1718021801 HTTP/1.1" 404 5055 "http://<PUBLIC_IP>/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" "-"

[14/Jun/2024:21:39:04 +0000] "GET /widgets/power.js HTTP/1.1" 200 3660 "http://<PUBLIC_IP>/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" "-"

[14/Jun/2024:21:39:04 +0000] "GET /js/locale_enus.js?1718021802 HTTP/1.1" 404 5055 "http://<PUBLIC_IP>/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" "-"

[14/Jun/2024:21:39:04 +0000] "GET /js/global.js?1718021802 HTTP/1.1" 404 5055 "http://<PUBLIC_IP>/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" "-"

[14/Jun/2024:21:39:04 +0000] "GET /js/locale.js?1718043586 HTTP/1.1" 404 5055 "http://<PUBLIC_IP>/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" "-"

[14/Jun/2024:21:39:04 +0000] "GET /js/Markup.js?1718043640 HTTP/1.1" 404 5055 "http://<PUBLIC_IP>/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" "-"

[14/Jun/2024:21:39:04 +0000] "GET /js/home.js?1718021802 HTTP/1.1" 404 5055 "http://<PUBLIC_IP>/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" "-"

[14/Jun/2024:21:39:04 +0000] "GET /images/logos/favicon.ico HTTP/1.1" 200 3660 "http://<PUBLIC_IP>/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" "-"

[14/Jun/2024:21:39:04 +0000] "GET /download/searchplugins/aowow.xml HTTP/1.1" 200 3659 "-" 
"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" "-"

[14/Jun/2024:21:39:08 +0000] "GET /static/ HTTP/1.1" 403 555 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" "-"

[14/Jun/2024:21:39:08 +0000] "GET /favicon.ico HTTP/1.1" 200 3648 "http://<PUBLIC_IP>/static/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" "-"
jzizka91 commented 5 months ago

I discovered the issue. The resources in the /static directory weren't being found because of a misconfiguration in my Nginx setup. Everything is working now. Thanks! aa