Category Archives: Debian

Latest Laravel php artisan migrate command error : Illuminate\Database\QueryException : SQLSTATE[HY000] [2002] Connection refused

When I run php artisan migrate –seed command , I am encountering the following error : Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection timed out (SQL: select * from information_schema.tables where table_schema = myDB and table_name = migrations and table_type = ‘BASE TABLE’) at vendor/laravel/framework/src/Illuminate/Database/Connection.php:671667| // If an exception occurs when attempting to run a query, we’ll format… Read More »

How to backup and Restore ISPConfig 3

I recently backup and restored an ISPConfig 3 server root@za-02-802:#mkdir -p /backups/os/ispconfigbkuproot@za-02-802:#cd /backups/os/ispconfigbkup Back up all of the databases on a server: root@za-02-802:/backups/os/ispconfigbkup# mysqldump -u root -p –all-databases > all-database.sql root@za-02-802:/backups/os/ispconfigbkup# tar -pczf completeserverbackup.tar.gz /backups/os/all-database.sql /home /var/vmail /var/log /var/www /var/lib /etc /opt/letsencrypt /usr/local/ispconfig Restore to a New Server or Reinstallation root@za-02-802:#mkdir -p /backups/os/ispconfigbkup root@za-02-802:~# cd… Read More »

Installing PowerDNS (With MySQL Backend) on Debian

PowerDNS is a DNS server, written in C++ and licensed under the GPL. It runs on most Unix derivatives. PowerDNS features a large number of different backends ranging from simple BIND style zonefiles to relational databases and load balancing/failover algorithms. A DNS recursor is provided as a separate program. Installation of the PowerDNS Authoritative server… Read More »