Noaru

So a bunch of friends are saying that 90% of instances don't work on the server i've setup, but I have set it up with SD2, and ACID. Is there something else I'm missing?

Okay I'm not sure if this is a core-bug or DB-bug so please do tell me if I am incorrect in posting this here. Apparently one of my friends was testing out Ice Crown Citadel and said that they cannot get into it unless they are level 90, is this true, or not? I'm using PSDB.

I think I figured out what it was, two of my GMs were messing around apparently and some boss spawned many, many, MANY minions and it got laggey, and crashed.

Hello I was wondering if anyone could help me sift through this crash report, i'm not sure what caused it so I'd be very grateful if someone could help me find the source of it.

http://pastebin.com/H1JVJCCP

Seems like the project is dead, can we get some clarification or /lock the topic? oO

Architecture is different for VPS types. For example, with XEN you can use Swap Memory/Page File, which writes some things in active RAM to the HDD space, however for something like OpenVZ you only utilize what memory you are given.

I said nothing about making a public or private server at all, I'm trying to figure out a good server for mangos to set on for semi-best performance. Also 1. people make public Mangos servers a lot, and 2. a part of testing mangos for educational usage is to gather statistic information on running it in a server environment.

So I'm curious, starting out i'm pretty much thinking about getting a VPS. But the thing is, and if those of you who have hosting and hosting on a VPS plz help me on this. Is it best to go with a VPS which uses Swap/Page File memory than one that doesn't? e.g. XEN Architecture as opposed to OpenVZ.

but I thought the SQL files for characters and realmD would be empty, the only thing which would be filled would be the World database.

I should be able to use the Characters and RealmD supplied with the raw files correct? Rather than using the two supplied with something like UDB. and go from there using UDB's World DB and updating it from the raw files, correct? as opposed to use both RealmD and Characters DB from UDB and updating EVERYTHING up to the current version?

So I was wondering how I could compile Mangos w/ the Extra areas like the Emerald Dream and the weird Island, I think it was the original GM island... something like that, i'm not entirely sure how to do that... And... any advice on a working hacking prevention system?

I thought about changing the hosts file and i'm not sure if it'd work correctly I could try but not 100% sure. And I did think about taking away the primary key for the realm ID so they both point to "1". Not sure which one to really test, any recommendations on the best method?

Also what would I enter if I were to change a Windows host file?

Can you post additional information,

1) ports you have forwarded on your router

2) type of router (if its similar to any of the ones of I've dealt with at home and work, I may be able to help)

2) records in your realmd.realmlist table

3) the lines in your mangos.conf and realmd.conf, specifically BindIP and Port lines

I was going to suggest reading the guide on setting up mangos for intranet and internet use, but it sounds like you may have done so already

Well, I have had the ports in the Database (8085) and everything from the config files, (inc SQL DB), forwarded.

However the system which I have it on is being DMZ Hosted and therefore is outside the firewall and should not need Port Forwarding. (in addition it has no software layer firewall enabled)

There were two records in the realmlist table:

ID|name|address|port|icon|realmflags|timezone|allowedSecurityLevel|poulation|realmbuilds|

1|Twilight|EXTERNAL IP|8085|0|2|0|0|0.02| |

2|DEV|192.168.0.3|8085|0|2|0|0|0.02| |

I also changed #2's port from 8085 to 8086 and still nothing worked or showed up.

The lines in the configuration files are mostly the same except for the SQL Passwords and users. The Bind IP is also set to 0.0.0.0

I've read numerous guides inc the one on setting up for hosting behind a router.

The Router I'm using is "Actiontec M1000", doesn't support NAT Loopback, i.e. cannot access the External IP from that router unless using a Proxy.

Hello I'm having some issues trying to connect to my server, I'm trying to set it up so I can login locally, and have other people login externally from outside my local network. However I'm having some issues, I cannot seem to login on both sides. I.e. If I set it up so I log in, no one can connect externally, and if I set it up externally, I can't login (locally). Apparently my Router doesn't support NAT Loopback, but I thought there's a work around this entire issue some where. I even tried making two realms on the realmlist and having my External IP and Local IP set up so that I can login one way and external users can login their way, however neither of those tend to work. Where if I set it up with my Local IP (first listed server) then second is external IP address, only I can login. Then if I have that reversed where the external IP is first and the local IP is second, only external access is permitted while the second realm (local) doesn't show up at all. So I hope you can understand all this, I've tried this many many ways, and with no success.

Note: My server is DMZ-ed so, no PF needed and the Server is also on another computer on my network so, no localhost/127.0.0.1 confusion.

