Client cant login to the server

[apokzero]

Hi getmangos community :

i have a linux vps with the server running (mangosZero) and the client 1.12.1 on win pc.

open ports:

- 8085 udp and tcp

- 3724 udp and tcp

database realmd:

realmlist = id:1 , name:<the name>, address:<the vps ip>, realmflags:2, etc etc

mangosd.conf settings fine port 8085 to 0.0.0.0

realmd.conf settings fine same as mangosd with different port of course

client side: set realmd "<server>:<port>" al fine

the problem is when i try to login i just got disconnected from the server tried creating and modify users but still cant login, i dont wait a solution but what can i do? at least something to modify and get a clue of what way to follow.

ty...

[thanas]

I have the same problem...

I tried to check with nmap and ports are accessible, realmd and mangosd (i'm under linux) still working... And database is ok

I tried the client to another server and it work

Any suggestions? How can I find the problem?

Thanks

[lfxgroove]

What happens when you try to connect via WoW? Does it show you a realm list or does it not connect at all? Also, what ip's is the server listening to in the config?

[thanas]

Always appears: "The information you have entered is not valid. Please check the spelling..."

But username and password are correct, I have created different to try, but the result is always the same.

The server is listening on the IP of the LAN and not on localhost (192.168.0.111 and not 127.0.0.1 )

Thanks

[lfxgroove]

If you check the window where you've started realmd, does it output anything about someone connecting and having bad credentials? Try changing that back to 0.0.0.0 so that it listens to everything or changing it to your external IP since it's a VPS which you're probably never going to lan with

[thanas]

Sorry, i'm in lan, not in vps

apokzero have same problem, but in vps

[lfxgroove]

Oh, sorry, i got mixed up How did you add the users to you database?

Also, did you try to change the listen configuration option back to 0.0.0.0? And try logging in as player/player or administrator/administrator to begin with, does that work?

[thanas]

Yes, I tried both with administrator/administrator and player/player, but without success.

I added test users to the database using the command "account create user password password".

Yes, I have tried to reset the configuration to 0.0.0.0.

I do not know what to do anymore

EDIT: there is a log that shows if the client tries to connect really?

[lfxgroove]

In your realmd window there should be some info about someone connecting and whether it was right or wrong. You could also set a file for logging in your realmd.conf file so that you have the data handy. Could you up the log output to max and then post a log after trying to logon once?

[thanas]

I have increased the log level, but unfortunately it did not help. I do not see anything in the logs.

To test I tried to replace the default port with 6565 (chosen at random), but it did not do anything.

Here are my configuration files:

LoginDatabaseInfo = "my database login"
LogsDir = "/opt/ruolo/logs"
MaxPingTime = 30
RealmServerPort = 6565
BindIP = "0.0.0.0"
PidFile = ""
LogLevel = 3
LogTime = 1
LogFile = "Realmd.log"
LogTimestamp = 1
LogFileLevel = 3
LogColors = "13 7 11 9"
UseProcessors = 0
ProcessPriority = 1
WaitAtStartupError = 0
RealmsStateUpdateDelay = 20
WrongPass.MaxCount = 0
WrongPass.BanTime = 600
WrongPass.BanType = 0

and client realmlist.wtf

set realmlist 192.168.0.111:6565

nmap mostra il server (e tutte le porte) raggiungibile dal client.

And now Realmd.log

2013-07-03 07:32:14 MaNGOS Zero/ (* * Revision 2424 - *) for Linux_x64 (little-endian) [realm-daemon]
2013-07-03 07:32:14 <Ctrl-C> to stop.

2013-07-03 07:32:14 Using configuration file /opt/ruolo/etc/realmd.conf.
2013-07-03 07:32:14 OpenSSL 1.0.1e 11 Feb 2013 (Library: OpenSSL 1.0.1e 11 Feb 2013)
2013-07-03 07:32:14 Using ACE: 5.8.3
2013-07-03 07:32:14 Max allowed open files is 1024
2013-07-03 07:32:14 Login Database total connections: 2
2013-07-03 07:32:14 Connected to MySQL database [email protected]:3306/ruolo_realmd
2013-07-03 07:32:14 MySQL client library: 5.5.31
2013-07-03 07:32:14 MySQL server ver: 5.5.31-0+wheezy1 
2013-07-03 07:32:14 AUTOCOMMIT SUCCESSFULLY SET TO 1
2013-07-03 07:32:14 Connected to MySQL database [email protected]:3306/ruolo_realmd
2013-07-03 07:32:14 MySQL client library: 5.5.31
2013-07-03 07:32:14 MySQL server ver: 5.5.31-0+wheezy1 
2013-07-03 07:32:14 AUTOCOMMIT SUCCESSFULLY SET TO 1
2013-07-03 07:32:14 Updating Realm List...
2013-07-03 07:32:14 Added realm id 1, name 'TEST'
2013-07-03 07:32:44 Halting process...

If I have time later I try to re-download the source and recompile everything. I delete the database and redo. So I try again with a fresh installation ... I have no other ideas

Thanks for the help, I hope to find a solution, my friends and I have a strong desire to make us a lan party!

[lfxgroove]

From the logs it doesn't even seem anyone is connecting Did you try to connect once before halting?

[thanas]

From the logs it doesn't even seem anyone is connecting Did you try to connect once before halting?

Yes, I tried. In the last hour I tried several times, but the log does not say anything:

2013-07-03 07:34:20 MaNGOS Zero/ (* * Revision 2424 - *) for Linux_x64 (little-endian) [realm-daemon]

2013-07-03 07:34:20 <Ctrl-C> to stop.

2013-07-03 07:34:20 Using configuration file /opt/ruolo/etc/realmd.conf.

2013-07-03 07:34:20 OpenSSL 1.0.1e 11 Feb 2013 (Library: OpenSSL 1.0.1e 11 Feb 2013)

2013-07-03 07:34:20 Using ACE: 5.8.3

2013-07-03 07:34:20 Max allowed open files is 1024

2013-07-03 07:34:20 Login Database total connections: 2

2013-07-03 07:34:20 Connected to MySQL database [email protected]:3306/ruolo_realmd

2013-07-03 07:34:20 MySQL client library: 5.5.31

2013-07-03 07:34:20 MySQL server ver: 5.5.31-0+wheezy1

2013-07-03 07:34:20 AUTOCOMMIT SUCCESSFULLY SET TO 1

2013-07-03 07:34:20 Connected to MySQL database [email protected]:3306/ruolo_realmd

2013-07-03 07:34:20 MySQL client library: 5.5.31

2013-07-03 07:34:20 MySQL server ver: 5.5.31-0+wheezy1

2013-07-03 07:34:20 AUTOCOMMIT SUCCESSFULLY SET TO 1

2013-07-03 07:34:20 Updating Realm List...

2013-07-03 07:34:20 Added realm id 1, name 'TEST'

2013-07-03 08:04:24 Ping MySQL to keep connection alive

2013-07-03 08:34:28 Ping MySQL to keep connection alive

Now I try to redo the server from scratch...

[lfxgroove]

That's darn strange Yeah, please report back when you've tried that!

[thanas]

Do not worry, we will find the problem. I probably have the wrong configuration or build. Now try again to make the server from scratch on the same machine, and if this does not work, try it on another machine

At the end I make a report

[thanas]

With a fresh install on the same machine no change, I can just try with a different machine...

[lfxgroove]

Okay, thanks! Hope that it will start working! if you run into any problems during the build or so just send me a pm or ask here

Edit: that was quick did you create a fresh db aswell? And mangosd doesn't show any start errors that seem to matter ?

[thanas]

Hello guys,

I have now done the test on a fresh install (now ubuntu server instead of debian) and the result was the same: I can't connect.

I think the problem is in realmd, when I do a test of open ports (with realmd started), if it is set to the default (3724), I see nothing listening.

If, however, imposed a different port (eg 8084) from the client I see realmd listening. But I still can't connect. Obviously mangosd is initiated

The realmlist is configured correctly in both cases.

Any suggestions? Someone could make a similar test?

Thanks to all,

Thanas

EDIT: yes, the new machine and clean database.

[bels]

Do you really have the port set in your realmlist.wtf file? I've never had to do that before. Are you trying to run the server on non-standard ports? There was another guy on this forum that was having a very similar problem and he found it was he couldn't connect because he had the :portnumber on the realmlist line.

[Merlinium]

You stated you have mangosd.conf with bindip = 0.0.0.0

I run 2 separate servers a tbc and a cata, both machines are linux ubuntu 12.04, client machines are windows xp and windows 7 machines. I can connect to both without any issues, originally I had some connection issues but that was .conf settings and mysql db settings.

I just checked mine to see what the setup was:

Mangosd.conf:

since I have mysql on the same machine, the db IP is 127.0.0.1

bindip = IP Address of Machine (ie 192.168.1.51)

realmd.conf:

BindIP = IP Address of Machine (ie 192.168.1.51)

mysql realmd database:

realmlist:

address: IP Address of Machine (ie 192.168.1.51)

And finally realmlist.wtf:

set realmlist IP Address of Machine (ie 192.168.1.51)

set patchlist localhost

Of course I am using standard ports so the 8085 and 3724 are default options during configuration, just need to change all 3 if using non standard ports, realmlist.wtf (just tested with a changed port, it needs to be added to realmlist.wtf, the mysql db realmd needs the game server port 8085 or whatever you are using in mangosd.conf

The realmd.conf needs the port number you are using and must match the clients realmlist.wtf to connect (except for default 3724, which the client automatically chooses)

[antz]

what have you set the ip address to in your realm database ?

Firewall blocking requests ?

[madmax]

Marking topic as solved. If you need further help please reply. Topic will become auto-locked within a month.