The Corner Wookie Posted July 17, 2017 Share Posted July 17, 2017 (edited) I am saying config error as I can figure out what else it could be. I am using Heidi and it cant connect to the sql but for some reason DB3 cant connect logs bellow extDB3: https://bitbucket.org/torndeco/extdb3/wiki/Home extDB3: Version: 1.028 extDB3: Windows Version Message: All development for extDB3 is done on a Linux Dedicated Server Message: If you would like to Donate to extDB3 Development Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2 Message: Also leave a message if there is any particular feature you would like to see added. Message: Thanks for all the people that have donated. Message: Torndeco: 18/05/15 extDB3: Found extdb3-conf.ini extDB3: Detected 8 Cores, Setting up 6 Worker Threads extDB3: ... extDB3: ... extDB3: ... extDB3: ... extDB3: ... extDB3: ... [19:53:22:553973 +01:00] [Thread 21188] extDB3: Config Error: altislife: No such node (altislife.IP) (shortened it as this is the only relevant thing in description.ext) class CfgServer { DatabaseName = "altislife"; //Config name that'll be grep in the extdb-conf.ini. Default: [altislife] Config for EXTDB3 [Main] Version = 1 Randomize Config File = false ;; Randomizes Config File after loading. ;; Recommend to turn on, if you have enabled filepatching on arma. Allow Reset = false ;; Allows 9:RESET, usefull for development work Thread = 0; ;; Option to force number of worker threads for extDB3. ;; Auto = 0, Min = 2, Max = 6 [Log] Flush = true; ;; Flush logfile after each update. ;; Option really only usefull if running DEBUG BUILD [Database] IP =127.0.0.1 Port =3306 Username =root Password =(password im not sharing public ) Database =altislife If there is anything missing from this ill add it any help would be appreciated https://gyazo.com/2891d2a50579500714f13a698edb774f screenshot of Heidi session manager if needed. Edited July 17, 2017 by The Corner Wookie Added a t to can to make it cant Quote Link to comment Share on other sites More sharing options...
The Corner Wookie Posted July 17, 2017 Author Share Posted July 17, 2017 (edited) It psoted a reply twice delete this one Edited July 17, 2017 by The Corner Wookie accidental double posting Quote Link to comment Share on other sites More sharing options...
The Corner Wookie Posted July 17, 2017 Author Share Posted July 17, 2017 I changed [database] to Altis life and it does this https://gyazo.com/4a18d88ef51d5d17e8e3401825a88b66 https://docs.google.com/document/d/1BsucJfbSYiko6djRt9AdkHBd_NIzl3_2-cuSDevnfR4/edit?usp=sharing Quote Link to comment Share on other sites More sharing options...
joew Posted July 18, 2017 Share Posted July 18, 2017 Hello @The Corner Wookie ! Next time post your logs at pastebin.com , please. Its better for us to read it ^^ Don't forgot to post server's and client's RPT logs too. Anyway, which version of Altis Life framework are you using? It's important. extDB3 works both with 4.4R4 and 5.0 versions, but for 4.4R4 version, you have to make those changes: https://github.com/AsYetUntitled/Framework/commit/8de51bd0d87070a7be64f9c3fc85d1d2922ea178 And make sure it is: - description.ext : ... class CfgServer { DatabaseName = "altislife"; //Config name that'll be grep in the extdb-conf.ini. Default: [altislife] ... }; ... - extdb3-conf.ini : [altislife] IP = 127.0.0.1 Port = 3306 Username = root Password = YOUR_MYSQL_PASSWORD Database = altislife There are a lot of errors on your database's log. My guess is that you used the wrong SQL file to create the database. You have to use the right one for your version, or it will be something missing/different. For AL v4.4R4, use those files: https://github.com/AsYetUntitled/Framework/releases/tag/4.4r3 For AL v5.0 (dev), use those files: https://github.com/AsYetUntitled/Framework If you still have some questions, I recommend you follow this complete guide (But use the files I posted above instead files from youtube video's description): Spoiler I don't recommend you disables spyglass, so if you have any spyglass errors, read it to learn how it works: https://github.com/AsYetUntitled/Framework/tree/master/Altis_Life.Altis/Spyglass Quote Link to comment Share on other sites More sharing options...
The Corner Wookie Posted July 18, 2017 Author Share Posted July 18, 2017 (edited) Hey Sorry for not posting some of the shorter stuff in paste bin I didn't think it would be required. I followed a similar tutorial that went step by step. Description.ext (from the server mission file ): https://pastebin.com/dueWvreR Server Log: https://pastebin.com/RG8hycyn Client log: https://pastebin.com/FiJ8PH1V The extdb3 stays the same and it's exactly like yours... also the Altis life SQL is from the framework mission it's not my own. I just replaced it with the link you gave me just in case and reinstalled life server as I heard this was another fix. I have done all the installation and stuff. Do you need to see anything else Sorry if I sound annoyed I have been trying to create this following every tutorial and it's still not working. Oh and it's 5.0.0 If what I'm doing currently doesn't work then I'm going to create a new mission just in case I broke something Edited July 18, 2017 by The Corner Wookie Added some stuff Quote Link to comment Share on other sites More sharing options...
The Corner Wookie Posted July 18, 2017 Author Share Posted July 18, 2017 (edited) [11:38:08:843920 +01:00] [Thread 1860] extDB3: SQL: Initialized: Add Quotes around TEXT Datatypes mode: 2 [11:38:08:845218 +01:00] [Thread 1860] extDB3: SQL: Initialized: NULL = "" [11:38:08:845252 +01:00] [Thread 1860] extDB3: Locked [11:38:08:856236 +01:00] [Thread 21152] extDB3: SQL: Error MariaDBQueryException: The user specified as a definer ('arma3'@'localhost') does not exist [11:38:08:856242 +01:00] [Thread 2020] extDB3: SQL: Error MariaDBQueryException: The user specified as a definer ('arma3'@'localhost') does not exist [11:38:08:856249 +01:00] [Thread 21148] extDB3: SQL: Error MariaDBQueryException: The user specified as a definer ('arma3'@'localhost') does not exist [11:38:08:856275 +01:00] [Thread 21152] extDB3: SQL: Error MariaDBQueryException: Input: CALL resetLifeVehicles [11:38:08:856291 +01:00] [Thread 2020] extDB3: SQL: Error MariaDBQueryException: Input: CALL deleteDeadVehicles [11:38:08:856300 +01:00] [Thread 21148] extDB3: SQL: Error MariaDBQueryException: Input: CALL deleteOldHouses [11:38:08:856492 +01:00] [Thread 15048] extDB3: SQL: Error MariaDBQueryException: The user specified as a definer ('arma3'@'localhost') does not exist Fresh instal and this still happens https://pastebin.com/gAH62gbR - Altis life SQL https://pastebin.com/VGpnBEiM - config for extdb3 https://pastebin.com/7nynYQyW - full log Edited July 18, 2017 by The Corner Wookie added pastebins Quote Link to comment Share on other sites More sharing options...
joew Posted August 2, 2017 Share Posted August 2, 2017 2 errors that I found. 1) You already found it: Quote [11:38:08:856236 +01:00] [Thread 21152] extDB3: SQL: Error MariaDBQueryException: The user specified as a definer ('arma3'@'localhost') does not exist You have to change your Altis Life SQL. Change all 'arma3'@'localhost' to 'root'@'localhost' 2) Your SQL stills have error: Quote [11:38:16:850568 +01:00] [Thread 15048] extDB3: SQL: Error MariaDBQueryException: Unknown column 'pid' in 'field list' Its looking for one column that don't exists. You're using the wrong SQL file for your AL version. Which AL framework version are you using, please? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.