Hodžův blog

Reset the interface through SSH. ssh root@my.hp.ilo cd /map1 reset

# rm -f /etc/courier/imapd.pem # rm -f /etc/courier/pop3d.pem # vi /etc/courier/imapd.cnf # vi /etc/courier/pop3d.cnf # mkimapdcert # mkpop3dcert # /etc/init.d/courier-imap-ssl restart # /etc/init.d/courier-pop-ssl restart

CREATE USER ‚new_user’@’%‘ IDENTIFIED BY ‚some_pass‘; GRANT ALL PRIVILEGES ON *.* TO ‚new_user’@’%‘ WITH GRANT OPTION; FLUSH PRIVILEGES;

Disable IPv6 in system # echo „net.ipv6.conf.all.disable_ipv6 = 1“ >> /etc/sysctl.conf # echo „net.ipv6.conf.default.disable_ipv6 = 1“ >> /etc/sysctl.conf # echo „net.ipv6.conf.lo.disable_ipv6 = 1“ >> /etc/sysctl.conf # /sbin/sysctl -p /etc/sysctl.conf

DELETE FROM mytable USING mytable, mytable as virtualtable WHERE (NOT mytable.id=virtualtable.id) AND (mytable.fieldname=virtualtable.fieldname) Simple isn’t it?

ALTER DATABASE `název_databáze` CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE `název_tabulky` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; Hint: mysql> show character set;

This is a virtual database so you will need to add the option –skip-events to make it work.

Try this workaround: mysqldump -uroot –events –ignore-table=mysql.event mysql

I always get an error: $ lftp user@server:/directory Password: ls: Fatal error: Certificate verification: Not trusted To fix this issue run simple command in lftp shell set ssl:verify-certificate no or disble certificate verification in lftp configuration file echo „ssl:verify-certificate no“ >> ~/.lftp/rc

This directive has been deprecated with ProFTPD 1.3.1rc1. Please use CreateHome instead. http://www.proftpd.org/docs/howto/CreateHome.html