[XP] RPG Maker XP Online System (RMX-OS)

[Ryex]

if your running the server on their server and try to access the mysql server there is no reason that it shouldn't work. if your running the server on your computer and trying to access their mysql server then that is NOT going to work. run the server on their shell and set the IP for the sql server to be the localhost. also make sure that the port for the sql server is right and if you still have errors either your an idiot or their shell service isn't going to work. not sure which would be preferable.

[Blizzard]

I guess it is time somebody put together a proper how-to guide for this problem. It will probably be me and it will probably be in the manual. >.<

[Ryex]

but nobody reads the manual what good is it to put it in there?

[Noob]

i definitely would read it. please make a guide like that. and ryex, im doing everything you said, i think, but i'll check again. its the server file that actually accesses the database, right? the user doesnt directly access it (remotely)...or do they?

[Ryex]

i definitely would read it. please make a guide like that. and ryex, im doing everything you said, i think, but i'll check again. its the server file that actually accesses the database, right? the user doesnt directly access it (remotely)...or do they?

yes. the server dose all the database access, it would be stupid for the users to have access to the database. BTW I don;t think you've shared your specific error (or have you?) doing so will help in the event that your not setting things up right.

[Noob]

I did it's on page 52 of the replies. Here it is:

==========================================================================
RMX-OS Server v1.15
==========================================================================
Loading extensions...
'blizzabsrmxos.rb' v1.1 loaded and initialized.
--------------------------------------------------------------------------
> Starting TCP Server at '69.10.56.122:12025'...
> Connecting to MySQL database 'test_rmxos'...
Unexpected error occured!
Can't connect to MySQL server on '127.0.0.1' (111)
./RMX-OS_Server/Data/Server.rb:93:in `new'
./RMX-OS_Server/Data/Server.rb:93:in `connect_to_database'
./RMX-OS_Server/Data/Server.rb:60:in `start'

./RMX-OS_Server/rmxos.rb:58:in `main'
./RMX-OS_Server/rmxos.rb:173


RMX-OS Server is being terminated...
RMX-OS Server has been terminated.
Restart in: 5 4 3 2 1

[Noob]

So I got my server up on vlexofree.com. I actually was in the game. a depressingly huge  amount of problems then arose. The problems include:
-Can't talk
-Can't fight Blizz-ABS battles
-If you exit the game window, you cant log back in unless you shut down the server and restart it.
-If you down the server and restart it, then try logging back in, your user data is not there and you have to start over.
-I'm thinking this means user data is not being saved or something..............
Are you all absolutely certain that the client doesn't have to communicate directly with the mySQL database?

[Blizzard]

Why would the client communicate with the database directly? That's a gigantic security hole.

[Noob]

Ok. so what can I do to solve this?

[Blizzard]

It looks to me that for some reason the network traffic into one direction is cut off. Since data never gets saved, I assume the server doesn't really get the info from the client. Were there any error messages on the server (there's a log file)?

[Noob]

No error messages in the log, but I can give you a bit more information about the problem. I looked in the database, and found that the username and IP Address were logged. Also, when you talked no words appeared above your head, nor did they appear in the chatbox, even after refreshing it. Nor could this first account see other players. However, nothing was logged in the save_data part of the database, so in essence you have to start over every time you log in. So then I tried creating a new account. All data logging worked fine with it. I created three more new accounts, and everything worked fine with all of them. But when I went into a stage with Blizz-ABS enemies, they just stood there like normal events, but did have lifebars. And I could use attack skills on them, but the skills did nothing except show the animation and drain my SP.

So then I thought I might have accidentally screwed up blizzabs because, so I made a brand new database. Again, data logging was screwed up for the first account created, and again it worked perfectly for the second account. For the next three accounts it failed like the first one. And the blizzabs problem was not fixed.

So I went back to my original database, because in it I at least had the data logging working. To my surprise, blizzabs actually worked for a couple seconds when I went back. I tried a few regular attacks, and then i used a skill and all the enemies froze up and became un-damageable. So then I tried to talk. That didn't work anymore. Then I realized that datalogging also didn't work anymore, for any of the accounts. So I deleted that database and started with yet another new one. On this one datalogging never worked, nor did blizzabs.

Please help me fix this problem. If it's any help to you, I'm working with RMXOS v1.15, Blizz-ABS v2.79, and RMX-OS babs controller v1.1. With this exact setup I got the game to run perfectly when I ranu the server locally, off my PC. I know you may tell me to update my RMXOS and Blizz-ABS, and I would prefer not to do that unless it is actually necessary for solving the problem, rather than just to update.

[Blizzard]

The old versions of those scripts were buggy already if you didn't know. That is, the Blizz-ABS Controller had a few problems.

[Noob]

Okay............I'll update them then..........hopefully that solves it. Do you know why they'd be this buggy globally but work completely fine locally?

[Blizzard]

They never worked fine locally in the first place. For some reason you didn't experience any problems and maybe you just went around them each time, but the controller script was never fully functional.

[Noob]

okay. i guess i may have just gotten lucky. are the server scripts mostly the same for rmxos 1.16?
because i had to do a couple of minor modifications to the rmxos.rb file to make it run un the unix machine. i think i showed them in an earlier post.

[Blizzard]

