[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