Jump to content
TrinityCore

krazor94

Members
  • Posts

    16
  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

krazor94's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. yeh sorry about that PC crashed while i was at work today. the website loads perfectly fine which in tern shows if the servers are up or down, as in the server status page. so servers are definitely up. it just gets stuck at loading realm/server and flicks bac kto the realm selection list, however i do not remember if this is correct or not. the last thing that Auth server shows is added Realm "Trinity" at <IP Address> which is my correct External IP. world server finishes with ready... as normal. so im unsure what indications to look for when this was working perfectly fine a couple of days ago. i do believe between then i tried to change something because port 3306 was always in use and still is, so i use netstat -abo to find the PID that is running it generally 0.0.0.0 so i use taskkill /pid <PID> /f to terminate the process hogging port 3306 on my PC and allows me to run the database as normal. however i think i may have changed something but i am not sure i think it was ISS and changed one of the system files to 4 as instructed in a tutorial to stop system from loading up and using port 3306. i will try and figure out how i did it and try to revers what i did their.
  2. Dynamic ip so I use no-ip as a dns solution, your welcome to try. wowwotlk.ddns.net This is also the same for the registration site. That is also set in the database under realm. And the ip is forwarded to my static local ip. Thing is everything worked perfectly all week. Just last night stopped working.
  3. Hi, I have issue now I didn't have before. I can log into the game on my network but people outaide my network can no longer get past success and wont load realm. This worked fine all week now randomly started happening. Running on windows and I am able to connect from my laptop to my pc perfectly fine.
  4. indeed, got the server up and running the other day and it works perfectly in 3.3.5, havent fully tested but at least the quest and pets work for locks and hunters, mages slightly tested, hows the BG's and Raids? but now for my ultimate goal to get the 2.4.3 repo to work. this has been a challenge since i started on these repos about a week or so ago. they are definitely a hell of a lot of work to get set up. if anyone has experience with Linux and setting up the 2.4.3 would love some tips to get started, was unsuccessful with all Windows versions, so going linux now as they are cheaper servers to run, but defiantly worth the experience setting something like this up on windows .
  5. alright everything works now and i got it online, thanks heaps for the help! i will do my best to contribute back to the community with my newly learned knowledge =) will make a new post regarding the issues i had here for others to look up so they can get it fixed quickly esp the SQL stuff and installation issues, currently working on account creation through my website which i will also post up so others know what tables to edit when making their website also.​
  6. ok i found the fixes i required and will post a link to a new thread i will make which should help anyone getting the same errors as i am. instead of the cat * sql for windows copy /b *.sql all_files.sql this will make a new SQL file within the folder called all_files.sql and you only need to import 1 file to thedatabase, for the paths issue i opened CMD and put in set path=%PATH%;D:\Xamp\mysql\bin; NOTE: D:\Xamp\mysql\bin <- is the directory of which youmysql\bin folder is located, i am using xampp and i used that folder and all works well. for the updates i use it somewhat similar to phpmyadmin but i do use navicat and have not had an isue with it yet, but as advices i do have heidiSQL installed also. now the only issue is im having is logging in. i see the password is SHA1 i have ran into issues with this before using the old hashing system which php uses, so i do know that is incorrect, how would we create the password for a new user in the accounts table as this is slightly different to Arc Emu as they just have a straight string for this. ok so i got past the logging in issue byadding a email and reg_email to the account i was trying to log in with and used the email as the username and hashed the password and it let me log in fine, but now my client is trying to patch itself to a new version how can we stop this from happening?
  7. ​getting this error after diving into the Updates/World Folder in SQL/updates in my source folder of trinity this is my structure and i ran the command from here D:\Trinity\TrinityCore\sql\updates\world type *.sql | mysql -utrinitycore -ptrinitycore world is not recognized as an internal or external command, operable or batch file. ERROR i am getting: D:\Trinity\TrinityCore\sql\updates\world>type *.sql | mysql -utrinitycore -ptrin itycore world 'mysql' is not recognized as an internal or external command, operable program or batch file. ​ok so i took a dive into the issue and it seems it does not recognise mySQL installation, however i also use Xamp to host the website i believe this is in conflict. but when i followed this video of hwo to fix it my paths are not the same either. my PATH links to a JDk1.8.0_25/bin but it should link to MySQL of some sort, i dont see what could have gone wrong with this. ​ link to vid i was talking about​ https://www.youtube.com/watch?v=jYT6W9v8e94
  8. ​getting this error after diving into the Updates/World Folder in SQL/updates in my source folder of trinity this is my structure and i ran the command from here D:\Trinity\TrinityCore\sql\updates\world type *.sql | mysql -utrinitycore -ptrinitycore world is not recognized as an internal or external command, operable or batch file. ERROR i am getting: D:\Trinity\TrinityCore\sql\updates\world>type *.sql | mysql -utrinitycore -ptrin itycore world 'mysql' is not recognized as an internal or external command, operable program or batch file.
  9. No worries, if not ill apply all the patches manually from the updates folder ill let you know how it goes.
  10. alrighty the Vmaps worked perfectly but im now getting the DB error where it is not up to date, which is where i am unable to follow the next command mysql -utrinitycore -ptrinitycore world < TDB_full_world_335.59_2015_07_14.sql i ran it through CMD where i was in my WoW Folder as you stated with CMD could you please specify how i would update the DB, this doesnt seem to work. i had also tried running it directly from MySQL Command prompt was unable to navigate to my WoW directory with that.
  11. ​this here seemed to work i had tested the first command and it works nicely however i still need to test the rest of it, so redoing all the folders from scrap and will see how it goes. and quick question how do you find linux because i was thinking of converting my desktop to linux to run the server on as its much faster than windows.
  12. ok i just ran DoxramosPS first command and the Vmaps seem to be creating... ill re run everythign as this seems to be the only issue im now getting and the servers are running perfectly fine apart from the world server giving me the maps and maps issue. ill report back, perhaps this should be put in the wiki because it mentions nothing about running the command this way in terms of running the assembler and what not.
  13. ok thanks ill look into swapping over. However I'm still getting the vmaps issue. I have heard of a simple extractor floating around in some repacks that fix the issue. However the repacks I have tested the map extractor works perfectly but all the ones I compile only generate a maps folder dbd folder and buildings folder. I have tried creating a vmaps folder as sugested here already but it does nothing. And I rum the extractors through cmd. Windows 8.1 x64 bit Also I am not aure if thia is. Rought up or I'm looking in the wrong spot. Ut I origionally tried to get bc up and running only arc emu repack worked for that and no soirce ill attempt it again at a later date but ill tackle worlk atm as its the only xpac I have gotten the furthest with in actually compiling it. But the database I can't seem to find one for 3.3.5 or 2.4.3 are they hoated elsewhere, because I remember looking at the mangos community and downloaded the source for mangostwo and three bc and wotll. Ut had similar issues. but there was no up to date wiki to set anything up. I appreciate the efforts you guys put into these projects. Not alot of people appreciate. It and all theu see is. Bugs. but alot goes into a project like this, as well as keeping socumentation up to date. Would just like to say thank you.
  14. ahh ok i will do this from scrap and attempt it again thanks for the advice, and why do you say not to use navicat, which is what i am currently using.
  15. define run the client, as in log into a game ? and i installed the client with my disk's and manually patched to 3.3.5a, also seem to be having major complications with the Database for some reason. when i followed the link it was broken to the download section but when you add .7z at the end of the file yo u can extract it and get a folder and the DB file, but it freezes up when i load it into the World and all the tables for other databases are empty?
×
×
  • Create New...