• MySQL utf-8

    [client]
    default-character-set=utf8

    [mysql]
    default-character-set=utf8

    [mysqld]
    collation-server = utf8_unicode_ci
    init-connect='SET NAMES utf8'
    character-set-server = utf8


  • APACHE


    prefork

    mpm_prefork is.. well.. it’s compatible with everything. It spins of a number of child processes for serving requests, and the child processes only serve one request at a time. Because it’s got the server process sitting there, ready for action, and not needing to deal with thread marshaling, it’s actually fasterthan the more modern threaded MPMs when you’re only dealing with a single request at a time – but concurrent requests suffer, since they’re made to wait in line until a server process is free. Additionally, attempting to scale up in the count of prefork child processes, you’ll easily suck down some serious RAM.

    It’s probably not advisable to use prefork unless you need a module that’s not thread safe.

    Use if: You need modules that break when threads are used, like mod_php. Even then, consider using FastCGI and php-fpm.

    Don’t use if: Your modules won’t break in threading.

    worker

    mpm_worker uses threading – which is a big help for concurrency. Worker spins off some child processes, which in turn spin off child threads; similar to prefork, some spare threads are kept ready if possible, to service incoming connections. This approach is much kinder on RAM, since the thread count doesn’t have a direct bearing on memory use like the server count does in prefork. It also handles concurrency much more easily, since the connections just need to wait for a free thread (which is usually available) instead of a spare server in prefork.

    Use if: You’re on Apache 2.2, or 2.4 and you’re running primarily SSL.

    Don’t use if: You really can’t go wrong, unless you need prefork for compatibility.

    However, note that the treads are attached to connections and not requests – which means that a keep-alive connection always keeps ahold of a thread until it’s closed (which can be a long time, depending on your configuration). Which is why we have..

    event

    mpm_event is very similar to worker, structurally; it’s just been moved from ‘experimental’ to ‘stable’ status in Apache 2.4. The big difference is that it uses a dedicated thread to deal with the kept-alive connections, and hands requests down to child threads only when a request has actually been made (allowing those threads to free back up immediately after the request is completed). This is great for concurrency of clients that aren’t necessarily all active at a time, but make occasional requests, and when the clients might have a long keep-alive timeout.

    The exception here is with SSL connections; in that case, it behaves identically to worker (gluing a given connection to a given thread until the connection closes).

    Use if: You’re on Apache 2.4 and like threads, but you don’t like having threads waiting for idle connections. Everyone likes threads!

    Don’t use if: You’re not on Apache 2.4, or you need prefork for compatibility.


  • Configure hostname

    You should double confirm the system hostname if it looks good. For example if this host is www.example.com, the /etc/hostname can be:
    host.example.com
    The /etc/hosts should also be:
    127.0.0.1 localhost
    127.0.1.1 host.example.com host

    Now reboot your system, and check the system hostname with command:
    hostname
    Ensure all APT source enabled

    By default some of your APT source may be disabled, so let’s enable them with:
    sed -i 's/^#\s*deb/deb/g' /etc/apt/sources.list
    Install Virtualmin with GPL installation script (not available yet on 2012-04-30)

    Just simply access http://www.virtualmin.com/download.html and download the Virtualmin installation script with wget:

    cd /tmp
    wget http://software.virtualmin.com/gpl/scripts/install.sh
    /bin/bash /tmp/install.sh


  • Linux default console resolution

    into /etc/default/grub

    GRUB_GFXMODE=1024x768
    GRUB_GFXPAYLOAD_LINUX=keep


  • twitter widget

    $("iframe#twitter-widget-0").contents().find('head').append('<style>img.u-photo.avatar{display:none !important;}.header.h-card.p-author{padding-left:0;}</style>');

    i use the “waituntilexists.js” plugin to detect when the content is added to DOM instead of the setTimout(): https://gist.github.com/buu700/4200601

    $("iframe#twitter-widget-0").waitUntilExists(function(){
    $("iframe#twitter-widget-0").contents().find('head').append('<style>img.u-photo.avatar{display:none !important;}.header.h-card.p-author{padding-left:0;}</style>');
    });


  • Disku UUID

    blkid


  • Grub Rescue

    boot from livecd or usb
    in terminal window:

    &nbsp;

    sudo su
    TARGET=/media/sda1
    mkdir -p $TARGET
    mount /dev/sda1 $TARGET
    mount --bind /dev $TARGET/dev
    mount --bind /dev/pts $TARGET/dev/pts
    mount --bind /proc $TARGET/proc
    mount --bind /sys $TARGET/sys
    cp /etc/resolv.conf $TARGET/etc/
    chroot $TARGET /bin/bash

    This places you in a root terminal on the #! system
    Do whatever you want to do there, e.g. re-install grub
    grub-install /dev/sda
    update-grub

    To exit from chroot:
    control-D
    This brings you back to where you were in the live session and you can unmount
    umount -l $TARGET/dev/pts
    umount -l $TARGET/dev
    umount -l $TARGET/proc
    umount -l $TARGET/sys

     


  • PHP Preg_match lai izvilktu pirmo youtube linku no teksta

    preg_match('#(?:http://)?(?:www\.)?(?:youtube\.com/(?:embed/|v/|watch\?v=)|youtu\.be/)([\w-]+)(?:\S+)?#', $string, $match);


  • Youtube thumbnail no video identifikatora

    $url="http://www.youtube.com/watch?v=mHifGmeToVU";
    parse_str(parse_url($url,PHP_URL_QUERY),$my_array);
    echo $my_array['v'];
    echo "<img alt="" src="http://img.youtube.com/vi/&quot;.$my_array[" />";

    VAI
    function youtube_id_from_url($url) {
    $pattern =
    '%^# Match any youtube URL
    (?:https?://)? # Optional scheme. Either http or https
    (?:www\.)? # Optional www subdomain
    (?: # Group host alternatives
    youtu\.be/ # Either youtu.be,
    | youtube\.com # or youtube.com
    (?: # Group path alternatives
    /embed/ # Either /embed/
    | /v/ # or /v/
    | /watch\?v= # or /watch\?v=
    ) # End path alternatives.
    ) # End host alternatives.
    ([\w-]{10,12}) # Allow 10-12 for 11 char youtube id.
    $%x'
    ;
    $result = preg_match($pattern, $url, $matches);
    if (false !== $result) {
    return $matches[1];
    }
    return false;
    }

    echo youtube_id_from_url(‘http://youtu.be/NLqAF9hrVbY’); # NLqAF9hrVbY

    http://img.youtube.com/vi//0.jpg
    http://img.youtube.com/vi//1.jpg
    http://img.youtube.com/vi//2.jpg
    http://img.youtube.com/vi//3.jpg

    http://img.youtube.com/vi//default.jpg

    http://img.youtube.com/vi//hqdefault.jpg

    http://img.youtube.com/vi//mqdefault.jpg

    http://img.youtube.com/vi//sddefault.jpg

    http://img.youtube.com/vi//maxresdefault.jpg


  • Exports uz Exceli

    function vissuzexceli(){
    window.open('data:application/vnd.ms-excel,' + encodeURIComponent($('HTML').html()))
    }