I finally set up MySQL 5.5
and Its all running, my game says its online, I register
then when I log in it says Disconnected.
anyone know how to help me?
have I missed a step?
Either your network has not been configured properly (look it up in the manual's installation guide) or something else is wrong. What does the log file say?
Nothing it all works fine except when I try to register a file playing the game, it comes up you have been disconnected.
RMX-OS GUI says its all working fine
I followed your Tutorial about setting up MySQL 5
but what do I do when that is finished? is there anything more i have to do besides add the information into RMX-OS GUI?
I think that the newest version of the GUI doesn't work properly with the newest version of RMX-OS. You should ask Ryex to update the GUI.
ill try installing the old one like the same one from your tutorial and let you know how that goes
EDIT:
how do I open TCP port 3306 in my firewall?
Please no double posting within 24 hours. ~ gameus
Port 3306 is used for MySQL connections to the server, not for gaming. It is recommended you use port 40000 or above since those are rarely used so there's a low possibility that they are used by something else.
(https://fbcdn-sphotos-h-a.akamaihd.net/hphotos-ak-snc7/391674_10151515648222741_1463726042_n.jpg)
thats my router what do I type in and where?
You don't actually have to do any port translation. You only have to turn on port forwarding.
I suggest that you type into "Port Range" the same port you specified as PORT in cfg.ini, "Translate To..." should be your internal IP address (e.g. 192.168.0.1, basically what you specified as HOST) and the trigger port is the same as "Port Range". Try that.
Also, please use spoilers for images.
sorry I just realized that in installing the MySQL server instance Config wizard
thats the thing stopping me saying that error NR. 1045
EDIT: So ive gone back to the start and tried installing MySQL 5.1.41
and I get to the final step and it says error Firewall is blocking 3306 and i tried changing it to all the other 330's but nothing will work.
ive tried turning my avg and windows firewall off and those still wont allow it to finish installing.
im just so lost right now
Please don't double post within 24 hours. Use the "Modify" function in the top right corner of your post instead.
Post the contents of your cfg.ini first. You only need to have port 3306 allowed through your firewall if your MySQL server is not the same machine as your RMX-OS server.
Sorry about that im new to this.
Ive set it up exactly as was shown again, im now using the old 5.1.41 MySQL
and when I set my game up it still says Mysql.users doesnt exist.
ive set up my game so it runs
Server Address: 127.0.0.1
Username: Root
Password:Root
Database Mysql (dont think thats right)
this is my script in the game
SERVERS.push(['Localhost', '127.0.0.1', 54269])
CFG
NAME = 'RMX-OS Server' (do I have to change this to the name of my game?)
HOST = '127.0.0.1'
PORT = 54269
RMXOS_VERSION = 1.18
LOG_MESSAGES = false
LOG_ERRORS = true
LOG_ACTIONS = true
DEBUG_MODE = false
MAXIMUM_CONNECTIONS = 50
LOGIN_TIMEOUT = 30
AUTO_RESTART = true
RESTART_TIME = 5
USE_IP_BANNING = true
PREVENT_ZOMBIE_CLIENTS = false
RUBY_PROMPT = false
OPTIMIZE_DATABASE_ON_STARTUP = true
DATABASE_CONNECTION_TIMEOUT = 60
SQL_HOSTNAME = '127.0.0.1'
SQL_USERNAME = 'root'
SQL_PASSWORD = 'root'
SQL_DATABASE = 'MySQL'
INBOX_SIZE = 10
EXTENSIONS = [
]
Did you use the proper SQL script that came with the download?
yes, Ill try starting from the start re-scripting it and see if that'll work
So I dont have a table Mysql.users
How do I make one? and is there a link to a tutorial simple enough to follow?
You didn't use the proper SQL script then. There's a folder called "Database" in the RMX-OS server. In this folder, there are numerous .SQL scripts. You have to execute this file "RMX-OS SQL Database.sql" in MySQL. It creates all the tables for you. You didn't completely follow instructions when setting up the script.
So I open that file and then I do what?
thats as far as the tutorial goes, it says open it and thats it
Quote from: Manual1.4.7. Creating the database
After you have installed MySQL and the management software for MySQL, you need to create a database for RMX-OS. This can be done by running an SQL query. SQL queries are run in the management software which means that you need to run the management software first in order to create the database. All queries you need to run are provided in a separate file in the server scripts (RMX-OS SQL Database.sql). You can open the file with a text editor (Notepad, Wordpad) or (depending on the management software) directly. If you are upgrading from an older version of RMX-OS, there are additional labeled query files that allow you to upgrade your database from one version to another. Make sure to apply ALL queries provided to upgrade from an older version.
Yeah I've read that but it doesnt make sense to me.
so i open Navicat to make a new database. and then what?
is there a video tutorial to show how to do that step?
Quote from: Manual1.4.7. Creating the database
After you have installed MySQL and the management software for MySQL, you need to create a database for RMX-OS. This can be done by running an SQL query. SQL queries are run in the management software which means that you need to run the management software first in order to create the database. All queries you need to run are provided in a separate file in the server scripts (RMX-OS SQL Database.sql). You can open the file with a text editor (Notepad, Wordpad) or (depending on the management software) directly. If you are upgrading from an older version of RMX-OS, there are additional labeled query files that allow you to upgrade your database from one version to another. Make sure to apply ALL queries provided to upgrade from an older version.
Quote from: ManualThis can be done by running an SQL query.
Quote from: Manualrunning an SQL query.
(http://imageshack.us/a/img88/2438/navicatr.png)
Quote from: ManualAll queries you need to run are provided in a separate file in the server scripts (RMX-OS SQL Database.sql).
It's literally in the first screen when you open Navicat.
this is what ive done so far correct me if im wrong
http://imageshack.us/a/img189/2945/17262931.png
http://imageshack.us/a/img89/1438/74665512.png
You named your database "mysql", not "rmxosdb". You have to change that in the SQL query and in cfg.ini. Or simply rename your database to "rmxosdb" (or delete it and create a new one named "rmxosdb").
Ok ive done that now.
what do I do next?
it let me create an account, but when i log in it comes up with an error script is left hanging.
never mind i copied my game and pasted it over the top of the original game and now it works
is it possible to turn off auto save? just incase i update my game and people are standing where a new barrier is,
p.s. caterpillar script wont work with it
Quote from: TjtheFox on September 19, 2012, 06:35:18 am
never mind i copied my game and pasted it over the top of the original game and now it works
is it possible to turn off auto save? just incase i update my game and people are standing where a new barrier is,
If you turn off auto-saving, people can cheat very easily. That's why you can't turn it off. You should consider these things before you update the game. There is no real way around it.
Quote from: TjtheFox on September 19, 2012, 06:35:18 am
p.s. caterpillar script wont work with it
It's not supported by RMX-OS, I mentioned that in the documentation.
I turned my computer off and then on again and it came up not allowed to connect to local host
Something with your network got messed up. Make sure that the RMX-OS server is up and running and make sure that you have added a firewall exception for the port you are using for RMX-OS (what you defined under PORT in cfg.ini).
its 54269 and i made sure it was open in my router and on my firewall
but even mysql server 5.1 wont connect, it worked fine yesterday
Something surely went wrong. Make sure you are running the server on 127.0.0.1 or localhost and you are connecting to that over the client, too. If it doesn't help, you have to google for the problem.
Hi me again, I got it all set up and running but when I give my game to my brother on the same network to play after ive compressed it into an exe file, they open it and yet it wont connect. it just says offline,
why doesnt theirs connect to my server?
Check out the part for setting up the network in the installation guide. If you follow all steps, it should be working. And check the FAQ, too.