Need some help

Welcome in the osRose emulator Project.

Moderators: osRose dev team, ospRose dev team, osiRose dev team, Moderators

Need some help

Postby Noir on Thu Jul 17, 2008 11:51 pm

I just compiled the newest svn revision and after setting up everything the STB files and all from the guide i got here viewtopic.php?f=39&t=1542 and following all the steps when i start the server i'm getting an error

[INFO]: Autosaving Every 60 minutes
[INFO]: Connecting to MySQL
[INFO]: MySQL Ping Timeout: 28740 seconds
[INFO]: Connected to MySQL server
[INFO]: opened ISC poort 29210
[INFO]: Loading PYDrops Data
[INFO]: PYDrops loaded
[INFO]: Loading Skillbook data
[INFO]: Skillbook Data loaded
[INFO]: Loading database config
[INFO]: Config Data Loaded
[FATAL ERROR]: Could not execute query: You have an error in your SQL syntax; ch
eck the manual that corresponds to your MySQL server version for the right synta
x to use near 'range, respawntime, `limit`, tacticalpoints, moblist FROM list_mo
bgroups' at line 1
[INFO]: Reconnecting to Mysql
[LOADING]: NPC spawn

there was a post about that error here [url]http://forum.dev-osrose.com/viewtopic.php?f=18&t=682&p=5424&hilit=+range+respawntime+limit+tacticalpoints+moblist+from+list+mo+%5BFATAL+ERROR%5D%3A+Could+not+execute+query%3A+You+have+an+error+in+your+SQL+syntax%3B+ch#p5424
[/url]
but the patch which was provided is out of date with the current source so i was wondering is there a new patch which is more updated then the one posted here or is there some fix to the problem which i might have missed while searching?
Noir
Little soul
Little soul
 
Posts: 9
Joined: Thu Jul 17, 2008 11:43 pm

Re: Need some help

Postby Drakia on Fri Jul 18, 2008 12:06 am

Apparently in the MySQL version you're using one of the field names is a reserved keyword. I uploaded a new revision with backticks around all the entries in that query, give it a shot and hopefully that'll work for you :)
My favorite skill is scaring new users away.
If you haven't SEARCHED expect me to yell at you.
Image
Drakia
ospRose dev team
ospRose dev team
 
Posts: 1614
Joined: Tue Sep 18, 2007 6:53 am
Location: Nanaimo, BC, Canada

Re: Need some help

Postby Rescudo on Fri Jul 18, 2008 12:23 am

"range" sounds like a word that could very well be reserved in MySQL.
SEARCH - it's there for a reason!
User avatar
Rescudo
El Verloon Marshall
El Verloon Marshall
 
Posts: 872
Joined: Tue Mar 11, 2008 7:20 am

Re: Need some help

Postby Drakia on Fri Jul 18, 2008 1:01 am

Indeed. We really should start putting backticks around all of our field names, it avoids things like this if MySQL decides to add new keywords.
My favorite skill is scaring new users away.
If you haven't SEARCHED expect me to yell at you.
Image
Drakia
ospRose dev team
ospRose dev team
 
Posts: 1614
Joined: Tue Sep 18, 2007 6:53 am
Location: Nanaimo, BC, Canada

Re: Need some help

Postby Noir on Fri Jul 18, 2008 2:32 am

That fixed the problem for sure no error now.

Altho now im plagued with an issue at login cant get past the login screen. Its client 112 of course i have my bat file made with
  1. TRose.exe @TRIGGER_SOFT@ _69.125.34.102
although when i attempt to login I get the message that all servers are currently in maintance and I'm pretty sure all my settings are correct and the correct ports are opened. So I was wondering is there an option somewere like Maintance = yes which I missed that needs to be changed?
Noir
Little soul
Little soul
 
Posts: 9
Joined: Thu Jul 17, 2008 11:43 pm

Re: Need some help

Postby Drakia on Fri Jul 18, 2008 2:35 am

that should be
@TRIGGER_SOFT@ _server [iphere]
My favorite skill is scaring new users away.
If you haven't SEARCHED expect me to yell at you.
Image
Drakia
ospRose dev team
ospRose dev team
 
Posts: 1614
Joined: Tue Sep 18, 2007 6:53 am
Location: Nanaimo, BC, Canada

Re: Need some help

Postby Blackdpd on Fri Jul 18, 2008 2:42 am

if you have everything setted up maybe make a little backup and then try using NeonCube in the guides section of this forum, that is an launcher + updater and if you dont understand it and all you can still use that little backup you made so you can at least try something else what is easier to understand and then try again with neoncube so you learn more and more ;)

( just thought maybe give some info :) )

