Stuck on Debian Install Guide ./start

[thepoetwarrior]

I'll try to get a battery backup for the PC's incase power hits.

I already did the edit before on my.cnf and added the sql line to add a user with all privilelges, double and triple checked the ip's etc, but still not working. Maybe Im not getting the correct ip? Its on 192.168.1.x

EQ Server is on Linux PC but the DB is being pulled from the windows PC.

Oh, when I started up EQ Server yesterday, it was using around 400 meg ram, but now its almost 600 meg ram used. Does this continue to go up forever eventually requiring to restart the server, just like the Windows Pagefile problem?

Well, going to sleep, back to work tonight. Will have to try again next Saturday.

Thanks for the reply Trevius.

[Jack Daniel]

on this step what directory do you put the unzipped and extracted files


Map Files

Download Map Files
Map files∞

Maps.tar.gz∞
new_maps.zip∞

Install Map Files
tar xzf Maps.tar.gz
unzip new_maps.zip

do they go in sourse or server

[trevius]

They go in the server/maps directory. You want to keep /maps and /quests in your server directory, so that they don't get changed when you do upgrades to the emu code.

You can run the ifconfig command from your linux terminal window and it will tell you the IP of your server. That is the IP you will need to set the Bind Address to in your my.cnf file.

Make sure that the changed you made to the file actually saved. That file is set to only be editable by root, and the only way I know of to do that from the Linux PC is either VI, or to use chmod to change the file access properties so that your normal Linux login can save the file and then you have to set the properties back again for mysql to use it. It requires a restart of mysql for these changes to happen, but you can just restart the whole PC to make it simple.

The way I normally edit that file is using the webmin tool. If you haven't set that up yet and checked it out, I highly recommend doing so You can log into that tool as root and then you can edit the text file and save it directly without having to use VI or having to change file access properties.

As for the RAM, yes it will go up as you get more players on, but normally it will go back down again when there are less players. If you have more than 1GB of RAM, you probably won't ever have any page filing, as it will all stay in RAM, which is better anyway. Occasionally something happens that starts using up my RAM and I have to restart the server to restore it to normal, but normally it can run for quite a while before there are RAM issues. RAM usage will go up the more players you have on, but even with 120ish on my server, I have never seen it go over 1.5GB of RAM usage.

I think that you should be able to work on getting your Windows to Linux Mysql connection working without effecting your players at all. You can just keep the server running the way you have it now until you can get that connection working. Once you do, then a simple database dump and move then source it and change your settings back to your Linux database and you should be good to go

[thepoetwarrior]

Yeah, I put maps into server/maps/ and the quest into server/quest/

I put the ifconfig local ip 192.x.x.x into the my.cnf. Also I've learned a bit how to use VI so I did that from root to edit the my.cnf. I dont know how to use chmod on it, what attributes to give it for editing, or what to change it back too.

Thats stuff I've already done, and having problems already. Also one step in the install of Linux OS was some kernal for more ram, so I used the AMD one and it locked up my PC at the login screen, so I had to boot up with the orig kernal, which probably recoginizes 1 gig ram, but 1 gig ram is all that my test machine has anyways.

Speaking of ram, server booted up with 400 ram used, but after 21 hours up, we're at 673 ram used, and there are 51 users online. Another gig of ram I should be good then.

You know what, I never rebooted the PC after changing the my.cnf file. Maybe thats the problem? Figured I didn't have to reboot anymore.

On my next day off, I'll try to reboot the LinuxPC and see if Navicat or Georges tools work from Windows. If that works, then next step is to try and dump the db onto the linux server again.

Thanks for the help. Im trying to not get discouraged here. At least its half working, Server on Linux, DB on Windows. Its a start.

[trevius]

Don't get discouraged! You are very close to having it setup perfectly. A reboot should solve your mysql connection issue from Windows. You don't really *have* to reboot to resolve it, but it is the easiest way IMO. You could always just restart mysql. If you are running the webmin tool, you can go to Servers and then select Mysql and it gives you the option to stop and start mysql. So, you could do it that way if you wanted.

Once you are fully setup, the server will run much smoother and better than it ever did on Windows. And, you won't have to worry about anymore of these setup issues.

If your server only has 1GB of RAM in it, then there is no reason to upgrade your Kernel just yet. Though, you will need to upgrade it when you get more RAM otherwise it won't recognize the extra RAM. You can view your system stats easily from the main screen of Webmin ( have I mentioned how useful this tool is yet? :P ) and it will show you how much RAM your system recognizes and is using. And, yes, 2GBs should be a very good amount of RAM. I barely ever break 1GB of usage even with 100+ on, but I have seen it as high as 1.5GB before, which was probably do to some issue, but a server restart fixed it.

