Stuck on Debian Install Guide ./start

[trevius]

Well, from the wiki that AndMetal made and that I added some steps to, you can find how to set mysql on linux to allow remote connections from your windows PC in this section:

http://www.eqemulator.net/wiki/wikka...er#MySQLRemote

Make sure you follow the section directly below that as well:

http://www.eqemulator.net/wiki/wikka...LRemoteAccount

You have to configure access to the mysql database running on the linux PC by adding an account for the windows PC:

GRANT ALL PRIVILEGES ON *.* TO 'eqemu'@'192.168.1.%' IDENTIFIED BY 'my-new-password';

And then the windows PC will have to have Navicat or whatever you use set to use that account that you just created. It should be set to eqemu and whatever password you set. If your LAN uses different IPs than the 192.168.1 network, then you will need to adjust that. You can leave it with the % sign in there and that will just allow all PCs on your LAN to access your database, but still block anything from outside.

You also have to change the text file I mention in the first line (my.cnf) otherwise, Linux won't allow any access at all from outside sources. And, make sure you set the Bind Address to the IP of your Linux PC.

That should get you access to your database on the Linux PC from your Windows PC like you will need.

As for your rules, I am not exactly sure why they wouldn't load, because they should all carry over when you did the database move and it sounds like they did. The only thing I can think of off-hand is that you might want to check your Rule_Sets table and make sure that the number of your default rule set (or whichever set you normally use if you made a custom one) is the same as what is being set in your Rules_Values table to enable the rules.

In my case, my default rule set is 1, and so to enable rules, I have to set them to 1, as by default they are set to 0, which basically means the rule is ignored. Really, this should carry over and work just like it does on your windows database, but that is the only reason I can think of that would cause that. Otherwise, I think there is a command to set your rules in game, which I don't know the command name offhand, but maybe it is worth a shot if you want to try that.

Sounds like overall, your install didn't go too bad =) It took me about a week of tweaking to get my linux server working perfectly before I moved my database over and started running the server from it. But, now I have rebuilt Linux 3 or so times, so I got the hang of it hehe. And, I didn't rebuild because there were issues, I rebuilt because I was moving it back and forth between PCs. Since I went to Linux, there have been very few issues. Though, you might want to consider getting a UPS power backup at some point to protect your OS install. If your power hits and brings your Linux PC down, it can sometimes be nasty to get Mysql running properly again, but normally there aren't many issues with that even.

[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.