|
||||||
|
This is a short table of useful and common MySQL & PostgreSQL commands put up against each other. MySQL PostgreSQL Command line client mysql psql Connect to database use mysql; \connect postgresql; List databases show databases; \l List tables show tables; \dt Describe table describe table; \d table; Show server version select version(); select version(); […] Discovered during a recent project. Bind / Named was constantly spamming the logs about it being unable to reach root servers. The logs revealed that we were talking IPv6 addresses. Which was assumed to be disabled. The less cool part was that in “/etc/named.conf” the following was commented out. // listen-on-v6 port 53 { ::1; […] Let me introduce you to the “extremely simple MTA to get mail off the system to a mailhub”. Particularly useful when you don’t want systems to have a full blown MTA installed. Such as Postfix, Exim or Sendmail. I find ssmtp extremely helpful on standalone servers that use Logwatch. Getting this up and running requires […] Installing the PostgreSQL server on RHEL, CentOS, Scientific Linux or Fedora installs the PostgreSQL databases and configuration files in “/var/lib/pgsql/data”. This may or may not be desirable. Let’s assume for a moment you have a separately crafted partition for PostgreSQL to use, let’s say a RAID10 volume. You’d want to change this. Change the defaults […] The following is required to reset the root/postgres user password for PostgreSQL. The distribution used in my example is CentOS 5.5 and PostgreSQL 8.4. Note: By default there’s no password for the postgres user. In step 2 and 5 you will most likely not be using “ident” but rather “password” or “md5?. 1. Shut down […] To get at this information we will use a utility called “dmidecode”. dmidecode is a tool for dumping a computer’s DMI (some say SMBIOS) table contents in a human-readable format. On CentOS/RHEL/Fedora you may run the following to install it. # yum install dmidecode On Arch Linux you may run # pacman -S dmidecode The […] This is a short article that explains how you change the default MySQL data directory and adjust SELinux to account for the changes. The article assumes that you’re running either RHEL, CentOS, Scientific Linux or Fedora with SELinux enabled. This works with the most recent EL (6.2) version. We’ll be doing this in the following […] Security through obscurity is not something one would generally recommend. But to thwart the effort of automated scanners changing the default OpenSSH port will yield you less pain in every day life. This will not fend off directed attacks or nullify vulnerabilities or bad security design. Should you see an error message such as shd[14221]: […] An access control list (ACL), with respect to a computer file system, is a list of permissions attached to an object. ACL allows you to grant or deny permissions for any user or group on a filesystem resource. Enabling ACL To enable ACL, edit your /etc/fstab file as such: /dev/VolGroup00/LogVol00 / ext3 defaults,acl 1 1 […] There’s several ways of accomplishing this. I will list all the methods beneath, just pick the one that fits the situation/you. Filesystem tunable Grub boot parameter Placing command files on your root device Active reboot without FSCK Filesystem tunable Use the tune2fs command to tell your filesystem to have a max count of mounts before […] |
||||||
|
Copyright © 2025 - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
Recent Comments