MY SQL INSTALATION ON LINUX

Howto Install MySQL on Linux

Tweet

Most of the Linux distro comes with MySQL.  If you want use MySQL, my recommendation is that you download the latest version of MySQL and install it yourself. Later you can upgrade it to the latest version when it becomes available. In this article, I will explain how to install the latest free community edition of MySQL on Linux platform.

1. Download the latest stable relase of MySQL

Download mySQL from mysql.com .  Please download the community edition of MySQL for your appropriate Linux platform. I downloaded the “Red Hat Enterprise Linux 5 RPM (x86)”. Make sure to download MySQL Server, Client and “Headers and libraries” from the download page.

• MySQL-client-community-5.1.25-0.rhel5.i386.rpm
• MySQL-server-community-5.1.25-0.rhel5.i386.rpm
• MySQL-devel-community-5.1.25-0.rhel5.i386.rpm

INTERVIEW QUESTIONS FOR LINUX ADMIN

Name: V V S GUPTA
email ID: lvvs.gupta@hotmail.com








Interview stuff:

Cromton Interview Questions

1. Difference between RHEL 4 & RHEL 5.
2. What is RAID and what is RAID 5
3. If a user (simon) is created in FTP and a directory in any location of the disk, that particular directory should be used for the user simon itself. He should not have other access.
4. How to deny a network in web server & what do you write and where do you write in the configuration file.
5. If I want to create more than 2 web pages what is the procedure and how do you configure the file.


Zeta Interactive

1. What is the Linux Booting Process?
2. How do you compile a Kernel?
3. What are Run Levels? Name them
4. What is NFS and which file do you configure for NFS.
5. What are the Records stored in DNS.
6. What are TCP wrappers?


Precession Informatics

1. What is the port no of Telnet & SSH & Apache
2. What is the difference between Telnet and SSH.
3. If at all I need to restrict a user remotely how can I do this?
4. What is the package you install for NIS? (Server side)
5. What is LDAP
6. What are the services to be restarted for NFS
7. Why do we restart Portmap Service?
8. Why do we add no_root_squash in NFS?
9. If we want to change the port no for Apache where I need to change it. Whether it will work if I do so
10. What is the default permission for ‘tmp’ directory
11. Where do we see the log messages
12. If we have 5 users and a group called ‘system’ and I have a directory where I will create a file then I need to obtain my group owner as the user name
13. Why do we use sticky Bit and what is the syntax.


Oracle

1. What s initrd file?
2. How do you install kernel
3. How to find the which ports opened
4. What are the commands used to check which all process running?
5. Explain Raid 5
6. How to find what interfaces available
7. How to assign IP Address through command line.
8. What are the troubleshooting command used till now
9. What are the service to be restarted for NFS
10. what are the daemons for NFS
11. Knowledge in Back & Restore
12. How to check what services are running apart form /etc/init.d/ or service <name> satus
Round II

13. What is the linux Boot Process
14. what is initrd file
15. wha is the N/W bonding and how o find the interfaces which are active / deactive
16. Port number of NFS / Portmap / FTP .
17. How to find the routing
18. How to assign the routing table through command line
19. Difference between Raid 1 & Raid 5
20. what are the daemons should be running for NFS
21. how to mount NFS permanently
22. how to assign hostname for the system
23. How to extend the Logical volume
24. what is vmlinuz(in Grub.conf)
25. How to find hba car failure
26. how to find the NFS directory from client with knowing only Nfs Server IP
27. What is the command to restart the server.
28. How to allow access to the user with out password (SSH)

Round III

29. What is initrd file what is the use
30. How dns resolves
31. How to modify the User ID for a particular user
32. I have space in / and root user is not able to touch file
33. How do you harden the linux system
34. rpm –qa is not displaying rpm’s
35. what are the fields in /etc/shadow file
36. what is swap and what is the use
37. How to reduce the LVM
38. What are ACL’s

LDAP CONFIGURATION ON LINUX

<!-- closes #header

L V V S GUPTA

email id: lvvs.gupta@hotmail.com

Step-by-step OpenLDAP Installation and Configuration

This tutorial describes how to install and configure an OpenLDAP server and also an OpenLDAP client.

