[Video Series - Sharpienero] Setting up your rAthena Private Server

[Sharpienero]

In reference to this and all future post. Please avoid making this topic into a Support Topic of all kinds.

Part 1 - Setting up your server.

http://tinyurl.com/7dcwdz2

Part 2 - Getting onto your server.

http://tinyurl.com/7nqunos

Part 3 - All about groups.conf and setting server admins and GM's.

http://tinyurl.com/7u6c442

Part 4 - Adding custom NPCs

http://tinyurl.com/8x359bt

Edited June 2, 2013 by Sharpienero

[Drakkus]

So far, the VIDEO very well understand, somehow i didn't see your 'VIDEO' with another MySQL Tutorials for 'MySQL Administrator'

You need to Import them ">>" and 'Apply Changes' for the 'Schema Privileges' or else it will show MySQL Error.

and also check your /conf/files

Following:

char_athena.conf

map_athena.conf --> You forgot to config this also, that's why it shows [Error] on your mapserv.sql.exe.

Regards,

Mindless

[Sharpienero]

So far, the VIDEO very well understand, somehow i didn't see your 'VIDEO' with another MySQL Tutorials for 'MySQL Administrator'

You need to Import them ">>" and 'Apply Changes' for the 'Schema Privileges' or else it will show MySQL Error.

and also check your /conf/files

Following:

char_athena.conf

map_athena.conf --> You forgot to config this also, that's why it shows [Error] on your mapserv.sql.exe.

Regards,

Mindless

I configured them both. I just looked them over as well. EDIT - I saw the issue. I forgot to remove //. I'm making an annotation now.

And @ the mysql ">>", don't you mean "<<"? o: I forgot about that step because I already did it waayyyyy before this video was made.

Edited March 5, 2012 by Sharpienero

[WhatFT]

Nice guide but can you also give the links you've used? Thanks

[Sharpienero]

Nice guide but can you also give the links you've used? Thanks

They're on the youtube video, but I'll also upload them here.

[kitnam]

I will be trying it now. Thanks!

[Petey Pablo]

this is awesome guide!

Edited March 6, 2012 by Will Suranol

[Sharpienero]

I will be trying it now. Thanks!

Best of luck to you. c:

this is awesome guide!

Thank you! (:

[Damaso]

[string "buf"]:10: attempt to call global 'Iter_getTable' (a nil value)

have you ever encountered this one? teach me how to fix this please ...

[Arcenciel]

[string "buf"]:10: attempt to call global 'Iter_getTable' (a nil value)

have you ever encountered this one? teach me how to fix this please ...

In reference to this and all future post. Please avoid making this topic into a Support Topic of all kinds.

[cuddleme]

nice sir.!~!

[elcontrol00]

In the last step where it says to put slq. db_password. Well i don't have a password on my mysql can i leave it blank or just leave the ragnarok?

Edited April 26, 2012 by elcontrol00

[Sharpienero]

In the last step where it says to put slq. db_password. Well i don't have a password on my mysql can i leave it blank or just leave the ragnarok?

I recommend having a password for mysql.

But yes, you can leave it blank.

[elcontrol00]

Thanks to your guide i finished my server thanks.

[kbs]

Had a big long question typed but I ended up figuring it out but still thanks for the info

Great video, very helpful!

Edited May 14, 2012 by kbs

[naughty]

hi, i have watched and followed your step from the video, but i cant log in to the games....Reject from Server (137) it shown, do you know how to solve it?

[Sharpienero]

hi, i have watched and followed your step from the video, but i cant log in to the games....Reject from Server (137) it shown, do you know how to solve it?

Did you port forward correctly? Sorry for the late response.

[born2bagamer]

Hey Sharpie, thanks for the video. I am stuck on the part about schema privileges. I am getting an error saying "unknown database 'rathena' when I try to add the new connection. Would you mind making another short video about schema privileges, or go into more detail here about how to do such a thing? I haven't messed with MySQL before so I am actually learning as I go.

[Cookie]

Hey Sharpie, thanks for the video. I am stuck on the part about schema privileges. I am getting an error saying "unknown database 'rathena' when I try to add the new connection. Would you mind making another short video about schema privileges, or go into more detail here about how to do such a thing? I haven't messed with MySQL before so I am actually learning as I go.

This is likely because at that point you haven't created a database named 'rathena'. That is the login to MySQL. If this is, I'm assuming, your first time logging in there will not be a schema/database created.

Run this in the query execution area after you've logged in:

CREATE SCHEMA `rathena`;

Side-note, on permissions, you won't need to set permissions if using root as your login. On the other hand, I highly suggest only using a root login for testing purposes (i.e. test server) and do not on a production server; it's not best practices.

Edited June 29, 2012 by Cookie

[Sharpienero]

Hey Sharpie, thanks for the video. I am stuck on the part about schema privileges. I am getting an error saying "unknown database 'rathena' when I try to add the new connection. Would you mind making another short video about schema privileges, or go into more detail here about how to do such a thing? I haven't messed with MySQL before so I am actually learning as I go.

This is likely because at that point you haven't created a database named 'rathena'. That is the login to MySQL. If this is, I'm assuming, your first time logging in there will not be a schema/database created.

Run this in the query execution area after you've logged in:

CREATE SCHEMA `rathena`;

Side-note, on permissions, you won't need to set permissions if using root as your login. On the other hand, I highly suggest only using a root login for testing purposes (i.e. test server) and do not on a production server; it's not best practices.

Thanks, I didn't even see his post.

[born2bagamer]

Thanks for the help Cookie. I am going to start over and try it again.

On a side note, what I am looking to do is create a server for my friends and I. We have been wanting to play old school RO, ie. before transcendent classes. After this many years, how difficult would it be to setup a server that excludes everything after say Juno?

Edited June 29, 2012 by born2bagamer

[ADMxRain]

Hi Can you post the link of the applications you used

Cause in the youtube channel the link there is the website of the application and i dont know what version there to download.

thanks

[kangfredy]

but,how to upload on vps?it's same if i want to install in vps??in that video please make tutorial how to install mysql and xampp

[Sharpienero]

but,how to upload on vps?it's same if i want to install in vps??in that video please make tutorial how to install mysql and xampp

It's the same thing, I believe.

I will be re-making this video sometime soon due to mysql being EOL'd.

[Sharpienero]

Alright, I've remade this video!

Here is the video now.

[media=]http://www.youtube.com/watch?v=3LTOOEjRtUo&feature=youtu.be[/media]

Edited July 13, 2012 by Sharpienero

[Geonode]

when is part 2?