[Phpwm] Horde

Jon Spriggs jon at spriggs.org.uk
Sat Feb 10 10:21:50 GMT 2007


Hi all,

Has anyone tried using the Horde groupware suite?

I've been playing with it for a couple of weeks and I think it's
really good, but I just wanted to see if anyone else had the same
impression (and see if anyone knows of anything better :) ).

I'm actually pulling different bits from the site - using some bits of
the CVS code (well, actually mostly CVS code outside of the core
frameworks). My version from the CVS has: Calendar, Tasks, Memo, Wiki,
File Store

If anyone wants to duplicate what I've done here's my simple walk through guide.

Base Fedora Core 6 install.
(Enable Software Development and Web Server, select "Select packages
manually" and remove the GNOME and X11 group packages)

Select "Firewall configuration" and choose "Disable" then "Exit"
------------ SCRIPTS BELOW ------------------
mkdir /sources
cd /sources
wget ftp://ftp.horde.org/pub/horde-groupware/horde-groupware-1.0.tar.gz
tar xfz horde-groupware-1.0.tar.gz
mv horde-groupware-1.0 horde
mkdir /var/www/html
cd /var/www/html
cp -Rf /sources/horde/* .
cd /usr/share
mv /var/www/html/pear .
cd /var/www/html
ln -s /usr/share/pear pear

yum install php-devl php-mysql php-ldap php-gd mysql-common
mysql-server httpd php-mcrypt php-pear php-xml gpg php-imap
php-mbstring openssl pth-devel
yum update

chkconfig --levels 345 httpd on
chkconfig --levels 345 mysqld on

pear channel-discover pear.horde.org

rm -Rf kronolith/ turba/ nag/ mnemo/

export CVSROOT=:pserver:cvsread at anoncvs.horde.org:/repository
# the following password is "horde" no quotes.
cvs login
cvs co kronolith
cd kronolith/config/
for foo in *.dist; do cp $foo `basename $foo .dist`; done
cd ../..
cvs co nag
cd nag/config/
for foo in *.dist; do cp $foo `basename $foo .dist`; done
cd ../..
cvs co mnemo
cd mnemo/config/
for foo in *.dist; do cp $foo `basename $foo .dist`; done
cd ../..
cvs co gollem
cd gollem/config/
for foo in *.dist; do cp $foo `basename $foo .dist`; done
cd ../..
cvs co wicked
cd wicked/config/
for foo in *.dist; do cp $foo `basename $foo .dist`; done
cd ../..

pear channel-update pear.php.net
pear install Text_Wiki Date_Holidays-alpha

chown -R apache.apache *
chmod -R u+w *

cd scripts

# You must at least configure the database and create the database
tables using the following util
./setup.php

---------------- SCRIPT STOP ------------------

Visit http://<servername>/test.php and confirm all dependencies are
"Green" (memcache, fileinfo, SSH2 PECL packages are not required, SSH2
VFS driver is not required)

Configure /var/www/html/gollem/config/backends.php to use just "SQL
Server with home" - that is, delete all the other lines except this
one.

Patch /var/www/html/config/registry.php with the following:

84c84
<     'status' => 'active',
---
>     'status' => 'inactive',
92c92
<     'status' => 'active',
---
>     'status' => 'inactive',
112c112
<     'status' => 'active',
---
>     'status' => 'inactive',
121c121
<     'status' => 'active',
---
>     'status' => 'inactive',
160c160
<     'menu_parent' => 'organizing'
---
>     'menu_parent' => 'horde'
183c183
<     'menu_parent' => 'organizing'
---
>     'menu_parent' => 'horde'
192c192
<     'menu_parent' => 'organizing'
---
>     'menu_parent' => 'horde'
229c229
<     'status' => 'active',
---
>     'status' => 'inactive',
411c411
<     'menu_parent' => 'myaccount',
---
>     'menu_parent' => 'horde',
426c426
<     'status' => 'active',
---
>     'status' => 'inactive',
516c516
<     'status' => 'inactive',
---
>     'status' => 'active',
518c518
<     'menu_parent' => 'website'
---
>     'menu_parent' => 'horde'

Patch /var/www/html/config/prefs.php with the following:

299c299
<     'value' => 'bluewhite',
---
>     'value' => 'azur',
306a307,313
> //$_prefs['categories'] = array(
> //    'value' => '',
> //    'locked' => false,
> //    'shared' => true,
> //    'type' => 'implicit'
> //);
>
308c315
<     'value' => '',
---
>     'value' => 'Appointment - In Office|Appointment - Out of Office|Company Event|Personal Event|Personal Task|Task - Administrative Group|Task - IT Group|Task - Sales Group|Training|Vacation Schedule|Vendor meeting|Holiday',
314a322,328
> //$_prefs['category_colors'] = array(
> //    'value' => '',
> //    'locked' => false,
> //    'shared' => true,
> //    'type' => 'implicit'
> //);
>
316c330
<     'value' => '',
---
>     'value' => '1:Appointment - Out of Office|2:Company Event|3:Holiday|4:Personal Event|5:Personal Task|6:Task - Administrative Group|7:Task - IT Group|8:Task - Sales Group|9:Training|10:Vacation Schedule|11:Vendor meeting|12:_default_|13:_unfiled_|14:1|15:2|16:3|17:4|18:5|19:6|20:7|21:8|22:9|23:10|24:11|25:12|26:13|27:14|28:15|29:16|30:17|31:18|32:19|33:20|34:21|35:22|36:23|37:24|38:25|39:26|40:27|41:28|42:29|43:30|44:31|45:32|46:33|47:34|48:35|49:36|50:37|51:38|52:39|53:40|54:41|55:42|56:43|57:44|58:45|59:46|60:47|61:48|62:49|63:50|64:51|65:52|66:53|67:54|68:55|69:56|70:57|71:58|72:59|73:60|74:61|75:62|76:63|77:64|78:65|79:66|80:67|81:68|82:69|83:70|84:71|85:72|86:73|87:74|88:75|89:76|90:77|91:78|92:79|93:80|94:81|95:82|96:83|97:84|98:85|99:86|100:87|101:88|102:89|103:90|104:91|105:92|106:93|107:94|108:95|109:96|110:97|111:98|112:99|113:100|114:101|115:102|116:103|117:104|118:105|119:106|120:107|121:108|122:109|123:110|124:111|125:112|126:113|127:114|128:115|129:116|130:117|131:118|132:119|133:120|134:121|135:122|136:123|137:124|138:125|139:126|140:127|141:128|142:129|143:130|144:131|145:132|146:133|147:134|148:135|149:136|150:137|151:138|152:139|153:140|154:141|155:142|156:143|157:144|158:145|159:146|160:147|161:148|162:149|163:150|164:151|165:152|166:153|167:154|168:155|169:156|170:157|171:158|172:159|173:160|174:161|175:162|176:163|177:164|178:165|179:166|180:167|181:168|182:169|183:170|184:171|185:172|186:173|187:174|188:175|189:176|190:177|191:178|192:179|193:180|194:181|195:194|208:|Appointment - In Office:#0000aa|Appointment - Out of Office:#0000ff|Company Event:#1d1dff|Holiday:#7d7d7d|Personal Event:#7dff7d|Personal Task:#9dff9d|Task - Administrative Group:#ff5f5f|Task - IT Group:#ff7f7f|Task - Sales Group:#ff9f9f|Training:#adadff|Vacation Schedule:#9d9d9d|Vendor meeting:#7d7dff|_default_:#FFFFFF|_unfiled_:#DDDDDD',
431c445
<     'locked' => false,
---
>     'locked' => true,
457c471,472
<     'value' => 'a:0:{}',
---
> //    'value' => 'a:2:{i:0;a:2:{i:0;a:4:{s:3:"app";s:9:"kronolith";s:6:"height";i:1;s:5:"width";i:1;s:6:"params";a:2:{s:4:"type";s:7:"summary";s:6:"params";a:1:{s:8:"calendar";s:5:"__all";}}}i:1;a:4:{s:3:"app";s:3:"nag";s:6:"height";i:1;s:5:"width";i:1;s:6:"params";a:2:{s:4:"type";s:7:"summary";s:6:"params";a:8:{s:8:"show_pri";s:2:"on";s:12:"show_actions";s:2:"on";s:8:"show_due";s:2:"on";s:13:"show_tasklist";s:2:"on";s:11:"show_alarms";s:2:"on";s:13:"show_category";s:2:"on";s:12:"show_overdue";s:2:"on";s:14:"show_completed";s:2:"on";}}}}i:1;a:2:{i:0;a:4:{s:3:"app";s:5:"mnemo";s:6:"height";i:1;s:5:"width";i:1;s:6:"params";a:2:{s:4:"type";s:7:"summary";s:6:"params";a:2:{s:12:"show_actions";s:2:"on";s:12:"show_notepad";s:2:"on";}}}i:1;a:4:{s:3:"app";s:5:"turba";s:6:"height";i:1;s:5:"width";i:1;s:6:"params";a:2:{s:4:"type";s:10:"minisearch";s:6:"params";a:0:{}}}}}',
>     'value' => 'a:2:{i:0;a:4:{i:0;a:4:{s:3:"app";s:9:"kronolith";s:6:"height";i:1;s:5:"width";i:3;s:6:"params";a:2:{s:4:"type";s:5:"month";s:6:"params";a:1:{s:8:"calendar";s:5:"__all";}}}i:1;s:7:"covered";i:2;s:7:"covered";i:3;a:4:{s:3:"app";s:3:"nag";s:6:"height";i:1;s:5:"width";i:1;s:6:"params";a:2:{s:4:"type";s:7:"summary";s:6:"params";a:10:{s:11:"block_title";s:5:"Tasks";s:8:"show_pri";s:2:"on";s:12:"show_actions";s:2:"on";s:8:"show_due";s:2:"on";s:13:"show_tasklist";s:2:"on";s:11:"show_alarms";s:2:"on";s:13:"show_category";s:2:"on";s:12:"show_overdue";s:2:"on";s:14:"show_completed";s:2:"on";s:14:"show_tasklists";a:1:{i:0;s:4:"root";}}}}}i:1;a:4:{i:0;a:4:{s:3:"app";s:6:"wicked";s:6:"height";i:1;s:5:"width";i:3;s:6:"params";a:2:{s:4:"type";s:4:"page";s:6:"params";a:1:{s:4:"page";s:8:"WikiHome";}}}i:1;s:7:"covered";i:2;s:7:"covered";i:3;a:4:{s:3:"app";s:5:"mnemo";s:6:"height";i:1;s:5:"width";i:1;s:6:"params";a:2:{s:4:"type";s:7:"summary";s:6:"params";a:2:{s:12:"show_actions";s:2:"on";s:12:"show_notepad";s:2:"on";}}}}}',
483c498
<     'value' => true,
---
>     'value' => false,


Regards,

Jon



More information about the Phpwm mailing list