Not Another Noob Topic >.<

[Elyisa]

Hello everyone! I am currently trying to make a offline private server mainly because I am at college and i cannot port forward my college router >.< lol now i need some help with my folders i have been told to make everything 127.0.0.1 and i have heard to make everything my LAN address but i have no clue which to use and which lines to put it on I have been following the Sharpienero video tutorial which is great so i assumed by making an offline server I would just switch the addresses he put with my LAN or 127.0.0.1 but idk lol For some reason it keeps saying my pass and username is still wrong but everything is fine that i can see idk how to post pics under a spoiler either so i have to post it as a download for right now sry guys =( any help is appreciated heres a pic!

thanks in advance!

-Kris

ScreenShot001.bmp

Edited November 29, 2012 by Elyisa

[Ajjwidjdneidjenw]

if everything is set to 127.0.0.1 you wouldn't have to port forward.

[Elyisa]

well thats where one of my problems lie...lol I have everything set to 127.0.0.1 and it still says it cant connect...which i just want a offline server so yea..haha

[michaelsoftman]

You have to setup your s1/p1 communication passwords.

Both in your conf files and your login table in your SQL database.

[Elyisa]

You have to setup your s1/p1 communication passwords.

Both in your conf files and your login table in your SQL database.

Well everything is exactly the same my username is ragnarok and password is ragnarok in my char_athena and map_athena folder it is also that way on my SQL database do I have to change login_athena at all? whenever i try to start the server(besides the ip issues) it says Error ill post another picture

ScreenShot001.bmp

Edited November 28, 2012 by Elyisa

[michaelsoftman]

This part

// Server Communication username and password.

userid: s1

passwd: p1

Unless you changed that to ragnarok and ragnarok, I think you are looking at the wrong thing. Ragnarok is the default user / pass for mysql, but not the server communication info.

Also, don't upload .bmps D:

[Elyisa]

This part

// Server Communication username and password.

userid: s1

passwd: p1

Unless you changed that to ragnarok and ragnarok, I think you are looking at the wrong thing. Ragnarok is the default user / pass for mysql, but not the server communication info.

Also, don't upload .bmps D:

Well in my char_athena and map_athena under //server communication and //interserver communication it is ragnarok and ragnarok nothing is changed lol any other ideas?

EDIT: I have also fixed the patcher thing for some reason the new client:2012-10-17bRagexeRE.exe doesnt work... i had to revert to an older one and now the patcher runs flawlessly besides a lua error which i can fix but it runs! but for some reason my connection isnt working what should I have under the files in order to play offline(not LAN not Online just on my computer for testing) i dont know what to put T_T if you need pics i can upload them

Edited November 28, 2012 by Elyisa

[michaelsoftman]

Are you using md5 hashes, and the password isn't hashed in your SQL database?

[Elyisa]

Are you using md5 hashes, and the password isn't hashed in your SQL database?

What do you mean by hashes? example pls xD noob here

[michaelsoftman]

In your SQL database, in the login table, what's the user / pass listed as? The default would be s1 / p1, but with MD5 hashes, it would be s1 / ec6ef230f1828039ee794566b9c58adc.

There's an option to turn on MD5 in the conf files, and you have to then change it in your SQL DB.

[Elyisa]

In your SQL database, in the login table, what's the user / pass listed as? The default would be s1 / p1, but with MD5 hashes, it would be s1 / ec6ef230f1828039ee794566b9c58adc.

There's an option to turn on MD5 in the conf files, and you have to then change it in your SQL DB.

here is a picture of my MYSQL Workbench with my login table pulled up ScreenShot001.bmp

[michaelsoftman]

here is a picture of my MYSQL Workbench with my login table pulled up ScreenShot001.bmp

Change the pass to 84c114001520462ff6357ee859cac52d

And then give it a try.

[Elyisa]

here is a picture of my MYSQL Workbench with my login table pulled up ScreenShot001.bmp

Change the pass to 84c114001520462ff6357ee859cac52d

And then give it a try.

Nothing changed it still says the same thing... lol ill post pictures of my char/map/inter/subnet folders

ScreenShot001.bmp

ScreenShot002.bmp

ScreenShot003.bmp

ScreenShot004.bmp

Edited November 29, 2012 by Elyisa

[michaelsoftman]

In the screenshot of your SQL database, you have the password as ragnarok, and in the screenshots you have posted now, you have the password as ragnarok1.

See the problem

[Elyisa]

In the screenshot of your SQL database, you have the password as ragnarok, and in the screenshots you have posted now, you have the password as ragnarok1.

See the problem

oh sry that was just something i tested earlier i changed them back to ragnarok and still nothing lol need any other pics?

[michaelsoftman]

Take a screenshot of the very first error you get when starting the server.

If it's the connection, I can't figure out why, everything should work fine. Only other thing I can think of is your actual mysql user and pass aren't root and tokyojapan like you have it set.

[Elyisa]

Take a screenshot of the very first error you get when starting the server.

If it's the connection, I can't figure out why, everything should work fine. Only other thing I can think of is your actual mysql user and pass aren't root and tokyojapan like you have it set.

Well the first screenshot is the mysql login when i try to get into my database and i confirmed that the password is tokyojapan to enter and my username is root =/ and the second is my charserv-sql.bat where the errors are taking place at the very beginning

ScreenShot001.bmp

ScreenShot002.bmp

[michaelsoftman]

It has to be your communication password for some reason.

Check this in your login.conf, what's it set to?

// Store passwords as MD5 hashes instead of plaintext ?

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

use_MD5_passwords: yes

[Elyisa]

It has to be your communication password for some reason.

Check this in your login.conf, what's it set to?

// Store passwords as MD5 hashes instead of plaintext ?

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

use_MD5_passwords: yes

Heres a pic of what that part of the file looks like

ScreenShot001.bmp

[michaelsoftman]

Well, I'm out of ideas then lol.

Only thing I can recommend is downloading a fresh SVN, using all the default settings, and trying to get it to work. That may give you an idea of what went wrong somewhere.

[Elyisa]

Well, I'm out of ideas then lol.

Only thing I can recommend is downloading a fresh SVN, using all the default settings, and trying to get it to work. That may give you an idea of what went wrong somewhere.

ok ill try that out and update on xD so should i just delete my rAthena folder and thats all? or are there others i must delete as well? =/ sry my 1st time making a server lol

Well, I'm out of ideas then lol.

Only thing I can recommend is downloading a fresh SVN, using all the default settings, and trying to get it to work. That may give you an idea of what went wrong somewhere.

ok everything is running fine i talked to one of my buddies and he said to change something in my localhost file to remove the # which i did and its running flawlessly right now but now i have ran into another problem i keep getting a Rejected From Server now whenever i try to login ill post a pic of my console and client when it happens I also get a lua error even though my lua files r updated =/ thats the second picture

ScreenShot001.bmp

ScreenShot002.bmp

Edited November 29, 2012 by Elyisa