wabbuwabbu
-
Content Count
20 -
Joined
-
Last visited
Posts posted by wabbuwabbu
-
-
5 hours ago, Ridley said:I had this once too. Problem was my webhost's firewall and some other security settings they had to adjust for me (it was a shared webhosting plan), e.g. allowing connections from outside and whitelist some stuff for mod_security
Hello @Ridley, thank you for the help.
I've spoken to the host provider and in their side the ports seem to be opened.
Wanting to see what's wrong with my MarianDB configuration y decided to go to:
sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf
To modify the bind-address from 127.0.0.1 to 0.0.0.0
Then I restarted the service using:sudo systemctl restart mysql.service sudo systemctl restart mariadb.service
Next step I could think of is to run a netcast to see the port 3306. This is what I found:
Good news is that the 3306 port seems to be opened and working.
The bad news is that I'm getting SQLSTATE[HY000] [2002] Connection refused
So the problem, I'm guessing its something related to the configuration in 844/./map-server and 842/./login-server.
Problem is that I don't exactly know how to access this aboved described destinations. -
28 minutes ago, Rynbef said:If u using a website outside ur local network u have to use ur public ip address. U can find on https://whatsmyip.com and this u need to add to ur Flux Config. But maybe ur IP Address changes some times therefore it's better to configure a dyndns server at ur router. Then u can insert ur dns instead of ur ip.
And on ur router u need to allow incoming connection to port 3306 (MySQL port) and for the ip of ur Webserver (cause of security).
U need to change the access of the database to "%" (any host) and on the configuration u need to allow external access.
Best regards,
Rynbef~
Thank you for your reply @Rynbef,
In servers.php, I've modified the field '192.168.1.38' to the Public IP. My idea is to make it work with the public IP first, and eventually change to a static IP.
Router ports are open. Although for some reason, in the port checker it says that the port 3306 is closed.
Database access is modified by following this commands:
use mysql; update user set host='%' where User='hercrodbusr'; flush privileges; quit
Sadly, I'm still getting SQLSTATE[HY000] [2002] Connection refused
Edit: I found in Hercules/conf/global/sql_connection.conf
sql_connection: { // [INTER] You can specify the codepage to use in your mySQL tables here. // (Note that this feature requires MySQL 4.1+) //default_codepage: "" // [LOGIN] Is `userid` in account_db case sensitive? //case_sensitive: false // For IPs, ideally under linux, you want to use localhost instead of 127.0.0.1. // Under windows, you want to use 127.0.0.1. If you see a message like // "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" // and you have localhost, switch it to 127.0.0.1 db_hostname: "localhost" db_port: 3306 db_username: "hercrodbusr" db_password: "Password" db_database: "hercrodb" //codepage:"" }
I've tried changing the db_hostname to the public IP. But when I restarted the ragnarok server it gave me a sql warning saying that it can't connect to MySQL server on "__My_PublicIP__" (115)
-
On 5/4/2020 at 3:53 PM, Zero Human said:The Exp numbers are not displayed. PRIu64 is displayed instead.
-
I’m having trouble connecting FluxCP to my server.
I have an independent host for the website (FluxCP) and then I’m running my ragnarok server through a Raspberry PI, utilizing my Public IP address.
I can’t seem to connect my server.php properly.
This is how I got my server.php setup:<?php return array( // Example server configuration. You may have more arrays like this one to // specify multiple server groups (however they should share the same login // server whilst they are allowed to have multiple char/map pairs). array( 'ServerName' => 'NetRO', // Global database configuration (excludes logs database configuration). 'DbConfig' => array( //'Socket' => '/tmp/mysql.sock', //'Port' => 3306, //'Encoding' => 'utf8', // Connection encoding -- use whatever here your MySQL tables collation is. 'Convert' => 'utf8', // -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available. // -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8) 'Hostname' => '192.168.1.38', // Raspberry PI's Local IP 'Username' => 'hercrodbusr', 'Password' => 'Password', 'Database' => 'hercrodb', 'Persistent' => true, 'Timezone' => null // Example: '+0:00' is UTC. // The possible values of 'Timezone' is as documented from the MySQL website: // "The value can be given as a string indicating an offset from UTC, such as '+10:00' or '-6:00'." // "The value can be given as a named time zone, such as 'Europe/Helsinki', 'US/Eastern', or 'MET'." (see below continuation!) // **"Named time zones can be used only if the time zone information tables in the mysql database have been created and populated." ), // This is kept separate because many people choose to have their logs // database accessible under different credentials, and often on a // different server entirely to ensure the reliability of the log data. 'LogsDbConfig' => array( //'Socket' => '/tmp/mysql.sock', //'Port' => 3306, //'Encoding' => null, // Connection encoding -- use whatever here your MySQL tables collation is. 'Convert' => 'utf8', // -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available. // -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8) 'Hostname' => '192.168.1.38', // Raspberry PI's Local IP 'Username' => 'hercrodbusr', 'Password' => 'Password', 'Database' => 'hercrodb', 'Persistent' => true, 'Timezone' => null // Possible values is as described in the comment in DbConfig. ), // Login server configuration. 'LoginServer' => array( 'Address' => 'Public_IP', 'Port' => 6900, 'UseMD5' => true, 'NoCase' => true, // Hercules account case-sensitivity; Default: Case-INsensitive (true). 'GroupID' => 0, // Default account group ID during registration. //'Database' => 'ragnarok' ), 'CharMapServers' => array( array( 'ServerName' => 'NetRO', 'Renewal' => true, 'MaxCharSlots' => 9, 'DateTimezone' => null, // Specifies game server's timezone for this char/map pair. (See: http://php.net/timezones) //'ResetDenyMaps' => 'sec_pri', // Defaults to 'sec_pri'. This value can be an array of map names. //'Database' => 'ragnarok', // Defaults to DbConfig.Database 'MaxBaseLevel' => 150, 'ExpRates' => array( 'Base' => 100, // Rate at which (base) exp is given 'Job' => 100, // Rate at which job exp is given 'Mvp' => 100 // MVP bonus exp rate ), 'DropRates' => array( // The rate the common items (in the ETC tab, besides card) are dropped 'Common' => 100, 'CommonBoss' => 100, // The rate healing items (that restore HP or SP) are dropped 'Heal' => 100, 'HealBoss' => 100, // The rate usable items (in the item tab other then healing items) are dropped 'Useable' => 100, 'UseableBoss' => 100, // The rate at which equipment is dropped 'Equip' => 100, 'EquipBoss' => 100, // The rate at which cards are dropped 'Card' => 100, 'CardBoss' => 100, // The rate adjustment for the MVP items that the MVP gets directly in their inventory 'MvpItem' => 100 ), 'CharServer' => array( 'Address' => 'Public_IP', 'Port' => 6121 ), 'MapServer' => array( 'Address' => 'Public_IP', 'Port' => 5121 ), // -- WoE days and times -- // First parameter: Starding day 0=Sunday / 1=Monday / 2=Tuesday / 3=Wednesday / 4=Thursday / 5=Friday / 6=Saturday // Second parameter: Starting hour in 24-hr format. // Third paramter: Ending day (possible value is same as starting day). // Fourth (final) parameter: Ending hour in 24-hr format. // ** (Note, invalid times are ignored silently.) 'WoeDayTimes' => array( //array(0, '12:00', 0, '14:00'), // Example: Starts Sunday 12:00 PM and ends Sunday 2:00 PM //array(3, '14:00', 3, '15:00') // Example: Starts Wednesday 2:00 PM and ends Wednesday 3:00 PM ), // Modules and/or actions to disallow access to during WoE. 'WoeDisallow' => array( array('module' => 'character', 'action' => 'online'), // Disallow access to "Who's Online" page during WoE. array('module' => 'character', 'action' => 'mapstats') // Disallow access to "Map Statistics" page during WoE. ) ) ) ) ); ?>
I’ve enabled the ports 6900, 5121, 6121 and 3306 (MySQL) from my rooter and also applied them to the firewall exception in the raspberry pi. Following this method, I managed to run all the ports except 3303.
Also, I would like to point out that I activated the DMZ on my Raspberry PI, but I still get the same error error SQLSTATE[HY000] [2002] Connection refused.
Edit: This is how I created the Mysql data base in the Raspberry PI:
QuoteDROP DATABASE IF EXISTS hercrodb; CREATE DATABASE IF NOT EXISTS hercrodb DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; DROP DATABASE IF EXISTS hercrolog; CREATE DATABASE IF NOT EXISTS hercrolog DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; GRANT SELECT,INSERT,UPDATE,DELETE ON hercrodb.* TO 'hercrodbusr'@'localhost' IDENTIFIED BY '[YOUR_HERCRODBUSR_PASSWORD]'; GRANT SELECT,INSERT ON hercrolog.* TO 'hercrodbusr'@'localhost'; FLUSH PRIVILEGES;
Same names, only thing I changed was the password.
I tried changing the hostname to 'RaspberryPi'
But the error changes to: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
-
On 5/1/2020 at 12:01 PM, wabbuwabbu said:a. Values are displayed as Base: %”PRlu64” (0.00%) Job: %”PRlu64” (31.88%)
It appears to be a common problem: https://github.com/HerculesWS/Hercules/pull/2647/files
This did the work for me:Go to Hercules/conf/messages.conf and modify the following code 889: Experience Gained Base:%"PRIu64" (%.2f%%) Job:%"PRIu64" (%.2f%%) to this:
889: Experience Gained Base:%Iu64 (%.2f%%) Job:%Iu64 (%.2f%%)
-
I wonder if there's a way to have certain commands always active. So new players don’t have to wonder.
Commands like for example:
/showname@showexp
-
Found it.
Just in case it's of interest. Its located in Hercules/conf/map/battle/monster.confQuote192 // Display some mob info next to their name? (add as needed)
193 // (does not works on guardian or Emperium)
194 // 1: Display mob HP (Hp/MaxHp format)
195 // 2: Display mob HP (Percent of full life format)
196 // 4: Display mob's level
197 show_mob_info: 1
Make sure to disable the monsters health bar.
Also if the name does not appear. Type in /showname
-
I’m curious to know if it’s possible to change back to the old monster’s health bar.
For example: Poring: (50/50)
-
That did the work!
By the way @Zhao Chow it's really impressive that you knew exactly what was going on. Thank you for the help!
-
Everytime a player hits a mob this error appears in the server.
Any ideas on what could be the problem?
-
I have some problems/questions regarding my @showexp
a. Values are displayed as Base: %”PRlu64” (0.00%) Job: %”PRlu64” (31.88%)
b. One of the values does not calculate at all. Being Base level 10 and Job level 7.
c. Is there a way to always have @showexp activated for all players?
Thank you
-
Currently trying to log into the server and this appears on the server status:
Quote[Status]: Char-server 'Ragnarok Network': authentication of the account 1 REFUSED (ip: __Public_IP__).
Ports 6900, 5121 & 6121 are open and active.
-
17 hours ago, 4144 said:as i said before this probably mean because wrong grf or data directory. need use compatible grf and data with your client exe.
True, you did mention this matter before.
I'm having trouble finding a compatible grf or data directory. Do you know where I could search for a compatible one?
I'm also opened to change my client to a newer/older version if needed.
-
24 minutes ago, 4144 said:this error mean you have wrong clientinfo or sclientinfo xml file
I modified the servicetype back to <servicetype>korea</servicetype> and it fixed the error! Thank you!
Although now when I proceed to execute the client, it takes me directly to the server selection screen. If I press OK the client closes immediately.
I can’t seem to figure out the problem, it skips the login screen and jumps directly to the server selection screen.
-
20 hours ago, 4144 said:at first you used wrong client type. read here how to build hercules for this client: http://nemo.herc.ws/downloads/2018-04-18bRagexeRE/#build-hercules
Also crash may happens because you using wrong grf/data files. each client version need own version of all files. with other versions it may crash or works.
Thank you for the fast reply @4144
After downloading http://nemo.herc.ws/downloads/2018-04-18bRagexeRE/#build-hercules
I’ve patched 2018-04-18bRagexeRE.
Then proceeded to execute the client 2018-04-18bRagexeRE_Patched. While launching, a ServiceType Error appears this time. Once clicked Enter, it loads the server selection screen. If I press OK the client closes immediately.
-
I’m having trouble starting the client: 2018-04-18bRagexeRE
Server is running and packed with the following: ./configure --enable-packetver=20180418
Ports "6900, 5121, 6121" are open and working, yet when I want to create a character this error appears:
Module Name: D:\Archivos de Programa\Juegos\Gravity\RO\NetRO.exe Time Stamp: 0x5ad44028 - Mon Apr 16 08:18:16 2018 Exception Type: 0xc0000005 0x00ae481c D:\Archivos de Programa\Juegos\Gravity\RO\NetRO.exe 0x008cb04a D:\Archivos de Programa\Juegos\Gravity\RO\NetRO.exe 0x008cac0b D:\Archivos de Programa\Juegos\Gravity\RO\NetRO.exe 0x00abfd53 D:\Archivos de Programa\Juegos\Gravity\RO\NetRO.exe 0x00515894 D:\Archivos de Programa\Juegos\Gravity\RO\NetRO.exe 0x00711e2f D:\Archivos de Programa\Juegos\Gravity\RO\NetRO.exe 0x00512862 D:\Archivos de Programa\Juegos\Gravity\RO\NetRO.exe 0x00512b82 D:\Archivos de Programa\Juegos\Gravity\RO\NetRO.exe 0x005b6e12 D:\Archivos de Programa\Juegos\Gravity\RO\NetRO.exe 0x0071b934 D:\Archivos de Programa\Juegos\Gravity\RO\NetRO.exe 0x00a873ca D:\Archivos de Programa\Juegos\Gravity\RO\NetRO.exe 0x00b0dff7 D:\Archivos de Programa\Juegos\Gravity\RO\NetRO.exe 0x00b0f4f1 D:\Archivos de Programa\Juegos\Gravity\RO\NetRO.exe 0x77740419 C:\WINDOWS\System32\KERNEL32.DLL 0x77e366dd C:\WINDOWS\SYSTEM32\ntdll.dll 0x77e366ad C:\WINDOWS\SYSTEM32\ntdll.dll eax: 0x00000002 ebx: 0x0019f4d0 ecx: 0x0ee30418 edx: 0xa542066f esi: 0x0019f44c edi: 0x1a7f04f0 ebp: 0x0019ffec esp: 0x0019ffe4 stack 0019ffe4 - 001a03e4 0019FFE4 : FF FF FF FF BB 53 E5 77 00 00 00 00 00 00 00 00 0019FFF4 : C5 F3 B0 00 00 D0 39 00 00 00 00 00 41 63 74 78 001A0004 : 20 00 00 00 01 00 00 00 34 33 00 00 DC 00 00 00 001A0014 : 00 00 00 00 20 00 00 00 00 00 00 00 14 00 00 00 001A0024 : 01 00 00 00 07 00 00 00 34 00 00 00 7C 01 00 00 001A0034 : 01 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 001A0044 : 00 00 00 00 00 00 00 00 02 00 00 00 4E EF 26 1A 001A0054 : 98 02 00 00 44 00 00 00 E0 02 00 00 60 02 00 00 001A0064 : 00 00 00 00 BA 71 32 F3 40 05 00 00 4A 00 00 00 001A0074 : 8C 05 00 00 48 03 00 00 00 00 00 00 5B 49 59 2D 001A0084 : D4 08 00 00 32 00 00 00 08 09 00 00 00 03 00 00 001A0094 : 00 00 00 00 CD EA CE 32 08 0C 00 00 42 00 00 00 001A00A4 : 4C 0C 00 00 36 03 00 00 00 00 00 00 C8 5F 50 38 001A00B4 : 84 0F 00 00 5E 00 00 00 E4 0F 00 00 68 03 00 00 001A00C4 : 00 00 00 00 44 05 28 B1 4C 13 00 00 56 00 00 00 001A00D4 : A4 13 00 00 98 03 00 00 10 00 00 00 09 00 00 00 Launch Info 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 Job : Novice Renderer.cpp 700 -
Thank you 4144 for the help.
Indeed that's exactly what I was doing wrong, I jumped the step of running make plugin.
I proceeded on running: make @pk/Hercules/src/plugins# make @pk CC @pk.c PLUGIN @pkServer now runs correctly
Solved. -
Hello,
I'm currently trying to add a @pk plugin to my server.
I'm following this guide to add plugins made for linux: http://herc.ws/wiki/Building_HPM_Plugin_for_gccLet me run you through what I have done:
1st I went to my folder "Hercules/conf/" used nano to open plugins.conf and edited and added the following:
plugins_list: [ /* Enable HPMHooking when plugins in use rely on Hooking */ "HPMHooking", //"db2sql", //"sample", //"other", "@pk", ]2nd step was to go to "Hercules/src/plugins/" used nano to create @pk.c and add this code: https://github.com/dastgirp/HPM-Plugins/blob/master/src/plugins/%40pk.c
The only thing I modified from the @pk.c code was the delay timer:
int config_delay = 5; // After turn pk on/off, how many seconds delay before the player allow to pk on/off ?I changed it to 60 seconds:
int config_delay = 60; // After turn pk on/off, how many seconds delay before the player allow to pk on/off ?I'm not exactly sure if I should do any other modification apart from this one.
Right after this I started the server and the moment it started this error appeared:
[Status]: HPM: Loaded plugin 'HPMHooking' (0.2) built with HPMHooking support. [Status]: HPM: Loaded plugin 'HPMHooking' (0.2) built with HPMHooking support. [Fatal Error]: HPM:plugin_load: failed to load 'plugins/@pk.so' (error: plugins/@pk.so: cannot open shared object file: No such file or directory)! [Fatal Error]: HPM:plugin_load: failed to load 'plugins/@pk.so' (error: plugins/@pk.so: cannot open shared object file: No such file or directory)! [Status]: HPM: Loaded plugin 'HPMHooking' (0.2) built with HPMHooking support. [Fatal Error]: HPM:plugin_load: failed to load 'plugins/@pk.so' (error: plugins/@pk.so: cannot open shared object file: No such file or directory)!So from what I understood from the fatal error message it says it can not find the "plugins/@pk.so" because theres not such file or directory.
So I procceded to create that file in the directory (Hercules/src/plugins/) I used nano to create "@pk.so" add added the code again https://github.com/dastgirp/HPM-Plugins/blob/master/src/plugins/%40pk.c
Set the delay timer to 60 and nothing else.
So now, my "Hercules/src/plugins/" folder is like this
/Hercules/src/plugins# ls constdb2doc.c HPMHooking Makefile.in sample.c db2sql.c HPMHooking.c mapcache.c script_mapquit.c dbghelpplug.c HPMHooking.h @pk.c generate-translations.c Makefile @pk.soI proceeded to start the server again, to see what error message would show now this came showed up:
[Status]: HPM: Loaded plugin 'HPMHooking' (0.2) built with HPMHooking support. [Fatal Error]: HPM:plugin_load: failed to load 'plugins/@pk.so' (error: plugins/@pk.so: cannot open shared object file: No such file or directory)! [Fatal Error]: HPM:plugin_load: failed to load 'plugins/@pk.so' (error: plugins/@pk.so: cannot open shared object file: No such file or directory)! [Info]: Server uses 'select' as event dispatcher [Info]: Server supports up to '1024' concurrent connections. [Status]: HPM: Loaded plugin 'HPMHooking' (0.2) built with HPMHooking support. [Fatal Error]: HPM:plugin_load: failed to load 'plugins/@pk.so' (error: plugins/@pk.so: cannot open shared object file: No such file or directory)!It still says that there is not such file or directory.
I'm out of ideas so I ask for help.
Thank you for your time.
FluxCP - Connection Refused
in Website Support
Posted · Edited by wabbuwabbu
Modifying the Bind-Address to the Public IP gives me an error in the server when it restarts: