Jump to content
  • 0

FIXED please close topic


saverem

Question


  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  28
  • Reputation:   0
  • Joined:  09/05/14
  • Last Seen:  

hello all, i'm trying to set up the rathena server and i'm having trouble getting it started.

 

ok, so when i click on the run server.bat:

 

-the mapserv.bat has no problems, everything is green.

-but then the logserv.bat has the "access denied for user "ragnarok'@'localhost' (using password: YES)

-and the charserv.bat has the make connection to loggin server failed (socket #3 error 10061)

 

 

i believe it's something to do with my login server.bat, it has the access denied problem and the char server can't connect to the log server as well. how do i solve this problem?

 

thanks in advance! =D

Edited by saverem
Link to comment
Share on other sites

14 answers to this question

Recommended Posts


  • Group:  Developer
  • Topic Count:  153
  • Topics Per Day:  0.04
  • Content Count:  2285
  • Reputation:   745
  • Joined:  06/16/12
  • Last Seen:  

if u're using default, I see a trailing white space

ipban_db_pw: ragnarok 

just try retype every config that u need on conf/import, see conf/import-tmpl for the files

  • Upvote 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  782
  • Reputation:   82
  • Joined:  01/01/12
  • Last Seen:  

rA Installation Wiki : http://rathena.org/wiki/Installation_on_Windows

 

I assume you did not create a new SQL user ragnarok/ragnarok yet? also make sure you didn't open multi instances of these serv.bat

 

Welcome to rA anyway :P

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  28
  • Reputation:   0
  • Joined:  09/05/14
  • Last Seen:  

rA Installation Wiki : http://rathena.org/wiki/Installation_on_Windows

 

I assume you did not create a new SQL user ragnarok/ragnarok yet? also make sure you didn't open multi instances of these serv.bat

 

Welcome to rA anyway :P

 

yup i followed that guide. but might've messed up or missed a step or two, if so please help me indentify which steps i missed.

 

i set up the sql ragnarok/log schemas. but not too sure about what u mean by sql user ragnarok/ragnarok. what's that?

 

also, how do i make sure i didn't open multiple instances of these serv.bat? i might have to reboot comp to see if that changes things

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  782
  • Reputation:   82
  • Joined:  01/01/12
  • Last Seen:  

For local hosting you should have a user ragnarok/ragnarok to access your MySQL db.

 

You need to add one like this in your MySQL tools (Not sure which one you using, could be MySQL Administrator Tool, MySQL Workbench or others)

XSYOtZ7.png

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  28
  • Reputation:   0
  • Joined:  09/05/14
  • Last Seen:  

For local hosting you should have a user ragnarok/ragnarok to access your MySQL db.

 

You need to add one like this in your MySQL tools (Not sure which one you using, could be MySQL Administrator Tool, MySQL Workbench or others)

XSYOtZ7.png

hiya, thanks for replying so fast.

 

i do have somehting similar to yours. although on my left tab section, i only have the root and the ragnarok % one:

 

i dun think i'm missing this.

 

besides, out of my 3 servers.bats:

-my map server i think works fine

-my char server connects fine, until it tries to connect to the login server, then it fails

-my login server fails to access.

 

which means the basic connection should be fine right? but i messed up some kind of setting regarding the login server right? i dunno @.@

 

how do i fix this problem? help please!

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  782
  • Reputation:   82
  • Joined:  01/01/12
  • Last Seen:  

Well before trying WAN IP, try only using localhost / 127.0.0.1 to start the server. Edit all the conf (map, login, char) and also don't forget to port forward 5121, 6121, 6900.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  28
  • Reputation:   0
  • Joined:  09/05/14
  • Last Seen:  

Well before trying WAN IP, try only using localhost / 127.0.0.1 to start the server. Edit all the conf (map, login, char) and also don't forget to port forward 5121, 6121, 6900.

 

yup, right now i'm jsut trying the server out via local machine 127.0.0.1

my main goal was to create a small server between friends (5-10 ppl).

but even now, while using 127.0.0.1, the login server is not connecting. T.T

 

 

also, a question regarding the port foward. since i'm just trying it local (127.0.0.1) is it neccessary to port foward the 5121, 6121, 6900 to get the local server to work?

 

 

ultimately tho, right now, out of the 3 rathena server.bat, map and char servers work fine, but the login server has a problem. it can't acces for some reason.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  782
  • Reputation:   82
  • Joined:  01/01/12
  • Last Seen:  

If you are using Windows there are chances your Windows Firewall are blocking its access. But usually they are automatically added to exception.

 

o2KZxN2.png

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  28
  • Reputation:   0
  • Joined:  09/05/14
  • Last Seen:  

If you are using Windows there are chances your Windows Firewall are blocking its access. But usually they are automatically added to exception.

 

o2KZxN2.png

ok i think i found out what t eproblem is, when i tried the login server bat again, there was a debug message that led me to the ipban.c file:

 

debug: at ..\src\log\ipban.c:216

 

 

Edited by saverem
Link to comment
Share on other sites


  • Group:  Developer
  • Topic Count:  153
  • Topics Per Day:  0.04
  • Content Count:  2285
  • Reputation:   745
  • Joined:  06/16/12
  • Last Seen:  

make sure everything are written correctly for conf/inter_athena.conf#L28-L65.

// MySQL Login server
login_server_ip: 127.0.0.1
login_server_port: 3306
login_server_id: ragnarok
login_server_pw: ragnarok
login_server_db: ragnarok
login_codepage:
login_case_sensitive: no
 
ipban_db_ip: 127.0.0.1
ipban_db_port: 3306
ipban_db_id: ragnarok
ipban_db_pw: ragnarok 
ipban_db_db: ragnarok
ipban_codepage:
 
// MySQL Character server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: ragnarok
char_server_pw: ragnarok
char_server_db: ragnarok
 
// MySQL Map Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: ragnarok
map_server_pw: ragnarok
map_server_db: ragnarok
 
// MySQL Log Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: ragnarok
log_db_pw: ragnarok
log_db_db: ragnarok
log_codepage:
log_login_db: loginlog

since 2d2991a we cleaned TXT server leftovers, and some changes made for server config files.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  28
  • Reputation:   0
  • Joined:  09/05/14
  • Last Seen:  

make sure everything are written correctly for conf/inter_athena.conf#L28-L65.

// MySQL Login server
login_server_ip: 127.0.0.1
login_server_port: 3306
login_server_id: ragnarok
login_server_pw: ragnarok
login_server_db: ragnarok
login_codepage:
login_case_sensitive: no
 
ipban_db_ip: 127.0.0.1
ipban_db_port: 3306
ipban_db_id: ragnarok
ipban_db_pw: ragnarok 
ipban_db_db: ragnarok
ipban_codepage:
 
// MySQL Character server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: ragnarok
char_server_pw: ragnarok
char_server_db: ragnarok
 
// MySQL Map Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: ragnarok
map_server_pw: ragnarok
map_server_db: ragnarok
 
// MySQL Log Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: ragnarok
log_db_pw: ragnarok
log_db_db: ragnarok
log_codepage:
log_login_db: loginlog

since 2d2991a we cleaned TXT server leftovers, and some changes made for server config files.

 

yup i think they're correct. i've also reset the sql side for all the user and pass to "ragnarok" to simplify this processs, so that my inter athena conf file wont even need to be changed, since the default password is "ragnarok"

 

but after i recompiled the server.bats the same problem still occurs. my login server still has access denied at the ragnarok@localhost (using password: yes)

 

weird.

 

once again, the other 2 servers seems to be fine ( i think). they connected but fail when they interact with the login server.

 

here is a copy and paste of my inter athena conf from those same lines:

 

// MySQL Login server

login_server_ip: 127.0.0.1

login_server_port: 3306

login_server_id: ragnarok

login_server_pw: ragnarok

login_server_db: ragnarok

login_codepage:

login_case_sensitive: no

ipban_db_ip: 127.0.0.1

ipban_db_port: 3306

ipban_db_id: ragnarok

ipban_db_pw: ragnarok

ipban_db_db: ragnarok

ipban_codepage:

// MySQL Character server

char_server_ip: 127.0.0.1

char_server_port: 3306

char_server_id: ragnarok

char_server_pw: ragnarok

char_server_db: ragnarok

// MySQL Map Server

map_server_ip: 127.0.0.1

map_server_port: 3306

map_server_id: ragnarok

map_server_pw: ragnarok

map_server_db: ragnarok

// MySQL Log Database

log_db_ip: 127.0.0.1

log_db_port: 3306

log_db_id: ragnarok

log_db_pw: ragnarok

log_db_db: log

log_codepage:

log_login_db: loginlog

 

 

hmm i seem to be using log db db as "log" instead of "ragnarok" tho. was just folling the instructions on here: http://rathena.org/wiki/Installation_on_Windows

 

here are screenshots of the server batspost-28740-0-84348300-1410476992_thumb.jpg

post-28740-0-16179800-1410477354_thumb.jpgpost-28740-0-06920900-1410477364_thumb.jpg

also here is a copy of my ipban.c, since the login server kept saying debug at 216 and i have no idea how to read it T.T

 

i renamed the ipban.c into ipban.txt so that it can be uploaded. change back to .c if u can't open it

ipban.txt

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  28
  • Reputation:   0
  • Joined:  09/05/14
  • Last Seen:  

if u're using default, I see a trailing white space

ipban_db_pw: ragnarok 

just try retype every config that u need on conf/import, see conf/import-tmpl for the files

what do u mean by trailing white space?

i dun get it. sorry kinda new to this. still in the figuring stuff out process T.T

 

i'll try out the conf/import folders in a lil bit. meanwhile, do you know what the debug at ipban.c 216 means? i think this is the key to figuring out what is preventing the login server from working. it's in the screenshot from my previous post.

 

k i'll try to retype the import folder conf files. hopefully that fixes it

 

really need the help tho. have no idea what's wrong with it. the worst part is, the other servers work. char and map servers seem to be fine, except the login server which has a problem. so i think i must've done something right, but missed a step somewhere or edited the files wrong.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.00
  • Content Count:  139
  • Reputation:   24
  • Joined:  09/02/12
  • Last Seen:  

i thought it was my fault that i ruined my server... damn whitespace. thanks for quick solution.

Link to comment
Share on other sites


  • Group:  Developer
  • Topic Count:  153
  • Topics Per Day:  0.04
  • Content Count:  2285
  • Reputation:   745
  • Joined:  06/16/12
  • Last Seen:  

@saverem, can u set the topic as before? it's better leave it like that. Thank you :)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...