Jump to content
  • 0

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


Sharpienero

Question


  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   28
  • Joined:  01/16/12
  • Last Seen:  

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 by Sharpienero
  • Upvote 4
Link to comment
Share on other sites

Recommended Posts


  • Group:  Members
  • Topic Count:  39
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   15
  • Joined:  11/17/11
  • Last Seen:  

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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   28
  • Joined:  01/16/12
  • Last Seen:  

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 by Sharpienero
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  142
  • Topics Per Day:  0.03
  • Content Count:  511
  • Reputation:   7
  • Joined:  02/15/12
  • Last Seen:  

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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   28
  • Joined:  01/16/12
  • Last Seen:  

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

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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  1
  • Reputation:   0
  • Joined:  03/06/12
  • Last Seen:  

I will be trying it now. Thanks! :D

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  152
  • Topics Per Day:  0.03
  • Content Count:  569
  • Reputation:   11
  • Joined:  11/24/11
  • Last Seen:  

this is awesome guide! :D

Edited by Will Suranol
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   28
  • Joined:  01/16/12
  • Last Seen:  

I will be trying it now. Thanks! :D

Best of luck to you. c:

this is awesome guide! :D

Thank you! (:

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  20
  • Reputation:   1
  • Joined:  04/10/12
  • Last Seen:  

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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  69
  • Topics Per Day:  0.02
  • Content Count:  1315
  • Reputation:   372
  • Joined:  12/10/11
  • Last Seen:  

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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  7
  • Reputation:   0
  • Joined:  04/18/12
  • Last Seen:  

nice sir.!~!

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  36
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   1
  • Joined:  04/25/12
  • Last Seen:  

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 by elcontrol00
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   28
  • Joined:  01/16/12
  • Last Seen:  

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.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  36
  • Topics Per Day:  0.01
  • Content Count:  236
  • Reputation:   1
  • Joined:  04/25/12
  • Last Seen:  

Thanks to your guide i finished my server thanks. :(

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  1
  • Reputation:   0
  • Joined:  05/14/12
  • Last Seen:  

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

Great video, very helpful!

Edited by kbs
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  1
  • Reputation:   0
  • Joined:  05/19/12
  • Last Seen:  

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?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   28
  • Joined:  01/16/12
  • Last Seen:  

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.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  2
  • Reputation:   0
  • Joined:  06/24/12
  • Last Seen:  

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.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  20
  • Topics Per Day:  0.00
  • Content Count:  213
  • Reputation:   109
  • Joined:  05/21/12
  • Last Seen:  

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 by Cookie
  • Upvote 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   28
  • Joined:  01/16/12
  • Last Seen:  

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.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  2
  • Reputation:   0
  • Joined:  06/24/12
  • Last Seen:  

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 by born2bagamer
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  46
  • Reputation:   1
  • Joined:  07/01/12
  • Last Seen:  

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

/no1

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  112
  • Topics Per Day:  0.03
  • Content Count:  388
  • Reputation:   4
  • Joined:  05/01/12
  • Last Seen:  

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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   28
  • Joined:  01/16/12
  • Last Seen:  

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.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  386
  • Reputation:   28
  • Joined:  01/16/12
  • Last Seen:  

Alright, I've remade this video!

Here is the video now.

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

Edited by Sharpienero
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  1
  • Reputation:   0
  • Joined:  07/12/12
  • Last Seen:  

when is part 2?

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