Notepad:Notepad: Difference between revisions
From Amar
Jump to navigationJump to search
→Windows: Firefox Vista |
Added samba page |
||
(152 intermediate revisions by 7 users not shown) | |||
Line 1: | Line 1: | ||
== Unfiled == | == Unfiled == | ||
* [[Notepad:Benchmark|Benchmark]] | * See the whole drive bash tool | ||
ncdu | |||
* [[Notepad:Mac| Mac Tricks]] | |||
* [[Notepad:Benchmark|Benchmark]] | |||
* [[Notepad:PIX Capture| PIX Capture]] | * [[Notepad:PIX Capture| PIX Capture]] | ||
* [http://www. | * [http://lythgoes.net/genealogy/software.php genealogy site building] | ||
* [http://www.ietf.org/rfc/rfc2445.txt iCalendar RFC] | |||
* [http://resources.hewitt.com/benefits/experian/ Exeprian Benefits] | |||
* [http://www.getafreelancer.com/ get a freelancer] | |||
* [http://travel.state.gov/visa/immigrants/types/types_1322.html Visa Lottery] | |||
* [[Notepad:PHP Test | PHP Test]] | |||
* [[Notepad:PHP Result | PHP Result]] | |||
* [[Notepad:favicon | How to set up favicon]] | |||
* Quicken Payroll : ViewMyPaycheck Employees Menu > Manage Payroll Cloud Services > CHECK the ViewMyPaycheck box > Enter the PIN > click Save Changes. That's it! | |||
* Thunderbird User CSS in userChrome.css (roaming profile) | |||
<syntaxhighlight lang='css' line> | |||
#threadTree treechildren::-moz-tree-row(odd) { | |||
-moz-appearance: none !important; | |||
background-color: #your_color_here !important; } | |||
#threadTree treechildren::-moz-tree-row(odd, selected) { | |||
background-color: Highlight !important; | |||
} | |||
</syntaxhighlight> | |||
== Windows == | == Windows == | ||
Line 8: | Line 29: | ||
* [http://softwarepatch.com/windows/ The Windows Update Patch] | * [http://softwarepatch.com/windows/ The Windows Update Patch] | ||
* [[Notepad:Wrap up background Tasks|Wrap up background Tasks]] | * [[Notepad:Wrap up background Tasks|Wrap up background Tasks]] | ||
* [ | * [[Notepad:WindowsTime Windows Time Service and Internet Communications]] | ||
* [http://www.enterprisenetworkingplanet.com/netos/article.php/3487081 Join Samba 3 to your Active Directory Domain] | * [http://www.enterprisenetworkingplanet.com/netos/article.php/3487081 Join Samba 3 to your Active Directory Domain] | ||
* [http://kb.mozillazine.org/Windows_Media_Player#Missing_plugin Missing Media Player in Vista/Firefox] | * [http://kb.mozillazine.org/Windows_Media_Player#Missing_plugin Missing Media Player in Vista/Firefox] | ||
* [http://blogs.zdnet.com/Bott/?p=224 rearm Vista] <code>slmgr.vbs -rearm</code> | |||
* [http://www.microsoft.com/technet/security/advisory/935964.mspx Windows DNS security hack] | |||
* [http://support.microsoft.com/kb/932818 Media Center patch for Vista] | |||
* [http://www.microsoft.com/technet/sysinternals/default.mspx Sysinternals for windows] | |||
* [http://www.microsoft.com/whdc/devtools/debugging/default.mspx Debugging Tools for Windows] | |||
* [http://www.nobodix.org/seb/win2003_adminpass.html How to reset the Domain Admin Password under Windows 2003 Server] | |||
* [http://www.intowindows.com/how-to-install-windows-7vista-from-usb-drive-detailed-100-working-guide/ Install Windows 7 on USB] | |||
* [[Notepad:Rejoin Domain]] | |||
* [[Notepad:Enable Num Lock]] | |||
* [https://superuser.com/questions/1060567/cpu-constantly-at-100-in-task-manager-but-not-in-process-explorer/1061436#1061436 Task Manager at 100% ] | |||
C:\WINDOWS\system32>PowerCfg /SETACVALUEINDEX SCHEME_CURRENT SUB_PROCESSOR IDLEDISABLE 000 | |||
C:\WINDOWS\system32>PowerCfg /SETACTIVE SCHEME_CURRENT | |||
* [https://www.tenforums.com/tutorials/80520-enable-disable-domain-users-sign-pin-windows-10-a.html Disable PIN and enable fingerprint for domain] | |||
* [[Notepad::Prepare AD for windows 2012]] | |||
* DISM Cleanup | |||
DISM /Online /Cleanup-Image /RestoreHealth /source:WIM:F:\Sources\Install.wim:1 /LimitAccess | |||
DISM /Online /Cleanup-Image /RestoreHealth /source:F:\sources /LimitAccess | |||
* [https://www.nartac.com/Products/IISCrypto/Download SSL Security Best Practices Nartac IISCrypto] | |||
* [https://www.windowscentral.com/how-fix-mapped-network-drive-problem-windows-10-october-2018-update Fix Mapped Network Drive Disconnect] | |||
* [[Notepad:Fix Windows Directory Permissions]] | |||
== URLs == | == URLs == | ||
Line 16: | Line 57: | ||
* [http://everything2.com/index.pl?node=Special%20Alt%20key%20characters%20%26%20accents Special Alt Keys & Accents] | * [http://everything2.com/index.pl?node=Special%20Alt%20key%20characters%20%26%20accents Special Alt Keys & Accents] | ||
* [http://scoreboard.keynote.com/scoreboard/Main.aspx?Login=Y&Username=public&Password=public Keynote Internet Health Report] | * [http://scoreboard.keynote.com/scoreboard/Main.aspx?Login=Y&Username=public&Password=public Keynote Internet Health Report] | ||
* [http://www.globalwholesalers.biz/ Global Wholesalers Sattelite] | |||
* [http://f2atv.com F2 ATV Sat code] | |||
* [http://www.simonshepherd.supanet.com/tea.htm The Tiny Encryption Algorithm (TEA)] | |||
* [[Notepad:Water Cooling|Water Cooling]] | |||
* [https://developer.motorola.com/docstools/USB_Drivers/Handset_USB_Driver/ Motorola USB drivers] | |||
* [https://www.ssllabs.com/ssltest/index.html SSL Labs SSL cert check] | |||
* [https://dnssec-analyzer.verisignlabs.com/ DNSSEC Analyzer] | |||
* [https://dns.google.com/query?type=A&dnssec=true Google DNS test] | |||
== Linux Tricks == | == Linux Tricks == | ||
Linux stuff I often have to lookup. Just my personal list of things. | Linux stuff I often have to lookup. Just my personal list of things. | ||
* [[Notepad: | *[[Notepad:Linux | Linux Tips and Tricks]] | ||
* [[Notepad: | |||
* | == MySQL == | ||
* [[Notepad:UTF8|UTF8 ]] | |||
* [[Notepad: | * Get a list of processes to kill | ||
* [http:// | <syntaxhighlight lang='SQL' line> | ||
* [[Notepad: | SELECT GROUP_CONCAT(CONCAT('KILL ',id,';') SEPARATOR ' ') | ||
* | 'Paste the following query to kill all processes' | ||
FROM information_schema.processlist | |||
WHERE user<>'system user' | |||
</syntaxhighlight> | |||
* install latest MariaDB | |||
curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash | |||
* Move/Rename a DB to another | |||
mysql -u username -ppassword old_db -sNe 'show tables' | while read table; \ | |||
do mysql -u username -ppassword -sNe "rename table old_db.$table to new_db.$table"; done | |||
* database dump without charset | |||
mysqldump -u <user> -p --skip-add-locks --skip-set-charset <DB> <tables ...> | |||
* Disable foreign key checks in a session | |||
SET FOREIGN_KEY_CHECKS=0; | |||
== SSL Certificates == | |||
* [[Notepad:SSL|SSL Certificates]] | |||
== Version Control == | |||
* [http://www.sbf5.com/~cduan/technical/git/ Understanding git conceptually] | |||
* [[Notepad:SVN Create| SVN Create New Repository with branches]] | |||
* make a file executable in git (+x) | |||
git update-index --chmod=+x filename.sh | |||
== Oracle == | == Oracle == | ||
Line 37: | Line 108: | ||
* [http://www.jlcomp.demon.co.uk/faq/pin_table.html Oracle Pin in memory] | * [http://www.jlcomp.demon.co.uk/faq/pin_table.html Oracle Pin in memory] | ||
* [http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1353453813863 Oracle View Performance] | * [http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1353453813863 Oracle View Performance] | ||
* [[Notepad:Oracle Pagination|Oracle Pagination]] | |||
== SC Backup == | |||
*[[Notepad:Dell OpenManage | Dell Openmanage Install]] | |||
== KVM == | |||
*[[Notepad:KVM | KVM]] | |||
* [https://computingforgeeks.com/how-to-convert-virtualbox-disk-image-vdi-and-img-to-qcow2-format/ How to convert virtualbox disk image vdi and img to qcow2 format] | |||
== QNAP == | |||
*[[Notepad:QNAP | QNAP]] | |||
== Zend Framework == | |||
* [[Notepad:Zend Setup]] | |||
== Video ffmpeg == | |||
Convert wmv to mp4 | |||
'''ffmpeg''' -i ''<input>'' -c:v libx264 -c:a aac -strict -2 -q:a 100 -crf 23 ''<output>'' | |||
== Zimbra == | |||
* [https://lorenzo.mile.si/letsencrypt-zimbra-the-easy-way/242/ Automatic Zimbra certbot] | |||
* [https://wiki.zimbra.com/wiki/Installing_a_LetsEncrypt_SSL_Certificate Zimbra letsencrypt] | |||
* [https://wiki.zimbra.com/wiki/Configuring_for_DKIM_Signing Zimbra DKIM] | |||
* [https://gist.github.com/ugurerkan/6e9e3addf9a574ad0c57039164570e6f Zimbra Letsencrypt SSL Renew] | |||
* [[Notepad:Zimbra Zimbra Let's encrypt | Zimbra Let's encrypt ]] | |||
* [https://community.letsencrypt.org/t/zimbra-renewal-problems-with-r3/160842/38 Zombra renewal - Problems with R3] | |||
Working with the following for chain.pem: | |||
-----BEGIN CERTIFICATE----- | |||
MIIFFjCCAv6gAwIBAgIRAJErCErPDBinU/bWLiWnX1owDQYJKoZIhvcNAQELBQAw | |||
TzELMAkGA1UEBhMCVVMxKTAnBgNVBAoTIEludGVybmV0IFNlY3VyaXR5IFJlc2Vh | |||
cmNoIEdyb3VwMRUwEwYDVQQDEwxJU1JHIFJvb3QgWDEwHhcNMjAwOTA0MDAwMDAw | |||
WhcNMjUwOTE1MTYwMDAwWjAyMQswCQYDVQQGEwJVUzEWMBQGA1UEChMNTGV0J3Mg | |||
RW5jcnlwdDELMAkGA1UEAxMCUjMwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEK | |||
AoIBAQC7AhUozPaglNMPEuyNVZLD+ILxmaZ6QoinXSaqtSu5xUyxr45r+XXIo9cP | |||
R5QUVTVXjJ6oojkZ9YI8QqlObvU7wy7bjcCwXPNZOOftz2nwWgsbvsCUJCWH+jdx | |||
sxPnHKzhm+/b5DtFUkWWqcFTzjTIUu61ru2P3mBw4qVUq7ZtDpelQDRrK9O8Zutm | |||
NHz6a4uPVymZ+DAXXbpyb/uBxa3Shlg9F8fnCbvxK/eG3MHacV3URuPMrSXBiLxg | |||
Z3Vms/EY96Jc5lP/Ooi2R6X/ExjqmAl3P51T+c8B5fWmcBcUr2Ok/5mzk53cU6cG | |||
/kiFHaFpriV1uxPMUgP17VGhi9sVAgMBAAGjggEIMIIBBDAOBgNVHQ8BAf8EBAMC | |||
AYYwHQYDVR0lBBYwFAYIKwYBBQUHAwIGCCsGAQUFBwMBMBIGA1UdEwEB/wQIMAYB | |||
Af8CAQAwHQYDVR0OBBYEFBQusxe3WFbLrlAJQOYfr52LFMLGMB8GA1UdIwQYMBaA | |||
FHm0WeZ7tuXkAXOACIjIGlj26ZtuMDIGCCsGAQUFBwEBBCYwJDAiBggrBgEFBQcw | |||
AoYWaHR0cDovL3gxLmkubGVuY3Iub3JnLzAnBgNVHR8EIDAeMBygGqAYhhZodHRw | |||
Oi8veDEuYy5sZW5jci5vcmcvMCIGA1UdIAQbMBkwCAYGZ4EMAQIBMA0GCysGAQQB | |||
gt8TAQEBMA0GCSqGSIb3DQEBCwUAA4ICAQCFyk5HPqP3hUSFvNVneLKYY611TR6W | |||
PTNlclQtgaDqw+34IL9fzLdwALduO/ZelN7kIJ+m74uyA+eitRY8kc607TkC53wl | |||
ikfmZW4/RvTZ8M6UK+5UzhK8jCdLuMGYL6KvzXGRSgi3yLgjewQtCPkIVz6D2QQz | |||
CkcheAmCJ8MqyJu5zlzyZMjAvnnAT45tRAxekrsu94sQ4egdRCnbWSDtY7kh+BIm | |||
lJNXoB1lBMEKIq4QDUOXoRgffuDghje1WrG9ML+Hbisq/yFOGwXD9RiX8F6sw6W4 | |||
avAuvDszue5L3sz85K+EC4Y/wFVDNvZo4TYXao6Z0f+lQKc0t8DQYzk1OXVu8rp2 | |||
yJMC6alLbBfODALZvYH7n7do1AZls4I9d1P4jnkDrQoxB3UqQ9hVl3LEKQ73xF1O | |||
yK5GhDDX8oVfGKF5u+decIsH4YaTw7mP3GFxJSqv3+0lUFJoi5Lc5da149p90Ids | |||
hCExroL1+7mryIkXPeFM5TgO9r0rvZaBFOvV2z0gp35Z0+L4WPlbuEjN/lxPFin+ | |||
HlUjr8gRsI3qfJOQFy/9rKIJR0Y/8Omwt/8oTWgy1mdeHmmjk7j1nYsvC9JSQ6Zv | |||
MldlTTKB3zhThV1+XWYp6rjd5JW1zbVWEkLNxE7GJThEUG3szgBVGP7pSWTUTsqX | |||
nLRbwHOoq7hHwg== | |||
-----END CERTIFICATE----- | |||
-----BEGIN CERTIFICATE----- | |||
MIIFazCCA1OgAwIBAgIRAIIQz7DSQONZRGPgu2OCiwAwDQYJKoZIhvcNAQELBQAw | |||
TzELMAkGA1UEBhMCVVMxKTAnBgNVBAoTIEludGVybmV0IFNlY3VyaXR5IFJlc2Vh | |||
cmNoIEdyb3VwMRUwEwYDVQQDEwxJU1JHIFJvb3QgWDEwHhcNMTUwNjA0MTEwNDM4 | |||
WhcNMzUwNjA0MTEwNDM4WjBPMQswCQYDVQQGEwJVUzEpMCcGA1UEChMgSW50ZXJu | |||
ZXQgU2VjdXJpdHkgUmVzZWFyY2ggR3JvdXAxFTATBgNVBAMTDElTUkcgUm9vdCBY | |||
MTCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBAK3oJHP0FDfzm54rVygc | |||
h77ct984kIxuPOZXoHj3dcKi/vVqbvYATyjb3miGbESTtrFj/RQSa78f0uoxmyF+ | |||
0TM8ukj13Xnfs7j/EvEhmkvBioZxaUpmZmyPfjxwv60pIgbz5MDmgK7iS4+3mX6U | |||
A5/TR5d8mUgjU+g4rk8Kb4Mu0UlXjIB0ttov0DiNewNwIRt18jA8+o+u3dpjq+sW | |||
T8KOEUt+zwvo/7V3LvSye0rgTBIlDHCNAymg4VMk7BPZ7hm/ELNKjD+Jo2FR3qyH | |||
B5T0Y3HsLuJvW5iB4YlcNHlsdu87kGJ55tukmi8mxdAQ4Q7e2RCOFvu396j3x+UC | |||
B5iPNgiV5+I3lg02dZ77DnKxHZu8A/lJBdiB3QW0KtZB6awBdpUKD9jf1b0SHzUv | |||
KBds0pjBqAlkd25HN7rOrFleaJ1/ctaJxQZBKT5ZPt0m9STJEadao0xAH0ahmbWn | |||
OlFuhjuefXKnEgV4We0+UXgVCwOPjdAvBbI+e0ocS3MFEvzG6uBQE3xDk3SzynTn | |||
jh8BCNAw1FtxNrQHusEwMFxIt4I7mKZ9YIqioymCzLq9gwQbooMDQaHWBfEbwrbw | |||
qHyGO0aoSCqI3Haadr8faqU9GY/rOPNk3sgrDQoo//fb4hVC1CLQJ13hef4Y53CI | |||
rU7m2Ys6xt0nUW7/vGT1M0NPAgMBAAGjQjBAMA4GA1UdDwEB/wQEAwIBBjAPBgNV | |||
HRMBAf8EBTADAQH/MB0GA1UdDgQWBBR5tFnme7bl5AFzgAiIyBpY9umbbjANBgkq | |||
hkiG9w0BAQsFAAOCAgEAVR9YqbyyqFDQDLHYGmkgJykIrGF1XIpu+ILlaS/V9lZL | |||
ubhzEFnTIZd+50xx+7LSYK05qAvqFyFWhfFQDlnrzuBZ6brJFe+GnY+EgPbk6ZGQ | |||
3BebYhtF8GaV0nxvwuo77x/Py9auJ/GpsMiu/X1+mvoiBOv/2X/qkSsisRcOj/KK | |||
NFtY2PwByVS5uCbMiogziUwthDyC3+6WVwW6LLv3xLfHTjuCvjHIInNzktHCgKQ5 | |||
ORAzI4JMPJ+GslWYHb4phowim57iaztXOoJwTdwJx4nLCgdNbOhdjsnvzqvHu7Ur | |||
TkXWStAmzOVyyghqpZXjFaH3pO3JLF+l+/+sKAIuvtd7u+Nxe5AW0wdeRlN8NwdC | |||
jNPElpzVmbUq4JUagEiuTDkHzsxHpFKVK7q4+63SM1N95R1NbdWhscdCb+ZAJzVc | |||
oyi3B43njTOQ5yOf+1CceWxG1bQVs5ZufpsMljq4Ui0/1lvh+wjChP4kqKOJ2qxq | |||
4RgqsahDYVvTH9w7jXbyLeiNdd8XM2w9U/t7y0Ff/9yi0GE44Za4rF2LN9d11TPA | |||
mRGunUHBcnWEvgJBQl9nJEiU0Zsnvgc/ubhPgXRR4Xq37Z0j4r7g1SgEEzwxA57d | |||
emyPxgcYxn/eR44/KJ4EBs+lVDR3veyJm+kXQ99b21/+jh5Xos1AnX5iItreGCc= | |||
-----END CERTIFICATE----- | |||
== AWS == | |||
* [https://blog.alejandrocelaya.com/2016/08/16/setup-a-lets-encrypt-certificate-in-a-aws-elastic-load-balancer/ AWS Letsencrypt Manual Setup] | |||
** Load balance instances to 1 | |||
** Generate new cert | |||
letsencrypt certonly --webroot -w /var/www/mydomain -d mydomain.com -d www.mydomain.com -w /var/www/cool-site -d cool-site.com -d www.cool-site.com | |||
** deploy new cert to all | |||
** upload into AWS *Load Balance* *Listeners* *SSL Certificate* (We get a weird error but it works) | |||
** Load balance instances back to all | |||
== [[Notepad:Hackintosh | Hackintosh Tricks]] == | |||
== [[Notepad:Samba | Samba/Active Directory/Bind]] == | |||
== Firefox == | |||
=== [http://about:config about:config] === | |||
layout.css.devPixelsPerPx | |||
to set the textsize on high res displays | |||
== Wireguard == | |||
== Links == | |||
* [https://blog.scottlowe.org/2021/06/28/using-wireguard-on-mac-via-cli/ Using WireGuard on macOS via the CLI] | |||
* [https://blog.scottlowe.org/2021/08/04/starting-wireguard-interfaces-automatically-launchd-macos/ Starting Wiguard Automatically on a Mac] | |||
=== [https://serverfault.com/questions/1013535/unable-to-configure-wireguard-to-use-secondary-ip-address-instead-of-main-ip-add Wireguard using a secondary interface with iptables help] === | |||
=== IP link example === | |||
ip link add wgpillgram type wireguard | |||
wg setconf wgpillgram /dev/fd/63 | |||
ip -4 address add 172.26.27.1/24 dev wgpillgram | |||
ip link set mtu 1420 up dev wgpillgram | |||
ip -4 route add 10.26.27.5/32 dev wgpillgram | |||
---- | ---- | ||
{{wiki}} | |||
Latest revision as of 22:52, 26 February 2024
Unfiled
- See the whole drive bash tool
ncdu
- Mac Tricks
- Benchmark
- PIX Capture
- genealogy site building
- iCalendar RFC
- Exeprian Benefits
- get a freelancer
- Visa Lottery
- PHP Test
- PHP Result
- How to set up favicon
- Quicken Payroll : ViewMyPaycheck Employees Menu > Manage Payroll Cloud Services > CHECK the ViewMyPaycheck box > Enter the PIN > click Save Changes. That's it!
- Thunderbird User CSS in userChrome.css (roaming profile)
#threadTree treechildren::-moz-tree-row(odd) {
-moz-appearance: none !important;
background-color: #your_color_here !important; }
#threadTree treechildren::-moz-tree-row(odd, selected) {
background-color: Highlight !important;
}
Windows
- Prevent Reboots
- The Windows Update Patch
- Wrap up background Tasks
- Notepad:WindowsTime Windows Time Service and Internet Communications
- Join Samba 3 to your Active Directory Domain
- Missing Media Player in Vista/Firefox
- rearm Vista
slmgr.vbs -rearm
- Windows DNS security hack
- Media Center patch for Vista
- Sysinternals for windows
- Debugging Tools for Windows
- How to reset the Domain Admin Password under Windows 2003 Server
- Install Windows 7 on USB
- Notepad:Rejoin Domain
- Notepad:Enable Num Lock
- Task Manager at 100%
C:\WINDOWS\system32>PowerCfg /SETACVALUEINDEX SCHEME_CURRENT SUB_PROCESSOR IDLEDISABLE 000 C:\WINDOWS\system32>PowerCfg /SETACTIVE SCHEME_CURRENT
DISM /Online /Cleanup-Image /RestoreHealth /source:WIM:F:\Sources\Install.wim:1 /LimitAccess DISM /Online /Cleanup-Image /RestoreHealth /source:F:\sources /LimitAccess
- SSL Security Best Practices Nartac IISCrypto
- Fix Mapped Network Drive Disconnect
- Notepad:Fix Windows Directory Permissions
URLs
- Ajax Howto
- Special Alt Keys & Accents
- Keynote Internet Health Report
- Global Wholesalers Sattelite
- F2 ATV Sat code
- The Tiny Encryption Algorithm (TEA)
- Water Cooling
- Motorola USB drivers
- SSL Labs SSL cert check
- DNSSEC Analyzer
- Google DNS test
Linux Tricks
Linux stuff I often have to lookup. Just my personal list of things.
MySQL
- UTF8
- Get a list of processes to kill
SELECT GROUP_CONCAT(CONCAT('KILL ',id,';') SEPARATOR ' ')
'Paste the following query to kill all processes'
FROM information_schema.processlist
WHERE user<>'system user'
- install latest MariaDB
curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash
- Move/Rename a DB to another
mysql -u username -ppassword old_db -sNe 'show tables' | while read table; \ do mysql -u username -ppassword -sNe "rename table old_db.$table to new_db.$table"; done
- database dump without charset
mysqldump -u <user> -p --skip-add-locks --skip-set-charset <DB> <tables ...>
- Disable foreign key checks in a session
SET FOREIGN_KEY_CHECKS=0;
SSL Certificates
Version Control
- Understanding git conceptually
- SVN Create New Repository with branches
- make a file executable in git (+x)
git update-index --chmod=+x filename.sh
Oracle
- Oracle Build Custom Aggregate Function
- Oracle Timer
- Oracle Pin in memory
- Oracle View Performance
- Oracle Pagination
SC Backup
KVM
QNAP
Zend Framework
Video ffmpeg
Convert wmv to mp4
ffmpeg -i <input> -c:v libx264 -c:a aac -strict -2 -q:a 100 -crf 23 <output>
Zimbra
- Automatic Zimbra certbot
- Zimbra letsencrypt
- Zimbra DKIM
- Zimbra Letsencrypt SSL Renew
- Zimbra Let's encrypt
- Zombra renewal - Problems with R3
Working with the following for chain.pem:
-----BEGIN CERTIFICATE----- MIIFFjCCAv6gAwIBAgIRAJErCErPDBinU/bWLiWnX1owDQYJKoZIhvcNAQELBQAw TzELMAkGA1UEBhMCVVMxKTAnBgNVBAoTIEludGVybmV0IFNlY3VyaXR5IFJlc2Vh cmNoIEdyb3VwMRUwEwYDVQQDEwxJU1JHIFJvb3QgWDEwHhcNMjAwOTA0MDAwMDAw WhcNMjUwOTE1MTYwMDAwWjAyMQswCQYDVQQGEwJVUzEWMBQGA1UEChMNTGV0J3Mg RW5jcnlwdDELMAkGA1UEAxMCUjMwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEK AoIBAQC7AhUozPaglNMPEuyNVZLD+ILxmaZ6QoinXSaqtSu5xUyxr45r+XXIo9cP R5QUVTVXjJ6oojkZ9YI8QqlObvU7wy7bjcCwXPNZOOftz2nwWgsbvsCUJCWH+jdx sxPnHKzhm+/b5DtFUkWWqcFTzjTIUu61ru2P3mBw4qVUq7ZtDpelQDRrK9O8Zutm NHz6a4uPVymZ+DAXXbpyb/uBxa3Shlg9F8fnCbvxK/eG3MHacV3URuPMrSXBiLxg Z3Vms/EY96Jc5lP/Ooi2R6X/ExjqmAl3P51T+c8B5fWmcBcUr2Ok/5mzk53cU6cG /kiFHaFpriV1uxPMUgP17VGhi9sVAgMBAAGjggEIMIIBBDAOBgNVHQ8BAf8EBAMC AYYwHQYDVR0lBBYwFAYIKwYBBQUHAwIGCCsGAQUFBwMBMBIGA1UdEwEB/wQIMAYB Af8CAQAwHQYDVR0OBBYEFBQusxe3WFbLrlAJQOYfr52LFMLGMB8GA1UdIwQYMBaA FHm0WeZ7tuXkAXOACIjIGlj26ZtuMDIGCCsGAQUFBwEBBCYwJDAiBggrBgEFBQcw AoYWaHR0cDovL3gxLmkubGVuY3Iub3JnLzAnBgNVHR8EIDAeMBygGqAYhhZodHRw Oi8veDEuYy5sZW5jci5vcmcvMCIGA1UdIAQbMBkwCAYGZ4EMAQIBMA0GCysGAQQB gt8TAQEBMA0GCSqGSIb3DQEBCwUAA4ICAQCFyk5HPqP3hUSFvNVneLKYY611TR6W PTNlclQtgaDqw+34IL9fzLdwALduO/ZelN7kIJ+m74uyA+eitRY8kc607TkC53wl ikfmZW4/RvTZ8M6UK+5UzhK8jCdLuMGYL6KvzXGRSgi3yLgjewQtCPkIVz6D2QQz CkcheAmCJ8MqyJu5zlzyZMjAvnnAT45tRAxekrsu94sQ4egdRCnbWSDtY7kh+BIm lJNXoB1lBMEKIq4QDUOXoRgffuDghje1WrG9ML+Hbisq/yFOGwXD9RiX8F6sw6W4 avAuvDszue5L3sz85K+EC4Y/wFVDNvZo4TYXao6Z0f+lQKc0t8DQYzk1OXVu8rp2 yJMC6alLbBfODALZvYH7n7do1AZls4I9d1P4jnkDrQoxB3UqQ9hVl3LEKQ73xF1O yK5GhDDX8oVfGKF5u+decIsH4YaTw7mP3GFxJSqv3+0lUFJoi5Lc5da149p90Ids hCExroL1+7mryIkXPeFM5TgO9r0rvZaBFOvV2z0gp35Z0+L4WPlbuEjN/lxPFin+ HlUjr8gRsI3qfJOQFy/9rKIJR0Y/8Omwt/8oTWgy1mdeHmmjk7j1nYsvC9JSQ6Zv MldlTTKB3zhThV1+XWYp6rjd5JW1zbVWEkLNxE7GJThEUG3szgBVGP7pSWTUTsqX nLRbwHOoq7hHwg== -----END CERTIFICATE----- -----BEGIN CERTIFICATE----- MIIFazCCA1OgAwIBAgIRAIIQz7DSQONZRGPgu2OCiwAwDQYJKoZIhvcNAQELBQAw TzELMAkGA1UEBhMCVVMxKTAnBgNVBAoTIEludGVybmV0IFNlY3VyaXR5IFJlc2Vh cmNoIEdyb3VwMRUwEwYDVQQDEwxJU1JHIFJvb3QgWDEwHhcNMTUwNjA0MTEwNDM4 WhcNMzUwNjA0MTEwNDM4WjBPMQswCQYDVQQGEwJVUzEpMCcGA1UEChMgSW50ZXJu ZXQgU2VjdXJpdHkgUmVzZWFyY2ggR3JvdXAxFTATBgNVBAMTDElTUkcgUm9vdCBY MTCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBAK3oJHP0FDfzm54rVygc h77ct984kIxuPOZXoHj3dcKi/vVqbvYATyjb3miGbESTtrFj/RQSa78f0uoxmyF+ 0TM8ukj13Xnfs7j/EvEhmkvBioZxaUpmZmyPfjxwv60pIgbz5MDmgK7iS4+3mX6U A5/TR5d8mUgjU+g4rk8Kb4Mu0UlXjIB0ttov0DiNewNwIRt18jA8+o+u3dpjq+sW T8KOEUt+zwvo/7V3LvSye0rgTBIlDHCNAymg4VMk7BPZ7hm/ELNKjD+Jo2FR3qyH B5T0Y3HsLuJvW5iB4YlcNHlsdu87kGJ55tukmi8mxdAQ4Q7e2RCOFvu396j3x+UC B5iPNgiV5+I3lg02dZ77DnKxHZu8A/lJBdiB3QW0KtZB6awBdpUKD9jf1b0SHzUv KBds0pjBqAlkd25HN7rOrFleaJ1/ctaJxQZBKT5ZPt0m9STJEadao0xAH0ahmbWn OlFuhjuefXKnEgV4We0+UXgVCwOPjdAvBbI+e0ocS3MFEvzG6uBQE3xDk3SzynTn jh8BCNAw1FtxNrQHusEwMFxIt4I7mKZ9YIqioymCzLq9gwQbooMDQaHWBfEbwrbw qHyGO0aoSCqI3Haadr8faqU9GY/rOPNk3sgrDQoo//fb4hVC1CLQJ13hef4Y53CI rU7m2Ys6xt0nUW7/vGT1M0NPAgMBAAGjQjBAMA4GA1UdDwEB/wQEAwIBBjAPBgNV HRMBAf8EBTADAQH/MB0GA1UdDgQWBBR5tFnme7bl5AFzgAiIyBpY9umbbjANBgkq hkiG9w0BAQsFAAOCAgEAVR9YqbyyqFDQDLHYGmkgJykIrGF1XIpu+ILlaS/V9lZL ubhzEFnTIZd+50xx+7LSYK05qAvqFyFWhfFQDlnrzuBZ6brJFe+GnY+EgPbk6ZGQ 3BebYhtF8GaV0nxvwuo77x/Py9auJ/GpsMiu/X1+mvoiBOv/2X/qkSsisRcOj/KK NFtY2PwByVS5uCbMiogziUwthDyC3+6WVwW6LLv3xLfHTjuCvjHIInNzktHCgKQ5 ORAzI4JMPJ+GslWYHb4phowim57iaztXOoJwTdwJx4nLCgdNbOhdjsnvzqvHu7Ur TkXWStAmzOVyyghqpZXjFaH3pO3JLF+l+/+sKAIuvtd7u+Nxe5AW0wdeRlN8NwdC jNPElpzVmbUq4JUagEiuTDkHzsxHpFKVK7q4+63SM1N95R1NbdWhscdCb+ZAJzVc oyi3B43njTOQ5yOf+1CceWxG1bQVs5ZufpsMljq4Ui0/1lvh+wjChP4kqKOJ2qxq 4RgqsahDYVvTH9w7jXbyLeiNdd8XM2w9U/t7y0Ff/9yi0GE44Za4rF2LN9d11TPA mRGunUHBcnWEvgJBQl9nJEiU0Zsnvgc/ubhPgXRR4Xq37Z0j4r7g1SgEEzwxA57d emyPxgcYxn/eR44/KJ4EBs+lVDR3veyJm+kXQ99b21/+jh5Xos1AnX5iItreGCc= -----END CERTIFICATE-----
AWS
- AWS Letsencrypt Manual Setup
- Load balance instances to 1
- Generate new cert
letsencrypt certonly --webroot -w /var/www/mydomain -d mydomain.com -d www.mydomain.com -w /var/www/cool-site -d cool-site.com -d www.cool-site.com
- deploy new cert to all
- upload into AWS *Load Balance* *Listeners* *SSL Certificate* (We get a weird error but it works)
- Load balance instances back to all
Hackintosh Tricks
Samba/Active Directory/Bind
Firefox
about:config
layout.css.devPixelsPerPx
to set the textsize on high res displays
Wireguard
Links
Wireguard using a secondary interface with iptables help
IP link example
ip link add wgpillgram type wireguard wg setconf wgpillgram /dev/fd/63 ip -4 address add 172.26.27.1/24 dev wgpillgram ip link set mtu 1420 up dev wgpillgram ip -4 route add 10.26.27.5/32 dev wgpillgram
<insert>googlesearchwiki</insert> | <insert>paypal</insert> | <insert>analytics</insert> |