Notepad:Notepad: Difference between revisions

From Amar
Jump to navigationJump to search
← Older editNewer edit →
VisualWikitext
Line 129: Line 129:
* [https://www.linuxquestions.org/questions/slackware-14/how-to-configure-iptables-for-router-with-2-public-ip-addresses-4175618196/ Example routing iptables firewall]
* [https://www.linuxquestions.org/questions/slackware-14/how-to-configure-iptables-for-router-with-2-public-ip-addresses-4175618196/ Example routing iptables firewall]
* [[Notepad:Disable IPv6 | Disable IPv6]]
* [[Notepad:Disable IPv6 | Disable IPv6]]
* [https://serverfault.com/questions/620019/smartctl-megaraid-how-to-find-the-right-device-node-for-an-adapter find the right device for smartctl]


== MySQL ==
== MySQL ==

Revision as of 17:01, 27 May 2021

Unfiled

#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

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

URLs

Linux Tricks

Linux stuff I often have to lookup. Just my personal list of things. 

shutdown -rF now

xauth add `hostname`/unix:0 . `openssl rand -hex 32`
  • yum versionlock - allows to lock an rpm
  • install faster random for dns etc.
yum install haveged;
systemctl enable haveged;
systemctl start haveged

sudo visudo -f /mnt/etc/sudoers

netstat -tulpn

xargs yum -y install < file
  • Create Default Home Directory
mkhomedir_helper username

use tmpfiles.d and have your package drop a file /usr/lib/tmpfiles.d/mydaemon.conf :

#Type Path            Mode UID      GID    Age Argument
d     /run/mydaemon   0755 myuser myuser   -   -

rpm -Uvh --nodeps $(repoquery --location <module>)

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

Oracle

SC Backup

Matricom gBox Q

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

AWS

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

pmset -g assertions

These are the steps

  1. replacing the drivers > UEFI > AptioMemoryFix.efi with OpenRuntime.efi
  2. Also, add OcQuirk.efi (More Info: https://github.com/ReddestDream/OcQuirks)
  3. select: config.plist/Quirks > DisableIoMapper
<insert>googlesearchwiki</insert> <insert>paypal</insert> <insert>analytics</insert>
Retrieved from "https://wiki.amar.com/index.php?title=Notepad:Notepad&oldid=556"