Mangos and Navicat

[Stalvros]

Ok i didnt sleep for 28 hours now cause i had trouble configuring this server :(

its like sooo hard~

basically what happened is that im using Azzum v1.0 repack
did all the instructions correctly

UNTIL i had to open Mangos Database handler
you know the part where you're supposed to put your username and password and click 'save' ?

After i click save, it just states;

Your configuration file is wrong, modify your options...
#42S02Table 'mangos.item_loot_template' doesnt exist

i dont know waht i did wrong -_-
Can anyone help me in this?

Also, id like to ask one more thing~
Is there any way to change your SQL username?
I dont see the option anywhere~
Only changing password but what about username?

[MentaL]

[Anshar]

You must not have executed the batch file in the mangos database. Or whatever sql you used didn't have the right tables.

[Stalvros]

i executed it
both on mangus and realmd as suggested

still doesnt work~
and i used the tables which are provided~
unless you could provide me with a better one?

alright now its fixed

it asks me now to

Step 4 - Configure Website in Navicat
I - Open Navicat
II - Batch the 4 files from sql_install_tables in your website directory (unzip the zipped file)(Thank you Takeshy for
bringing that to my attention)

how do you do step II?
batch to what?

[Takeshy]

alright now its fixed

it asks me now to

Step 4 - Configure Website in Navicat
I - Open Navicat
II - Batch the 4 files from sql_install_tables in your website directory (unzip the zipped file)(Thank you Takeshy for
bringing that to my attention)

how do you do step II?
batch to what?

You should have downloaded a mangos_si.rar file (or other website package).
Within that package, you should find some .sql files to add to your realmd database in Navicat :)

You might get a problem with one of them though - I did. I think it was "zone_coordinates", just ignore it and all works fine.

Once you have done that you then just add the website folder (complete contents) to your "htdocs" folder in your "xampp" directory :) I never bothered with the vhost configuration file.

[Stalvros]

yep i got it right~
now its up and running thanks

but now i cant even login to my own server -_-