Often the server admin has little control over the applications which uses MySQL and it is hard to find the bottlenecks. This blog post can’t bring the peace in the …
Author: ServerAdmin
FreeRadius install howto (3)
In this post I will say something about FreeRadius config files, database connection, basic instruction how to insert user in database, etc. Before you step inside this post, I recommend …
FreeRadius install howto (2)
Last post about FreeRadius (available on this LINK) introduced FreeRadius and basic installation steps (install from RPM and directly from source). My advice is to install from source (frequent updates, …
kipmi0 problem
Few days ago one client called and asked about high CPU load on his Fedora server… It was very easy to detect that CPU is consumed by kipmi0 process. Unfortunately …
Neighbour table overflow – sysctl.conf tunning
If you have a big network with the hundreds of hosts you can expect “Neighbour table overflow” error which occurs in large networks when there are two many ARP requests …
Problem with apache – Address already in use… Unable to open logs
This morning I had a problem with apache. The httpd was stopped and the #service httpd restart didn’t work. Starting httpd: (98)Address already in use: make_sock: could not bind to …
FreeRadius install howto (1)
FreeRADIUS is the most widely deployed RADIUS server in the world. It is the basis for multiple commercial offerings. It supplies the AAA needs of many Fortune-500 companies and Tier …
Detect mobile browser (smartphone)
Detecting mobile browsers is very easy when you know the right regular expression. Here are two examples (for PHP and JSP) PHP <?php $useragent = $_SERVER[’HTTP_USER_AGENT’]; if (preg_match(’/android|avantgo|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|midp|mmp|opera m(ob|in)i|palm( …
MySQL – Update one table from another
If you need to update one table with information from another table, you can use next query. UPDATE sourceTable s, destTable d SET d.something = s.something WHERE d.fieldId = s.idUPDATE …
Detect visitor IP address with PHP
Two post in 2 days… 🙂 Here is a small PHP function to detect remote IP address (visitor IP address). This should work even if the client/visitor is behind a …