Jump to content


  • Content Count

  • Joined

  • Last visited

About wabbuwabbu

  • Rank

Recent Profile Visitors

2453 profile views
  1. 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
  2. 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 to 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.
  3. Thank you for your reply @Rynbef, In servers.php, I've modified the field '' 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 // Under windows, you want to use 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 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)
  4. 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' => '', // 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' => '', // 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
  5. 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%%)
  6. 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
  7. 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
  8. Here are some ideas on how to do it: 1. You can add the "sprite" folder inside the data folder. 2. You can add the "sprite" folder inside the data folder, inside the data.grf. 3. You can create a custom grf folder and add inside the data folder the "sprite" folder. Hope it helps
  9. I’m curious to know if it’s possible to change back to the old monster’s health bar. For example: Poring: (50/50)
  10. 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!
  11. Everytime a player hits a mob this error appears in the server. Any ideas on what could be the problem?
  12. 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
  13. Currently trying to log into the server and this appears on the server status: Ports 6900, 5121 & 6121 are open and active.
  14. 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.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.