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

Status
Not open for further replies.
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

guys were u find out ur lan ip when i goto start den goto run den type in cmd it dosent come up with ip help me
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

and Akai can u please help me, I got this problem when I use ruff-rose:
-When I try to login (loginserver.exe also running) It says: login failed (and the loginserver.exe log noticed:

Starting up server on port 29000.
Server is now listening on port 29000. <SID: 160>
Client connected <IP: 127.0.0.1, SID:228>
<SID:228> User failed to login. Buffer: 326769a30cfc846881c9fb483bab3ab6admin

and when I use NArose:
-When I try to login (loginserver.exe also running) It stay on "connecting to server" but if I watch the loginserver.exe log it says it's already connected to client but in game it stay saying:"connecting to server..."
please help me, would be nice :)
 
Client can't connect.

Hi ,

I got an alien problem here hahaha.

1) i double check all the steps and numbers and steps in your guide to my server setting (spend 5 hours). checking word by words char by char... :(

2) I can access the server status through the web.

in fact the web page is online .. lol... my friends can see it too

3) i have port forward almost every ports i can think of from my windowsx64 and router. 1 - 65000 (should be enough ....)

4) The client is able to log in to others game server .. :(

BUT i just can't seems to get my client to log in at all ... :( ....

Anyway here is how it goes . the client works as per normal and load and when it come to the user login page there where the programe react differently.

1) if i try to create a new account / login ... it will have a server loading status permentely there. it never find the server at all. (trying to search for server)

2) if i click cancel the game just hang and pop back into windows

the error from the error log from client

log: start. (2007/03/14, 04:35:14) from(e:/program files (x86)/triggersoft/rose online evolution) version(2.12.11.934). lang(0)
os: tgt supported.
interface: dispqual(0)
interface: dispqual(5)
r_d3d: iNiT...
r_d3d: cUrMoDe (1024x768)-(22)-(85Hz)
r_d3d: adapter(0): desc(RADEON X850 Series ), version(6.14.10.6635)
r_d3d: best adapter ordinal = adapter(0)-mode(41)-(1024x768x32-full)-(85)Hz.
interface: vsync on.
r_d3d: fullscreen-mode(1024x768) enabled.
r_d3d: cdHW
r_d3d: maxtexmem = 143654912
r_d3d: iNiTdOnE
octree: cull_planes() no root <---- something fishy here
r_d3d: cLeAnUpDoNe
r_d3d: no d3d_device
log: end. (2007/03/14, 04:35:56).


**********
of if you wondering i have also do the copy of the trose.exe file into server directory and all other directory in the server folder just in case ... (So piss off)

