Mangos One Datebase

[Auntie Mangos]

as UDB forums is down: http://getmangos.eu/community/post/132557/#p132557

this should give some information.

Everything about SD2 installation can be found on www.scriptdev2.com forums.

[Auntie Mangos]

as UDB forums is down: http://getmangos.eu/community/post/132557/#p132557

this should give some information.

Everything about SD2 installation can be found on www.scriptdev2.com forums.

Nice, thanks for first link. But I registered at sd2 forum and dont get a confirmation.

[Leandros99]

Hi,

where I get a Mangos-One DB?

Someone said, that I can use the same scriptdev2, can I use the same db's, too? (The same means the 3.3.5a which are in the tutorial)

[lillecarl]

Mangos 1st page: Looking for client 2.4.3 support? The official mangos one repository contains code compatible with client 2.4.3. A matching database is provided by the TBC-DB project, and scriptdev2 includes a custom patch for compatibility with mangos one.

[Leandros99]

I read this, but in Sourceforge TBC-DB are no files. Can I use "git clone git://github.com/scriptdev2/scriptdev2.git src/bindings/ScriptDev2/" for mangos one?

[Leandros99]

Hey,

hope you can help me 3rd time.

I installed Mangos One via git rep (git://github.com/mangos/one.git), with scriptdev2 via git rep (git://github.com/scriptdev2/scriptdev2.git) and with the TBCDB as world db. The other db's (e.g realm, characters and so on) have I created in the same way what I have done with 3.3.5a (followed the tutorial).

If I start mangosd I get this.

Using configuration file /home/mangos/mangos-server/etc/mangosd.conf.

OpenSSL 0.9.8o 01 Jun 2010 (Library: OpenSSL 0.9.8o 01 Jun 2010)

Using ACE: 5.8.3

World Database: 127.0.0.1;3306;mangos;mangos;mangos, total connections: 2

Connected to MySQL database at 127.0.0.1

MySQL client library: 5.1.49

MySQL server ver: 5.1.49-3

AUTOCOMMIT SUCCESSFULLY SET TO 1

[0 ms] SQL: SET NAMES `utf8`

[0 ms] SQL: SET CHARACTER SET `utf8`

Connected to MySQL database at 127.0.0.1

MySQL client library: 5.1.49

MySQL server ver: 5.1.49-3

AUTOCOMMIT SUCCESSFULLY SET TO 1

[0 ms] SQL: SET NAMES `utf8`

[0 ms] SQL: SET CHARACTER SET `utf8`

SQL: SELECT required_s1329_11679_01_mangos_spell_proc_event FROM db_version LIMIT 1

query ERROR: Unknown column 'required_s1329_11679_01_mangos_spell_proc_event' in 'field list'

[0 ms] SQL: SELECT * FROM db_version LIMIT 1

The table `db_version` in your [WORLD] database indicates that this database is out of date!

A You have: --> `s1130_11348_01_mangos_spell_bonus_data.sql`

B You need: --> `s1329_11679_01_mangos_spell_proc_event.sql`

You must apply all updates after A to B to use mangos with this database.

These updates are included in the sql/updates folder.

Please read the included [README] in sql/updates for instructions on updating.

How can I update? In the tutorial are only the way for udb, and I dont have udb, or?^^

[Leandros99]

deleted

[lillecarl]

Just to point out that about the TBC-DB here is a tarball link:

http://tbc-db.svn.sourceforge.net/viewvc/tbc-db/?view=tar

EDIT: Your database is more up to date then your core, do a git pull

- LilleCarl

[Leandros99]

I have used the db from this tarball

I use from the archive the 1.1.0 Full_DB as my world db.

I pulled the core from mangos one git rep. With "git clone git://github.com/mangos/one.git". I thought this is the latest core ...

Edit: I pulled from mangos one, this is what I got:

git pull git://github.com/mangos/one.git master

From git://github.com/mangos/one

* branch master -> FETCH_HEAD

Already up-to-date.

[lillecarl]

Oooops i read wrong

You need to import all updates in the mangosonerepo/sql/updates from A to B (import the one AFTER a then all to (and including b)

A You have: --> `s1130_11348_01_mangos_spell_bonus_data.sql`

B You need: --> `s1329_11679_01_mangos_spell_proc_event.sql`

[Leandros99]

How? In the world db?

[lillecarl]

yes

[Leandros99]

Done. It starts, but my WoW stuck at "connect" ...

[lillecarl]

Thats because you have not added the realm to the realmlist table in the realmd database

[Leandros99]

I added it, DB realmd.realmlist

everything is set. RealmID is the same as in the config.

Edit: I checked every config file, and dont get it why it wont work. My friend, too.

I have forwarded ports, but It seems it dont work ..

[lillecarl]

Where are you hosting?

[Leandros99]

I own an root server (2x Intel Xeon, 32 GB RAM and 2x 1 TB Raid 1 HDD's), running Debian 6.0.1. Located in a servercenter. I installed the Server on this machine. IPtables are configured. Port 3724. But I cant connect, I think I have to free a second port, but which?

[lillecarl]

print me the /proc/cpuinfo then ill belive in you, anyways, to access the realmlist you need to open 3724, to access the worlserver default is 8085 i think (its in the realmlist table)

Also wich server center i know vpsland have blocked wow traffic for some reason, but please gimme a print of top, htop and /proc/cpuinfo also free -m

- LilleCarl

[Leandros99]

Its a german servercenter, I rented the server @ www.hetzner.de. And I made a mistake, its an i7-950, not xeons. The xeons are the other server. To much servers here. (If you not trust me, I can give you an htop and cpuinfo from this server, too.)

processor : 0

vendor_id : GenuineIntel

cpu family : 6

model : 26

model name : Intel® Core i7 CPU 950 @ 3.07GHz

stepping : 5

cpu MHz : 1600.000

cache size : 8192 KB

physical id : 0

siblings : 8

core id : 0

cpu cores : 4

apicid : 0

initial apicid : 0

fpu : yes

fpu_exception : yes

cpuid level : 11

wp : yes

flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni dtes64 monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm ida tpr_shadow vnmi flexpriority ept vpid

bogomips : 6148.04

clflush size : 64

cache_alignment : 64

address sizes : 36 bits physical, 48 bits virtual

power management:

(not the whole cpuinfo. Only 1 core. )

total used free shared buffers cached

Mem: 7998 5612 2385 0 628 3492

-/+ buffers/cache: 1492 6506

Swap: 2053 11 2041

I cant provide you an htop, because on this server are sensible datas and htop is to much information. sorry.

Edit: My Xeon

processor : 0

vendor_id : GenuineIntel

cpu family : 6

model : 7

model name : Intel® Xeon® CPU L5240 @ 3.00GHz

stepping : 6

cpu MHz : 3000.011

cache size : 6144 KB

physical id : 0

siblings : 2

core id : 0

cpu cores : 2

fpu : yes

fpu_exception : yes

cpuid level : 10

wp : yes

flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall lm pni monitor ds_cpl est tm2 cx16 xtpr

bogomips : 6004.01

clflush size : 64

cache_alignment : 64

address sizes : 38 bits physical, 48 bits virtual

power management:

[lillecarl]

That costs alot well i could try to help you more laters

[Leandros99]

Nah, I make money with this.

[lillecarl]

Nah, I make money with this.

May i ask what you are doing more? If its personal there is no need at all that you answer, do you have any instant messaging app? Or irc or such, then i can assist you further i think

- LilleCarl

[Leandros99]

Nah, I make money with this.

May i ask what you are doing more? If its personal there is no need at all that you answer, do you have any instant messaging app? Or irc or such, then i can assist you further i think

- LilleCarl

Do you have Skype? Add me Leandros9999