echo „“ >> /etc/lftp.conf echo „set ftp:ssl-allow true“ >> /etc/lftp.conf echo „set ftp:ssl-force true“ >> /etc/lftp.conf echo „set ftp:ssl-protect-data true“ >> /etc/lftp.conf echo „set ftp:ssl-protect-list true“ >> /etc/lftp.conf
Before: # lsusb | grep -i huawei Bus 002 Device 007: ID 12d1:14fe Huawei Technologies Co., Ltd Fix it with command: usb_modeswitch -v 12d1 -p 14fe -J After: # lsusb | grep -i huawei Bus 008 Device 005: ID 12d1:1506 Huawei Technologies Co., Ltd. E398 LTE/UMTS/GSM Modem/Networkcard You can also create a udev rule: vi […]
# wget –user=ftp –password=ftp ftp://ftp.rs.internic.net/domain/db.cache -O /etc/bind/db.root
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.