Add PHP support to Apache in open SuSe 11.4

yast2 -i apache2-mod_php5

Edit /etc/apache2/sysconfig.d/loadmodule.conf

Add LoadModule php5_module                    /usr/lib64/apache2/mod_php5.so

apache2ctl restart

Then check it worked  apache2ctl -M

php5_module (shared) should be listed.

Pacha podcast

Vist http://www.pacha.com/ for the Pacha podcast, perfect accompaniment to a Monday morning coding session!

mod_rewrite on SuSe

edit /etc/sysconfig/apache2

Add rewrite inside the speech marks for APACHE_MODULES=”rewrite, other modules…”

edit /etc/apache2/default-server.conf

Change AllowOverride None to AllowOverride All

apache2ctl restart

Source http://enarion.net/web/htaccess/mod_rewrite-on-suse/

Create a new MySQL user

CREATE USER ‘user1′@’localhost’ IDENTIFIED BY ‘pass1′;

GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO ‘user1′@’localhost’;

Source http://www.databasef1.com/tutorial/mysql-create-user.html

Twitter feed

Converting an empty MySQL database to UTF8

During the setup of a new Moodle server I got an error that the database was not UTF8. To fix this in MySQL command line: ALTER DATABASE mydatabasename charset=utf8;

Moodle course backup fails

If a backups fail when using the built in backup feature off moodle.  Check your apache error log.  I was getting ‘ALERT – configured POST variable limit exceeded – dropped variable ‘backup_user_info_resource_instance_25051′

Edit your PHP Suhosin module configuraion either withing php.ini or on SuSe Enterprise Linux /etc/php5/conf.d/suhosin.ini

Remove the ; and increase the value e.g. from:
;suhosin.request.max_vars = 200
;suhosin.post.max_vars = 200

suhosin.request.max_vars = 400
suhosin.post.max_vars = 400

Then stop and start apache for the changes to take effect. apache2ctl stop then apache2ctl start.

PHP memory

If you get PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 14 bytes) in /srv/www/htdocs/yourscript.php

Edit /etc/php5/apache2/php.ini

Find memory_limit = 128M ; and up the value e.g. memory_limit = 256M;

Save the file and restart apache e.g. apache2ctl restart

DVD playback in Debian

http://wiki.debian.org/MultimediaCodecs

SQLbuddy

Just read about SQL Buddy – Web based MySQL administration in Linux Magazine.  It’s really good go on, give it a go!

http://www.sqlbuddy.com/