Stuck on Debian Install Guide ./start

[thepoetwarrior]

I've spent a few hours today slowly going thru the Debian Install Guide with no problem, but I got stuck after making the start, stop, and persist_world on

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

Do I need eqemu_config.xml like on Windows server?

In the start file, does P=`pwd` need to change or anything else need change? Like database names or passwords?

I didn't see a place for local IP, not that I'd know how to obtain my local IP on debian, which Im sure I can google that one.

Some help would be appreciated. Thanks

[thepoetwarrior]

Oh, added note, the problem when I type ./start from the appropiate path results in the error:

-su: ./start: Permission denied

[Derision]

Originally Posted by thepoetwarrior

Oh, added note, the problem when I type ./start from the appropiate path results in the error:

-su: ./start: Permission denied

You probably just need to flag it as executable:

chmod +x start

[thepoetwarrior]

Yup, didn't know about that, so now Im moving forward again.

I only got about 10 lines of startup spam, then back to a command prompt. Is the server running? I know how an active server looks like on the Windows version, with text constantly spamming.

Also, I dont see the server in the Login Server list. Is the eqemu_config.xml used or is that file just for windows? Trying to get my first attempt of Linux server to show up on The login server.

Oh, and I found out how to obtain my local IP by going to root and doing ifconfig -a.

Thanks again.

[thepoetwarrior]

Oh crap, I guess it does use the config.xml file... got a double server name up, one for Windows, and the closed one obviously my Linux one.

one error I had was sourcing in my custom database, maybe it need repair, will try again.

No questions for now. Thanks for the friendly help

[thepoetwarrior]

Well, for a while I was able to log in but nobody else could. I guess that means its a router/local ip issue? So I forward the same ports to new local IP for linux, but no good. Tried to reset the router, still no good. So I set the DMZ, which reset the router again, and now a few people can log in. The database is correct for the server version, cause I ported over from windows using same server version number. I dont see the usual text spam in a window when the server is up like Windows Server has, bit unusual for me.

[thepoetwarrior]

Ok, people are in my server now, but they cant cast spells. I have the correct spell files in the correct area, dunno whats wrong.

[thepoetwarrior]

Does the spells_us.txt and spells_en.txt need to be a certain file format for Linux? Spells not loading, and I have them in the correct directory.

[thepoetwarrior]

was max number of spells. Looks like windows server can handle over 10k spells, but Linux server under 10k spells... found out thru experimenting. Good to note differnces between windows/linux. Thanks for reading my self responding thread/topic

[trevius]

Oh crap! You are doing it lol! You should have let me know!

Ok, here are a few tips:

Casting issue should be only for detrimental spells and that is because you didn't install the .map files in your home/eqemu/server/maps directory.

And, you won't see the spam in the window the same as you do in windows. Instead, everything gets logged into separate log files in your /home/eqemu/server/logs directory. So, if you want to watch the spam go by to see if there are any errors, you can do this:

cd /home/eqemu/server/logs
tail -f *.*

And, if you just want to look for errors, you could run this tail command instead:

tail -f *.* | grep ERR

When you start the server, you use the ./start command as you already know. And, when you do a reset, you can shut down the server in game using the #worldshutdown command and then go to your command prompt and run the ./stop command. And you will probably have to use the chmod on the stop command like you did for the start command. Basically, the stop command ends all of the processes and I think clears out RAM and stuff.

One thing to note is that once you have your server running smoothly, you will never need to do another actual reboot of the PC again lol. Only the server needs to be reset every now and then, not the PC itself.

Max number of spells on the server isn't an issue for Windows or Linux. Both server types can use unlimited numbers of spell IDs. It is the client that is limited to 9999 as the max spell ID number. And that doesn't change from a Linux to Windows server.

Lemme know if you have any other issues. Following the wiki isn't too bad really. The only complex part IMO is getting your tools working from another Windows PC on your LAN. But, once you get mysql setup correctly and make an account for the windows PC on your LAN, it isn't bad. I think the worst part for me is always getting Windows and Linux to share files so I can map to the quests directory.

[thepoetwarrior]

Bear with me, Im awake maybe 30+ hours now pulling my hair out. Making some progress.

Actually, I had map files in the correct place.

I didnt know about tail, but good to know!

I used chmod on start, persit_world, and stop. That fixed it.

I use ./start, then while logged in EQ Client as admin I do #worldshutdown, then after it shut down I do ./stop. So that part is working.

Now for the problems driving me crazy:

With EQServer working on Debian Linux, and imported the entire windows db from a sql file thru mysql, seems most of the db gets loaded when I do ./start such as peoples chars and inventory, except its not reading the rule_values table! Regen caps are not correct, corpses are poofing, and people can scribe spells up to 70 but lose their 66-70 spells when zoning which might be because of the default level 65 cap.

I went into mysql on LinuxPC and created an account for my windows pc, using the windows local ip 192.x.x.x, with made up user/pw. I've done this before between 2 window PC's so I know how to do that, to use editors like Georges tools or Navicat from a differnt PC. So I go on the WinPC to use GUI Editors to log into the LinuxPC, but connection failed! Weird.

So I do reverse. I make ip-user-pw account in mysql on window machine for the linux machine to use. I then edit the eqemu_config.xml on LinuxPC to reflect the database info (ip, user, pw, db name) for mysql to connect to the db on WindowsPC. Hope makes sense,

So what I get is EQ Server running on Debian Linux, and using the database from the WindowsPC, not from its own LinuxPC! At least i can now edit the database on windows with localhost for ip thru Navicat or Georges tools, etc.

So I double check database on LinuxPC to see that rule_values imported, and they did. So why is Linux not using the rule_values from the database off its own machine?

Also, why can LinuxPC log into the Windows DB but the WindowsPC cannot log into the LInuxPC DB? Seems like a 1-way street there almost. When in mysql Im creating accounts with the correct IP's (192.168.1.x) etc so I know how to do that, but seems to work in only 1 direction, Linux->Win.

1) My WinPC cant remote into LinuxPC but the Linux can remote into the WinPC.

2) rule_values I verified to be on LinuxPC by using mysqldump then viewing, but the Server is not reading those values. Its like Linux can only access most of its own database, just not rule_values.

Any ideas?

Did a lot for one day here.

[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