When I try to connect to my monitoring system with desktop widget Nagstamon, Nagstamon was not able to connect due to SSL certificate validation problem. I’m using certificate from CAcert.org.
After a while of hacking I have found this workaround in source code. This is the wrong way: Pokračovať v čítaní
For more details see man x509
echo '' | \
openssl s_client -connect ldap.hostname.sk:ldaps -status 2>/dev/null | \
openssl x509 -noout -issuer_hash
The following query lists all grants for nonexistent databases:
/* grants in mysql.db for nonexistent databases */ SELECT DISTINCT db FROM mysql.db AS d LEFT JOIN information_schema.SCHEMATA AS s ON (d.db = s.SCHEMA_NAME) WHERE s.SCHEMA_NAME IS NULL; /* grants cleanup */ DELETE mysql.db FROM mysql.db LEFT JOIN information_schema.SCHEMATA ON (mysql.db.db = information_schema.SCHEMATA.SCHEMA_NAME) WHERE information_schema.SCHEMATA.SCHEMA_NAME IS NULL;
/* databases withouth grants */ \ SELECT DISTINCT s.SCHEMA_NAME FROM information_schema.SCHEMATA AS s LEFT JOIN mysql.db AS d ON (d.db = s.SCHEMA_NAME) WHERE d.db IS NULL;
Queries are not complete, you are welcome to add other queries.
initramfs-tools-cryptroot-as-password-once
I bought a new hard drive. Because I protect all my harddisk with encryption, I setup LUKS for new harddrive too. But init scripts ask password for every encrypted partition and I want enter my harddisk password only once. I have started with googling but I wasn’t succesfull. I have found this thread about the same problem. But author didn’t provide patch and uploaded *.tar.gz archive is no longer available. Pokračovať v čítaní
Developer at work
Angry developer
1465 HY000 ER_NO_TRIGGERS_ON_SYSTEM_SCHEMA Triggers can not be created on system tables
Do you need to discover what IP netblocks are owned and operated by Google to perhaps add to your firewall ACLs?
With dynamic zones available in Shorewall, you are able to define firewall rules and to filter network traffic based on the domain name. For example, you can permit IMAPS connection only to gmail.com domain. Problem is that Google cluster is very big and you are always connecting to different IP address. So you can’t define static rules for traffic filtering.
Here is little HOWTO do this.
Pokračovať v čítaní
Píšete stored procedúru pre MySQL na spracovanie nejakých dát. Používate na to svoj obľúbený editor a túto procedúru udržiavate ako súbor na disku.
Commitnete svoj výtvor do verzionovacieho nástroja a naimportujete svoju procedúru do MySQL:
Na kontrolu SSL certifikátu použijeme známy nástroj :
openssl s_client -starttls xmpp -connect jabber.hostname.sk:5222
Skript na aktualizáciu SSL certifikátov som pridal na github.
