Jump to content
TrinityCore

Magnuss

Members
  • Posts

    318
  • Joined

  • Last visited

  • Days Won

    16

Magnuss last won the day on March 5 2019

Magnuss had the most liked content!

Profile Information

  • Gender
    Male
  • Location
    : Switzerland

Recent Profile Visitors

4518 profile views

Magnuss's Achievements

Newbie

Newbie (1/14)

27

Reputation

  1. Hi everybody, I'm wondering if the WotLK client is IPv6 capable. It's difficult to test because the Trinity isn't supporting IPv6. However I have good reasons to believe that the client may has IPv6 capabilities. - On the login screen is a frame where Blizzard News appears. This frame is definitely IPv6 capable. We modified the client to use a custom web-address. And I can see in my Apache log IPv6 requests from 'Blizzard Web Client'. It works even with https on Port 443. - Entering in the realmlist a IPv6 only domainname and starting the client has success. In the WoW log is only a message LOGIN_STATE_FAILED result: LOGIN_SERVER_DOWN. But this is logical. - Blizzard was at the building time of the 3.3.5 client clever enough to use a lot of Microsoft API calls. That's the reason why the client is even running these days without problems. May they have used a MS network framework that supports IPv4 and IPv6? What do you think?
  2. You didn't told that you want to going public in your post. In that case you have to open in router1 both ports and forward these ports to your gameserver (192.168.1.130). You should have a static WAN-IP. In your WoW realmlist set the server: Your WAN-IP or your domainname In your Auth database in table realmlist you have to enter in the field address your server ip: Your WAN-IP or your domainname But in general if you have problems with networking you should make at the first time your configuration as simple as possible, f.ex. a) Is everything working well just using local PC on 127.0.0.1? (server, client, database) b) Is everything working in 1 LAN? c) Working well with WAN and LAN? d) Working well with WAN, LAN1 and LAN2?
  3. Read for what a DNS (Domain Name Server) and host files are used. Than you understand why you don't need them as long your are connecting from IP to IP. IP binding to 0.0.0.0 in conf files (both auth and world) means the servers are listening on all IPs and that's fine for you. As I understand you have 2 LANs: WAN | WAN-IP to Router (192.168.1.1/255.255.255.0) | | ---- Gameserver (192.168.1.130/255.255.255.0) | LAN1-IP to Router (192.168.2.1/255.255.255.0) | | ---- PC (192.168.2.?/255.255.255.0) In this configuration you don't need port forwarding but you have to open in the firewall of the gameserver 2 ports 8085 and 3724 (or better switch off the firewall for testing) In your WoW realmlist set the server IP: 192.168.1.130 In your Auth database in table realmlist you have to enter in the field address your server ip: 192.168.1.130 That's all, I think.
  4. Well, never thought people really following the wiki exactly xD. For security reason you may will change later the default password for user trinity or never ever give other host rights than localhost. If you would give host right like % it's likely you will get hacked early or later. Atm, I don't know what the problem could be. You have a user trinity, that's good. The user trinity has permission to the 3 databases, that's also good. And as I understand you right you installed the mysql server and the trinity server on the same machine, so both are localhost. Last thing you may can try is to connect from Ubuntu terminal as user trinity: mysql -u trinity -p Enter password trinity and check if you can access.
  5. Now you have maybe more than you need ;-) If your databases are named auth, characters and world you can revoke rights to trinity_auth and so on. These was only example names to group trinity databases together. REVOKE ALL PRIVILEGES, GRANT OPTION ON trinity_auth.* FROM 'trinity'@'localhost'; REVOKE ALL PRIVILEGES, GRANT OPTION ON trinity_characters.* FROM 'trinity'@'localhost'; REVOKE ALL PRIVILEGES, GRANT OPTION ON trinity_world.* FROM 'trinity'@'localhost'; It seems you have a problem with your password or similar in your config file. Check this in your config file: 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" You have to replace the password with your own password for user trinity.
  6. What's now the output of SELECT Host, User from mysql.user and SELECT Host, Db, User FROM mysql.db
  7. The mySQL server is an independent piece of software. It even could run on a complete different hardware. And it has it's own user management separated from your OS Ubuntu. The idea is to add different new users to the mysql server with fine graduated rights. A mysql user can have access to everything, or just only to specific databases, or only to a table. If you have a webserver, you add a user just only for the webser. If you have a mail server, you add a mailserver user. If you have a trinity server, you add a trinity user. For security reasons root f.ex. never should have set host=%. Better add a new user like adminfity and give admin rights and set host to %. Additionally add a user trinity and give only rights to auth, character and world database. Example for such a 'superuser': CREATE USER 'adminfity'@'%' IDENTIFIED BY 'somepassword'; GRANT ALL ON *.* TO 'adminfity'@'%' WITH GRANT OPTION; Example for trinity user: CREATE USER 'trinity'@'localhost' IDENTIFIED BY 'anotherpassword'; GRANT ALL ON trinity_auth.* TO 'trinity'@'localhost'; GRANT ALL ON trinity_characters.* TO 'trinity'@'localhost'; GRANT ALL ON trinity_world.* TO 'trinity'@'localhost'; As you see I give the trinity user only access on localhost. You would remote access with your adminfity user. Be aware: Examples are out of my brain. And my brain is not allways correct ^^ Edit: Reading the Trinity wiki very exactly helps better: Creating the Trinity databases in MySQL For 3.3.x: https://github.com/TrinityCore/TrinityCore/blob/3.3.5/sql/create/create_mysql.sql For master: https://github.com/TrinityCore/TrinityCore/blob/master/sql/create/create_mysql.sql
  8. As you see, there is no user trinity ;-) Edit: Here's how to add users: https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
  9. SELECT Host, User from mysql.user - It seems you don't have added a user trinity (following the posting in the other forum). Therefore you can't access to mysql with this username, even you have a local account on Ubuntu with the same name. And of course you can give every rights to an existing mysql user, but you shouldn't. You shout give only rights really needed. - There are good reasons to NOT allow external access for mysql user root ;-) - And as you was told it seem a problem with password.
  10. There is absolutely nothing wrong with mySQL. Have you switched off Ubuntu firewall? Often the user root is not planned to have remote access and has rights only on localhost. You can try to add another user and give them proper rights. Both (mysql server and user) must have the right to access from external (means setting the host ip to 0.0.0.0. or to your local network) If you have a GUI on your Ubuntu you also can install MySQL Workbench server which is similar to HeidiSql to manage the SQL server.
  11. Just some ideas: Spawn/despawn Change phase mask Change the the type_flags and make him a ghost.
  12. Be aware this may can be confusing for other players if a creature isn't available. And looking to the smartscript wiki page https://trinitycore.atlassian.net/wiki/spaces/tc/pages/2130108/smart+scripts the event On Target Quest Accepted isn't implemented yet.
  13. Today I wanted to edit a wiki page with some small changes. But after saving the page it was fucked up. All internal links was replaced and a lot other stupid changes was made: https://trinitycore.atlassian.net/wiki/pages/diffpagesbyversion.action?pageId=2130261&selectedPageVersions=118&selectedPageVersions=117 I had to revert it to version 117. However I checked it with other pages -> same issue. I even don't need to do any single change. I can just click on page edit, than immediately on page preview and have tons of changes I never made. I hate Atlassian products!
  14. Question 1: The field RequestItemsText in the table quest_template is old and doesn't exist anymore. Replaced by: Table quest_request_items, Field CompletionText
×
×
  • Create New...