Generate Large Test Files in Windows Rumi, January 16, 2021 Open an administrative level command prompt. Run the following command: fsutil file createnew <file> <size in bytes> For example, this command will create a 1GB file called 1gb.test on my desktop: fsutil file createnew c:\users\steve\desktop\1gb.test 1073741824 The key is to input the size of the file in bytes so here… Continue Reading
Delete/Purging mysql-bin (binlog) files safely Rumi, January 7, 2021 The file mysql-bin.index keeps a list of all binary logs mysqld has generated and auto-rotated. The mechanisms for cleaning out the binlogs in conjunction with mysql-bin.index are: PURGE BINARY LOGS TO ‘binlogname’; PURGE BINARY LOGS BEFORE ‘datetimestamp’; These will clear all binary logs before the binlog or timestamp you just… Continue Reading
MySQL: Show Users, Privileges and Passwords Rumi, December 29, 2020 Show all MySQL users: mysql> SELECT user FROM mysql.user; List only unique user names: mysql> SELECT DISTINCT user FROM mysql.user; Show MySQL users and hosts they are allowed to connect from: mysql> SELECT user,host FROM mysql.user; Show MySQL users, their passwords and hosts: mysql> SELECT user,host,password FROM mysql.user; in MySQL… Continue Reading
Wget, Apt and Git behind proxy Rumi, December 22, 2020 For Wget Add/Comment out below line(s) in file ~/.wgetrc or /etc/wgetrc: http_proxy = http://[Proxy_Server]:[port] https_proxy = http://[Proxy_Server]:[port] ftp_proxy = http://[Proxy_Server]:[port] For Apt Create a new configuration file named proxy.conf.sudo touch /etc/apt/apt.conf.d/proxy.conf Open the proxy.conf file in a text editor.sudo vi /etc/apt/apt.conf.d/proxy.conf Paste it as following: Acquire { HTTP::proxy “http://127.0.0.1:8080”; HTTPS::proxy… Continue Reading
How to import a certificate into WorldClient Rumi, December 21, 2020 WorldClient’s web server currently does not support generating certificate requests. If you have IIS you can use its certificate wizard to create the request and import the response. WorldClient will then be able to use it. You do not need to continue to use IIS at that point, you can disable… Continue Reading
How to fix CentOS 5 or 6 error: YumRepo Error: All mirror URLs are not using ftp, http[s] or file Rumi, December 6, 2020July 9, 2021 The error looks like- And here goes the resolution (please carefully update/use the exact CentOS version you are using, in my case it was CentOS 6.9) 1. Go to /etc/yum.repos.d/ directory: # cd /etc/yum.repos.d/ 2. Make copy of original file: # cp CentOS-Base.repo CentOS-Base.repo.old 3. Open and edit file with… Continue Reading
Force Stop Proxmox LXC Rumi, November 21, 2020 First try to unlock the pct (assuming your troubled container is 101): pct unlock 101 if it works just stop and start again the vm. if it does’nt work (my case) try to stop with this lxc-stop –name 101 if it’s does’nt work (my case) you can force stop with… Continue Reading
Install OnlyOffice Document Server on Ubuntu 16 Rumi, November 21, 2020 Step 1: Install ONLYOFFICE Document Server Please note that OnlyOffice document server requires at least 2GB of RAM. An additional 2GB of swap space is recommended. OnlyOffice document server depends on PostgreSQL, Node.js, Redis Server, RabbitMQ server and Nginx. The following steps are tested on a Ubuntu 16.04 server but should… Continue Reading
Installing wkhtmltopdf on Debian 7.8 Rumi, November 17, 2020July 17, 2021 Installing wkhtmltopdf on Debian 7.8 to dynamically create PDF documents from HTML. apt-get update aptitude install xfonts-base xfonts-75dpi fontconfig mkdir ~/src/wkhtmltopdf -p cd ~/src/wkhtmltopdf wget https://github.com/wkhtmltopdf/wkhtmltopdf/releases/download/0.12.2.1/wkhtmltox-0.12.2.1_linux-wheezy-amd64.deb dpkg -i wkhtmltox-0.12.2.1_linux-wheezy-amd64.deb Src: https://fedir.github.io/web/blog/2015/09/01/install-wkhtmltopdf-on-debian-7.8 https://github.com/wkhtmltopdf/wkhtmltopdf/releases/0.12.2.1/ https://github.com/wkhtmltopdf/packaging/releases/0.12.6-1 https://stackoverflow.com/questions/38262173/how-to-correctly-install-wkhtmltopdf-on-debian-64-bit Continue Reading
Disabling graphical (GUI) login in Debian wheezy/7 Rumi, November 17, 2020November 17, 2020 If you’d like to disable webgui mode of Debian wheey, run the commands in the terminal as root- update-rc.d -f gdm remove update-rc.d -f gdm3 remove update-rc.d -f wdm remove Continue Reading