This article will walk through the process of installing Sun/Oracle Java 8 JDK/JRE 8u45 on RHEL/CentOS 7/6/5 and Fedora 22-18 systems using binary rpm files. Check the captured data with Wireshark for "EAP" protocol. "EAP" is stand for Extensible Authentication Protocol "EAP" only defines message formats. Ham Radio Software on Centos Linux - Configuring multitudes of Amateur / HAM Radio software for Centos6 / Centos5 Linux. Installing Postgre. SQL 9. 4 And php. Pg. Admin In Cent. OS 7/6. 5/6. 4. Introduction. Postgre. SQL is a powerful, open- source object- relational database system. It runs under all major operating systems, including Linux, UNIX (AIX, BSD, HP- UX, SGI IRIX, Mac OS, Solaris, Tru. Windows OS. Postgre. SQL 9. 4 has been released last week with major enhancements, fixes, and features. Read what is new in Postgre. SQL 9. 4 here. In this handy tutorial, let us see how to install Postgre. SQL 9. 4 on Cent.OS 7/6. 5/6. 4 server.Install Postgre. SQLGo to the Postgre.SQL repository download page, and add the Postgre.SQL 9. 4 repository depending upon your server architecture.For Cent. OS 6. x 3.Uvh http: //yum. postgresql. . For Cent. OS 6. x 6. Uvh http: //yum. postgresql. For Cent. OS 7 6. Uvh http: //yum. postgresql. Update the repository list using command: yum update. Now, Install postgresql with the following command: yum install postgresql. Initialize postgresql database using following command: On Cent. OS 6. x systems: service postgresql- 9. On Cent. OS 7 systems: /usr/pgsql- 9. Then, start postgresql service and make it to start automatically on every reboot. On Cent. OS 6. x systems: service postgresql- 9. On Cent. OS 7 systems: systemctl enable postgresql- 9. Adjust Iptables/Firewall. Next, adjust iptables to access postgresql from remote systems. On Cent. OS 6. x systems: vi /etc/sysconfig/iptables. Add the following line: -A INPUT - m state - -state NEW - m tcp - p tcp - -dport 5. ACCEPT. - A INPUT - m state - -state NEW - m tcp - p tcp - -dport 8. ACCEPTSave and exit the file. Restart iptables service. On Cent. OS 7 systems: firewall- cmd - -permanent - -add- port=5. Adjust SELinux. Run the following command to make Postgre. SQL work if SELinux enabled on your system. P httpd_can_network_connect_db 1. You may not login to Postegre. SQL if you didn’t run the above command. Access Postgre. SQL command prompt. The default database name and database user are “postgres”. Switch to postgres user to perform postgresql related operations: su - postgres. To login to postgresql, enter the command: psql. Sample Output: psql (9. Type "help" for help. To exit from posgresql prompt, type \q following by quit to return back to the Terminal. Set “postgres” user password. Login to postgresql prompt,su - postgres. Enter new password. Enter it again. postgres=# \q. To install Postgre. SQL Adminpack, enter the command in postgresql prompt: postgres=# CREATE EXTENSION adminpack. CREATE EXTENSIONCreate New User and Database. For example, let us create a new user called “senthil” with password “centos”, and database called “mydb”. Switch to postgres user: su - postgres. Create user senthil.$ createuser senthil.Create database: $ createdb mydb.Now, login to the psql prompt, and set password and Grant access to the database mydb for senthil: $ psqlpsql (9.Type "help" for help.Delete Users and Databases. Long Will Take Crack Wpa Handshake . To delete the database, switch to postgres user: su - postgres. Enter command: $ dropdb < database- name> To delete a user, enter the following command: $ dropuser < user- name> Configure Postgre. SQL- MD5 Authentication. MD5 authentication requires the client to supply an MD5- encrypted password for authentication. To do that, edit /var/lib/pgsql/9. Add or Modify the lines as shown below[..]. TYPE DATABASE USER ADDRESS METHOD. Unix domain socket connections only. IPv. 4 local connections. IPv. 6 local connections. Restart postgresql service to apply the changes: On Cent. OS 6. x systems: service postgresql- 9. On Cent. OS 7 systems: systemctl restart postgresql- 9. Configure Postgre. SQL- Configure TCP/IPBy default, TCP/IP connection is disabled, so that the users from another computers can’t access postgresql. To allow to connect users from another computers, Edit file /var/lib/pgsql/9. Find the lines: [..]. Uncomment both lines, and set the IP address of your postgresql server or set ‘*’ to listen from all clients as shown below: listen_addresses = '*'. Restart postgresql service to save changes: On Cent. OS 6. x systems: /etc/init. On Cent. OS 7 systems: systemctl restart postgresql- 9. Manage Postgre. SQL with php. Pg. Adminphp. Pg. Admin is a web- based administration utility written in PHP for managing Posgre. SQL. php. Pg. Admin is available only in Postgre. SQL RPM repository. If you didn’t add Postgre. SQL repository, you should add EPEL repository. Follow the below link to install EPEL repository on Cent. OS 6. x. For Cent. OS 7, refer the following link. Or, simply enter the following command: yum install epel- release. Update the repository using command: yum update. Now, Install php. Pg. Admin, enter the following command: yum install php. Pg. Admin httpd. Note: php. Pg. Admin is case sensitive. Use upper and lower cases properly as shown in the above command. By default, you can access phppgadmin using http: //localhost/php. Pg. Admin from your local system only. To access remote systems, do the following. Edit file /etc/httpd/conf. Pg. Admin. conf: vi /etc/httpd/conf. Pg. Admin. conf. Make the changes as shown below in the bold letters.[..]. Alias /php. Pg. Admin /usr/share/php. Pg. Admin. < Location /php. Pg. Admin>. < If. Module mod_authz_core. Apache 2. 4. Require all granted. Require host example. If. Module>. < If. Module ! mod_authz_core. Apache 2. 2. Order deny,allow. Allow from all. # Allow from . If. Module>. < /Location> Start or Restart Apache service: On Cent. OS 6. x systems: service httpd start. On Cent. OS 7 systems: systemctl enable httpd. Configure php. Pg. Admin. Edit file /etc/php. Pg. Admin/config. Most of these options are self- explanatory. Read them carefully to know why do you change these values. Pg. Admin/config. Find the following line: $conf['servers'][0]['host'] = ''; Change it as shown below: $conf['servers'][0]['host'] = 'localhost'; And find the line: $conf['extra_login_security'] = true; Change the value to false: $conf['extra_login_security'] = false; Find the line: $conf['owned_only'] = false; Set the value as true. Save and close the file. Restart postgresql service and Apache services. On Cent. OS 6. x systems: service postgresql- 9. On Cent. OS 7 systems: systemctl restart postgresql- 9. Now open your browser and navigate to http: //ip- address/php. Pg. Admin. You will see the following screen. Login with users that you’ve created earlier. I already have created a user called “senthil” with password “centos” before, so I log in with user “senthil”. You may get an error called: Login failed. This is because SELinux might restrict the users to log in to the Postgre. SQL. Just enter the following command to get rid of this error. P httpd_can_network_connect_db 1. Now, you’ll be able to log in to the Dashboard without any problems. This is how my php. Pg. Admin dashboard looked. Log in with postgres user: That’s it. Now you’ll able to create, delete and alter databases graphically using php. Pg. Admin easily. How to Install GUI (Gnome 3) Using CD/DVD on RHEL/Cent. OS 7. As a Linux administrator for more than 6 yrs, I spend most of my time working on terminals, but there are some situations where I need a GUI instead of terminal. By default, RHEL/Cent. OS 7 server installed as minimal without any Graphical Desktop support. So, to install GUI on the top of minimal installation, we have two options: The First method is, installing GUI (i. Gnome 3) using default base repository, it will download and install packages from Internet. The second method is, installing GUI using RHEL/Cent. OS 7 ISO image via local CD/DVD device, this will avoid downloading of packages from internet. The first method is time taking process, as it downloads packages from internet and install it on the system, if you have a fastest internet connection you can simply type the following command on the terminal to install GUI in no time.# yum groupinstall "GNOME Desktop" [On Cent. OS 7]. # yum groupinstall "Server with GUI" [On RHEL 7]. But, those who have a slower connection, they can follow CD/DVD method, here the packages are installed from your local CD/DVD device, and the installation is much quicker than the first method. Note: The installation instructions for GUI are same for both methods, but here our main goal is to avoid downloading of packages from internet and minimize time. Those who are following CD/DVD method, they must have full RHEL/Cent. OS 7 DVD ISO (download and burn image to CD/DVD) with them, because we use this image to create a local yum repository. So that, during GUI installation, the packages are taken from your CD/DVD. Note: For the demonstration purpose, I’ve used RHEL/Cent. OS 7 DVD ISO image to install Gnome 3, but the same instructions also works on RHEL 7 with minor changes in commands. Step 1: Creating Local Yum Repository. Before creating a local yum repository, insert your Cent. OS 7 DVD ISO image your CD/DVD drive and mount it using the following commands. First, create a empty ‘cdrom‘ directory under ‘/mnt/‘ location and mount the ‘cdrom‘ (/dev/cdrom is the default name of your device) under ‘/mnt/cdrom‘ path.[[email protected] ~]# mkdir /mnt/cdrom. Once the ‘cdrom‘ mounted, you can verify the files under /mnt/cdrom using ls command.[[email protected] ~]# cd /mnt/cdrom/. Jul 4 2. 1: 3. 1 Cent. OS_Build. Tag. drwxr- xr- x 3 tecmint tecmint 2. Jul 4 2. 1: 2. 9 EFI. Jul 4 2. 1: 3. 1 EULA. Jul 4 2. 1: 3. 1 GPL. Jul 4 2. 1: 2. 9 images. Jul 4 2. 1: 2. 9 isolinux. Jul 4 2. 1: 2. 9 Live. OS. drwxr- xr- x 2 tecmint tecmint 5. Jul 5 1. 5: 5. 6 Packages. Jul 5 1. 6: 1. 3 repodata. Jul 4 2. 1: 3. 1 RPM- GPG- KEY- Cent. OS- 7. - rw- r- -r- - 1 tecmint tecmint 1. Jul 4 2. 1: 3. 1 RPM- GPG- KEY- Cent. OS- Testing- 7. - r- -r- -r- - 1 tecmint tecmint 2. Jul 6 2. 3: 0. 2 TRANS. TBL. 3. Next, create a new local yum repository file under ‘/etc/yum. I am using Vi editor. On Cent. OS 7[[email protected] ~]# vi /etc/yum. Add the following lines to it, save and quit the file.[centos. RPM- GPG- KEY- Cent. OS- 7. On RHEL 7[[email protected] ~]# vi /etc/yum. Add the following lines to it, save and quit the file.[rhel. RPM- GPG- KEY- redhat- release. Some explanation about the above lines.[centos. Name of the new repo section. Name of the new repository. The current location of the packages. Enabled: Enabled repository, value ‘1’ means enable and ‘0’ means disable. Check the signature of the packages, before installing them. Location of the key. Now, check the newly created local repository is available from yum repost list, but before that you must clear the yum cache and verify the local repo.[[email protected] ~]# yum clean all. Sample Output[[email protected] Desktop]# yum repolist all. Loaded plugins: fastestmirror, langpacks. Loading mirror speeds from cached hostfile. Cent. OS- 7 - Base enabled: 8,4. Cent. OS- 7 - Base Sources disabled. Cent. OS- 7 - Plus disabled. Cent. OS- 7 - Plus Sources disabled. Cent. OS- 7 - Debuginfo disabled. Cent. OS- 7 - Extras enabled: 8. Cent. OS- 7 - Extras Sources disabled. Cent. OS- 7 - Updates enabled: 1,4. Cent. OS- 7 - Updates Sources disabled. Note: Did you see in the above output highlighted in red color, that means our local repo is enabled and available to install packages. But, you will also find multiple repositories are enabled in the above output, if you try to install any package it will take Cent. OS Base as default repository. For example, let’s try to install ‘httpd‘ package using yum command.[[email protected] ~]# yum install httpd. Sample Output============================================================================================================================================. Package Arch Version Repository Size. M. Installing for dependencies. Transaction Summary. Install 1 Package (+4 Dependent packages). Total download size: 3. M. Installed size: 1. M. Is this ok [y/d/N]. Note: You see in the above output, the package ‘httpd‘ is installing from Cent. OS base repository, even if you force yum to install packages from local repository by adding ‘–enablerepo‘ option, it still uses Cent. OS Base as its default repo. Give it a try and see the results, you will get same result as above.[[email protected] ~]# yum - -enablerepo=centos. So, to install packages from our local repository, we need to use options ‘–disablerepo‘ to disable all repos and ‘–enablerepo‘ to enable centos. Step 2: Installing Gnome 3 in RHEL/Cent. OS 7. 5. To install GUI (Gnome 3) on RHEL/Cent. OS 7 minimal installation server, run the following yum command. On Cent. OS 7[[email protected] ~]# yum - -disablerepo=* - -enablerepo=centos. GNOME Desktop". On RHEL 7[[email protected] ~]# yum - -disablerepo=* - -enablerepo=rhel. Server with GUI". The above command will install and resolve all the dependent packages using local repository, during installation it will ask for the confirmation press “Y” to continue. When the installation finishes, make the system to boot automatically to the Graphical Interface, here we no more using ‘/etc/inittab‘ file to change runlevel, because RHEL/Cent. OS 7 switched to systemd and here we use ‘targets‘ to change or set default runlevels. Run the following command to tell the system to boot Gnome Desktop automatically at system startup.[[email protected] ~]# ln - sf /lib/systemd/system/runlevel. Once you set the default ‘targets‘ for the GUI, now reboot the server to get into Gnome Desktop.Install Gnome in RHEL/Centos 7.Once Gnome 3 installed, unmount the CD/DVD device.[[email protected] ~]# umount /mnt/cdrom. Can Microsoft Access Print Barcodes From Excel .
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |