Debian Wiki Updates/Tweaks - Page 3

demonstar55 · #1 08-06-2014, 03:04 AM

http://bpaste.net/show/172372/ those are the notes I took last time I did a debian install (some of it is probably a bit out of date?)

**hayward6** · #2 08-06-2014, 07:02 AM

As soon as the wiki is where you want it I will also run another bare metal install to see if we have it all worked out. The wiki is simple to follow so the only real time constraints are the downloads. I cloned my server at the point before adding anything directly emulator based as well, so I can always start there on a rebuild.

This is why I love this community! Last night my wife asked why I was still messing with my server when I can just play on another... I told her it's because I am trying to help where I can, I love it, and these guys are talented and amazing to work with!

**hayward6** · #3 08-06-2014, 04:46 PM

Buffs are no longer dropping when I zone

And the emulator is running much faster! Even the loading and zone times are drastically reduced!

**hayward6** · #4 08-06-2014, 05:06 PM

...And I don't have any npc's

It's so peaceful... I didn't even notice until track had no results. Going to restart the DB server and then just go from there all the way to a re-source.

**hayward6** · #5 08-06-2014, 05:49 PM

I'm throwing in the towel for tonight. I just completed two complete database sources both times from new and separate downloads, and I simply don't have any npc's... I think maybe I have been at this for too long now. I have never had this problem before.

This is going to require a complete restart and I am just not feeling invested tonight.

**Akkadius** · #6 08-06-2014, 06:02 PM

Quote:

Originally Posted by hayward6

I'm throwing in the towel for tonight. I just completed two complete database sources both times from new and separate downloads, and I simply don't have any npc's... I think maybe I have been at this for too long now. I have never had this problem before.

This is going to require a complete restart and I am just not feeling invested tonight.

Once again, this is a database related issue.

Did you do a database source from ProjectEQ's dump?

You're missing a SQL source that adds or changes a column in the npc_types table.

Are you also running the latest binaries from Git and not SVN ?

**hayward6** · #7 08-06-2014, 06:12 PM

Quote:

Originally Posted by Akkadius

Once again, this is a database related issue.

Did you do a database source from ProjectEQ's dump?

You're missing a SQL source that adds or changes a column in the npc_types table.

Are you also running the latest binaries from Git and not SVN ?

Yeah this was all correct as far as source and sql goes. I know it's db related, but I don't know where... Maybe now that I have the right db I should look for updates? Not one to walk away, I am going to spend a nit more time on it tonight

**Akkadius** · #8 08-06-2014, 06:21 PM

Quote:

Originally Posted by hayward6

Yeah this was all correct as far as source and sql goes. I know it's db related, but I don't know where... Maybe now that I have the right db I should look for updates? Not one to walk away, I am going to spend a nit more time on it tonight

Well you should see what it barks about in the zone logs, it will specifically spit out the MySQL error.

**hayward6** · #9 08-06-2014, 06:38 PM

Quote:

Originally Posted by Akkadius

Well you should see what it barks about in the zone logs, it will specifically spit out the MySQL error.

Sure enough!

line after line of this...

Code:

Error loading NPCs from database. Bad query: #1054: Unknown column 'npc_types.am
mo_idfile' in 'field list'

**hayward6** · #10 08-06-2014, 06:54 PM

Success! I am going to have some fun now and see if there is anything else I missed.

This may sound dumb but I would add a line in the wiki about checking and running required updates. I had just assumed that the db was fully updated because it was a fresh download, but now I know different

I will continue to report any findings.

demonstar55 · #11 08-06-2014, 07:06 PM

I think the issue is that cavedude can't always update the server so the DB might be missing an update sometimes :P

**Shin Noir** · #12 08-06-2014, 07:30 PM

Quote:

Originally Posted by hayward6

Success! I am going to have some fun now and see if there is anything else I missed.

This may sound dumb but I would add a line in the wiki about checking and running required updates. I had just assumed that the db was fully updated because it was a fresh download, but now I know different

I will continue to report any findings.

No suggestions are dumb, my goal with my step by steps is to make it easy even as a non-linux guru. I'll probably hit this up when I get home late tonight.

thanks for all your hard work hayward!
And thanks to all other developers with any tips they have about my build process. I took in your steps demonstar55 to ensure their implementation was included on mine.

**Akkadius** · #13 08-06-2014, 08:03 PM

Yes, it is a serious goal to make getting a server setup easy and keep it easy. It is something I look to be addressing fairly soon here. So Shin's contribution to the Linux guide is amazing.

Thanks all

**hayward6** · #14 08-07-2014, 06:48 AM

So, now that internal things seem to be working properly. Here is a short list of the management issues I am having.

1. cannot access http to manage server. I have the 9080 port forwarded but it just doesn't seem to even acknowledge a listening application, so I never get to a login screen (I used to like this portal for a quick description of who is logged on and for the ability to lock and unlock the server remotely)
2. phpeditor is still messed up, but I just remembered that I never sourced in the new sql statement from the proper database.
3. everytime I zone I see a message in red about the chat channel being disconnected. This might be nothing, but I did see another thread that mentioned changing the address in the emu config from channel.eqemulator.net to the host address. I changed it to 127.0.0.1 and I haven't seen any change in that. Chat seems to be working fine though...

**Shin Noir** · #15 08-07-2014, 04:42 PM

1. I'm not familiar with the 9080 system, can you clarify this system? I wrote a preliminary instruction of setup on step 25 (Remote Web Management), it isn't binding the port properly however, maybe a dev can confirm it's setup? (Can't find it in windows setup instructions either).
2. Yeah, the phpeditor step in my instructions should get it working, I've been using it with the steps I noted.
3. ucs isn't started/configured with my setup, I can add that real quick.
I added step 24, which sets up Universal Chat Service (ucs). I didn't fully configure the general channels etc, but it at least starts up it appears.

When we get this all cleaned up and done, I'll rewrite that startup script you noted to include my config settings, and also how to auto start your server on server bootup, but waiting for all bugs to be found.
I'll also likely remake my videos once all instructions are done and solidified.
And I'm also planning to EXPLAIN each section soon, instead of just giving steps.
And lastly, I'll probably have a step talking about how to use iptables to increase security of what ports you're forwarding.

Let me know of any other issues, and if above helps you out.