Jump to content

Lordamax

Members
 View Profile  See their activity

  • Posts

    328

  • Joined

  • Last visited

  • Days Won

    1

 Content Type 

Posts posted by Lordamax

    FAILED TO CONNECT :( EATHENA MYSQL

    in Tulong para sa Server

    Posted

    eto po... di ko pa po pinapalitan ung s1 and p1 :D ung default na lumalabas ata dun sa packet_db is 25.. :P basta po...nid help ;)

    char_athena.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: s1

    passwd: p1

    // Server name, use alternative character such as ASCII 160 for spaces.

    // NOTE: Do not use spaces in the name, or guild emblems won't work client-side!

    server_name: TaheeRO

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

    // 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: WAN IP KO

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

    // Option to force a player to create an e-mail.

    // If a player have default e-mail, and if you activate this option, the player can only connect in the game (to arrive on a map) like follow:

    // - Create at least 1 character

    // - Select 1 character

    // - Select DEL to enter his/her e-mail. (if OK is choosen, client says to the player: 'invalid e-mail')

    // - If his/her e-mail is correct, the player enter in the game (an e-mail is saved definitively).

    // - If his/her e-mail is incorrect, he/she have 'incorrect e-mail' and must select again DEL.

    // - After entering in the game (when the player arrives on a map), DEL and SEL/OK button work normaly for all next connections.

    // Resume: If a player have "incorrect/invalid e-mail" when he/she click on 'OK' button,

    // the player must click 'DEL' button and register his/her NEW e-mail to enter in the game

    // So, default is 0, because administrator must explain to their players before to activate this option.

    email_creation: 0

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

    // Minimum GM level that is allowed to bypass the server limit of users.

    gm_allow_level: 99

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

    // Character server flatfile database

    char_txt: save/athena.txt

    // Friends list flatfile database

    friends_txt: save/friends.txt

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

    // Log Filename

    char_log_filename: log/char.log

    // 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
    // What folder the DB files are in (item_db.txt, etc.)
    db_path: db
    //NOTE: The following online listing options are only for TXT servers.
    // Filename of the file which receives the online players list in text
    online_txt_filename: online.txt
    // Filename of the file which receives the online players list, but in html version
    online_html_filename: online.html
    // Choose how to display online players.
    // (sorting operation with a lot of online players can take time on a slow computer)
    // 0: no sorting (default)
    // 1: by alphabetical order of their name
    // 2: by number of their zenys
    // 3: by their base level
    // 4: by their job (and job level inside the same job)
    // 5: by alphabetical order of their actual map location
    online_sorting_option: 0
    // Choose which columns that you want display in the online files. Do the addition of these values:
    // (if value is 0, no file is done)
    // 1: name (just the name, no function like 'GM')
    // 2: job
    // 4: levels
    // 8: map name
    // 16: mapname and coordonates
    // 32: zenys
    // 64: name (with 'GM' if the player is a GM)
    // default value: 1 (only name)
    online_display_option: 1
    // minimum GM level to display 'GM' when we want to display it (default: 1)
    online_gm_display_min_level: 20
    // refresh time (in sec) of the html file in the explorer (default 20)
    online_refresh_html: 20
    import: conf/import/char_conf.txt
    map_athena.conf
    //      ______  __    __                                 
    //     /  _  / __/                                 
    

    //   __  L   ,_  ___      __    ___      __     
    

    // /'__`   __   /   _ `  /'__`/' _ `  /'__`   
    

    ///  __/  /   _    /  __// / / L._ 
    

    // ____ _ _ __ _ _ ____ _ _ __/._
    

    // /____/ /_//_//__/ /_//_//____//_//_//__//_/
    

    //  _   _   _   _   _   _   _     _   _   _   _   _   _
    

    // /  /  /  /  /  /  /    /  /  /  /  /  /  
    

    //( e | n | g | l | i | s | h ) ( A | t | h | e | n | a )
    

    // _/ _/ _/ _/ _/ _/ _/   _/ _/ _/ _/ _/ _/
    

    //
    

    //--------------------------------------------------------------
    

    //eAthena 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: 127.0.0.1
    

    // 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: WAN IP
    

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

    // Scripts
    

    import: npc/scripts_main.conf
    

    // Maps:
    

    import: conf/maps_athena.conf
    

    import: conf/import/map_conf.txt
    

    

    login_athena.conf
    // Athena Login Server configuration file.
    // Translated by Peter Kieser <[email protected]>
    

    // 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.
    

    // The login 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
    

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

    // Whether remote administration is enabled or disabled
    

    admin_state: no
    

    // Administrative password, used by ladmin to connect remotely to server.
    

    // NOTICE: you should change this value for security if you use ladmin.
    

    admin_pass: admin
    

    // Indicate the IP/host that the server accepts for remote administration.
    

    admin_allowed_host: 127.0.0.1
    

    // Console Commands
    

    // Allow for console commands to be used on/off
    

    // This prevents usage of >& log.file
    

    console: off
    

    // Can you use _M/_F to make new accounts on the server?
    

    new_account: yes
    

    // Account registration flood protection system
    

    // allowed_regs is the number of registrations allowed in time_allowed (in seconds)
    

    allowed_regs: 1
    

    time_allowed: 10
    

    // Log Filename. All operations received by the server are logged in this file. 
    

    login_log_filename: log/login.log
    

    // To log the login server?
    

    // NOTE: The login-sql server needs the login logs to enable dynamic pass failure bans.
    

    log_login: yes
    

    // Indicate how to display date in logs, to players, etc.
    

    date_format: %Y-%m-%d %H:%M:%S
    

    // Indicate the minimum GM level of player that the server accepts to connection.
    

    // 0: all players (normal player are 0. it's default), 1-99: GM level at least with level x
    

    min_level_to_connect: 0
    

    // Starting additional sec from now for the limited time at creation of account
    

    // -1: new account are created with UNlimited time (default value)
    

    // 0 or more: new accounts was created by addition of the value (in sec) to the actual time (to set first limited time)
    

    start_limited_time: -1
    

    // Check The clientversion set in the clientinfo ?
    

    check_client_version: no
    

    // What version we would allow to connect? (if the options above is enabled..)
    

    client_version_to_connect: 20
    

    // Store passwords as MD5 hashes instead of plaintext ?
    

    // NOTE: Will not work with clients that use <passwordencrypt>
    

    use_MD5_passwords: no
    

    // Ipban features (SQL only)
    

    ipban.enable: yes
    

    //ipban.sql.db_hostname: 127.0.0.1
    

    //ipban.sql.db_port: 3306
    

    //ipban.sql.db_username: ragnarok
    

    //ipban.sql.db_password: ragnarok
    

    //ipban.sql.db_database: ragnarok
    

    //ipban.sql.codepage: 
    

    //ipban.sql.ipban_table: ipbanlist
    

    // Dynamic password failure ipban system
    

    ipban.dynamic_pass_failure_ban: yes
    

    ipban.dynamic_pass_failure_ban_interval: 5
    

    ipban.dynamic_pass_failure_ban_limit: 7
    

    ipban.dynamic_pass_failure_ban_duration: 5
    

    // Interval (in seconds) to clean up expired IP bans. 0 = disabled. default = 60.
    

    // NOTE: Even if this is disabled, expired IP bans will be cleaned up on login server start/stop.
    

    // Players will still be able to login if an ipban entry exists but the expiration time has already passed.
    

    ipban_cleanup_interval: 60
    

    // Interval (in minutes) to execute a DNS/IP update. Disabled by default.
    

    // Enable it if your server uses a dynamic IP which changes with time.
    

    //ip_sync_interval: 10
    

    // DNS Blacklist Blocking
    

    // If enabled, each incoming connection will be tested against the blacklists
    

    // on the specified dnsbl_servers (comma-separated list)
    

    use_dnsbl: no
    

    dnsbl_servers: dnsbl.deltaanime.net
    

    // Which account engine to use.
    

    // 'auto' selects the first engine available (txt, sql, then others)
    

    // (defaults to auto)
    

    account.engine: auto
    

    // Account data storage configuration
    

    // TXT
    

    account.txt.account_db: save/account.txt
    

    account.txt.case_sensitive: no
    

    // SQL
    

    //account.sql.db_hostname: 127.0.0.1
    

    //account.sql.db_port: 3306
    

    //account.sql.db_username: ragnarok
    

    //account.sql.db_password: ragnarok
    

    //account.sql.db_database: ragnarok
    

    //account.sql.codepage: 
    

    //account.sql.case_sensitive: no
    

    //account.sql.account_db: login
    

    //account.sql.accreg_db: global_reg_value
    

    import: conf/inter_athena.conf
    

    import: conf/import/login_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.0.0.0:WAN IP:WAN IP
    

    subnet: 255.255.255.0:127.0.0.1:127.0.0.1
    

    

    SCLIENTINFO.xml
    <?xml version="1.0" encoding="euc-kr" ?>
    <clientinfo>
    

    <desc>Ragnarok Client Information</desc>
    

    <servicetype>korea</servicetype>
    

    <servertype>sakray</servertype>
    

    <hideaccountlist />
    

    <passwordencrypt />
    

    <passwordencrypt2 />
    

    <extendedslot />
    

    <readfolder />
    

    <connection>
    

    <display>TaheeRO</display>
    

    <desc>TaheeRO</desc>
    

    <balloon>this is a tool tip</balloon>
    

    <address>LAN IP</address>
    

    <port>6900</port>
    

    <version>23</version>
    

    <langtype>1</langtype>
    

    <registrationweb>REGISTRATION URL HERE</registrationweb>
    

    <yellow>
    

    <admin>2000001</admin>
    

    <admin>2000002</admin>
    

    <admin>2000003</admin>
    

    </yellow>
    

    <loading>
    

    <image>loading00.jpg</image>
    

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

    <image>loading10.jpg</image>
    

    </loading>
    

    </connection>
    

    </clientinfo>
    

    

    

						
    
					
    
					
						
    
							

	
    	
		
    
			
				
				
    
					
				
    
			
			
			
		
    
	
    

						
    
					
				
    		
			
    
		
    
	
    18. 

	
	
  18. 
		
    

			

			
    	
				
    
					
    
						
						
      
							
							
						
    
					
    
					



    
	
    
		
			
		
			FAILED TO CONNECT :( EATHENA MYSQL
		
	
    
	
    in Tulong para sa Server
    

    
				
    
				
				
    
					
    
						
						
    
							Posted 
							
								· 


	Edited  by grabs123
	
	

							
														
						
    
						

						
    
							
							

    mga sir i tried also tried ko din sinabi ni mod...good news is nakakagawa na ako ng character after nun failed to connect na naman.
    

    @Sir Will sir...recompiled it already...
    

    used 20100707 <- as the client date..kasi un ung date na gumagana sa txt server ko :D
    

    Anu po gagawin ko? ;)
    

    Ung sa clientinfo po ba? WAN ip or lan?
    

						
    
					
    
					
						
    
							

	
    	
		
    
			
				
				
    
					
				
    
			
			
			
		
    
	
    

						
    
					
				
    		
			
    
		
    
	
    19. 

	
	
  19. 
		
	
    20. 

	
	
  20. 
		
	
    21. 

	
	
  21. 
		
	
    22. 

	
	
  22. 
		
	
    23. 

	
	
  23. 
		
	
    24. 

			

		

	
	

		


	
	

	





			

		


	




								


							

							


						

					

					
				

				

				

			

		

		
		



	

		×
		


    
	





			
				

					
				

			

			

			

			
		

	






	

		×
		

			
    
				
  • Create New...
    •