Just my blog
Blog about everything, mostly about tech stuff I made. Here is the list of stuff I'm using at my blog. Feel free to ask me about implementations.
Soft I recommend
- Mobaxterm SSH RDP FTP...
- Thunderbird Email client
- Filezilla FTP client/server
- Nirsoft Win utils
- Sysinternals Win utils
- Pi-Hole AD block by DNS
- NUT UPS manager
- Rpi MON Raspberry monitoring
- Free CAD 3D modelling
- Free Commander Far-like filemanager
- Bitwarden Password manager
Py lib I recommend
- Django web framework
- celery multi-tasking
- celery-beat Celery + Django
- celery-results Celery + Django
- Pillow Python image lib
- wsgi mod Apache + Python
- requests best in WEB requests
- openpyxl make Excell docs
- p4python Perforce + Python
- paramiko SSH + Python
- pyvmomi ESXi Vcenter + Python
I'm using these libraries so you can ask me about them.
MySQL troubleshooting
Возможные проблемы:
-
отваливается сокет /var/lib/musql/mysql.sock
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Лечится при помощи проверки прав на папку в директории: Проверяем:
[root@web-server ~]# cd /var/lib/mysql [root@web-server mysql]# ls -l
Ставим: chown -R :mysql /var/lib/mysql -R - все вложенные, получат такие же права
drwx------. 2 mysql mysql 4096 Oct 31 07:32 mysql srwxrwxrwx. 1 mysql mysql 0 Nov 8 19:41 mysql.sock drwx------. 2 mysql mysql 4096 Nov 4 15:38 radio_tk_def
-
не стартует служба mysqld
[root@web-server mysql]# service mysqld start MySQL Daemon failed to start. Starting mysqld: [FAILED]
Проверим, все ли нормально с конфигами /etc/my.cnf Самая простая и рабочая конфига:
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1
# Disabling symbolic-links is recommended to prevent assorted security risks; # to do so, uncomment this line: # symbolic-links=0
[mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
[client] socket=/var/lib/mysql/mysql.sock
Конфигу поправили, папке, где лежит сокет дали разрешение для пользователя mysql:
[root@web-server mysql]# service mysqld restart Stopping mysqld: [ OK ] Starting mysqld: [ OK ]
tech
Tech posts, about installing or setting-up something.
raspberry
Everything related to raspberry
python
Using Python or coding in Python.
linux
Anything related to Linux user experience
octopus
Octopus is a framework for test execution, statistics collection and virtual machine deployment automation.
windows
WIndows OS and related issues and stuff.
REST
REST API for\from different services
Django
Django Web(Server) Framework
virtualization
Topics related to OS virtualization software
SQL DB
SQL type database and related issues
project man
Project management tools and thoughts, software and not.
web
Site hostings, web server, web browsing, web developing.
personal
Just personal thoughts, they aren't always readable or adequate
photo
My photos or photo related stuff.