Reputation
16,794
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
1 14 30
Impact
~988k people reached

Feb
6
answered Deleting expired PHP session files on Ubuntu 14.04
Feb
6
comment How to tell squid use Source IP address for sending requests?
I don't think ACLs will work for this - I think you're going to have to do some tinkering with iproute2 - see lartc.org/howto/lartc.rpdb.multiple-links.html
Dec
25
comment how to access a unix machine from windows command prompt
Yes there are lots of ways of doing that, but most are insecure or require a large investment of effort. That's why everyone uses SSH.
Dec
12
comment phpMyAdmin tries to install Apache
Or just install phpmyadmin from tarball.
Nov
27
answered How to set up a Apache forward proxy with persistent connections?
Nov
24
comment Webserver randomly serves different vhosts
Have you reproduced this behaviour with a client which you KNOW supports SNI / is there a correlation between the user-agent and occurrences?
Nov
23
answered Which MySQL Replication should I use?
Nov
5
comment Good optimization for Mysql
Enough information to formulate a guess at whether anything can be done here would take an expert at least 5 hours hands on with the system.
Oct
28
comment Ubuntu LAMP server busy at peak hours
Not much point in doing that unless you increase Apache listen backlog too. Given the number of connections in TIME_WAIT, you should check net.ipv4.tcp_tw_recycle = 1 and net.ipv4.tcp_tw_reuse = 1.
Oct
24
comment MySQL and high jdb2 io/wait
If this is a dedicated server why have you allocated less than5 of its 32Gb to the innodb buffer pool???? That should probably be at least 15, maybe 20. Go get a copy of mysqltuner.pl and run it on your server. You can get a lot more performance out of this system without adding hardware.
Oct
5
comment Slow accessing HTTPS when ran via IIS (FastCGI)
The iis and CGI bit are common to the http and 'https request, so the difference between the behaviours for http and 'https is unlikely to be anything to do with the webserver or gateway mechanism.
Oct
5
comment How do I change the MySQL database directory?
pstump forgot to mention that you also need to shutdown mysql and copy all your data files to the new location before starting it up again.
Oct
5
comment Mysql: create index on 1.4 billion records
So 40 x 1 hour is less than 10 hour?
Oct
2
answered Can a poor client VPN connection corrupt a database?
Oct
2
comment restrict ssh, sftp access on ubuntu 12.04 through iptables or /etc/hosts.allow
If your ftpd was compiled against TCP wrappers then connection will be controlled by hosts.allow/deny. How hard would it be to test? But if you are concerned about security then WTF are you using FTP for?
Oct
2
comment restrict ssh, sftp access on ubuntu 12.04 through iptables or /etc/hosts.allow
If you are at all concerned about security then you should be using keypair authentication. If you're not already doing that then there's probably a lot of other basic prevention measures not implemented on your server. Whether the clients have static or dynamic IPs is irrelevant. With TCP wrappers (but not iptables) you can enforce restrictions based on the IP name independently of the IP address. But there are other solutions too including port knocking and fail2ban
Oct
2
answered SSH allowing remote hosts to connect to local forwarded ports
Oct
2
comment MySQL Service allow local connections through hosts.allow
There are some useful things you can do with tcpwrappers that you can't with iptables and vice versa. Did you check if your system was able to resolve 'mysql' to a port number?
Sep
29
answered php - error: Cannot find OpenSSL's <evp.h>
Sep
26
comment Which PHP (opcode) cache one should use and why?
This answer is now very dated. APC is unlikely to be updated for future versions of PHP having been replaced by Zend's optimizer and opcode cache (now known as opcache) since v. 5.5. However I've not seen a substantial difference in performance ( symcbean.blogspot.co.uk/2013/09/… ) further the lack of data support in opcache and lack of memory reclaims may make upgrading counter productive for some.