Need help for invite friend on my server

[Leonis]

Hello everyone. First i am sorry for my language, i am french i have some troubles for writing and understanding english.

I have create a server Wow 3.3.5 with TrinityCore tutorial on my PC and i want to invite friend, by changing IP on authserver.conf and worldserver.conf and start authserver.exe, but it deosn't work.
I try to open the ports on my routeur and add them into Firewall but it doesn't change.
I don't know but maybe i need to change the Ip of MySQL server from 127.0.0.1 to my IP but it is not possible.
My objective is not to put my server on a dedicated external machine, just to keep it on my PC and invite friend on it. That's all.

It is impossible to me to continue without help......


Edit : I succeded conecting to database by recreate it and asking a Full Stack IP. Now i tried to re-create database and my worldserver.conf is :

LoginDatabaseInfo     = "xxx.xxx.xxx.xxx:3306;root;Leonis2020;auth"
WorldDatabaseInfo     = "xxx.xxx.xxx.xxx:3306;root;Leonis2020;world"
CharacterDatabaseInfo = "xxx.xxx.xxx.xxx:3306;root;Leonis2020;characters"

And Authserver.conf is : 

LoginDatabaseInfo = "xxx.xxx.xxx.xxx:3306;root;Leonis2020;auth"

(don't worry for password i have put a not secret ont and i will change).

So with that my Server.Log is :

 

Using configuration file C:/Build/bin/RelWithDebInfo/worldserver.conf.

Using SSL version: OpenSSL 1.1.1d  10 Sep 2019 (library: OpenSSL 1.1.1d  10 Sep 2019)
Using Boost version: 1.66.0
Database Auth is empty, auto populating it...
>> Applying 'C:/Trinity/sql/base/auth_database.sql'...
Warning: option 'port': value --default-character-set=utf8 adjusted to 0
ERROR 2005 (HY000): Unknown MySQL server host '-u' (0)

Applying of file 'C:/Trinity/sql/base/auth_database.sql' to database '' failed! If you are a user, please pull the latest revision from the repository. Also make sure you have not applied any of the databases with your sql client. You cannot use auto-update system and import sql files from TrinityCore repository with your sql client. If you are a developer, please fix your sql query.
Could not populate the Login database, see log for details.

 

And Auth.Log : 
 

 

http://TrinityCore.org         

Using configuration file C:/Build/bin/RelWithDebInfo/authserver.conf.
Using SSL version: OpenSSL 1.1.1d  10 Sep 2019 (library: OpenSSL 1.1.1d  10 Sep 2019)
Using Boost version: 1.66.0
Automatic database updates are disabled for all databases!
Opening DatabasePool ''. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.6.47
MySQL server ver: 5.6.47-log 
Connected to MySQL database at 
MySQL client library: 5.6.47
MySQL server ver: 5.6.47-log 
Connected to MySQL database at 
DatabasePool '' opened successfully. 2 total connections running.
In mysql_stmt_prepare() id: 1, sql: "DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
No database selected
In mysql_stmt_prepare() id: 2, sql: "UPDATE account_banned SET active = 0 WHERE active = 1 AND unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
No database selected
In mysql_stmt_prepare() id: 3, sql: "SELECT unbandate > UNIX_TIMESTAMP() OR unbandate = bandate AS banned, NULL as country FROM ip_banned WHERE ip = ?"
No database selected
In mysql_stmt_prepare() id: 4, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
No database selected
In mysql_stmt_prepare() id: 8, sql: "INSERT INTO account_banned (id, bandate, unbandate, bannedby, banreason, active) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban', 1)"
No database selected
In mysql_stmt_prepare() id: 9, sql: "DELETE FROM account_banned WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 10, sql: "UPDATE account SET v = ?, s = ? WHERE username = ?"
No database selected
In mysql_stmt_prepare() id: 12, sql: "SELECT a.id, a.username, a.locked, a.lock_country, a.last_ip, a.failed_logins, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, ab.unbandate = ab.bandate, aa.gmlevel, a.totp_secret, a.sha_pass_hash, a.v, a.s FROM account a LEFT JOIN account_access aa ON a.id = aa.id LEFT JOIN account_banned ab ON ab.id = a.id AND ab.active = 1 WHERE a.username = ?"
No database selected
In mysql_stmt_prepare() id: 13, sql: "SELECT a.id, UPPER(a.username), a.locked, a.lock_country, a.last_ip, a.failed_logins, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, ab.unbandate = ab.bandate, aa.gmlevel, a.sessionKey FROM account a LEFT JOIN account_access aa ON a.id = aa.id LEFT JOIN account_banned ab ON ab.id = a.id AND ab.active = 1 WHERE a.username = ?"
No database selected
In mysql_stmt_prepare() id: 14, sql: "UPDATE account SET failed_logins = failed_logins + 1 WHERE username = ?"
No database selected
In mysql_stmt_prepare() id: 17, sql: "SELECT a.id, a.sessionkey, a.last_ip, a.locked, a.lock_country, a.expansion, a.mutetime, a.locale, a.recruiter, a.os, aa.gmLevel, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, r.id FROM account a LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID IN (-1, ?) LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account r ON a.id = r.recruiter WHERE a.username = ? ORDER BY aa.RealmID DESC LIMIT 1"
No database selected
In mysql_stmt_prepare() id: 19, sql: "SELECT realmid, numchars FROM realmcharacters WHERE  acctid = ?"
No database selected
In mysql_stmt_prepare() id: 21, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?)"
No database selected
In mysql_stmt_prepare() id: 22, sql: "DELETE FROM ip_banned WHERE ip = ?"
No database selected
In mysql_stmt_prepare() id: 26, sql: "INSERT INTO account_banned (id, bandate, unbandate, bannedby, banreason, active) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
No database selected
In mysql_stmt_prepare() id: 27, sql: "UPDATE account_banned SET active = 0 WHERE id = ? AND active != 0"
No database selected
In mysql_stmt_prepare() id: 28, sql: "DELETE FROM realmcharacters WHERE acctid = ? AND realmid = ?"
No database selected
In mysql_stmt_prepare() id: 29, sql: "DELETE FROM realmcharacters WHERE acctid = ?"
No database selected
In mysql_stmt_prepare() id: 30, sql: "INSERT INTO realmcharacters (numchars, acctid, realmid) VALUES (?, ?, ?)"
No database selected
In mysql_stmt_prepare() id: 31, sql: "SELECT SUM(numchars) FROM realmcharacters WHERE acctid = ?"
No database selected
In mysql_stmt_prepare() id: 33, sql: "INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist, account LEFT JOIN realmcharacters ON acctid = account.id WHERE acctid IS NULL"
No database selected
In mysql_stmt_prepare() id: 34, sql: "UPDATE account SET expansion = ? WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 35, sql: "UPDATE account SET locked = ? WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 36, sql: "UPDATE account SET lock_country = ? WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 37, sql: "INSERT INTO logs (time, realm, type, level, string) VALUES (?, ?, ?, ?, ?)"
No database selected
In mysql_stmt_prepare() id: 38, sql: "UPDATE account SET v = 0, s = 0, username = ?, sha_pass_hash = ? WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 39, sql: "UPDATE account SET v = 0, s = 0, sha_pass_hash = ? WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 40, sql: "UPDATE account SET email = ? WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 41, sql: "UPDATE account SET reg_mail = ? WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 42, sql: "UPDATE account SET mutetime = ? , mutereason = ? , muteby = ? WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 43, sql: "UPDATE account SET mutetime = ? WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 44, sql: "UPDATE account SET last_ip = ? WHERE username = ?"
No database selected
In mysql_stmt_prepare() id: 45, sql: "UPDATE account SET last_attempt_ip = ? WHERE username = ?"
No database selected
In mysql_stmt_prepare() id: 46, sql: "UPDATE account SET online = 1 WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 47, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
No database selected
In mysql_stmt_prepare() id: 48, sql: "DELETE FROM logs WHERE (time + ?) < ? AND realm = ?"
No database selected
In mysql_stmt_prepare() id: 49, sql: "DELETE FROM account_access WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 50, sql: "DELETE FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)"
No database selected
In mysql_stmt_prepare() id: 51, sql: "INSERT INTO account_access (id,gmlevel,RealmID) VALUES (?, ?, ?)"
No database selected
In mysql_stmt_prepare() id: 66, sql: "DELETE FROM account WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 71, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
No database selected
In mysql_stmt_prepare() id: 72, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_attempt_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
No database selected
In mysql_stmt_prepare() id: 73, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, ?, ?, unix_timestamp(NOW()), NOW())"
No database selected
In mysql_stmt_prepare() id: 74, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, 0, 1, ?, ?, unix_timestamp(NOW()), NOW())"
No database selected
In mysql_stmt_prepare() id: 76, sql: "SELECT permissionId, granted FROM rbac_account_permissions WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY permissionId, realmId"
No database selected
In mysql_stmt_prepare() id: 77, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
No database selected
In mysql_stmt_prepare() id: 78, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
No database selected
In mysql_stmt_prepare() id: 79, sql: "INSERT INTO account_muted VALUES (?, UNIX_TIMESTAMP(), ?, ?, ?)"
No database selected
In mysql_stmt_prepare() id: 81, sql: "DELETE FROM account_muted WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 83, sql: "INSERT INTO secret_digest (id, digest) VALUES (?,?)"
No database selected
In mysql_stmt_prepare() id: 84, sql: "DELETE FROM secret_digest WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 86, sql: "UPDATE account SET totp_secret = ? WHERE id = ?"
No database selected
Closing down DatabasePool ''.
Asynchronous connections on DatabasePool '' terminated. Proceeding with synchronous connections.
All connections on DatabasePool '' closed.
Could not prepare statements of the Login database, see log for details.
Closing down DatabasePool ''.
Asynchronous connections on DatabasePool '' terminated. Proceeding with synchronous connections.
All connections on DatabasePool '' closed.

