Bright:Setup user quotas - Revision history

Chenhui: /* MySQL */

2015-04-01T15:13:51Z

MySQL

Chenhui at 15:11, 1 April 2015

2015-04-01T15:11:27Z

David at 11:20, 19 December 2014

2014-12-19T11:20:51Z

Show changes

David at 10:58, 19 December 2014

2014-12-19T10:58:30Z

David at 09:48, 19 December 2014

2014-12-19T09:48:21Z

David: Created page with "* Lets apply user quotas to /home on a Bright headnode * Running Centos 6.5 * Applying qoutas to an EXT3 filesystem == Setup quotas within /etc/fstab == * Need to add `us..."`

2014-12-19T07:31:16Z Created page with "* Lets apply user quotas to /home on a Bright headnode * Running Centos 6.5 * Applying qoutas to an EXT3 filesystem == Setup quotas within /etc/fstab == * Need to add <tt>us..." New page * Lets apply user quotas to /home on a Bright headnode * Running Centos 6.5 * Applying qoutas to an EXT3 filesystem == Setup quotas within /etc/fstab == * Need to add <tt>usrquota,grpquota</tt> to the <tt>/etc/fstab</tt> file for the home dir mount point * Lets check the home mount point (in this instance its just / for bright) <syntaxhighlight> [root@trainning ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/md126 426G 14G 392G 4% / tmpfs 16G 84K 16G 1% /dev/shm /dev/md125 496M 24M 447M 6% /boot </syntaxhighlight> * Lets update the <tt>/etc/fstab</tt> file with the parameters <tt>usrquota,grpquota</tt> for user mount points. <syntaxhighlight> [root@trainning ~]# cat /etc/fstab UUID=9586a511-9b87-48e1-8749-f5fa0ebabd01 / ext3 defaults,noatime,nodiratime,usrquota,grpquota 0 1 UUID=6b542d80-a228-47bc-9e39-831f37bc074c /boot ext2 defaults,noatime,nodiratime 0 2 UUID=5e9078a4-9975-4659-839f-9749ceb8ab02 swap swap defaults 0 0 proc /proc proc defaults,nosuid 0 0 sysfs /sys sysfs noauto 0 0 devpts /dev/pts devpts mode=0620,gid=5 0 0 tmpfs /dev/shm tmpfs defaults 0 0 # This section of this file was automatically generated by cmd. Do not edit manually! # BEGIN AUTOGENERATED SECTION -- DO NOT REMOVE # END AUTOGENERATED SECTION -- DO NOT REMOVE </syntaxhighlight> * Remount the filesystem and verify the args in mtab <syntaxhighlight> [root@trainning ~]# mount -o remount / [root@trainning ~]# cat /etc/mtab /dev/md126 / ext3 rw,noatime,nodiratime,usrquota,grpquota 0 0 proc /proc proc rw,nosuid 0 0 sysfs /sys sysfs rw 0 0 devpts /dev/pts devpts rw,mode=0620,gid=5 0 0 tmpfs /dev/shm tmpfs rw 0 0 /dev/md125 /boot ext2 rw,noatime,nodiratime 0 0 none /proc/sys/fs/binfmt_misc binfmt_misc rw 0 0 sunrpc /var/lib/nfs/rpc_pipefs rpc_pipefs rw 0 0 nfsd /proc/fs/nfsd nfsd rw 0 0 gvfs-fuse-daemon /root/.gvfs fuse.gvfs-fuse-daemon rw,nosuid,nodev 0 0 </syntaxhighlight>

@@ Line 252: / Line 252: @@
 </syntaxhighlight>
-= MySQL =
+[[ MySQL ]]
 Please note that you can reset the MySQL root password by the following
 procedure:

← Older revision		Revision as of 15:11, 1 April 2015
Line 250:		Line 250:


		+	</syntaxhighlight>
		+
		+	= MySQL =
		+	Please note that you can reset the MySQL root password by the following
		+	procedure:
		+
		+	1- Stop the services.
		+	<syntaxhighlight>
		+	# service cmd stop
		+	# service mysql stop
		+	</syntaxhighlight>
		+
		+	2- Start MySQL in safe mode.
		+	<syntaxhighlight>
		+	# mysqld_safe --skip-grant-tables &
		+	# mysql -u root
		+	</syntaxhighlight>
		+
		+	3- Change the password
		+	<syntaxhighlight>
		+	mysql> use mysql;
		+	mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where
		+	User='root'; flush privileges;
		+	quit
		+	</syntaxhighlight>
		+
		+	Replace the string NEW-ROOT-PASSWORD inside the double quotes with your
		+	new password.
		+
		+	4- Restart the services.
		+	<syntaxhighlight>
		+	# service mysqld stop
		+	# service mysqld start
		+	# service cmd start
	</syntaxhighlight>		</syntaxhighlight>

@@ Line 54: / Line 54: @@
 * Note: This took a few mins to run
 * Perform an initial check of the system
@@ Line 91: / Line 86: @@
    Filesystem                   blocks       soft       hard     inodes     soft     hard
    /dev/md126                       60    5242880    5242880         15        0        0
 </syntaxhighlight>
@@ Line 102: / Line 102: @@
       /dev/md126      60  5242880 5242880              15       0       0
 </syntaxhighlight>

@@ Line 2: / Line 2: @@
 * Running Centos 6.5
 * Applying qoutas to an EXT3 filesystem
 == Setup quotas within /etc/fstab ==
@@ Line 45: / Line 47: @@
 nfsd /proc/fs/nfsd nfsd rw 0 0
 gvfs-fuse-daemon /root/.gvfs fuse.gvfs-fuse-daemon rw,nosuid,nodev 0 0
 </syntaxhighlight>