Local server?
 

Hello, so this is kinda a mod question cause it relates to using mods/plugins and such locally,
was just wondering if anyone knows anything about setting EVERYTHING up locally, from a MySQL server for the maps and plugins to running the server itself, as I want to run it as dedicated for my friends to play on.

I currently have Steam CMD and all that greatness already setup, I recently started working on the MySQL database and got almost everything working, the only issue is that I can't figure out how to connect to it via ftp like, I know it's local but I can't connect to the data base at all?

I get the error:

"Status: Connection attempt failed with "ECONNREFUSED - Connection refused by server".
Error: Could not connect to server
Status: Waiting to retry..."

and this happens even if I connect using "Only use plain FTP" Encryption like most say.
I've ran the "Network configuration wizard" and I get "connection closed prematurely" and "failed to create listen socket on port 0, aborting"

is it just because it's all local? and if so where do I go to sort the "root" files for setting up the server?

if there is any more questions or tips, I will answer them the moment I wake up, and thanks for everything guys :)

Re: Local server?
 

I'm not sure if you are mixing things up here a little.
MYSQL is a database and you can't connect to it with FTP wich is a file server.

And why would you need FTP if you have everything locally?

Re: Local server?
 

I thought you had to have MySQL to make a database?

the only thing local would be the files, I want it to function like a normal host server would.

otherwise why would like CKsurf have SQL files? tbh I haven't messed with this stuff in a long time so I may just be doing stuff I don't gotta do

pretty much what I'm looking to do is make my PC a dedicated server, all the way from letting people download the maps from my pc on the server to having CKsurf, bot times, player times, models, trails, everything pretty much.

this may actually be way to difficult for me but I reallllly don't wanna pay for a server again, so far I have the server set up to boot and people could join it if I let them, however right now no one can download maps through the server, and CKsurf is not currently working due to the SQL server not working.

Re: Local server?
 

...well, yes. MySQL database is saved in one kind file.
But you not do anything with it withouth MySQL program.

If plugin use MySQL to store data, stats, etc. etc. You need MySQL program or server.

You can try install this free MySQL+php program in same local PC where your srcds is.
http://www.uniformserver.com/

There is other similiar programs to.


If plugin use SQLite, sourcemod can handle that itself.

*edit
There could be differences with those free programs, so it work or not.

Re: Local server?
 

There no reason to install Apache or some suite, or even PHP as you suggested. The MySQL server itself is just enough.

Re: Local server?
 

...phpMyAdmin ?

Re: Local server?
 

I already have MySQL installed and set up, infact it's actually running on the server already I just can't figure out how to add the files so others can download it, I imagine if I can get the files to go into the root directory of the database "cksurf" I will be done right?

https://imgur.com/a/b0qDF

this is what the MySQL data bases look like, all the SM and local files are linked to those databases in the Databases CFG

Re: Local server?
 

You mean "files" -> upload maps for players ?
You perhaps need run another program to host files as server... filezilla ?

*edit
srcds.exe can upload also missing files, but it have own MAX file limits. And it is slow.

Re: Local server?
 

Yeah thats what I mean, but I can't figure out how to put the files in the directory, I mean so far the server itself does have most cksurf SQL files, however if I try to put the extra ones on there it won't let me simply drag and drop?

oh I need to create a actual database aside from mysql?

and I tried to connect to MySQL server with filezilla but since it's local I don't think it's possible. I get quite a few issues when trying to connect to the database even when using the information I put in the databases CFG

Well, if I can't use this set up then I'll have to get you to teach me how to set it up that way lol, I don't really wanna have everyone complaining about speed and lack of maps

Re: Local server?
 

...I quick peek cksurf file, https://github.com/fluffyst/Surftime...aster/optional
I didn't understand what the heck you where talking all the time about database sql files :D

There seems SQL command files *sql
You need in import sql file from phpMyAdmin to one of database. (ck_zones, ck_maptier)

*edit
example https://forums.alliedmods.net/showpo...11&postcount=2