Cannot Get Game Server Running

[cbk41]

Hi there,

I have the search and login server running just fine. I have been having trouble (I believe) with the triggers sql file. Not sure if triggers is supposed to show up in navicat under the dspdb along with the other squls, but it isn't there. This is the error I get if I try to paste the "DELETE FROM..." code into the box. Originally just the "accounts" part was there, ansd I was effectively trying to paste the "chars" part.

[kjLotus]

triggers.sql doesn't make a table, it just makes a bunch of triggers (not sure if you can even see them in navicat or not)

[cbk41]

That's pretty much what I figured. Regardless, the game server crashes upon launch.

[cbk41]

Here's a log


[1;32m[Status][0m Memory manager initialised: [1;37mlog/DSP.leaks[0m
[1;37m[Info][0m DarkStar - onetimexi - SVN Revision: [1;37m1743[0m.
[1;32m[Status][0m do_init: begin server initialization...
[21:59:38][1;37m[Info][0m Console Silent Setting: 0 - [1;32m[OK][0m
[21:59:38][1;32m[Status][0m do_init: map_config is reading - [1;32m[OK][0m
[21:59:38][1;32m[Status][0m luautils::init:lua initializing... - [1;32m[OK][0m
[21:59:38][1;32m[Status][0m cmdhandler::init: initializing... - [1;32m[OK][0m
[21:59:38][1;32m[Status][0m do_init: sqlhandle is allocating[21:59:38][1;35m[SQL][0m Access denied for user 'root'@'localhost' (using password: YES)
[1;32m[Status][0m Memory manager initialised: [1;37mlog/DSP.leaks[0m
[1;37m[Info][0m DarkStar - onetimexi - SVN Revision: [1;37m1743[0m.
[1;32m[Status][0m do_init: begin server initialization...
[21:59:38][1;37m[Info][0m Console Silent Setting: 0 - [1;32m[OK][0m
[21:59:38][1;32m[Status][0m do_init: map_config is reading - [1;32m[OK][0m
[21:59:38][1;32m[Status][0m luautils::init:lua initializing... - [1;32m[OK][0m
[21:59:38][1;32m[Status][0m cmdhandler::init: initializing... - [1;32m[OK][0m
[21:59:38][1;32m[Status][0m do_init: sqlhandle is allocating[21:59:38][1;35m[SQL][0m Access denied for user 'root'@'localhost' (using password: YES)
[1;32m[Status][0m Memory manager initialised: [1;37mlog/DSP.leaks[0m
[1;37m[Info][0m DarkStar - onetimexi - SVN Revision: [1;37m1743[0m.
[1;32m[Status][0m do_init: begin server initialization...
[22:00:03][1;37m[Info][0m Console Silent Setting: 0 - [1;32m[OK][0m
[22:00:03][1;32m[Status][0m do_init: map_config is reading - [1;32m[OK][0m
[22:00:03][1;32m[Status][0m luautils::init:lua initializing... - [1;32m[OK][0m
[22:00:03][1;32m[Status][0m cmdhandler::init: initializing... - [1;32m[OK][0m
[22:00:03][1;32m[Status][0m do_init: sqlhandle is allocating[22:00:03][1;35m[SQL][0m Access denied for user 'root'@'localhost' (using password: YES)
[1;32m[Status][0m Memory manager initialised: [1;37mlog/DSP.leaks[0m
[1;37m[Info][0m DarkStar - onetimexi - SVN Revision: [1;37m1743[0m.
[1;32m[Status][0m do_init: begin server initialization...
[22:00:41][1;37m[Info][0m Console Silent Setting: 0 - [1;32m[OK][0m
[22:00:41][1;32m[Status][0m do_init: map_config is reading - [1;32m[OK][0m
[22:00:41][1;32m[Status][0m luautils::init:lua initializing... - [1;32m[OK][0m
[22:00:41][1;32m[Status][0m cmdhandler::init: initializing... - [1;32m[OK][0m
[22:00:41][1;32m[Status][0m do_init: sqlhandle is allocating[22:00:41][1;35m[SQL][0m Access denied for user 'root'@'localhost' (using password: YES)
[1;32m[Status][0m Memory manager initialised: [1;37mlog/DSP.leaks[0m
[1;37m[Info][0m DarkStar - onetimexi - SVN Revision: [1;37m1743[0m.
[1;32m[Status][0m do_init: begin server initialization...
[22:04:16][1;37m[Info][0m Console Silent Setting: 0 - [1;32m[OK][0m
[22:04:16][1;32m[Status][0m do_init: map_config is reading - [1;32m[OK][0m
[22:04:16][1;32m[Status][0m luautils::init:lua initializing... - [1;32m[OK][0m
[22:04:16][1;32m[Status][0m cmdhandler::init: initializing... - [1;32m[OK][0m
[22:04:16][1;32m[Status][0m do_init: sqlhandle is allocating[22:04:16][1;35m[SQL][0m Access denied for user 'root'@'localhost' (using password: YES)
[1;32m[Status][0m Memory manager initialised: [1;37mlog/DSP.leaks[0m
[1;37m[Info][0m DarkStar - onetimexi - SVN Revision: [1;37m1743[0m.
[1;32m[Status][0m do_init: begin server initialization...
[22:04:30][1;37m[Info][0m Console Silent Setting: 0 - [1;32m[OK][0m
[22:04:30][1;32m[Status][0m do_init: map_config is reading - [1;32m[OK][0m
[22:04:30][1;32m[Status][0m luautils::init:lua initializing... - [1;32m[OK][0m
[22:04:30][1;32m[Status][0m cmdhandler::init: initializing... - [1;32m[OK][0m
[22:04:30][1;32m[Status][0m do_init: sqlhandle is allocating[22:04:30][1;35m[SQL][0m Access denied for user 'root'@'localhost' (using password: YES)
[1;32m[Status][0m Memory manager initialised: [1;37mlog/DSP.leaks[0m
[1;37m[Info][0m DarkStar - onetimexi - SVN Revision: [1;37m1743[0m.
[1;32m[Status][0m do_init: begin server initialization...
[22:04:30][1;37m[Info][0m Console Silent Setting: 0 - [1;32m[OK][0m
[22:04:30][1;32m[Status][0m do_init: map_config is reading - [1;32m[OK][0m
[22:04:30][1;32m[Status][0m luautils::init:lua initializing... - [1;32m[OK][0m
[22:04:30][1;32m[Status][0m cmdhandler::init: initializing... - [1;32m[OK][0m
[22:04:30][1;32m[Status][0m do_init: sqlhandle is allocating[22:04:30][1;35m[SQL][0m Access denied for user 'root'@'localhost' (using password: YES)
[1;32m[Status][0m Memory manager initialised: [1;37mlog/DSP.leaks[0m
[1;37m[Info][0m DarkStar - onetimexi - SVN Revision: [1;37m1743[0m.
[1;32m[Status][0m do_init: begin server initialization...
[22:06:24][1;37m[Info][0m Console Silent Setting: 0 - [1;32m[OK][0m
[22:06:24][1;32m[Status][0m do_init: map_config is reading - [1;32m[OK][0m
[22:06:24][1;32m[Status][0m luautils::init:lua initializing... - [1;32m[OK][0m
[22:06:24][1;32m[Status][0m cmdhandler::init: initializing... - [1;32m[OK][0m
[22:06:24][1;32m[Status][0m do_init: sqlhandle is allocating[22:06:24][1;35m[SQL][0m Access denied for user 'root'@'localhost' (using password: YES)
[1;32m[Status][0m Memory manager initialised: [1;37mlog/DSP.leaks[0m
[1;37m[Info][0m DarkStar - onetimexi - SVN Revision: [1;37m1743[0m.
[1;32m[Status][0m do_init: begin server initialization...
[22:08:56][1;37m[Info][0m Console Silent Setting: 0 - [1;32m[OK][0m
[22:08:56][1;32m[Status][0m do_init: map_config is reading - [1;32m[OK][0m
[22:08:56][1;32m[Status][0m luautils::init:lua initializing... - [1;32m[OK][0m
[22:08:56][1;32m[Status][0m cmdhandler::init: initializing... - [1;32m[OK][0m
[22:08:56][1;32m[Status][0m do_init: sqlhandle is allocating[22:08:56][1;35m[SQL][0m Access denied for user 'root'@'localhost' (using password: YES)
[1;32m[Status][0m Memory manager initialised: [1;37mlog/DSP.leaks[0m
[1;37m[Info][0m DarkStar - onetimexi - SVN Revision: [1;37m1743[0m.
[1;32m[Status][0m do_init: begin server initialization...
[22:25:30][1;37m[Info][0m Console Silent Setting: 0 - [1;32m[OK][0m
[22:25:30][1;32m[Status][0m do_init: map_config is reading - [1;32m[OK][0m
[22:25:30][1;32m[Status][0m luautils::init:lua initializing... - [1;32m[OK][0m
[22:25:30][1;32m[Status][0m cmdhandler::init: initializing... - [1;32m[OK][0m
[22:25:30][1;32m[Status][0m do_init: sqlhandle is allocating[22:25:30][1;35m[SQL][0m Access denied for user 'root'@'localhost' (using password: YES)
[1;32m[Status][0m Memory manager initialised: [1;37mlog/DSP.leaks[0m
[1;37m[Info][0m DarkStar - onetimexi - SVN Revision: [1;37m1743[0m.
[1;32m[Status][0m do_init: begin server initialization...
[00:43:45][1;37m[Info][0m Console Silent Setting: 0 - [1;32m[OK][0m
[00:43:45][1;32m[Status][0m do_init: map_config is reading - [1;32m[OK][0m
[00:43:45][1;32m[Status][0m luautils::init:lua initializing... - [1;32m[OK][0m
[00:43:45][1;32m[Status][0m cmdhandler::init: initializing... - [1;32m[OK][0m
[00:43:45][1;32m[Status][0m do_init: sqlhandle is allocating[00:43:45][1;35m[SQL][0m Access denied for user 'root'@'localhost' (using password: YES)
[1;32m[Status][0m Memory manager initialised: [1;37mlog/DSP.leaks[0m
[1;37m[Info][0m DarkStar - onetimexi - SVN Revision: [1;37m1743[0m.
[1;32m[Status][0m do_init: begin server initialization...
[00:43:56][1;37m[Info][0m Console Silent Setting: 0 - [1;32m[OK][0m
[00:43:56][1;32m[Status][0m do_init: map_config is reading - [1;32m[OK][0m
[00:43:56][1;32m[Status][0m luautils::init:lua initializing... - [1;32m[OK][0m
[00:43:56][1;32m[Status][0m cmdhandler::init: initializing... - [1;32m[OK][0m
[00:43:56][1;32m[Status][0m do_init: sqlhandle is allocating[00:43:56][1;35m[SQL][0m Access denied for user 'root'@'localhost' (using password: YES)
[1;32m[Status][0m Memory manager initialised: [1;37mlog/DSP.leaks[0m
[1;37m[Info][0m DarkStar - onetimexi - SVN Revision: [1;37m1743[0m.
[1;32m[Status][0m do_init: begin server initialization...
[00:43:57][1;37m[Info][0m Console Silent Setting: 0 - [1;32m[OK][0m
[00:43:57][1;32m[Status][0m do_init: map_config is reading - [1;32m[OK][0m
[00:43:57][1;32m[Status][0m luautils::init:lua initializing... - [1;32m[OK][0m
[00:43:57][1;32m[Status][0m cmdhandler::init: initializing... - [1;32m[OK][0m
[00:43:57][1;32m[Status][0m do_init: sqlhandle is allocating[00:43:57][1;35m[SQL][0m Access denied for user 'root'@'localhost' (using password: YES)
[1;32m[Status][0m Memory manager initialised: [1;37mlog/DSP.leaks[0m
[1;37m[Info][0m DarkStar - onetimexi - SVN Revision: [1;37m1743[0m.
[1;32m[Status][0m do_init: begin server initialization...
[00:43:58][1;37m[Info][0m Console Silent Setting: 0 - [1;32m[OK][0m
[00:43:58][1;32m[Status][0m do_init: map_config is reading - [1;32m[OK][0m
[00:43:58][1;32m[Status][0m luautils::init:lua initializing... - [1;32m[OK][0m
[00:43:58][1;32m[Status][0m cmdhandler::init: initializing... - [1;32m[OK][0m
[00:43:58][1;32m[Status][0m do_init: sqlhandle is allocating[00:43:58][1;35m[SQL][0m Access denied for user 'root'@'localhost' (using password: YES)
[1;32m[Status][0m Memory manager initialised: [1;37mlog/DSP.leaks[0m
[1;37m[Info][0m DarkStar - onetimexi - SVN Revision: [1;37m1743[0m.
[1;32m[Status][0m do_init: begin server initialization...
[00:46:39][1;37m[Info][0m Console Silent Setting: 0 - [1;32m[OK][0m
[00:46:39][1;32m[Status][0m do_init: map_config is reading - [1;32m[OK][0m
[00:46:39][1;32m[Status][0m luautils::init:lua initializing... - [1;32m[OK][0m
[00:46:39][1;32m[Status][0m cmdhandler::init: initializing... - [1;32m[OK][0m
[00:46:39][1;32m[Status][0m do_init: sqlhandle is allocating[00:46:39][1;35m[SQL][0m Access denied for user 'root'@'localhost' (using password: YES)

[whitevamp]

check your password for mysql in your config file.

this
[00:46:39][1;32m[Status][0m do_init: sqlhandle is allocating[00:46:39][1;35m[SQL][0m Access denied for user 'root'@'localhost' (using password: YES)
is saying you have not entered the correct password in the conf file.

[cbk41]

Thanks. That's really what I thought was going on. I'm brand new to mysql and had all the config files matched up. I had to go into the SQL monitor dashboard and change it for the root user.

[cbk41]

Everything was running great until I decided to edit some config files while the server was still up. That's a big no-no, right? Because now I'm getting this. I'll re-install the server tomorrow and try not to do that again.

[atom0s]

Make sure you do a full checkout of the svn repo.

[cbk41]

Make sure you do a full checkout of the svn repo.

Yeah, I did full recursive. I did the whole set-up again and everything's a-ok.

[cbk41]

Welp, ran into a problem. After I tried to create my character and enter the world I got the 3101 error and this in the game server window.