Since I installed Linux, I haven't rebooted the PC a single time myself. It has gone down a few times due to power hits at my house though.

Hopefully the next sql dump you do fixes your issue with the rules. You can always run that tail command and see if it is giving any errors while trying to load the rules or if it just skips the rules completely. Just make sure to open a separate terminal window for the tail and start the tail before you start the server so you can watch the whole process. Also, when I am not using the tail, I always turn it off using CTRL+C to exit it, just to reduce server load if it adds some. If it is just skipping your rules section completely when the server boots up, then maybe you should double check those rules tables and make sure they look ok. I will see if I can find the command to change rule sets in game. I know there is one that is supposed to allow you to set which rule sets are used by the server, it has just been a while since I have seen it.

[thepoetwarrior]

I copied the DB from Windows to Linux PC and the rule_sets changed to 3 in Linux, so I looked at windows and its rule_sets set to 0... which all my rules are... so some reason the export/import is changing that ruleset from 0 to 3, dunno why but quick edit fixed that, and now Linux runs with no problem.

Reboot fixed the my.cnf problem not working. Now I can use Navicat and Georges tools on Windows to edit the DB on Linux PC.

The kernel upgrade didnt work, cause just freezes up at the login screen before desktop part. The PC only has 1 gig ram right now so I'll figure that out when I add more ram. I might use a differnt PC anyways, this was just to test that I can get a Linux Server up and running, and it looks like I can, 100% successful within only 1 1/2 days. Just gotta do same, this time quicker, on a differnt PC.

Two quick questions:

The dynamic zone memory leak, was that only windows version, or also on Linux? If on Linux, then is recommended to make a lot of static zones?

Also, I see errors about the peq db not having a name_filter table, is that required? Well probably not required since the server runs, but just curious if its suggested?

Thanks for help Trevius.

[trevius]

Awesome! I figured the rules tables were doing something weird. Glad you got that straightened out. And, maybe I need to add something about restating the PC or restarting mysql at least after editing the my.cnf file in the wiki. Glad the reboot worked for you as well.

It sounds like you have everything running perfectly now other than the kernel upgrade. The kernels I suggested on there probably don't work for all PCs. I just put the most common 2 for Intel or AMD CPUs. You can always experiment with others to see if they work or not. I don't think it will hurt anything. You just use the "apt-cache search kernel | grep AMD" command if you are looking for AMD kernels. There are quite a few different ones, but I suggest you can try using the one that is the closest match to your CPU, as long as you don't use a 64bit one. The only reason I say not to use the 64 bit one is because some programs don't work on it. The server would still work fine, but for example, the "Shell in a Box" add-on tool for Webmin doesn't work on 64 bit and that is one of my favorite Webmin tools.

Once you are able to get your PC running on the kernel you want, you can always re-arrange your boot order by going to the Webmin tool and going to Hardware then to Grub Boot Loader and removing ones that don't work or change the order of what boots first and stuff. You don't have to boot it very often, so it isn't a big deal really, but I just like my PC to be as perfect as possible lol. Just make sure you don't remove the ones with "Debian GNU/Linux, kernel 2.6.18-6-486" in them, as those are the default ones and you might need them if something else goes wrong. The kernel that I currently use is Debian GNU/Linux, kernel 2.6.18-6-k7 and it works great. I thought the one I put in the wiki (should be the same one I am using) should work for most AMDs. I know this is probably a stupid question, but are you sure you don't have an Intel CPU in that PC? I build so many PCs that it is hard to keep track of the parts in all of them, and while most are AMD, I do have an Intel in there somewhere lol.

I run all of my zones dynamically and have no issues with it. Though I have considered adding a few statics just to keep a couple of zones from resetting when they are empty (mainly if a raid wipes).

And ya, I get those name filter errors as well when new characters are created. I don't know why that is the only thing that actually does scroll after the server is started lol. I am sure it isn't an issue at all and not much need for it unless you want to set a filter for names, which might not be bad if you have a strict naming policy or just don't want certain words in names. I had to delete a character tonight cause his name was so bad, and a name filter would definitely have stopped it. I wouldn't mind having another table for it, but I don't know what the table would be setup like. I have just been ignoring those errors.

Now that you have all of that stuff setup, there is only 1 more thing to setup, but it isn't exactly critical. The last thing you would want to get setup is file sharing between windows and Linux. I vaguely described how to do it in the wiki, but it can sometimes be a little rough to get setup. But, once it is setup, you will have 100% control over your server from your Windows PC. The quest editor won't work without the file sharing. If you have issues getting it working, just let me know and I will help if I can.

Oh, and Welcome to Linux! I think you find that it was well worth the work. And, if you ever do another install, the second time around is considerably easier lol.