Webleit.info

Selected from Linux	Selected from PHP
- Ubuntu 17.10 Install google's mod pagespeed for apache	- PHP-Ubuntu-Youtube-dl simple script for converting and downloading youtube video or mp3
- Ubuntu SSH tunnel via proxy	- PHP while loop with every row with a different color
- Install GoAccess Apache Log Analyzer Tool on Ubuntu 17.10	- PHP use while loop in function
- SSHFS and map folder with a proxy	- PHP List Files And Folders As links
- How to connect to SSH server with a proxy	- PHP Extract Text From String

➥ How to show the last queries executed on MySQL?

Added by sonik on 01-07-2018 and keywords: log, mysql, querys, queries [ Print Article ]

You can enable a general query log for that sort of diagnostic. Generally you don't log all SELECT queries on a production server though, it's a performance killer.
Edit your MySQL config, e.g. /etc/mysql/my.cnf - look for, or add, a line like this:

[mysqld]
log = /var/log/mysql/mysql.log

Restart mysql to pick up that change, now you can:

tail -f /var/log/mysql/mysql.log

Hey presto, you can watch the queries as they come in. [ read more... ]

➥ Make Browsers Cache Static Files With mod_expires On Apache2 Ubuntu 18.04

Added by sonik on 27-06-2018 and keywords: apache2, mod_cache, speed, website, tool [ Print Article ]

[warning]

Backup your 000-Default apache2 file before running the tutorial.

If you have tested your website for speed with googles website test tool then you have seen the error: Leverage browser caching not enabled. To fix this you need to enable and configure mod_expires on Apache2. This will make your website faster and better and meet the requirements of google website page speed.

This module controls the setting of the Expires HTTP header and the max-age directive of the Cache-Control HTTP header in server responses. The expiration date can set to be relative to either the time the source file was last modified, or to the time of the client access.
These HTTP headers are an instruction to the client about the document's validity and persistence. If cached, the document may be fetched from the cache rather than from the source until this time has passed. After that, the cache copy is considered "expired" and invalid, and a new copy must be obtained from the source.

[ read more... ]

➥ Apache CouchDB NOSQL database solution

Added by sonik on 25-06-2018 and keywords: no,sql,nosql,apache,couchdb,database, [ Print Article ]

[warning]

Materials copied from Wikipedia

CouchDB is a free and an open source NOSQL database solution implemented in the concurrency-oriented language Erlang. It has a document-oriented NoSQL database architecture. It uses JSON to store data, JavaScript as its query language using MapReduce, and HTTP for an API. CouchDB implements a form of multi-version concurrency control, so it does not lock the database file during writes. You can use CouchDB in mobile devices for replication and synchronization.

A No SQL (originally referring to "non SQL" or "non relational") database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases. Such databases have existed since the late 1960s, but did not obtain the "No SQL" moniker until a surge of popularity in the early twenty-first century, triggered by the needs of Web 2.0 companies such as Facebook, Google, and Amazon. No SQL databases are increasingly used in big data and real-time web applications. No SQL systems are also sometimes called "Not only SQL" to emphasize that they may support SQL-like query languages

[ read more... ]

➥ SELECT browser as COUNT

Added by sonik on 26-06-2018 and keywords: [ Print Article ]

SELECT browser, COUNT(browser) AS freq FROM [ read more... ]

➥ Install GoAccess Apache Log Analyzer Tool on Ubuntu 17.10

Added by sonik on 27-06-2018 and keywords: [ Print Article ]

GoAccess is an open source real-time web log analyzer and interactive viewer that runs in a terminal in *nix systems or through your browser. It provides fast and valuable HTTP statistics for system administrators that require a visual server report on the fly.
GoAccess was designed to be a fast, terminal-based log analyzer. Its core idea is to quickly analyze and view web server statistics in real time without needing to use your browser (great if you want to do a quick analysis of your access log via SSH, or if you simply love working in the terminal).
While the terminal output is the default output, it has the capability to generate a complete, self-contained real-time HTML report (great for analytics, monitoring and data visualization), as well as a JSON, and CSV report. [ read more... ]

➥ Hddtemp crontab every hour in to file

Added by sonik on 27-06-2018 and keywords: hdd, temp, hddtemp, crontab [ Print Article ]

In this article we are going to create a txt file and in it we are going to store the hdd temperature for every hour. Install [ read more... ]