Sometimes it is only one way to do

[root@mail ~]# echo b > /proc/sysrq-trigger

OpenLDAP backup and restore

I'm going to change some schema and data in my ldap ;)

But 1st thing is how to restore ldap from ldiff file when something will go bad ...

1st is backup
2nd is store backup on other host/disk/whatever, it can be printed each time ;)
3rd is how to restore it when disaster come true ...

1st) backup like this? hm ... put it to cron ;)

[root@samba64 tmp]# slapcat  -o ldif-wrap=no > slapcat-o-ldif-wrap-n.ldiff


2nd) when file is created send it somewhere ;)

3rd) restore from ldiff file, please remember about correct schema files,
if there is something 'strange' (my setup has some tweaks for Postfix) then also backup schema files :P just in case :P ;-) 

how to restore it?

- shut down ldap server,
- remove broken files, in my case just clean directory /var/lib/openldap-data or rename it,
-  change directory to /var/lib/openldap-data,
- do command: slapadd -v -l ~/LDAP/slapcat-o-ldif-wrap-n.ldiff,
- chown slapd:slapd files in /var/lib/openldap-data (beware, it is my PLD Linux ;) ),
- start ldap,
- check it. something like this:

ldapsearch  -b "ou=Users,dc=XXXX,dc=pl" -D "cn=Manager,dc=XXXX,dc=pl" \
        -w MyPassword -x -v \
        -h 127.0.0.1\
        '(&(objectClass=PostfixUser)(accountStatus=active))' mail

Uff done ...

Restore procedure looks like "IT WORKS!"

:-)

Next step is add and change some data in my secret schema ;) then do some tricks with ldiff file ...

Some movies from 1st run of nitro 1/10th scale in Ruda Śląska/Katowice

:-)

Ruda Śląska 2014-05 Nitro cars ;)

Sun ultra 10

Back to home :)

Sun ultra 10, 450mhz, 512 mb, 2x hdd ata 20gb

Power of SQL

And again ... I've discovered power of SQL in PostgreSQL db ...

begin;

insert into przetargi_zalaczniki
(
    przetarg_id,
    zalacznik,
    plik,
    createdby,
    datapublikacji
 )
select 991, zalacznik, plik, createdby, '2014-05-14 14:55:05'
from przetargi_zalaczniki
where przetarg_id=970;

commit;

nice blog about shepherd cars in FI

nice blog about shepherd cars in FI

http://raddad-racinginfinland.blogspot.com

Power of sfdisk

sfdisk -d /dev/sda > file

cat file | sfdisk /dev/sdb
cat file | sfdisk /dev/sdc
cat file | sfdisk /dev/sdd


;)
maybe ...