Dedicated Server cannot connect to DB

General discussion about Life is Feudal MMO and Life is Feudal: Your Own, The main section and backbone of the forums.

Shu
 
Posts: 84
Joined: 23 Sep 2014, 19:16

Dedicated Server cannot connect to DB

Post by Shu » 26 Sep 2014, 18:29

Hi!

I've just set up my dedicated server, following the instructions given in the infamous steam community post. Everything went fine up until I started the server. The window pops up and immediately closes again. Starting as admin didn't do anything.

The logs from the server say:
//-------------------------- 9/26/2014 -- 20:14:30 -----
ECHO 2014-09-26 20:14:30.364 {00} <NOSCOPE> --------- Loading DIRS ---------
ECHO 2014-09-26 20:14:30.365 {00} <NOSCOPE>
ECHO 2014-09-26 20:14:30.366 {01} <onStart>
--------- Initializing Directory: scripts ---------
ECHO 2014-09-26 20:14:30.367 {02} <initServer>
--------- Initializing LiF Server: Server Scripts ---------
ECHO 2014-09-26 20:14:30.375 {02} <initServer> Loading CmConfiguration
ECHO 2014-09-26 20:14:30.376 {02} <initServer> Init of DB interface
ERRR 2014-09-26 20:14:30.382 {02} <initServer> CmDb::_connect() - connection error #1045: Access denied for user 'root'@'localhost' (using password: YES)
ERRR 2014-09-26 20:14:30.382 {02} <initServer> CmServerInfoManager::processLocalWorlds() - can't connect to MySQL!
ERRR 2014-09-26 20:14:30.382 {02} <initServer> Fatal: Can't init local world (id=). Terminating.
ECHO 2014-09-26 20:14:30.382 {00} <NOSCOPE> Engine initialized...
core/scripts/server/server.cs (69): Unable to find function destroyWorld


But I can connect via HeidiSQL just fine and see everything. I've also correctly set my password in the config_local.cs and triple checked.
Why can't the game server connect then? Thanks for any insight!

User avatar
Rarp
 
Posts: 137
Joined: 26 Sep 2014, 13:55

Re: Dedicated Server cannot connect to DB

Post by Rarp » 26 Sep 2014, 18:33

Taken from elsewhere:

Edit your config_local.cs which is located in (root)\Program Files (x86)\Steam\SteamApps\Common\Life Is Feudal Your Own Dedicated Server\Docs
Change server = "127.0.0.1" to "localhost"
Change Password = "THE PASSWORD YOU MADE WHEN INSTALLING MARIADB"
MOVE the file to the directory above:
(root)\Program Files (x86)\Steam\SteamApps\Common\Life Is Feudal Your Own Dedicated Server\
ImagejoinToRemoteServer("lif.nightswatch.ca:28000","")
The Night's Watch is recruiting!
Web based skill calculator


Shu
 
Posts: 84
Joined: 23 Sep 2014, 19:16

Re: Dedicated Server cannot connect to DB

Post by Shu » 26 Sep 2014, 18:52

Ahhh! The copying wasn't mentioned in the article, or I didn't see it. Works like charm now, thanks a lot!

User avatar
Rarp
 
Posts: 137
Joined: 26 Sep 2014, 13:55

Re: Dedicated Server cannot connect to DB

Post by Rarp » 26 Sep 2014, 18:56

Shu wrote:Ahhh! The copying wasn't mentioned in the article, or I didn't see it. Works like charm now, thanks a lot!


Glad I could help out!
ImagejoinToRemoteServer("lif.nightswatch.ca:28000","")
The Night's Watch is recruiting!
Web based skill calculator


Drifter711
 
Posts: 5
Joined: 06 Oct 2014, 05:53

Re: Dedicated Server cannot connect to DB

Post by Drifter711 » 06 Oct 2014, 06:00

