howto use php pear horde utilities whilst avoiding the ubuntu14 apache2 php5 pear includefile bug

on an ubuntu 14 apache 2 php 5 install if you look at your php include_path it may look like this

include_path .:/usr/share/php:/usr/share/pear 

which is WRONG because there is no /usr/share/pear directory in fact on ubuntu 14 php 5 pear is installed in /usr/share/php/PEAR and horde is installed in /usr/share/php/Horde

so to enable autoloading to allow you to automatically use a horde class just

install pear horde

# pear channel-discover pear.horde.org
# pear install horde/Horde_Autoloader
# pear install horde/Horde_Text_Diff

then

require_once 'Horde/Autoloader/Default.php';

then whenever you use any horde class library (that you have previously downloaded and installed) it will be autoloaded

$check_diff = new Horde_Text_Diff( 'auto', array($a_lines, $b_lines) );
$renderer = new Horde_Text_Diff_Renderer_Inline();

some more php horde text css and js libraries

some more php horde text css and js libraries

• http://pear.horde.org/
• Horde_Text_Filter
• Horde_Text_Filter_Csstidy
• Horde_Text_Filter_Jsmin

php horde text diff

the php text diff library has moved from pear to horde

download

• http://pear.horde.org/

docs

• http://dev.horde.org/api/master/lib/Text_Diff/class-Horde_Text_Diff.html
• http://www.mybbsecurity.net/docs/class/Horde_Text_Diff.html

mysql config files, global, commandline options and session variables

you seem to be able to set global and command line options variables in mysql config files but not session variables so you’ll need to create a .my.cnf file with your favorite global and command line options and a separate mysql.sql file with your favorite session variables and source it once logged in

ie

.my.cnf

[mysql]
user=user
password=password

mysql.sql

#
set sql_quote_show_create=OFF

mysql

mysql> source ~/mysql.sql

see also

https://dev.mysql.com/doc/refman/5.5/en/option-files.html

drupal 7 install fails with call to undefined function

if you get

Fatal error: Call to undefined function field_attach_load() in /var/www/drupal/includes/entity.inc on line 316

just drop all the tables in your drupal db and rerun /install

code beautifiers

css

http://www.webtoolkitonline.com/css-formatter.html

json

http://www.webtoolkitonline.com/json-formatter.html

sql

http://www.webtoolkitonline.com/sql-formatter.html

xml

http://www.webtoolkitonline.com/xml-formatter.html

ubuntu php5 mcrypt is broken

to fix it you will need to run

# php5enmod mcrypt
# service apache2 restart