adminer setup script

Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consists of a single file ready to deploy to the target server. Adminer is available for MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch, and MongoDB. install script sudo mkdir /usr/share/adminer sudo wget "http://www.adminer.org/latest.php" -O /usr/share/adminer/latest.php sudo ln -s /usr/share/adminer/latest.php /usr/share/adminer/adminer.php echo "Alias /adminer.php /usr/share/adminer/adminer.php" | sudo tee /etc/apache2/conf-available/adminer.conf sudo a2enconf adminer.conf # restart apache/httpd

September 20, 2019 · 1 min · 73 words · Akhil Jalagam

git – using multiple remote URLs

When using Git for version control, many people use GitHub as a place to hold remote repositories and push their repositories there. I recently started using BitBucket also and wanted to be able to simultaneously update my GitHub and BitBucket repositories when changes were made. To begin, rename your current remote (most likely named origin) to a different name. I’d rename this to the name of the service you are using, such as Github or bitbucket....

September 19, 2019 · 1 min · 168 words · Akhil Jalagam

mysqld – Got packet bigger than ‘max_allowed_packet’ bytes when dumping table `memcache` at row

Add --max_allowed_packet=512M to your mysqldump command. Or add max_allowed_packet=512M to [mysqldump] the section of your my.cnf Note: it will not work if it is not under the [mysqldump] section…

September 17, 2019 · 1 min · 29 words · Akhil Jalagam

Cron job for Automatic Feed updates in Openvas

To get updated content from the feeds you need to run the following scripts (in this order) on a daily base crontab -e 0 1 * * * /usr/sbin/greenbone-nvt-sync &> /dev/null 0 2 * * * /usr/sbin/greenbone-scapdata-sync &> /dev/null 0 3 * * * /usr/sbin/greenbone-certdata-sync &> /dev/null If there is any issue during the sync the scripts should give you additional info.

September 6, 2019 · 1 min · 62 words · Akhil Jalagam

How to Redirect HTTP to HTTPS in apache

Install modules Enable modules Method 1 using rewrite module RewriteEngine On RewriteCond %{HTTPS} !=on RewriteRule ^/?(.*) https://%{SERVER_NAME}/$1 [R,L] </VirtualHost> Method 2 using redirect method Redirect permanent / https://www.yourdomain.com/ </VirtualHost>

September 4, 2019 · 1 min · 29 words · Akhil Jalagam