PostgreSQL is a powerful, open source relational database system.It offers an alternative to other database systems, such mySQL.
In this case, i want to stop postgresql, both services and system startup
# chkconfig --list
# chkconfig --levels 235 postgresql off
# service postgresql stop
To turn on system startup and start postgresql
# chkconfig --levels 235 postgresql on
# service postgresql start
Adriaan Pienaar is a blogger and web designer from South Africa. He has done series of mini interview. This Mini Interview series target bloggers, designers & online personalities of corporate blogging and Enterprise 2.0
Here is mini interviews which i think is very interesting (and i enjoy so much reading them):
Weblog Tools Collection announce the beta version of Wordpress Jobs, a primary location for employers looking for professional Wordpress help and for Wordpress professionals to find, apply for and obtain jobs in WordPress.
Job categories : Design Positions, Programmer Positions, Blogger Positions, and General Positions. While in beta, the service will be free.
Xampp for linux is an easy to install Apache distribution containing MySQL, PHP and Perl. Xampp contain a package of Apache 2.2.4, MySQL 5.0.45, PHP 5.2.3 & 4.4.7 & PEAR + SQLite 2.8.17/3.3.17 + multibyte (mbstring) support, Perl 5.8.7, ProFTPD 1.3.0a, phpMyAdmin 2.10.3, OpenSSL 0.9.8e, GD 2.0.1, Freetype2 2.1.7, libjpeg 6b, libpng 1.2.12, gdbm 1.8.0, zlib 1.2.3, expat 1.2, Sablotron 1.0, libxml 2.4.26, Ming 0.3, Webalizer 2.01, pdf class 009e, ncurses 5.8, mod_perl 2.0.2, FreeTDS 0.63, gettext 0.11.5, IMAP C-Client 2004e, OpenLDAP (client) 2.3.11, mcrypt 2.5.7, mhash 0.8.18, eAccelerator 0.9.5.1, cURL 7.13.1, libxslt 1.1.8, phpSQLiteAdmin 0.2, libapreq 2.07, FPDF 1.53, XAMPP Control Panel 0.6.
But Xampp is not meant for production use but only for developers in a development environment, and have a list of missing security :
1. The MySQL administrator (root) has no password.
2. The MySQL daemon is accessible via network.
3. ProFTPD uses the password “lampp” for user “nobody”.
4. PhpMyAdmin is accessible via network.
5. Examples are accessible via network.
6. MySQL and Apache running under the same user (nobody).
Xampp is not recommended for an online (dedicated or shared) server.
Remove Xampp (if you already have a Xampp)
Stop then remove
# /opt/lampp/lampp stop
# rm -rf /opt/lampp
Plesk have DNS Zone template to setup DNS Zone when you create a domain.
DNS Zone template located in System > Server Administration > Services > DNS.
. NS ns.. . A . MX (10) mail.. / 24 PTR . ftp.. CNAME . mail.. A ns.. A webmail.. A
DNS Zone Template only have one ns (nameserver) by default. Changes template for 2 nameserver, for example
. NS ns1.. . NS ns2.. . A . MX (10) mail.. / 24 PTR . ftp.. CNAME . mail.. A ns1.. A ns2.. A webmail.. A
DNS Zone can be seen in General > Domains > Domain Name > DNS. If you want to change values, just do it in a domain DNS Zone, not in DNS Zone template.
Chrooted DNS doesn’t work with Plesk. That’s why chrooted DNS must remove from CentOS after Plesk installation. Plesk have its own DNS. It’s better not to install chrooted DNS in CentOS, if you are using Plesk
Remove Chrooted DNS
# rpm -e bind-chroot
Chrooted DNS make DNS service in Plesk looks failed, but it’s not (Server > Service Management > DNS Server (Bind)).
Setup Plesk DNS manually.
DNS files is in /var/named, /var/named/run-root/etc, /var/named/run-root/var/named, /var/named/run-root/var directory.
In this case, /var/named and /var/named/run-root/var/named directory have same content (below), except file named.pid in /var/named :
localdomain.zone
localhost.zone
named.broadcast
named.ca
named.ip6.local
named.local
named.zero
DNS configuration (named.conf) in /var/named/run-root/etc must same�with rndc-key , for example :
# Start of rndc.conf
key "rndc-key" {
algorithm hmac-md5;
secret "CeMgS23y0oWE20nyv0x40Q==";
};options {
default-key "rndc-key";
default-server 127.0.0.1;
# default-port 953;
};
# End of rndc.conf# Use with the following in named.conf, adjusting the allow list as needed:
# key "rndc-key" {
# algorithm hmac-md5;
# secret "CeMgS23y0oWE20nyv0x40Q==";
# };
#
# controls {
# inet 127.0.0.1 port 953
# allow { 127.0.0.1; } keys { "rndc-key"; };
# };
Generate rndc-key
# rndc-confgen
Generate rndc-keyStop/Start/Restart BIND
# /etc/init.d/named stop
# /etc/init.d/named start
# /etc/init.d/named restart
Meanwhile, Plesk DNS Zone is in /var/named/run-root/var. Setup Plesk DNS Zone using Plesk Administration Site
Related Topics
Setup Plesk DNS Zone