Blackdpd `
User avatar
Blackdpd
El Verloon Marshall
El Verloon Marshall
 
Posts: 900
Joined: Sun Jan 27, 2008 10:06 pm
Location: The Netherlands

Re: Need some help

Postby Noir on Fri Jul 18, 2008 5:20 am

Hmm well I still seem to be getting the servers in maintance error even though now I have my .bat all fixed up I've tried using http://forum.dev-osrose.com/viewtopic.php?f=27&t=34 this guide for setting up the config options but osp doesnt seem to have all the same options. And i didnt see any other guides which are osprose.

charserver.conf
  1. [DATABASE]
  2. mysql_host=localhost
  3. mysql_user=prose
  4. mysql_pass=test123
  5. mysql_database=prose
  6. mysql_port=3306
  7.  
  8. [SERVERDATA]
  9. serverid=1
  10. serverip=69.125.34.102
  11. serverport=29100
  12. servername=RoseForever
  13. parentid=0
  14. accesslevel=100
  15.  
  16. [CHARSERVER]
  17. deletetime=3600
  18. usethreads=0
  19. [server2server]
  20. CharsPort=29110
  21.  
  22. [PASSWORDS]
  23. loginpass=789456
  24. charpass=456123
  25. worldpass=321654


loginserver.config
  1. [DATABASE]
  2. mysql_host=localhost
  3. mysql_user=prose
  4. mysql_pass=test123
  5. mysql_database=prose
  6. mysql_port=3306
  7.  
  8. [SERVERDATA]
  9. serverid=0
  10. serverip=69.125.34.102
  11. serverport=29000
  12. servername=RoseForever
  13.  
  14. [LOGINSERVER]
  15. accesslevel=100
  16. CreateLoginAccount=1
  17. usethreads=0
  18. Testserver=0
  19.  
  20. [PASSWORDS]
  21. loginpass=789456
  22. charpass=456123
  23. worldpass=321654


and for world ive tried it 2 different ways not exactly sure about what all the options in the config are for so i tried it 2 ways which i'll post first and second way.

first worldserver.conf
  1. [DATABASE]
  2. mysql_host=localhost
  3. mysql_user=prose
  4. mysql_pass=test123
  5. mysql_database=prose
  6. mysql_port=3306
  7.  
  8. [SERVERDATA]
  9. serverid=2
  10. serverip=69.125.34.102
  11. serverport=29200
  12. servername=Channel 1
  13. maxconnections=500
  14. parentid=1
  15.  
  16. [WORLDSERVER]
  17. accesslevel=100
  18. drop_type=2
  19. welcome_msg=Welcome to ospRose - Check Dev-OsROSE.com for updates
  20. autosave=1
  21. savetime=3600
  22. mapdelay=10
  23. visualdelay=200
  24. worlddelay=700
  25. partygap=10
  26. maxstat=300
  27. fairy=1
  28. fairystay=45
  29. fairywait=30
  30. fairytestmode=0
  31. playerdmg=230
  32. monsterdmg=78
  33. cfmode=0
  34.  
  35. [server2server]
  36. charip=69.125.34.102
  37. charport=29110
  38. WorldsPort=29210
  39.  
  40. [PASSWORDS]
  41. loginpass=789456
  42. charpass=456123
  43. worldpass=321654



and the second way
  1. [DATABASE]
  2. mysql_host=localhost
  3. mysql_user=prose
  4. mysql_pass=test123
  5. mysql_database=prose
  6. mysql_port=3306
  7.  
  8. [SERVERDATA]
  9. serverid=2
  10. serverip=69.125.34.102
  11. serverport=29200
  12. servername=Channel 1
  13. maxconnections=500
  14. parentid=1
  15.  
  16. [WORLDSERVER]
  17. accesslevel=100
  18. drop_type=2
  19. welcome_msg=Welcome to ospRose - Check Dev-OsROSE.com for updates
  20. autosave=1
  21. savetime=3600
  22. mapdelay=10
  23. visualdelay=200
  24. worlddelay=700
  25. partygap=10
  26. maxstat=300
  27. fairy=1
  28. fairystay=45
  29. fairywait=30
  30. fairytestmode=0
  31. playerdmg=230
  32. monsterdmg=78
  33. cfmode=0
  34.  
  35. [server2server]
  36. charip=127.0.0.1
  37. charport=29110
  38. WorldsPort=29210
  39.  
  40. [PASSWORDS]
  41. loginpass=789456
  42. charpass=456123
  43. worldpass=321654



One thing I was wondering about is the server2server setting not really sure what its for but if you have any idea what might be a miss it would help greatly.
Noir
Little soul
Little soul
 
Posts: 9
Joined: Thu Jul 17, 2008 11:43 pm

Re: Need some help

Postby Drakia on Fri Jul 18, 2008 5:43 am

The server2server setting is used for inter-server communication (Clan stuff mainly) and should be set to your internal IP (Or, 127.0.0.1). You can find a guide on setting up in this forum (It's labelled READ, you should have read it before posting ;))
Make sure you don't have a firewall blocking ports 29000, 29100, or 29200. Also make sure they are forwarded through your router.
My favorite skill is scaring new users away.
If you haven't SEARCHED expect me to yell at you.
Image
Drakia
ospRose dev team
ospRose dev team
 
Posts: 1614
Joined: Tue Sep 18, 2007 6:53 am
Location: Nanaimo, BC, Canada

Re: Need some help

Postby Noir on Fri Jul 18, 2008 5:54 am

I have read the guide in this section although it doesnt cover the setup of the config files but besides that there is no router what so ever just a straight connection and no firewall as well at all.

another thing too i find it odd that i keep getting maintance error cause that means it is partly connecting cause when i turn the server offline of course the client errors that the server is offline but the server isnt even trying to pick up the connection that someones connecting to it.

oh yeah one other thing i thought id add is there any problem with runing it on vista cause im runing it on vista x64bit
Noir
Little soul
Little soul
 
Posts: 9
Joined: Thu Jul 17, 2008 11:43 pm

Next

Return to Support - OspRose Emulator

Who is online

Users browsing this forum: No registered users and 5 guests

cron