Serveradminblog - serveradminblog.com - ServerAdminBlog
General Information:
Latest News:
Number of bugs per line of code 26 Jul 2013 | 04:36 am
I would like to annouce a 2013. winner in “Bugs per line of code 2013.” contest. Pleeeease welcome – MySQL Workbench
CentOS 5 Call to undefined function sqlite_escape_string() 19 Jul 2013 | 11:45 am
If you’re using PHP 5.2.x on RHEL/CentoOS and you received error don’t worry. The reason for this is the missing sqlite extension which is not included in RHEL/Fedora/CentOS php packages by default. ...
pgModeler – PostgreSQL Database Modeler 23 Jun 2013 | 02:04 am
pgModeler is an open source tool for modeling PostgreSQL databases which is very similar to MySQL Workbench. The models created by the user can be exported to SQL code and applied directly into databa...
PostgreSQL books which you should consider 22 May 2013 | 02:33 am
Since the Oracle bought Sun (including MySQL), I wanted to improve my knowledge about other databases and to check the alternatives (in case “something” happens to MySQL). Luckily, MySQL is still here...
CentOS server – nginx howto 13 May 2013 | 04:45 pm
Nginx is a free, open-source, high-performance HTTP server and reverse proxy, as well as an IMAP/POP3 proxy server. Nginx now hosts nearly 12.18% (22.2M) of active sites across all domains. Nginx is k...
Why PostgreSQL is not so popular? (howto part 2) 9 May 2013 | 03:54 am
So… After the first part (Link) where we talk about the installation, the next step would be to create root user and to change postgres and root password. [root@XTdata init.d]# su postgres bash-3.2$ c...
Logrotate settings 29 Apr 2013 | 04:08 pm
As you probably know, the default logrotate period on RH based distros is 7 days. From my point of view, this number is to big for production servers (files can became extremely large so grep through ...
Extra Packages for Enterprise Linux – EPEL HowTo 18 Apr 2013 | 03:46 pm
EPEL (Extra Packages for Enterprise Linux) is a volunteer-based community effort from the Fedora project to create a repository of high-quality add-on packages that complement the Fedora-based Red Hat...
How to disable foreign key checks – MySQL 20 Feb 2013 | 02:29 am
From time to time you’ll need to delete something from your database and when you try to do it, the MySQL will complain on foreign keys (beside the fact that other table is empty) This can be solved w...
Find and delete files 20 Feb 2013 | 02:21 am
Few months ago, I had a problem after mail server migration. The old mail server decided to die and I had to replace the complete server. I read my logs carefully (on daily basis) and I noticed that h...
