antiroot

Do you have any custom patches applied? and when you recompile make sure to clean your build directory first

Good idea for a topic Toinan67, nice way to get to know the community and contributors! I only recently became familiar with MaNGOS in the beginning of this year, mainly as a way for my brother and I to work on a project together and just have fun learning and messing around with everything that goes into MaNGOS making custom adventures/patches/etc. We've always enjoyed playing MMORPGs together since I've moved half way across the United States a couple years ago, but MaNGOS lets us build our own world with no limits. Aside from my intro to how I discovered MaNGOS, I'm an IT Systems Administrator for two companies one local and one international. Went to college for Electrical Engineering, Web Applications Development, and Cisco Networking Academy. During my free time I build and prototype electronics for myself and others, after 2 years I finally have a complete electronics lab! Ironically MaNGOS is not only helping learn new tricks in server world, but also with electronics because I often use C when programming microcontrollers (when I'm too lazy to use assembly ) and I have learned new and different ways to accomplish tasks that sometimes would run too slow on a 4-20mhz computer Also I'm curious what kind of servers people are using with MaNGOS. I for one use FreeBSD, however I build/experiment with MaNGOS within a FreeBSD Jail. Runs just like a real system but there are a few things I've run into that most users have not due to the nature of jails. 1.8ghz single core, 1GB RAM, I know not quite as high as people trying to maintain a 3000+ user server, but my server is only for learning purposes for my brother and I and it seems to do the job very nicely

What kind of patch are you trying to apply, if this is a patch made using "git" than you can use (change the patch path/name to match your patch) git apply /path/to/patchname.patch or with a scriptdev patch you use (change the patch path/name to match your patch) git am /path/to/scriptdev2.patch There are other ways to apply different types of patches, but they depend on the type of patch you are trying to use. Note that to apply patches this implies you have the MaNGOS source code and you are compiling everything yourself. You cannot apply a patch to a repack, repacks are not supported here

Add a mysql user that uses host % to connect, and that this user has access to select/update on the tables you need to access remotely. As far as adding a script somewhere that will update your server, this is a slight security flaw giving mysql access to internet bound users, but basically allow access to the port mysql listens on and use a remote server to send the mysql queries to your server. However if your server is able to handle MaNGOS + MySQL it should be plenty fast enough to handle a single query to the database to add a user.

Do you have your realmlists configured correctly? 1) Your client's realmlist.wtf file 2) your server's MySQL Database realmd.realmlist 3) on your server set RealmID to match your database entry, and Bind IP to 0.0.0.0 in your mangos.conf file By default you will have a realmlist entry in your database set with address 127.0.0.1 you will need to change this to an address accessible by your client, your server's LAN IP if you client is on the same local network

Well I see that I have my awesome rank back, but looking at a handful of threads none of the other Donators have ranks, not even their Donator rank is displayed. Was this an unexpected bug? Otherwise I feel very unique having the Orange nickname and a rank when no one else does lol Edit: Actually a couple other donators have ranks now @TheLuda are you having to change records manually to update all the donators? If so you are a very dedicated person, thanks for your efforts!

Ha good point there, I in fact rather have my "Is it an apple?" rank and blue name rather than just saying "Donator", but maybe some people think of donating like buying stock in a company and they want the Donator status so everyone else knows that they "own" 1/10,000 of the project lol I for one only donated because I want to see this community continue to thrive, and not go out in a small poof of smoke leaving us with other projects that aren't up to par with the quality of MaNGOS

I've donated little bits and pieces of code and knowledge in the past, but maybe a financial donation is in order this time. I know all too well that the fees that come with hosting and maintaining a project/community like this is can add up very quickly so I've sent $20.00 USD your way, hope this helps with next month's bills. Thanks for the awesome project/community/learning experience

As FragFrog touched on briefly, using a firewall would do this. If there's a router between MaNGOS and the webhost that supports this than perfect. Otherwise on your MaNGOS server you can configure its firewall to do so. Windows Firewall in Windows (obviously) iptables/ipfw/pf in *nix A Firewall based filter would be much easier to create than doing a VPN, especially if you don't have direct access of your webserver in order to configure its end of the VPN

Only thing I can comment on is that you should have two functions handeling SOAP ExecuteSoapCommand() and also ConnectToSoap() or something similar, your current ExecuteSoapCommand() function creates a new SOAP connection everytime it is called, however this is not needed and is wasting resources. Instead ConnectToSoap() would connect to SOAP one time and then ExecuteSoapCommand() should execute the commands only on the connected socket resource. This makes sense if you use ExecuteSoapCommand 2 or more times on the same PHP script. Think about MySQL + PHP, if you can have 1 query to do a task as opposed to 3 queries, which one makes more sense in terms of efficiency. Otherwise nice contribution, I really like the logging/debug portion

by external do you mean an address of one of the interfaces on the server or an address outside the server. SOAP will bind to any address that the server "owns" for example my server's LAN address is 192.168.1.50 soap can bind to 127.0.0.1, 0.0.0.0, 192.168.1.50 all without crash An address that the server does not "own" (again using my example) 192.168.1.51 will crash because the server doesn't not have this address, so it can not bind to it This is using the following configurations if your interested SOAP.Enabled = 1 SOAP.IP = 192.168.1.50 SOAP.Port = 7878

