For any kind Apache/SQL aficionado out there - HELP!

[freewotlk]

Well I am posting here in hopes that some kind, knowledgable person, might help me troubleshoot my recent server updates.

I did have my support questions going in a thread on ac -web, but for some reason my last post said "needs to be approved by admin" so who knows how long that might take. Plus I know there are some very skilled people here that might be able to figure this one out.

Before someone shouts "ITS A REPACK WE DON'T DO THOSE YOU CRAZY IDIOT WHO CANT COMPILE THINGS >:O !!" for whatever your die-hard reason might be ..... please just hear my question, as it does not really pertain to anything related to the repack, but more about MySQL and Apache in general. I will mention some things about the repack so you have some history to understand the question though.

If it is important to know specifically, I am working with a trinity repack called Jeuties Blizzlike Repack and use FusionCMS as the website system for this repack/server. I was attempting to update the repack.

Below I will first list posts I had made on the other forum to get anyone up to speed on the matter, so that they can understand my current situation better. Again, I understand some of it does touch on repack related issues, but the END question I have now come down to, is not repack related; it is Apache/SQL based.

---

Post 1) - Updating Jeuties Blizzlike Repack

Hello Everyone! I hope someone will be able to point me in the right direction on this one, as I really think I did everything right and was expecting there to be no problems

I was updating from 9.7.4 to 9.8.1

I did everything as I should and executed each update correctly in sequence.
My auth server starts up fine but the World server will crash saying:

[1054] Unknown column 'Id' in 'Field list'
Your database structure is not up to date Please make sure you've executed all queries in the sql/updates folders.

Please Helpssss

Just to show everyone my thought process I made a checklist while going through executing the updates, as I noticed there was not necessarily an update for char and auth per repack revision number. So, if I marked [No] for does update exist, it means there wasnt an sql update for this and I jumpped to executing the update below it.

My update sequence checklist

For Characters

Does update exist_____________update name________Now "current revision"
[Yes]__________________9.7.4_characters_db.sql________.5
[ No]__________________9.7.5_characters_db.sql________.6
[Yes]__________________9.7.6_characters_db.sql________.7
[Yes]__________________9.7.7_characters_db.sql________.8
[ No]__________________9.7.8_characters_db.sql_________.9
[Yes]__________________9.7.9_characters_db.sql_______8.0
[Yes]__________________9.8.0_characters_db.sql_______8.1

For Auth

Does update exist_____________update name________Now "current revision"
[ No]__________________9.7.4_auth_db.sql________.5
[Yes]__________________9.7.5_auth_db.sql________.6
[Yes]__________________9.7.6_auth_db.sql________.7
[Yes]__________________9.7.7_auth_db.sql________.8
[ No]__________________9.7.8_auth_db.sql_________.9
[Yes]__________________9.7.9_auth_db.sql_______8.0
[ No]__________________9.8.0_auth_db.sql_______8.1

---

Post 2) - Found a solution, but create website problem.

To further explain my above problem to any one knowledgeable in the field I have manipulated some things and found a solution to the original problem, but that creates another, perhaps more simple problem that someone on here could more likely help me overcome.

My setup:

• Home based cpu running both a fusioncms website and the wow server all in one (such that I have the usual databases auth, char etc + fusion_cms used for the website)
• Run Apache and MySQL through Xampp

Originally would receive the [1054] Unknown column 'Id' in 'Field list' error when I would try to run the worldserver on the setup as it was (Apache and MySQL through xampp).

Just to try things out I decided to, (using the exact same autch char database that originally threw the 'Id' error) run the "all in one" mysql provided in the repack 9.8.1. and What do you know the world server runs just fine :P

So, my logic?
Well ditch xampp and just use the provided Apache and MySQL services in the Jeuties Blizzlike Repack 9.8.1/Server folder.


Moving the fusioncms website over to repack www folder:

Copy contents of htdocs folder from xampp and place --------> into Jeuties Blizzlike Repack 9.8.1/Server/www
**I am sure to edit all requirements FusionCMS needs in the Apache httpd.conf file, which are to enable:

• mod_rewrite
• mod_headers
• mod_expires
• mod_deflate

and in the php.ini file

• php_curl
• php_openssl
• php_soap
• php_gd2

Everything should be good now, am sure xamp apache and sql services are off, launch provided MySQL, Apache, and go ahead with auth server and world server.

--> Go to website on localhost and have error

"Unable to connect to your database server using the provided settings.
Filename: C:\Users\Gerald\Desktop\Jeuties Blizzlike Repack 9.8.1\Server\www\system\database\DB_driver.php
Line Number: 124"

--> Go to localhost/debug.php and find

Testing your server connections...

MySQL connection to CMS database could not be established: Access denied for user 'fusion'@'localhost' (using password: YES)

Does any repack sql/apache / fusioncsm aficionado know what I should do next?


Current Situation:
MySQL work from repack: ✓
apache/fusioncms website work from repack: ✖

[freewotlk]

Pertaining to the above listed problem. Where the MySQL connection is giving an error I MIGHT have a clue as to what is behind it, but need someone with better knowledge of the "art" to interpret this.

Usually all database usernames involved with any of this are: root and password: ascent


Well I noticed something.
Check this out.

Go in with navicat to examine the database in its original state (running back on xampp) to look into the fusion_cms database and poke around for password info, as the error ( Access denied for user 'fusion'@'localhost' (using password: YES) ) seems to pertain to that.

Here is what I find on my journey in.
(using pictures to really help clear up things for anyone wanting to try and help)
1)
2)
3)
4)

Interesting.... There is some 8 character password... I don't know if this is an issue at all. But perhaps some file somewhere expects fusion db to use the same generic password: ascent ?

Does anyone know if this is potentially the problem / what that 8 key password would be? Was it auto generated from fusionCMS install?


Again I know this likely wont get many replies as the help needed here is kind of specalized for those familiar with the fusionCMS website stuff, but you people are very bright, you never know what might happen! Thanks!

[freewotlk]

Problem solved!

All services are up and running and are viewable at Frozenwow.net if you are curious.

I want to share how I ended up fixing it for anyone else that might encounter the same problem

To sum it up real fast here is what happened.
Setup:

• Was running Apache and MySQL through xampp.

I eventually discovered that, (though this appeared to be a database related issue, given the whole 'ID' field thing on the worldserver.exe) if I ran the MySQL through the "all in one" mysql provided with the repack that the worldserver.exe would startup just fine with no errors (using the same DB that previously threw errors).


But there was a trade-off, if I moved content previously from the xampp MySQL to the repack version, and did the same for the Apache (move xampp apache htdocs content to repack: server/www directory) that the website would no longer function.

So in the end I had to split services. Xampp runs the Apache and MySQL is provided through the repack version.


That description of the fix IS GREATLY OVERSIMPLIFIED. ---> If you are in the same position and are like "but I'm getting all these errors trying to separate the services like that" here is my tip to try and help out.

The main trouble you will encounter is that, unlike the auth and character databases which you can recreate easily in navicat by loading the previously dumped sql files, the fusion_cms website database will not work this same way. You will have troubles establishing the DB and then getting the site to connect with it.
There was some process/order which was a combination of the following that eventually worked: a drag and drop transfer of the xamp www/mysql/data/fusion_cms content into the newly established repack Server/MySQL/data/fusion_cms , the execution of previously dumped sql file, and some weird specific editing of user permissions/atributes in navicat (for fusion@localhost), which eventually worked.

Again those sound like 3 basic steps, but it was a specific order of doing them like 1/40 tries that eventually made everything come to life.



Hopefully this will help someone else as well!