(it seems that some how there is also a small issue bugging me too .. with the 3 server program load ing here is the log

loginserver
Connected to MySQL server
Could not execute query: Unknown column 'type' in 'where clause'
Query: DELETE FROM channels WHERE id=1 and type=1
Signal received: SIGINT

charserver
Connected to MySQL server
Could not execute query: Unknown column 'type' in 'where clause'
Query: DELETE FROM channels WHERE id=1 and type=1
Signal received: SIGINT

worldserver
Autosaving Every 2 minutes
Connected to MySQL server
Loading STBs: |= |
Loading STBs: |== |
Loading STBs: |=== |
Loading STBs: |==== |
Loading STBs: |===== |
Loading STBs: |====== |
Loading STBs: |======= |
Loading STBs: |======== |
Loading STBs: |========= |
Loading STBs: |========= |
Loading STBs: |========== |
Loading STBs: |=========== |
Loading STBs: |============ |
Loading STBs: |============= |
Loading STBs: |============== |
Loading STBs: |=============== |
Loading STBs: |================ |
Loading STBs: |=================|

Skills loaded
Drops loaded
Quest loaded
NPCData loaded
Maps Loaded
Telegates loaded
RespawnZones loaded
NPC NOT FOUNDED! 16
Spawn will not be added - spawnid 16
SpawnZones loaded
NPC spawned
PVPZones loaded
Monsters Spawned
Refine Probability Loaded
Could not execute query: Unknown column 'type' in 'where clause'
Query: DELETE FROM channels WHERE id=1 and type=2


hmm some sql error is reflected.


Sorry if i apper too helpless .. but i really tried my best and read so many posting in the forum over the 5 hour i been trying to fix it. I have check all the 4 conf files in the server side and i am sure unless there are varation in the setting it should works..

Just in case here are the 4 conf files


charserver
[DATABASE]
mysql_host=localhost
mysql_user=root
mysql_pass=1234
mysql_database=roseon
mysql_port=3306
AutoQueryTime=600

[SERVERDATA]
serverid=1
servertype=1
serverip=218.186.145.34
serverport=29100
servername=test
parentid=0
accesslevel=100
connection=2
lanip=19.12.19.101
lansubmask=19.12.19

[CHARSErVER]
deletetime=3600
usethreads=0

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

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

[GLOBAL]
AutoQueryTime=600
usethreads=0

[LOGINSERVER]
minimal_access_level=100
loginip=218.186.145.34
loginport=29000
loginpass=789456
CreateLoginAccount=1

[CHARSERVER]
deletetime=3600
charip=218.186.145.34
charport=29100
charpass=456123

[WORLDSERVER]
worldip=218.186.145.34
worldport=29200
worldpass=321654
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


loginserver
[DATABASE]
mysql_host=localhost
mysql_user=root
mysql_pass=1234
mysql_database=roseon
mysql_port=3306

[SERVERDATA]
serverid=0
servertype=0
serverip=218.186.145.34
serverport=29000
servername=test
connection=0
lanip=19.12.19.101
lansubmask=19.12.19

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

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

world server
[DATABASE]
mysql_host=localhost
mysql_user=root
mysql_pass=1234
mysql_database=roseon
mysql_port=3306
AutoQueryTime=600

[SERVERDATA]
serverid=1
servertype=2
serverip=218.186.145.34
serverport=29200
servername=Channel 1
maxconnections=500
parentid=1
connection=2
lanip=19.12.19.101
lansubmask=19.12.19

[WORLDSERVER]
accesslevel=100
exp_rate=3
drop_rate=1
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


Hmm .. my local computer ip is 19.12.19.101
my router ip is 19.12.19.80
my lansubnetmask is 19.12.19
my WANIP is 218.186.145.34

did i set anything wrong ? ?


Oh client side too just in case

[CFG]
Server=218.186.145.34
HTTPReg=http://218.186.145.34/register
HTTPNot=http://218.186.145.34

hmmm .. Please i hope you might be able to help me soplve this problem ...

Thanks .

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

oke, now I'm trying to use ur guide, I did all staps, now running the servers and they work(am using ruff-rose as client) and when I try to login it says "SERVER DEAD" and it says there is an maintenance 0.o but my roseonlineserver.exe says: #server1 connected from ip 127.0.0.1

please help me

EDDIT: I saw you posted on the begin post also what I should do when I get that error SERVER DEAD but there's no "acces" 300 in the config.ini .... only one with =100 so please help me, what I have to do now? how can I fix it (the SERVER DEAD problem xD)

EDDIT2: When I use everywhere as IP: 127.0.0.1 it won't say SERVER DEAD when I try to login but then it says: login in please wait... and then incorrect password...
but those don't work damn... help me please
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

i set everything and when i tried to login rose with the account created in xampp, it always say wrong password. then i went to create another account and this time it say can't find account. so what is the problem?
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

ye, I have the same problem if I set everywhere the server IP to: 127.0.0.1
but if I set it to my IP; then it says: server DEAD 0.o

help would be nice.
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

hi all are working fine by me i have a question very noob for this, can someone confirm is jobquest change are working, because i am killing the mobs i need to get soldier job and they dont drop the item i need
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

damn, how u guys getting this working! It really isn't working for me, please, help me!!
when I set the server IP's from the config files to my IP adress and I launch login server.exe and try to login to the game, it says SERVER DEAD and when I use the 127.0.0.1 IP it says: Incorrect password
when I try to login with one of the made accounts!
Please help me, what do I do wrong? how can I get this working correctly? please help me, would be nice ^__^
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

i have a Problem with :
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

omfg why doesn't it work for me and why is no1 helping me already for 2 days :( I want my server working! if I use my IP (I found on google with "what's my ip" or something) and I try to login to rose it says server dead: servers are undergoing for a maintenance. and in the config.ini is the acces already 100, so ... WEIRD :S and when I use as server IP : 127.0.0.1 and I try to login to rose it says the password
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

I forwarded the ports, it work now! no SERVER DEAD error anymore, awesome :D
well... othersides; another new error! YAY! -.- '
it says: incorect password
when I try to login with a correct password 0.o someone told me something about md5 or something, but didn't understand anything about it lol, help me please, what I have to do to fix this?
(and sometimes it stay on "connecting" (if someone else try to login on another computer ))

EDDIT: for NArose when I try to login it says:
loggin in...please wait...
incorect password.

and the loginserver.exe noticed logs:
User connected from 192.168.1.1
User disconnected

and when I try to login while using Ruff-Rose as client it stay saying: connecting...
 
Re: Client can't connect.

Hi ,

I got an alien problem here hahaha.

1) i double check all the steps and numbers and steps in your guide to my server setting (spend 5 hours). checking word by words char by char... :(

2) I can access the server status through the web.