My opinion would be that you have wasted your money on a quadcore that could have been better spend on extra RAM. Unless you use the multithreading patch your server will only be able to use 25% of the available CPU power, yet on the other hand, 2Gb ram is not enough to run a server without grid_unload.

Good performance is a matter of finding bottlenecks and adequate resources for the task. I could use a supercomputer to run WoW yet get less performance than a netbook, or run a server with 16Gb RAM, a 4Ghz CPU and a PATA hard disk and it'd still take half a year to start. And even with all the hardware details there could still be a lot of other issues: older MySQL versions for example used to run terrible slow on a SUN Fire X series server. By far the best way to know how much your server can support is to simply use it and see. Mangos does quite well on normal hardware, anything under a 1000 users should run just fine on whatever regular machine you throw at it.

Actually it's a VPS for the price of a regular WoW Subscription by multithreading patch do you mean on compiling where you specify the cores? I believe we're using the grid_unload feature.

Okay, what would your "expert" opinion be if I'm using a server with... 2 GB RAM... 3.1 x4 GHZ Quad Core Processors? On a Linux Distro of Ubuntu.

try this

diff --git a/src/game/Level2.cpp b/src/game/Level2.cpp
index ca2cc96..c349554 100644
--- a/src/game/Level2.cpp
+++ b/src/game/Level2.cpp
@@ -2160,8 +2160,9 @@ bool ChatHandler::HandlePInfoCommand(const char* args)
    std::string last_ip = GetMangosString(LANG_ERROR);
    uint32 security = 0;
    std::string last_login = GetMangosString(LANG_ERROR);
+    std::string email = GetMangosString(LANG_ERROR);

-    QueryResult* result = loginDatabase.PQuery("SELECT username,gmlevel,last_ip,last_login FROM account WHERE id = '%u'",accId);
+    QueryResult* result = loginDatabase.PQuery("SELECT username,gmlevel,last_ip,last_login,email FROM account WHERE id = '%u'",accId);
    if(result)
    {
        Field* fields = result->Fetch();
@@ -2178,13 +2179,15 @@ bool ChatHandler::HandlePInfoCommand(const char* args)
            last_ip = "-";
            last_login = "-";
        }
+        
+        email = fields[4].GetCppString();

        delete result;
    }

    std::string nameLink = playerLink(target_name);

-    PSendSysMessage(LANG_PINFO_ACCOUNT, (target?"":GetMangosString(LANG_OFFLINE)), nameLink.c_str(), GUID_LOPART(target_guid), username.c_str(), accId, security, last_ip.c_str(), last_login.c_str(), latency);
+    PSendSysMessage(LANG_PINFO_ACCOUNT, (target?"":GetMangosString(LANG_OFFLINE)), nameLink.c_str(), GUID_LOPART(target_guid), username.c_str(), accId, email.c_str(), security, last_ip.c_str(), last_login.c_str(), latency);

    std::string timeStr = secsToTimeString(total_player_time,true,true);
    uint32 gold = money /GOLD;

sql:

delete from `mangos_string` where `entry` = '548';
insert into `mangos_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) values('548','Player%s %s (guid: %u) Account: %s (id: %u) E-mail: %s GMLevel: %u Last IP: %s Last login: %s Latency: %ums',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

Where would we implement that in? (I get the SQL part.)

/noob (sorry Q_Q )

i'm not 100% sure, but may it be, that the .pinfo command displays it?

Nopes

Tried that already

Is there anyway to retrieve someone's registered account email using a GM Command? (w/o looking Directly in the database...)

Ah so there really isn't an average... So I'm guessing if someone has a pretty balanced system, it can hold up to a decent number of people.

The reason I decided to post this question was to take a live statistic of how things are going within the current revision. Some are outdated and some are just a couple of posts with rampant variables, so I want to try and get some hard statistics. Yes I have used the search button, however every answer I find is very large, or small, and isn't conclusive, so I need to find an average and pattern.

Hello! I have a couple of questions!

How much RAM does Mangos usually use for a typical server?

How many people has mangos, been able to hold? (general majority)

Well that's it for starters, just collecting some simple information. ^^,

okay the directory listings are re-done but now I get this error:

./mangos-realmd: error while loading shared libraries: libACE-5.6.6.so: cannot open shared object file

is there anyway to... make it so they use shared object files?

when I do my list, the files it's talking about look weird...

I get an error like this:

./mangos-realmd: error while loading shared libraries: libACE-5.6.6.so: cannot open shared object file

when the file is infact in the main directory of my Mangos Server, are they suppose to be in a sub directory? (the lib files)