[Phpwm] Horde

Michael Sheldon mike at mikeasoft.com
Mon Feb 12 11:33:03 GMT 2007


On Mon, Feb 12, 2007 at 10:27:59AM +0000, Jon Spriggs wrote:
> On 2/12/07, Michael Sheldon <mike at mikeasoft.com> wrote:
> > Ah, I've seen your recent mailings. What I don't understand (and
> >seemingly neither does anyone else on the Horde list) is why you
> >can't use Kronolith's existing iCal facility for this. Outlook
> >supports the iCal protocol so you can open Kronolith calendars in
> >Outlook without any trouble.
> 
> LOL, and so it goes around again :) After the initial rejection of the
> enhancement bug I submitted, where Jan told me about the iCal
> functions, I tried to use iCal, and while it seems like it will do a
> one-off import of calendar items, it doesn't appear to dynamically
> update the calendar, whereas the Sharepoint/Outlook SOAP calls make it
> appear like you have a live tie-in to the calendar, so when you change
> the Sharepoint side, the Outlook updates automatically (within a
> couple of seconds IIRC)... but I can't see how you do that with
> Kronolith/Outlook.

Ah, I see what you mean now.

> > I don't have a whole lot of experience with that side of things
> >however, as here we use Kolab (basically all Calendar entries,
> >tasks, notes, etc. are just emails containing XML which then get
> >processed by Horde's Kolab driver, or Kontact's Kolab plugin, or
> >the KONSEC Konnektor for Outlook depending on the client).
> 
> So, what is Kolab? From what I've seen, is it like MS Exchange,
> without a users web frontend?

 I think so, I've never used MS Exchange myself, but as far as I can
tell the functionality is similar. And whilst there's no builtin 
webfrontend, Horde can be used reasonably well for this purpose.

 Cheers,
  Mike.

> >On Mon, Feb 12, 2007 at 09:20:19AM +0000, Jon Spriggs wrote:
> >> Hi there Michael,
> >>
> >> Thanks for the offer! I've been struggling a little on the Kronolith
> >> d-list last week because I want to expose a series of SOAP calls in
> >> the same way the Sharepoint does, because sharepoint allows you to
> >> open the calendar in Oulook, and have it dynamically update the screen
> >> - which is a sticking point on adoption for my team, who are fairly
> >> ambivalent about the solution, but prefer sharepoint for the sole fact
> >> that you can open the calendar in Outlook ... grrr...
> >>
> >> Anyway, it's good to know someone else is using it :)
> >>
> >> I might drop you a line some time in the future...
> >>
> >> Regards,
> >>
> >> Jon
> >>
> >> On 2/10/07, Michael Sheldon <mike at mikeasoft.com> wrote:
> >> >Hi Jon,
> >> >
> >> > I work with Horde a lot at work, we're using it in a lot of groupware
> >> >installations for various parts of the German government, along with the
> >> >Kolab groupware system. Horde itself is pretty nice, the Kolab driver
> >> >still needs some work though (we had to make some pretty big
> >> >modifications to get it working with reasonable performance).
> >> >
> >> > If you have any Horde questions feel free to ask me, I'm pretty familiar
> >> >with the codebase now.
> >> >
> >> > Cheers,
> >> >  Mike.
> >> >
> >> >On Sat, Feb 10, 2007 at 10:21:44AM +0000, Jon Spriggs wrote:
> >> >> 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:1
> >> >>
> >> 
> >>21|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
> >> >>
> >> >> _______________________________________________
> >> >> Phpwm mailing list
> >> >> Phpwm at mailman.lug.org.uk
> >> >> https://mailman.lug.org.uk/mailman/listinfo/phpwm
> >> >>
> >> >
> >> >--
> >> >Michael Sheldon
> >> >http://www.mikeasoft.com
> >> >
> >> >_______________________________________________
> >> >Phpwm mailing list
> >> >Phpwm at mailman.lug.org.uk
> >> >https://mailman.lug.org.uk/mailman/listinfo/phpwm
> >> >
> >>
> >> _______________________________________________
> >> Phpwm mailing list
> >> Phpwm at mailman.lug.org.uk
> >> https://mailman.lug.org.uk/mailman/listinfo/phpwm
> >>
> >
> >--
> >Michael Sheldon
> >http://www.mikeasoft.com
> >
> >_______________________________________________
> >Phpwm mailing list
> >Phpwm at mailman.lug.org.uk
> >https://mailman.lug.org.uk/mailman/listinfo/phpwm
> >
> 
> _______________________________________________
> Phpwm mailing list
> Phpwm at mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/phpwm
> 

-- 
Michael Sheldon
http://www.mikeasoft.com



More information about the Phpwm mailing list