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

[VFmikesmith]

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

you mean worldserver charserver and loginserver? i edited those and made them what they needed to be...

 

[Akai]

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

you mean worldserver charserver and loginserver? i edited those and made them what they needed to be...

In the loginserver.conf, make sure you didn't change the name.

 

[VFmikesmith]

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

[DATABASE]
mysql_host=localhost
mysql_user=root
mysql_pass=
mysql_database=roseon
AutoQueryTime=600

[SERVERDATA]
serverid=1
servertype=2
serverip=69.136.6.97
serverport=29200
servername=Channel 1
maxconnections=500
parentid=1
sameserver=0

[WORLDSERVER]
accesslevel=100
exp_rate=3
drop_rate=4
drop_type=2
zuly_rate=4
welcome_msg=Welcome to Open Source Rose Online
autosave=1
savetime=120
mapdelay=10
visualdelay=200
worlddelay=700
partygap=10
maxstat=255

[PASSWORDS]
loginpass=789456
charpass=456123
worldpass=321654


[DATABASE]
mysql_host=localhost
mysql_user=root
mysql_pass=
mysql_database=roseon

[SERVERDATA]
serverid=0
servertype=0
serverip=69.136.6.97
serverport=29000
servername=LoginServer
sameserver=1

[LOGINSERVER]
accesslevel=100
CreateLoginAccount=1
usethreads=0

[PASSWORDS]
loginpass=789456
charpass=456123
worldpass=321654




[DATABASE]
mysql_host=localhost
mysql_user=root
mysql_pass=
mysql_database=roseon
AutoQueryTime=600

[SERVERDATA]
serverid=1
servertype=1
serverip=69.136.6.97
serverport=29100
servername=Dark
parentid=0
accesslevel=100
sameserver=0

[CHARSErVER]
deletetime=3600
usethreads=0

[PASSWORDS]
loginpass=789456
charpass=456123
worldpass=321654

 

[Akai]

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

[DATABASE]
mysql_host=localhost
mysql_user=root
mysql_pass=
mysql_database=roseon
AutoQueryTime=600

[SERVERDATA]
serverid=1
servertype=2
serverip=69.136.6.97
serverport=29200
servername=Channel 1
maxconnections=500
parentid=1
sameserver=0

[WORLDSERVER]
accesslevel=100
exp_rate=3
drop_rate=4
drop_type=2
zuly_rate=4
welcome_msg=Welcome to Open Source Rose Online
autosave=1
savetime=120
mapdelay=10
visualdelay=200
worlddelay=700
partygap=10
maxstat=255

[PASSWORDS]
loginpass=789456
charpass=456123
worldpass=321654


[DATABASE]
mysql_host=localhost
mysql_user=root
mysql_pass=
mysql_database=roseon

[SERVERDATA]
serverid=0
servertype=0
serverip=69.136.6.97
serverport=29000
servername=LoginServer
sameserver=1

[LOGINSERVER]
accesslevel=100
CreateLoginAccount=1
usethreads=0

[PASSWORDS]
loginpass=789456
charpass=456123
worldpass=321654




[DATABASE]
mysql_host=localhost
mysql_user=root
mysql_pass=
mysql_database=roseon
AutoQueryTime=600

[SERVERDATA]
serverid=1
servertype=1
serverip=69.136.6.97
serverport=29100
servername=Dark
parentid=0
accesslevel=100
sameserver=0

[CHARSErVER]
deletetime=3600
usethreads=0

[PASSWORDS]
loginpass=789456
charpass=456123
worldpass=321654

Not sure what to tell you then, ask the DEVS at

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

, drauk can probably help you.

 

[VFmikesmith]

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

nvrm..i give up..im just a failure..cya

 

[masterzeo]

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

ok i got the xammp start thing working now whenever i try 2 open my site it just shows a blank screen

 

[Akai]

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

ok i got the xammp start thing working now whenever i try 2 open my site it just shows a blank screen

Install PHP, if that doesn't work then try using WAMP.

 

[interlider]

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

Do you mean the tables? Just click them all and move them into the new database.

I tryed ... so dont work , when you try to run server it dont found Table (ex: Acount )
So i do what ?

 

[iviv]

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

