davidflynn2
Members-
Posts
41 -
Joined
-
Last visited
-
Days Won
1
Everything posted by davidflynn2
-
Ok so I trashed the auth and used the file in the create folder to create a new auth then went into the base and applied the files for auth from there. I am now getting this error still but it does allow me to create an account and make it a gm. If any one could plz help me get rid of this error I would appresheat it very much. Table `command` have not existed command '.rbac', skip. Table `command` have not existed command '.rbac', skip. Table `command` have not existed command '.rbac', skip. Table `command` have not existed command '.rbac', skip. Table `command` have not existed command '.rbac', skip. Table `command` have unexpected subcommand 'groups' in command 'rbac list groups', skip. Table `command` have unexpected subcommand 'roles' in command 'rbac list roles', skip. Table `command` have unexpected subcommand 'permissions' in command 'rbac list permissions', skip.
-
When I try to do this Final Steps You can type commands inside the worldserver program, similar to a command prompt. Type: account create <user> <pass> Example: account create test test Type: account set gmlevel <user> 3 -1 Example: account set gmlevel test 3 -1 DO !NEVER! create an account directly into your database unless you are ABSOLUTELY SURE that you know what and how to do! The "3" is the GM account level (higher numbers = more access), and the "-1" is the realm ID that stands for "all realms". Tip: Open the world database in your database management tool and find the command table. This table shows a full list of GM commands, their descriptions, and the security (GM level) needed to use them. You will not find a more accurate list of current GM commands anywhere else (assuming you keep your database up-to-date). The security level for a given command identifies that THAT GM level can use the command, along with all GM levels above it. For example, if a command has a security of 2, all accounts with a GM level of 2, 3, and 4 will be able to use it. Minimize your authserver and worldserver and run WoW (never run WoW using the Launcher unless you edited the realmlist.wtf's patchlist option above). Log in using the user/pass you just created (test/test). The Trinity realm should be selectable. Log in, create a character, and you're all done! I get this error. Table `command` have not existed command '.rbac', skip. Table `command` have not existed command '.rbac', skip. Table `command` have not existed command '.rbac', skip. Table `command` have not existed command '.rbac', skip. Table `command` have not existed command '.rbac', skip. Table `command` have unexpected subcommand 'groups' in command 'rbac list groups', skip. Table `command` have unexpected subcommand 'roles' in command 'rbac list roles', skip. Table `command` have unexpected subcommand 'permissions' in command 'rbac list permissions', skip.
-
I just did a complete new build of the core with the GET system and now I am working on setting up the database to the newest stuff. In the provided files for the system I used the create_mysql.sql to create the directorys. I then went to the base folder and ran the auth_databse.sql to add all its contents. Now I am in the updates / auth folder trying to put the updates in when I run them I get the fallowing error. Error Code: 1146. Table 'auth.rbac_role_permissions' doesn't exist Is there any where I can get this tables data so I can make the updates work?
-
Ok so I managed to do them all by hand before I seen your post I have it a few small problems though im not sure what caused. I used the create folder that came with the GET to create all the tables. Then for the world I went to the downloads section on the website and got the TDB_full_335%2e52_2013)07_17 zip file. I used the TDB_full_335%2e52_2013)07_17 fill to fill in the world then I went back to the GET location and into the updates folder then world. I did every one of these other then the ones listed below that are for some reason having the problem listed. 2013_11_02_04_world_sai.sql Error Code: 1048. Column 'entry' cannot be null 2013_11_03_00_world_sai.sql Error Code: 1048. Column 'entryorguid' cannot be null 2013_11_03_31_world_misc.sql Error Code: 1048. Column 'SourceEntry' cannot be null 2013_11_03_33_world_misc.sql Error Code: 1146. Table 'world.creature_ai_scripts' doesn't exist 2013_11_03_42_world_creature.sql Error Code: 1048. Column 'entry' cannot be null2 013_11_04_08_world_sai.sql Error Code: 1062. Duplicate entry '13-7-30098-0-0-31-0-3-17253-0' for key 'PRIMARY' The server is running now but not sure if these will cause any major problems. Thanks so much for all the help every one.
-
I missed them I'm giving that a shot now. Ok that allowed it to work now im just getting "Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders." so I had to have missed one is there any trick to do all the updates at once instead of each individualy. I am using MySQL Worbench
-
The address and password and all is correct the Auth launches with no errors. When I launch the World it just closes and the info above is the info from the Server.txt file it makes. In the worldserver.conf this is they only line you have to alter right? LoginDatabaseInfo = "127.0.0.1;3306;root;Goldie&123;auth" WorldDatabaseInfo = "127.0.0.1;3306;root;Goldie&123;world" CharacterDatabaseInfo = "127.0.0.1;3306;root;Goldie&123;characters" I am using the newest version of the Sql avaible from the downloads section. I did the full sql for the world.
-
I did an all new complie of the server an went though all the directions again and I am still getting this. Using configuration file worldserver.conf. Using SSL version: OpenSSL 1.0.1e 11 Feb 2013 (library: OpenSSL 1.0.1e 11 Feb 2013) Using ACE version: 6.1.4 TrinityCore rev. 3cee0b7dc780 2013-12-12 04:20:31 -0800 (master branch) (Win32, Release) (worldserver-daemon) <Ctrl-C> to stop. ______ __ /__ _ __ __/ __ /_/ / _ __ /_ ___ /_ , _ __ __ /`'__/ /' _ `/ / / / / / / _ _ _ _ _ _ _ _ __/`____ /_//_/ /_//_//_//_//__/ `/___/> C O R E /___/ http://TrinityCore.org /__/ DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Cannot connect to world database 127.0.0.1;3306;root;Goldie&123;world
-
My server was a ways behind so I did trash of the sql and updated it and now when I lauch the world it get the following error. From what In understand its looking for an directory that is not there. Where can I get a copy of this directory to put in so I can make it work. Or is this another problem. Using configuration file worldserver.conf. Using SSL version: OpenSSL 1.0.1e 11 Feb 2013 (library: OpenSSL 1.0.1e 11 Feb 2013) Using ACE version: 6.1.4 TrinityCore rev. 353b82c48b65 2013-04-19 18:07:19 +0200 (master branch) (Win32, Release) (worldserver-daemon) <Ctrl-C> to stop. ______ __ /__ _ __ __/ __ /_/ / _ __ /_ ___ /_ , _ __ __ /`'__/ /' _ `/ / / / / / / _ _ _ _ _ _ _ _ __/`____ /_//_/ /_//_//_//_//__/ `/___/> C O R E /___/ http://TrinityCore.org /__/ In mysql_stmt_prepare() id: 58, sql: "SELECT c.country FROM ip2nationCountries c, ip2nation i WHERE i.ip < ? AND c.code = i.country ORDER BY i.ip DESC LIMIT 0,1" Table 'world.ip2nationcountries' doesn't exist DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Cannot connect to world database 127.0.0.1;3306;root;Goldie&123;world
-
By newest version I ment the newest compile shown on your instructions site. I dont trust repacks seems like normaly them are just virouses. I have used Trinity core a few times now and I have noticed that the core is far more advanced and stable then any other I have used. I do have mysql 5.2 installed. I had a problem with my computer and was forced to reinstall it so maby the problem layed in the same spot. I thank you for your suggestions. I will mark this as solved. Thanks David.
-
I am running the newest version from the website. When I try to run the authserver.exe or the worldserver.exe I get this error "The application was unable to start correctly (0x000007b). Click Ok to close application. I have no firewall or antivirous running that is stoping it not quite sure what is going wrong. Please Help Me.
-
Sorry ya I noticed that just as you answered I feel silly. Thanks for your help.
-
I have tried to download the files from the zip the git hub and using the git command. I get the following error. I have looked though all your things and I did not see any one else with the problem already answered. Make Error at C:/Program Files (x86)/CMake 2.8/share/cmake-2.8/Modules/FindPackageHandleStandardArgs.cmake:97 (message): Could NOT find OpenSSL (missing: OPENSSL_LIBRARIES OPENSSL_INCLUDE_DIR) Call Stack (most recent call first): C:/Program Files (x86)/CMake 2.8/share/cmake-2.8/Modules/FindPackageHandleStandardArgs.cmake:291 (_FPHSA_FAILURE_MESSAGE) cmake/macros/FindOpenSSL.cmake:175 (find_package_handle_standard_args) CMakeLists.txt:53 (find_package) Hope I did not miss something I am sorry if I did.