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.

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.

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. 2018-04-18bRagexeRE_patched.exe.secure.txt

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 @pk Server 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_gcc Let 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.so I 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.