Margus Roo

It is annoying to type them from the scratch every time. So a little copy paste place for my. Lazy me!

insert into user (Host, User, Password) Values (‘localhost’, ‘username’, PASSWORD(‘xxx’));

insert into db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv) values (‘localhost’, ‘dbname’, ‘username’, ‘Y’, ‘Y’, ‘Y’, ‘Y’);

UPDATE `mysql`.`user` SET `Create_priv` = ‘Y’,
`Drop_priv` = ‘Y’,
`Reload_priv` = ‘Y’,
`Shutdown_priv` = ‘Y’,
`Process_priv` = ‘Y’,
`File_priv` = ‘Y’,
`Grant_priv` = ‘Y’,
`References_priv` = ‘Y’,
`Index_priv` = ‘Y’,
`Alter_priv` = ‘Y’,
`Show_db_priv` = ‘Y’,
`Super_priv` = ‘Y’,
`Create_tmp_table_priv` = ‘Y’,
`Lock_tables_priv` = ‘Y’,
`Execute_priv` = ‘Y’,
`Repl_slave_priv` = ‘Y’,
`Repl_client_priv` = ‘Y’,
`Create_view_priv` = ‘Y’,
`Show_view_priv` = ‘Y’,
`Create_routine_priv` = ‘Y’,
`Alter_routine_priv` = ‘Y’,
`Create_user_priv` = ‘Y’ WHERE CONVERT( `user`.`Host` USING utf8 ) = ‘h3.okia.ee’ AND CONVERT( `user`.`User` USING utf8 ) = ‘root’ LIMIT 1 ;

Posted in: Linux by margusja /
No Comments

ull
tegime just ühe ä tähtedega domeeni ispmaniga
2:31 www.snäp.eu
2:31 selle asjaga tuleb nimi ära konvertida: http://mct.verisign-grs.com/
2:32 ja siis konvertidu kujul saab teha domeene ja asju ispmanis ja kõik töötab

Posted in: Linux by margusja /
No Comments

Posted in: Linux by margusja /
No Comments

Selline lugu juhtus täna.

Tahtsin ühte NAS serveri sharet mis oli mounditud cifs võtmega, apache kaudu serveerida. Asi nagu peaaegu õnnestus. Faile sai näha ja puha. Aga kui hakkata alla laadima siis tuleb 0 biti.

TCP liikluse analüüs ka targemat miskit ei andnud:


GET /path/to/file HTTP/1.1
User-Agent: Opera/9.80 (Macintosh; Intel Mac OS X; U; en) Presto/2.2.15 Version/10.10
Host: ftp.example.com
Accept: text/html, application/xml;q=0.9, application/xhtml+xml, image/png, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1
Accept-Language: en,ja;q=0.9,fr;q=0.8,de;q=0.7,es;q=0.6,it;q=0.5,pt;q=0.4,pt-PT;q=0.3,nl;q=0.2,sv;q=0.1,nb;q=0.1,da;q=0.1,fi;q=0.1,ru;q=0.1,pl;q=0.1,zh-CN;q=0.1,zh-TW;q=0.1,ko;q=0.1
Accept-Charset: iso-8859-1, utf-8, utf-16, *;q=0.1
Accept-Encoding: deflate, gzip, x-gzip, identity, *;q=0
Authorization: Basic dGFua2NsaWVudDpNaW5nZVRhbmtpMDAxsad3
Connection: Keep-Alive, TE
TE: deflate, gzip, chunked, identity, trailers

HTTP/1.1 200 OK
Date: Thu, 26 Nov 2009 11:33:48 GMT
Server: Apache
Last-Modified: Thu, 21 May 2009 12:37:30 GMT
ETag: "3830e7-f19ac-46a6b68415680"
Accept-Ranges: bytes
Content-Length: 989612
Keep-Alive: timeout=10, max=5
Connection: Keep-Alive
Content-Type: text/plain


Kogu moos.

siis selgus et see on vana hea tundud probleem ja lahenduse annab apache virtuali konfis: EnableSendfile Off

Posted in: Linux by margusja /
No Comments

lvcreate -L 500M -n vm22.swap vg

lvcreate -L 10G -n vm22.root vg

lvcreate -L 20G -n vm22.var vg

mkfs.ext3 /dev/vg/vm22.root

mkfs.ext3 /dev/vg/vm22.var

mkswap /dev/vg/vm22.swap

mkdir /mnt/var

mkdir /mnt/proc

mkdir /mnt/sys

mount /dev/vg/vm22.root /mnt/

mount /dev/vg/vm22.var /mnt/var

cd /mnt/

tar -zxvf /root/f11-x86_64-base.tar.gz

rm f11-x86_64-base.tar.gz

vim ./etc/sysconfig/network

vim ./etc/sysconfig/network-scripts/ifcfg-eth0

vim ./etc/fstab

vim ./etc/sysconfig/network-scripts/ifcfg-eth0:1

vim ./etc/hosts

umount /mnt/var/

cd /

umount /mnt/

cd /etc/xen/auto/

cp vm21 vm22

vim vm22

xm create -c /etc/xen/auto/vm22

Posted in: Linux by margusja /
No Comments

Allpool on näha ühe serveri mälukasutuse graafik. Kuni punase jooneni kadus vaba mälu mis ei ole linux kerneli puhul midagi erilist, pigem hea. Samas on näha et ei cachetud mälu mis on aga väga halb.
Kuni punase kriipsuni olid apache seaded default. Peale seda seadistasin apache serverit ning peale punast kriipsu on ka tulemus. Minu arust päris hea.

Posted in: Linux by margusja /
No Comments

Sometimes it is good to know it

sync; echo 3 > /proc/sys/vm/drop_caches

Posted in: Linux by margusja /
No Comments

RewriteEngine on

Rewrite if no https and no www

RewriteCond %{SERVER_PORT} !^443$
RewriteRule (.*) https://www.test.ee/$1 [L,R]

RewriteCond %{HTTP_HOST} !^www\.test\.ee [NC]
RewriteRule (.*) https://www.test.ee$1 [L,R]

Rewrite if no request uri

RewriteEngine on
RewriteCond %{REQUEST_URI} ^/$ [NC]
RewriteRule ^(.*)$ http://www.example.com [L,R]


Posted in: Linux by margusja /
No Comments

Kuna mul koguaeg läheb see mergemine meelest siis paar hinti endale siia.

1. svn co /path/to/your/svn/repo/your/branch/ projectname
2. Nüüd uuri välja revisioni number millal branch on tehtud (r-start) ja viimane revision sinu branchis (r-end)
3. svn merge -r r-start:r-end file:///path/to/your/svn/repo/your/branch/
4. svn ci -m “- sinu teade. Võiks sisaldada ka mergetud revisione”

* revert to some version – svn up -r (revision number)

Kui väga suur kopp on ees sinu projektis .svn kataloogidest siis: find . -name “.svn” -exec rm -rf {} \;

Posted in: Linux by margusja /
No Comments

To export, use:
gpg –armor –export mymail@here.com > public.asc
gpg –armor –export-secret-key mymail@here.com > private.asc

To import, use:
gpg –import public.asc
gpg –allow-secret-key-import private.asc

Posted in: Linux, Turvalisus by margusja /
No Comments