To everyone with database troubles: please read the first troubleshooting entry.
To everyone with database troubles: please read the first troubleshooting entry.
/kiss OMG +reppppppp
i changed the address in the realmlist table but my friend still gets stuck at "Logging into game server"
You say to open the realmd file, do I go to Mycomputer WoW directory and open it there? If so, I did that then this comes up in notepad.
2008-08-30 20:45:53 Using configuration file realmd.conf.
2008-08-30 20:45:53 MaNGOS/0.12.0-SVN (Revision 6360) (Win32,little-endian) (realm-daemon)
2008-08-30 20:45:53 <Ctrl-C> to stop.
2008-08-30 20:45:53 Database: 127.0.0.1;3306;root;root;realmd
2008-08-30 20:45:53 MySQL client library: 5.0.56
2008-08-30 20:45:53 MySQL server ver: 5.0.27-community
2008-08-30 20:45:53 Added realm "MaNGOS".
2008-08-30 20:45:53 realmd process priority class set to HIGH
2008-08-30 20:45:53
Do I change the MaNGOS in quotations to my specified realm name as seen below?
2008-08-30 20:45:53 Added realm "MaNGOS".
Also I did that find my IP to change it do I change the 127.0.0.1 (as seen below) to the IP i was given? And I see on other private servers they have it as the name of their server such as *****.servegame.com, how do I do that?
2008-08-30 20:45:53 Database: 127.0.0.1;3306;root;root;realmd
Edit sorry: And then to top all of this off do I overwrite the current Realmd file?
Wiggles, you don't open any files called realm, you download and run the program SQLyog, and then follow the instructions in the first post for connecting to the database. The mysql server must be running to do this. Once connected in SQLyog, find the realmd database on the left panel, open it, open the realmlist table inside of that, then click "table data". You should then see the stuff you need to edit. Make sure to save changes before exiting. If the server is running, it needs to be restarted for changes to take effect.
As for blahlbahblah.servegame.com, see No-IP™ Free - Free Dynamic DNS - DDNS
I have Sqlyog downloaded but I don't understand it at all I can find the realmd but I couldn't find your second step. The whole program confuses me. Can you please help me on configuring things in there, also where can I configure xp rates/quest rates/drop rates etc.? And lastly I got the server downloaded with no trouble but there are tons of PvP bugs such as WSG not working and Arena how can I fix these? Sorry I am really new to this whole making a server thing please help me.
nice work!
this is just awsome i gotta tell ya ive never seen a server with so few bugs/glitches ive found 2 and there so small its funny..but i was wondering...how do you make 2 servers under the same ip? and im havein a hard time finding the file you said was in the DB for changeing the server name
Wiggles, here's a video explaining in more detail how to edit the DB. I was gonna make it a streaming flv, but it was about 20x the filesize. New_sqlyogging.avi
Bella, I honestly have no idea how to host multiple servers, never tried it. Sorry. But the above video should help you with editing serverside realmlist data.
I tryed to play your video and I got it downloaded but it says it cannot play because it doesn't have Codec or something? I must have the worst luck..
Needs H.264 codec to play. Download H.264 Codec - afreeCodec.com
Alternatively, watch the GIF version:
http://img505.imageshack.us/img505/7...yoggingrm7.gif
Last edited by 711; 08-31-2008 at 02:07 PM.
my probem is every time i go to enter a password into any MySQL thing it wont let me connect - y the heck is that, this is really makin me mad.
Thx in advance....
What is the command for learing skills? .learnsk does not work.. Thanks in Advance.
Hey 711. Great repack and great guide.
I'm new at creating my own server and by following your guide I've only run into one roadblock. When ad.exe was extracting my maps it got an error at 41% and shut down. What did get extracted were 725 .map files into the maps folder. When I run through starting up mangos I get the following errors.
2008-09-02 09:31:46 ERROR:Check existing of map file './maps/0004331.map': not exist!
2008-09-02 09:31:46 ERROR:Correct *.map files not found in path './maps' or *.vmap/*vmdir files in './vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
I've gone through the whole uninstall/reinstall process 3 or 4 times for both your repack and wow client. Ad.exe still crashes at 41%. Any ideas?
Ok...slight update. After working on this most of the afternoon, I found a download for the maps folder with all the maps already extracted. Through this download I found out that my maps folder should contain well over 3000 files (not the 700+ I have extracted)
The missing map error I received earlier doesn't come up anymore. Now I get an error that says map 0004331.map is outdated. For a reason I can't explain ad.exe doesn't work on my system.
Can anybody upload a current version of the maps folder already extracted (2.4.3) to megauploads.com or someplace similar?
Or has anybody else had a similar experience as me with ad.exe and found a solution to it? I can't count the number of times I've uninstalled/reinstalled.
Thanks again for any imput.