Hi, and sorry for what is probably another annoying question.

I've downloaded and installed everything, though when installing PHP it asked which web server I wished to set up, I selevted not to, since we already have a web server set up, right?

Anyhow, I installed everything and started xampp. The localhost gave me the xampp page, so I deleted the htdocs, and copied the CMS v2.6 Full files into their instead. However, now nothing appears in the localhost. I tried localhost/install as well, but still a blank screen.

I forwarded port 80 to my router, though since the xampp page worked I don't think its a port issue.

 

[Akai]

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

I tryed ... so dont work , when you try to run server it dont found Table (ex: Acount )
So i do what ?

In the old database, highlight all the tables you want copied over. Click and drag them over to the new database. It will ask you if you want to copy "Data only" or "Data and structure" choose the "Tables and Structure".

 

[soneta]

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

why i can't connect to my server, always detected hacking tool

but i've already use the "Rose Online Game Guard Fix"

grrr, what wrong

server already up
website register already up
game already work

when i login n then choose server channel it says detected hacking tool

 

[bladefinor]

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

When I start my server (Login, Character, World) it will work perfect for a while, then the "Character server.exe" and "Login server.exe" disconnecting. So People can't login! But the players that are logged in can play until they log out...
NEED HELP FOR THIS PROBLEM!

 

[spotlifter]

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

I have question. This setup is only runs on windows server/NT?
Can it be setup at a Linux debian server?
I run a webserver with mysql server. Just needed a info. Thanks

 

[fabioos]

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

ok now this is starting to piss me off.. i didn't get any respond in 2 days.. so.. i re-downloaded NAVICAT now for 7 TIMES.. and i still get those fked up errors.. "2003 Can't connect to Localhost on 10061" is NAVICAT the only file i have to download ? >.>

Now, download Navicat. This is used for the Databases (SQL).
Link: Navicat MySQL

Install Navicat. After it's installed, run the program. You should see the connection "localhost" to the left. IF you do not, go to "File > New Connection". In the fields put this:

Connection Name: localhost
Host Name/IP Address: localhost
Port: 3306
Username: root
Password:

(Leave password blank) And click "Test Connection" and you should get a success. If you do, click "OK".

Now, click your connection "localhost" and right click and go to "New Database". Name the database "roseon" and click OK. Right click on the database you just made, and click "Execute batch file". Browse to the folder you extracted the server files, and find the folder named "database" and double click "osrose svn.sql". It will start the process that .sql file, it may take a few minutes. If everything went right, it should tell you it executed it successfully.

what if i dont get a succes?

 

[spotlifter]

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

try using the navicat troubleshooter website?

 

[fabioos]

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

spot,, Are MySQL 5.0 and Navicat different programs? bcuz the link in the beginning says Navicat MySQL

 

[iviv]

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

First post:

5.) When I try to connect with Navicat, it says it can't connect to MySQL!
Solution: You need to install MySQL. Download here: MySQL 5.0

Can someone help with my question? >_>

 

[kkshisuke]

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

Akai I already updated to the newest sql that I found (5.0.27) but I still get the same thing.
Or maybe I didn't configure the mysql corectly ?

 

[spotlifter]

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

spot,, Are MySQL 5.0 and Navicat different programs? bcuz the link in the beginning says Navicat MySQL

Yup.

 

[spotlifter]

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

Would this help you guys? Copied from the Navicat FAQ.

Why I cannot connect to my MySQL Server?The reasons for not connecting to your MySQL server successfully may involve few aspects. We would suggest you to check the following issues:

1. Do you have the correct hostname of your MySQL server?
2. Are you using the correct TCP/IP port number when trying to connect to the mysqld server? (the default port number for mysql is 3306)
3. Are you behind any firewall that blocks the port number?
4. Is your public IP address of your desktop PC changed by your ISP recently?

We would like to remind you that after MySQL server is installed, it would only allow "localhost" connection by default. Any client PCs will be blocked by the remote MySQL server until the user privileges has been configured.

If you are using MySQL server provided by hosting company, most of the hosting companies will block access to the MySQL server from outside the hosting company's network, and only grant access to users connecting from localhost. For this case, you will need to configure SSH Tunnel Connection to solve the problem.