[Guide] Osrose helping guide [Fixing problems]

This guide is fully updated in 19/6/2010
> I guess this is only helpfull for Osrose v81. <

Hey Ragezone users, i started my own rose server,
and i experienced a few buggs or mistakes i made myself, that i why i want to share how to fix these, because allot of posts are asking for the fixes of these, im not a pro for sure in rose servers, but i think this will help a bit atleast.

[Please remind that i never made a real guide before, this will be my first!]


Table of contents;
1. A few things about Osrose
2. Most common problems with mysql server.
3. Most common problems with ''Server under maintenance''
4. Most common problems with running World, Char & Login .exe
5. Navicat problems
6. Most common ingame questions.
7. What to do if you really cant get it working.
8. Closing words + Extra help.
9. Links to guides and credits!








Lets get started;

1. A few things bout Osrose.

Osrose is an emulator which gives you the abbility to run your own rose online private server. There is also an Osirose but i never used that Emu. If you got it down how to get up your own server it will be very easy to manage this, or let your friends play!

The time that it takes:
Never had a server before : Around a week
Had another kind of server: 5 Days
Experienced in setting up servers: I guess a few hours?

Also, the guide from Aukemon0NL is very detailed and will show you the basics, this is just to fix a few problems.
(look at the bottom for the links)





2.

Most common problems with the Mysql server;

At first, the mysql server is needed to run Navicat, which can manager your database. Also, it will be needed to let yourself & your friends play.

Problems:

What if it says port 3306 is not opened, and i opened my router for sure!

A: This is because you didnt open it on your firewall, to open it go to

firewall ; Advanced settings ; Rules for incoming connections ; Add rule ; Make sure 'port' is checked ; then click the green area ; type 3306 ; click apply ; give it a name ; click apply ; there we go.

A second way, just click 'Add firewall exeption to this port at the last part of the Mysql server setup. (Didnt work very well for me).


What if i only can click apply when i want to install Mysql, instead of setting it up completely?

A: You have to make sure you have uninstalled every other Mysql service which could be running or causing trouble, this was my problem.


When i click execute at the last part of the setting up, it starts to apply, but at starting service it wont get ready, then my setup screen freezes and closes.

A: This is caused by already running Mysql, maybe on 'XAMPP' or maybe you have moved it into another map while installing. Just make sure to follow the Mysql setup part on Aukemon0NL's guide.

- End of the Mysql part.






3. 'servers under maintenance' fix

Well, if it displays this message when you try to relogg you dont really have to worry, its mostly caused by;

1. Wrong connection IPs,
2. Wrong Subnets/LAN
3. Setted up wrong on Mysql

