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
Sun ILOM – Enable HTTP or HTTPS Web Access Using the CLI Rumi, November 13, 2020 ILOM supports both HTTP or HTTPS connections. ILOM enables you to automatically redirect HTTP access to HTTPS. ILOM also enables you to set the HTTP and HTTPS ports. 1. Log in to the ILOM CLI as a an Administrator. 2. At the command prompt, type: -> set /SP/services/http The properties… Continue Reading
Remove Proxmox Subscription Notice Rumi, November 1, 2020 Copy and paste following command to the terminal (6.1 and up) sed -i.backup “s/data.status !== ‘Active’/false/g” /usr/share/javascript/proxmox-widget-toolkit/proxmoxlib.js && systemctl restart pveproxy.service (6.2-11 and up) sed -i.backup -z “s/res === null || res === undefined || \!res || res\n\t\t\t.false/false/g” /usr/share/javascript/proxmox-widget-toolkit/proxmoxlib.js && systemctl restart pveproxy.service (6.2-12 and up) Continue Reading