132 reputation
111
bio website addedbytes.com
location Brighton, United Kingdom
age 34
visits member for 4 years, 1 month
seen Oct 13 at 13:59

Professional geek from Brighton, UK. PHP/HTML/CSS/JS developer, using MODX and Magento. Learning Python.


Mar
12
comment VPN and MySQL Server on Same Machine
Thanks Sergey. I'm not sure I understand. The static route should be added to the MySQL server, or should be a route to the MySQL server?
Feb
22
comment How can I set Apache's .gitignore file?
Doesn't that just set it for your user, though, not all users? The global refers to all repositories, not all users and all repositories.
Oct
28
comment Apache processes at 100% with no traffic - how can I see what's going on?
Thanks for the quick reply! I updated and upgraded, and added one of the recommended prevention measures for the range vulnerability, restarted everything and re-enabled traffic, and the same thing happened again almost immediately - Apache process went to 100% (and is still there, with traffic off again).
Oct
14
comment How does iptables execute rules?
Would that I could accept two answers. ktf cleared it up for me, but I wanted to say thanks for your answer as well as it was very helpful.
Oct
14
comment How does iptables execute rules?
Lines 1 and 2 above are in the same chain (on sequential lines) and lines 3 and 4 are on sequential lines in a different chain. If I've understood you correctly, if lines 1 and 2 above are in the same chain, and it reaches line 1, it will ignore line 2 - is that right?
Jun
16
comment How can I keep Apache from falling over?
I've had a look at Varnish and that looks like a good solution to dropping the CPU load, at least until I can move to a host with better CPU setup. Thanks.
Jun
16
comment How can I keep Apache from falling over?
They're saved in a tmpfs.
Jun
6
comment How can I keep Apache from falling over?
Normally, something like 10-20 processes actively serving requests at any point. When the load is extremely high, then lots more. Magento is something of a monster to run, so while I would expect other systems to be ok with this traffic and setup, I can believe this might just be Magento outgrowing the box. Thanks for the book recommendation.
Jun
5
comment How can I keep Apache from falling over?
Sorry, didn't realise you'd edited your reply. Yes, it's a dual-core VPS (Xeon 2.4ghz). I would have thought this server should be able to handle its current load, which is why I'm worried I've missed something in config or have failed to spot a bottleneck somewhere.
Jun
5
comment How can I keep Apache from falling over?
Here's the output (I'd prefer not to link directly to the site/server): dl.dropbox.com/u/16366/apc.htm
Jun
5
comment How can I keep Apache from falling over?
First, thanks! The load is still pretty high, so I can try some of these things straight away, which is helpful :). I increased MaxRequestsPerChild to 4000 - load jumped immediately and stayed very high. I reduced it back to 1000, and the load has dropped somewhat, though still too high. APC is installed. SHM is 256. The include_once override is on.
Feb
11
comment How can I set up Postfix so that all email sent on my dev box gets routed to the developer email group?
All sorted - thanks rems! I had a couple of issues, which I'll outline here in case anyone else comes looking for this. I didn't realise what postmap was doing, first. So to do the above, I created a text file (/etc/postfix/canonical) with the first line from rems. I then ran postmap from the postix directory, and that generated a database file used by postfix (canonical.db). The line added to main.cf doesn't use the .db extension, but does look for the .db file. Finally you need regexp: instead of hash: if using a regex pattern as above.
Feb
11
comment How can I set up Postfix so that all email sent on my dev box gets routed to the developer email group?
I'm probably doing this wrong, but I didn't get very far. There was no /etc/postfix/canonical file, so I created one with the text above. I then ran "postmap canonical", but got this error: "postmap: fatal: open canonical: No such file or directory"
Feb
11
comment How can I prevent Postfix sending email outside my domain?
Thanks Unixguy. Sadly, although I should be able to figure out what to do from this ... it seems I can't. Is the ourdomain.com line configured to deliver email to our domain via the relay, and then anything else (*) set to just sit locally? This sounds like it will block all email delivered to other domains and deliver it to a local user - can I then have that mail delivered externally (to a developer group address, for example)?
Feb
11
comment How can I prevent Postfix sending email outside my domain?
Thanks Walter. Unfortunately, this blocked the emails that I wanted to be sent (which aren't hosted on the same box).