29Jun 2012 by Asim Zeeshan No Comments

cPanel/WHM 11.30 now supports MySQL TRIGGERS and VIEW privileges

News
I just noticed that cPanel/WHM 11.30 now supports MySQL TRIGGERS and VIEW privileges. From the official release notes In 11.30 we are adding support for the MySQL TRIGGER and VIEW privileges. Systems using MySQL 5.0 and higher can use the VIEW privilege. This privilege will grant the database user the CREATE VIEW and SHOW VIEW MySQL privileges. When using MySQL 5.0, the SUPER privilege is required for the TRIGGER privilege. Due to this caveat, we will not support the TRIGGER privilege on systems using MySQL 5.0. Systems using MySQL 5.1 and higher can enable and use the TRIGGER privilege. However, this privilege is not available if binary logging is enabled for the MySQL service. Neither TRIGGER nor VIEW is available to systems using MySQL 4.0 or 4.1.
Read More
19Jul 2010 by Asim Zeeshan 6 Comments

Installing Lighttpd, PHP and MySQL on Ubuntu

How to, Linux, OpenSource, PHP, Tips and Tricks, Tutorials, Ubuntu, Virtual Private Server
If you are not getting a package on Ubuntu, please check to see if your /etc/apt/sources.list file is updated. This is common with most VPS providers On VPS, especially with challenging small memory limit (e.g. 64MB or 128MB) lighttpd is the best option instead of Apache. In this article I will show you how to do that. On a fresh box (which has no apache installed) type this to get lighttpd webserver installed [code]apt-get install lighttpd[/code] Now install PHP5 CGI package and PHP5 command line package [code]apt-get install php5-cgi php5-cli[/code] Edit the following file [code]nano /etc/php5/cgi/php.ini[/code] and uncomment this line [code]cgi.fix_pathinfo = 1[/code] Now enable fastcgi module [code]lighty-enable-mod fastcgi[/code] Restart Lighttpd [code]/etc/init.d/lighttpd restart[/code] You get the welcome page Lets install MySQL 5.1 server and client [code]apt-get install mysql-server mysql-client[/code] and…
Read More
15May 2010 by Asim Zeeshan 6 Comments

Good bye CentOS! Hello Ubuntu

CentOS, Linux, PHP, Reviews, Tips and Tricks, Ubuntu
Its been about almost more then two years since I have been playing with CentOS on many different platforms etc. Its very stable but on the other hand, PHP/MySQL updates are very hard to get and still PHP is 5.1.6. I tried EPEL repo and it updated PHP to 5.3.1 but still there were conflicts with stuff and many core packages. So, I thought why not move to Ubuntu since it has just announced 10.04LTS (Long Term Support) in April 2010. Folks at iWeb were really nice to do a reinstall without any charges and also process a memory upgrade request at an amazing 50% discount. Ubuntu 10.04 LTS Apache 2 version is 2.2.14 PHP version is 5.3.2 MySQL version is 5.1.41-3ubuntu12 SVN (Subversion) version is 1.6.6 As a comparison…
Read More
08Apr 2010 by Asim Zeeshan No Comments

How to solve ‘You do not have sufficient permissions to access this page.’ in WordPress

How to, Tutorials
I have been getting the following error because I changed the database table prefix You do not have sufficient permissions to access this page. The cause of the problem is that you have changed the database prefixes but still, some of the word press config is tied down to the previous prefix (wp_ or something) Just execute the following two queries [code lang="sql" toolbar="false"] -- Replace 'prefix_' with your actual prefix UPDATE `prefix_usermeta` SET `meta_key` = REPLACE( `meta_key` , 'wp_', 'prefix_' ); -- Replace 'prefix_' with your actual prefix UPDATE `prefix_options` SET `option_name` = 'prefix_user_roles' WHERE `option_name` ='wp_user_roles' AND `blog_id` =0;[/code]
Read More
02Jul 2009 by Asim Zeeshan 2 Comments

How to Install Apache, PHP and MySQL on CentOS

How to, Linux, OpenSource, PHP, Resources, Tips and Tricks, Tutorials
I have seen people installing Apache, PHP and MySQL from source code on a production server. You should NEVER, NEVER, NEVER install these packages from source on an RPM or DEB based Linux distributions. Did I say “NEVER” enough times to make your realize that it is not a good practice? Installing from source is bad idea; there are many reasons for this but the major one is that you will be spending a lot of time keeping the system updated. If you love installing from source then I would suggest using a different distribution e.g. Gentoo. You can build from source if the package is not available in yum but still, try to use “yum” (or “apt-get” on Ubuntu) because it will save a lot of your time when…
Read More
26May 2009 by Asim Zeeshan No Comments

How to list Stored Procedures and Functions in MySQL database

How to, Resources, Tips and Tricks, Tutorials
How to check if there are any STORED PROCEDURE in MySQL database? [sourcecode language="sql"]SHOW PROCEDURE STATUS;[/sourcecode] Similarly for MySQL database FUNCTIONS [sourcecode language="sql"]SHOW FUNCTION STATUS;[/sourcecode] But it displays a list of all PROCEDURE and all FUNCTIONS, you can chop down the list by appending [sourcecode language="sql"]## display FUNCTIONS from 'test' db SHOW FUNCTION STATUS WHERE db LIKE ='test';[/sourcecode] Hope it helps somebody. Enjoy!
Read More
01May 2009 by Asim Zeeshan 6 Comments

Installing MySQL 5.1 on Ubuntu

How to, Linux, Tips and Tricks, Tutorials, Ubuntu
I wanted to use PARTITIONING introduced in MySQL 5.1 to handle some 2 Million records (and growing everyday) in a table. Ubuntu 8.10 does not have MySQL 5.1 available if you do apt-get the latest version available is 5.0 So this is what I did, its easy and this might help somebody. [sourcecode language="plain"]nano /etc/apt/sources.list[/sourcecode] I prefer nano editor but you can use any editor of your choice. Add these new lines at the end of the end of the file. [sourcecode language="plain"]deb http://ppa.launchpad.net/monty/ubuntu gutsy main universe restricted multiverse deb http://ppa.launchpad.net/smurf/ubuntu gutsy main universe restricted multiverse[/sourcecode] (These packages were targeted for 7.10 so I will recommend using them and removing them from this list once you got the latest MySQL version) Now run the following commands [sourcecode language="plain"]apt-get update apt-get…
Read More
09Jan 2009 by Asim Zeeshan 2 Comments

Intall Apache, MySQL and PHP on Ubuntu 8.10

How to, Linux, OpenSource, Resources, Reviews, Tips and Tricks, Tutorials, Ubuntu
WARNING: Please use this method to install Apache, PHP and MySQL because its more suitable for most of your needs and has options to auto-upgrade your installation. The following method is obsolete and not recommended. After trying to install Apache, MySQL and PHP on Ubuntu 8.10 via several methods listed over the web. I opted for xampp package for linux. It is as easy as ABC Download the xampp linux package from their official website [code lang="plain"]wget http://nchc.dl.sourceforge.net/sourceforge/xampp/xampp-linux-1.7.tar.gz[/code] (I have selected NCHC, Taiwan as the mirror to download this package, you may try another) Extract the files [code lang="plain"]sudo tar xvfz xampp-linux-1.7.tar.gz -C /opt[/code] Chmod the files to have nobody ownership [code lang="plain"]sudo chown -R nobody:root /opt/lampp/[/code] Configure xampp security [code lang="plain"]sudo /opt/lampp/lampp security[/code] Start xampp with this command [code…
Read More