Sharpienero Posted March 5, 2012 Posted March 5, 2012 (edited) 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 4 Quote
Drakkus Posted March 5, 2012 Posted March 5, 2012 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 Quote
Sharpienero Posted March 5, 2012 Author Posted March 5, 2012 (edited) 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 Quote
WhatFT Posted March 6, 2012 Posted March 6, 2012 Nice guide but can you also give the links you've used? Thanks Quote
Sharpienero Posted March 6, 2012 Author Posted March 6, 2012 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. Quote
Petey Pablo Posted March 6, 2012 Posted March 6, 2012 (edited) this is awesome guide! Edited March 6, 2012 by Will Suranol Quote
Sharpienero Posted March 7, 2012 Author Posted March 7, 2012 I will be trying it now. Thanks! Best of luck to you. c: this is awesome guide! Thank you! (: Quote
Damaso Posted April 11, 2012 Posted April 11, 2012 [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 ... Quote
Arcenciel Posted April 15, 2012 Posted April 15, 2012 [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. Quote
elcontrol00 Posted April 25, 2012 Posted April 25, 2012 (edited) 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 Quote
Sharpienero Posted May 14, 2012 Author Posted May 14, 2012 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. Quote
elcontrol00 Posted May 14, 2012 Posted May 14, 2012 Thanks to your guide i finished my server thanks. Quote
kbs Posted May 14, 2012 Posted May 14, 2012 (edited) 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 Quote
naughty Posted May 19, 2012 Posted May 19, 2012 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? Quote
Sharpienero Posted June 15, 2012 Author Posted June 15, 2012 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. Quote
born2bagamer Posted June 24, 2012 Posted June 24, 2012 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. Quote
Cookie Posted June 29, 2012 Posted June 29, 2012 (edited) 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 1 Quote
Sharpienero Posted June 29, 2012 Author Posted June 29, 2012 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. Quote
born2bagamer Posted June 29, 2012 Posted June 29, 2012 (edited) 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 Quote
ADMxRain Posted July 1, 2012 Posted July 1, 2012 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 Quote
kangfredy Posted July 9, 2012 Posted July 9, 2012 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 Quote
Sharpienero Posted July 9, 2012 Author Posted July 9, 2012 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. Quote
Sharpienero Posted July 13, 2012 Author Posted July 13, 2012 (edited) 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 Quote
Question
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 by SharpieneroTop Posters For This Question
38
10
6
6
Popular Days
Jul 18
16
Jul 19
16
Jul 17
12
Jul 16
7
Top Posters For This Question
Sharpienero 38 posts
Zaden 10 posts
ADMxRain 6 posts
mooncbz 6 posts
Popular Days
Jul 18 2012
16 posts
Jul 19 2012
16 posts
Jul 17 2012
12 posts
Jul 16 2012
7 posts
Popular Posts
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 you
Sharpienero
Thank you! I am starting the video now, and I will keep your post in mind. Part 2 - http://www.youtube.com/watch?v=CtDRZki3Hpo&feature=youtu.be Part 3 - http://www.youtube.com/watch?v=UT3bHi
Cookie
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/databas
Posted Images
131 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.