If someone as a awnser i ask you for it.

Thx for advance
Leonis.

En Français : Bonjour à tous. J'essaie de faire un serveur WoW sur mon PC. J'ai réussi mais maintenant j'aimerais inviter des amis dessus. Dans le Tutorial de Trinity j'ai vu qu'il fallait changer l'IP dans les fichiers authserver.conf et worldserver.conf, mais impossible de démarrer le serveur (voir lignes de commandes). Idem en ouvrant les ports. Et impossible de changer l'IP du serveur de MySQL, il ne marche qu'avec 127.0.0.1. Je me retrouve bloquer. Si quelqu'un a la solution à mon problème je cherche de l'aide. Pour l'instant mon but est juste d'héberger le serveur sur mon PC et d'inviter des amis. Il n'est pas question de louer un serveur dédié.
Merci d'avance
Leonis

Edited March 24, 2020 by Leonis

[Aokromes]

NEVER put your public ip as database connection, NEVER allow mysql to reach from outside your local network.

[Leonis]

Ok so Navicat Ip and MySQL as to be 127.0.0.1, so do you know where is the problem ?
I change Ip on authserver.conf and worldserver.conf and open ports on firewall and routeur.
But it does not work.
Actually i only can run authserver.exe and worldserver.exe ONLY with 127.0.0.1 as Ip, it not works with my public IP.

Even with no change of database connection IP and MySQL Ip.

I tried tu put Ip and Port with the symbol "two points" (xxx.xxx.xxx.xxx:3306) instead of "xxx.xxx.xxx.xxx;3306". authserver.exe detect database but cannot connect...

Can you explain me where is my problem please ?

Edited March 24, 2020 by Leonis