in fact the web page is online .. lol... my friends can see it too

3) i have port forward almost every ports i can think of from my windowsx64 and router. 1 - 65000 (should be enough ....)

4) The client is able to log in to others game server .. :(

BUT i just can't seems to get my client to log in at all ... :( ....

Anyway here is how it goes . the client works as per normal and load and when it come to the user login page there where the programe react differently.

1) if i try to create a new account / login ... it will have a server loading status permentely there. it never find the server at all. (trying to search for server)

2) if i click cancel the game just hang and pop back into windows

the error from the error log from client

log: start. (2007/03/14, 04:35:14) from(e:/program files (x86)/triggersoft/rose online evolution) version(2.12.11.934). lang(0)
os: tgt supported.
interface: dispqual(0)
interface: dispqual(5)
r_d3d: iNiT...
r_d3d: cUrMoDe (1024x768)-(22)-(85Hz)
r_d3d: adapter(0): desc(RADEON X850 Series ), version(6.14.10.6635)
r_d3d: best adapter ordinal = adapter(0)-mode(41)-(1024x768x32-full)-(85)Hz.
interface: vsync on.
r_d3d: fullscreen-mode(1024x768) enabled.
r_d3d: cdHW
r_d3d: maxtexmem = 143654912
r_d3d: iNiTdOnE
octree: cull_planes() no root <---- something fishy here
r_d3d: cLeAnUpDoNe
r_d3d: no d3d_device
log: end. (2007/03/14, 04:35:56).


**********
of if you wondering i have also do the copy of the trose.exe file into server directory and all other directory in the server folder just in case ... (So piss off)

