Skip to content

Instantly share code, notes, and snippets.

View maliMirkec's full-sized avatar
🤘
I’m really good at this without realising how.

Silvestar Bistrović maliMirkec

🤘
I’m really good at this without realising how.
101 followers · 11 following
View GitHub Profile
@maliMirkec
maliMirkec / sendfile
Last active October 23, 2015 13:35
Turn off sendfile option if you see strange characters in your assets files using vagrant and virtual box
// http://stackoverflow.com/questions/9479117/vagrant-virtualbox-apache2-strange-cache-behaviour
// Apache
EnableSendfile off
// nging
sendfile off
@maliMirkec
maliMirkec / replace_string.sql
Last active October 27, 2015 17:58
Replace string in database
UPDATE table_name
SET column_name = REPLACE(column_name, 'old_string_part', 'new_string_part');
@maliMirkec
maliMirkec / count_files
Created November 3, 2015 07:38
Count nubmer of files in folder
// Count nubmer of files in folder
find FOLDER_NAME -type f | wc -l
@maliMirkec
maliMirkec / my.sql
Created November 26, 2015 10:29
Useful sql commands: reinstall, reset password
// mysql version
apt-cache policy mysql-server
// mysql reconfig
sudo dpkg-reconfigure mysql-server-*.*
// phpmyadmin reconfig
sudo dpkg-reconfigure phpmyadmin
@maliMirkec
maliMirkec / phpmyadmin_fix
Last active July 6, 2016 07:09
Fix phpmyadmin controluser message
curl -O -k https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-ubuntu.sh && chmod +x pma-ubuntu.sh && ./pma-ubuntu.sh
@maliMirkec
maliMirkec / server
Last active March 2, 2016 08:06
Set up server
https://github.com/DigitalOcean-User-Projects/Articles-and-Tutorials/blob/master/set_hostname_fqdn_on_ubuntu_centos.md
https://www.digitalocean.com/community/articles/how-to-set-up-a-host-name-with-digitalocean
https://www.digitalocean.com/community/tutorials/how-to-use-an-spf-record-to-prevent-spoofing-improve-e-mail-reliability
https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-dkim-with-postfix-on-debian-wheezy
@maliMirkec
maliMirkec / bitnami-apps-prefix.conf
Created May 16, 2016 20:48
Bitnami WAMP Wordpress vhosts fix.
# Bitnami applications installed in a prefix URL
Include "C:/Workspace/Bitnami/apps/phpmyadmin/conf/httpd-prefix.conf"
Include "C:/Workspace/Bitnami/apps/wordpress/conf/httpd-prefix.conf"
@maliMirkec
maliMirkec / find-and-exclude
Last active May 27, 2016 09:31
Find and exclude files on Ubuntu
// http://www.cyberciti.biz/faq/find-command-exclude-ignore-files/
find . -type f \( -iname "*.jpg" ! -iname "*1024*" ! -iname "*800*" ! -iname "*768*" ! -iname "*300*" ! -iname "*150*" \)
@maliMirkec
maliMirkec / resize-images
Created May 27, 2016 11:10
Resize all images in folder
find . -type f \( -iname "*.jpg" ! -iname "*1024*" ! -iname "*800*" ! -iname "*768*" ! -iname "*300*" ! -iname "*150*" ! -iname "*article cover*" \) | xargs mogrify -resize 750
@maliMirkec
maliMirkec / .htaccess
Created July 5, 2016 20:11
.htaccess vestacp
<ifmodule mod_deflate.c>
SetOutputFilter DEFLATE
AddOutputFilterByType DEFLATE text/html text/css text/plain text/xml application/x-javascript application/x-httpd-php
BrowserMatch ^Mozilla/4 gzip-only-text/html
BrowserMatch ^Mozilla/4\.0[678] no-gzip
BrowserMatch \bMSIE !no-gzip !gzip-only-text/html
BrowserMatch \bMSI[E] !no-gzip !gzip-only-text/html
SetEnvIfNoCase Request_URI \.(?:gif|jpe?g|png)$ no-gzip
Header append Vary User-Agent env=!dont-vary
</ifmodule>