How to keep rsync from chown’ing transferred files?

You are probably running rsync like this: rsync -a dir/ remote:/dir/ The -a option according to the documentation is equivalent to: -rlptgoD -a, –archive archive mode; equals -rlptgoD (no -H,-A,-X) You probably want to remove the -o and -g options: -o, –owner preserve owner (super-user only) -g, –group preserve group So instead your rsync command … Read more

Dealing with HTTP w00tw00t attacks

From your error log they are sending a HTTP/1.1 request without the Host: portion of the request. From what I read, Apache replies with a 400 (bad request) error to this request, before handing over to mod_security. So, it doesn’t look like your rules will be processed. (Apache dealing with it before requiring to hand … Read more

Storing a million images in the filesystem

I’d recommend using a regular file system instead of databases. Using file system is easier than a database, you can use normal tools to access files, file systems are designed for this kind of usage etc. NTFS should work just fine as a storage system. Do not store the actual path to database. Better to … Read more

Turn off pager for psql’s interactive output

TL;DR: \pset pager 0 From the \pset section of the psql manual: pager Controls use of a pager program for query and psql help output. If the environment variable PAGER is set, the output is piped to the specified program. Otherwise a platform-dependent default (such as more) is used. When the pager option is off, … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)