Step-by-step OpenLDAP Installation and Configuration This tutorial describes how to install and configure an OpenLDAP server and also an OpenLDAP client. Step by Step Installation and Configuration OpenLDAP Server Software:  OS-Cent OS 4.4, openldap 2.2.13-6.4E System name:   ldap.adminmart.com Domain name:   adminmart.com System IP:     192.168.1.212 Note: Use your domain name and IP instead of adminmart. Easy steps for adding users:     1. Create unix user     2. Create unix user's ldap passwd file     3. Convert passwd.file to ldif file     4. Add ldap file to LDAP Directory using ldapadd Step #1. Requirements     compat-openldap.i386 0:2.1.30-6.4E     openldap-clients.i386 0:2.2.13-6.4E     openldap-devel.i386 0:2.2.13-6.4E     openldap-servers.i386 0:2.2.13-6.4E     openldap-servers-sql.i386 0:2.2.13-6.4E You can install them using the command: yum install *openldap* -y Step #2. Start the service [root@ldap ~]# chkconfig --levels 235 ldap on [root@ldap ~]# service ldap start  Step #3. Create LDAP root user password [root@ldap ~]# slappasswd     New password:     Re-enter new password:     {SSHA}cWB1VzxDXZLf6F4pwvyNvApBQ8G/DltW [root@ldap ~]# Step #4. Update /etc/openldap/slapd.conf for the root password [root@ldap ~]# vi /etc/openldap/slapd.conf     #68 database        bdb     #69 suffix          "dc=adminmart,dc=com"     #70 rootdn          "cn=Manager,dc=adminmart,dc=com"     #71 rootpw          {SSHA}cWB1VzxDXZLf6F4pwvyNvApBQ8G/DltW  Step #5. Apply Changes [root@ldap ~]# service ldap restart  Step #6. Create test users [root@ldap ~]# useradd test1 [root@ldap ~]# passwd test1     Changing password for user test1.     New UNIX password:     Retype new UNIX password:     passwd: all authentication tokens updated successfully. [root@ldap ~]# useradd test2 [root@ldap ~]# passwd test2     Changing password for user test2.     New UNIX password:     Retype new UNIX password:     passwd: all authentication tokens updated successfully. [root@ldap ~]# Note: Repeat the same for the rest of users Step #7. Migrate local users to LDAP [root@ldap ~]# grep root /etc/passwd > /etc/openldap/passwd.root [root@ldap ~]# grep test1 /etc/passwd > /etc/openldap/passwd.test1 [root@ldap ~]# grep test2 /etc/passwd > /etc/openldap/passwd.test2  Note: Repeat the same for the rest of users Step #8. Update default settings on file /usr/share/openldap/migration/migrate_common.ph     #71 $DEFAULT_MAIL_DOMAIN = "adminmart.com";     #74 $DEFAULT_BASE = "dc=adminmart,dc=com"; Step #9. Convert passwd.file to ldif (LDAP Data Interchange Format) file  [root@ldap ~]# /usr/share/openldap/migration/migrate_passwd.pl /etc/openldap/passwd.root /etc/openldap/root.ldif [root@ldap ~]# /usr/share/openldap/migration/migrate_passwd.pl /etc/openldap/passwd.test1 /etc/openldap/test1.ldif [root@ldap ~]# /usr/share/openldap/migration/migrate_passwd.pl /etc/openldap/passwd.test2 /etc/openldap/test2.ldif Note: Repeat the same for the rest of users Step #10. Update root.ldif file for the "Manager" of LDAP Server  [root@ldap ~]# vi /etc/openldap/root.ldif     #1 dn: uid=root,ou=People,dc=adminmart,dc=com     #2 uid: root     #3 cn: Manager     #4 objectClass: account Step #11. Create a domain ldif file (/etc/openldap/adminmart.com.ldif) [root@ldap ~]# cat /etc/openldap/adminmart.com.ldif     dn: dc=adminmart,dc=com     dc: adminmart     description: LDAP Admin     objectClass: dcObject     objectClass: organizationalUnit     ou: rootobject     dn: ou=People, dc=adminmart,dc=com     ou: People     description: Users of adminmart     objectClass: organizationalUnit Step #12. Import all users in to the LDAP Add the Domain ldif file [root@ldap ~]# ldapadd -x -D "cn=Manager,dc=adminmart,dc=com" -W -f  /etc/openldap/adminmart.com.ldif     Enter LDAP Password:     adding new entry "dc=adminmart,dc=com"     adding new entry "ou=People, dc=adminmart,dc=com" [root@ldap ~]# Add the users: [root@ldap ~]# ldapadd -x -D "cn=Manager,dc=adminmart,dc=com" -W -f  /etc/openldap/root.ldif     Enter LDAP Password:     adding new entry "uid=root,ou=People,dc=adminmart,dc=com"     adding new entry "uid=operator,ou=People,dc=adminmart,dc=com" [root@ldap ~]# [root@ldap ~]# ldapadd -x -D "cn=Manager,dc=adminmart,dc=com" -W -f  /etc/openldap/test1.ldif     Enter LDAP Password:     adding new entry "uid=test1,ou=People,dc=adminmart,dc=com" [root@ldap ~]# [root@ldap ~]# ldapadd -x -D "cn=Manager,dc=adminmart,dc=com" -W -f  /etc/openldap/test2.ldif     Enter LDAP Password:     adding new entry "uid=test2,ou=People,dc=adminmart,dc=com"  [root@ldap ~]#  Note: Repeat the same for the rest of users Step #13. Apply Changes  [root@ldap ~]# service ldap restart  Step #14. Test LDAP Server It prints all the user information: [root@ldap ~]# ldapsearch -x -b 'dc=adminmart,dc=com' '(objectclass=*)'  LDAP Authentication In Linux Please do not use the comment function to ask for help! If you need help, please use our forum. Comments will be published after administrator approval. Second Entry Submitted by Anonymous (not registered) on Sun, 2012-11-18 12:38. I am not able to adding my second entry. Anyone Could you please help me. [root@client ~]# ldapadd -x -D "cn=Manager,dc=adminmart,dc=com" -W -f /etc/openldap/test1.ldif Enter LDAP Password: adding new entry "uid=test1,ou=People,dc=adminmart,dc=com" ldap_add: No such object (32)         matched DN: dc=adminmart,dc=com [root@client ~]# ldapadd -x -D "cn=Manager,dc=adminmart,dc=com" -W -f /etc/openldap/test2.ldif Enter LDAP Password: adding new entry "uid=test2,ou=People,dc=adminmart,dc=com" ldap_add: No such object (32)         matched DN: dc=adminmart,dc=com reply | view as pdf error reading information on service ldap: No such file or direc Submitted by MacPhotoBiker (not registered) on Wed, 2012-08-29 16:04. Hi, I did the installation from step one (on CentOS 6), and all went well. But already in step 2, I get an error message: root@vps [~]# chkconfig --levels 235 ldap on error reading information on service ldap: No such file or directory Could somebody please guide me how to proceed from here? Any help would be greatly appreciated! reply | view as pdf I don't have ldap service Submitted by maryam (not registered) on Tue, 2012-03-13 07:59. I don't have any thing to ldap service in step 2,can I do slapd service instead of ldap? reply | view as pdf Really Great DOC... Thanks a Submitted by Anonymous (not registered) on Thu, 2011-06-16 05:59. Really Great DOC... Thanks a lot reply | view as pdf Re: Really Great DOC... Thanks a Submitted by RogierDikkes (not registered) on Thu, 2012-03-29 11:02. Yeah good document, had some problems with the configuration. Followed all steps but got the error that username and password was incorrect when trying to login with phpadmin environment, after changing cn "Manager" to admin it worked perfect. Thanks for the guide! reply | view as pdf Great tutorial, got me up Submitted by Anonymous (not registered) on Mon, 2010-04-19 14:05. Great tutorial, got me up and running in a few hours, after looking for over a week for a decent document to follow... There is a typo error above that I should highlight. In /etc/openldap/adminmart.com.ldif example above, you need to insert a blank line between each "dn" text area. The result should be: dn: dc=adminmart,dc=com dc: adminmart description: LDAP Admin objectClass: dcObject objectClass: organizationalUnit ou: rootobject dn: ou=People, dc=adminmart,dc=com ou: People description: Users of adminmart objectClass: organizationalUnit enjoy reply | view as pdf Password problem Submitted by vinu (not registered) on Sat, 2009-02-14 04:34. When i entered the password while importing the domain ldif file to LDAP, there was an error ldap_bind: Invalid credentials (49) What might be the problem. The password i entered was same as the one created using slappasswd.   reply | view as pdf Re: Password problem Submitted by zaza (not registered) on Tue, 2009-09-08 08:37. have u solve the problem with the  "ldap_bind: Invalid credentials (49)"?? im facing the same too.... reply | view as pdf Re: Re: Password problem Submitted by Anonymous (not registered) on Wed, 2011-07-13 14:53. Hi, In the configuration file the line starting with a space is considered a continuation of the previous line so guys check in the slapd.conf for the "rootpw" line.if there is a space at the starting of the line then remove it and restart the server it will resolve your problem. reply | view as pdf Yes, It worked Submitted by Vkram (not registered) on Thu, 2012-03-29 07:03. U rocks..... bro... It worked for me space before rootpw....... reply | view as pdf Re: Re: Password problem Submitted by Anonymous (not registered) on Tue, 2011-02-15 20:06. I know I'm late to the thread for this, but hopefully this will be of value to future readers. For the password problem, I was confusing the root password for the user's password.  When doing the ldapadd, I used the root user's password, and that fixed the credentials problem.  Don't use the password of the user you are adding. For the problem with not finding the server, specify "-h 127.0.0.1" to resolve to localhost.  It doesn't default to any server in the add or search, not even localhost. reply | view as pdf I can't add the domain ldif Submitted by Ken (not registered) on Fri, 2008-09-19 20:02. I can't add the domain ldif file - I get prompted for the password, I enter the password used in the slapd.conf (tried both encrypted and plaintext) but still get the error below: ldap_bind: Can't contact LDAP server (-1) Thoughts? reply | view as pdf Re: I can't add the domain ldif Submitted by Anonymous (not registered) on Wed, 2011-07-13 14:48.  ldap_bind: Can't contact LDAP server (-1)This is when your server is not reachable  Start the LDAP server and try add the user :)  reply | view as pdf ldap installation related error Submitted by ashadeep nagar (not registered) on Fri, 2009-04-03 14:02.           ldap_bind: Invalid credentials (49) reply | view as pdf Re: ldap installation related error Submitted by anand pavithran (not registered) on Thu, 2011-01-27 07:44. Check for free space in the ldif file.(Some times there will be unwanted space  in the line). reply | view as pdf Groups and shadow Submitted by Revantine (registered user) on Mon, 2007-03-12 20:22. I had to add a blank line to fix an error in /etc/openldap/adminmart.com.ldif, and I added for groups : dn: dc=adminmart,dc=com dc: adminmart description: LDAP Admin objectClass: dcObject objectClass: organizationalUnit ou: rootobject dn: ou=People, dc=adminmart,dc=com ou: People description: Users of adminmart objectClass: organizationalUnit dn: ou=Group, dc=adminmart,dc=com ou: Group description: Groups of adminmart objectClass: organizationalUnit I copied all of my groups that I wanted in ldap from /etc/groups to /etc/openldap/groups.txt and then ran: /usr/share/openldap/migration/migrate_groups.pl /etc/openldap/groups.txt /etc/openldap/groups.ldif After I imported users, and groups, I used phpldapadmin to import shadow passwords. I opened /etc/shadow and copied the password field: username:$1$0oDpBoKc$qw6grPT4jqgfqkc5Kzd/G.:_____:_:_____:_::: as {crypt}$1$0oDpBoKc$qw6grPT4jqgfqkc5Kzd/G. And selected clear in the drop down so it would not try to re-encrypt (mangle) the password. There is likely a scripted solution for shadow passwords, but I only had about 15 users and it was faster to just do it. reply | view as pdf Replication Submitted by nicolargo (registered user) on Mon, 2007-02-19 17:39. Thanks for the tuto. Here is a link to  help you configure a backup server (slave server) and another one to configure ProFTPD to use LDAP for authentication (french link but you can google translate ;)). Nicolargo  reply | view as pdf

THE BASIC COMMANDS OF LINUX

Creating repository in linux:

#cd /linuxos/Server

cd -ivh createrepo....rpm

#rpm --import RPM-GPG-KEY-redhat-release

#rpm --import RPM-GPG-KEY-redhat-beta