Crmgo Blog

Linux

← Blog

Linux

3ptoxyActiveDirectoryCentOSDebianFTPIP v.6JiraKVMLibreOfficeLomixMYSQLMuninNginxOpenSUSEOpenWRTPostfixRedmineSQUIDSVNUbuntuUbuntu 12.04Ubuntu 13.04VPNZabbixapachebackupbindcactidhcpejabberdfsckgrepiptablesispmanagerpostgresqlrdesktopremastersysroutesambascreensedsnmptartcpdumptftp-serverthunderbirdtruecriptvideovimvsftpGeneral questionsMailWorking with foldersFontswith files

Posts: 189

OpenWRT on a USB Flash Drive

OpenWRT on a USB Flash Drive

· OpenWRT

Update the package list and install the necessary modules to support USB drives and the ext4 file system: Do not worry about the error message that occurs during the installation of the kmod-usb-storage package (Barrier Breaker 14.07). In fact, the module installs successfully.…

CentOS Disable IPv6

CentOS Disable IPv6

· CentOS

vim /etc/sysctl.conf net.ipv6.conf.enp5s1.disable_ipv6 = 1 enp5s1 - the name of the network interface or all sysctl -p

Jira Update

Jira Update

· Jira

Example of upgrading from 7.2 to 7.4.2. I make a backup of the configs: cd /opt/atlassian/jira/ cp -R conf/ ~/ Download the latest version: wget https://www.atlassian.com/software/jira/downloads/binary/atlassian-jira-core-7.4.2-x64.bin Install it: service jira stop chmod a+x atlassian-jira-core-7.4.2-x64.bin sh atlassian-jira-core-7.4.2-x64.bin mv server.xml server_orig.xml cp ~/conf/server.xml ./ service jira start If there is an error…

MySQL Cheat Sheet

MySQL Cheat Sheet

· MYSQL

Settings List of configuration parameters and their values User Management List of users List of privileges for user root@localhost Creating a new user Add selected privileges for all tables in the dbname database to user 'user'@'localhost' Add all privileges for all tables in the dbname database to user 'user'@'localhost' Deleting...

Zabbix, changing the encoding

Zabbix, changing the encoding

· Zabbix

Anyone who has installed a Zabbix server has encountered the encoding issue in the Web GUI interface, where all Russian text is displayed as question marks. The problem lies in the default character sets of the database tables, which we will modify to fix it. We need to convert the character set of the tables and...

htaccess Rewrite

htaccess Rewrite

· apache

Metacharacters Example: Used to define character groups or "labels" in a pattern. For example, labels for the beginning or end of a line. \ The "escaping" backslash. The character following it is treated as a regular character, not a special one. The \ character is placed before special characters if they are needed in their original form...

Auto-starting a script in CentOS 7 using systemd

Auto-starting a script in CentOS 7 using systemd

· CentOS

Systemd introduces the concept of systemd units. Units are represented by configuration files located in one of the following directories: /usr/lib/systemd/system/ – units from installed RPM packages; /run/systemd/system/ – units created at runtime. This directory takes precedence over the directory containing units installed from packages. /etc/systemd/system/ – units created…

Restoring file permissions after a failed chown, chmod

Restoring file permissions after a failed chown, chmod

· Linux

On the donor system: Collect the correct "owner:group" permissions using the following command: ```bash find /etc /usr /bin /boot /dev /home /media /mnt /opt /proc /sys -exec stat --format 'chown %U:%G ${MPOINT}%n' {} \; > /tmp/restoreperms_chown.sh ``` Collect the correct file permissions using: ```bash find /etc /usr /bin /boot /dev /home /media /mnt /opt /proc…

UrBackup: Making a Backup from Windows to CentOS7

UrBackup: Making a Backup from Windows to CentOS7

· backup

Installing the server component on CentOS: # rules for urbackup -A INPUT -m state --state NEW -m tcp -p tcp --dport 55414 -j ACCEPT -A INPUT -m state --state NEW -m tcp -p tcp --dport 35621 -j ACCEPT -A INPUT -m…

MySQL recovery after failures.

MySQL recovery after failures.

· MYSQL

If MySQL fails to start: vim /etc/my.conf [mysqld] innodb_force_recovery = 1 service mysql start Dump all data: mysqldump database | gzip > database.sql.gz Check integrity: mysqlcheck --auto-repair --all-databases -p Below are possible options for mysqlcheck. Which of them are supported…

CentOS: Preventing OOM from Killing Our Required Service (MySQL Example) When Memory Is Low

CentOS: Preventing OOM from Killing Our Required Service (MySQL Example) When Memory Is Low

· CentOS

For CentOS 6: vim /etc/init.d/mysqld Add to the start section: pgrep -f "mysql" | while read PID; do echo -17 > /proc/$PID/oom_adj; done Another method For CentOS 7: vim /etc/systemd/system/mysqld OOMScoreAdjust=-1000 Info: http://geckich.blogspot.com/2013/12/linux-out-of-memory-killer-oom.html https://habrahabr.ru/company/infobox/blog/241237/ https://habrahabr.ru/company/centosadmin/blog/255845/

Zabbix + UPS (monitoring of power outages)

Zabbix + UPS (monitoring of power outages)

· Zabbix

yum install usbutils apcupsd (the apcupsd-cgi package is not needed for the web interface) lsusb vim /etc/apcupsd/apcupsd.conf service apcupsd start chkconfig apcupsd on apcaccess status vim /etc/zabbix/zabbix_agentd.d/ups.conf On the server, create 3 items: ups.charge, ups.status, ups.volts. Set a trigger for ups.status: For the rest...

Zabbix + sensors (temperature monitoring)

Zabbix + sensors (temperature monitoring)

· Zabbix

yum install lm_sensors sensors-detect sensors sensors | grep 'Physical id' | cut -c18-19 vim /etc/zabbix/zabbix_agentd.d/sensors.conf UserParameter=sensor.temp1,sensors | grep 'Physical id' | cut -c18-19 service zabbix-agent restart On the Zabbix server, create a data item: Add a graph and a trigger with the value {KVM1:sensor.temp1.last()}>60 KVM1 - Hostname, replace with your own.

Zabbix-agent + monitoring of MySQL, Nginx, php-fpm on CentOS

Zabbix-agent + monitoring of MySQL, Nginx, php-fpm on CentOS

· Zabbix

chkconfig zabbix-agent on vim /etc/zabbix/zabbix_agentd.conf #Server=zabbix.domain.ua #ServerActive=zabbix.domain.ua #Hostname=MyServer #Include=/usr/local/etc/zabbix2/zabbix_agentd.d/ mkdir /etc/zabbix/zabbix_agentd.d/ service zabbix-agent start MYSQL mysql> GRANT USAGE ON *.* TO 'zabbix'@'%' IDENTIFIED BY 'mypass'; FLUSH PRIVILEGES; vim /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/var/lib/zabbix mysql -N |…