You can use lost password link in login page to reset password. If you don’t have a valid email set or mail server not working, you can reset the password using SSH. NextCloud users are stored in table oc_users. If you don’t know the user name, you can use following SQL command to see all […]
maildev is a fake SMTP server + interface to read the mail. It is useful for web developers during development stage where they don’t want email sents to read email address. To run maildev using docker, run
|
1 |
docker run -p 1080:80 -p 25:25 maildev/maildev |
Now you will be able to access web interface to read emails on port 1080
|
1 |
http://your-server-ip:1080 |
Fake […]
oneinstack is a free hosting management software available at https://oneinstack.com/ Documentation available at https://oneinstack.com/docs/lampstack-image-guide-en/ To find MySQL root password, run
|
1 2 |
cd /root/oneinstack grep dbrootpwd options.conf |
Nginx configuration files
|
1 |
/usr/local/nginx/conf/vhost |
Restart Nginx
|
1 |
systemctl restart nginx |
See Hosting Control Panels […]
Customer Relationship Management (CRM) allow you to manage customers. HubSpot Fre plan allow unlimited users, unlimited contacts, shared inbox and ticket system. Look like a good system to use as shared inbox/helpdesk. They have google chrome extension, that integrate with gmail/google workspace so all emails get tracked in CRM with read notifications. https://hubspot.com/ Agile CRM […]
When starting RuneScape client on Ubuntu 20.04, i get folloiwng error
|
1 2 |
Gtk-Message: 14:22:22.826: Failed to load module "canberra-gtk-module" /home/boby/Jagex/launcher/rs2client: error while loading shared libraries: libOpenGL.so.0: cannot open shared object file: No such file or directory |
To fix this, run
|
1 |
sudo apt install libopengl0 -y |
[…]
To connect to PostgreSQL database server using psql command line, run
|
1 2 |
su - postgres psql |
If you have a PostgreSQL user and password, you can use
|
1 |
psql -h SERVER_IP_HERE -p 5432 -U USER_NAME_HERE -W |
Example
|
1 |
psql -h students.arrhwfpckmeo.ap-southeast-2.rds.amazonaws.com -p 5432 -U aite_students -W |
-W option is to force asking password. See PostgreSQL […]
Moodle 3.2 PostgreSQL 12 Error reading from database […]
Moodle 3.2 site started showing error “Error reading from database”. I checked config.php, the database credentials are correct, i was able to login to Amazon AWS RDS PostgreSQL database with the credentaials and able to see the database tables with command \dt.
|
1 |
psql -h mydb.hwfckmarrpeo.ap-southeast-2.rds.amazonaws.com -p 5432 -U moodle_user -W |
I enabled debug in DB with following SQL commands
|
1 2 3 4 |
select * from mdl_config WHERE name = 'debug'; select * from mdl_config WHERE name = 'debugdisplay'; UPDATE mdl_config SET VALUE = 2047 WHERE name = 'debug'; UPDATE mdl_config SET VALUE = 1 WHERE name = 'debugdisplay'; |
But for […]
To benchmark server with GeekBench, you can run
|
1 2 |
wget https://raw.githubusercontent.com/serverok/server-setup/master/benchmark/geekbench-5.sh bash ./geekbench-5.sh |
You can create an account on https://browser.geekbench.com and keep all your benchmaks in one place. Here is my Geekbanch benchmarks https://browser.geekbench.com/user/55314 If you get error installing, you may need to install depency with
|
1 |
yum install libgcc.i386 libstdc++.i386 libgcc.i686 libstdc++.i686 -y |
See Benchmark […]
Nginx Hotlink Protection […]