Are there meant to be this many SQL problems? and unable to connect to map server

[keoco]

I keep getting SQL errors... like the screenshots stated... i thought the main.sql would have all of it but i guess not... so is this normal to get that many sql problems? also when entering the server, i get stuck and unable to connect to the map server... sorry for asking soo many questions... ~___~

[JayPee]

you did not import the sql files which can be found @ sql-files folder inside your server files.

Base on the screenshot you did not import

item_db_re.sql

item_db2.sql

mob_db.sql

mob_skill_db.sql

mob_skill_db2.sql

which all of them can be found @ sql-files folder

[Judas]

means that in ths sql-files folder you have to execute those files as well

https://rathena.svn....runk/sql-files/

Edited January 25, 2012 by Judas

[keoco]

means that in ths sql-files folder you have to execute those files as well

https://rathena.svn....runk/sql-files/

you did not import the sql files which can be found @ sql-files folder inside your server files.

Base on the screenshot you did not import

item_db_re.sql

item_db2.sql

mob_db.sql

mob_skill_db.sql

mob_skill_db2.sql

which all of them can be found @ sql-files folder

thanks guys, it got rid of the errors, but now i still cant log on to the server... it just keeps saying "failed to connect to server" , the servers arent showing any abnormalities...

[ngek202]

check your ip on clientinfo.xml

[keoco]

check your ip on clientinfo.xml

i had a feeling it had something to do with it... which IP should it be?

also:

[info] Closed connection from "192.xxx.x.x"

Edited January 25, 2012 by keoco

[ngek202]

if ur just using it as a test on your own pc then configure it with what ip your using on char_athena.conf and map_athena.conf by default it's 127.0.0.1

[keoco]

i did that.. i also tried wan IP and it didnt work...

[Judas]

well if you try localhost you should be able to connect,

[keoco]

tried localhost on clientinfo.xml

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

<desc>Ragnarok Client Information</desc>

<servicetype>korea</servicetype>

<servertype>sakray</servertype>

<extendedslot></extendedslot>

<readfolder></readfolder>

<connection>

<display>Ragnarok Online</display>

<desc>none</desc>

<balloon>lol</balloon>

<address>localhost</address>

<port>6900</port>

<version>0</version>

<langtype>0</langtype>

<registrationweb>Web site</registrationweb>

<aid>

<admin>2000000</admin>

</aid>

</connection>

</clientinfo>

however it still didnt work...

[Judas]

what client are you using

[keoco]

i used this http://rathena.org/board/topic/54190-release-basic-rathena-client/

i basically downloaded and used the latest SVN, set it up, and dragged in everything from that "Basic Rathena client"

[Amellia sizilia sembiring]

set it address= 127.0.0.1, version=22, langtype= 1

It will connect

[keoco]

that didnt work either... still says "failed to connect to server" :|

[ngek202]

<address>127.0.0.1</address>

didn't work?

[keoco]

<address>127.0.0.1</address>

didn't work?

nope.. didnt work man... unless i need to change it to 127.0.01 even on char_athena.conf & map_athena.conf...

[JayPee]

can you post your char_athena.conf, login_athena.conf and map_athena.conf

[keoco]

char_athena.conf

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

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

// Character Server Port

char_port: 6121

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

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

//If new_account is enabled, minimum length to userid and passwords should be 4?

//Must be 'Yes' unless your client uses both 'Disable 4 LetterUserID/Password' Diffs

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

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

map_athena.conf

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

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

// Map Server Port

map_port: 5121

i copied what was important only for char and map, i just realised i havent done anything for login_athena though :|

[Amellia sizilia sembiring]

Set login_ip, map_ip, and char_ip to 127.0.0.1 if you want to host on WAN change that match your WAN IP. then make sure you're open incoming connection both on NAT and PORT.

It will solved it

Edited January 25, 2012 by Amellia sizilia sembiring

[Lightning]

are the IPs intentionally different? if this is a local server change map_ip, char_ip and login_ip to 127.0.0.1

[Magnetix]

Use the following:

conf/char_athena.conf

login_ip: 127.0.0.1
char_ip: 127.0.0.1

conf/map_athena.conf

char_ip: 127.0.0.1
map_ip: 127.0.0.1

conf/login_athena.conf

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

search your clientinfo.xml and replace with these values

<address>127.0.0.1</address>
<port>6900</port>

make sure clientinfo.xml is found inside your data folder, not outside nor the other folders(if you have any)

that are also found inside data folder.

Edited January 25, 2012 by Magnetix

[keoco]

are the IPs intentionally different? if this is a local server change map_ip, char_ip and login_ip to 127.0.0.1

this worked! thankss

Use the following:

conf/char_athena.conf

login_ip: 127.0.0.1
char_ip: 127.0.0.1

conf/map_athena.conf

char_ip: 127.0.0.1
map_ip: 127.0.0.1

conf/login_athena.conf

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

search your clientinfo.xml and replace with these values

<address>127.0.0.1</address>
<port>6900</port>

make sure clientinfo.xml is found inside your data folder, not outside nor the other folders(if you have any)

that are also found inside data folder.

i did this too~ thanks soo much for the help guys