so i got my server going and all that my friends are able to find it in the list and have been playing for a couple days but i cant for the life of me get in i know i need to use the console to do it and have been using it joinToRemoteServer("xx.x.x.xx:28000","xxxxxxxx") all i get is the waiting for server screen no moving ... or login activity on the dedicated server screen nothing what am i doing wrong
:crazy: :%)


Snapshot
 
Posts: 29
Joined: 21 Sep 2014, 19:50

Re: Dedicated Server cannot connect to DB

Post by Snapshot » 06 Oct 2014, 10:06

Drifter711 wrote:so i got my server going and all that my friends are able to find it in the list and have been playing for a couple days but i cant for the life of me get in i know i need to use the console to do it and have been using it joinToRemoteServer("xx.x.x.xx:28000","xxxxxxxx") all i get is the waiting for server screen no moving ... or login activity on the dedicated server screen nothing what am i doing wrong
:crazy: :%)


Is you server hosted by a hosting provider? If not and you are hosting it at your computer at home you may have to forward the 28000 port to the computer the dedicated server is running on.

Please consider that some router / modems do not allow to use single port forward (mine for example) the just use a port range like 28000-28000 or 27999-28001 (depends on what is allowed).


Drifter711
 
Posts: 5
Joined: 06 Oct 2014, 05:53

Re: Dedicated Server cannot connect to DB

Post by Drifter711 » 06 Oct 2014, 18:33

yeah im running it on my computer ports are forwarded in both windows firewall and router and like i said my friends are able to connect to it and play and have been for a few days i am the only one that cant connect to the server

User avatar
Rarp
 
Posts: 137
Joined: 26 Sep 2014, 13:55

Re: Dedicated Server cannot connect to DB

Post by Rarp » 06 Oct 2014, 19:00

Drifter711 wrote:yeah im running it on my computer ports are forwarded in both windows firewall and router and like i said my friends are able to connect to it and play and have been for a few days i am the only one that cant connect to the server


Is it running on the same machine you're hosting it off of? If so...

Load game
Hit ~
Type in:
/joinToRemoteServer("127.0.0.1:28000","")
ImagejoinToRemoteServer("lif.nightswatch.ca:28000","")
The Night's Watch is recruiting!
Web based skill calculator


Drifter711
 
Posts: 5
Joined: 06 Oct 2014, 05:53

Re: Dedicated Server cannot connect to DB

Post by Drifter711 » 06 Oct 2014, 19:10

like i said in my first post i am doing that and it goes to waiting for server screen and thats it it goes no further


Snapshot
 
Posts: 29
Joined: 21 Sep 2014, 19:50

Re: Dedicated Server cannot connect to DB

Post by Snapshot » 06 Oct 2014, 19:20

Drifter711 wrote:like i said in my first post i am doing that and it goes to waiting for server screen and thats it it goes no further


Maybe I haven't read it properly but are you able to connect to other servers? It also won't be worse to allow the LiF client access in the windows firewall... maybe there is something blocking. Is there any log in the dedicated server console when you try to login? Does the LiF Client gives you a timeout error?


Drifter711
 
Posts: 5
Joined: 06 Oct 2014, 05:53

Re: Dedicated Server cannot connect to DB

Post by Drifter711 » 06 Oct 2014, 20:12

i am able to connect to other servers have to to use the console to log into mine. no i dont get a timeout it just sits at waiting for server and sometimes you can hear game sounds. i have already allowed everything i know of in the windows firewall. and no when i try to log in there is no activity in the dedicated server window


Drifter711
 
Posts: 5
Joined: 06 Oct 2014, 05:53

Re: Dedicated Server cannot connect to DB

Post by Drifter711 » 06 Oct 2014, 21:12

i finally figured it out sorry for all the trouble


Snapshot
 
Posts: 29
Joined: 21 Sep 2014, 19:50

Re: Dedicated Server cannot connect to DB

Post by Snapshot » 07 Oct 2014, 15:56

