Creating Mangos Server

EDIT : Problem resolved ...

Quote:

---

Originally Posted by Ghostys

Hello Thanks for the guide is very good ...

My problem is that when I run mangos gives me two errors to show as follows ....

Using configuration file mangosd.conf.
MaNGOS daemon /0.10.0-SVN (Revision 5185) (Win32)
<Ctrl-C> to stop.


MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM MaNGOS community forums (Powered by Invision Power Board)
MMMMMM


World Database: localhost;3306;root;xxxxxxxxx;mangos
Connected to MySQL database at localhost

MySQL client library: 5.0.45
MySQL server ver: 5.0.41-community-nt
AUTOCOMMIT SUCCESSFULLY SET TO 1
Character Database: localhost;3306;root;xxxxxxxxx;characters
Connected to MySQL database at localhost

MySQL client library: 5.0.45
MySQL server ver: 5.0.41-community-nt
AUTOCOMMIT SUCCESSFULLY SET TO 1
Login Database: localhost;3306;root;xxxxxxxxx;realmd
Connected to MySQL database at localhost

MySQL client library: 5.0.45
MySQL server ver: 5.0.41-community-nt
AUTOCOMMIT SUCCESSFULLY SET TO 1
Realm running as realm ID 1
Using UDB 0.9.1 (335) with SD2 calls rev.233
Using DataDir ./
WORLD: VMap support included. LineOfSight:0, getHeight:0
WORLD: VMap data directory is: ./vmaps
WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapId
s, vmap.ignoreSpellIds

Loading MaNGOS strings...
SQL: SELECT `entry`,`content_default` FROM `mangos_string`
query ERROR: Table 'mangos.mangos_string' doesn't exist
==================================================== 100%
>> Loaded 0 mangos strings. DB table `mangos_string` is empty. Cannot continue.


What can I do, thank you expect answers soon .....

---

Im having the same problem. Ive check it over and over but as of yet not got a clue if its something Ive put in wrong. Any ideas thanks

For get this, I found the fix. I loaded the UDB for it which were wrong. All I did was to reload the files but this time the mangos.sql ones which came with the core files.

these problems that i'm seeing seem to be an issue with the udb. make sure you match the version that the udb is recommended for with the one you download!

i cant connect using localhost, 3306 ??? n sql

i need the 1.12.0 dbc files plz..can some1 upload on fileshare or something..

why do i get this on MySQL Error Code 2003 (10061) ???

im getting everything loading up fine but then "error in instance_template table, probably sql file format was updated (There should be 10 fields in sql)"

not to sure what is up with this
- trying some different versions of mangos
if anyone knows please say, cheers.

Quote:

---

Originally Posted by Josco

im getting everything loading up fine but then "error in instance_template table, probably sql file format was updated (There should be 10 fields in sql)"

---

I just got the exact same error. I went into mysql and checked the instance_template table, and it has ELEVEN fields.

Maybe we need an older UDB database.

I tried the next two older UDB cores and got even worse errors.

Ok, I might have fixed it. Although my server might die a fiery death, since I don't really know what I'm doing...

From a command prompt window (my mysql login and password are "root"):

Code:

---

C:\>mysql -uroot -proot

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 103 to server version: 5.0.27-community-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> connect mangos;
Connection id:    104
Current database: mangos

mysql> alter table instance_template drop parent;
Query OK, 49 rows affected (0.05 sec)
Records: 49  Duplicates: 0  Warnings: 0

mysql>quit;

---

If you know how to edit tables with SQLyog, feel free to alter the table and delete the "parent" column.

I got EnGB.. Ad.exe dont work.. :(

Download the GBmaps from the Internet...
Just search... ;-)

Well I setup the server with no problem but there is no NPC's no were. How do i fix this?

[post deleted, started new thread]

hey everything was working fine until the MySQL part where i have to connect to the MySQL host it keeps on saying Error No. 2003 Can't connect to MySQL server on '127.0.0.1' (10061) how can i fix this thanks!