wabbuwabbu

Modifying the Bind-Address to the Public IP gives me an error in the server when it restarts: [SQL]: Access denied for user 'hercrodbusr'@'%' to database 'hercrolog' [Notice]: Connection of the char-server 'NetRO' REFUSED. [Error]: Sent wrong packet id: 0x2711 [Error]: --- failed assertion -------------------------------------------- [Error]: socket.c:2112: '0' in function `socket_validateWfifo' [Error]: 0x2be67 nullpo_backtrace_print [Error]: /home/inty/Hercules/src/common/nullpo.c:77 [Error]: 0x2be67 assert_report [Error]: /home/inty/Hercules/src/common/nullpo.c:147 [Error]: 0x3e3cf socket_validateWfifo [Error]: /home/inty/Hercules/src/common/socket.c:2112 [Error]: 0x40c7f wfifoset [Error]: /home/inty/Hercules/src/common/socket.c:901 [Error]: 0x40c7f wfifoset [Error]: /home/inty/Hercules/src/common/socket.c:855 [Error]: 0x1efbb login_parse_request_connection [Error]: /home/inty/Hercules/src/login/login.c:1473 [Error]: 0x19e7b lclif_parse_CA_CHARSERVERCONNECT [Error]: /home/inty/Hercules/src/login/lclif.c:266 [Error]: 0x1a2f7 lclif_parse_packet [Error]: /home/inty/Hercules/src/login/lclif.c:510 [Error]: 0x19f33 lclif_parse [Error]: /home/inty/Hercules/src/login/lclif.c:419 [Error]: 0x404d7 do_sockets [Error]: /home/inty/Hercules/src/common/socket.c:1073 [Error]: 0x1575f main [Error]: /home/inty/Hercules/src/common/core.c:539 [Error]: 0x76c59717 ??? [Error]: ???:0 [Error]: --- end failed assertion ---------------------------------------- [Error]: Can not connect to login-server. [Error]: The server communication passwords (default s1/p1) are probably invalid. [Error]: Also, please make sure your login db has the correct communication username/passwords and the gender of the account is S. [Error]: The communication passwords are set in /conf/map/map-server.conf and /conf/char/char-server.conf

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.

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)

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: 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

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.conf 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: Ports 6900, 5121 & 6121 are open and active.

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.