[MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

[smackthat111]

that 5.0 thing u said makes no changes..still getting the same errror..
damn annoying

 

[Akai]

Ok, I went to bed and I get another 2 pages of people having errors

Ok, for everything not being able to connect using Navicat, you need to install MySQL.
Link:

To view the content, you need to sign in or register

localhost/install worked for me, but placing my IP in wouldn't load the page. And that could possibly direct me to what's wrong with my setup.

You need to port forward the port 80, read the problems section and this explains your problem exactly and a solution.

Akai, when I run the EXEs they run fine BUT they say "user connected from 127.0.0.1", even though I changed everything to my IP. Is that an error there?

EDIT: Sorry for all those posts, Akai.

It's supposed to say that, it's fine.

I have a problem with navicat it says :
"2003 - can't connect to mysql server on "localhost" (10061)"

Read above, you need to install MySQL.
Link:

To view the content, you need to sign in or register

I have tryed all the IPs I can :
- Other players can play but not me or
- I can play but not the others !

The ports are forewared please help me :'(

Make sure the Channels Table, the Config.ini, and your launcher are ALL set to your WAN IP.

that 5.0 thing u said makes no changes..still getting the same errror..
damn annoying

MySQL probably isn't running, restart your computer.

Just install mysql 5 ( cf page 2 )

PLease help me :

[INFO]: User connected from XX.XX.XXX.XXX
[INFO]: User disconnected

-_-

Is my router doing this?

"servers are currently beeing inspected"

I have this error on the Problems section, read -_-
You need to go into the config.ini, find this part "minimal_level=300" , you need to change that 300, to 100

Same here nev.. local it worked but now on dedicated he says that..

Again, you need to port forward the port 80. Go to

To view the content, you need to sign in or register

to learn how to port forward.

 

[ryber]

When i click 'Register' under -http://localhost-, it comes up with nothing

 

[Akai]

When i click 'Register' under -http://localhost-, it comes up with nothing

Yes that Rose Web was bugged, I have added a new one and rewrote the whole installation explanation of your Rose Web CMS. So please go download the new one and follow the new instructions.

 

[smackthat111]

I restarted my computer, still getting the error can't connect to mySQL bla bla bla.. I also tried my IP and 127.0.0.1...also not working. wtf could the problem be since my friend his one doesn't work either even now he installed 5.0.

 

[ryber]

Yes that Rose Web was bugged, I have added a new one and rewrote the whole installation explanation of your Rose Web CMS. So please go download the new one and follow the new instructions.

Thanks, the problem now is that it comes up with a blank page.

 

[Akai]

Thanks, the problem now is that it comes up with a blank page.

1.) Make you installed PHP
2.) Check our database settings in config.php
3.) Make sure MySQL is running

 

[marabon]

I will try later and i WILL tell u if i made it xD

 

[Sojobo]

I keep getting invalid password errors when i try to login locally, any idea why?

 

[Akai]

Fullserver has been updated - IMPORTANT UPDATE. Fullserver has been updated with a new SQL update (rosen_beta.sql). So please delete your old database and update with this new one! (This is just the .sql)

Important Update (SQL Update with tons of new spawns, fixes, npc fixes, map fixes, quest data fixes, pvpzones, telegates, drop data, and more)

Also, I updated the creating database part, the name of the database should be "rosen_beta" not "roseon_beta".

 

[ryber]

When i 'register' by -http://localhost/register.php- it doesn't store in the database.

 

[Akai]

When i 'register' by -http://localhost/register.php- it doesn't store in the database.

Then you didn't do something correctly..check your database settings to make sure they are absolutely correct with the navicat settings.

 

[majintom]

I'm having the same problem as sojobo, any known reasons?

 

[smackthat111]

i wanna get this working anyone please help?

 

[ryber]

Then you didn't do something correctly..check your database settings to make sure they are absolutely correct with the navicat settings.

Yep just checked them again, there all correct

 

[Sojobo]

I get this error when registering with the new update;

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\register.php on line 107

edit: when i register manually i still get the wrong password error

edit: forget it i fixed it, still having the incorrect password problem though

 

[Akai]

I get this error when registering with the new update;

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\register.php on line 107

edit: when i register manually i still get the wrong password error

edit: forget it i fixed it, still having the incorrect password problem though

Evedently you have your database for your Rose Web password different from your MySql/Navicat password.

 

[smackthat111]

nobody knows how to fix my problem?

 

[Sojobo]

The wrong password error is for my account on the game, everything else is working fine, for some reason when i try to play the game it just says my password is incorrect

 

[Matt]

Also, for apache, you need to forward 80, and 443, you only said 80.

TCP AND UDP.