when you use git to fetch the newest mangos source theres a folder called contrib that has the exectuables in their appropiate sub folders, the updates will be in a folder called sql/updates/ for example after you do the following cd ~ git clone http://github.com/mangos/mangos.git cd ~/mangos/ from here you will find contrib at ~/mangos/contrib and sql update at ~/mangos/sql/updates

Not to keep this topic going but there's a wiki page on getmangos.eu describing Hosting Behind a Router which explains exactly how to do this, however from what Darkruler stated if we're not allowed to do it on the forums at getmangos.eu, is that wiki page allowed to exist? Not trying to make anyone mad by suggesting that it be removed, but its contradicting to have a wiki page and then say we can't repeat the same info on the forums on the same domain/organization

PSDB is an alternate worlddatabase, so even tho its not UDB you do have a world database installed So all you need to to do is download/compile a new core (if you have not done so yet) and apply the sql updates to get the database upto date.. If you still need the source for the new core go with revision 10155 like i said in my second post since scriptdev2 has not caught up with the changes yet (hopefully they will in a day or two)

The whole guide is for installing a brandnew fresh server, however parts of it can be used for updating. which if you already have UDB+scriptdev2 in your database than all you need to do is apply your mangos patches until you are at the correct version Theres a collumn in mangos.db_version that tells you which version your database has, just keep applying your sql updates until its correct Edit: From your second post in this thread i assumed you had the current core compiled and you were only needing the data files, did you compile a new core or do you still need to do that?

Oh shoot i need to go over the forum guidelines and rules again SORRY for my post as well

The ad.exe and other executables are pre-compiled for windows and you will not need to to compile them yourself. You can download the files from your server to your client or from the git repository to your client. The rest of that sounds like you understand what you need to do. Just make sure to copy the folders in to your MaNGOS Data directory Edit: Using Filezilla in SFTP mode would be an easy way to get the executable files from your server to your client, and then also be able to push the newly generated files/directories from your client onto the server

[self-Censored] sorry for the post. This post did not describe how to do anything, only general theory of networking, however I have erased my post just so I don't cross any lines

That part is done on your client computer not the server. In the MaNGOS repository theres a directory called contrib which has the files you need. You need to place the ad.exe, vmapextract_v2.exe, vmap_assembler.exe, splitConfig.txt, makevmaps_SIMPLE.bat files in your game client's installation folder and execute ad.exe and makevmaps_SIMPLE.bat Afterwards you will have directories named dbc, vmaps, maps you will need to copy these new directories to your MaNGOS server's data directory Edit: I'm only posting this info because you said your server is remote, and some of the guides don't clearly tell you that you these files MUST be generated on the client not the server Edit 2: One thing that the guides do not state, as far as i've read, if ad.exe does not run and complains that its corrupt or something similar, you need Microsoft's Visual C++ Redistributable Package (Google for it) not sure if it matters if its 2005 or 2008 on your client computer

The update files do not create the table though, when the update queries drop the field it drops it from the Primary Key as well so they are not an issue as far as I can tell. besides if the updates were an issue, then that would require a new update file not patching an old one Edit: @darkruler Yeah I agree with your code you provided above, dropping the key and then recreating it would be a good way to do it, just dropping the column I'm not sure if the index gets rebuilt, but recreating the key altogether would rebuild the index (if there were actually any data in the table that is)

sql/characters.sql was changed to add some new fields and dropped some old ones, one of the fields dropped was part of the PRIMARY KEY Rev. 10156 on line 386 of sql/characters.sql PRIMARY KEY (`guid`,`spell`,`effect_index`) If someone is creating this table for the first time this query will fail because effect_index does not exist I do not know if a new field needs to be added (effIndexMask if it does?) or if only guid+spell is enough, so i cannot provide a patch

How many entries are in your `quest_poi_points` table? there should be 56,372 if you have duplicates of the records this is causing the client crash Edit: This is the number of records if using UDB, not sure about other databases This can happen if you apply the UDB 390_updatepack_mangos.sql update more than once because it does not delete existing records before inserting these records, however this is not a MaNGOS bug The easiest way to fix this (if you don't have custom content) is to DROP your mangos database only (not characters,realmd, or scriptdev) and recreate the mangos database and apply the updates one at a time If you have custom content and do not wish to completely drop the mangos database, you will need to truncate the quest_poi_points table and re-populate the data, which you will need to extract manually from the UDB files

There are many posts that already explain this and all the guides as well git the current revision, any revision after 10136 supports 3.3.5a (build 12340). Make sure to extract the data files from a client with 3.3.5a patch (this is the ad.exe and vmap part of any guide) If you have any further questions about this I recommend reading the Install guides, mainly the parts on compiling and extracting the data files

the client will pass the server any info you have in your wtf files, as long you change those back to their defaults they can't tell that way. If you want to be extra cautious tho you could delete your client's cache directories. Aside from those two things MaNGOS does not alter any client files. Edit: oh and as long as your not using a custom/tweaked client patch, which there's not very much reason to do that in the first place unless your trying to create new features in the client that don't exist, but that is not MaNGOS related Out of curiosity what was your solution to your database problem?

Well that's the right db_version for the current revision. Have you applied any patches (AHBot, etc)? Did you have to manually change the db_version string at anytime yourself because you thought an update was "missing" And even tho this will be a large list, can you export your item_template structure USE mangos; SHOW COLUMNS FROM item_template; The column I'm concerned about is NonConsumable added in update 09509_01_mangos_item_template.sql if you used an older UDB before this and then manually tweaked the db_version in order to apply the newer updates or anything like that then that would explain why you have a invalid field count