A common issue I see Rackspace customers with is there PhpMyAdmin not having enough memory, often I ‘ll see countless tickets where the memory_limit is increased for phpmyadmin, and when one of their virtualhosts falls over, it is then decreased for all of the sites, until someone wants to use phpmyadmin again. <\/p>\n
not very good really is it? Actually, fixing this is quite easy. Lets provide a php.ini for phpmyadmin that only phpmyadmin uses;<\/p>\n
\r\n\r\n# Copy original php configuration\r\ncp \/etc\/php.ini \/usr\/share\/phpMyAdmin\/php.ini\r\n\r\n# Modify \/usr\/share\/phpMyAdmin\/php.ini so that the following variable is set as a higher value\r\nmemory_limit = 256M\r\n\r\n<\/pre>\nNaturally if you now goto the customerwebsite.com\/phpmyadmin\/php.ini you’ll see a nice php file waiting for you… not good… we need to protect the php.ini file as it can expose stuff we don’t want to be seen; lets make it as hard to find out the server configuration and hide php.ini altogether.<\/p>\n
\r\n# File to edit may differ but it can be any file inside conf.d make one if you like call it phpini.conf or something\r\nvi \/etc\/httpd\/conf.d\/php.conf\r\n<\/pre>\n\r\n<Files php.ini>\r\n Order allow,deny\r\n Deny from all\r\n<\/Files>\r\n<\/pre>\nDont’t forget the most important step<\/p>\n
\r\n# Check apache syntax\r\napachectl -t\r\n\r\n# Restart the apache process\r\napachectl graceful\r\n<\/pre>\nAnother pretty simples thing to do. That isn’t pretty simple until you do it.<\/p>\n","protected":false},"excerpt":{"rendered":"
A common issue I see Rackspace customers with is there PhpMyAdmin not having enough memory, often I ‘ll see countless tickets where the memory_limit is increased for phpmyadmin, and when one of their virtualhosts falls over, it is then decreased … Continue reading