Jump to content
TrinityCore

m_pan

Members
  • Posts

    82
  • Joined

  • Last visited

  • Days Won

    3

Everything posted by m_pan

  1. You might want to hop over to this thread as I believe it may address the problem that you are now seeing... Keep in mind that the experience I am posting from is in regards to the 3.3.5 branch so YMMV regarding the 6.x branch... or it might be exactly the same... I'm not sure.
  2. This step gave me issues too and I remember not being certain of what I was doing at the time so I didn't take notes on what finally worked for me. I need to boot my server up to be certain but here's the jist- (read the TL;DR at the bottom before you do anything.) Trinity runs on three databases- auth, character and world. auth handles credentials like account name, password, email and the like. characters handles character names, class, level, etc. and world contains the game world proper- NPCs, creatures, quests, game objects, armor, weapons, items and everything else you see once you're logged in and playing. For the most part the only ones that get modified by your actual install are the auth and characters DBs... world for the most part is static unless you get into custom stuff like adding NPCs or custom items. TDB_full_:blahblah::.sql only contains content for the world database. auth and characters gets populated as you add accounts and those accounts create characters. Before these databases can be populated with data the table structure needs to be defined and this is the step that I think you (and the install wiki) may be missing. I think the wiki is missing steps 1-5 below... I used the 3.3.5 branch so YMMV if using the 6.X branch... I think these are the steps I took that finally resulted in success... (As mysql root) - I used /source/sql/create/create_mysql.sql as a template but probably just copy\pasted commands directly into the mysql console. 1. Created a new user for Trinity. (You can run Trinity under the sql root account, but this is a bad security practice. A dedicated user should be created with only the permissions on just the 3 databases needed to function.) 2. Created the three databases: auth, characters, world. 3. Grant needed privileges on auth, characters and world to the new user (switch to trinity user) 4. import auth structure (/source/sql/base/auth_database.sql) 5. import characters structure (/source/sql/base/characters_database.sql) (really unsure past this point) I can't remember if I manually imported TDB_full or if I let the server startup do this automatically. I think I did it manually but the preceding steps should give you an idea of the workflow as it's really just repeating the same steps for each database. Now that I'm thinking about it again I think I may have done steps 1 - 3 manually by SSH through the mysql console then connected to the database using my SQL client (I use SQLyog Community, others recommend HeidiSQL) to import the structure queries in the /source/sql/base/ directory. If you create a dedicated trinity user don't forget to update the auth and worldserver configs with the new name and password. TL;DR- looking at all that I've written I'm sure that I could probably rewrite it to be more concise and to the point but it is what it is. Entirely possible that all you're missing is importing the /source/sql/create/create_mysql.sql query. As I said above I don't like running as root and I don't like running as the default 'trinity;trinity' that the create_mysql query sets it up as. Hell... probably get away with just creating your database user and editing the create query with the new user and password.
  3. I think the wiki skips over the part where you're supposed to import the sqls that setup the database structure. If you check your source directory there should be a directory that has import scripts for auth and characters. My server is shut down right now so I can't tell you the exact path but I think it might be \source\sql\base?
  4. re: repacks... it's not about you distributing anything it's more about supporting something that may have been mangled by whoever put the repack together that you are using. To be clear- to get anything beyond what limited help I can provide you'll need to be self-compiling from the source that is in the TrinityCore GitHub repository. re: the mySQL issues... uninstalling mySQL is not as easy as Control Panel > Add\Remove Programs > Uninstall mySQL. http://serverfault.com/questions/103127/how-to-completely-remove-mysql-from-windows ...I run my Trinity install on a linux server so won't be of much help on the windows side.
  5. You said a dirty word around these parts... repack. The devs here won't offer support or assistance if you are attempting to setup a repack and will tell you to ask on the forums where you found the repack if you are having trouble setting it up. Regardless of that... your problem has something to do with your SQL access rights... user, pass or remote access using 'root'. Accessing SQL via 'root' is typically advised against.
  6. Well... a few of the results when I did the google thing were from EmuDevs so your core not having RBAC could be a result of the same technique. At the very least you could check that out to see what would actually be involved.
  7. My bad... apparently I read the 'I'm missing RBAC' part without weighing it against what you were asking. I'm still getting myself back up to speed after being away from TC for a couple years so I'd wait to see if someone more knowledgeable about TC than I corrects what I'm about to say but I'm pretty sure that there isn't a way to add RBAC into the core because the changes are in-line and not module based so if you wanted your core to include RBAC the only way would be to compile a new core then add your customizations back into the new core. That said- if you Google "trinity remove rbac" you can find videos and forum posts then attempt to reverse those steps to reinsert it though I'd expect you to be on your own or have to resort to seeking help through other channels. Really expect your best course of action would be to compile a fresh core and reapply custom changes from there. As far as your .pinfo issue- I can't read what the thing you linked says because it sits on one line of text then briefly flashes another line before looping back through.
  8. http://collab.kpsn.org/display/tc/RBAC%3A+Role+based+Access+Control
  9. The link for 'Code Repository' on the trinitycore.info site is broken. clicking ends in a white page, right-click>new tab opens github as it's supposed to. Firefox 36.0.4, no fancy plugins
  10. The 'Top Contributors' box off to the right side of the forum main page is bugged when you switch it to 'month' view. Instead of being a vertical list they run laterally and on top of each other.
×
×
  • Create New...