I suppose you have a couple of clients who believes in Teamviewer only. Teamviewer on Linux works fine but after you install it, you’ll be supprised that the proces is …
Author: ServerAdmin
Number of bugs per line of code
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()
If you’re using PHP 5.2.x on RHEL/CentoOS and you received error PHP Fatal error: Call to undefined function sqlite_escape_string()PHP Fatal error: Call to undefined function sqlite_escape_string() don’t worry. The reason …
pgModeler – PostgreSQL Database Modeler
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 …
PostgreSQL books which you should consider
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 …
CentOS server – nginx howto
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. …
Why PostgreSQL is not so popular? (howto part 2)
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]# …
Logrotate settings
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 …
Extra Packages for Enterprise Linux – EPEL HowTo
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 Enterprise …
How to disable foreign key checks – MySQL
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 …