Fix num 1/2: Check your 'binary' folder (from where you extracted your files for navicat) and click on Characterserver.CONF, Worldserver.CONF or loginserver.CONF, then check 'serverip' at all three .CONF files, the servip ip should be your WAN-IP (Which you can find on www.Whatismyip.org or whatsmyip.com. Just copy the code you find there and paste it after 'Serverip' in your .CONF files.

Fix num 3.
Please open 'MySql server instance config wizard' and check if you filled in everything and you filled it in right. Most of the time the 'Inspection' message is NOT caused by this.

Also, you will have to open some ports, on your router AND firewall (How to open on firewall is explained above)

Ports to be opened
3306, 80, 29000 29100 29200.

-End of Maintenance part




4. Most common problems with running the Worldserver.exe, Charserver.exe and the Loginserver.exe.

If you start one of these 3 and it gives a [FATAL ERROR] you will have to check if you imported EVERYTHING in your mysql database, very often the uploaded file ''Roseon'' from binary DOES NOT contain characters, channels and MOB_list.

So, if it says [FATAL]Error - Could not find MOB_LIST or CHANNELS, or whatever,
just,

Right click roseon ; Execute batch file ; Browse to your binary ; database ; Then click the files that were displayed after the [FATAL] Error ; click apply ; it will load up ; click exit ; restart Navicat.

> This goes for every file that those 3 display <

-Now the table that you were missing on worldserver, charserver or loginserver is added to your database and will be able to run now.



-End of World, char & Login server problems.






5. Navicat problems!

Navicat is a very usefull progamm used to manage and store databases for your server, there are just a few problem with this program because its so easy.

At first;

The probemlem when you double click localhost.

It will say: Cannot connect to Mysql, PASSWORD=NO.

When you set up your MySQL it asks if you would like to modify the security settings by adding a password. If you get this message, you set a password to your MySQL and are trying to create a connection to it without using a password. There is an alternative side to this as well; if you uncheck the 'Modify Security Settings' box and try to connect using a password, you'll get a error message that has USING PASSWORD=YES in it. So set up a password and try again. Also see Solution #2.

Still not fixed?

Then Open 'MySql server instance config wizard' and redo everything just like you did before, after that, restart your PC and try again.

-End of the Navicat part.








6. Most common ingame questions.

1. How can i get all those commands down?

A: Just learn by playing (JUst like in Dora the Explorer ft'w)
This are the commands you could need;

/tele [map] [x] [y] - teleport
/b - broadcast
/save - save character data
/reload - reload config.ini
/ann [msg] - announcement
/SSPAWN [monid] [min] [max] - startspawn
/SET - setspawnlocation
/ESPAWN [monid] [aggressive] - endspawn
/DSPAWN [id] [monid] [min] [max] [respawn time] [aggressive]- dupespawn
/DELETESPAWN [id] - delete spawn by id
/pak - read packet.txt and send it
/pak2 - read packet2.txt and send it
/level [lvl] - change lvl
/class [id] - change your class, must relog after
/info - show info
/exp [amt] - give yourself exp
/mon [monid] [count] - spawn monsters
/kick [charname] - kick player from game
/job [jobname] - finish first job quest
/set [id] [refine] - set full armor to [id] with [refine]
/cha [slotname] [id] [stats] - cha slot to [id] with [stats]
/item [id] [type] [amt] - get item
/levelup - go to next level
/drop [type] [id] - drop an item
/givezuly [charname] [amt] - give someone zuly
/npc [id] - spawn an npc
/givefairy [charname] [flag] - give/remove fairy (1/0)
/move [charname] [map] [x] [y] - tele someone
/goto [charname] - goto someone
/teletome [charname] - bring someone here
/playerinfo [charname] - get player infor
/give2 [charname] [id] [type] [amt] - give someone item(s)
/ban [charname] - ban a player
/buff [id] - buff yourself
/ani [id] - do animation
/summon [monid] - summon monstor (to help you)
/reloadquest - reload quest info
/shutdown [minutes] - shutdown server in x minutes
/dquest - debug quests
/iquest [id] <amt> - get items for quest (i think)

>Check the link section in bottom for a link to every single item code<

2. What about changing codes like /go for every player?

This is easy, every player has an acceslevel, you can change this in navicat at accounts. But its more usefull to just open commands.INI in your binary folder (Just under characterserver.exe) and change /go or any command you want to 99, because everyones standard acceslevel is 100, isnt that easy? =P
-To make yourself [GM] Make yourself acceslevel 500-

Trose errors ?

When you are having an error ingame saying;

Client doesn't answer or Trose _ Ignore or _Cancel you will have to run Triggerdetect.exe before starting up your server, make sure you fill in your own graphic card settings.


Screen just poping away when logging in?
This is caused by your graphics card or by the way of running the game, at first try to run it as admin, if that doesnt help, you should also run triggerdetect.exe.


- End of the ingame part.






7. What to do if you really cant get it working.

If you really cant get your own server to work, you will have to search on;

osROSE Forums &bull; Index page (This is the site of the DEV's of Osirose & Osrose emulators. Also Ragzone has a huge amount of posts of guides to help and so on.
Please remind the following things when asking for help;

-Describe exactly what the problem is.
-Tell them what emu you are using.
-Tell them what OS you are using (win7, Vista, etc)
(Links in Links section)






8. Closing words

Well, i hope you learned something from this guide, it only describes the most common problems from Osrose, not really little problems, it was fun to make a guide like this!'

Extra help to let your friends play;

Follow the complete guide on http://forum.ragezone.com/f291/osros...-guide-618620/ and just change your Serverip to your WAN IP - Explained above.

Also, if your still having problems with letting your friends connect, please check the guide of Lmame (In link section)

-End of extra help & Closing words.




9. Links & Credits.

Link to Evo rose setup guide v81.
http://forum.ragezone.com/f291/osros...-guide-618620/

Link to Osrose site
osRose :: osiRose :: dev Team - Home

Link to Osrose forum
osROSE Forums &bull; Index page

Link for letting your friends connect help
Connecting your friends

Link to help with portforwarding
http://forum.dev-osrose.com/viewtopic.php?f=18&t=2488


Credits

Credits for helping me getting information.

-Lmame
-PurpleYouko
-Perrin9028

Credits for the commands:

-Aukemon0NL

Credits for the rest of the guide:

-Myself

-If i forgot someon please tell me, also tell me if i forgot a section or link, please remind that i will handle CMS & XAMPP in my next guide.


- End of my 'epic' guide. :w00t:



------------------------------------------------------------>
Thats the right way to the THANKS BUTTON =']

Good guide I will add this to my Problem part of the guide.
It will be a little more helpfull than what it has now...

I'd like to point out some things here...
From my quick glance through, I noticed some problems...

Firstly, a couple of hours is WAY too long to be setting up a server, are you making a website to go along with that server as well? Could make one in 20-25 minutes with a good internet connection if you know what you're doing.

Secondly, in the NaviCat error section, USING PASSWORD=NO is surprisingly about passwords as far as you don't know. When you set up your MySQL it asks if you would like to modify the security settings by adding a password. If you get this message, you set a password to your MySQL and are trying to create a connection to it without using a password. There is an alternative side to this as well; if you uncheck the 'Modify Security Settings' box and try to connect using a password, you'll get a error message that has USING PASSWORD=YES in it.

Just saw another one in the IP problems area, your WAN IP is not your LAN IP, you will not get either your LAN IP or your SubNet Mask from whatsmyip.com . To get these, open up your Start Menu and click Run if on XP, or search for Run on Vista/7. Once your Run prompt is open, type cmd and press Okay or Enter and a command prompt will pop up. In here, type ipconfig or ipconfig \all and a bunch of IPs will magically appear which you'll then have to decipher using only common sense and your eyes!

You also forgot two very basic in-game problems; the TRose.exe error fixed by running TriggerDetect.exe and the one where R.O.S.E. closes for no apparent reason which may be caused by your graphics drivers not being up to date, in which case you should go to the card's manufacturer's website where they should have driver updates available. Take for instance, you have an NVIDIA/RADEON card, guess where you go? The NVIDIA/RADEON website!

Just my two-cents on the subject.

I'd like to add one or two things :)

Read the guide I made about the sublanmask which is very important:
osROSE Forums - [GUIDE] IP/Port Forwarding for osRose

And you don't need (and you shouldn't in fact) to open the port for MySQL 3306 since it's only accessed by the servers itself.

Oh and last point, it's Lmame ;)