[kronolith] Username/e-mail mapping

[Claude Tompers]

On Thu, 20 Mar 2014 09:54:18 -0400
"Pete Billson" <Pete at Turtle.com> wrote:

> Hello,
> 
>  
> 
> I have a question concerning invitations when all affected calendars
> "belong" to the Horde system.
> 
>  
> 
> In fact, when a colleague invites me to an event in kronolith, he
> enters my email-address in the attendees field. Free/Busy information
> does not work. I suppose the reason is that the fb.php page needs the
> username ?
> 
>  
> 
> Is there a way that Horde can map those internally ?
> 
>  
> 
>  
> 
> Also, when the invitation is sent, I get an email, but I would somehow
> expect a non-acknowledged event in my calendar as well, which there
> isn't. Is there a way to fix this as well ?
> 
>  
> 
> kind regards,
> 
> Claude
> 
>  
> 
> --
> 
> Claude Tompers
> 
> Ingénieur réseau et système
> 
> Fondation RESTENA - Réseau Téléinformatique de l'Education Nationale
> et de la Recherche 6, rue Richard Coudenhove-Kalergi
> 
> L-1359 Luxembourg
> 
>  
> 
> Tel: +352 424409 1
> 
> Fax: +352 422473
> 
>  
> 
> Claude,
> 
>    I don't know if this is the correct way to do things but I created
> a little perl script to run through all the horde address books and
> add a free/busy URL to anybody that has an email address on my horde
> server. All my mailboxes are under /var/vmail so you will probably
> need to modify the @emails= line to meet your needs.
> 
>  
> 
> #!/usr/bin/perl
> 
> use DBI;
> 
> # Script created 2013-09-25 to update the Global Address Book Free
> Busy URLs
> 
>  
> 
> # Connect to the database
> 
> my $dbh = DBI->connect('DBI:mysql:horde',"horde","{YOUR DB
> PASSWORD}");
> 
>  
> 
> # Get all the user's currently on the system @emails =
> `cd /var/vmail;ls -1d *;cd -`;
> 
>  
> 
> foreach $a (0 ..$#emails){
> 
>   chomp($emails[$a]);
> 
>   ($user) = $emails[$a] =~ /(.*)\@{YOUR DOMAIN}/;
> 
>   $sth = $dbh->prepare("update turba_objects set object_freebusyurl=?
> 
>                         where object_email=?");
> 
>   $FreeBusy = "http://{YOUR HORDE SERVER}/kronolith/fb.php?u=$user
> <http://%7bYOUR%20HORDE%20SERVER%7d/kronolith/fb.php?u=$user> ";
> 
>   $sth->execute($FreeBusy,$emails[$a]);
> 
>   $sth->finish;
> 
> } # end foreach $a
> 
>  
> 
> # Disconnect from the database
> 
> $dbh->disconnect;
> 
> exit(0);
> 
>  
> 
> Pete Billson
> 

Hi Pete,

Thanks for your input, I did not even think about the address books in
this context. I'll have a look at that. Thanks for the script.

regards,
Claude


-- 
Claude Tompers
Ingénieur réseau et système
Fondation RESTENA - Réseau Téléinformatique de l'Education Nationale et
de la Recherche 6, rue Richard Coudenhove-Kalergi
L-1359 Luxembourg

Tel: +352 424409 1
Fax: +352 422473
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://lists.horde.org/archives/kronolith/attachments/20140320/36e1c9c6/attachment.bin>