Hodžův blog

Archive for the 'Služby' Category

16 Zář

Courier IMAP & POP3 – regenerate SSL certificates on Debian GNU Linux

# 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

19 Srp

MySQL – Creating a user with root privilages

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

14 Kvě

HowTo: Bind9 – disable IPv6 (couldn’t add command channel ::1#953: address not available)

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

23 Led

MySQL – Remove Duplicate Data or Rows

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

06 Říj

Změna kódování databáze a tabulky u MySQL

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;

09 Bře

HowTo fix Warning: Couldn’t execute ‚show events‘: Access denied for user ‚root’@’localhost‘ to database ‚performance_schema‘ (1044)

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

29 Pro

HowTo fix Warning: Skipping the data of table mysql.event. Specify the –events option explicitly.

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

24 Čvc

lftp – Fatal error: Certificate verification: Not trusted

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

02 Zář

HowTo resolve ProFTPD problem: Fatal: unknown configuration directive ‚SQLHomedirOnDemand‘ on line xxx of ‚/etc/proftpd/proftpd.conf‘

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

01 Srp

HowTo install Oracle Instant Client and PHP OCI8 module under Debian Squueze (Ubuntu) 64bit

1) Download the Basic and the SDK packages from http://www.oracle.com (registration needed). # mkdir -p /opt/oracle/instantclient # cd /opt/oracle/instantclient # wget http://download.oracle.com/otn/linux/instantclient/112020/instantclient-basic-linux-x86-64-11.2.0.2.0.zip # wget http://download.oracle.com/otn/linux/instantclient/112020/instantclient-sdk-linux-x86-64-11.2.0.2.0.zip“

Hodžův blog is is proudly powered by Wordpress and the Magellan Theme