-
Posts
21 -
Joined
-
Last visited
-
Days Won
1
Content Type
Profiles
Forums
Downloads
Jobs Available
Server Database
Third-Party Services
Top Guides
Store
Crowdfunding
Everything posted by Johnathan
-
RO Patcher Lite, v4.5.0.1340 - last updated 2024/09/21
Johnathan replied to Ai4rei's topic in Client Releases
I'm having the same error, in the same file, every time. The Windows Defender is already disabled. -
I'm having problems with my palettes, the jobs 1-1 and 1-2 are totally black after the color number 500 and the pecos from ( B Halter Box 30Days Item ID# 16683 (B_Halter_Box_30Days) ) are totally black, no matters the color number. I'm using these palettes: With the update: Here are some screenshots: May someone help me? Which are my options te get palettes working well?
-
I solved the problem, only changed the AMAZON_AWS_PUBLIC_DNS in char_athena and map_athena, for the ipv4 provided by Amazon. I don't know if this is Elastic IP. The other files still having the AMAZON_AWS_PUBLIC_DNS. Thx for the help.
-
Yes man, the version is correct. I tested to a 2015-11-04b client diffed. I still having the same problem.
-
Yes, I recompiled disabling PACKET_OBFUSCATION. Where did I find this Elastic IP?
-
The PACKET_OBFUSCATION is already commented and the version on mmo.h is correct. I checked on your site, all ports are opened. I disabled the firewall, by using sudo ufw disable, still with the same problem.
-
Now, after trying to connect, the client said that the server is closed.
-
The server was compiled commenting this in mmo.h, the NEMO doesn't have this option. The server doesn't show any errors.
-
I'm using the 2015-10-29.
-
Here it is: <?xml version="1.0" encoding="euc-kr" ?> <clientinfo> <desc>Ragnarok Client Information</desc> <servicetype>korea</servicetype> <servertype>primary</servertype> <connection> <display>Local</display> <address>AMAZON_AWS_PUBLIC_DNS</address> <port>6900</port> <version>54</version> <langtype>1</langtype> <aid> <admin>2000000</admin> </aid> <yellow> <admin>2000000</admin> </yellow> <registrationweb>www.ragnarok.com</registrationweb> <loading> <image>loading00.jpg</image> <image>loading01.jpg</image> <image>loading02.jpg</image> <image>loading03.jpg</image> <image>loading04.jpg</image> </loading> </connection> </clientinfo>
-
I reverted the subnet to default values, but the problem still remains. How can I see the firewall configs?
-
I'm trying to connect to my server but without success. I was able to do this at same computer (using 127.0.0.1) and friends were able to connect to my server using hamachi. Now, I'm trying to use any Amazon AWS. I see the server, but when I try to login the client freezes and I got an error of timeout. In the server-side, I got this: Here're my configurations: char_athena.txt // Athena Character configuration file. // Note: "Comments" are all text on the right side of a double slash "//" // Whatever text is commented will not be parsed by the servers, and serves // only as information/reference. // Server Communication username and password. userid: s1 passwd: p1 // Server name, use alternative character such as ASCII 160 for spaces. // NOTE: Do not use spaces or any of these characters which are not allowed in // Windows filenames \/:*?"<>| // ... or else guild emblems won't work client-side! server_name: rAthena // Wisp name for server: used to send wisp from server to players (between 4 to 23 characters) wisp_server_name: Server // Login Server IP // The character server connects to the login server using this IP address. // NOTE: This is useful when you are running behind a firewall or are on // a machine with multiple interfaces. login_ip: AMAZON_AWS_PUBLIC_DNS // The character server listens on the interface with this IP address. // NOTE: This allows you to run multiple servers on multiple interfaces // while using the same ports for each server. //bind_ip: 127.0.0.1 // Login Server Port login_port: 6900 // Character Server IP // The IP address which clients will use to connect. // Set this to what your server's public IP address is. char_ip: AMAZON_AWS_PUBLIC_DNS // Character Server Port char_port: 6121 map_athena.txt //-------------------------------------------------------------- //rAthena Map-Server Configuration File //-------------------------------------------------------------- // Note: "Comments" are all text on the right side of a double slash "//" // Whatever text is commented will not be parsed by the servers, and serves // only as information/reference. //-------------------------------------------------------------- // Configuration Info //-------------------------------------------------------------- // Interserver communication passwords, set in account.txt (or equiv.) userid: s1 passwd: p1 // Character Server IP // The map server connects to the character server using this IP address. // NOTE: This is useful when you are running behind a firewall or are on // a machine with multiple interfaces. char_ip: AMAZON_AWS_PUBLIC_DNS // The map server listens on the interface with this IP address. // NOTE: This allows you to run multiple servers on multiple interfaces // while using the same ports for each server. //bind_ip: 127.0.0.1 // Character Server Port char_port: 6121 // Map Server IP // The IP address which clients will use to connect. // Set this to what your server's public IP address is. map_ip: AMAZON_AWS_PUBLIC_DNS // Map Server Port map_port: 5121 subnet_athena.txt // Subnet support file // Format is: // subnet: net-submask:char_ip:map_ip // you can add more than one subnet (max 16) // check is if((net-submask & char_ip ) == (net-submask & servip)) => ok subnet: 255.0.0.0:AMAZON_AWS_PUBLIC_DNS:AMAZON_AWS_PUBLIC_DNS I've already port-forwarding 6900, 6121 and 5121. May someone help me?
-
SQL Error: main.sql invalid default value for 'time'
Johnathan replied to Johnathan's question in Database Support
I solve this, thank for your help @Hurtsky. I find the answer here: https://www.sitepoint.com/quick-tip-how-to-permanently-change-sql-mode-in-mysql/ Was like here: But I added more things. The newer version of MySql doesn't enable the use of zeros in date fields (date, datetime and etc). So I activated it again, to do this, I run inside MySql: select @@sql_mode I copied the configs, removing the tags NO_ZERO_IN_DATE,NO_ZERO_DATE. After that, I pasted the new configs like @Hurtsky said. -
SQL Error: main.sql invalid default value for 'time'
Johnathan replied to Johnathan's question in Database Support
Still getting the same error =/ -
SQL Error: main.sql invalid default value for 'time'
Johnathan replied to Johnathan's question in Database Support
I added this line to /etc/mysql/my.cnf, now a get this error (including to mysqld): [ERROR] Found option without preceding group in config file /etc/mysql/my.cnf at line 20! -
SQL Error: main.sql invalid default value for 'time'
Johnathan posted a question in Database Support
I'm trying to import the sql-files, but I'm getting errors in the fields related to datetime. I'm using the latest version of rathena. CREATE TABLE IF NOT EXISTS `charlog` ( `time` datetime NOT NULL default '0000-00-00 00:00:00', `char_msg` varchar(255) NOT NULL default 'char select', `account_id` int(11) NOT NULL default '0', `char_num` tinyint(4) NOT NULL default '0', `name` varchar(23) NOT NULL default '', `str` int(11) unsigned NOT NULL default '0', `agi` int(11) unsigned NOT NULL default '0', `vit` int(11) unsigned NOT NULL default '0', `int` int(11) unsigned NOT NULL default '0', `dex` int(11) unsigned NOT NULL default '0', `luk` int(11) unsigned NOT NULL default '0', `hair` tinyint(4) NOT NULL default '0', `hair_color` int(11) NOT NULL default '0' ) ENGINE=MyISAM; Importing the main.sql above, I get the error: ERROR 1067 (42000) at line 271: Invalid default value for 'time'. This error occur in all files which use datetime. Anyone can help me? -
I have this problem too, after updating the mapserver started crashing. In my case, if I stay AFK the mapserver crash. The development team should create a stable version (or releases) branch, thus, servers which want to keep the emulator up-to-date will be safe as well.
-
I'm trying to use the option usb_sql_db: yes in conf\inter_athena.conf, but doesn't work. In mapserv.bat the option appears allowed ([Status]: Using SQL dbs: yes) but the thing is, my custom mobs at mob_db_re (IDs: 3634 to 3656) and my custom items at item_db_re (ID up to 35000) doesn't are loaded. Anyone know what I am doing wrong? Thx.
-
My rAthena is up-to-date and, doesn't matters how I call this label (OnPCLoginEvent), it's never works. - script login_player_cmd -1,{ OnPCLoginEvent: dispbottom "test"; end; } May someone help me?
-
prontera,155,179,2 script Debug 1001,{ OnTouch: //set @count, 0; mes "[npc name]"; switch(@count){ case 0:{ mes "Please, do not bother me. I am in pain."; @count++; close; }break; case 1:{ mes "Can you not see I am grieving? Begone."; @count++; close; }break; case 2:{ mes "I have no quarrel with you stranger, LEAVE ME BE."; @count++; close; }break; case 3:{ if(countitem(578) >= 80){ delitem 578,80; getitem 19620,1; mes "Congrats!"; @count++; close; }else{ mes "You don't have what I want."; close; } }break; } mes "Im sorry for being rude, please, come near me. Would you like to hear my melancholic tale?"; close; end; } Was the OnInit, @count it's on player, can't be executed at OnInit Now I suppose that will runs everything ok.
-
prontera,155,179,2 script Debug 1001,{ OnTouch: announce @count, 0; mes "[npc name]"; switch(@count){ case 0:{ mes "Please, do not bother me. I am in pain."; @count++; close; }break; case 1:{ mes "Can you not see I am grieving? Begone."; @count++; close; }break; case 2:{ mes "I have no quarrel with you stranger, LEAVE ME BE."; @count++; close; }break; case 3:{ if(countitem(578) >= 80){ delitem 578,80; getitem 19620,1; mes "Congrats!"; @count++; close; }else{ mes "You don't have what I want."; close; } }break; } mes "Im sorry for being rude, please, come near me. Would you like to hear my melancholic tale?"; close; end; OnInit: set @count, 0; end; }