[Phpwm] Horde

Jon Spriggs jon at spriggs.org.uk
Mon Feb 12 10:28:12 GMT 2007 

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.

I felt like I was going around in circles explaining it on the list,
but maybe it was just me!

To see what I mean, If you have access to MS Outlook, I've got a
"demo" sharepoint server up-and-running at
http://1319.freesharepoint.com
Username: PUBLIC27\xujepomitiqoweho
Password: fb?NA6*1

At the home page, click on Events and then "Link to Calendar" which
offers a URI which MSOutlook accepts. This then tells outlook where to
send the SOAP requests for the calendar updates.

Don't worry about experimenting with the sharepoint - I set it up
specifically to demo to people on the Kronolith list, and obviously,
if there's anything I can do to help, let me know.

>  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?

Regards,

Jon

>  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
>

More information about the Phpwm mailing list