[horde] horde Digest, Vol 4027, Issue 1

murali at itechservices.in murali at itechservices.in
Wed Jun 25 08:16:48 UTC 2014


On 2014-06-25 13:00, horde-request at lists.horde.org wrote:
> Send horde mailing list submissions to
> 	horde at lists.horde.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://lists.horde.org/mailman/listinfo/horde
> or, via email, send a message with subject or body 'help' to
> 	horde-request at lists.horde.org
> 
> You can reach the person managing the list at
> 	horde-owner at lists.horde.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of horde digest..."
> 
> 
> Today's Topics:
> 
>    1. Re: horde-remove-user-data leaves data of user in various
>       tables (Steffen)
>    2. Re: [SOLVED] clean DB from unused users (old users)
>       (Stefan Joh?nntgen)
>    3. Logging into Horde from another website. (Ernie Dunbar)
>    4. Re: Logging into Horde from another website. (Michael M Slusarz)
>    5. Re: Handler for action "dynamicinit" does not exist.
>       (Michael M Slusarz)
>    6. Help for Activesync (murali at itechservices.in)
>    7. Re: Help for Activesync (Ruud Baart)
>    8. Re: Help for Activesync (Bastian Klein)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Tue, 24 Jun 2014 16:37:26 +0200 (CEST)
> From: Steffen <skhorde at smail.inf.fh-bonn-rhein-sieg.de>
> To: horde at lists.horde.org
> Cc: horde at lists.horde.org
> Subject: Re: [horde] horde-remove-user-data leaves data of user in
> 	various tables
> Message-ID:
> 	<alpine.DEB.2.02.1406241205330.5396 at pc-2m63z.inf.fh-bonn-rhein-sieg.de.>
> 
> Content-Type: TEXT/PLAIN; format=flowed; charset=US-ASCII
> 
> On Fri, 20 Jun 2014, Michael J Rubinsky wrote:
>> Quoting Steffen <skhorde at smail.inf.fh-bonn-rhein-sieg.de>:
>> 
>>> I'm using 2014-06-20's stable PEAR packages of Horde 5.
>>> 
>>> If I remove the user data with horde-remove-user-data, the user data 
>>> in the
>>> rampage tables are left untouched and there are entries imp:<user>: 
>>> in
>>> horde_histories still.
>>> 
>>> a) Would it make sense to call history->removeByParent("imp:<user>") 
>>> in
>>> removeUserData() of imp?
>> 
>> We don't remove history data for any other application. I would say we
>> shouldn't remove it for IMP either. For other apps, it's possible the 
>> data
>> could still be used for synchronization, for IMP even though this is 
>> not the
>> case, I could see it being used as some type of audit trail.
> 
> OK, understood.
> I'm thinking about the data in this table for two reasons:
> 1a) For privacy purpose I'm entitled to give the data a "end of live",
> once an user left the organisation and the account is deleted.
> 1b) The History grows, see message "horde_histories" by Pete from Feb 
> 2014
> http://thread.gmane.org/gmane.comp.horde.user/34294/focus=34297, which 
> may
> become a performance problem.
> 
> 2) The data is required for sync'ing of (in the future) shared 
> ressources.
> 
> I'll think about this issue again, probably once the remote access to
> shared ressource works. :-)
> 
>>> d) horde_activesync_cache, horde_activesync_device_users
>>> still contains entries with cache_user or device_user = <user>, the 
>>> device
>>> referenced here, is in horde_activesync_device and 
>>> horde_activesync_state,
>>> too.
> 
>>> That might probably happen because of:
>>> http://bugs.horde.org/ticket/13277 -> orphan devices not removed
>>> http://bugs.horde.org/ticket/13278 -> function call at wrong place
>> 
>> Correct.
> 
> Your changes work for me. Thanks.
> 
>>> e) the same for: horde_dav_collections
>>> calendars a.s.o. deleted by the script are still listed
>>> 
>>> Neither deleteInternalCollectionId() nor deleteExternalCollectionId() 
>>> from
>>> /usr/share/php/Horde/Dav/Storage/Base.php are called anywhere in 
>>> Horde it
>>> seems. So cleanup is not implemented, yet?
>>> 
>>> f) imp_sentmail
>>> has entries with sentmail_who = <user>
>> 
>> This table is self-cleaning, IIRC.
> 
> Ah, there is ./imp/lib/LoginTasks/SystemTask/GarbageCollection.php, 
> which
> triggers the cleaning of the table weekly, when an admin logs into IMP. 
> I
> didn't noticed this, yet.
> 
> --
> Steffen
> 
> 
> ------------------------------
> 
> Message: 2
> Date: Tue, 24 Jun 2014 16:39:04 +0200
> From: Stefan Joh?nntgen <Stefan at NicoleJo.de>
> To: horde at lists.horde.org
> Subject: Re: [horde] [SOLVED] clean DB from unused users (old users)
> Message-ID: <53A98D88.4050201 at NicoleJo.de>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> Many thanks Steffen! Solved! I understand, yes - my Horde is up-to-date
> and its installed with pear. And the script is in /usr/bin.
> Many thanks!!!
> 
> 
> Am 16.06.2014 um 08:39 schrieb Steffen
> <skhorde at smail.inf.fh-bonn-rhein-sieg.de>:
> 
>> On Sat, 14 Jun 2014, Stefan Joh?nntgen wrote:
>> 
>>> Thanks, but where do I put the xargs < users-to-remove
>>> horde-remove-user-data --force --continue
>> 
>>> And there is no file horde/bin/horde-remove-user-data to edit
>> 
>> What version of Horde do you use? PEAR installed the script to 
>> /usr/bin/horde-remove-user-data on my system.
>> 
>> xargs < users-to-remove horde-remove-user-data --force --continue
>> is actually a command, xargs < users-to-remove reads the file 
>> users-to-remove and calls the command horde-remove-user-data --force 
>> --continue for any token find within the file, see
>> man xargs
>> xargs bypasses the problem, if the command line gets too long.
>> 
>>> 
>>> Zitat von Steffen <skhorde at smail.inf.fh-bonn-rhein-sieg.de>:
>>> 
>>>> Stefan Joh?nntgen wrote:> Hi,
>>>>> I have the authentication with the existing IMAP e-mail accounts.
>>>>> Is there a script that I can delete a user from the horde database?
>>>>> Because on the Horde frontend I can not manage the users. But in 
>>>>> the
>>>>> database are users (horde_prefs, turba_sharesng etc)
>>>>> I want to clean up the database.
>>>>> Many Thanks to Horde Team!
>>>> see horde-remove-user-data in conjunction with this patch:
>>>> http://bugs.horde.org/ticket/12997
>>>> I did it so:
>>>> 1. generate user list in Horde:
>>>> for me, I query the Postgres SQL DB and dump into a file from psql
>>>> SELECT DISTINCT pref_uid FROM horde_prefs \g /tmp/users
>>>> 2. check above list, which users are gone with your user database
>>>> 3. xargs < users-to-remove horde-remove-user-data --force --continue
>>>> --Steffen
>> 
>> --
>> Steffen--
>> Horde mailing list
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
> 
> 
> 
> ------------------------------
> 
> Message: 3
> Date: Tue, 24 Jun 2014 12:01:57 -0700
> From: Ernie Dunbar <maillist at lightspeed.ca>
> To: Horde Mailing List <horde at lists.horde.org>
> Subject: [horde] Logging into Horde from another website.
> Message-ID: <cde748396430e6f5aa7dd8ffaeecf480 at pop.lightspeed.ca>
> Content-Type: text/plain; charset=UTF-8
> 
> 
> 
> Hi all.
> 
> Way back in Horde 3.3.6, it used to be possible to log into Horde
> through a web form at another location, just using some embedded HTML
> form values, ie:
> 
>> <form action='https://webmail.lightspeed.ca/horde/imp/redirect.php'>
>> 
>> <input type=text size=25 name='imapuser' id='imapuser'>
>> 
>> <input type=password size=25 name='pass' id='pass'>
>> 
>> </form>
> 
> However, this form no longer appears to work in Horde 5.1.6, and just
> puts the user at the Horde login prompt (again, from their point of
> view). Since users are used to logging into our webmail through our 
> home
> page, it's pretty important that upgrading to the latest version of
> Horde be as seamless as it used to be. What do we need to do to make
> this work?
> 
> 
> ------------------------------
> 
> Message: 4
> Date: Tue, 24 Jun 2014 13:33:51 -0600
> From: Michael M Slusarz <slusarz at horde.org>
> To: horde at lists.horde.org
> Subject: Re: [horde] Logging into Horde from another website.
> Message-ID:
> 	<20140624133351.Horde.LbYTAohwVyUHCprM5to7hg2 at bigworm.curecanti.org>
> Content-Type: text/plain; charset=UTF-8; format=flowed; DelSp=Yes
> 
> Quoting Ernie Dunbar <maillist at lightspeed.ca>:
> 
>> Hi all.
>> 
>> Way back in Horde 3.3.6, it used to be possible to log into Horde
>> through a web form at another location, just using some embedded HTML
>> form values, ie:
>> 
>>> <form action='https://webmail.lightspeed.ca/horde/imp/redirect.php'>
>>> 
>>> <input type=text size=25 name='imapuser' id='imapuser'>
>>> 
>>> <input type=password size=25 name='pass' id='pass'>
>>> 
>>> </form>
>> 
>> However, this form no longer appears to work in Horde 5.1.6, and just
>> puts the user at the Horde login prompt (again, from their point of
>> view). Since users are used to logging into our webmail through our 
>> home
>> page, it's pretty important that upgrading to the latest version of
>> Horde be as seamless as it used to be. What do we need to do to make
>> this work?
> 
> All logins are handled through a single Horde endpoint now 
> (horde/login.php).
> 
> The list of URL parameters for the base page is located at the top of
> that script.  Specific applications (like IMP) may require additional
> parameters -- see the application's
> [App]_Application#authLoginParams() for these values.
> 
> michael
> 
> ___________________________________
> Michael Slusarz [slusarz at horde.org]
> 
> 
> 
> ------------------------------
> 
> Message: 5
> Date: Wed, 25 Jun 2014 00:37:01 -0600
> From: Michael M Slusarz <slusarz at horde.org>
> To: horde at lists.horde.org
> Subject: Re: [horde] Handler for action "dynamicinit" does not exist.
> Message-ID:
> 	<20140625003701.Horde.ozhzUiYEhz45uwOnN9oA8g9 at bigworm.curecanti.org>
> Content-Type: text/plain; charset=UTF-8; format=flowed; DelSp=Yes
> 
> Quoting Ernie Dunbar <maillist at lightspeed.ca>:
> 
>> Background: I have the latest Horde Webmail suite running on a Debian
>> web server that also happens to host a few hundred other domains. I 
>> had
>> installed a "dev" version of Horde with the intention of upgrading our
>> old Horde installation, because I wanted to make sure that the
>> transition was a smooth one. I had Horde and Imp running smoothly up 
>> to
>> a point, until Imp started to die with the Javascript popup message
>> "Handler for action "dynamicinit" does not exist." Oddly enough, Imp
>> actually still works - on the first login of the day. If you log out 
>> and
>> try to log back in, then you start getting this message again. Until 
>> the
>> next morning, or on another computer.
>> 
>> In trying to troubleshoot this problem, I searched all the code in 
>> Horde
>> for "dynamicInit" and found only one place where it was used: in the
>> file horde/imp/js/dimpbase.js
>> 
>> Here's the code:
>> 
>>  ajax: function(params) {
>>  /* Store the requestid locally, so we don't need to
>>  * round-trip to the server. We'll re-add it later. */
>>  var action, r_id = params.unset('requestid');
>>  if (this.init) {
>>  action = 'viewPort';
>>  } else {
>>  // action = 'dynamicInit';
>>  action = 'viewPort';
>>  if (this.uid) {
>>  params.set('msgload', this.uid);
>>  }
>>  this.init = true;
>>  }
>> 
>> You can see here I also changed the line 'action = dynamicInit' to
>> 'action = viewPort'. Doing this merely changes the error message from
>> "Handler for action 'dynamicInit' does not exist" to "Handler for 
>> action
>> 'viewPort' does not exist".
>> 
>> This is a Javascript file that is supposed to be running in the
>> *browser*, so I'm extra baffled as to why this error occurs, nevermind
>> the bizarre behaviour with some crazy 24 hour timeout.
> 
> This has nothing to do with the browser.  viewPort and dynamicInit are
> the names of actions performed on the server.  The error message you
> are seeing are notifications sent from the *server*.  (You should see
> the same error message in your server logs if the level is high 
> enough).
> 
> Your problem seems to be that you are trying to access these actions
> without a valid session.  In Horde 5.1, session timeout AJAX actions
> worked inconsistently.  This has been fixed in Horde 5.2.
> 
> michael
> 
> ___________________________________
> Michael Slusarz [slusarz at horde.org]
> 
> 
> 
> ------------------------------
> 
> Message: 6
> Date: Wed, 25 Jun 2014 12:28:07 +0530
> From: murali at itechservices.in
> To: horde at lists.horde.org
> Subject: [horde] Help for Activesync
> Message-ID: <69af12b959742eac84c0ecd5272b4515 at itechservices.in>
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> 
> 
> Hi
> 
> I am new to horde and installed horde webmail groupware 5.1.6 in wheezy
> with postfix and dovecot. Everything works fine as far as mail
> transactions are concerned .I have enabled activesync option and when i
> try to connect the outlook to horde with option of Microsoft Exchange  
> i
> get the error message saying there is no exchange server running. Can
> anyone help me in configuring horde to sync the mails to outlook? Is
> Horde Activsync 100% replacement for MS Exchange server? If yes kindly
> provide proper document to make it work.
> 
> 
> Thanks in advance
> 
> Murali
> 
> 
> ------------------------------
> 
> Message: 7
> Date: Wed, 25 Jun 2014 09:19:56 +0200
> From: Ruud Baart <r.j.baart at prompt.nl>
> To: murali at itechservices.in, horde at lists.horde.org
> Subject: Re: [horde] Help for Activesync
> Message-ID: <53AA781C.1050908 at prompt.nl>
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> have you enabled https? It is required for Outlook.
> 
> And take a look at  http://wiki.horde.org/ActiveSync
> 
> murali at itechservices.in schreef op 25-6-2014 8:58:
>> 
>> 
>> Hi
>> 
>> I am new to horde and installed horde webmail groupware 5.1.6 in
>> wheezy with postfix and dovecot. Everything works fine as far as mail
>> transactions are concerned .I have enabled activesync option and when
>> i try to connect the outlook to horde with option of Microsoft
>> Exchange  i get the error message saying there is no exchange server
>> running. Can anyone help me in configuring horde to sync the mails to
>> outlook? Is Horde Activsync 100% replacement for MS Exchange server?
>> If yes kindly provide proper document to make it work.
>> 
>> 
>> Thanks in advance
>> 
>> Murali
> 
> --
> 
> Ruud Baart
> 
> 
> 
> ------------------------------
> 
> Message: 8
> Date: Wed, 25 Jun 2014 07:30:48 +0000
> From: Bastian Klein <b.klein at bkims.de>
> To: horde at lists.horde.org
> Subject: Re: [horde] Help for Activesync
> Message-ID:
> 	<20140625073048.Horde.-vSbBFbzuoWOqBILAf0UJQ3 at mail.bkims.net>
> Content-Type: text/plain; charset=UTF-8; format=flowed; DelSp=Yes
> 
>   Zitat von murali at itechservices.in:
> 
>> Hi
>> 
>> I am new to horde and installed horde webmail groupware 5.1.6 in 
>> wheezy
>> with postfix and dovecot. Everything works fine as far as mail
>> transactions are concerned .I have enabled activesync option and when 
>> i
>> try to connect the outlook to horde with option of Microsoft Exchange? 
>> i
>> get the error message saying there is no exchange server running. Can
>> anyone help me in configuring horde to sync the mails to outlook? Is
>> Horde Activsync 100% replacement for MS Exchange server? If yes kindly
>> provide proper document to make it work.
> 
> No! You have to use Outlook 2013 wich is the first version to support
> Exchange Active Sync Protocoll.
> Please choose manual and then "Outlook.com or Exchange Active Sync" as
> Option. Not Exchange.
> 
> Sounds little bit confusing, but Exchange ist not Exchange Active Sync. 
> ;-)
> 
> Regards,
> Bastian
> 
> Please correct me if i am wrong with this ;-)
> 
>> Thanks in advance
>> 
>> Murali
>> --
>> Horde mailing list
>> Frequently Asked Questions: http://horde.org/faq/To unsubscribe, mail:
>> horde-unsubscribe at lists.horde.org
> bk:ims
> 
> Phone: +49 (5344) 2590066
> Mobil: +49 (179) 7425446
> Mail: b.klein at bkims.de
> 
> 
> ------------------------------

Thank you Bastian

I will try with outlook 2013 and would share the outcome.

Regards
Murali


More information about the horde mailing list