Jump to content
TrinityCore

CDawg

Members
  • Posts

    1477
  • Joined

  • Last visited

  • Days Won

    85

Posts posted by CDawg

  1. ... Completely new, from github.com/trinitycore

    That doesn't help amigo... We are asking for a revision.. but anyways, Nay provided the link that should help you "update your DB".

    Too many people ask for help and don't provide what revision they are using, come to find out it isn't even the correct version (even with links provided does not help us, help you!)

  2. Sometimes the client times out when importing large DBs. That goes for all clients (if the file is really large). I always import the sql files manually through the terminal/command prompt.

    1. Login into mysql: mysql -u <username> -p <password>

    2. Import the database manually.

     

    Example: If you need to import to the characters database

    At the mysql prompt type

    use characters; source <path_to_your_file>\largefile.sql;
      Import to world
    use world; source <path_to_your_file>\largefile.sql;

    • Upvote 1
  3. Yes put the name of the dns in the address='putyourdnsnamehere'. Be sure to copy the above where it's wrapped in code tags, just in case there's a back-tick missing.

    My guess is that you didn't have the dns name in the DB originally, which is where people find themselves in the connection loop.

     

    worldserver.conf = localhost (127.0.0.1) [if your DB is on the same machine]

    router configuration = 10.10.10.10 => [8085] (whatever your local network is set to. in my case it would be like 192.168.x.x) <= whatever your router resolves locally!

    router configuration = 10.10.10.10 => [3724] (whatever your local network is set to. in my case it would be like 192.168.x.x) <= whatever your router resolves locally!

    DB auth.realmlist = DNSName (external) (The query example i gave should help you modify your DB realmlist to get your friends to connect)

     

    [On outside connections]

    Tell them to point to your DNSName in the realmlist.wtf, It also helps to change your .wtf file as well.  Think as if your outside trying to get in...

    The application is exposed talking outside.

     

    Thats it!

    • Upvote 1
  4. UPDATE `realmlist` SET `address`='<putyourdnsnamehere>' WHERE `id`=1;
      Ugh.. I hate windows. Open a command prompt in windows and type "ping <yourdnsname>". If it results back an IP.address then your good on resolving the dns. Then type "ipconfig" (to get your internal IP address) Use your internal address in your router to forward the ports 8085 and 3724. Example:
    10.11.12.13 => 8085 10.11.12.13 => 3724

  5. @MrSmite, maybe update the guide with, "make a copy of your wow 3.3.5a client first...

    That way when someone doesn't read your guide all the way through (won't mention names) they will have a backup.

    lolz.

    BTW, Good guide :)

    Also, I made a copy of my current client (3.3.5) and renamed it (bcuz I still love my Wrath), so that way when I update to 4.x I have a 3.3.5 client as well. ;) Once the installation is done, renaming the client directory will 'un-link' the registry in Windows. (If the install was from scratch)

  6. Your DB has the loopback (127.0.0.1), It's fine for local, but won't get your friends connected... first, you need to check your firewall.. If you are using Windows it should have prompted you to allow traffic on 8080, and 3724 as usual. Removing, Reinstalling or configuring CMake and VisualStudio(C++) has nothing to do with connecting, those our the tools to compile the source.

    There is something blocking you on your router and/or LAN or something wrong with the DB.

    If you plan on having friends connect, then you need to setup your forwarding address, But I think you should iron out getting connected locally, before getting your friends to connect.

  7. Read this first. http://www.trinitycore.org/f/topic/345-howto-properly-install-git-on-windows-fix-trinitycore-rev-0000-00-00/

    Does a server list even populate on your screen? If it doesn't, then you don't have the TDB setup correctly.

    Tips for people using 'root'. Create a user in your TDB that doesn't have full access to 'mysql'.'user'. I've just seen too many terrible things happen.

  8. Sounds like you checked the box in cmake, but didn't re-run the "configure" twice, then click "generate", then..... recompile with the tool you are using (Visual Studio). THat would be the only reason why the tools are not compiled, and like Zaranthos stated if you could find the worldserver and authserver binaries that is also where the tools will be dumped.

  9. 
    Check for working C compiler using: Visual Studio 10 -- broken
    
    CMake Error at C:/Program Files/Programme Server/CMake 2.8/share/cmake-2.8/Modules/CMakeTestCCompiler.cmake:52 (MESSAGE):
    
      The C compiler "cl" is not able to compile a simple test program.
    
       Change Dir: C:/Users/Tobi/Desktop/Build/CMakeFiles/CMakeTmp
    
      Run Build Command:C:\Windows\Microsoft.NET\Framework\v4.0.30319\MSBuild.exe
    
      cmTryCompileExec1631159175.vcxproj /p:Configuration=Debug
    
    

    Try reinstalling Visual Studio plus the dependencies, then try selecting Visual Studio 9 when compiling.

  10. Before I go hacking up my character DB I need some answers.

    1) Why doesn't SQLDriver.log work? No log is ever created. Maybe the server crashes before it does any logging, I don't know, but with the old logging system I'd get that log and it was helpful.

    2) In my Cmake options should I be enabling core debug option if I want to build with full debugging for better crash reporting or is that not needed and I just need to build in debug mode from Visual Studio 2010?

    1. I agree, I like the old logging system.

    2. Yes, you want to enable core debug option.

    BTW the above method was just to see if you would get past the character_equipmentset table, you can easily change it back.

    I was just trying to help with a unique problem that your are having,.

×
×
  • Create New...