******Updates 5/2024****** Project SkyFire has migrated from Github to Codeberg. I have updated the links but generally speaking everything is the same configuration wise. You will use the updated URL's for doing the Git pulls. The OpenSSL 1.1.1w link no longer exists. I have a direct download link from MediaFire that can be used now. Also, if you get transmog errors and the world server crashes one first the first launch you will need to run the query in the URL below on your "characters" database in HeidiSQL or a SQL manager of your choosing: github.com/ProjectSkyfire/SkyFire_548/blob/095121ecf334bcd40c854a8b4a32c225931723c0/sql/updates/characters/2024_02_12_23_12_characters.sql You can either copy the query and paste it in or download it and apply it. Just be sure it is run on the "characters" database and no others!
DS, thank you again for another superlative video. The clarity and harmony with which you are able to compose and present content incorporating, at times, disparate and distantly-related compositional elements is truly without reproach. Such compositional acumen is especially appreciated when it is pointed at themes so classic and beloved as that of WOW. I believe I speak for the voiceless multitude when I say that my hat goes off to you sir.
Works perfectly. I only had the Worldserver connection problem at the end. I didn't see your comment under the video. *****Updates 5/2024***** For me it generated an error when starting the Worldserver, it couldn't access the character database. The SQL patch has now fixed this error... thank god ;) This guide is great! Thanx a lot
Really nice. I was going to jump to legion from WoTLK since there's a repack available but since you posted this tutorial i will play MoP first. Thanks.
Hey DS. Hope you are doing well. Thanks for another great vid! FYI, it looks like they've made some more changes on Codeburg that may cause issues for someone following this guide. They have changed the OpenSSL requirement to 3.x.x and added a new CMake check for a Legacy.dll, which fails in CMake. Figuring out this Legacy.dll change was the biggest headache for me as they appear to be looking in \lib\ossl-modules when the dll is in \bin. I do not know where the 'ossl' folder is supposed to come from and my attempts to google it only got me more confused . In the end I manually created this folder, copied the dll in, and was able to proceed with compilation.
I'm going to add this here as I found out the hard way as well. In the SkyFire_548 folder is a contrib/openssl folder that contains a zip that should be used at the C:/ drive root. It has to be extracted at root or it doesn't work.
I think I am running into this error. I am having a "CMake Error at cmake/macros/FindOpenSSL.cmake:188 (message): Found OpenSSL legacy library: OPENSSL_LIB_LEGACY-NOTFOUND" Error in Cmake. What I do not understand from your description is what DLLs I need and in what folder system I am to put them. Im I to create a new folder called "ossl" in the root cmake folder or in the OpenSSL root folder? Sorry for asking so many questions, this is the first time I am leaning how all these systems work and talk with each other.
hello again :) Is it possible to get "NPC Bots" added to this like Emucoach done ? I wanted to make a Pandaria PLUS server like "Dingledork" did with his WOTLK repack. I also want to add a progression phases so you cant skip content. Do you think this possible ? I know I probably asking too much lol ( panda version) :)
Some structure has changed by the project since I made the video. I need to make a new video to show the changes soon. If you check out the projects discord page they mention the fix for this.
@@Digital-Scriptorium i finally fixed my problem after changing things around. currently struggling how to set my account to gm... i've try to set it in the world cmd but it didnt work also tried heidi. even if i set my gm level to 4 its not working in game
I have installed this but are there any gmlevel settings? It seems unlike the WOTLK windows tutorial, the GMLEVEL settings is not the same or not working here. What exactly do I need to look out for to set gmlevel because it doesn't use the same syntax.
If you look at the recent commits in the code repository, they seem to be removing these commands for some reason. I ran into the same issue, and it was only fixed by checking out the code at this commit - afb98cf57dc969487e5c5387b9e3d387387579e8 as the next commit is when they started stripping out functionality. I recompiled using this code and the GM commands are working now.
Hey bud, question please answer. Let's say if I did a family server, and that they had to change them realmlist to (name of host site) would I still have to make their accounts for them or could I just add this registration script to the SQL that leads to the site? I wish they could just use their BN account but that would somewhat be impossible
@@Digital-Scriptorium "CMake Error at cmake/macros/FindOpenSSL.cmake:80 (message): Found OpenSSL legacy library: OPENSSL_LIB_LEGACY-NOTFOUND Call Stack (most recent call first): CMakeLists.txt:56 (find_package) Configuring incomplete, errors occurred!" During Cmake i guess i really do need that 1.1W version openSSL but the thing is it's not there on the site
Sorry for the delayed response. Here's a direct link to 1.1.1w if you still need it: www.mediafire.com/file_premium/srru301deblv6k4/Win64OpenSSL-1_1_1w.msi/file
DS, Thank you for this tutorial. I will be retiring in a couple of years and would love to make a private wow 5.4.8 server for myself, my sons, and my grandkids. I have a few questions to ask before I get started. 1. Are there classes you can recommend that would make it easier for me to get this done more effectively. 2. I have looked through MANY guides and tutorials for a very detailed written list as I am trying to watch these on my phone and they are either to small to see or go too quickly for me to keep up. Do you happen to know if there is one out there or could you possibly make one? 3. Since I have little computer experience, would it just be better to download the emucoach repack and use it along with the Tauri WOW game client? 4. Someone posted in the comment section that the Skyfire emulator had terrible game content. I have the well scripted Tauri WOW as my game client. Where would the game be pulling its data from? 5. Is there a way to edit the data? For example, since I am basically playing solo, how would I get the Glyph of Safe Fall from the AH? Also, how could I add any rares back that are missing from the Tauri WOW game client? Would either even be a possibility? I have seen that there is one for 3.3.5 and emucoach has a guide for 5.1.0 but found nothing for 5.4.8. I apologize in advance if my questions seem inherently obvious to most. I have tried asking most of these questions elsewhere and have never gotten a response. I just noticed that you actually seemed to answer the people when they asked for advice. Sincerely, Jayce
No worries! One thing to note as the one person commented on is if you are looking for stable and complete game content I'd eye 1.12, 2.4.3, or 3.3.5 server projects. The versions above that have a much smaller community developing it out. Part of me making the videos is to help shed light on them if others want to jump in and help develop it. As far as learning it all my channel is certainly a good spot to see the OS guides plus the different different projects. A lot can be learned just from those and check out the discord's channels for the projects too. The game clients would be pulling the data from the servers for the most part. Some stuff is hard coded in the game clients themselves.
So what is the status of this core? I suppose everything after 3.5.5a barely works or is stuck on some closed-source servers like whitemane. I recently installed Cataclysm Preservation Project but barely anything related to Cata worked and didn't had any scripts. Tbc and wotlk are working almost blizzlike. TrinityCore seems to support multiple expansions, which means that the devs are stretching thin and wide - I cannot expect good quality when you stretch this thin.
It's still a small group that is actively developing this one. It certainly has its faults. As for cataclysm I think it will get significantly better once classic cataclysm releases. They're planning to use its client to work through the major roadblocks.
Hello, can you help me create my server? I really can't make it to work, it just crash my CMD prompt, telling me that termination behavior... then just close :( Can you guide me on discord?
Unfortunately, some structure changes have happened with the project and that's why it's failing. I'm hoping to make a new guide for it in the next month. For now the best thing to do is to check the projects discord page as it has the information that is needed to make it happy.
hi! we're a couple of noobs who decided to give this a shot. after alot of issues and trouble shooting we managed to do the wrath from a previous video. But with this after we made it, (we tried twice making it from the bottom following the vid) then creating a character and log in all sorts of weird gameplay stuff happens. quests not showing up, enemies having an insane aggro range and other weird quircks.. As total noobs we have very limited knowledge on what it could be, so we where hoping someone here might have an idea on what the issue could be or how to fix it :)
I think ultimately this is just the current state of the project. It's still actively under development but only a small handful of developers. So expect things to be a little wacky.
Ty very much for this, tutorial! However transmog doesnt work on my server for some reason. Does it work for you? When i wanna transmog item i click on apply and model doesnt change only sound of transmogrification is played.
I keep getting SQL Error (1227): Access denied. It says that I need at least one of the SYSTEM_USER privileges for the operation when populating the world database. Everything up to this point has gone without a hitch.
@@Digital-Scriptorium Same account, or at least it should be. Looking at user manager, my account has all the global permissions. I have a user called Root with two separate global privileges drop downs, the first one has all permissions, the second only has GRANT permission. There's three more users starting mysql. with infoschema, session, and sys. They're all localhoast and none have full global permissions.
@@Digital-Scriptorium Hey, just got it to work. I had to go into the sql file for the world and replace DEFINER='root'@'localhost' with DEFINER='(username here)'@'localhost Obviously replacing "(username here)" with my account username. So if the account username was Adrian, it would read DEFINER='Adrian'@'localhost' After that, it worked. Needed to be closed out and reopened to see the changes, but it's populated now.
I'm having a problem here in cmake: CMake Error at cmake/macros/FindOpenSSL.cmake:188 (message): Found OpenSSL legacy library: OPENSSL_LIB_LEGACY-NOTFOUND Call Stack (most recent call first): CMakeLists.txt:66 (find_package) Is there a solution?
I believe openssl needs to be in a specific spot. I'm away from my computer but I believe someone mentioned the fix in the comments. The discord also has info on it.
im not a computer nurd and i am clueless, but can i play offline if i follow this process ? i mean set up online first and then go camping and play offline ? Any assistance appreciated
Hey m8 . Very good job . i got 1 question. Do you know anything about that error . DatabasePool characters NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. i check the details in authserver.conf and worldserver.conf if i have any errors there but verything good . still the same Error also on top of that the Cmd starts with Table 'characters.item_instance_transmog' doesn't exist. Does this effects ?
@@AlexandrosAlexiou-k4t so one thing that changed recently is they moved the project going forward off of git. The other area has lots of fixes and I just haven't had a chance to test it since the change. I can give an update in a few days which might resolve your issue.
FYI I figured out the problem. You'll want to open HeidiSQL or the SQL manager of your choice. Select the "Characters" database. Then run a query with the following code from this URL: github.com/ProjectSkyfire/SkyFire_548/blob/095121ecf334bcd40c854a8b4a32c225931723c0/sql/updates/characters/2024_02_12_23_12_characters.sql
Hello! Previously I had installed AC 3.3.5 on my PC (successfully). Now I'm trying to compile SkyFire on that PC and in CMake I have an error CMake "Error at cmake/macros/FindOpenSSL.cmake:80 (message): Found OpenSSL legacy library: OPENSSL_LIB_LEGACY-NOTFOUND Call Stack (most recent call first): CMakeLists.txt:56 (find_package)" . What is wrong?
They recently changed the openssl requirements. They have a link if you search for that error on their discord channel. I'd link you it but I'm not near a computer right now :(
@@wantedslv here's from their discord if it helps: "in contrib folder you have a precompiled openssl 3.3 move it to C:/ drive and recmake recompile that will fix your issue, the issue is you cant locate legacy library in C:/OpenSSL-Win64/lib/ossl-modules"
Hey digi love your work. I've hit this error and can't seem to work out how to fix it. happens when I try to open the worldserver, if there's a fix, please dumb it down lol. Table 'characters.item_instance_transmog' doesn't exist Table 'characters.item_instance_transmog' doesn't exist Table 'characters.item_instance_transmog' doesn't exist Table 'characters.item_instance_transmog' doesn't exist DatabasePool characters NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Cannot connect to Character database
No problem! I checked out the discord for the project and here's the fix. Download this and run it on the characters database. github.com/ProjectSkyfire/SkyFire_548/blob/095121ecf334bcd40c854a8b4a32c225931723c0/sql/updates/characters/2024_02_12_23_12_characters.sql
@@Digital-Scriptorium Any chance on an update vid? I had to use OpenSSL 3.3.1 because when building with OpenSSL 1.1.1w I was getting missing header file errors. With 3.3.1 though I can't figure out how to load the legacy provider even when using the methods suggested by @ADacidion and others in the thread
Hi! Thanks for the video. I'm having problems in the final part, cant login to the realmlist (i see the realm but is grayed out). Any idea of what can i do to solve this? Thx!
No problem! If your server and client are on the same machine then make sure your realmlist SQL table has 127.0.0.1 set. If the server is separate from the client machine then make sure the IP is correct in the realmlist table. The other thing is if you haven't rebooted yet then relaunch the server.
Thanks for the fast anwser@@Digital-Scriptorium ! I fix this problem redownloading the connection patcher from the GitHub link and reaplying the patch but running as administrator. (The IP address in the SQL table was a No-IP dns and in my Config.wtf my "SET realmlist" i'm using my local IP 192.x.x.x). Now everything is running smooth. I hope this help if anyone have the same issue.
@@sezantonio I've tried everything I can think of and I'm still running into the issue. The ips all match, it's calling to the correct IP, the client is 5.4.8 (18414), and I'm about to start pulling panda hair trying to figure this out. I even tried (knowing it probably wouldn't work) replacing all the IPs with my personal one... of course it didn't work. I don't know what else to try.
@@Digital-Scriptorium So I need to single player in MOP with bots to raiding. So, you told not everything working? mmm ;( My time ending... never mind... I hope ur project will be done well...;)
@@Digital-Scriptorium allg mate, after installing mop from your video which was amazing btw, decided to follow your wotlk vid so i could add bots, all done and working now although having mop fucked me with heidisql and i couldnt seem to login to the wrath db i kept getting mop and just couldnt figure out how to get into wrath, even deleting heidi and mysql didnt help my pc forget mop haha, so i deleted mop, still had the same issue. fuck it so i reinstalled windows and then wrath, thanks alot for your videos mate, amazing stuff take care xx
Found this video after I installed a skyfire server today, kind of "fun" that you can enter zones after wotlk content, but really.. there is absolutely no content in cata and later zones. Those npcs and mobs that should work, even in Stormwind and so on, they do not.. no waypoints for npcs or mobs or anything works.. Ironforge has lots of extra npcs that shouldn't be there, they are falling from the air and dropping down on the ground and so on and this is with version 24 of the DB. Lots of teleports aren't in place, so it is hard to visit zones after cata content. Skyfire is ok if you want to visit zones and just see what it looked like back in the day.. but really, Skyfire isn't for playing the game. Even starting zones are really bad. I don't understand why they aren't working together with either TC or AC with database data, so the zones up to 80 will work good. I know there are changes from cata and onwards, but at least they should have a base to work further on - which doesn't seem to be the case. Great video though, really in depth and could probably have saved me some time searching today, if I just watched it before installing the server 😂😋
youtube keeps deleting my comments, quite annoying. but i have an error because i am no using the older version of openSSL is there a fast fast way to fix this?
Sorry to again bug you :/ this has messed up a bit of my files i may have to start over again, all because OpenSSL 1.1.1W is no longer available :/ i wish there was a better way to do this
Im at the point id pay you to get this running for me. i can get every other server going by watching your videos but for the life of me this one i can not.
After I was doing so well with your video when I went to launch the worldserver, it won't launch. I'm getting two errors one from doing your troubleshooting saying that Invalid or missing configuration file : worldserver.conf Verify that the file exists and has '[worldserver]' written in the top of the file! and the DBError text file saying In mysql_stmt_prepare() id: 55, sql: "PÍ}ëõ" Table 'characters.item_instance_transmog' doesn't exist In mysql_stmt_prepare() id: 107, sql: "€-€ëõ" Table 'characters.item_instance_transmog' doesn't exist In mysql_stmt_prepare() id: 108, sql: "À ‚ëõ" Table 'characters.item_instance_transmog' doesn't exist In mysql_stmt_prepare() id: 109, sql: "0Gtëõ" I dont have a clue what to do... please help!
It looks like the project jumped ship off of git and is using a new repository with lots of fixes. I need to try it out and see what needs to be changed in my guide. I'll let you know when I've tested it and what's changed.
FYI I figured out the problem. You'll want to open HeidiSQL or the SQL manager of your choice. Select the "Characters" database. Then run a query with the following code from this URL: github.com/ProjectSkyfire/SkyFire_548/blob/095121ecf334bcd40c854a8b4a32c225931723c0/sql/updates/characters/2024_02_12_23_12_characters.sql
******Updates 5/2024******
Project SkyFire has migrated from Github to Codeberg. I have updated the links but generally speaking everything is the same configuration wise. You will use the updated URL's for doing the Git pulls.
The OpenSSL 1.1.1w link no longer exists. I have a direct download link from MediaFire that can be used now.
Also, if you get transmog errors and the world server crashes one first the first launch you will need to run the query in the URL below on your "characters" database in HeidiSQL or a SQL manager of your choosing:
github.com/ProjectSkyfire/SkyFire_548/blob/095121ecf334bcd40c854a8b4a32c225931723c0/sql/updates/characters/2024_02_12_23_12_characters.sql
You can either copy the query and paste it in or download it and apply it. Just be sure it is run on the "characters" database and no others!
DS, thank you again for another superlative video. The clarity and harmony with which you are able to compose and present content incorporating, at times, disparate and distantly-related compositional elements is truly without reproach. Such compositional acumen is especially appreciated when it is pointed at themes so classic and beloved as that of WOW. I believe I speak for the voiceless multitude when I say that my hat goes off to you sir.
I appreciate the kind words and enjoy!
Works perfectly.
I only had the Worldserver connection problem at the end. I didn't see your comment under the video. *****Updates 5/2024***** For me it generated an error when starting the Worldserver, it couldn't access the character database. The SQL patch has now fixed this error... thank god ;)
This guide is great! Thanx a lot
Nice and enjoy! :)
Really nice. I was going to jump to legion from WoTLK since there's a repack available but since you posted this tutorial i will play MoP first. Thanks.
Nice and yeah give it a shot for sure. I'll be making a Legion server guide soon as well so keep an eye out.
Amazing tutorial! It took me going through the tutorial twice to get it working. The transmog fix helped so much!
No problem and enjoy! :)
Awesome video again. 🙂
Thank you! :)
Hey DS. Hope you are doing well. Thanks for another great vid!
FYI, it looks like they've made some more changes on Codeburg that may cause issues for someone following this guide. They have changed the OpenSSL requirement to 3.x.x and added a new CMake check for a Legacy.dll, which fails in CMake. Figuring out this Legacy.dll change was the biggest headache for me as they appear to be looking in \lib\ossl-modules when the dll is in \bin. I do not know where the 'ossl' folder is supposed to come from and my attempts to google it only got me more confused . In the end I manually created this folder, copied the dll in, and was able to proceed with compilation.
O interesting. I'll have to do another run through and check it out. Thank you for the info!
I'm going to add this here as I found out the hard way as well. In the SkyFire_548 folder is a contrib/openssl folder that contains a zip that should be used at the C:/ drive root. It has to be extracted at root or it doesn't work.
@@anthonyhales7047 thank you for the info.
Ran into this exact issue and could not find anything useful when Googling. Thank you for this!
I think I am running into this error. I am having a "CMake Error at cmake/macros/FindOpenSSL.cmake:188 (message):
Found OpenSSL legacy library: OPENSSL_LIB_LEGACY-NOTFOUND" Error in Cmake.
What I do not understand from your description is what DLLs I need and in what folder system I am to put them. Im I to create a new folder called "ossl" in the root cmake folder or in the OpenSSL root folder?
Sorry for asking so many questions, this is the first time I am leaning how all these systems work and talk with each other.
Love your videos!
Do the MOP and/or CATA servers have equivalent AH bot and Autobalance modules like AC?
Thank you! Unfortunately, they do not that I know of.
@@Digital-Scriptorium Thank you for replying. I look forward to future videos of yours! Merry Christmas!🎄
@@retrogamer821 no problem! I'm just waiting for my voice to return after being sick for a few weeks. Merry Christmas!
I just came back to say, everything is great and i even got the MoP bots running, you're welcome to join Digital!!!!!! bring your A-game!
Bots you say? Like world player bots?
@@Digital-Scriptorium yes!!
@@RommyTVx fancy! :)
@@Digital-Scriptorium I'll be sure to upload the video tomorrow, players vs AI
@@RommyTVx nice! I look forward to it.
hello again :) Is it possible to get "NPC Bots" added to this like Emucoach done ? I wanted to make a Pandaria PLUS server like "Dingledork" did with his WOTLK repack. I also want to add a progression phases so you cant skip content. Do you think this possible ? I know I probably asking too much lol ( panda version) :)
sorry to ask the same question but im trying to make a plus version of a blizzlike server but i need a Modify friendly server ( thats not WOTLK )
Unfortunately, no for this project either.
i need help. im trying to open my authserver and it instantly closes. i check cmd>cd to check the error, it says "loading legacy provider: (failed)
Using configuration file authserver.conf.
OpenSSL 3.3.0 9 Apr 2024 (Library: OpenSSL 3.3.0 9 Apr 2024)
Failed loading legacy provider, Try to load legacy provider again.
Loading default provider: (succeeded)
Loading legacy provider: (failed)
Some structure has changed by the project since I made the video. I need to make a new video to show the changes soon. If you check out the projects discord page they mention the fix for this.
@@Digital-Scriptorium i finally fixed my problem after changing things around. currently struggling how to set my account to gm... i've try to set it in the world cmd but it didnt work also tried heidi. even if i set my gm level to 4 its not working in game
@@SindraNox hmmm it should be done in the world CMD. Might be worth checking the discord on that one.
I have installed this but are there any gmlevel settings? It seems unlike the WOTLK windows tutorial, the GMLEVEL settings is not the same or not working here. What exactly do I need to look out for to set gmlevel because it doesn't use the same syntax.
Yeah, I believe things are different. I believe the wiki has info on it.
If you look at the recent commits in the code repository, they seem to be removing these commands for some reason. I ran into the same issue, and it was only fixed by checking out the code at this commit - afb98cf57dc969487e5c5387b9e3d387387579e8 as the next commit is when they started stripping out functionality. I recompiled using this code and the GM commands are working now.
Very odd and thank you for the info.
Hello, can you show how to make warlords of draenor?
If I can find a project for it that is still alive then it is in my queue. Just no ETA right now.
Hey bud, question please answer. Let's say if I did a family server, and that they had to change them realmlist to (name of host site) would I still have to make their accounts for them or could I just add this registration script to the SQL that leads to the site? I wish they could just use their BN account but that would somewhat be impossible
I would say manually create their accounts yourself which will be easier in the long run.
@@Digital-Scriptorium "CMake Error at cmake/macros/FindOpenSSL.cmake:80 (message):
Found OpenSSL legacy library: OPENSSL_LIB_LEGACY-NOTFOUND
Call Stack (most recent call first):
CMakeLists.txt:56 (find_package)
Configuring incomplete, errors occurred!" During Cmake i guess i really do need that 1.1W version openSSL but the thing is it's not there on the site
Sorry for the delayed response. Here's a direct link to 1.1.1w if you still need it: www.mediafire.com/file_premium/srru301deblv6k4/Win64OpenSSL-1_1_1w.msi/file
DS,
Thank you for this tutorial. I will be retiring in a couple of years and would love to make a private wow 5.4.8 server for myself, my sons, and my grandkids. I have a few questions to ask before I get started.
1. Are there classes you can recommend that would make it easier for me to get this done more effectively.
2. I have looked through MANY guides and tutorials for a very detailed written list as I am trying to watch these on my phone and they are either to small to see or go too quickly for me to keep up. Do you happen to know if there is one out there or could you possibly make one?
3. Since I have little computer experience, would it just be better to download the emucoach repack and use it along with the Tauri WOW game client?
4. Someone posted in the comment section that the Skyfire emulator had terrible game content. I have the well scripted Tauri WOW as my game client. Where would the game be pulling its data from?
5. Is there a way to edit the data? For example, since I am basically playing solo, how would I get the Glyph of Safe Fall from the AH? Also, how could I add any rares back that are missing from the Tauri WOW game client? Would either even be a possibility? I have seen that there is one for 3.3.5 and emucoach has a guide for 5.1.0 but found nothing for 5.4.8.
I apologize in advance if my questions seem inherently obvious to most. I have tried asking most of these questions elsewhere and have never gotten a response. I just noticed that you actually seemed to answer the people when they asked for advice.
Sincerely, Jayce
No worries! One thing to note as the one person commented on is if you are looking for stable and complete game content I'd eye 1.12, 2.4.3, or 3.3.5 server projects. The versions above that have a much smaller community developing it out. Part of me making the videos is to help shed light on them if others want to jump in and help develop it. As far as learning it all my channel is certainly a good spot to see the OS guides plus the different different projects. A lot can be learned just from those and check out the discord's channels for the projects too. The game clients would be pulling the data from the servers for the most part. Some stuff is hard coded in the game clients themselves.
Nice
:)
how to fix problem with entering into the server ?
only "connecting" and nothing after it...
Double check the realmlist SQL configs are set ok for you.
So what is the status of this core? I suppose everything after 3.5.5a barely works or is stuck on some closed-source servers like whitemane. I recently installed Cataclysm Preservation Project but barely anything related to Cata worked and didn't had any scripts. Tbc and wotlk are working almost blizzlike. TrinityCore seems to support multiple expansions, which means that the devs are stretching thin and wide - I cannot expect good quality when you stretch this thin.
It's still a small group that is actively developing this one. It certainly has its faults. As for cataclysm I think it will get significantly better once classic cataclysm releases. They're planning to use its client to work through the major roadblocks.
Hello, can you help me create my server? I really can't make it to work, it just crash my CMD prompt, telling me that termination behavior... then just close :(
Can you guide me on discord?
Unfortunately, some structure changes have happened with the project and that's why it's failing. I'm hoping to make a new guide for it in the next month. For now the best thing to do is to check the projects discord page as it has the information that is needed to make it happy.
hi! we're a couple of noobs who decided to give this a shot. after alot of issues and trouble shooting we managed to do the wrath from a previous video. But with this after we made it, (we tried twice making it from the bottom following the vid) then creating a character and log in all sorts of weird gameplay stuff happens. quests not showing up, enemies having an insane aggro range and other weird quircks.. As total noobs we have very limited knowledge on what it could be, so we where hoping someone here might have an idea on what the issue could be or how to fix it :)
I think ultimately this is just the current state of the project. It's still actively under development but only a small handful of developers. So expect things to be a little wacky.
Ahh, thanks alot. We'll continue with wrath and try this later at some point then ;D@@Digital-Scriptorium
@@ObsessedGhost no problem and enjoy wrath!
Absolutely.
Do you know how to fix timeless loot?
I think the project hasn't completely built that out yet. You can check on the projects discord though.
Ty very much for this, tutorial! However transmog doesnt work on my server for some reason. Does it work for you? When i wanna transmog item i click on apply and model doesnt change only sound of transmogrification is played.
I believe that is still a work in progress with the project.
Can we use AzerothCore Modules in this project?
Unfortunately, it is incompatible with the modules from AC.
@@Digital-Scriptorium do they have there own modules that we can install?
@@jeffrandom4200 someone mentioned some modules they paid for from some 3rd party but never mentioned where or how they got them working.
I keep getting SQL Error (1227): Access denied. It says that I need at least one of the SYSTEM_USER privileges for the operation when populating the world database. Everything up to this point has gone without a hitch.
Are you doing this as the root user in SQL?
@@Digital-Scriptorium Would that be checked in HediSQL?
@@adriananderson9783 yeah, if you logged into heidisql with your root account or if you created a different account you're trying to use.
@@Digital-Scriptorium Same account, or at least it should be. Looking at user manager, my account has all the global permissions. I have a user called Root with two separate global privileges drop downs, the first one has all permissions, the second only has GRANT permission. There's three more users starting mysql. with infoschema, session, and sys. They're all localhoast and none have full global permissions.
@@Digital-Scriptorium Hey, just got it to work. I had to go into the sql file for the world and replace
DEFINER='root'@'localhost' with
DEFINER='(username here)'@'localhost
Obviously replacing "(username here)" with my account username. So if the account username was Adrian, it would read
DEFINER='Adrian'@'localhost'
After that, it worked. Needed to be closed out and reopened to see the changes, but it's populated now.
I'm having a problem here in cmake: CMake Error at cmake/macros/FindOpenSSL.cmake:188 (message):
Found OpenSSL legacy library: OPENSSL_LIB_LEGACY-NOTFOUND
Call Stack (most recent call first):
CMakeLists.txt:66 (find_package)
Is there a solution?
I believe openssl needs to be in a specific spot. I'm away from my computer but I believe someone mentioned the fix in the comments. The discord also has info on it.
@@Digital-Scriptorium what's your discord? for me to come in and see any corrections to resolve
@@jeanlucas505 sorry I meant the projects discord which I believe a link exists in their wiki.
im not a computer nurd and i am clueless, but can i play offline if i follow this process ? i mean set up online first and then go camping and play offline ? Any assistance appreciated
Yes, you can. Just be aware that some content of this project can be a little rough.
Hey m8 . Very good job . i got 1 question. Do you know anything about that error . DatabasePool characters NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. i check the details in authserver.conf and worldserver.conf if i have any errors there but verything good . still the same Error also on top of that the Cmd starts with Table 'characters.item_instance_transmog' doesn't exist. Does this effects ?
I believe it's just not implemented yet but as long as the world loads you should be ok.
Thx for the dast repply . Unfortunately with that error i cant run the worldserver.exe@@Digital-Scriptorium
@@AlexandrosAlexiou-k4t so one thing that changed recently is they moved the project going forward off of git. The other area has lots of fixes and I just haven't had a chance to test it since the change. I can give an update in a few days which might resolve your issue.
FYI I figured out the problem. You'll want to open HeidiSQL or the SQL manager of your choice. Select the "Characters" database. Then run a query with the following code from this URL: github.com/ProjectSkyfire/SkyFire_548/blob/095121ecf334bcd40c854a8b4a32c225931723c0/sql/updates/characters/2024_02_12_23_12_characters.sql
@@Digital-Scriptorium thanks a lot man, this fixed it!
Hello! Previously I had installed AC 3.3.5 on my PC (successfully). Now I'm trying to compile SkyFire on that PC and in CMake I have an error CMake "Error at cmake/macros/FindOpenSSL.cmake:80 (message):
Found OpenSSL legacy library: OPENSSL_LIB_LEGACY-NOTFOUND
Call Stack (most recent call first):
CMakeLists.txt:56 (find_package)" . What is wrong?
They recently changed the openssl requirements. They have a link if you search for that error on their discord channel. I'd link you it but I'm not near a computer right now :(
@@Digital-Scriptorium I'll wait for you. I'd installed 3.3.0 SSL, but still got an error
@@wantedslv here's from their discord if it helps: "in contrib folder you have a precompiled openssl 3.3 move it to C:/ drive and recmake recompile that will fix your issue,
the issue is you cant locate legacy library in C:/OpenSSL-Win64/lib/ossl-modules"
@@Digital-Scriptorium thank you very much, you are the best, the error is disappear :)
@@wantedslv no problem! Enjoy! :)
Client 5.4.8 where can I download 64 bit and 86 bit?
The best place I know of is wowdl
Hey digi love your work.
I've hit this error and can't seem to work out how to fix it. happens when I try to open the worldserver, if there's a fix, please dumb it down lol.
Table 'characters.item_instance_transmog' doesn't exist
Table 'characters.item_instance_transmog' doesn't exist
Table 'characters.item_instance_transmog' doesn't exist
Table 'characters.item_instance_transmog' doesn't exist
DatabasePool characters NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to Character database
No problem! I checked out the discord for the project and here's the fix. Download this and run it on the characters database. github.com/ProjectSkyfire/SkyFire_548/blob/095121ecf334bcd40c854a8b4a32c225931723c0/sql/updates/characters/2024_02_12_23_12_characters.sql
@@Digital-Scriptorium Thanks heaps Digi, that worked!
@@mickmunn-xr6nn No problem! Enjoy! :)
@@Digital-Scriptorium Just wanted to thank you as well, I also had the exact same error and this worked perfectly!
@@TheLichKing829 no problem! :)
Is it possible to customize Skyfire to make it Single Player friendly?
In the current state not really besides manually upping your stats and what not.
@@Digital-Scriptorium Also, how come I need OpenSSL 1.1.1w instead of OpenSSL 3.0.1?
@@Daimando they say you can just install 3.x.x now but I haven't confirmed it completely works yet.
@@Digital-Scriptorium Any chance on an update vid? I had to use OpenSSL 3.3.1 because when building with OpenSSL 1.1.1w I was getting missing header file errors. With 3.3.1 though I can't figure out how to load the legacy provider even when using the methods suggested by @ADacidion and others in the thread
I do have a reworked video on my list just no ETA.
How can you set a GM account?? Do you have a list with some GM commands? :)
The best place to look for that is on the project's wiki page.
Hi! Thanks for the video. I'm having problems in the final part, cant login to the realmlist (i see the realm but is grayed out). Any idea of what can i do to solve this? Thx!
No problem! If your server and client are on the same machine then make sure your realmlist SQL table has 127.0.0.1 set. If the server is separate from the client machine then make sure the IP is correct in the realmlist table. The other thing is if you haven't rebooted yet then relaunch the server.
Thanks for the fast anwser@@Digital-Scriptorium !
I fix this problem redownloading the connection patcher from the GitHub link and reaplying the patch but running as administrator. (The IP address in the SQL table was a No-IP dns and in my Config.wtf my "SET realmlist" i'm using my local IP 192.x.x.x). Now everything is running smooth.
I hope this help if anyone have the same issue.
Thank you for sharing that info :)
@@sezantonio I've tried everything I can think of and I'm still running into the issue. The ips all match, it's calling to the correct IP, the client is 5.4.8 (18414), and I'm about to start pulling panda hair trying to figure this out. I even tried (knowing it probably wouldn't work) replacing all the IPs with my personal one... of course it didn't work. I don't know what else to try.
It's doing the realm offline thing?
Everything works fine, but raids cannot set difficulty and Immerseus isnt working
The project is very much still a work in progress but that team.
@@Digital-Scriptorium My guess is that is something in dbc, maps, vmaps, so I'll be generating mine
@@mjs1488 I believe it's database side functionality.
And is this working without bugs and glitches?
It's a fan project that is very much still in development. Since it's a small team of people working on it you will find broken stuff.
@@Digital-Scriptorium So I need to single player in MOP with bots to raiding. So, you told not everything working? mmm ;( My time ending... never mind... I hope ur project will be done well...;)
@@PastaLord-mg9ij it's still worth giving a shot but the people who develop the project are for sure a small group.
hey mate sorry to bother you but any chance you can point me in the direction of adding player bots to the game so i can do some dungeons, cheers mate
No worries! Unfortunately, the only projects I know of adding bots successfully are vmangos, cmangos, TrinityCore, and AzerothCore projects
@@Digital-Scriptorium allg mate, after installing mop from your video which was amazing btw, decided to follow your wotlk vid so i could add bots, all done and working now although having mop fucked me with heidisql and i couldnt seem to login to the wrath db i kept getting mop and just couldnt figure out how to get into wrath, even deleting heidi and mysql didnt help my pc forget mop haha, so i deleted mop, still had the same issue. fuck it so i reinstalled windows and then wrath, thanks alot for your videos mate, amazing stuff take care xx
No problem! Enjoy! :)
Found this video after I installed a skyfire server today, kind of "fun" that you can enter zones after wotlk content, but really.. there is absolutely no content in cata and later zones. Those npcs and mobs that should work, even in Stormwind and so on, they do not.. no waypoints for npcs or mobs or anything works.. Ironforge has lots of extra npcs that shouldn't be there, they are falling from the air and dropping down on the ground and so on and this is with version 24 of the DB. Lots of teleports aren't in place, so it is hard to visit zones after cata content.
Skyfire is ok if you want to visit zones and just see what it looked like back in the day.. but really, Skyfire isn't for playing the game. Even starting zones are really bad. I don't understand why they aren't working together with either TC or AC with database data, so the zones up to 80 will work good. I know there are changes from cata and onwards, but at least they should have a base to work further on - which doesn't seem to be the case.
Great video though, really in depth and could probably have saved me some time searching today, if I just watched it before installing the server 😂😋
Yeah, the project needs a good coat of paint for sure to get things in a good state.
youtube keeps deleting my comments, quite annoying. but i have an error because i am no using the older version of openSSL is there a fast fast way to fix this?
Sorry for the delay. Did you have any luck?
@@Digital-Scriptorium hello, and yes, there's a site with better repacks that doesn't require OpenSSL. BFA etc.
@@RommyTVx yes, the repacks do make things easier instead of a manual compile.
Sorry to again bug you :/ this has messed up a bit of my files i may have to start over again, all because OpenSSL 1.1.1W is no longer available :/ i wish there was a better way to do this
Sorry for the delay. Did you have any luck?
I can't connect musql 8
Getting into it with Heidisql?
Im at the point id pay you to get this running for me. i can get every other server going by watching your videos but for the life of me this one i can not.
I think some big changes happened recently that I need to check over. I'll give an update when I can.
14>C:\SkyFire_548\src\server\worldserver\Master.cpp(113,5): error C2653: 'OpenSSLCrypto': is not a class or namespace name
when i try to compile :(
Did you do a clean before the build?
@@Digital-Scriptorium Hello, I fix it. It was because I had a wrong version of openssl. Thank you for the tutorial, everything works accordingly.
@@hempsader1234 glad to hear it's all good now. Enjoy! :)
linux next please ty
Absolutely! I should have the Linux version up within 2 weeks.
Here ya go. ruclips.net/video/Ba4WzrC9tco/видео.html
@@Digital-Scriptorium thank you so much man
@@wh1t3lotus19 No problem! Enjoy!
After I was doing so well with your video when I went to launch the worldserver, it won't launch. I'm getting two errors one from doing your troubleshooting saying that Invalid or missing configuration file : worldserver.conf
Verify that the file exists and has '[worldserver]' written in the top of the file! and the DBError text file saying In mysql_stmt_prepare() id: 55, sql: "PÍ}ëõ"
Table 'characters.item_instance_transmog' doesn't exist
In mysql_stmt_prepare() id: 107, sql: "€-€ëõ"
Table 'characters.item_instance_transmog' doesn't exist
In mysql_stmt_prepare() id: 108, sql: "À ‚ëõ"
Table 'characters.item_instance_transmog' doesn't exist
In mysql_stmt_prepare() id: 109, sql: "0Gtëõ"
I dont have a clue what to do... please help!
It looks like the project jumped ship off of git and is using a new repository with lots of fixes. I need to try it out and see what needs to be changed in my guide. I'll let you know when I've tested it and what's changed.
@@Digital-Scriptorium I'm also interested in this solution
@@Digital-Scriptoriumthank you so much! I was doing so good too and looking forward to playing...
FYI I figured out the problem. You'll want to open HeidiSQL or the SQL manager of your choice. Select the "Characters" database. Then run a query with the following code from this URL: github.com/ProjectSkyfire/SkyFire_548/blob/095121ecf334bcd40c854a8b4a32c225931723c0/sql/updates/characters/2024_02_12_23_12_characters.sql
@@Digital-Scriptorium That worked. Thanks for the quick turn around