gixxer_j
-
Posts
14 -
Joined
-
Last visited
-
Days Won
1
Posts posted by gixxer_j
-
-
You should be creating a user in mysql for running the server, not using the root account.
I'm assuming your mysql server is on the same machine as the emu.
1) log in to mysql:
mysql -uroot -p
enter your password when prompted
2) I always create the databases first, but i believe that the worldserver and authserver will create them if they don't exist. To do this, from the mysql prompt run:
create database world;
create database auth;
create database characters;
3) from the mysql prompt run the following to create the user and authorize them to have access to the databases.
create user 'trinity'@'localhost' identified by 'trinity';
grant all on auth.* to 'trinity'@'localhost' identified by 'trinity';
grant all on characters.* to 'trinity'@'localhost' identified by 'trinity';
grant all on world.* to 'trinity'@'localhost' identified by trinity;
quit
4) now, edit your worldserver.conf and authserver.conf so that the connection strings are like the following: (should be in the /etc folder)
LoginDatabaseInfo is in both authserver.conf and worldserver.conf. WorldDatabaseInfo and CharacterDatabaseInfo are in worldserver.conf only
LoginDatabaseInfo = "127.0.0.1;3306;trinity;trinity;auth"
WorldDatabaseInfo = "127.0.0.1;3306;trinity;trinity;world"
CharacterDatabaseInfo = "127.0.0.1;3306;trinity;trinity;characters"
then try running worldserver again.
-
1
-
-
Glad to hear!
Those lines are fairly new AFAICT - i think you only need to edit them if the mysql bin folder is NOT in your path, otherwise it won't find them.
-
did you edit the .conf file and locate the mysql executable?
around line 170 in bnetserver.conf, 225 in worldserver.conf, 158 in authserver.conf
-
1
-
-
4 hours ago, Lorac said:
make sure your LoginREST.ExternalAddress= points to your real ip address not your internal router ip address to get that just type whats my ip address in your search box on browser
Yep, LoginRest.ExternalAddress is my external address
LoginREST.Port = 8081
LoginREST.ExternalAddress = xx.xxx.xxx.xxx
LoginREST.LocalAddress = 192.168.1.10I checked that all the ports i listed in the OP are indeed open, and they are.
3.3.5 can connect locally using the LAN ip (192.168.1.10), locally using my external ip, and remotely using my external ip.
6x can connect locally using the LAN ip (192.168.1.10), locally using my external ip, but NOT remotely using my external ip.
-
I have 3.3.5a and 6x server running on linux simultaneously, and they both work for connections from the local LAN.
I set up port forwarding using
(3.3.5a) -> 3724 , 8087
changed worldserver.conf port and auth.realmlist to 8087
(6x) -> 1119,8081, 8085,8086
I changed my local config to use my external ip, and both 3.3.5a and 6x connect - from a local machine using my external ip
on a remote machine, 3.3.5a connects fine
6x gives me a 'you have been disconnected (BLZ51914001)' when logging in.
According to BattleNet.log, the local 6x connects via my external ip on port 1119 - so at least it appears that port forwarding is working....
3/31 12:52:44.683 [IBN_Login] Starting up | hasFrontInterface=false | hasBackInterface=false
3/31 12:53:01.901 [GlueLogin] Starting login | launcherPortal=nullopt | loginPortal=xx.xxx.xxx.xxx:1119
3/31 12:53:01.901 [GlueLogin] Resetting
3/31 12:53:01.901 [IBN_Login] Initializing
3/31 12:53:01.901 [IBN_Login] Attempting logon | host=xx.xxx.xxx.xxx | port=1119
3/31 12:53:01.901 [GlueLogin] Waiting for server response.
3/31 12:53:01.992 [GlueLogin] Waiting for server response.
3/31 12:53:02.002 [GlueLogin] Waiting for server response.
3/31 12:53:02.074 [GlueLogin] Waiting for server response.
3/31 12:53:02.229 [GlueLogin] Waiting for server response.
3/31 12:53:02.249 [GlueLogin] Waiting for server response.
3/31 12:53:02.311 [GlueLogin] Logon complete.
3/31 12:53:02.311 [GlueLogin] Waiting for realm list.the remote machine has the following:
3/31 13:23:53.905 [IBN_Login] Starting up | hasFrontInterface=false | hasBackInterface=false
3/31 13:24:06.647 [GlueLogin] Starting login | launcherPortal=nullopt | loginPortal=xx.xxx.xxx.xxx:1119
3/31 13:24:06.647 [GlueLogin] Resetting
3/31 13:24:06.647 [IBN_Login] Initializing
3/31 13:24:06.647 [IBN_Login] Attempting logon | host=xx.xxx.xxx.xxx | port=1119
3/31 13:24:06.647 [GlueLogin] Waiting for server response.
3/31 13:24:06.790 [GlueLogin] Waiting for server response.
3/31 13:24:06.809 [GlueLogin] Waiting for server response.
3/31 13:24:07.839 [GlueLogin] Fatal error while logging in | result=( | code=ERROR_HTTP_COULDNT_CONNECT (14001) | localizedMessage= | debugMessage=JSON error: ERROR_HTTP_COULDNT_CONNECT (14001) token: 1)What am I missing?
Any suggestions?
EDIT:
I saw this:
but I had already set those values correctly.
And according to canyouseeme.org, all the ports are open and not blocked by my isp.
-
Any luck? I've got 3.3.5 and 6x running ok with 5.6.28 (linux)
EDIT:
I set up mine like
create user 'trinity'@'%' identified by 'trinity';
create database auth;
create database characters;
create database world;
then
grant all on auth.* to 'trinity'@'%' identified by 'trinity';
grant all on characters.* to 'trinity'@'%' identified by 'trinity';
grant all on world.* to 'trinity'@'%' identified by 'trinity';
ran the sql from sql/base
ran the sql from the db download
-
1 hour ago, Shauren said:
Incompatible? realmlist.gamebuild controls that.
Changing the gamebuild and restarting server didn't work, still incompatible.
1 hour ago, jtongzhi said:try SET portal "127.0.0.1" at config.wtf and repatch.
Tried that with 127.0.0.1 and 192.168.1.10
still getting incompatible realm.
EDIT:
/sigh
so apparently my dyslexia and inability to check each number kicked in.....
i put in '21335' instead of '21355'.
Connecting now....
-
1
-
-
Yep, I changed that to the 21355 per the client supported post, restarted the server and still getting the incompatible message.
Changed the realm name to 6X so I know it's connecting to the right db - bnetserver shows 6x and so des the realm list after login.
-
I'll try again and make sure all files are in place - and see if some of the above suggestions work and post back.
EDIT:
Yep, I was missing the tc_bundle.txt. I cleaned up the wow folder a bit and must have selected that file when I did.
I'm now able to connect, but getting an 'incompatible' realm.
Looking into that now!
Thanks Shauren!
-
14 hours ago, Shauren said:
FFS when will you people learn that copying the patched exe from another machine alone IS NOT ENOUGH? You need another file in wow installation folder - tc_bundle.txt
I think I oversimplified "copying the patched exe", i copied the entire installation from windows -> linux, ran the patcher, then copied the entire install from linux -> windows. I should have specified that.
-
Hi all,
wondering if someone might be able to point me in the right direction.
I wanted to try out the 6x branch of the server so here's what i've done so far:
i pulled everything yesterday and compiled (TrinityCore rev. 7f8cd123c43b 2016-03-28 23:10:44 +0100 (6.x branch) (Unix, Release)).
Updated my client to 6.2.4.21355 via WoW Launcher / Battle.Net
ran the extractors (dbc / maps / vmaps / mmaps),
updated my configs with the new versions,
loaded the db (TDB_full_6.03_2015_11_08) from scratch,
edited the realmist table and changed both 'address' and 'localAddress' to 192.168.1.10
and ran bnetserver and worldserver. They updated and are running.
Created an account
I updated my client config.wtf to add
SET portal "192.168.1.10"
SET patchlist "192.168.1.10"ran the connection patcher on wow.exe (on linux), copied it back to my wow install
bnetserver and worldserver are running on a linux server (192.168.1.10) that is also successfully running 3.3.5a (it's stopped at present).
Ran Wow_Patched.exe (same LAN as the server) and tried to log in and got the error
'You have been disconnected. (BLZ51901021)'
BattleNet.log has the following:
3/30 11:43:28.790 [IBN_Login] Starting up | hasFrontInterface=false | hasBackInterface=false
3/30 11:43:55.244 [GlueLogin] Starting login | launcherPortal=nullopt | loginPortal=192.168.1.10:1119
3/30 11:43:55.244 [GlueLogin] Resetting
3/30 11:43:55.244 [IBN_Login] Initializing
3/30 11:43:55.244 [IBN_Login] Attempting logon | host=192.168.1.10 | port=1119
3/30 11:43:55.244 [GlueLogin] Waiting for server response.
3/30 11:43:55.441 [IBN_Login] Front disconnected | connectionId=1 | result=( | code=ERROR_NETWORK_MODULE_FAILED_TO_DOWNLOAD_CERT_BUNDLE (1021) | localizedMessage= | debugMessage=)
3/30 11:43:55.441 [GlueLogin] Fatal error while logging in | result=( | code=ERROR_NETWORK_MODULE_FAILED_TO_DOWNLOAD_CERT_BUNDLE (1021) | localizedMessage= | debugMessage=)
Thought maybe that error had to do with the two new (to me) files in the bin folder, bnetserver.cert.pem and bnetserver.key.pem
Wasn't sure what to do with them, so i thought maybe they followed the same pattern as the bnetserver.conf.dist, so i copied (not renamed) both of them to 'bnetserver.cert' and 'bnetserver.key'.
all 4 files are in the same folder as bnetserver and worldserver.
I restarted bnetserver and worldserver and tried again, with the same results
firewall on server is currently inactive (ufw)
now i'm stuck. Any suggestions?
-
Looks like your mysql user is missing privileges...
from the mysql prompt try:
grant all on dbname.* to 'user'@'%' identified by 'password';
change dbname to the name of the database in question, user to the mysql user and password to that user's password.
"unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page
in Help and Support
Posted
If you haven't already, you'll need to run the extractors in the client folder on a properly updated client to generate the dbc, maps, etc.
And yes, just add each of those lines to your worldserver.conf file.
True, I always forget about those - it's been so long since I've done a server from scratch.