Free and Open Source blogger with an attitude
Here’s a quick way to export SQLite3 database to *.sql text file.
sqlite3 this.db .dump > this-db.sql
The command is useful for exporting SQLite database to standard ANSI .sql which can be imported into other database management system such as Oracle, MariaDB/MySQL, etc
The dreaded 404 HTTP code means page not found. However multiple 403 and 404 on weblogs also can also mean there are attempts to crack the website.
The awk script down here can be useful tool to analyze weblogs and identify multiple attempts at cracking the web application.
awk '($9 ~ /404/)' access.log | awk '{print $7}' | sort | uniq -c | sort -n
The script can also be tweaked for other HTTP status code too.
Cronjob or CRON is an important tool to perform automated / schedule task for web application.
Some shared hosting company may limit (or completely disable) the cron service functionality leading to some web application unable to perform periodic / automated task.
Luckily there’s website such as Cron-Job.org which offers free cron-job to those who aren’t able to obtain one.
The best thing about Cron-Job.org service, is they allow minute-by-minute cronjob execution for free!
Bonus: The folks at Cron-Job also releases the source code behind the service at GitHub!
The previously featured checkip.mypapit.net has been upgrade to JSON. You just need to add /json parameter to get ip address and country code in json format.
http://checkip.mypapit.net/json/
Check http://checkip.mypapit.net/json/ now
As always you can also access the website using ‘cURL’, ‘wget’ or any programming language which supports .json.
000Webhost.com is offering free PHP and MySQL Hosting to those in need those who are looking to simply to test out their PHP projects to the public (hint: Great for students !)
Advantages:
However the free hosting does come with 1 hour downtime per day as an incentive for the users to upgrade. Nevertheless it is still useful for students and hobbyist to test their website on the internet for free!
Nmap (or Network Mapper) is probably the most popular network mapper around. However if you are running a very stable long-term support server, there are chances that your nmap database installation isn’t keep up to that.
Updating Nmap database
Nmap detection database consists of these files:
What you need to do is to download these files from Nmap Github project page and copy it to /usr/share/nmap/ folder.
Alternatively, you can use this script ‘nmap-update.sh’ which I’ve created based on this gist.
Copy all the files to /usr/share/nmap/ once all of them have been downloaded.
(y) (y)