Drifter711 wrote:i finally figured it out sorry for all the trouble


And? It will be good to know where your problem was located...


Metl
 
Posts: 19
Joined: 24 Oct 2014, 05:44

Re: Dedicated Server cannot connect to DB

Post by Metl » 01 Nov 2014, 21:01

I'm curious as to what the problem was. When I try to connect, my server crashes.


Fr3eMan
 
Posts: 1
Joined: 06 Dec 2014, 06:50

Re: Dedicated Server cannot connect to DB

Post by Fr3eMan » 06 Dec 2014, 06:54

Hello, I have same problem with my server, this is the logfile

Spoiler


I already change from 127.0.0.1 to localhost but nothing, any suggestion?

update 7/12/2014

problem solved! :D


valirius
Alpha Tester
 
Posts: 80
Joined: 28 Nov 2011, 11:20
Location: Time-paradox.net

Re: Dedicated Server cannot connect to DB

Post by valirius » 17 Dec 2014, 21:04

how solve this problem?
ImageYou are entering    Time ParadoxImage


Sydbio
Beta Tester
 
Posts: 25
Joined: 09 Dec 2014, 14:06

Re: Dedicated Server cannot connect to DB

Post by Sydbio » 06 Mar 2015, 02:12

Shu wrote:Hi!

I've just set up my dedicated server, following the instructions given in the infamous steam community post. Everything went fine up until I started the server. The window pops up and immediately closes again. Starting as admin didn't do anything.

The logs from the server say:
//-------------------------- 9/26/2014 -- 20:14:30 -----
ECHO 2014-09-26 20:14:30.364 {00} <NOSCOPE> --------- Loading DIRS ---------
ECHO 2014-09-26 20:14:30.365 {00} <NOSCOPE>
ECHO 2014-09-26 20:14:30.366 {01} <onStart>
--------- Initializing Directory: scripts ---------
ECHO 2014-09-26 20:14:30.367 {02} <initServer>
--------- Initializing LiF Server: Server Scripts ---------
ECHO 2014-09-26 20:14:30.375 {02} <initServer> Loading CmConfiguration
ECHO 2014-09-26 20:14:30.376 {02} <initServer> Init of DB interface
ERRR 2014-09-26 20:14:30.382 {02} <initServer> CmDb::_connect() - connection error #1045: Access denied for user 'root'@'localhost' (using password: YES)
ERRR 2014-09-26 20:14:30.382 {02} <initServer> CmServerInfoManager::processLocalWorlds() - can't connect to MySQL!
ERRR 2014-09-26 20:14:30.382 {02} <initServer> Fatal: Can't init local world (id=). Terminating.
ECHO 2014-09-26 20:14:30.382 {00} <NOSCOPE> Engine initialized...
core/scripts/server/server.cs (69): Unable to find function destroyWorld


But I can connect via HeidiSQL just fine and see everything. I've also correctly set my password in the config_local.cs and triple checked.
Why can't the game server connect then? Thanks for any insight!


update your world_1.xml, make one new, don't place one big server name.


Therockman123
 
Posts: 3
Joined: 14 Jan 2015, 01:43

Re: Dedicated Server cannot connect to DB

Post by Therockman123 » 08 Aug 2015, 19:13

Rarp wrote:Taken from elsewhere:

Edit your config_local.cs which is located in (root)\Program Files (x86)\Steam\SteamApps\Common\Life Is Feudal Your Own Dedicated Server\Docs
Change server = "127.0.0.1" to "localhost"
Change Password = "THE PASSWORD YOU MADE WHEN INSTALLING MARIADB"
MOVE the file to the directory above:
(root)\Program Files (x86)\Steam\SteamApps\Common\Life Is Feudal Your Own Dedicated Server\

if changing the server to localhost. wont that be only the ppl who is at ur own house can connect. but no one else like UK friends?

Return to General Discussion

cron