client not connecting to server

[rainz89]

My client, tried numerous of different DIFF but most them has their resolution un-change even after I tried changing the settings on setup.

I tried opening the KRO client but it did changes but the DIFF client for my server didn't.

I'm currently using 2011-12-28aRageRE.exe now..

Also, there's something wrong after I change the packet on mmo.h at rAthena/scr/common/ with (20111228).

http://imageshack.us.../507/3123r.jpg/

Edited August 28, 2012 by rainz89

[EvilPuncker]

don't diff your client with "read data folder first"

[rainz89]

I didn't.

Double checked it every time I try with every Diff.

And the diff before 2011-03-15 can't even open up, I mean nothing happens after double clicking it.

[Mystery]

With clients under 2012, they need the read data/lua first diffs. 2012+ clients don't need those diffs.

[rainz89]

With clients under 2012, they need the read data/lua first diffs. 2012+ clients don't need those diffs.

Thanks, your tips reminds me of the data folder contain a optionlua file, take away the data folder and it works like a charm.

Now that solved, another problem surface.....

The stupid SQL seems to causing me problem over and over for some reason.

Now it tells me the it unable to access to SQL database from my server-sql.exe due to password protection.

I tried to login from my sql workbrench and funny thing is, it doesn't let me go into the database and stuck there.

I'm going to reinstall the whole sql and see if it works.

[Mystery]

Make sure your IP is allowed to access your database.

[rainz89]

Yea, i change the port and make a new password after re-installing it, the server is back to normal.

Now another issue where I can't seem to connect to my own server.

It says Failed to connect to server when going in the character selection page.

i'll post some screenies here.

And Also, When i tried to access my own server using a different PC (Local),

It has another error where something like this.

(This one seems to able to let me goes into the character selection page but rejects when going into the game.)

