Notepad:Notepad: Difference between revisions

From Amar
Jump to navigationJump to search
Line 104: Line 104:
  mkhomedir_helper username
  mkhomedir_helper username
* [[Notepad:crontab | Schedule crontab with lock]]
* [[Notepad:crontab | Schedule crontab with lock]]
* [https://hackernoon.com/how-to-shutdown-your-servers-in-case-of-power-failure-ups-nut-co-34d22a08e92 Configure UPS shutdown frmo Linux with nut]


== MySQL ==
== MySQL ==

Revision as of 19:18, 4 February 2019

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

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

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

SSL Certificates

Version Control

Oracle

SC Backup

Matricom gBox Q

KVM

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



<insert>googlesearchwiki</insert> <insert>paypal</insert> <insert>analytics</insert>