Skip to content

Instantly share code, notes, and snippets.

View xakrume's full-sized avatar
➕
emerge -auDN @world

Ruslan Kh. xakrume

➕
emerge -auDN @world
7 followers · 17 following
View GitHub Profile
@xakrume
xakrume / show trigers for database (mysql)
Last active December 22, 2015 19:58
mysql> use nersh;
mysql> SHOW TRIGGERS\G
*************************** 1. row ***************************
Trigger: update_order_issue
Event: UPDATE
Table: order_issue
Statement: INSERT INTO `templog` (act, tbl, pkey, comment) VALUES ('update', 'order_issue', NEW.id, CONCAT('set user_id = ', NEW.user_id))
Timing: AFTER
Created: NULL
@xakrume
xakrume / commands to delete the triggers
Last active December 22, 2015 19:59
mysql> DROP TRIGGER IF EXISTS update_order_issue;
Query OK, 0 rows affected (0.06 sec)
mysql> DROP TRIGGER IF EXISTS update_order_issue_archive;
Query OK, 0 rows affected (0.08 sec)
mysql> DROP TRIGGER IF EXISTS update_user_addressbook;
Query OK, 0 rows affected (0.05 sec)
mysql> DROP TRIGGER IF EXISTS delete_user_addressbook;
@xakrume
xakrume / bind installation
Created September 11, 2013 13:02
yum install -y bind bind-utils bind-libs portreserve
@xakrume
xakrume / file named.conf
Created September 11, 2013 13:08
listen-on { 127.0.0.1; 10.0.0.111; };
здесь 10.0.0.111 - ip нашего сервера с сервисом bind
@xakrume
xakrume / allow queries from subnet
Created September 11, 2013 13:11
allow-query { 127.0.0.1; 10.0.0.0/24; };
@xakrume
xakrume / gist:6523373
Created September 11, 2013 13:12
chkconfig named on
service named restart
@xakrume
xakrume / =xakru=dig google.com
Last active December 22, 2015 19:59
$ dig google.com
; <<>> DiG 9.8.2rc1-RedHat-9.8.2-0.17.rc1.el6_4.4 <<>> google.com
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 1012
;; flags: qr rd ra; QUERY: 1, ANSWER: 16, AUTHORITY: 4, ADDITIONAL: 4
;; QUESTION SECTION:
;google.com. IN A
@xakrume
xakrume / =xakru=ip sort
Last active December 22, 2015 19:59
# route | sort -n -t . -k 1,1 -k 2,2 -k 3,3 -k 4,4
Destination Gateway Genmask Flags Metric Ref Use Iface
Kernel IP routing table
172.16.16.0 172.16.16.2 255.255.255.252 UG 0 0 0 tun2
172.16.16.2 * 255.255.255.255 UH 0 0 0 tun2
172.16.24.0 172.16.24.2 255.255.248.0 UG 0 0 0 tun3
172.16.24.0 172.16.24.2 255.255.255.252 UG 0 0 0 tun3
172.16.24.2 * 255.255.255.255 UH 0 0 0 tun3
@xakrume
xakrume / =xakru=mysql error
Last active December 22, 2015 21:29
130802 15:10:50 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','I
GNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','
MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZER
O','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE'
,'NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MY
SQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','ST
@xakrume
xakrume / =xakru=mysql commands
Last active December 22, 2015 21:29
service mysql stop
service mysql start --skip-grant-tables
mysql_upgrade