• Easy Guide --- Mangos 2.1.1-2.1.2 Server! •

[weaselking1973]

Aww man, could you please try and think what it could be?

sorry i dont do himachie (sp)

you will have to find someone familiary with it. dont use it I use static IP or no-ip or dynip.com

[regnar]

I was gonna use No-IP, but I don't know how to configure my router.

[weaselking1973]

you will ahve to configure your router for anyone to connect

[weaselking1973]

I have one problme i cant get Realmd.exe or mangos.exe to work i open then then they close how do i fix it?

go back and read the guide and start at the top

you haven't modified the config files

[faraon2k]

Hello, have had a mangos server up before and i did know how to fix this kind of problem before but now i really dont have any clue :/, i start up realmd and mangos but it shows up for 1 sec and popps down: sais like this in config from realmd:


2007-11-10 14:38:12 Verbinde zur Datenbank: 127.0.0.1;3306;root;[root];realmd
2007-11-10 14:38:12 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)
2007-11-10 14:38:12 ERROR:Cannot connect to database

And this from mangos:

2007-11-10 14:38:24 World Database: 127.0.0.1;3306;root;[root];mangos
2007-11-10 14:38:24 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)
2007-11-10 14:38:24 ERROR:Cannot connect to world database 127.0.0.1;3306;root;[root];mangos


Does someone know how to fix that? would be greatful if you would help me

[faraon2k]

And i have done this guide twice to fix the problem but its stuck to me

[weaselking1973]

are you running the MySQL?

its ether your SQL isn't running or you have the wrong password for the SQL database you created

[faraon2k]

Mate, i dont know hwo to run MySQL actually :/, sorry about that ^^. How do i run it?

[faraon2k]

The password is correct i know that. must be that SQL thing and i dont know how to run it :/

[weaselking1973]

Mate, i dont know hwo to run MySQL actually :/, sorry about that ^^. How do i run it?

this is the very first thing that needs to be done before you can run the server

http://www.mmowned.com/forums/emulat...l-picutre.html

best guide your find for starting it.

[sparts]

I got all the way up to where you run the Restarter. It starts and then it fails. I'm pretty sure I did everything right.
I look in the log and I think it is here ..

2007-11-10 23:31:05 ERROR:Error in `spell_proc_event` table, probably sql file format was updated (there should be 7 fields in sql).

Help?

[weaselking1973]

I got all the way up to where you run the Restarter. It starts and then it fails. I'm pretty sure I did everything right.
I look in the log and I think it is here ..

2007-11-10 23:31:05 ERROR:Error in `spell_proc_event` table, probably sql file format was updated (there should be 7 fields in sql).

Help?

dont run the restarter

just run the realmd.exe

then the mangos.exe

if you get errors post the server.txt and realms.txt

[faraon2k]

ive done everything over again and it still sais same message that it cant connect to the server :/, anything else i can do?

[Panchito]

Great guide How can I get things to attack me back though or using these private servers you can't fight just look cool?

[sparts]

Thank you for the help but now I can't get past the "Authenticating" stage or it says that the information is not valid. It switches between those two when I try to log on.

server.txt
2007-11-11 08:34:02 World Database: 127.0.0.1;3306;root;mangos;mangos
2007-11-11 08:34:02 Login Database: 127.0.0.1;3306;root;mangos;realmd
2007-11-11 08:34:02 Realm running as realm ID 1
2007-11-11 08:34:02 Using DataDir ./
2007-11-11 08:34:02 Initialize data stores...
2007-11-11 08:34:03
2007-11-11 08:34:03 >> Loaded 32 data stores
2007-11-11 08:34:03
2007-11-11 08:34:03 Cleaning up instances...
2007-11-11 08:34:03
2007-11-11 08:34:03 >> Initialized 0 instances, deleted 0 old instances
2007-11-11 08:34:03 Packing instances...
2007-11-11 08:34:03
2007-11-11 08:34:03 >> Instance numbers remapped, next instance id is 1
2007-11-11 08:34:03 Loading Game Object Templates...
2007-11-11 08:34:03 >> Loaded 11867 game object templates
2007-11-11 08:34:03
2007-11-11 08:34:03 Loading Spell Chain Data...
2007-11-11 08:34:03
2007-11-11 08:34:03 >> Loaded 1672 spell chain records
2007-11-11 08:34:03 Loading Spell Learn Skills...
2007-11-11 08:34:03
2007-11-11 08:34:03 >> Loaded 42 spell learn skills + found in DBC 74
2007-11-11 08:34:03 Loading Spell Learn Spells...
2007-11-11 08:34:03
2007-11-11 08:34:03 >> Loaded 38 spell learn spells + found in DBC 5927
2007-11-11 08:34:03 Loading Spell Proc Event conditions...
2007-11-11 08:34:03 ERROR:Error in `spell_proc_event` table, probably sql file format was updated (there should be 7 fields in sql).

realmd.txt
2007-11-11 08:37:24 Verbinde zur Datenbank: 127.0.0.1;3306;root;mangos;realmd
2007-11-11 08:37:24 Benutze Realm "Testing".
2007-11-11 08:37:24 Realmd prozess priorität HOCH
2007-11-11 08:37:24
2007-11-11 08:37:39 ERROR:SQL: SELECT `password`,`banned`,`locked`,`last_ip`,`online` FROM `account` WHERE `username` = 'SPARTS'
2007-11-11 08:37:39 ERROR:query ERROR: Unknown column 'password' in 'field list'

Thank you for help.