(it seems that some how there is also a small issue bugging me too .. with the 3 server program load ing here is the log

loginserver
Connected to MySQL server
Could not execute query: Unknown column 'type' in 'where clause'
Query: DELETE FROM channels WHERE id=1 and type=1
Signal received: SIGINT

charserver
Connected to MySQL server
Could not execute query: Unknown column 'type' in 'where clause'
Query: DELETE FROM channels WHERE id=1 and type=1
Signal received: SIGINT

worldserver
Autosaving Every 2 minutes
Connected to MySQL server
Loading STBs: |= |
Loading STBs: |== |
Loading STBs: |=== |
Loading STBs: |==== |
Loading STBs: |===== |
Loading STBs: |====== |
Loading STBs: |======= |
Loading STBs: |======== |
Loading STBs: |========= |
Loading STBs: |========= |
Loading STBs: |========== |
Loading STBs: |=========== |
Loading STBs: |============ |
Loading STBs: |============= |
Loading STBs: |============== |
Loading STBs: |=============== |
Loading STBs: |================ |
Loading STBs: |=================|

Skills loaded
Drops loaded
Quest loaded
NPCData loaded
Maps Loaded
Telegates loaded
RespawnZones loaded
NPC NOT FOUNDED! 16
Spawn will not be added - spawnid 16
SpawnZones loaded
NPC spawned
PVPZones loaded
Monsters Spawned
Refine Probability Loaded
Could not execute query: Unknown column 'type' in 'where clause'
Query: DELETE FROM channels WHERE id=1 and type=2


hmm some sql error is reflected.


Sorry if i apper too helpless .. but i really tried my best and read so many posting in the forum over the 5 hour i been trying to fix it. I have check all the 4 conf files in the server side and i am sure unless there are varation in the setting it should works..

Just in case here are the 4 conf files


charserver
[DATABASE]
mysql_host=localhost
mysql_user=root
mysql_pass=1234
mysql_database=roseon
mysql_port=3306
AutoQueryTime=600

[SERVERDATA]
serverid=1
servertype=1
serverip=218.186.145.34
serverport=29100
servername=test
parentid=0
accesslevel=100
connection=2
lanip=19.12.19.101
lansubmask=19.12.19

[CHARSErVER]
deletetime=3600
usethreads=0

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

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

[GLOBAL]
AutoQueryTime=600
usethreads=0

[LOGINSERVER]
minimal_access_level=100
loginip=218.186.145.34
loginport=29000
loginpass=789456
CreateLoginAccount=1

[CHARSERVER]
deletetime=3600
charip=218.186.145.34
charport=29100
charpass=456123

[WORLDSERVER]
worldip=218.186.145.34
worldport=29200
worldpass=321654
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


loginserver
[DATABASE]
mysql_host=localhost
mysql_user=root
mysql_pass=1234
mysql_database=roseon
mysql_port=3306

[SERVERDATA]
serverid=0
servertype=0
serverip=218.186.145.34
serverport=29000
servername=test
connection=0
lanip=19.12.19.101
lansubmask=19.12.19

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

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

world server
[DATABASE]
mysql_host=localhost
mysql_user=root
mysql_pass=1234
mysql_database=roseon
mysql_port=3306
AutoQueryTime=600

[SERVERDATA]
serverid=1
servertype=2
serverip=218.186.145.34
serverport=29200
servername=Channel 1
maxconnections=500
parentid=1
connection=2
lanip=19.12.19.101
lansubmask=19.12.19

[WORLDSERVER]
accesslevel=100
exp_rate=3
drop_rate=1
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


Hmm .. my local computer ip is 19.12.19.101
my router ip is 19.12.19.80
my lansubnetmask is 19.12.19
my WANIP is 218.186.145.34

did i set anything wrong ? ?


Oh client side too just in case

[CFG]
Server=218.186.145.34
HTTPReg=http://218.186.145.34/register
HTTPNot=http://218.186.145.34

hmmm .. Please i hope you might be able to help me soplve this problem ...

Thanks .

Sincerely
Shine

lol you must be using ruff-rose client, don't you? :P
Caus I have EXACTLY the same problem with ruff-rose client when I try to login it stay saying: connecting to server...
but it never connect, and exactly the same loginserver logs and queries lol, but when I try it with NArose client it does fined the server and try to login but then it says: incorect password,
like wtf lol.
but kinda same problem here when I use ruff-rose client
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

well i am trying to learn a skill my worldserver restarts someone can help me, thx for the anwers
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

well i am trying to learn a skill my worldserver restarts someone can help me, thx for the anwers
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

hi all are working fine by me i have a question very noob for this, can someone confirm is jobquest change are working, because i am killing the mobs i need to get soldier job and they dont drop the item i need
dunno but I though there was a file to change the drops of monsters, maybe u can change i there >.< dunno, am kinda new to this too, for me login in even don't really work 100% correctly yet xD
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

can someone please awnser my question and help me please? 0.o
Akai maybe you would know what's wrong?:
when I try to log in with the NArose client it says: wrong password
when I'm using a correct password and username 0.o
and when I try to login and connect to my server with ruff-rose client it stay on : connecting to server...
please help me!
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

See this?... This is because of MySQL and Navicat. They cause all of this trouble... And always know that it still never works
Post a new rev link cause its crap
 
Status
Not open for further replies.
Back