Raised This Month: $99 Target: $400
 24% 

Local server?


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
ZmBzRALIVE
Member
Join Date: Apr 2016
Old 10-27-2017 , 01:22   Local server?
Reply With Quote #1

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
__________________


ZmBzRALIVE is offline
Sillium
AlliedModders Donor
Join Date: Sep 2008
Location: Germany
Old 10-27-2017 , 02:01   Re: Local server?
Reply With Quote #2

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?
__________________
brb, dishes have developed their own language and are talking to the garbage about overthrowing me... i must correct this


www.unterwasserpyromanen.de
Sillium is offline
ZmBzRALIVE
Member
Join Date: Apr 2016
Old 10-27-2017 , 04:07   Re: Local server?
Reply With Quote #3

Quote:
Originally Posted by Sillium View Post
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?
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.
__________________



Last edited by ZmBzRALIVE; 10-27-2017 at 04:18.
ZmBzRALIVE is offline
Bacardi
Veteran Member
Join Date: Jan 2010
Location: mom's basement
Old 10-27-2017 , 04:31   Re: Local server?
Reply With Quote #4

...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.
__________________
Do not Private Message @me

Last edited by Bacardi; 10-27-2017 at 04:33.
Bacardi is offline
KliPPy
AlliedModders Donor
Join Date: May 2013
Location: Serbia
Old 10-27-2017 , 06:13   Re: Local server?
Reply With Quote #5

Quote:
Originally Posted by Bacardi View Post
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.
There no reason to install Apache or some suite, or even PHP as you suggested. The MySQL server itself is just enough.
KliPPy is offline
Bacardi
Veteran Member
Join Date: Jan 2010
Location: mom's basement
Old 10-27-2017 , 06:32   Re: Local server?
Reply With Quote #6

Quote:
Originally Posted by KliPPy View Post
There no reason to install Apache or some suite, or even PHP as you suggested. The MySQL server itself is just enough.
...phpMyAdmin ?
Spoiler
__________________
Do not Private Message @me
Bacardi is offline
ZmBzRALIVE
Member
Join Date: Apr 2016
Old 10-27-2017 , 11:08   Re: Local server?
Reply With Quote #7

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
__________________



Last edited by ZmBzRALIVE; 10-27-2017 at 11:14.
ZmBzRALIVE is offline
Bacardi
Veteran Member
Join Date: Jan 2010
Location: mom's basement
Old 10-27-2017 , 11:30   Re: Local server?
Reply With Quote #8

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.

Last edited by Bacardi; 10-27-2017 at 11:31.
Bacardi is offline
ZmBzRALIVE
Member
Join Date: Apr 2016
Old 10-27-2017 , 11:35   Re: Local server?
Reply With Quote #9

Quote:
Originally Posted by Bacardi View Post
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.
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
__________________



Last edited by ZmBzRALIVE; 10-27-2017 at 11:36.
ZmBzRALIVE is offline
Bacardi
Veteran Member
Join Date: Jan 2010
Location: mom's basement
Old 10-27-2017 , 13:16   Re: Local server?
Reply With Quote #10

...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

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
__________________
Do not Private Message @me

Last edited by Bacardi; 10-27-2017 at 13:19.
Bacardi is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 09:42.


Powered by vBulletin®
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Theme made by Freecode