search

cmangos / issues

This repository is used as a centralized point for all issues regarding CMaNGOS.
180 stars 47 forks source link

mangos-tbc realmd "The information you have entered is not valid" #1422

Closed jam1271 closed 7 years ago

jam1271 commented 7 years ago

Hey guys, first off wanted to say great work here!

I managed to compile and run mangos-tbc on my Raspberry Pi 3B running Ubuntu 16.04 server. I hit quite a few hurdles along the way but got it running.

Everything seems to be working now except I can't login. I have confirmed that I'm connecting to the realmd program (if it's not running I get a different error--unable to connect).

mysql> select * from realmlist;
+----+--------+--------------+------+------+------------+----------+----------------------+------------+-------------+
| id | name   | address      | port | icon | realmflags | timezone | allowedSecurityLevel | population | realmbuilds |
+----+--------+--------------+------+------+------------+----------+----------------------+------------+-------------+
|  1 | JAMWOW | 192.168.1.14 | 8085 |    1 |          0 |        1 |                    0 |          0 | 8606        |
+----+--------+--------------+------+------+------------+----------+----------------------+------------+-------------+
1 row in set (0.00 sec)

I created my user using the account create user pass as instructed in the guide. I'm using the exact same credentials from there to try and login.

ubuntu@ubuntu:~/wow/run/bin$ ./realmd 
CMaNGOS TBC/0.18 (2017-07-14 01:02:41 - f2186f064508e415c46724624cbcb89a084fddad) for Linux_x32 (little-endian) [realm-daemon]
<Ctrl-C> to stop.

Using configuration file ../etc/realmd.conf.
Login Database total connections: 2
MySQL client library: 5.7.18
MySQL server ver: 5.7.18-0ubuntu0.16.04.1 
MySQL client library: 5.7.18
MySQL server ver: 5.7.18-0ubuntu0.16.04.1 
Added realm id 1, name 'JAMWOW'

mangosd seems to be booting correctly and getting the right realm id

ubuntu@ubuntu:~/wow/run/bin$ ./mangosd 
CMaNGOS TBC/0.18 (2017-07-14 01:02:41 - f2186f064508e415c46724624cbcb89a084fddad) for Linux_x32 (little-endian) [world-daemon]
<Ctrl-C> to stop.

       _____     __  __       _   _  _____  ____   _____ 
      / ____|   |  \/  |     | \ | |/ ____|/ __ \ / ____|
     | |        | \  / |     |  \| | |  __  |  | | (___  
     | |ontinued| |\/| | __ _| . ` | | |_ | |  | |\___ \ 
     | |____    | |  | |/ _` | |\  | |__| | |__| |____) |
      \_____|   |_|  |_| (_| |_| \_|\_____|\____/ \____/ 
      http://cmangos.net\__,_|     Doing things right!

Using configuration file ../etc/mangosd.conf.
OpenSSL 1.0.2g  1 Mar 2016 (Library: OpenSSL 1.0.2g  1 Mar 2016)
Using Boost: 1_58
World Database total connections: 2
Connected to MySQL database mangos@127.0.0.1:3306/mangos
MySQL client library: 5.7.18
MySQL server ver: 5.7.18-0ubuntu0.16.04.1 
AUTOCOMMIT SUCCESSFULLY SET TO 1
Connected to MySQL database mangos@127.0.0.1:3306/mangos
MySQL client library: 5.7.18
MySQL server ver: 5.7.18-0ubuntu0.16.04.1 
AUTOCOMMIT SUCCESSFULLY SET TO 1
Character Database total connections: 2
Connected to MySQL database mangos@127.0.0.1:3306/characters
MySQL client library: 5.7.18
MySQL server ver: 5.7.18-0ubuntu0.16.04.1 
AUTOCOMMIT SUCCESSFULLY SET TO 1
Connected to MySQL database mangos@127.0.0.1:3306/characters
MySQL client library: 5.7.18
MySQL server ver: 5.7.18-0ubuntu0.16.04.1 
AUTOCOMMIT SUCCESSFULLY SET TO 1
Login Database total connections: 2
Connected to MySQL database mangos@127.0.0.1:3306/realmd
MySQL client library: 5.7.18
MySQL server ver: 5.7.18-0ubuntu0.16.04.1 
AUTOCOMMIT SUCCESSFULLY SET TO 1
Connected to MySQL database mangos@127.0.0.1:3306/realmd
MySQL client library: 5.7.18
MySQL server ver: 5.7.18-0ubuntu0.16.04.1 
AUTOCOMMIT SUCCESSFULLY SET TO 1

Realm running as realm ID 1

Using World DB: TBC-DB 1.5.0 'PRE-RELEASE BUILD' for CMaNGOS-TBC
Using creature EventAI: ACID 2.4.3 (The Burning Crusades) for CMaNGOS-TBC (2.4.3 Client)

Here's my mangosd.conf and realmd.conf.

Does anyone have any idea as to what could be going wrong here? Any pointers about places to look or potential debug methods would be greatly appreciated.

Thanks!

Dramacydal commented 7 years ago

try opening corresponding ports on your raspberry PI

jam1271 commented 7 years ago

As far as I can tell, the ports are bound to properly

ubuntu@ubuntu:~/wow/run$ netstat -tulpn | grep LISTEN
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      -               
tcp        0      0 0.0.0.0:3724            0.0.0.0:*               LISTEN      25180/realmd    
tcp        0      0 0.0.0.0:80              0.0.0.0:*               LISTEN      -               
tcp        0      0 0.0.0.0:8085            0.0.0.0:*               LISTEN      25195/mangosd   
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      -               
tcp6       0      0 :::80                   :::*                    LISTEN      -               
tcp6       0      0 :::22                   :::*                    LISTEN      -

And my firewall is set to allow access:

ubuntu@ubuntu:~/wow/run$ sudo ufw status
Status: active

To                         Action      From
--                         ------      ----
OpenSSH                    ALLOW       Anywhere                  
80                         ALLOW       Anywhere                  
8085                       ALLOW       Anywhere                  
3724                       ALLOW       Anywhere                  
OpenSSH (v6)               ALLOW       Anywhere (v6)             
80 (v6)                    ALLOW       Anywhere (v6)             
8085 (v6)                  ALLOW       Anywhere (v6)             
3724 (v6)                  ALLOW       Anywhere (v6)
Lillecarl commented 7 years ago

Can you upload a print of the error you're getting?

jam1271 commented 7 years ago

http://imgur.com/MdRANoj

jam1271 commented 7 years ago

upon enabling debug mode (by manually adding printf to the #define--is there any easier way to do this? lol) I'm seeing the following error:

[AuthChallenge] account JAKE tried to login with wrong password!

seems like there's something off with the hash function (I tried administrator:administrator as well)

Lillecarl commented 7 years ago

So if you'd reinstall the auth DB, and login with administrator administrator

You'd still get the same error? Honestly i don't understand much in the AuthSocket::_HandleLogonProof() function, but it'd be nice if one could print the hashes from db and from what the client sent, for debugging purposes.

cyberium commented 7 years ago

Raspberry is not supported by cmangos