Yeah, the server scripts are mostly the same. Only the data exchange subsystem is different but apart from that there were no significant changes.
Sadly I don't have any experience with running RMX-OS on a Linux machine so you might be on your own. :/
Turn on message logging and try to connect with a client. You should also change the path for your logs (because of the ./ path error that you were having). I am curious whether the server freezes because of this like it used to on startup.

[Noob]

I never experienced it freezing....anyway, I updated the scripts, copying and pasting in all the new scripts except not the configuration parts because I already had configured them and I figured they wouldn't be any different in the new scripts. So i did that, and updated all the server scripts, and made sure to set up the extension and everything, I did NOT run the new mySQL query because I found everything to be the same. I got some lovely error about the host machine terminating my connection when I tried logging in. So I made a completely new account and got the same thing when I registered it. The messge in the error log looked like this:
Mon Jan 31 17:52:52 Central Standard Time 2011:
undefined method `damage' for nil:NilClass
babsmxos:663:in `update'
Blizz-ABS Part 2:3796:in `update_moving'
Blizz-ABS Part 2:3796:in `each'
Blizz-ABS Part 2:3796:in `update_moving'
Blizz-ABS Part 3:2087:in `update_blizzabsrmxos_later'
babsmxos:662:in `update'
Scene_Map:56:in `update_rmxos_later'
Scene_Map:49:in `loop'
Scene_Map:70:in `update_rmxos_later'
RMX-OS Script:3633:in `upd_blizzabs_later'
Blizz-ABS Part 3:6805:in `update'
Scene_Map:25:in `main_rmxos_later'
Scene_Map:19:in `loop'
Scene_Map:30:in `main_rmxos_later'
RMX-OS Script:3606:in `main_blizzabs_later'
Blizz-ABS Part 3:6713:in `main_blizzabsrmxos_later'
babsmxos:942:in `main'
RMX-OS Main:46

EDIT: btw, this was when i tried it locally on my windows pc. i didnt delete my earlier database or anything. i just updated all the new scripts except the configuration parts of them, and when i logged in or when i registered my account, it displayed the starting map for a fraction of a second before giving a message telling about how the server had terminated connections. im fine with updating the configurations if need be. if this is unfixable, i guess i'll go back to the other versions and "debug." i almost had them fully working at 1 point. but if these work, i'll certainly use them. please help!! thanks

[Blizzard]

In future, please don't double post. Use the "Modify" function instead.

You should try wiping the database anyway. It shouldn't have anything to do with it, but it might help solve the problem.
This problem actually shouldn't be happening, it doesn't make any sense. That's why I think it's odd. Pretty much nothing's unfixable, don't worry about that.

[Noob]

Kk I won't double post anymore. so I got around my previous error (I'd forgotten to configure version number, what a dumb mistake....) and now I'm faced with a new problem: I get this error immediately upon registering, or sometimes after I progress through one line of text and name my first character:
undefined method `damage' for nil:NilClass
babsmxos:663:in `update'
Blizz-ABS Part 2:3796:in `update_moving'
Blizz-ABS Part 2:3796:in `each'
Blizz-ABS Part 2:3796:in `update_moving'
Blizz-ABS Part 3:2087:in `update_blizzabsrmxos_later'
babsmxos:662:in `update'
Scene_Map:56:in `update_rmxos_later'
Scene_Map:49:in `loop'
Scene_Map:70:in `update_rmxos_later'
RMX-OS Script:3633:in `upd_blizzabs_later'
Blizz-ABS Part 3:6805:in `update'
Scene_Map:25:in `main_rmxos_later'
Scene_Map:19:in `loop'
Scene_Map:30:in `main_rmxos_later'
RMX-OS Script:3606:in `main_blizzabs_later'
Blizz-ABS Part 3:6713:in `main_blizzabsrmxos_later'
babsmxos:942:in `main'
RMX-OS Main:46


Also, the system still isn't logging all of the user data......
EDIT: Just to let you know, it logs IPs, users, and user data, but nothing else, whic makes gameplay kind of impossible.

Another EDIT: I went back to the blizz-abs controller v1.1. Now I can get the game to start, but again players cannot talk, and it's having wierd random save data errors. I'm assuming this is due to the abs controller being v1.1, so any advice on fixing my original error with 1.2 (above) so that I can return to the less glitchy 1.2 would be greatly appreciated. Also any advice on how to make the game write and read save data to/from the mySQL database would be extremely helpful, because the client just isn't doing it.

Yet Another EDIT: Just to let you know, there are a few other problems as well. The major ones that make it impossible for you to play the game are: the game appears to be unable to read save data, therefore, even if it did manage to write it, which it rarely does, it can't read it, so it doesn't matter. Also, enemies don't work. They just stand in a fixed position with the lifebar above their head. They can't attack you, you can't attack them. Also, if you exit the game window, then try logging back in, it says you're already logged in, therefore the only way to log back in is shut down the server and then try it. Obviously this wouldn't work. One final piece of information that I may have already mentioned: being able to talk, and being able to see other players appears to be directly linked to being able to wirte save data. If it's successfully writing the data, I can talk and see other players. If I can't do any one of those, I also can't do the other two. So......a few bugs. Please help.

[Wizered67]

D you only get this when you host it on the website you mentioned? I don't have any of these problems.....