[[3.3.5a] Logger and Appender question]

Hello everyone.

I would like to ask you something about Appender and Logger configurations.

I'm trying to log Arenas into database, so I can pull statistics and other analyze queries.

I have the following configurations at the moment:

Appender.Arenas=3,2,1

Logger.bg.arena=2,Arenas

Do I have to setup any other configurations?

Thanks.

 

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

I think you're missing some updates. Some table are changed.

 

column 'equipment_id' is obsolete.

[Random TrinityCore ideas]

Arena Logs into DB table, so with this we can generate detailed statistic on website. Like dmg/killing blows/heals.

This will help to catch some arena "alters".

 

Or arena spectator implementation.

[Random TrinityCore ideas]

Hi.

Is there way to complete some quest via RA console? I try it but there is no command like this in RA.

Like: .quest complete <QuestId> <PlayerName>

 

This will be more hard to implement because difference of quest (spellclick/kills/collected items/explore etc..)

[Compile or cmake problems]

What can I say

You need at least 1Gb ram + 2Gb Swap or more.

See attached picture.

I think, this isn't a bad idea to mention this in the wiki.

Zaranthos, thanks again mate.

[Compile or cmake problems]

Depends entirely on how you configure your server. That hardware should work for what you want to do but if you're running out of memory you'll need to increase your swap or reduce the system memory usage by running less processes/applications or tweaking your configuration so stuff like MySQL uses less memory. Not sure if Ubuntu is too much of a hog for that little RAM though. Maybe.

Thanks,

I will try to increase swap space. There is no other process on the machine. Only mysql server + ssh. (I exclude the OS processes).

I'll post result later.

[Compile or cmake problems]

I have a small server for test and experiments that have 1 Gb ram and 1 Gb swap.

When I try to compile the last trinity core I get this error:

[ 98%] Built target pch_Generate_worldserver

Linking CXX executable worldserver

collect2: ld terminated with signal 9 [Killed]

make[2]: *** [src/server/worldserver/worldserver] Error 1

make[1]: *** [src/server/worldserver/CMakeFiles/worldserver.dir/all] Error 2

make: *** [all] Error 2

In dmesg:

[ 4647.534122] Out of memory: Kill process 7016 (ld) score 921 or sacrifice child

[ 4647.534183] Killed process 7016 (ld) total-vm:1907404kB, anon-rss:902576kB, file-rss:24kB

[ 5186.478073] mysqld invoked oom-killer: gfp_mask=0x201da, order=0, oom_adj=0, oom_score_adj=0

The server is Ubuntu Server 12.04 LTS

gcc version 4.6.3 (Ubuntu/Linaro 4.6.3-1ubuntu5)

GNU ld (GNU Binutils for Ubuntu) 2.22

How much memory I need for test server with 1-2 players?