SysAdmin

Mysql TRIGGER command denied to user

Today i got a new mysql issue from one of my colleague. – Issue In MySQL TRIGGER command denied to user ‘username’@’192.168.0.112′ for table ‘abcd_table’ What you normally do ? As usual, I checked the user’s GRANTS with the following command. mysql> show grants for username@’%’; GRANT USAGE ON *.* TO ‘username’@’%’ IDENTIFIED BY PASSWORD ‘D1……….1A9F2’ …

Mysql TRIGGER command denied to user Read More »

Ubuntu – System hangs on shutdown/reboot, how to troubleshoot?

The problem is with the wireless adapter. To fix it you need to do this: Open a terminal and type: “` sudo modprobe -rf rt2860sta sudo modprobe rt2860sta“` Then you need to blacklist the wrong driver: `echo blacklist rt2800pci | sudo tee -a /etc/modprobe.d/blacklist.conf` Once you have rebooted (you will need to do a hard …

Ubuntu – System hangs on shutdown/reboot, how to troubleshoot? Read More »

How to change MTA on Centos5.6 – RHEL based server

Here you can see, how to change MTA qmail to any other you can set as simple sendmail or postfix, exim or qmail. `[root@JobNix~]#ll /etc/alternatives/mta` lrwxrwxrwx 1 root root 23 Aug 31 03:39 /etc/alternatives/mta -> /var/qmail/bin/sendmail [root@JobNix ~]# alternatives –config mta There are 4 programs which provide ‘mta’. Selection Command ———————————————– *+ 1 /var/qmail/bin/sendmail 2 …

How to change MTA on Centos5.6 – RHEL based server Read More »

AWS – How to setup an IAM user to access only one s3 Bucket

Hi, This will explain how you can create an IAM user in AWS, so that you can grant access to only one S3 bucket. – Create an S3 bucket in AWS account. [![](https://res.cloudinary.com/jobnix/image/upload/v1415999956/jobin_2012_02_24_01_vche3d.jpg “AWS_create_s3_bucket”)](https://res.cloudinary.com/jobnix/image/upload/v1415999956/jobin_2012_02_24_01_vche3d.jpg) –  Switch to AWS IAM tab – Click Group >> Create Group [![](https://res.cloudinary.com/jobnix/image/upload/v1415999956/jobin_2012_02_24_02_azzusv.jpg “AWS_create_iam_group”)](https://res.cloudinary.com/jobnix/image/upload/v1415999956/jobin_2012_02_24_02_azzusv.jpg) – Enter a Group Name, Click Continue …

AWS – How to setup an IAM user to access only one s3 Bucket Read More »

Oops…

# Error We cannot seem to find what you were looking for. Maybe we can still help you. – You can search our site using the form provided below. – Or you can view some of our recent posts. Search: ### Recent Posts Jobin JosephView all posts by Jobin Joseph hazercloud.com

MySQL Optimization

Find max connection using the formula:-  memory = keybuffer + (readbuffer + sort buffer ) max connections Open /etc/my.cnf file in your favorite editor (eg: vi, pico etc) max_connections=400 max_user_connections=30 key_buffer=256M (128MB for every 1GB of RAM) myisam_sort_buffer_size=64M join_buffer_size=1M read_buffer_size=1M (1MB for every 1GB of RAM) sort_buffer_size=1M (1MB for every 1GB of RAM) table_cache=1500 thread_concurrency=2 …

MySQL Optimization Read More »

Apache Optimization

All the important configuration options are stored by Apache in a config file called httpd.conf that is located at /usr/local/apache/conf/httpd.conf. We will start by opening this file in your favorite text editor. For example: – vi /usr/local/apache/conf/httpd.conf **MaxClients** Total number of concurrent connections. Locate it in the configuration file. This should be set to a …

Apache Optimization Read More »

Scroll to Top