(Seems like no-ip doesn't work for some reason for locals)

Bump*

Any help???

----------------------------------------------

Somehow I've solved the problem from (Disconnecting session #3 with unknown packet version.)

But now I seems to have another problem.........

When I login to the server, I can't do anything at all, whole thing frozen, but I could hear musics and see the animations moving, but I can't do anything else.

I wonder if it's related to the recompiling phase where the warning talk about, and it might related to the SQL DB error on the charserver-SQL.exe just on the picture above.

-----------------------------------------------

Nevermind, seems like i completely solve it.

Remove a packet version on packet_db,

Replace it with any of the client I'm going to use with the packet here.

http://svn6.assembla.com/svn/ClientSide/Packets/Packet_db/

Then change my client.xml version to the designed packet I've replaced from the packet_db.

Last but not least, change my packet on mmo.c............and recompile. It's done.

After that, slowly look for error and missing files listed on my mapserver-sql.exe when it runs....fix it and it works normally now.

But I still don't really get what are the SQL DB error showed on Charserver-sql.exe.....

Edited July 29, 2012 by rainz89

[Judas]

execute the sql file into your ragnarok schema

http://trac.rathena.org/changeset/16518/rathena

[rainz89]

Just the Sql ?

[Judas]

Yea

[rainz89]

Thanks, no more strange SQL error now.

Now.

Back to the packet question.

Seems like I did some mistake, I actually used the bypass client so I didn't know I'm not using my own client.

Anyhow, the packet error sent me a msg saying

recieving unknown packet ( 0x970 ) on charserver-sql.bat

&

clif_parse: Disconnecting session #3 with unknown packet version (p:0x4389,1:19) on mapserver-sql.bat

I did a check on my packet_db but it didn't list any packet number on the date client packet i'm using......weird.

Also, just a dumb question.

Where and how do I install the lua and lub file into? I need to install it for translated text to my client.

Got the file from here, http://svn6.assembla...a_Project/lubs/ .

Downloaded this 2011-12-28 Lub+src Files [Translated].rar since I want to use this diff for my server.

If, somehow I cannot solve the unknown packet ver/ disconnecting session #3 error.

Where can I find the lub file for 2012-04-10 ?

Edit: (Nevermind about my last question...... I'm totally blind LOL)

Bump agiain*

anyone?

I found the tread talking about unknown packet 0x970,

But i really don't understand how it works and how to modify it.

http://rathena.org/board/topic/60079-error-parse-char-received-unknown-packet-0x970-2012-03-07fragexere/page__hl__%2Bpacket+%2B0x970

Also, I really need help on the lua/lub files, I don't even know where I should put it into.

I only know one of the luafiles place inside the GRF, but other than that, I'm completely clueless.

Took this screenshot with 2012-04-10 client.

Edited July 29, 2012 by rainz89

[Mystery]

2012 clients, you gotta do luafiles514/lua files.

Edited August 1, 2012 by Mysterious
Forgot space

[Judas]

luafiles514/lua files

I think there is a space in there?

[Mystery]

Yup ;3. *Edit

[rainz89]

So instead of data/luafiles ,

I have to do it like this? data/luafiles514/lua files ?

Okay, most of the words were translated into english, included skills.

The few that were still untranslated is the Inventory tabs, the UI on ESC, and the UI for login interface.

Also, this topic onward isn't really related to installation purpose but I kinda not wanting to make a new topic over it.

The exp rate which i set for my server are 5x, but somehow. no matter how much I set it, "even the server is reading it as much" Whenever I kill a mob on lv1 regardless of the rate i played, it only gives 29.5% max on base exp. And the job rate always gets 150% on lv1. weird......

I'll try double check around the data and config just in case.

Nevermind, I just noticed the renewal exp rate changed dramatically on http://irowiki.org.

I'll keep it to default.

I think i'll just keep using 2012-04-10 for my server,

But, I encounter another problem related to skill cast.

I posted it on another topic here.

http://rathena.org/board/topic/68664-the-awkward-moment-when-theres-no-casting-timerbar-when-casting-spells/

Edited August 1, 2012 by rainz89

[Mystery]

So instead of data/luafiles ,

I have to do it like this? data/luafiles514/lua files ?

Okay, most of the words were translated into english, included skills.

The few that were still untranslated is the Inventory tabs, the UI on ESC, and the UI for login interface.

Correct. data/luafiles514/lua files. Next those will be changed VIA your msgstringtable. You can download a good msgstringtable here: http://rathena.org/board/topic/68560-navigation-problem/#entry125839

Also, make sure you have a System/ folder as well in your main directory where RO is installed: http://svn6.assembla.com/svn/ClientSide/Lua_Project/System/

[rainz89]

There is still some UI untranslated here and there, I did download a good msgstringtable on a page too.

although, I think it's templates/interface involvement........

Actually, it's best if I could use any other diff than 2012-04-10aRageke.exe.....

If anyone would be kind to teach me how to bypass that reject from server thingy.

The unknown packat 0x970....

This is kinda irritates me since after sometime I've set up the server and running smoothly only on Lan, and Login through a different PC/Local PC under Lan.

I kinda send a copy to my friend and ask him to login from his place to mine, and it says Failed to connect to server.

I'm pretty sure I've set everything accordingly, but I may not right.

(PS: My bro is playing just outside from my room while my friend can't connect from his place)

I'm running the rAthena SVN 16518 since the update posted to me by Judas.

Client 2012-04-10_J

char.conf

// 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: rainz89
passwd: Great6939
// 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: Rainz-Paradise
// 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: 192.168.0.103
// 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: rainzro.no-ip.org
// Character Server Port
char_port: 6121
//Time-stamp format which will be printed before all messages.
//Can at most be 20 characters long.
//Common formats:
// %I:%M:%S %p (hour:minute:second 12 hour, AM/PM format)
// %H:%M:%S (hour:minute:second, 24 hour format)
// %d/%b/%Y (day/Month/year)
//For full format information, consult the strftime() manual.
//timestamp_format: [%d/%b %H:%M]
//If redirected output contains escape sequences (color codes)
stdout_with_ansisequence: no
//Makes server output more silent by ommitting certain types of messages:
//1: Hide Information messages
//2: Hide Status messages
//4: Hide Notice Messages
//8: Hide Warning Messages
//16: Hide Error and SQL Error messages.
//32: Hide Debug Messages
//Example: "console_silent: 7" Hides information, status and notice messages (1+2+4)
console_silent: 0
// Console Commands
// Allow for console commands to be used on/off
// This prevents usage of >& log.file
console: off
// Type of server.
// No functional side effects at the moment.
// Displayed next to the server name in the client.
// 0=normal, 1=maintenance, 2=over 18, 3=paying, 4=P2P
char_maintenance: 0
// Enable or disable creation of new characters.
// Now it is actually supported [Kevin]
char_new: 1
// Display (New) in the server list.
char_new_display: 0
// Maximum users able to connect to the server. Set to 0 for unlimited.
max_connect_user: 0
// Group ID that is allowed to bypass the server limit of users.
// Default: -1 = nobody (there are no groups with ID < 0)
// See: conf/groups.conf
gm_allow_group: -1
// How often should the server save all files? (In seconds)
// Note: Applies to all data files on TXT servers.
// On SQL servers, it applies to guilds (character save interval is defined on the map config)
autosave_time: 60
// Display information on the console whenever characters/guilds/parties/pets are loaded/saved?
save_log: yes
// Start point, Map name followed by coordinates (x,y)
start_point: new_1-1,53,111
// Starting weapon for new characters
start_weapon: 1201
// Starting armor for new characters
start_armor: 2301
// Starting zeny for new characters
start_zeny: 0
// Size for the fame-lists
fame_list_alchemist: 10
fame_list_blacksmith: 10
fame_list_taekwon: 10
// Guild earned exp modifier.
// Adjusts taxed exp before adding it to the guild's exp. For example, if set
// to 200, the guild receives double the player's taxed exp.
guild_exp_rate: 100
// Name used for unknown characters
unknown_char_name: Unknown
// To log the character server?
log_char: 1
// Allow or not identical name for characters but with a different case (upper/lower):
// example: Test-test-TEST-TesT; Value: 0 not allowed (default), 1 allowed
name_ignoring_case: no
// Manage possible letters/symbol in the name of charater. Control character (0x00-0x1f) are never accepted. Possible values are:
// NOTE: Applies to character, party and guild names.
// 0: no restriction (default)
// 1: only letters/symbols in 'char_name_letters' option.
// 2: Letters/symbols in 'char_name_letters' option are forbidden. All others are possibles.
char_name_option: 1
// Set the letters/symbols that you want use with the 'char_name_option' option.
// Note: Don't add spaces unless you mean to add 'space' to the list.
char_name_letters: abcdefghijklmnopqrstuvwxyz ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890
// How many Characters are allowed per Account ? (0 = disabled)
chars_per_account: 0
// Restrict character deletion by BaseLevel
// 0: no restriction (players can delete characters of any level)
// -X: you can't delete chars with BaseLevel <= X
// Y: you can't delete chars with BaseLevel >= Y
// e.g. char_del_level: 80 (players can't delete characters with 80+ BaseLevel)
char_del_level: 0
// Amount of time in seconds by which the character deletion is delayed.
// Default: 86400 (24 hours)
// NOTE: Requires client 2010-08-03aragexeRE or newer.
char_del_delay: 86400
// What folder the DB files are in (item_db.txt, etc.)
db_path: db
import: conf/import/char_conf.txt

Map.conf

//--------------------------------------------------------------
//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: rainz89
passwd: Great6939
// 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: 192.168.0.103
// 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: rainzro.no-ip.org
// Map Server Port
map_port: 5121
//Time-stamp format which will be printed before all messages.
//Can at most be 20 characters long.
//Common formats:
// %I:%M:%S %p (hour:minute:second 12 hour, AM/PM format)
// %H:%M:%S (hour:minute:second, 24 hour format)
// %d/%b/%Y (day/Month/year)
//For full format information, consult the strftime() manual.
//timestamp_format: [%d/%b %H:%M]
//If redirected output contains escape sequences (color codes)
stdout_with_ansisequence: no
//Makes server log selected message types to a file in the /log/ folder
//1: Log Warning Messages
//2: Log Error and SQL Error messages.
//4: Log Debug Messages
//Example: "console_msg_log: 7" logs all 3 kinds
//Messages logged by this overrides console_silent setting
console_msg_log: 0
//Makes server output more silent by ommitting certain types of messages:
//1: Hide Information messages
//2: Hide Status messages
//4: Hide Notice Messages
//8: Hide Warning Messages
//16: Hide Error and SQL Error messages.
//32: Hide Debug Messages
//Example: "console_silent: 7" Hides information, status and notice messages (1+2+4)
console_silent: 0
//Where should the map data be read from?
map_cache_file: db/map_cache.dat
//Where should all database data be read from?
db_path: db
// Enable the @guildspy and @partyspy at commands?
// Note that enabling them decreases packet sending performance.
enable_spy: no
// Read map data from GATs and RSWs in GRF files or a data directory
// as referenced by grf-files.txt rather than from the mapcache?
use_grf: no
// Console Commands
// Allow for console commands to be used on/off
// This prevents usage of >& log.file
console: off
// Database autosave time
// All characters are saved on this time in seconds (example:
// autosave of 60 secs with 60 characters online -> one char is saved every
// second)
autosave_time: 300
// Min database save intervals (in ms)
// Prevent saving characters faster than at this rate (prevents char-server
// save-load getting too high as character-count increases)
minsave_time: 100
// Apart from the autosave_time, players will also get saved when involved
// in the following (add as needed):
// 1: after every successful trade
// 2: after every vending transaction
// 4: after closing storage/guild storage.
// 8: After hatching/returning to egg a pet.
// 16: After successfully sending a mail with attachment
// 32: After successfully submitting an item for auction
// 64: After successfully get/delete/complete a quest
// NOTE: These settings decrease the chance of dupes/lost items when there's a
// server crash at the expense of increasing the map/char server lag. If your
// server rarely crashes, but experiences interserver lag, you may want to set
// these off.
save_settings: 127
// Message of the day file, when a character logs on, this message is displayed.
motd_txt: conf/motd.txt
// When @help or @h is typed when you are a gm, this is displayed for helping new gms understand gm commands.
help_txt: conf/help.txt
help2_txt: conf/help2.txt
charhelp_txt: conf/charhelp.txt
// Maps:
import: conf/maps_athena.conf
import: conf/import/map_conf.txt

inter_athena

// Athena InterServer configuration.
// Options for both versions
// Log Inter Connections, etc.?
log_inter: 1
// Inter Log Filename
inter_log_filename: log/inter.log
// Level range for sharing within a party
party_share_level: 15
// SQL version options only
// You can specify the codepage to use in your mySQL tables here.
// (Note that this feature requires MySQL 4.1+)
//default_codepage:

// 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
// Global SQL settings
// overriden by local settings when the hostname is defined there
// (currently only the login-server reads/obeys these settings)
sql.db_hostname: 127.0.0.1
sql.db_port: 3307
sql.db_username: root
sql.db_password: Great5400881
sql.db_database: rAthena
sql.codepage:
// MySQL Character SQL server
char_server_ip: 127.0.0.1
char_server_port: 3307
char_server_id: root
char_server_pw: Great5400881
char_server_db: rAthena
// MySQL Map SQL Server
map_server_ip: 127.0.0.1
map_server_port: 3307
map_server_id: root
map_server_pw: Great5400881
map_server_db: rAthena
// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3307
log_db_id: root
log_db_pw: Great5400881
log_db_db: logs
log_codepage:
log_login_db: loginlog
// DO NOT CHANGE ANYTHING BEYOND THIS LINE UNLESS YOU KNOW YOUR DATABASE DAMN WELL
// this is meant for people who KNOW their stuff, and for some reason want to change their
// database layout. [CLOWNISIUS]
// ALL MySQL Database Table names
// Char Database Tables
char_db: char
hotkey_db: hotkey
scdata_db: sc_data
cart_db: cart_inventory
inventory_db: inventory
charlog_db: charlog
storage_db: storage
reg_db: global_reg_value
skill_db: skill
interlog_db: interlog
memo_db: memo
guild_db: guild
guild_alliance_db: guild_alliance
guild_castle_db: guild_castle
guild_expulsion_db: guild_expulsion
guild_member_db: guild_member
guild_skill_db: guild_skill
guild_position_db: guild_position
guild_storage_db: guild_storage
party_db: party
pet_db: pet
friend_db: friends
mail_db: mail
auction_db: auction
quest_db: quest
homunculus_db: homunculus
skill_homunculus_db: skill_homunculus
mercenary_db: mercenary
mercenary_owner_db: mercenary_owner
ragsrvinfo_db: ragsrvinfo
// Map Database Tables
item_db_db: item_db
item_db_re_db: item_db_re
item_db2_db: item_db2
mob_db_db: mob_db
mob_db2_db: mob_db2
mob_skill_db_db: mob_skill_db
mob_skill_db2_db: mob_skill_db2
mapreg_db: mapreg
//Use SQL item_db, mob_db and mob_skill_db for the map server
use_sql_db: no
// Nick for sending mainchat
// messages like whisper
main_chat_nick: Main
import: conf/import/inter_conf.txt

subnet_athena.conf

// Subnet support file
// Format is:
// subnet: net-submask:char_ip:map_ip
// you can add more than one subnet
subnet: 255.255.255.0:175.139.67.77:175.139.67.77

Clientinfo.xml

 <?xml version="1.0" encoding="euc-kr" ?>
<clientinfo>
 <desc>Ragnarok Client Information</desc>
 <servicetype>korea</servicetype>
 <servertype>sakray</servertype>
<connection>
 <display>RainRo</display>
 <desc>Ragnarok Online</desc>
 <address>rainzro.no-ip.org</address>
 <port>6900</port>
 <version>29</version>
 <langtype>01</langtype>
 <registrationweb></registrationweb>
<yellow>
 <admin>2000000</admin>
</yellow>
<aid>
<admin>2000000</admin>
</aid>
<loading>
 <image>loading01.jpg</image>
 <image>loading02.jpg</image>
 <image>loading03.jpg</image>
 <image>loading04.jpg</image>
 <image>loading05.jpg</image>
 <image>loading06.jpg</image>
 <image>loading07.jpg</image>
 <image>loading08.jpg</image>
 <image>loading09.jpg</image>
</loading>
</connection>
</clientinfo>

Port for D-link Router : Model DIR-615

http://imageshack.us...aradise000.jpg/

Server running

http://imageshack.us...4/34186950.jpg/

Lan & Wan/No-ip IP Address

http://imageshack.us...7/11815342.jpg/

I think I found out the problem....

I tried port checking with a web port check tool and this is what I get.

Port 6900 is closed on 175.139.67.77.

Port 5121 is closed on 175.139.67.77.

Port 6121 is closed on 175.139.67.77.

My window firewall was closed, router's firewall was closed as well.

I don't know about my antivirus though, seems like there's no option for it (Microsoft Security Essential)

Other than these, I have no idea what blocks it....

Nevermind, Solved it, I actually placed my Lan ip on public ip tab unknowingly......

But, the previous problem is still oncase, so I'm not changing the title to Solved until it's done :0

Source: http://forum.lowyat....pic/1927715/all

A new error found,

When trying to set party exp system to "Party Share"

It straight away disconnects the user who try to set it.

Any idea what cause it?

Bump~~~

Edited August 3, 2012 by rainz89
Dont forget your codebox's

[Mystery]

When trying to set party exp system to "Party Share"

It straight away disconnects the user who try to set it.

Any idea what cause it?

That's probably still caused by your packet configuration. I suggest you use the client rAthena currently provides support for, which would be 2012-04-10: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/src/common/mmo.h

#ifndef PACKETVER
#define PACKETVER 20120410
//#define PACKETVER 20111116
#endif

Your packet_db should be at default to support 2012-04-10 client already so you wouldn't have to worry about that.

When you get disconnected (the player) does the map server spit anything out? Stating as to why that player got booted?

[rainz89]

I didn't really take notice, and too I did change the packet at mmo.h too, maybe I should go and double check just in case

I'm currently using all these at the moment....

I'll put my files in the mediefire web so you can grab and look at it...

Since the words contain in the file is extremely long.

http://www.mediafire.com/?9ccryc3deu34z

0x07d7, i place the code on the packet_db for 2012-04-10 so the client doesn't get the error, but it does not respond to the option for party option changes.....

Anyone able to help out the newb ol me?

I have a lot of players joined in now and I need the party exp share to be fix...

Also, changing the party leader cause both people( current and new lead) to dc and the current leader still posses the title of bein the leader.....

And somehow the ex. Super Novice will lost the ability to use fury after reaching max level and max exp. on lv150.

Also, is there a way to modify the aspd for weapons/classes?

Anyone able to help out the newb ol me?

I have a lot of players joined in now and I need the party exp share to be fix...

Also, changing the party leader cause both people( current and new lead) to dc and the current leader still posses the title of bein the leader.....

And somehow the ex. Super Novice will lost the ability to use fury after reaching max level and max exp. on lv150.

Also, is there a way to modify the aspd for weapons/classes?

Last but not least, the party hp display doesn't seems to update.

Edited August 4, 2012 by rainz89

[rainz89]

Bump,

It's been awhile but there's seems no one able to help?

I'm in a hurry to fix these now, since I've already gotten myself into the middle of having more then 20 players playing on my server now......

[rainz89]

Bump,

Really, I'm starting to lost motivation on how to fix this.

The Party EXP sharing system isn't working at all, I tried to add the unknown error code into the packet_db, yes it doesn't shows the error and disconnects the player anymore, but the setting is still unchangeable.

Also, I have noticed the Party HP DO NOT update at all. It stucks at full health even the members got hit/receive damage.

I really need these two fix ASAP.

[rainz89]

All these bugs happens because of the Trunk I'm using is corrupted, and the Ragnarok folder is corrupted as well.

I redownload everything and tried it with a few friends of mine and it works perfectly normal now.

Thanks for the advice all of you guys giving anything.

[kaka19]

hello there..

how can i create server using no-ip??

i tried but my client didnt connect to my server..

here my clientinfo xml:

<?xml version="1.0" encoding="euc-kr" ?>
<clientinfo>
<servicetype>korea</servicetype>
<servertype>sakray</servertype>
  <connection>
  <display>zakaro Server</display>
  <balloon>Klik!</balloon>
  <desc>description</desc>
  <address>zakaro.zapto.org</address>
  <port>6900</port>
  <version>20</version>
  <langtype>1</langtype>
  <registrationweb></registrationweb>
	<aid>
		<admin>2000000</admin>
		<admin>2000001</admin>
		<admin>2000002</admin>
	</aid>
	<loading>
		<image>loading00.jpg</image>
           <image>loading01.jpg</image>
	</loading>
  </connection>
</clientinfo>

Edited September 4, 2012 by Emistry
Please use [XML] for XML Contents. ^^