From jan at horde.org  Mon Aug 24 07:41:05 2009
From: jan at horde.org (Jan Schneider)
Date: Mon, 24 Aug 2009 09:41:05 +0200
Subject: [horde] Problem with fresh install of Horde Groupware Webmail
 Edition 1.2.3...
In-Reply-To: <20090823233118.2b328afa@pennywise.havleik.no>
References: <20090823233118.2b328afa@pennywise.havleik.no>
Message-ID: <20090824094105.398474qkvdw0rboc@neo.wg.de>

Zitat von Bj?rn T Johansen <btj at havleik.no>:

> I have just installed one on a different server but now when trying  
> to install on my own server (Gentoo box) I just get an error when  
> logging on
> telling me "There has been no contact with the remote server for  
> several minutes........"
> The horde.log says I have successfully logged in to my imap server  
> but the php.log shows these error messages...:
>
> [23-Aug-2009 23:27:25] PHP Warning:  Cannot modify header  
> information - headers already sent in Unknown on line 0
> [23-Aug-2009 23:27:25] PHP Warning:  Cannot modify header  
> information - headers already sent in Unknown on line 0
> [23-Aug-2009 23:27:25] PHP Warning:  require_once() [<a  
> href='function.require-once'>function.require-once</a>]: Couldn't  
> resolve host name
> in /mnt/data/www/havleik/horde/lib/Horde/Share/sql.php on line 683  
> [23-Aug-2009 23:27:25] PHP Warning:  require_once(Horde/Group.php) [<a
> href='function.require-once'>function.require-once</a>]: failed to  
> open stream: operation failed
> in /mnt/data/www/havleik/horde/lib/Horde/Share/sql.php on line 683  
> [23-Aug-2009 23:27:25] PHP Fatal error:  require_once() [<a
> href='function.require'>function.require</a>]: Failed opening required
> 'Horde/Group.php'  
> (include_path='/mnt/data/www/havleik/horde/lib:/mnt/data/www/havleik/horde/lib/../pear')
> in /mnt/data/www/havleik/horde/lib/Horde/Share/sql.php on line 683  
> [23-Aug-2009 23:27:26] PHP Warning:  require_once() [<a
> href='function.require-once'>function.require-once</a>]: Couldn't  
> resolve host name in  
> /mnt/data/www/havleik/horde/lib/Horde/Share/sql.php on line
> 683 [23-Aug-2009 23:27:26] PHP Warning:   
> require_once(Horde/Group.php) [<a  
> href='function.require-once'>function.require-once</a>]: failed to  
> open
> stream: operation failed in  
> /mnt/data/www/havleik/horde/lib/Horde/Share/sql.php on line 683  
> [23-Aug-2009 23:27:26] PHP Fatal error:  require_once()
> [<a href='function.require'>function.require</a>]: Failed opening required
> 'Horde/Group.php'  
> (include_path='/mnt/data/www/havleik/horde/lib:/mnt/data/www/havleik/horde/lib/../pear')
> in /mnt/data/www/havleik/horde/lib/Horde/Share/sql.php on line 683

This looks like a badly broken PHP installation. To me it seems like  
it's trying to include the required file from a URL, which is of  
course wrong.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/


From lst_hoe02 at kwsoft.de  Mon Aug 24 07:43:30 2009
From: lst_hoe02 at kwsoft.de (lst_hoe02 at kwsoft.de)
Date: Mon, 24 Aug 2009 09:43:30 +0200
Subject: [horde] Problem with fresh install of Horde Groupware Webmail
 Edition 1.2.3...
In-Reply-To: <20090823233118.2b328afa@pennywise.havleik.no>
References: <20090823233118.2b328afa@pennywise.havleik.no>
Message-ID: <20090824094330.6521653gro4upo4c@webmail.kwsoft.de>

Zitat von Bj?rn T Johansen <btj at havleik.no>:

> I have just installed one on a different server but now when trying  
> to install on my own server (Gentoo box) I just get an error when  
> logging on
> telling me "There has been no contact with the remote server for  
> several minutes........"
> The horde.log says I have successfully logged in to my imap server  
> but the php.log shows these error messages...:
>
> [23-Aug-2009 23:27:25] PHP Warning:  Cannot modify header  
> information - headers already sent in Unknown on line 0
> [23-Aug-2009 23:27:25] PHP Warning:  Cannot modify header  
> information - headers already sent in Unknown on line 0
> [23-Aug-2009 23:27:25] PHP Warning:  require_once() [<a  
> href='function.require-once'>function.require-once</a>]: Couldn't  
> resolve host name
> in /mnt/data/www/havleik/horde/lib/Horde/Share/sql.php on line 683  
> [23-Aug-2009 23:27:25] PHP Warning:  require_once(Horde/Group.php) [<a
> href='function.require-once'>function.require-once</a>]: failed to  
> open stream: operation failed

Seams like you have configured a SQL Server your machine cannot  
resolve. Double-check your configs for typos and test the name  
resolution on the machine.

Regards

Andreas


From lameventanas at yahoo.com  Mon Aug 24 09:05:11 2009
From: lameventanas at yahoo.com (Frito Lay)
Date: Mon, 24 Aug 2009 02:05:11 -0700 (PDT)
Subject: [horde] Infinite loop in login
Message-ID: <241439.64604.qm@web111909.mail.gq1.yahoo.com>

Hello list,

I'm trying to install horde 3.3.4 in a linux machine, distro is suse 11.

Apache and php configuration is the standard one, there are no strange redirects, rewrites, etc configured.
I have followed each step closely, there are no missing requirements

Whenever I try to log in for the first time, I get an infinite loop:
index.php -> login.php -> index.php ...

I think the problem is index.php thinks I'm not authenticated, while login.php does.

If I comment this section in login.php:

/* Try transparent authentication. */
if (Auth::isAuthenticated()) {
    require HORDE_BASE . '/index.php';
    exit;
}

The loop breaks, but of course the application doesn't work.

I have read similar reports by people installing horde in the webroot.
For me it doesn't make any difference, I get the same behavior by using webroot='', or webroot='horde'.

I have installed previous versions of horde in the past, even written modules using the framework, and never came across this one before.

Any ideas?



      

From michael.groene at zew.uni-hannover.de  Mon Aug 24 11:12:00 2009
From: michael.groene at zew.uni-hannover.de (=?ISO-8859-15?Q?Michael_Gr=F6ne?=)
Date: Mon, 24 Aug 2009 13:12:00 +0200
Subject: [horde] Add own Javascript-code to Newmail-Notification
Message-ID: <4A927580.7070402@zew.uni-hannover.de>

Hello there,

I'm trying to setup Horde running as WebApp in Prism.
For a short time it's possible to display Notification-Popups in the 
Windows-Systray via Prism.

To do so, I need to add simple JavaScript code, appearing anywhere on 
the Horde-Site, when a new eMail is received.

I'm was scanning through the files, asking google, but I did not find 
out, how to do so.

Can anyone give me a hint?

Thanks a lot


For anyone whos interested in the Javascript:
<script type="text/javascript">
	window.platform.showNotification(
	'title',
	'description',
	null (or uri of an icon)
	);
</script>

From btj at havleik.no  Mon Aug 24 12:55:27 2009
From: btj at havleik.no (=?ISO-8859-1?Q?Bj=F8rn?= T Johansen)
Date: Mon, 24 Aug 2009 14:55:27 +0200
Subject: [horde] Problem with fresh install of Horde Groupware Webmail
 Edition 1.2.3...
In-Reply-To: <20090824094330.6521653gro4upo4c@webmail.kwsoft.de>
References: <20090823233118.2b328afa@pennywise.havleik.no>
	<20090824094330.6521653gro4upo4c@webmail.kwsoft.de>
Message-ID: <20090824145527.069748c1@btj-tux.asp-as.no>

On Mon, 24 Aug 2009 09:43:30 +0200
lst_hoe02 at kwsoft.de wrote:

> Zitat von Bj?rn T Johansen <btj at havleik.no>:
> 
> > I have just installed one on a different server but now when trying  
> > to install on my own server (Gentoo box) I just get an error when  
> > logging on
> > telling me "There has been no contact with the remote server for  
> > several minutes........"
> > The horde.log says I have successfully logged in to my imap server  
> > but the php.log shows these error messages...:
> >
> > [23-Aug-2009 23:27:25] PHP Warning:  Cannot modify header  
> > information - headers already sent in Unknown on line 0
> > [23-Aug-2009 23:27:25] PHP Warning:  Cannot modify header  
> > information - headers already sent in Unknown on line 0
> > [23-Aug-2009 23:27:25] PHP Warning:  require_once() [<a  
> > href='function.require-once'>function.require-once</a>]: Couldn't  
> > resolve host name
> > in /mnt/data/www/havleik/horde/lib/Horde/Share/sql.php on line 683  
> > [23-Aug-2009 23:27:25] PHP Warning:  require_once(Horde/Group.php) [<a
> > href='function.require-once'>function.require-once</a>]: failed to  
> > open stream: operation failed
> 
> Seams like you have configured a SQL Server your machine cannot  
> resolve. Double-check your configs for typos and test the name  
> resolution on the machine.
> 
> Regards
> 
> Andreas
> 

Have double checked and triple checked with no result... :(
I have also copied the config files for my old horde install for horde and imp over to my new install, with the same error....

BTJ


From btj at havleik.no  Mon Aug 24 12:46:39 2009
From: btj at havleik.no (=?ISO-8859-1?Q?Bj=F8rn?= T Johansen)
Date: Mon, 24 Aug 2009 14:46:39 +0200
Subject: [horde] Problem with fresh install of Horde Groupware Webmail
 Edition 1.2.3...
In-Reply-To: <20090824094105.398474qkvdw0rboc@neo.wg.de>
References: <20090823233118.2b328afa@pennywise.havleik.no>
	<20090824094105.398474qkvdw0rboc@neo.wg.de>
Message-ID: <20090824144639.3bebedf1@btj-tux.asp-as.no>

On Mon, 24 Aug 2009 09:41:05 +0200
Jan Schneider <jan at horde.org> wrote:

> Zitat von Bj?rn T Johansen <btj at havleik.no>:
> 
> > I have just installed one on a different server but now when trying  
> > to install on my own server (Gentoo box) I just get an error when  
> > logging on
> > telling me "There has been no contact with the remote server for  
> > several minutes........"
> > The horde.log says I have successfully logged in to my imap server  
> > but the php.log shows these error messages...:
> >
> > [23-Aug-2009 23:27:25] PHP Warning:  Cannot modify header  
> > information - headers already sent in Unknown on line 0
> > [23-Aug-2009 23:27:25] PHP Warning:  Cannot modify header  
> > information - headers already sent in Unknown on line 0
> > [23-Aug-2009 23:27:25] PHP Warning:  require_once() [<a  
> > href='function.require-once'>function.require-once</a>]: Couldn't  
> > resolve host name
> > in /mnt/data/www/havleik/horde/lib/Horde/Share/sql.php on line 683  
> > [23-Aug-2009 23:27:25] PHP Warning:  require_once(Horde/Group.php) [<a
> > href='function.require-once'>function.require-once</a>]: failed to  
> > open stream: operation failed
> > in /mnt/data/www/havleik/horde/lib/Horde/Share/sql.php on line 683  
> > [23-Aug-2009 23:27:25] PHP Fatal error:  require_once() [<a
> > href='function.require'>function.require</a>]: Failed opening required
> > 'Horde/Group.php'  
> > (include_path='/mnt/data/www/havleik/horde/lib:/mnt/data/www/havleik/horde/lib/../pear')
> > in /mnt/data/www/havleik/horde/lib/Horde/Share/sql.php on line 683  
> > [23-Aug-2009 23:27:26] PHP Warning:  require_once() [<a
> > href='function.require-once'>function.require-once</a>]: Couldn't  
> > resolve host name in  
> > /mnt/data/www/havleik/horde/lib/Horde/Share/sql.php on line
> > 683 [23-Aug-2009 23:27:26] PHP Warning:   
> > require_once(Horde/Group.php) [<a  
> > href='function.require-once'>function.require-once</a>]: failed to  
> > open
> > stream: operation failed in  
> > /mnt/data/www/havleik/horde/lib/Horde/Share/sql.php on line 683  
> > [23-Aug-2009 23:27:26] PHP Fatal error:  require_once()
> > [<a href='function.require'>function.require</a>]: Failed opening required
> > 'Horde/Group.php'  
> > (include_path='/mnt/data/www/havleik/horde/lib:/mnt/data/www/havleik/horde/lib/../pear')
> > in /mnt/data/www/havleik/horde/lib/Horde/Share/sql.php on line 683
> 
> This looks like a badly broken PHP installation. To me it seems like  
> it's trying to include the required file from a URL, which is of  
> course wrong.
> 
> Jan.
> 

What's strange is that I ran version 1.2.1 without any problems on the same server, so one should think that the PHP installation should work...

BTJ

From lfbm.andamentos at gmail.com  Mon Aug 24 15:36:03 2009
From: lfbm.andamentos at gmail.com (Luis Felipe Marzagao)
Date: Mon, 24 Aug 2009 12:36:03 -0300
Subject: [horde] Infinite loop in login
In-Reply-To: <241439.64604.qm@web111909.mail.gq1.yahoo.com>
References: <241439.64604.qm@web111909.mail.gq1.yahoo.com>
Message-ID: <4A92B363.1080603@gmail.com>

Try the $conf['cookie']['path'] option in your horde conf.php. It must 
reflect the root of horde installation.

Frito Lay escreveu:
> Hello list,
>
> I'm trying to install horde 3.3.4 in a linux machine, distro is suse 11.
>
> Apache and php configuration is the standard one, there are no strange redirects, rewrites, etc configured.
> I have followed each step closely, there are no missing requirements
>
> Whenever I try to log in for the first time, I get an infinite loop:
> index.php -> login.php -> index.php ...
>
> I think the problem is index.php thinks I'm not authenticated, while login.php does.
>
> If I comment this section in login.php:
>
> /* Try transparent authentication. */
> if (Auth::isAuthenticated()) {
>     require HORDE_BASE . '/index.php';
>     exit;
> }
>
> The loop breaks, but of course the application doesn't work.
>
> I have read similar reports by people installing horde in the webroot.
> For me it doesn't make any difference, I get the same behavior by using webroot='', or webroot='horde'.
>
> I have installed previous versions of horde in the past, even written modules using the framework, and never came across this one before.
>
> Any ideas?
>
>
>
>       
>   

From michel at casa.co.cu  Mon Aug 24 18:37:28 2009
From: michel at casa.co.cu (Michel Bulgado)
Date: Mon, 24 Aug 2009 14:37:28 -0400
Subject: [horde] Quota Bar
Message-ID: <1251139048.25082.2.camel@michel.casa.cult.cu>

Hello

I use Horde Groupware Webmail 123.

My users have their mailboxes quota, when using the traditional way
(imp) do  not get the quota bar, but when I enter using the dynamic mode
(dimp) if it is.

In old version in imp/templates/quota/quota.inc i see the quota bar but
this change with the new versions.

<?php
if (is_a($quota, 'PEAR_Error')) {
    $class = 'quotawarn';
    $message = $quota->getMessage();
} else {
        $percent=0;
        $color='';
    if ($quota['limit'] != 0) {
        $quota['usage'] = $quota['usage'] / (1024 * 1024.0);
        $quota['limit'] = $quota['limit'] / (1024 * 1024.0);
        $percent = ($quota['usage'] * 100) / $quota['limit'];
        if ($percent >= 90) {
            $class = 'quotaalert';
            $color = '#FF0000';
        } elseif ($percent >= 75) {
            $class = 'quotawarn';
            $color = '#FCE30D';
        } else {
            $class = 'control';
            $color = '#339933';
        }
        $message = sprintf(_("Quota status: %.2fMB / %.2fMB  (%.2f%%)"),
$quota['usage'], $quota['limit'], $percent);
    } elseif ($quota['usage'] != 0) {
        $quota['usage'] = $quota['usage'] / (1024 * 1024.0);
        $class = 'control';
        $message = sprintf(_("Quota status: %.2fMB / NO LIMIT"),
$quota['usage']);
    } else {
        $class = 'control';
        $message = sprintf(_("Quota status: NO LIMIT"));
    }
        $message .= '</td><td width="30" class="header"
align="right"><font size="-3">0%</font></td><td width="200"
class="header">';

        $message .= '<table width="100%"><tr><td bgcolor="#ffffff"><div
style="height:4px; width:';
        $message .= sprintf("%.0f%%", $percent). '; font-size:3px;
background-color:'.$color.'">';
        $message .= '</div></td></tr></table></td><td width="30"
class="header" align="left"><font size="-3">100%</font>';
        $message .= '</td></tr></table></td></tr></table>';
}
?>
<table width="100%" border="0" cellpadding="3" cellspacing="0">
  <tr><td class="<?php echo $class ?>" align="center">
    <?php echo $message ?>
  </td></tr>
</table>


just remote code php from quota.inc and rename to quota.html

That might be happening?

Thanks

Michel



From lameventanas at yahoo.com  Tue Aug 25 01:36:31 2009
From: lameventanas at yahoo.com (Frito Lay)
Date: Mon, 24 Aug 2009 18:36:31 -0700 (PDT)
Subject: [horde] Infinite loop in login
In-Reply-To: <4A92B363.1080603@gmail.com>
References: <241439.64604.qm@web111909.mail.gq1.yahoo.com>
	<4A92B363.1080603@gmail.com>
Message-ID: <30399.47215.qm@web111920.mail.gq1.yahoo.com>

The cookie path is correctly set to /horde when using the /horde webroot (default), and / when using the root htdocs directory.
Following the instructions and the default configuration leads one to this infinite loop problem, there is nothing strange that I'm doing here.





________________________________
From: Luis Felipe Marzagao <lfbm.andamentos at gmail.com>
To: Frito Lay <lameventanas at yahoo.com>
Cc: horde at lists.horde.org
Sent: Tuesday, August 25, 2009 12:36:03 AM
Subject: Re: [horde] Infinite loop in login

Try the $conf['cookie']['path'] option in your horde conf.php. It must 
reflect the root of horde installation.

Frito Lay escreveu:
> Hello list,
>
> I'm trying to install horde 3.3.4 in a linux machine, distro is suse 11.
>
> Apache and php configuration is the standard one, there are no strange redirects, rewrites, etc configured.
> I have followed each step closely, there are no missing requirements
>
> Whenever I try to log in for the first time, I get an infinite loop:
> index.php -> login.php -> index.php ...
>
> I think the problem is index.php thinks I'm not authenticated, while login.php does.
>
> If I comment this section in login.php:
>
> /* Try transparent authentication. */
> if (Auth::isAuthenticated()) {
>     require HORDE_BASE . '/index.php';
>     exit;
> }
>
> The loop breaks, but of course the application doesn't work.
>
> I have read similar reports by people installing horde in the webroot.
> For me it doesn't make any difference, I get the same behavior by using webroot='', or webroot='horde'.
>
> I have installed previous versions of horde in the past, even written modules using the framework, and never came across this one before.
>
> Any ideas?
>
>
>
>      
>  



      

From chuck at horde.org  Tue Aug 25 04:22:02 2009
From: chuck at horde.org (Chuck Hagenbuch)
Date: Tue, 25 Aug 2009 00:22:02 -0400
Subject: [horde] Problem in Rdo/RelationshipTest testing clotho example
 in MySQL
In-Reply-To: <6ec714020810122153h421ed2cncc1bfcc644d84b22@mail.gmail.com>
References: <6ec714020810122153h421ed2cncc1bfcc644d84b22@mail.gmail.com>
Message-ID: <20090825002202.owc4kck@technest.org>

Quoting Elier Delgado <elier.delgado at gmail.com>:

> I have been testing Rdo, specifically the clotho example available on
> the CVS with MySql,
> and seem happen an error building the SQL sentence when I tested the
> relationship.
>
> Have someone tested this in MySql before?
>
> The ItemMapper find method return this query, that not work in MySQL:
>
> SELECT clotho_wbs_items.item_id, clotho_wbs_items.item_name,
> clotho_wbs_items.item_parent, clotho_wbs_items.item_duration,
> clotho_wbs_items.item_start, clotho_wbs_items.item_start_fixed,
> clotho_wbs_items.item_finish, clotho_wbs_items.item_finish_fixed,
> clotho_resources.resource_id AS `clotho_resources at resource_id`,
> clotho_resources.resource_type AS `clotho_resources at resource_type`,
> clotho_resources.resource_name AS `clotho_resources at resource_name`,
> clotho_resources.resource_uid AS `clotho_resources at resource_uid`,
> clotho_resources.resource_base_calendar AS
> `clotho_resources at resource_base_calendar`,
> clotho_resources.resource_start AS `clotho_resources at resource_start`,
> clotho_resources.resource_finish AS
> `clotho_resources at resource_finish`,
> clotho_wbs_items.item_id AS `clotho_wbs_items at item_id`,
> clotho_wbs_items.item_name AS `clotho_wbs_items at item_name`,
> clotho_wbs_items.item_parent AS `clotho_wbs_items at item_parent`,
> clotho_wbs_items.item_duration AS `clotho_wbs_items at item_duration`,
> clotho_wbs_items.item_start AS `clotho_wbs_items at item_start`,
> clotho_wbs_items.item_start_fixed AS
> `clotho_wbs_items at item_start_fixed`, clotho_wbs_items.item_finish AS
> `clotho_wbs_items at item_finish`, clotho_wbs_items.item_finish_fixed AS
> `clotho_wbs_items at item_finish_fixed`
> FROM clotho_wbs_items INNER JOIN clotho_wbs_items ON
> clotho_wbs_items.item_parent = clotho_wbs_items.item_id
> WHERE clotho_wbs_items.`item_id` = 1 LIMIT 0, 1
>
> It's a join with the self table without use alias, to can work must be
> like this:

Hi! I know it's nearly a year later, but this email has been in my  
inbox, waiting for me to find a time to check it after the git Rdo  
rewrite. Tonight I sat down and went from the beginning, so this bug  
was up. I reproduced it and have fixed this specific issue. I've also  
fixed a few other things in Rdo that weren't working right, and  
updated the clotho example to work with the PHP 5 Horde_Db and  
Horde_Rdo libs. There's one more bug in there somewhere when running  
RelationshipTest.php; hopefully it's the last one, and I'll try to  
work on it more tomorrow.

Hope this is useful to someone - it's definitely gotten me familiar  
again with the Rdo pieces that need work.

Best,
-chuck

From lst_hoe02 at kwsoft.de  Tue Aug 25 08:04:33 2009
From: lst_hoe02 at kwsoft.de (lst_hoe02 at kwsoft.de)
Date: Tue, 25 Aug 2009 10:04:33 +0200
Subject: [horde] Empty tables regurlarly
In-Reply-To: <20090823145531.13843aghj4hckfnk@neo.wg.de>
References: <20090821180803.12913d3yfq5l03wg@wiki.jusbaires.gov.ar>
	<20090823145531.13843aghj4hckfnk@neo.wg.de>
Message-ID: <20090825100433.1359520y35nx6u4g@webmail.kwsoft.de>

Zitat von Jan Schneider <jan at horde.org>:

> Zitat von Alexa Rodriguez <avrodriguez at jusbaires.gov.ar>:
>
>> Hi all!
>>
>> I would like know if it's possible periodically empty some of the  
>> Horde database tables, for example the cache table.
>>
>> If so, which tables could empty and how regularly?
>
> None of the tables should be emptied manually.
>
> Jan.

Reminds me :

Is there any maintenance going on for the potentially large tables  
like horde_histories and horde_syncml_map ?

What is the proper way of purging/aging out for this tables?

Regards

Andreas



From dom.lalot at gmail.com  Tue Aug 25 09:14:21 2009
From: dom.lalot at gmail.com (LALOT Dominique)
Date: Tue, 25 Aug 2009 11:14:21 +0200
Subject: [horde] msword viewer bad url generated and errors in apache
	error.log
In-Reply-To: <20090822174246.437246il9ah5ikmw@neo.wg.de>
References: <1617f8010908210039o4f63e804p6ed9b31e59bcae1@mail.gmail.com>
	<20090821143701.wc8kgk00kswgg@bigworm.curecanti.org>
	<20090822174246.437246il9ah5ikmw@neo.wg.de>
Message-ID: <1617f8010908250214g2c3ccbccw110911f253e74d46@mail.gmail.com>

2009/8/22 Jan Schneider <jan at horde.org>

> Zitat von Michael M Slusarz <slusarz at horde.org>:
>
>  Quoting LALOT Dominique <dom.lalot at gmail.com>:
>>
>>  Hello,
>>>
>>> I get some apache errors concerning png,gif and so on.
>>>
>>> [Fri Aug 21 07:00:25 2009] [error] [client 139.124.132.65] File does not
>>> exist: /var/www/perso/horde/imp/mswordal7Inq0.emf, referer:
>>>
>>> http://webmel.univ.fr/horde/imp/view.php?popup_view=1&mailbox=INBOX&index=6535&actionID=view_attach&id=3&mimecache=ea6243f8596ced15b944642deafc3c6b
>>>
>>> I found that mswordal7Inq0.emf was in the tmpdir of horde.
>>>
>>> I don't understand where the error could be.
>>>
>>> Some other traces:
>>>
>>> [Wed Aug 19 17:02:08 2009] [error] [client 139.124.132.65] File does not
>>> exist: /var/www/perso/horde/imp/msword62qAsO0.png
>>> [Wed Aug 19 17:02:08 2009] [error] [client 139.124.132.65] File does not
>>> exist: /var/www/perso/horde/imp/StrangeNoGraphicData
>>> [Wed Aug 19 17:02:30 2009] [error] [client 139.124.132.65] File does not
>>> exist: /var/www/perso/horde/imp/StrangeNoGraphicData
>>> [Wed Aug 19 17:02:30 2009] [error] [client 139.124.132.65] File does not
>>> exist: /var/www/perso/horde/imp/msword62qAsO0.png
>>>
>>
>> The msword viewer does not allow display of graphics contained in word
>> documents, since there is no way to reliably serve temporary files on the
>> system via HTTP URLs (not to mention the security issues).
>>
>
> http://wiki.horde.org/GraphicswvHtml is a workaround.
>
> Jan.
>
> --
> Do you need professional PHP or Horde consulting?
> http://horde.org/consulting/
>
>
Yes, I discovered that, and it works. I was not able to answer to my post
(never get my own post)

Thanks

Dom


>
> --
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>



-- 
Dominique LALOT
Ing?nieur Syst?mes et R?seaux
http://annuaire.univmed.fr/showuser.php?uid=lalot

From rpjday at crashcourse.ca  Tue Aug 25 13:48:18 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Tue, 25 Aug 2009 09:48:18 -0400 (EDT)
Subject: [horde] after debian upgrade to lenny,
	"DB Error: Extension not found"
Message-ID: <alpine.LFD.2.00.0908250943520.3646@localhost>


  after a full upgrade of etch to lenny earlier this morning, any
attempt to access horde on the server generates

  A fatal error has occurred

  DB Error: extension not found

  Details have been logged for the administrator.

i've been googling already, and numerous people report that it's an
issue regarding kronolith[2?] and PHP.  i can't do a debian upgrade on
anything related to horde since all of that was installed simply by
unloading tarballs, so can anyone suggest the proper fix?

  i can see something that might be relevant under:

    <sitename>/horde/kronolith/lib/Scheduler/kronolith.php

is that something i should be investigating?  and where would those
details have been "logged"?  where would those diagnostic msgs have
gone by default so i can read any extra detail i can get my hands on?
thanks.

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From mtecles at biof.ufrj.br  Tue Aug 25 14:36:06 2009
From: mtecles at biof.ufrj.br (mtecles at biof.ufrj.br)
Date: Tue, 25 Aug 2009 11:36:06 -0300
Subject: [horde] after debian upgrade to lenny,
	"DB Error: Extension not found"
In-Reply-To: <alpine.LFD.2.00.0908250943520.3646@localhost>
References: <alpine.LFD.2.00.0908250943520.3646@localhost>
Message-ID: <4A93CCA6.30697.6851BF@mtecles.biof.ufrj.br>

It's a hole new system! Verify that you have installed php5-common  
php5-mysql php5-cli php-pear php5-gd, php5-imap if using IMAP. Read 
horde/docs/INSTALL, verify that you have those PEAR modules 
installed, check with horde/test.php, verify that you can access 
Horde database with "hode" user by command line.

Mauricio

On 25 Aug 2009 at 9:48, Robert P. J. Day wrote:

> 
>   after a full upgrade of etch to lenny earlier this morning, any
> attempt to access horde on the server generates
> 
>   A fatal error has occurred
> 
>   DB Error: extension not found
> 
>   Details have been logged for the administrator.
> 
> i've been googling already, and numerous people report that it's an
> issue regarding kronolith[2?] and PHP.  i can't do a debian upgrade on
> anything related to horde since all of that was installed simply by
> unloading tarballs, so can anyone suggest the proper fix?
> 
>   i can see something that might be relevant under:
> 
>     <sitename>/horde/kronolith/lib/Scheduler/kronolith.php
> 
> is that something i should be investigating?  and where would those
> details have been "logged"?  where would those diagnostic msgs have
> gone by default so i can read any extra detail i can get my hands on?
> thanks.
> 
> rday
> --
> 
> ========================================================================
> Robert P. J. Day                               Waterloo, Ontario, CANADA
> 
>         Linux Consulting, Training and Annoying Kernel Pedantry.
> 
> Web page:                                          http://crashcourse.ca
> Twitter:                                       http://twitter.com/rpjday
> ========================================================================
> -- 
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org


--------------------------------------------------------
Mauricio J. T. Tecles
Instituto de Biofisica Carlos Chagas Filho - UFRJ
Edificio do Centro de Ciencias da Saude, Bloco G
Av. Carlos Chagas Filho, 373
Cidade Universitaria, Ilha do Fundao
Rio de Janeiro, RJ
Brasil
21941-902
Telefone: 55 21 2562-6544
FAX: 55 21 2280-8193
mtecles at biof.ufrj.br


From rpjday at crashcourse.ca  Tue Aug 25 14:38:51 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Tue, 25 Aug 2009 10:38:51 -0400 (EDT)
Subject: [horde] after debian upgrade to lenny,
 "DB Error: Extension not found"
In-Reply-To: <4A93CCA6.30697.6851BF@mtecles.biof.ufrj.br>
References: <alpine.LFD.2.00.0908250943520.3646@localhost>
	<4A93CCA6.30697.6851BF@mtecles.biof.ufrj.br>
Message-ID: <alpine.LFD.2.00.0908251037130.4347@localhost>

On Tue, 25 Aug 2009, mtecles at biof.ufrj.br wrote:

> It's a hole new system! Verify that you have installed php5-common
> php5-mysql php5-cli php-pear php5-gd, php5-imap if using IMAP. Read
> horde/docs/INSTALL, verify that you have those PEAR modules
> installed, check with horde/test.php, verify that you can access
> Horde database with "hode" user by command line.
>
> Mauricio

  gotcha.  but one quick question before diving into that -- for the
time being, i would like to leave the current horde setup as it is as
much as possible.  is that remotely possible?  that is, i'd like to
avoid having to upgrade the horde software itself right this minute.

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From rpjday at crashcourse.ca  Tue Aug 25 14:54:53 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Tue, 25 Aug 2009 10:54:53 -0400 (EDT)
Subject: [horde] after debian upgrade to lenny,
 "DB Error: Extension not found"
In-Reply-To: <4A93CCA6.30697.6851BF@mtecles.biof.ufrj.br>
References: <alpine.LFD.2.00.0908250943520.3646@localhost>
	<4A93CCA6.30697.6851BF@mtecles.biof.ufrj.br>
Message-ID: <alpine.LFD.2.00.0908251050370.4347@localhost>

On Tue, 25 Aug 2009, mtecles at biof.ufrj.br wrote:

> It's a hole new system! Verify that you have installed php5-common
> php5-mysql php5-cli php-pear php5-gd, php5-imap if using IMAP. Read
> horde/docs/INSTALL, verify that you have those PEAR modules
> installed, check with horde/test.php, verify that you can access
> Horde database with "hode" user by command line.
>
> Mauricio
>
> On 25 Aug 2009 at 9:48, Robert P. J. Day wrote:
>
> >
> >   after a full upgrade of etch to lenny earlier this morning, any
> > attempt to access horde on the server generates
> >
> >   A fatal error has occurred
> >
> >   DB Error: extension not found
> >
> >   Details have been logged for the administrator.
> >
> > i've been googling already, and numerous people report that it's an
> > issue regarding kronolith[2?] and PHP.  i can't do a debian upgrade on
> > anything related to horde since all of that was installed simply by
> > unloading tarballs, so can anyone suggest the proper fix?
> >
> >   i can see something that might be relevant under:
> >
> >     <sitename>/horde/kronolith/lib/Scheduler/kronolith.php
> >
> > is that something i should be investigating?  and where would those
> > details have been "logged"?  where would those diagnostic msgs have
> > gone by default so i can read any extra detail i can get my hands on?
> > thanks.

  ok, here's the current scenario.  my newly-upgraded lenny system
already had:

  php5-common
  php-pear

i had to install:

  php5-mysql
  php5-cli
  php5-gd
  php5-imap

i then restarted the apache 1.3 server, and tried again to get to
horde, got the same error, so i opened horde/test.php, and here are
some of what look like important lines:

  PHP Module Capabilities:
    GD Support: No
    MySQL Support: No

why is that?  is that because horde is still looking for the PHP4
versions of those packages?

  i ran "mysql" to check the databases and the horde database was
still there.  so is it just a PHP version mismatch?  and where would i
change that?  and could those issues cause exactly the error i'm
currently seeing?

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From mtecles at biof.ufrj.br  Tue Aug 25 15:06:34 2009
From: mtecles at biof.ufrj.br (mtecles at biof.ufrj.br)
Date: Tue, 25 Aug 2009 12:06:34 -0300
Subject: [horde] after debian upgrade to lenny,
	"DB Error: Extension not found"
In-Reply-To: <alpine.LFD.2.00.0908251037130.4347@localhost>
References: <alpine.LFD.2.00.0908250943520.3646@localhost>,
	<4A93CCA6.30697.6851BF@mtecles.biof.ufrj.br>,
	<alpine.LFD.2.00.0908251037130.4347@localhost>
Message-ID: <4A93D3CA.21256.843844@mtecles.biof.ufrj.br>

I don't know which Horde version you are using, but I think you can 
stay with this one for now, upgrading it now would add to the 
problem. I miss spell "horde" DB user on the preceding mail.

After solving the problem and have Horde working and before upgrade 
Horde, back it up. Back up your DB (dump), back up your Horde 
installation (tar). Do the upgrade on a test server and take note of 
every step (I mean it!) so you can reproduce then on the production 
server. Read each horde/~/docs/UPGRADING for each Horde application 
you have.

Mauricio

On 25 Aug 2009 at 10:38, Robert P. J. Day wrote:

> On Tue, 25 Aug 2009, mtecles at biof.ufrj.br wrote:
> 
> > It's a hole new system! Verify that you have installed php5-common
> > php5-mysql php5-cli php-pear php5-gd, php5-imap if using IMAP. Read
> > horde/docs/INSTALL, verify that you have those PEAR modules
> > installed, check with horde/test.php, verify that you can access
> > Horde database with "hode" user by command line.
> >
> > Mauricio
> 
>   gotcha.  but one quick question before diving into that -- for the
> time being, i would like to leave the current horde setup as it is as
> much as possible.  is that remotely possible?  that is, i'd like to
> avoid having to upgrade the horde software itself right this minute.
> 
> rday
> --
> 
> ========================================================================
> Robert P. J. Day                               Waterloo, Ontario, CANADA
> 
>         Linux Consulting, Training and Annoying Kernel Pedantry.
> 
> Web page:                                          http://crashcourse.ca
> Twitter:                                       http://twitter.com/rpjday
> ========================================================================


--------------------------------------------------------
Mauricio J. T. Tecles
Instituto de Biofisica Carlos Chagas Filho - UFRJ
Edificio do Centro de Ciencias da Saude, Bloco G
Av. Carlos Chagas Filho, 373
Cidade Universitaria, Ilha do Fundao
Rio de Janeiro, RJ
Brasil
21941-902
Telefone: 55 21 2562-6544
FAX: 55 21 2280-8193
mtecles at biof.ufrj.br


From rpjday at crashcourse.ca  Tue Aug 25 15:10:30 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Tue, 25 Aug 2009 11:10:30 -0400 (EDT)
Subject: [horde] after debian upgrade to lenny,
 "DB Error: Extension not found"
In-Reply-To: <alpine.LFD.2.00.0908251050370.4347@localhost>
References: <alpine.LFD.2.00.0908250943520.3646@localhost>
	<4A93CCA6.30697.6851BF@mtecles.biof.ufrj.br>
	<alpine.LFD.2.00.0908251050370.4347@localhost>
Message-ID: <alpine.LFD.2.00.0908251107380.4669@localhost>


a quick followup:

On Tue, 25 Aug 2009, Robert P. J. Day wrote:

>   ok, here's the current scenario.  my newly-upgraded lenny system
> already had:
>
>   php5-common
>   php-pear
>
> i had to install:
>
>   php5-mysql
>   php5-cli
>   php5-gd
>   php5-imap
>
> i then restarted the apache 1.3 server, and tried again to get to
> horde, got the same error, so i opened horde/test.php, and here are
> some of what look like important lines:
>
>   PHP Module Capabilities:
>     GD Support: No
>     MySQL Support: No
>
> why is that?  is that because horde is still looking for the PHP4
> versions of those packages?
>
>   i ran "mysql" to check the databases and the horde database was
> still there.  so is it just a PHP version mismatch?  and where would i
> change that?  and could those issues cause exactly the error i'm
> currently seeing?

  to further suggest it's a PHP mismatch, the current status of the
old php4-mysql package is "rc", meaning it's been deleted and only its
config files are left.  so that would certainly explain why, if any
component of horde is still trying to use php4 for mysql, it's going
to fail badly.  with what little i know, that would certainly suggest
why test.php claims that there's no PHP MySQL support.  so i just need
to know what horde config file to change to resolve that.  thanks
muchly.

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From lst_hoe02 at kwsoft.de  Tue Aug 25 15:14:20 2009
From: lst_hoe02 at kwsoft.de (lst_hoe02 at kwsoft.de)
Date: Tue, 25 Aug 2009 17:14:20 +0200
Subject: [horde] after debian upgrade to lenny,
 "DB Error: Extension not found"
In-Reply-To: <alpine.LFD.2.00.0908251050370.4347@localhost>
References: <alpine.LFD.2.00.0908250943520.3646@localhost>
	<4A93CCA6.30697.6851BF@mtecles.biof.ufrj.br>
	<alpine.LFD.2.00.0908251050370.4347@localhost>
Message-ID: <20090825171420.10301lwtskr18slc@webmail.kwsoft.de>

Zitat von "Robert P. J. Day" <rpjday at crashcourse.ca>:

> On Tue, 25 Aug 2009, mtecles at biof.ufrj.br wrote:
>
>> It's a hole new system! Verify that you have installed php5-common
>> php5-mysql php5-cli php-pear php5-gd, php5-imap if using IMAP. Read
>> horde/docs/INSTALL, verify that you have those PEAR modules
>> installed, check with horde/test.php, verify that you can access
>> Horde database with "hode" user by command line.
>>
>> Mauricio
>>
>> On 25 Aug 2009 at 9:48, Robert P. J. Day wrote:
>>
>> >
>> >   after a full upgrade of etch to lenny earlier this morning, any
>> > attempt to access horde on the server generates
>> >
>> >   A fatal error has occurred
>> >
>> >   DB Error: extension not found
>> >
>> >   Details have been logged for the administrator.
>> >
>> > i've been googling already, and numerous people report that it's an
>> > issue regarding kronolith[2?] and PHP.  i can't do a debian upgrade on
>> > anything related to horde since all of that was installed simply by
>> > unloading tarballs, so can anyone suggest the proper fix?
>> >
>> >   i can see something that might be relevant under:
>> >
>> >     <sitename>/horde/kronolith/lib/Scheduler/kronolith.php
>> >
>> > is that something i should be investigating?  and where would those
>> > details have been "logged"?  where would those diagnostic msgs have
>> > gone by default so i can read any extra detail i can get my hands on?
>> > thanks.
>
>   ok, here's the current scenario.  my newly-upgraded lenny system
> already had:
>
>   php5-common
>   php-pear
>
> i had to install:
>
>   php5-mysql
>   php5-cli
>   php5-gd
>   php5-imap
>
> i then restarted the apache 1.3 server, and tried again to get to
> horde, got the same error, so i opened horde/test.php, and here are
> some of what look like important lines:
>
>   PHP Module Capabilities:
>     GD Support: No
>     MySQL Support: No

Huhh? You really have Apache 1.3 installed? Maybe Lenny had installed  
Apache2.x additionally and the PHP5 modules you are looking at are  
only loaded in apache2?

Regards

Andreas



From lst_hoe02 at kwsoft.de  Tue Aug 25 15:16:12 2009
From: lst_hoe02 at kwsoft.de (lst_hoe02 at kwsoft.de)
Date: Tue, 25 Aug 2009 17:16:12 +0200
Subject: [horde] after debian upgrade to lenny,
 "DB Error: Extension not found"
In-Reply-To: <alpine.LFD.2.00.0908251107380.4669@localhost>
References: <alpine.LFD.2.00.0908250943520.3646@localhost>
	<4A93CCA6.30697.6851BF@mtecles.biof.ufrj.br>
	<alpine.LFD.2.00.0908251050370.4347@localhost>
	<alpine.LFD.2.00.0908251107380.4669@localhost>
Message-ID: <20090825171612.80761ao76provrdw@webmail.kwsoft.de>

Zitat von "Robert P. J. Day" <rpjday at crashcourse.ca>:

>
> a quick followup:
>
> On Tue, 25 Aug 2009, Robert P. J. Day wrote:
>
>>   ok, here's the current scenario.  my newly-upgraded lenny system
>> already had:
>>
>>   php5-common
>>   php-pear
>>
>> i had to install:
>>
>>   php5-mysql
>>   php5-cli
>>   php5-gd
>>   php5-imap
>>
>> i then restarted the apache 1.3 server, and tried again to get to
>> horde, got the same error, so i opened horde/test.php, and here are
>> some of what look like important lines:
>>
>>   PHP Module Capabilities:
>>     GD Support: No
>>     MySQL Support: No
>>
>> why is that?  is that because horde is still looking for the PHP4
>> versions of those packages?
>>
>>   i ran "mysql" to check the databases and the horde database was
>> still there.  so is it just a PHP version mismatch?  and where would i
>> change that?  and could those issues cause exactly the error i'm
>> currently seeing?
>
>   to further suggest it's a PHP mismatch, the current status of the
> old php4-mysql package is "rc", meaning it's been deleted and only its
> config files are left.  so that would certainly explain why, if any
> component of horde is still trying to use php4 for mysql, it's going
> to fail badly.  with what little i know, that would certainly suggest
> why test.php claims that there's no PHP MySQL support.  so i just need
> to know what horde config file to change to resolve that.  thanks
> muchly.

Horde try to use what ever PHP version the webserver provides. So you  
have to look in your webserver (apache?) config what PHP  
version/modules are loaded.

Regards

Andreas




From rpjday at crashcourse.ca  Tue Aug 25 15:20:33 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Tue, 25 Aug 2009 11:20:33 -0400 (EDT)
Subject: [horde] after debian upgrade to lenny,
 "DB Error: Extension not found"
In-Reply-To: <20090825171420.10301lwtskr18slc@webmail.kwsoft.de>
References: <alpine.LFD.2.00.0908250943520.3646@localhost>
	<4A93CCA6.30697.6851BF@mtecles.biof.ufrj.br>
	<alpine.LFD.2.00.0908251050370.4347@localhost>
	<20090825171420.10301lwtskr18slc@webmail.kwsoft.de>
Message-ID: <alpine.LFD.2.00.0908251115070.4750@localhost>

On Tue, 25 Aug 2009, lst_hoe02 at kwsoft.de wrote:

> Zitat von "Robert P. J. Day" <rpjday at crashcourse.ca>:
> >
> >  ok, here's the current scenario.  my newly-upgraded lenny system
> > already had:
> >
> >  php5-common
> >  php-pear
> >
> > i had to install:
> >
> >  php5-mysql
> >  php5-cli
> >  php5-gd
> >  php5-imap
> >
> > i then restarted the apache 1.3 server, and tried again to get to
> > horde, got the same error, so i opened horde/test.php, and here are
> > some of what look like important lines:
> >
> >  PHP Module Capabilities:
> >    GD Support: No
> >    MySQL Support: No
>
> Huhh? You really have Apache 1.3 installed?

  yes, and that's what's running right now, the reason being that some
other folks told me that the apache1 -> apache2 upgrade wasn't as
simple as they'd thought, so i wanted to put that off for the time
being as long as everything kept running.

> Maybe Lenny had installed Apache2.x additionally and the PHP5
> modules you are looking at are only loaded in apache2?

  in fact, apache2 was there all the time, it just wasn't being
started, and it's not being started now until i resolve everything i
need to do that upgrade.  are you suggesting that running apache1
might be causing this?  because the horde/test.php page shows that all
PHP capabilities are being recognized except for GD, MySQL and
Postgresql (and that last one is because Postgresql isn't even
running).


rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From slusarz at horde.org  Tue Aug 25 15:31:50 2009
From: slusarz at horde.org (Michael M Slusarz)
Date: Tue, 25 Aug 2009 09:31:50 -0600
Subject: [horde] Empty tables regurlarly
In-Reply-To: <20090825100433.1359520y35nx6u4g@webmail.kwsoft.de>
References: <20090821180803.12913d3yfq5l03wg@wiki.jusbaires.gov.ar>
	<20090823145531.13843aghj4hckfnk@neo.wg.de>
	<20090825100433.1359520y35nx6u4g@webmail.kwsoft.de>
Message-ID: <20090825093150.o0g8kk08wsow@bigworm.curecanti.org>

Quoting lst_hoe02 at kwsoft.de:

> Is there any maintenance going on for the potentially large tables  
> like horde_histories and horde_syncml_map ?
>
> What is the proper way of purging/aging out for this tables?

For horde_histories, there isn't.  But that's the whole point of a  
table storing archived data.  Once you start purging, you destroy the  
reason why the table exists in the first place.

michael

-- 
___________________________________
Michael Slusarz [slusarz at horde.org]


From ruben at auger.org.ar  Tue Aug 25 17:17:41 2009
From: ruben at auger.org.ar (Ruben Squartini)
Date: Tue, 25 Aug 2009 14:17:41 -0300
Subject: [horde] Unable to set "individual user" permisions to shares
Message-ID: <20090825141741.43327i7z771q0cdx@webmail.auger.org.ar>

Hi people!

I was testing some features and in our latest installation  
(FRAMEWORK3) is not possible to give permissions to individual users  
to a share.

Result on top of the screen says "share updated" but no users has been  
added to the share.

Looking into the code it seems that there must be a user list in the  
"*_shares_users" tables, but there is none.

As we are using IMP to validate users we don't have the chance to add  
users using the administrative module, but somehow it is not adding  
the logged-in users to the list of possible users to share information  
with.

Any clue? Anything I could check to try to put this to work? Anything  
I missed when creating DB?

I also checked in an old installation (previously using DataTree) and  
it grabbed the user list from the DataTree when it was migrated to SQL.

Regards,
Ruben.



====================

El contenido del presente mensaje y sus adjuntos, es confidencial,  
privado y de uso exclusivo de los destinatarios a los cuales esta  
dirigido, pudiendo contener informaci?n privilegiada y legalmente  
protegida. Queda prohibida la revisi?n, divulgaci?n, publicaci?n,  
modificaci?n, copia, distribuci?n o acci?n en relaci?n con esta  
informaci?n, por personas o entidades distintas al destinatario. Si  
usted, por alguna raz?n, lo ha recibido por error, por favor tenga la  
amabilidad de re-enviarlo al remitente y eliminarlo de su sistema. Las  
opiniones contenidas son exclusivas de su autor y no representan  
necesariamente, la opini?n del Observatorio o sus Instituciones  
asociadas. Muchas gracias!
http://www.auger.org.ar

This e-mail transmission and it's attachments are confidential,  
private and of exclusive use of their legal recipients, can content  
legally privileged information. If you are not the intended recipient,  
you are hereby notified that any disclosure, copying, distribution, or  
reliance upon the contents of this e-mail is strictly prohibited. If  
you have received this e-mail transmission in error, please reply to  
the sender, so that the Observatory can arrange for proper delivery,  
and then please delete the message from your system. Opinions  
expressed are exclusive from the author and are not necessarily shared  
or supported by the Observatory or partner Institutions. Thank you!
http://www.auger.org.ar

From rpjday at crashcourse.ca  Tue Aug 25 17:28:24 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Tue, 25 Aug 2009 13:28:24 -0400 (EDT)
Subject: [horde] now running under apache2,
 horde/test.php has some interesting output
Message-ID: <alpine.LFD.2.00.0908251323320.5772@localhost>


  as a followup to my earlier post, i quickly set up apache2 on my
lenny system, configured the VirtualHosts, restarted apache2 and
here's the result of running horde/test.php:

  a bunch of copies of

    Notice: Undefined index: fileroot in .../horde/lib/Test.php on
line 583

  although i recall getting something similar under apache1.


  also, i now officially have GD and MySQL support, which is what i
was after.

  and, amusingly, i get:

  "Wow, a mystical version of PHP from the future ..."  the listed PHP
Version is "5.2.6-1+lenny3".  should i just assume i need an upgraded
script and that this isn't fatal?

rday
--


========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From rpjday at crashcourse.ca  Tue Aug 25 17:43:59 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Tue, 25 Aug 2009 13:43:59 -0400 (EDT)
Subject: [horde] newer version of horde to work with apache2 and php5?
Message-ID: <alpine.LFD.2.00.0908251337260.5976@localhost>


  this question might have a *very* simple solution -- should i
upgrade my horde install on my lenny system now that i've moved up to
apache2 and php5 from apache1 and php4?

the longer story:

  now that i've migrated over to apache2 that uses php5, i'm getting
some interesting behaviour from horde.  first, if i go to the URL that
redirects to horde, i get:

=====

Notice: Only variable references should be returned by reference in
/var/www/.../horde/lib/Horde/DataTree.php on line 1180

Notice: Only variable references should be returned by reference in
/var/www/.../horde/lib/Horde/Perms.php on line 347

Notice: Only variable references should be returned by reference in
/var/www/.../horde/lib/Horde/Auth.php on line 1168

Warning: Cannot modify header information - headers already sent by
(output started at /var/www/.../horde/lib/Horde/DataTree.php:1180) in
/var/www/.../horde/index.php on line 51

=====

  i'm not a php expert, so are those php issues related to the switch
to php5?

  if i go *directly* to .../horde/index.php, not surprisingly, i get
the same output since that's the default file in that directory.  to
login now (which should have happened automatically), i now need to
explicitly browse to .../horde/login.php  (that's why i'm starting to
guess that this is all php-related -- i should have ended up at the
login screen automatically).

  thoughts?  i can tell i'm getting close.

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From rpjday at crashcourse.ca  Tue Aug 25 18:24:47 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Tue, 25 Aug 2009 14:24:47 -0400 (EDT)
Subject: [horde] my plan for upgrading my horde install
Message-ID: <alpine.LFD.2.00.0908251414510.6333@localhost>


  if you can forgive another posting, based on what i've read, this is
what i plan on doing to bring my horde installation on my new lenny
system up to date.  if what follows sounds insane, please warn me off
of it.

  as i mentioned, after i upgraded to lenny and apache2 and php5, i'm
not surprised to see some errors since that was a pretty major upgrade
of a lot of stuff all at once.  so what i want to do is install a
sibling directory of the latest horde and slowly build it up to
eventually duplicate what's there now.

  under the appropriate /var/www/... directory, there is a "horde"
directory where the user is directed by default.  i've downloaded and
unloaded horde-3.3.4 next to it, so now i have:

   horde/  horde-3.3.4/

which means that i can now *explicitly* go to the new install if i
want by adding the "horde-3.3.4" directory name at the end of the URL,
and it seems to take me there just fine.  doesn't run properly yet,
but it takes me there (i'm assuming to invoke the index.php file it
finds there).  so far, so good?

  that, of course, doesn't work, since all i've done is unload the
tarball, and i'm told that i have some missing or unreadable files:

  prefs.php
  conf.php
  mime_drivers.php
  nls.php
  registry.php

which is fine -- i was certainly expecting to have to do more work,
and i can now get into setting up those files.  everything sound good
so far?

  i'll try to set them up to reproduce the settings from the current
install, of course, and i'm assuming that i can point the new install
at the current horde table that's already in mysql -- i really want
the new install to take advantage of all the horde data that's been
stored all this time.

  does this sound sane?  all i want to start with is getting an
absolutely basic and up-to-date install running next to the existing
one, and copy/reproduce that config info to the point where folks can
log in.  after that, i'll have to add:

  gollem
  hermes
  imp
  jonah
  klutz
  ... etc etc, all the stuff in the old install ...

  thoughts?

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From ruben at auger.org.ar  Tue Aug 25 18:51:27 2009
From: ruben at auger.org.ar (Ruben Squartini)
Date: Tue, 25 Aug 2009 15:51:27 -0300
Subject: [horde] Unable to set "individual user" permisions to shares
Message-ID: <20090825155127.715029ntvlndt773@webmail.auger.org.ar>

Hi people!

After some further testing I found that entries in "*_shares_users"  
are either added when the user logs in the first time or when someone  
grants some "individual user" permissions to a share.

In the old installation there are entries for each share to its owner,  
in the new one there are none.

In the new installation the entry is not added, but no error is shown.

There is some previous thing I need to activate to allow this behavior?

Administration->Configuration->Horde->Permissions
   is set to SQL with Horde defaults and tables are there and accessible.

Regards,
Ruben.





====================

El contenido del presente mensaje y sus adjuntos, es confidencial,  
privado y de uso exclusivo de los destinatarios a los cuales esta  
dirigido, pudiendo contener informaci?n privilegiada y legalmente  
protegida. Queda prohibida la revisi?n, divulgaci?n, publicaci?n,  
modificaci?n, copia, distribuci?n o acci?n en relaci?n con esta  
informaci?n, por personas o entidades distintas al destinatario. Si  
usted, por alguna raz?n, lo ha recibido por error, por favor tenga la  
amabilidad de re-enviarlo al remitente y eliminarlo de su sistema. Las  
opiniones contenidas son exclusivas de su autor y no representan  
necesariamente, la opini?n del Observatorio o sus Instituciones  
asociadas. Muchas gracias!
http://www.auger.org.ar

This e-mail transmission and it's attachments are confidential,  
private and of exclusive use of their legal recipients, can content  
legally privileged information. If you are not the intended recipient,  
you are hereby notified that any disclosure, copying, distribution, or  
reliance upon the contents of this e-mail is strictly prohibited. If  
you have received this e-mail transmission in error, please reply to  
the sender, so that the Observatory can arrange for proper delivery,  
and then please delete the message from your system. Opinions  
expressed are exclusive from the author and are not necessarily shared  
or supported by the Observatory or partner Institutions. Thank you!
http://www.auger.org.ar

From rpjday at crashcourse.ca  Tue Aug 25 19:07:16 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Tue, 25 Aug 2009 15:07:16 -0400 (EDT)
Subject: [horde] any horde experts in K-W area who might have a couple hours?
Message-ID: <alpine.LFD.2.00.0908251504400.6738@localhost>


  i'm starting to think that i might be getting out of my comfort zone
here since i'm now looking at upgrading a 3.0.9 horde install to
3.3.4, and that's a long way to go for someone who's new at this.

  if i make a snap decision and want to find someone local who wants
to make a few bucks doing this and is *good* at it, anyone out there
in the area who's available on *very* short notice?

rday

p.s.  if you don't know what "K-W" stands for, you're not local. :-)
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From me at sandaili.com  Tue Aug 25 13:50:07 2009
From: me at sandaili.com (Sandaili)
Date: Tue, 25 Aug 2009 08:50:07 -0500
Subject: [horde] Filters not working - help determining backend
Message-ID: <20090825085007.68461oyile3myqdc@sandaili.com>

I've installed the newest Groupware with Webmail. Everything that  
needs to be working is, except the filtering.

I know I need to let you all know what backend I am using, but I do  
not know where to look that up. I have full adminstrative control, so  
if someone can point me in the right direction, I will add that  
information here so I can get some help. I would appreciate it very  
much.

The problem itself - currently no filters work. For example, I still  
get mail from exampleuser at yahoo.com, even though exampleuser at yahoo.com  
is in my blacklist and the blacklist is enabled.



----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.


From mtecles at biof.ufrj.br  Tue Aug 25 19:41:25 2009
From: mtecles at biof.ufrj.br (mtecles at biof.ufrj.br)
Date: Tue, 25 Aug 2009 16:41:25 -0300
Subject: [horde] my plan for upgrading my horde install
In-Reply-To: <alpine.LFD.2.00.0908251414510.6333@localhost>
References: <alpine.LFD.2.00.0908251414510.6333@localhost>
Message-ID: <4A941435.12688.17FDAF7@mtecles.biof.ufrj.br>

I don't know which Horde version you are using, but I think you 
should not do it like this, some upgrades need intermediate versions. 
Remember, upgrading means upgrading database also, not just replace 
Horde files. The upgrades scripts are in Horde applications and they 
are supposed to be used from one version to another.

I have upgraded from Horde 3.1.5 to Horde 3.3.3 (IMP 4.1.5 to 4.3.4). 
You must read each horde/~/docs/UPGRADING from each intermediate 
version from yours to the newest one. 

Backup your database and Horde directory. Rename Horde directory, 
download the following version of yours (Horde and applications), 
read the UPGRADING docs, do the upgrade. Rename Horde directory, 
download the next following version (Horde and applications), read 
the UPGRADING docs, do the upgrade. Repeat this for each version 
until the newest.

Again, do it on a test server and take note of every step.

I will send you a file with the steps I followed to upgrade.

Mauricio

On 25 Aug 2009 at 14:24, Robert P. J. Day wrote:

> 
>   if you can forgive another posting, based on what i've read, this is
> what i plan on doing to bring my horde installation on my new lenny
> system up to date.  if what follows sounds insane, please warn me off
> of it.
> 
>   as i mentioned, after i upgraded to lenny and apache2 and php5, i'm
> not surprised to see some errors since that was a pretty major upgrade
> of a lot of stuff all at once.  so what i want to do is install a
> sibling directory of the latest horde and slowly build it up to
> eventually duplicate what's there now.
> 
>   under the appropriate /var/www/... directory, there is a "horde"
> directory where the user is directed by default.  i've downloaded and
> unloaded horde-3.3.4 next to it, so now i have:
> 
>    horde/  horde-3.3.4/
> 
> which means that i can now *explicitly* go to the new install if i
> want by adding the "horde-3.3.4" directory name at the end of the URL,
> and it seems to take me there just fine.  doesn't run properly yet,
> but it takes me there (i'm assuming to invoke the index.php file it
> finds there).  so far, so good?
> 
>   that, of course, doesn't work, since all i've done is unload the
> tarball, and i'm told that i have some missing or unreadable files:
> 
>   prefs.php
>   conf.php
>   mime_drivers.php
>   nls.php
>   registry.php
> 
> which is fine -- i was certainly expecting to have to do more work,
> and i can now get into setting up those files.  everything sound good
> so far?
> 
>   i'll try to set them up to reproduce the settings from the current
> install, of course, and i'm assuming that i can point the new install
> at the current horde table that's already in mysql -- i really want
> the new install to take advantage of all the horde data that's been
> stored all this time.
> 
>   does this sound sane?  all i want to start with is getting an
> absolutely basic and up-to-date install running next to the existing
> one, and copy/reproduce that config info to the point where folks can
> log in.  after that, i'll have to add:
> 
>   gollem
>   hermes
>   imp
>   jonah
>   klutz
>   ... etc etc, all the stuff in the old install ...
> 
>   thoughts?
> 
> rday
> --
> 
> ========================================================================
> Robert P. J. Day                               Waterloo, Ontario, CANADA
> 
>         Linux Consulting, Training and Annoying Kernel Pedantry.
> 
> Web page:                                          http://crashcourse.ca
> Twitter:                                       http://twitter.com/rpjday
> ========================================================================
> -- 
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org


--------------------------------------------------------
Mauricio J. T. Tecles
Instituto de Biofisica Carlos Chagas Filho - UFRJ
Edificio do Centro de Ciencias da Saude, Bloco G
Av. Carlos Chagas Filho, 373
Cidade Universitaria, Ilha do Fundao
Rio de Janeiro, RJ
Brasil
21941-902
Telefone: 55 21 2562-6544
FAX: 55 21 2280-8193
mtecles at biof.ufrj.br


From rpjday at crashcourse.ca  Tue Aug 25 20:12:32 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Tue, 25 Aug 2009 16:12:32 -0400 (EDT)
Subject: [horde] my plan for upgrading my horde install
In-Reply-To: <4A941435.12688.17FDAF7@mtecles.biof.ufrj.br>
References: <alpine.LFD.2.00.0908251414510.6333@localhost>
	<4A941435.12688.17FDAF7@mtecles.biof.ufrj.br>
Message-ID: <alpine.LFD.2.00.0908251605220.7260@localhost>

On Tue, 25 Aug 2009, mtecles at biof.ufrj.br wrote:

> I don't know which Horde version you are using, but I think you
> should not do it like this, some upgrades need intermediate
> versions. Remember, upgrading means upgrading database also, not
> just replace Horde files. The upgrades scripts are in Horde
> applications and they are supposed to be used from one version to
> another.

  i know, i've been reading the UPGRADING document.  i have to move
from 3.0.9 to 3.3.4 -- that's going to require a number of steps,
obviously.

  as i read it (and i could be wrong), first i can run a number of
scripts to bring the horde mysql database up to date -- scripts that
take it from 3.0.x to 3.1.x to ... etc etc.  until the database is
fully up to date.

  once that's done, it can't possibly be used by the old software so
that's where i have to now install and configure the 3.3.4 version of
horde and, once that's done, *that* version will now be able to work
with the updated mysql database.  does that sound about correct?

  (i checked, and the 3.3.4 software does contain *all* of the
cumulative upgrade scripts, so there is enough there to bring the
database fully up to date.)

> Backup your database and Horde directory. Rename Horde directory,
> download the following version of yours (Horde and applications),
> read the UPGRADING docs, do the upgrade. Rename Horde directory,
> download the next following version (Horde and applications), read
> the UPGRADING docs, do the upgrade. Repeat this for each version
> until the newest.

  that sounds like a lot of work, to keep installing and configuring
every intermediate version.  i realize it's a safe way, but can't it
be done the way i've suggested -- bring the database up to date
quickly by running the appropriate update scripts, then install the
newest software and configure it to resemble the old setup.

  if people tell me that's a bad idea, then i can do it one step at a
time.

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From rpjday at crashcourse.ca  Tue Aug 25 20:23:34 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Tue, 25 Aug 2009 16:23:34 -0400 (EDT)
Subject: [horde] my plan for upgrading my horde install
In-Reply-To: <4A941435.12688.17FDAF7@mtecles.biof.ufrj.br>
References: <alpine.LFD.2.00.0908251414510.6333@localhost>
	<4A941435.12688.17FDAF7@mtecles.biof.ufrj.br>
Message-ID: <alpine.LFD.2.00.0908251618240.7357@localhost>


  let me suggest a more refined approach to my 3.0.9 -> 3.3.4 upgrade.
currently, there is a "horde" mysql database, with all of the
3.0.9-related horde data.  let's leave that where it is, and make a
copy of it, call it "horde334" or something like that.  (what's the
mysql command to just make a copy of an existing database under a
different name?  i guess i can look that up.)

  once "horde334" exists, do all the upgrade steps on *that*, and i
should be able to do that with the collection of scripts that come
with horde-3.3.4.

  once my horde334 database has been brought up to date, install
horde-3.3.4 and slowly and carefully configure it to resemble the old
setup, the main difference being that i obviously point it at the
"horde334" database, and i'm assuming it will use that database, and
not just blindly wipe it out and create a new, empty one.

  once that configuration is complete, i should be able to browse to
my new horde install and start work again, no?  is there anything
wrong with that logic?

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From morgan at orst.edu  Tue Aug 25 22:44:51 2009
From: morgan at orst.edu (Andrew Morgan)
Date: Tue, 25 Aug 2009 15:44:51 -0700 (PDT)
Subject: [horde] my plan for upgrading my horde install
In-Reply-To: <alpine.LFD.2.00.0908251618240.7357@localhost>
References: <alpine.LFD.2.00.0908251414510.6333@localhost>
	<4A941435.12688.17FDAF7@mtecles.biof.ufrj.br>
	<alpine.LFD.2.00.0908251618240.7357@localhost>
Message-ID: <alpine.DEB.2.00.0908251543070.14434@shell.onid.oregonstate.edu>

On Tue, 25 Aug 2009, Robert P. J. Day wrote:

>  let me suggest a more refined approach to my 3.0.9 -> 3.3.4 upgrade.
> currently, there is a "horde" mysql database, with all of the
> 3.0.9-related horde data.  let's leave that where it is, and make a
> copy of it, call it "horde334" or something like that.  (what's the
> mysql command to just make a copy of an existing database under a
> different name?  i guess i can look that up.)
>
>  once "horde334" exists, do all the upgrade steps on *that*, and i
> should be able to do that with the collection of scripts that come
> with horde-3.3.4.
>
>  once my horde334 database has been brought up to date, install
> horde-3.3.4 and slowly and carefully configure it to resemble the old
> setup, the main difference being that i obviously point it at the
> "horde334" database, and i'm assuming it will use that database, and
> not just blindly wipe it out and create a new, empty one.
>
>  once that configuration is complete, i should be able to browse to
> my new horde install and start work again, no?  is there anything
> wrong with that logic?

These are the steps I follow every time I upgrade Horde.  You don't need 
to install or use the intermediate versions of Horde.  Just follow all the 
instructions in the UPGRADING file.

It sounds like you have an older version of Horde that does not support 
the version of PHP you have installed now, so a Horde upgrade will be 
required.  I remember running into a similar problem at some point myself.

 	Andy

From lcr_2505 at hotmail.com  Tue Aug 25 23:18:50 2009
From: lcr_2505 at hotmail.com (Luis campo)
Date: Tue, 25 Aug 2009 23:18:50 +0000
Subject: [horde] Login over SSL
Message-ID: <SNT112-W41892DE54D0C445D786F3AEFF80@phx.gbl>


Dear sirs,

Is it possible to have only LOGIN Over ssl and the rest of the session over NO SSL ?

Thanks

Luis




_________________________________________________________________
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE

From rpjday at crashcourse.ca  Wed Aug 26 05:47:20 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Wed, 26 Aug 2009 01:47:20 -0400 (EDT)
Subject: [horde] my plan for upgrading my horde install
In-Reply-To: <alpine.DEB.2.00.0908251543070.14434@shell.onid.oregonstate.edu>
References: <alpine.LFD.2.00.0908251414510.6333@localhost>
	<4A941435.12688.17FDAF7@mtecles.biof.ufrj.br>
	<alpine.LFD.2.00.0908251618240.7357@localhost>
	<alpine.DEB.2.00.0908251543070.14434@shell.onid.oregonstate.edu>
Message-ID: <alpine.LFD.2.00.0908260137480.4228@localhost>

On Tue, 25 Aug 2009, Andrew Morgan wrote:

> On Tue, 25 Aug 2009, Robert P. J. Day wrote:
>
> >  let me suggest a more refined approach to my 3.0.9 -> 3.3.4
> > upgrade. currently, there is a "horde" mysql database, with all of
> > the 3.0.9-related horde data.  let's leave that where it is, and
> > make a copy of it, call it "horde334" or something like that.
> > (what's the mysql command to just make a copy of an existing
> > database under a different name?  i guess i can look that up.)
> >
> >  once "horde334" exists, do all the upgrade steps on *that*, and i
> > should be able to do that with the collection of scripts that come
> > with horde-3.3.4.
> >
> >  once my horde334 database has been brought up to date, install
> > horde-3.3.4 and slowly and carefully configure it to resemble the
> > old setup, the main difference being that i obviously point it at
> > the "horde334" database, and i'm assuming it will use that
> > database, and not just blindly wipe it out and create a new, empty
> > one.
> >
> >  once that configuration is complete, i should be able to browse
> > to my new horde install and start work again, no?  is there
> > anything wrong with that logic?
>
> These are the steps I follow every time I upgrade Horde.  You don't
> need to install or use the intermediate versions of Horde.  Just
> follow all the instructions in the UPGRADING file.
>
> It sounds like you have an older version of Horde that does not
> support the version of PHP you have installed now, so a Horde
> upgrade will be required.  I remember running into a similar problem
> at some point myself.

  that's *exactly* the situation i'm in -- the massive debian upgrade
pushed me to PHP5, so i'm forced to upgrade the horde installation
similarly.

  as i read it, i can first upgrade the horde mysql database using the
upgrade scripts that come with horde-3.3.4.  i don't actually need to
*install* horde-3-3-4, i just need to un-tar it to get those upgrade
scripts, correct?  and run them, one at a time, on the database, until
it's up to date.

  and rather than upgrade the primary horde database itself, i'm going
to create a copy of it, and upgrade that copy so i can preserve the
original one, just in case.  (the old database is called "horde", so
i'll just call the copy "horde334" and let mysql look after both of
them.)

  once i have that upgraded "horde334" database, i'm going to install
horde-3.3.4 next to the original horde, configure it as similarly as
possible, then just point it at the "horde334" database.  i'm assuming
that's really all i'll need, correct?  this installation is really
being used for only two things:

  1) kronolith calendar, so i'll check the upgrade info on that as
     well

  2) a non-horde-based ticket system, which is already up to date,
     so that's pretty much done, i just need to link it back into the
     horde menus

and it's really only the ticket system that these folks care about, so
that makes this upgrade particularly easy -- that's the first thing i
can get running, while any horde apps can be re-installed slowly and
carefully.

  does all that sound reasonable?

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From rpjday at crashcourse.ca  Wed Aug 26 06:42:29 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Wed, 26 Aug 2009 02:42:29 -0400 (EDT)
Subject: [horde] recommendation on using debian packages instead of tarball?
Message-ID: <alpine.LFD.2.00.0908260236190.4935@localhost>


  a question related to my earlier post on upgrading from 3.0.9 to
3.3.4 -- would it have made things easier if horde had been installed
via debian packages rather than just unloading the tarball?

  obviously, if one installs via tarball (which i have no problem
with, and that's how it's done here at the moment), then upgrading
from one debian version to the next would have had no effect on the
horde install, but that's what allowed it to get so out of sync with
the version of debian.

  what would have happened with a package-based install?  would the
upgrade process (from sarge to etch to lenny) have dragged horde along
with it, perhaps forcing the administrator to upgrade the database
each time?  i'm just curious.  and is there an opinion on how
well-constructed those debian packages are?  (or for any other OS,
like fedora?)

  and in case i haven't mentioned it, thanks to all who have been so
helpful thus far.

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From roberto.maurizzi at gmail.com  Wed Aug 26 07:00:14 2009
From: roberto.maurizzi at gmail.com (Roberto Maurizzi)
Date: Wed, 26 Aug 2009 09:00:14 +0200
Subject: [horde] my plan for upgrading my horde install
In-Reply-To: <alpine.LFD.2.00.0908260137480.4228@localhost>
References: <alpine.LFD.2.00.0908251414510.6333@localhost> 
	<4A941435.12688.17FDAF7@mtecles.biof.ufrj.br>
	<alpine.LFD.2.00.0908251618240.7357@localhost> 
	<alpine.DEB.2.00.0908251543070.14434@shell.onid.oregonstate.edu> 
	<alpine.LFD.2.00.0908260137480.4228@localhost>
Message-ID: <47823e30908260000r60ebc68cl62f273877216b6e2@mail.gmail.com>

>   1) kronolith calendar, so i'll check the upgrade info on that as
>     well
>

As a rule you should check for additional configuration files in
/horde/appname/config when you upgrade a Horde application and
edit/integrate so that their format is up to date with the new version:
sometimes there are new keywords or other changes. You should check che
*.dist files and either redo your customization starting with a fresh copy
of the *.dist file, or add to your old file the extra parameters, info, etc,
that are in the *.dist file of the new version. In particular if you
customize prefs.php you should carry over the customization but you have to
use the new version. Horde usually say something it there's a problem in
those files, but I had a case with Ansel I think where it simply didn't work
until I remembered to update prefs.php with the new one.

Kronolith is quite ok with "secondary" configuration files (there's only the
keywords.php and menu.php and I don't know if those were also available in
3.0.4...).

  does all that sound reasonable?


Yes... mainly because if something goes wrong you can go back anytime and do
other tests quicky :-)

Ciao,
  Roberto

From roberto.maurizzi at gmail.com  Wed Aug 26 07:07:24 2009
From: roberto.maurizzi at gmail.com (Roberto Maurizzi)
Date: Wed, 26 Aug 2009 09:07:24 +0200
Subject: [horde] recommendation on using debian packages instead of
	tarball?
In-Reply-To: <alpine.LFD.2.00.0908260236190.4935@localhost>
References: <alpine.LFD.2.00.0908260236190.4935@localhost>
Message-ID: <47823e30908260007w5ac049d3s6f0e123ce9b89303@mail.gmail.com>

2009/8/26 Robert P. J. Day <rpjday at crashcourse.ca>

>
>  a question related to my earlier post on upgrading from 3.0.9 to
> 3.3.4 -- would it have made things easier if horde had been installed
> via debian packages rather than just unloading the tarball?
>

If I remember correctly, I read somewhere on the web (or inside the debian
packages) a warning that upgrading to a different version isn't supported
(and I quite understand them: while a standard install is easy, things do
get quite complex if you go i.e. with LDAP preferences, different DBs,
etc.).
So chances are that on upgrades Horde stops working even if you don't get a
new PHP.
That could have changed since I looked at this more than a year ago, but
between this and unavailability of packages of the newer Horde versions, it
convinced me to go with the official tar.
For a new installation I'd consider using the Groupware or Webmail editions,
since they should be easier to upgrade.

Ciao,
  Roberto

From rpjday at crashcourse.ca  Wed Aug 26 07:12:07 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Wed, 26 Aug 2009 03:12:07 -0400 (EDT)
Subject: [horde] my plan for upgrading my horde install
In-Reply-To: <47823e30908260000r60ebc68cl62f273877216b6e2@mail.gmail.com>
References: <alpine.LFD.2.00.0908251414510.6333@localhost>
	<4A941435.12688.17FDAF7@mtecles.biof.ufrj.br>
	<alpine.LFD.2.00.0908251618240.7357@localhost>
	<alpine.DEB.2.00.0908251543070.14434@shell.onid.oregonstate.edu>
	<alpine.LFD.2.00.0908260137480.4228@localhost>
	<47823e30908260000r60ebc68cl62f273877216b6e2@mail.gmail.com>
Message-ID: <alpine.LFD.2.00.0908260308580.5644@localhost>

On Wed, 26 Aug 2009, Roberto Maurizzi wrote:

>
>       ? 1) kronolith calendar, so i'll check the upgrade info on that
>       as
>       ? ? well

 ... snip ...

> Kronolith is quite ok with "secondary" configuration files (there's
> only the keywords.php and menu.php and I don't know if those were
> also available in 3.0.4...).

  what makes this upcoming upgrade *really* simple is that the only
really critical info that needs to be carried over is the contents of
the phpSupport ticket system, which has nothing to do with horde --
it's just linked into the horde menu system, and that's already up to
date.

  the only other app they use is kronolith, and they already told me
that they're happy to just blow all that data away and start fresh
anyway.  in short, it looks like there is *no* required upgrading of
any actual horde apps.  that's going to make life easy.

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From lst_hoe02 at kwsoft.de  Wed Aug 26 07:35:31 2009
From: lst_hoe02 at kwsoft.de (lst_hoe02 at kwsoft.de)
Date: Wed, 26 Aug 2009 09:35:31 +0200
Subject: [horde] Empty tables regurlarly
In-Reply-To: <20090825093150.o0g8kk08wsow@bigworm.curecanti.org>
References: <20090821180803.12913d3yfq5l03wg@wiki.jusbaires.gov.ar>
	<20090823145531.13843aghj4hckfnk@neo.wg.de>
	<20090825100433.1359520y35nx6u4g@webmail.kwsoft.de>
	<20090825093150.o0g8kk08wsow@bigworm.curecanti.org>
Message-ID: <20090826093531.19506u0otl1ehucc@webmail.kwsoft.de>

Zitat von Michael M Slusarz <slusarz at horde.org>:

> Quoting lst_hoe02 at kwsoft.de:
>
>> Is there any maintenance going on for the potentially large tables  
>> like horde_histories and horde_syncml_map ?
>>
>> What is the proper way of purging/aging out for this tables?
>
> For horde_histories, there isn't.  But that's the whole point of a  
> table storing archived data.  Once you start purging, you destroy  
> the reason why the table exists in the first place.
>
> michael

Not really. The table is useful for finite historie eg. for SyncML but  
every system with always in and never out is doomed to fail some time  
in the future. I guess you also use logrotate on your machines, don't  
you.
We don't have a problem with this today but i can imagine this can get  
you in trouble on a aging installation with thousands of busy users  
doing SyncML with all sort of devices.

But as always YMMV

Regards

Andreas



From lst_hoe02 at kwsoft.de  Wed Aug 26 07:44:30 2009
From: lst_hoe02 at kwsoft.de (lst_hoe02 at kwsoft.de)
Date: Wed, 26 Aug 2009 09:44:30 +0200
Subject: [horde] any horde experts in K-W area who might have a couple
 hours?
In-Reply-To: <alpine.LFD.2.00.0908251504400.6738@localhost>
References: <alpine.LFD.2.00.0908251504400.6738@localhost>
Message-ID: <20090826094430.15736mx9i65n9n48@webmail.kwsoft.de>

Zitat von "Robert P. J. Day" <rpjday at crashcourse.ca>:

>
>   i'm starting to think that i might be getting out of my comfort zone
> here since i'm now looking at upgrading a 3.0.9 horde install to
> 3.3.4, and that's a long way to go for someone who's new at this.
>
>   if i make a snap decision and want to find someone local who wants
> to make a few bucks doing this and is *good* at it, anyone out there
> in the area who's available on *very* short notice?
>
> rday
>
> p.s.  if you don't know what "K-W" stands for, you're not local. :-)

With SSH there is no need to be local. Maybe have a look at  
http://www.horde.org/consulting/ . You can hire Horde developers for  
doing a smooth/sane upgrade if you are able to spent a few bucks.

Regards

Andreas


From rpjday at crashcourse.ca  Wed Aug 26 07:55:57 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Wed, 26 Aug 2009 03:55:57 -0400 (EDT)
Subject: [horde] any horde experts in K-W area who might have a couple
 hours?
In-Reply-To: <20090826094430.15736mx9i65n9n48@webmail.kwsoft.de>
References: <alpine.LFD.2.00.0908251504400.6738@localhost>
	<20090826094430.15736mx9i65n9n48@webmail.kwsoft.de>
Message-ID: <alpine.LFD.2.00.0908260345060.6765@localhost>

On Wed, 26 Aug 2009, lst_hoe02 at kwsoft.de wrote:

> Zitat von "Robert P. J. Day" <rpjday at crashcourse.ca>:
>
> >
> >  i'm starting to think that i might be getting out of my comfort
> > zone here since i'm now looking at upgrading a 3.0.9 horde install
> > to 3.3.4, and that's a long way to go for someone who's new at
> > this.
> >
> >  if i make a snap decision and want to find someone local who
> > wants to make a few bucks doing this and is *good* at it, anyone
> > out there in the area who's available on *very* short notice?
> >
> > rday
> >
> > p.s.  if you don't know what "K-W" stands for, you're not local. :-)
>
> With SSH there is no need to be local. Maybe have a look at
> http://www.horde.org/consulting/ . You can hire Horde developers for
> doing a smooth/sane upgrade if you are able to spent a few bucks.

  i saw that, but i would still have preferred to find someone local,
so i could watch over their shoulder and bug them with dumb questions.
:-)  but i think i have a handle on the situation now.

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From vilius at lnk.lt  Wed Aug 26 08:29:20 2009
From: vilius at lnk.lt (=?windows-1257?Q?Vilius_=D0umskas?=)
Date: Wed, 26 Aug 2009 11:29:20 +0300
Subject: [horde] Empty tables regurlarly
In-Reply-To: <20090826093531.19506u0otl1ehucc@webmail.kwsoft.de>
References: <20090821180803.12913d3yfq5l03wg@wiki.jusbaires.gov.ar>	<20090823145531.13843aghj4hckfnk@neo.wg.de>	<20090825100433.1359520y35nx6u4g@webmail.kwsoft.de>	<20090825093150.o0g8kk08wsow@bigworm.curecanti.org>
	<20090826093531.19506u0otl1ehucc@webmail.kwsoft.de>
Message-ID: <002501ca2627$4f323170$ed969450$@lt>

> > Quoting lst_hoe02 at kwsoft.de:
> >
> >> Is there any maintenance going on for the potentially large tables
> >> like horde_histories and horde_syncml_map ?
> >>
> >> What is the proper way of purging/aging out for this tables?
> >
> > For horde_histories, there isn't.  But that's the whole point of a
> > table storing archived data.  Once you start purging, you destroy
> > the reason why the table exists in the first place.
> >
> > michael
> 
> Not really. The table is useful for finite historie eg. for SyncML but
> every system with always in and never out is doomed to fail some time
> in the future. I guess you also use logrotate on your machines, don't
> you.
> We don't have a problem with this today but i can imagine this can get
> you in trouble on a aging installation with thousands of busy users
> doing SyncML with all sort of devices.

This is not how databases work. It doesn't really matter how much data (e.i.
rows) you have in the table. If the application programmed correctly and
database structure and setup done right it will always work fast. Database
doesn't need to go through all the rows to return 10 of them. Here we have
15years old of data in our Oracle db with more than 15bilion rows in one
table, but queries run just as fast as before. The magic of indexes :)

If on the other hand you are seeing slowness in SyncML because of big
history table, then SyncML code needs to be fixed, not the other way around.

Just my 0.02euro.

-- 
  Best Regards,

  Vilius ?umskas
  LNK TV IT manager
  mob.: +370 614 75713
  http://www.lnk.lt


From lst_hoe02 at kwsoft.de  Wed Aug 26 09:15:57 2009
From: lst_hoe02 at kwsoft.de (lst_hoe02 at kwsoft.de)
Date: Wed, 26 Aug 2009 11:15:57 +0200
Subject: [horde] Empty tables regurlarly
In-Reply-To: <002501ca2627$4f323170$ed969450$@lt>
References: <20090821180803.12913d3yfq5l03wg@wiki.jusbaires.gov.ar>
	<20090823145531.13843aghj4hckfnk@neo.wg.de>
	<20090825100433.1359520y35nx6u4g@webmail.kwsoft.de>
	<20090825093150.o0g8kk08wsow@bigworm.curecanti.org>
	<20090826093531.19506u0otl1ehucc@webmail.kwsoft.de>
	<002501ca2627$4f323170$ed969450$@lt>
Message-ID: <20090826111557.122127pjbabpcy80@webmail.kwsoft.de>

Zitat von Vilius ?umskas <vilius at lnk.lt>:

>>
>> Not really. The table is useful for finite historie eg. for SyncML but
>> every system with always in and never out is doomed to fail some time
>> in the future. I guess you also use logrotate on your machines, don't
>> you.
>> We don't have a problem with this today but i can imagine this can get
>> you in trouble on a aging installation with thousands of busy users
>> doing SyncML with all sort of devices.
>
> This is not how databases work. It doesn't really matter how much data (e.i.
> rows) you have in the table. If the application programmed correctly and
> database structure and setup done right it will always work fast. Database
> doesn't need to go through all the rows to return 10 of them. Here we have
> 15years old of data in our Oracle db with more than 15bilion rows in one
> table, but queries run just as fast as before. The magic of indexes :)

The fact that you *can* do it today should not be a excuse if it  
doesn't make sense and it *may* lead to trouble. I fail to see why one  
can need add/modify/delete records from years ago and users left a  
long time already.
Good housekeeping is never wrong.


> If on the other hand you are seeing slowness in SyncML because of big
> history table, then SyncML code needs to be fixed, not the other way around.

As said we don't have trouble until now but i like to know in advance  
before we bring features to broder public.

Regards

Andreas


From jan at horde.org  Wed Aug 26 09:49:37 2009
From: jan at horde.org (Jan Schneider)
Date: Wed, 26 Aug 2009 11:49:37 +0200
Subject: [horde] Empty tables regurlarly
In-Reply-To: <20090826111557.122127pjbabpcy80@webmail.kwsoft.de>
References: <20090821180803.12913d3yfq5l03wg@wiki.jusbaires.gov.ar>
	<20090823145531.13843aghj4hckfnk@neo.wg.de>
	<20090825100433.1359520y35nx6u4g@webmail.kwsoft.de>
	<20090825093150.o0g8kk08wsow@bigworm.curecanti.org>
	<20090826093531.19506u0otl1ehucc@webmail.kwsoft.de>
	<002501ca2627$4f323170$ed969450$@lt>
	<20090826111557.122127pjbabpcy80@webmail.kwsoft.de>
Message-ID: <20090826114937.16205wbz6jxsxasc@neo.wg.de>

Zitat von lst_hoe02 at kwsoft.de:

> Zitat von Vilius ?umskas <vilius at lnk.lt>:
>
>>>
>>> Not really. The table is useful for finite historie eg. for SyncML but
>>> every system with always in and never out is doomed to fail some time
>>> in the future. I guess you also use logrotate on your machines, don't
>>> you.
>>> We don't have a problem with this today but i can imagine this can get
>>> you in trouble on a aging installation with thousands of busy users
>>> doing SyncML with all sort of devices.
>>
>> This is not how databases work. It doesn't really matter how much data (e.i.
>> rows) you have in the table. If the application programmed correctly and
>> database structure and setup done right it will always work fast. Database
>> doesn't need to go through all the rows to return 10 of them. Here we have
>> 15years old of data in our Oracle db with more than 15bilion rows in one
>> table, but queries run just as fast as before. The magic of indexes :)
>
> The fact that you *can* do it today should not be a excuse if it  
> doesn't make sense and it *may* lead to trouble. I fail to see why  
> one can need add/modify/delete records from years ago and users left  
> a long time already.

That's why there is the removeUserData API in Horde. There is no need  
to keep data that will never be used again. But removing data because  
it is old is just plain wrong and has nothing to do with housekeeping.

> Good housekeeping is never wrong.
>
>
>> If on the other hand you are seeing slowness in SyncML because of big
>> history table, then SyncML code needs to be fixed, not the other way around.
>
> As said we don't have trouble until now but i like to know in  
> advance before we bring features to broder public.
>
> Regards
>
> Andreas
>
> -- 
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>



Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/


From jan at horde.org  Wed Aug 26 09:50:57 2009
From: jan at horde.org (Jan Schneider)
Date: Wed, 26 Aug 2009 11:50:57 +0200
Subject: [horde] Filters not working - help determining backend
In-Reply-To: <20090825085007.68461oyile3myqdc@sandaili.com>
References: <20090825085007.68461oyile3myqdc@sandaili.com>
Message-ID: <20090826115057.20153e9h8l7lit8g@neo.wg.de>

Zitat von Sandaili <me at sandaili.com>:

> I've installed the newest Groupware with Webmail. Everything that  
> needs to be working is, except the filtering.
>
> I know I need to let you all know what backend I am using, but I do  
> not know where to look that up. I have full adminstrative control,  
> so if someone can point me in the right direction, I will add that  
> information here so I can get some help. I would appreciate it very  
> much.
>
> The problem itself - currently no filters work. For example, I still  
> get mail from exampleuser at yahoo.com, even though  
> exampleuser at yahoo.com is in my blacklist and the blacklist is enabled.

If you installed the Groupware and didn't change anything, your  
backend is IMAP. See ingo/config/backends.php.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/


From jan at horde.org  Wed Aug 26 09:51:21 2009
From: jan at horde.org (Jan Schneider)
Date: Wed, 26 Aug 2009 11:51:21 +0200
Subject: [horde] Login over SSL
In-Reply-To: <SNT112-W41892DE54D0C445D786F3AEFF80@phx.gbl>
References: <SNT112-W41892DE54D0C445D786F3AEFF80@phx.gbl>
Message-ID: <20090826115121.10816cg3ik352b4s@neo.wg.de>

Zitat von Luis campo <lcr_2505 at hotmail.com>:

>
> Dear sirs,
>
> Is it possible to have only LOGIN Over ssl and the rest of the  
> session over NO SSL ?

Yes, see the configuration.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/


From lst_hoe02 at kwsoft.de  Wed Aug 26 10:06:24 2009
From: lst_hoe02 at kwsoft.de (lst_hoe02 at kwsoft.de)
Date: Wed, 26 Aug 2009 12:06:24 +0200
Subject: [horde] [OT] Bugtracker Problems
Message-ID: <20090826120624.10665fcnvwok4f0g@webmail.kwsoft.de>

Some of the bugtracker entries cause Whups to fail :

http://bugs.horde.org/ticket/7702
http://bugs.horde.org/ticket/8474

Fatal error: Call to a member function getImageDir() on a non-object  
in /var/www/dev.horde.org/horde/whups/lib/Whups.php on line 843

While others work as expected.

Should i log a bug against Whups ;-)

Regards

Andreas




From jan at horde.org  Wed Aug 26 10:58:04 2009
From: jan at horde.org (Jan Schneider)
Date: Wed, 26 Aug 2009 12:58:04 +0200
Subject: [horde] [OT] Bugtracker Problems
In-Reply-To: <20090826120624.10665fcnvwok4f0g@webmail.kwsoft.de>
References: <20090826120624.10665fcnvwok4f0g@webmail.kwsoft.de>
Message-ID: <20090826125804.12236a3rtwsszs84@neo.wg.de>

Zitat von lst_hoe02 at kwsoft.de:

> Some of the bugtracker entries cause Whups to fail :
>
> http://bugs.horde.org/ticket/7702
> http://bugs.horde.org/ticket/8474
>
> Fatal error: Call to a member function getImageDir() on a non-object  
> in /var/www/dev.horde.org/horde/whups/lib/Whups.php on line 843
>
> While others work as expected.
>
> Should i log a bug against Whups ;-)

http://bugs.horde.org/ticket/8526

> Regards
>
> Andreas
>
>
>
> -- 
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>



Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/


From lst_hoe02 at kwsoft.de  Wed Aug 26 11:18:27 2009
From: lst_hoe02 at kwsoft.de (lst_hoe02 at kwsoft.de)
Date: Wed, 26 Aug 2009 13:18:27 +0200
Subject: [horde] Empty tables regurlarly
In-Reply-To: <20090826114937.16205wbz6jxsxasc@neo.wg.de>
References: <20090821180803.12913d3yfq5l03wg@wiki.jusbaires.gov.ar>
	<20090823145531.13843aghj4hckfnk@neo.wg.de>
	<20090825100433.1359520y35nx6u4g@webmail.kwsoft.de>
	<20090825093150.o0g8kk08wsow@bigworm.curecanti.org>
	<20090826093531.19506u0otl1ehucc@webmail.kwsoft.de>
	<002501ca2627$4f323170$ed969450$@lt>
	<20090826111557.122127pjbabpcy80@webmail.kwsoft.de>
	<20090826114937.16205wbz6jxsxasc@neo.wg.de>
Message-ID: <20090826131827.78337bl6xrg4b9s8@webmail.kwsoft.de>

Zitat von Jan Schneider <jan at horde.org>:

> Zitat von lst_hoe02 at kwsoft.de:
>
>> Zitat von Vilius ?umskas <vilius at lnk.lt>:
>>
>>>>
>>>> Not really. The table is useful for finite historie eg. for SyncML but
>>>> every system with always in and never out is doomed to fail some time
>>>> in the future. I guess you also use logrotate on your machines, don't
>>>> you.
>>>> We don't have a problem with this today but i can imagine this can get
>>>> you in trouble on a aging installation with thousands of busy users
>>>> doing SyncML with all sort of devices.
>>>
>>> This is not how databases work. It doesn't really matter how much  
>>> data (e.i.
>>> rows) you have in the table. If the application programmed correctly and
>>> database structure and setup done right it will always work fast. Database
>>> doesn't need to go through all the rows to return 10 of them. Here we have
>>> 15years old of data in our Oracle db with more than 15bilion rows in one
>>> table, but queries run just as fast as before. The magic of indexes :)
>>
>> The fact that you *can* do it today should not be a excuse if it  
>> doesn't make sense and it *may* lead to trouble. I fail to see why  
>> one can need add/modify/delete records from years ago and users  
>> left a long time already.
>
> That's why there is the removeUserData API in Horde. There is no  
> need to keep data that will never be used again. But removing data  
> because it is old is just plain wrong and has nothing to do with  
> housekeeping.

Not because the data are old but because they are old &  
unused/unusable. This is housekeeping but it is just a matter of  
preference if one tend to throw away more & earlier or keep as long as  
it does not hurt. I tend to be in the first group while the actual  
design is more toward the second.

Never mind, i just asked if i have overlooked something.

Many thanks

Andreas


From rpjday at crashcourse.ca  Wed Aug 26 13:26:28 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Wed, 26 Aug 2009 09:26:28 -0400 (EDT)
Subject: [horde] the order of doing a horde upgrade
Message-ID: <alpine.LFD.2.00.0908260919570.3128@localhost>


  just realized something critical, and want to verify it.  to move
from 3.0.9 to 3.3.4, i installed 3.3.4 in a sibling directory and, as
a test, browsed explicitly to that directory and got a generic new
horde screen.  perfect.  obviously nothing there as it represents
simply unloading the horde-3.3.4 tarball -- no configuration at all
yet.

  my next step was to go into the configuration process and, tab by
tab, reproduce what i see in the old (3.0.9) conf.php file, *except*
that, for safety's sake, i'm setting the new install to refer to a
*new* horde database, "horde334", which will represent the old one
after it's been upgraded (so i can preserve the old "horde" database,
for whatever reason).

  i hadn't set up the new horde database yet, but went through the
3.3.4 configuration, saved it, then tried to connect but failed to get
authenticated, and i'm *guessing* that, since the new install has been
set up to point to the new "horde334" database, and that database
doesn't even *exist* yet, i kind of screwed myself.  (default admin
and password, anyone?)

  in any event, this suggests that the very first thing i should do is
get that database upgraded and installed, *after* which i should
configure horde-3.3.4 to point to it.  is that pretty much the fatal
mistake i made here?  doing those things in the wrong order?  thanks.

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From lcr_2505 at hotmail.com  Wed Aug 26 13:59:34 2009
From: lcr_2505 at hotmail.com (Luis campo)
Date: Wed, 26 Aug 2009 13:59:34 +0000
Subject: [horde] Login over SSL
Message-ID: <SNT112-W50B035F68F87811C1528BCEFF70@phx.gbl>


Dear sirs,

Is it possible to have only LOGIN Over ssl and the rest of the session over NO SSL ?

Thanks

Luis
_________________________________________________________________
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx

From rpjday at crashcourse.ca  Wed Aug 26 14:01:25 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Wed, 26 Aug 2009 10:01:25 -0400 (EDT)
Subject: [horde] upgrading a *new* database doesn't look like it's going to
	work
Message-ID: <alpine.LFD.2.00.0908260950460.3522@localhost>


  looks like my carefully-designed plan for upgrading the horde
database won't work.  i'm looking at the steps for 3.0.x->3.1.x, and
the first step is fine:

  # mysql ... blah blah ... db_name ... < 3.0_to_3.1.mysql.sql

that appeared to work just fine since you have to *specify* the name
of the database to affect.  (the end result appeared to be to just add
the horde_histories table to the new database, is that correct?)

  the second step, running "move_history_out_of_datatree.php", doesn't
look like it's possible on my *new* database since i don't get to
specify the name of the new database.  instead, i'm *guessing* that it
has to be run from within the old horde installation, from which it
will somehow pick up the old database name and affect only *that*
(original) database.  is that correct?

  perhaps i should just bite the bullet and upgrade the old database
in place. it seems like that's going to be easier, if i understand
what i'm reading properly.

rday

afterthought:  a couple suggestions.  if what i wrote above is
correct, it might be worth extending the upgrade scripts to allow one
to specify exactly which database to modify.  being able to do all
that upgrading on a *copy* of the actual horde DB would seem to be a
safe way to approach this.

also, in the documentation, i think it would be *immensely* helpful
to, after each command, describe the change that should have taken
place so the user can verify it.

for example, after i ran 3.0_to_3.1.mysql,sql, i got no feedback
whatsoever, so i had no idea if it ran and worked, ran and failed or
what.  it would have been useful for the docs to have said something
like, "after that script runs, you can check that the database now has
a new 'horde_histories' table."  that sort of sanity checking can
really put a user's mind at ease.


--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From rob.macgregor at gmail.com  Wed Aug 26 14:11:39 2009
From: rob.macgregor at gmail.com (Rob MacGregor)
Date: Wed, 26 Aug 2009 15:11:39 +0100
Subject: [horde] Login over SSL
In-Reply-To: <SNT112-W50B035F68F87811C1528BCEFF70@phx.gbl>
References: <SNT112-W50B035F68F87811C1528BCEFF70@phx.gbl>
Message-ID: <43ea8d070908260711k2a2f563ekaf596f2fe6a98c4b@mail.gmail.com>

On Wed, Aug 26, 2009 at 14:59, Luis campo<lcr_2505 at hotmail.com> wrote:
>
> Dear sirs,
>
> Is it possible to have only LOGIN Over ssl and the rest of the session over NO SSL ?

http://lists.horde.org/archives/horde/Week-of-Mon-20090824/038056.html

-- 
                 Please keep list traffic on the list.

Rob MacGregor
      Whoever fights monsters should see to it that in the process he
        doesn't become a monster.                  Friedrich Nietzsche

From lst_hoe02 at kwsoft.de  Wed Aug 26 14:18:32 2009
From: lst_hoe02 at kwsoft.de (lst_hoe02 at kwsoft.de)
Date: Wed, 26 Aug 2009 16:18:32 +0200
Subject: [horde] upgrading a *new* database doesn't look like it's going
 to work
In-Reply-To: <alpine.LFD.2.00.0908260950460.3522@localhost>
References: <alpine.LFD.2.00.0908260950460.3522@localhost>
Message-ID: <20090826161832.18431j3skmfcgnr4@webmail.kwsoft.de>

Zitat von "Robert P. J. Day" <rpjday at crashcourse.ca>:

>
>   looks like my carefully-designed plan for upgrading the horde
> database won't work.  i'm looking at the steps for 3.0.x->3.1.x, and
> the first step is fine:
>
>   # mysql ... blah blah ... db_name ... < 3.0_to_3.1.mysql.sql
>
> that appeared to work just fine since you have to *specify* the name
> of the database to affect.  (the end result appeared to be to just add
> the horde_histories table to the new database, is that correct?)
>
>   the second step, running "move_history_out_of_datatree.php", doesn't
> look like it's possible on my *new* database since i don't get to
> specify the name of the new database.  instead, i'm *guessing* that it
> has to be run from within the old horde installation, from which it
> will somehow pick up the old database name and affect only *that*
> (original) database.  is that correct?
>
>   perhaps i should just bite the bullet and upgrade the old database
> in place. it seems like that's going to be easier, if i understand
> what i'm reading properly.
>
> rday
>
> afterthought:  a couple suggestions.  if what i wrote above is
> correct, it might be worth extending the upgrade scripts to allow one
> to specify exactly which database to modify.  being able to do all
> that upgrading on a *copy* of the actual horde DB would seem to be a
> safe way to approach this.
>
> also, in the documentation, i think it would be *immensely* helpful
> to, after each command, describe the change that should have taken
> place so the user can verify it.
>
> for example, after i ran 3.0_to_3.1.mysql,sql, i got no feedback
> whatsoever, so i had no idea if it ran and worked, ran and failed or
> what.  it would have been useful for the docs to have said something
> like, "after that script runs, you can check that the database now has
> a new 'horde_histories' table."  that sort of sanity checking can
> really put a user's mind at ease.

My personal suggestion :
- Make a dump of your Horde database and import it to a new database
- Create a second Virtual Webhost with a copy of the old Horde installation
- Update the copy of Horde one Application by one starting with Horde  
by the following
        - Use new Horde and copy all additional Apps (IMP/Turba etc.) over
        - Alter the basic config files to match your previous settings
          DO NOT COPY THE OLD ONES IN PLACE, but copy the *.dist files  
and alter them.
        - Use the update scripts after checked that you have correct DB-Schema
        - Repeat for the Applications using Horde

With this you always have a working (old) installation and you can  
start from scratch if something fails horrible.
If you have finished you can exchange old/new Horde webroot and the  
old/new database. If you have working users at the old installation  
you must take it offline and repeat the steps for database  
update/migration-scripts on the old database to get the latest changes.

Regards

Andreas




From rpjday at crashcourse.ca  Wed Aug 26 14:29:12 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Wed, 26 Aug 2009 10:29:12 -0400 (EDT)
Subject: [horde] upgrading a *new* database doesn't look like it's going
 to work
In-Reply-To: <20090826161832.18431j3skmfcgnr4@webmail.kwsoft.de>
References: <alpine.LFD.2.00.0908260950460.3522@localhost>
	<20090826161832.18431j3skmfcgnr4@webmail.kwsoft.de>
Message-ID: <alpine.LFD.2.00.0908261018540.3796@localhost>

On Wed, 26 Aug 2009, lst_hoe02 at kwsoft.de wrote:

> Zitat von "Robert P. J. Day" <rpjday at crashcourse.ca>:
>
> >
> >  looks like my carefully-designed plan for upgrading the horde
> > database won't work.  i'm looking at the steps for 3.0.x->3.1.x, and
> > the first step is fine:
> >
> >  # mysql ... blah blah ... db_name ... < 3.0_to_3.1.mysql.sql
> >
> > that appeared to work just fine since you have to *specify* the name
> > of the database to affect.  (the end result appeared to be to just add
> > the horde_histories table to the new database, is that correct?)
> >
> >  the second step, running "move_history_out_of_datatree.php", doesn't
> > look like it's possible on my *new* database since i don't get to
> > specify the name of the new database.  instead, i'm *guessing* that it
> > has to be run from within the old horde installation, from which it
> > will somehow pick up the old database name and affect only *that*
> > (original) database.  is that correct?
> >
> >  perhaps i should just bite the bullet and upgrade the old database
> > in place. it seems like that's going to be easier, if i understand
> > what i'm reading properly.
> >
> > rday
> >
> > afterthought:  a couple suggestions.  if what i wrote above is
> > correct, it might be worth extending the upgrade scripts to allow one
> > to specify exactly which database to modify.  being able to do all
> > that upgrading on a *copy* of the actual horde DB would seem to be a
> > safe way to approach this.
> >
> > also, in the documentation, i think it would be *immensely* helpful
> > to, after each command, describe the change that should have taken
> > place so the user can verify it.
> >
> > for example, after i ran 3.0_to_3.1.mysql,sql, i got no feedback
> > whatsoever, so i had no idea if it ran and worked, ran and failed or
> > what.  it would have been useful for the docs to have said something
> > like, "after that script runs, you can check that the database now has
> > a new 'horde_histories' table."  that sort of sanity checking can
> > really put a user's mind at ease.
>
> My personal suggestion :
> - Make a dump of your Horde database and import it to a new database
> - Create a second Virtual Webhost with a copy of the old Horde installation
> - Update the copy of Horde one Application by one starting with Horde by the
> following
>       - Use new Horde and copy all additional Apps (IMP/Turba etc.) over
>       - Alter the basic config files to match your previous settings
>         DO NOT COPY THE OLD ONES IN PLACE, but copy the *.dist files and alter
> them.
>       - Use the update scripts after checked that you have correct DB-Schema
>       - Repeat for the Applications using Horde

  yes, i realize that that would work, but i was really hoping to not
have to go through setting up every intermediate version of horde
between 3.0.9 and 3.3.4.  mostly, what would make this easy (as long
as i am correctly understanding those upgrade scripts) are upgrade
scripts that can be run *completely* standalone, outside the context
of any horde install.

  consider the following:  someone used to have horde-3.0.9 running
and has an old horde mysql database that's been gathering dust.
suddenly, they want to start running horde and the current version is
3.3.4.  (sound familiar?)  so, how much work would it take to upgrade
that database to be compatible and start using it?

  what would be ideal would be upgrade scripts that can be run
entirely standalone (if that's possible, maybe it isn't since i'm
still learning this stuff).  the first upgrade script for 3.0->3.1 has
that property -- you point it at a mysql database, and it does the
first upgrade step.  and you can run it from anywhere.

  the second upgrade script for 3.0->3.1 (move history) does *not*
have that property since it clearly(?) has to be run in the context of
a horde install.  so this seems to suggest that i really do have to
install every intermediate version of horde (or at least 3.1), do that
upgrade, install the next version, etc, etc.  that's painful.

  if there's no way around that, then i'll do it.  but it would have
been nice if that wasn't necessary.

rday

p.s.  the 3.1->3.2 mysql upgrade script appears capable of running
standalone as well.

--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From lst_hoe02 at kwsoft.de  Wed Aug 26 14:49:19 2009
From: lst_hoe02 at kwsoft.de (lst_hoe02 at kwsoft.de)
Date: Wed, 26 Aug 2009 16:49:19 +0200
Subject: [horde] upgrading a *new* database doesn't look like it's going
 to work
In-Reply-To: <alpine.LFD.2.00.0908261018540.3796@localhost>
References: <alpine.LFD.2.00.0908260950460.3522@localhost>
	<20090826161832.18431j3skmfcgnr4@webmail.kwsoft.de>
	<alpine.LFD.2.00.0908261018540.3796@localhost>
Message-ID: <20090826164919.110385yctkic8wog@webmail.kwsoft.de>

Zitat von "Robert P. J. Day" <rpjday at crashcourse.ca>:

> On Wed, 26 Aug 2009, lst_hoe02 at kwsoft.de wrote:
>
>> Zitat von "Robert P. J. Day" <rpjday at crashcourse.ca>:
>>
>> >
>> >  looks like my carefully-designed plan for upgrading the horde
>> > database won't work.  i'm looking at the steps for 3.0.x->3.1.x, and
>> > the first step is fine:
>> >
>> >  # mysql ... blah blah ... db_name ... < 3.0_to_3.1.mysql.sql
>> >
>> > that appeared to work just fine since you have to *specify* the name
>> > of the database to affect.  (the end result appeared to be to just add
>> > the horde_histories table to the new database, is that correct?)
>> >
>> >  the second step, running "move_history_out_of_datatree.php", doesn't
>> > look like it's possible on my *new* database since i don't get to
>> > specify the name of the new database.  instead, i'm *guessing* that it
>> > has to be run from within the old horde installation, from which it
>> > will somehow pick up the old database name and affect only *that*
>> > (original) database.  is that correct?
>> >
>> >  perhaps i should just bite the bullet and upgrade the old database
>> > in place. it seems like that's going to be easier, if i understand
>> > what i'm reading properly.
>> >
>> > rday
>> >
>> > afterthought:  a couple suggestions.  if what i wrote above is
>> > correct, it might be worth extending the upgrade scripts to allow one
>> > to specify exactly which database to modify.  being able to do all
>> > that upgrading on a *copy* of the actual horde DB would seem to be a
>> > safe way to approach this.
>> >
>> > also, in the documentation, i think it would be *immensely* helpful
>> > to, after each command, describe the change that should have taken
>> > place so the user can verify it.
>> >
>> > for example, after i ran 3.0_to_3.1.mysql,sql, i got no feedback
>> > whatsoever, so i had no idea if it ran and worked, ran and failed or
>> > what.  it would have been useful for the docs to have said something
>> > like, "after that script runs, you can check that the database now has
>> > a new 'horde_histories' table."  that sort of sanity checking can
>> > really put a user's mind at ease.
>>
>> My personal suggestion :
>> - Make a dump of your Horde database and import it to a new database
>> - Create a second Virtual Webhost with a copy of the old Horde installation
>> - Update the copy of Horde one Application by one starting with Horde by the
>> following
>>       - Use new Horde and copy all additional Apps (IMP/Turba etc.) over
>>       - Alter the basic config files to match your previous settings
>>         DO NOT COPY THE OLD ONES IN PLACE, but copy the *.dist  
>> files and alter
>> them.
>>       - Use the update scripts after checked that you have correct DB-Schema
>>       - Repeat for the Applications using Horde
>
>   yes, i realize that that would work, but i was really hoping to not
> have to go through setting up every intermediate version of horde
> between 3.0.9 and 3.3.4.  mostly, what would make this easy (as long
> as i am correctly understanding those upgrade scripts) are upgrade
> scripts that can be run *completely* standalone, outside the context
> of any horde install.

You don't need every intermediate version of Horde, the most recent  
will be sufficient. You only have to apply all intermediate DB-schema  
changes if you don't create the DB from scratch. You even should be  
able to "cat" the schema scripts together and only use it once, but  
checking for the end result is always recommended.


>   consider the following:  someone used to have horde-3.0.9 running
> and has an old horde mysql database that's been gathering dust.
> suddenly, they want to start running horde and the current version is
> 3.3.4.  (sound familiar?)  so, how much work would it take to upgrade
> that database to be compatible and start using it?

-Apply all schema changes since 3.0. If you prepare in advance this  
will not even take a minute to actually apply.
- Now the trickier Part : You need a new working Horde version to run  
the update scripts. If your brave this can be done with a separate  
Webroot pointing to the same database ;-)

With this you have a starting point to upgrade all the rest of the  
apps with the Horde GUI and the update scripts from the apps  
(DB-Schema changes).

This is not something finished in a minute and should never be done on  
a bigger installation without testing.

>   what would be ideal would be upgrade scripts that can be run
> entirely standalone (if that's possible, maybe it isn't since i'm
> still learning this stuff).  the first upgrade script for 3.0->3.1 has
> that property -- you point it at a mysql database, and it does the
> first upgrade step.  and you can run it from anywhere.

There is work in progress with the Webmail Edition  
(http://www.horde.org/webmail/) but there are to many  
customizations/settings to get this automatically.

>
>   the second upgrade script for 3.0->3.1 (move history) does *not*
> have that property since it clearly(?) has to be run in the context of
> a horde install.  so this seems to suggest that i really do have to
> install every intermediate version of horde (or at least 3.1), do that
> upgrade, install the next version, etc, etc.  that's painful.

As said the update script should run fine with Horde 3.3.4
There are also scripts which you simply can skip. If you don't use  
"groups" at the moment there is no need to alter them.

Regards

Andreas




From rpjday at crashcourse.ca  Wed Aug 26 15:03:47 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Wed, 26 Aug 2009 11:03:47 -0400 (EDT)
Subject: [horde] upgrading a *new* database doesn't look like it's going
 to work
In-Reply-To: <20090826164919.110385yctkic8wog@webmail.kwsoft.de>
References: <alpine.LFD.2.00.0908260950460.3522@localhost>
	<20090826161832.18431j3skmfcgnr4@webmail.kwsoft.de>
	<alpine.LFD.2.00.0908261018540.3796@localhost>
	<20090826164919.110385yctkic8wog@webmail.kwsoft.de>
Message-ID: <alpine.LFD.2.00.0908261103140.4246@localhost>


   ... massive snip ...

  let me digest all of that, and i'll probably have another question
or two later.

rday
--


========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From rpjday at crashcourse.ca  Wed Aug 26 15:15:37 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Wed, 26 Aug 2009 11:15:37 -0400
Subject: [horde] expanding on the "pear install MDB2_Schema" step during
	upgrade
Message-ID: <20090826111537.82grwwgw68kk04co@crashcourse.ca>

   unrelated to what's been going on so far, i read ahead and in the  
3.2.x -> 3.3.x upgrade step, the user is told to:

   #  pear install MDB2_Schema

from a position of *total* pear ignorance, i typed exactly that and got:

Failed to download pear/MDB2_Schema within preferred state "stable",  
latest release is version 0.8.5, stability "beta", use  
"channel://pear.php.net/MDB2_Schema-0.8.5" to install
Cannot initialize 'channel://pear.php.net/MDB2_Schema', invalid or  
missing package file
Package "channel://pear.php.net/MDB2_Schema" is not valid
install failed


   that's exactly the kind of thing that throws someone off.  based on  
what i read, it would appear that i'm configured to only allow  
"stable" content, while MDB2_Schema-0.8.5 is labelled as "beta", is  
that why it's failing?

   if i run:

   # pear config-show

i can see:

...
Preferred Package State        preferred_state  stable
...

   i'm going to guess that i just have to switch that to accept beta  
content, yes?  it shouldn't be hard for me to figure out how, but  
that's *precisely* the sort of thing that should be addressed in the  
documentation -- what might go wrong at various stages and how to fix  
it.

rday




From jolumape_al at hotmail.com  Wed Aug 26 15:19:20 2009
From: jolumape_al at hotmail.com (Jose Luis Marin Perez)
Date: Wed, 26 Aug 2009 10:19:20 -0500
Subject: [horde] Login over SSL
In-Reply-To: <20090826115121.10816cg3ik352b4s@neo.wg.de>
References: <SNT112-W41892DE54D0C445D786F3AEFF80@phx.gbl>
	<20090826115121.10816cg3ik352b4s@neo.wg.de>
Message-ID: <COL103-W23CF85A04D62C30A70BB698F70@phx.gbl>


Dear Sirs, 

I'm also interested to use SSL only for login, could please tell me in which part of the documentation could find information? 

Thanks
 

Jose Luis
 
> Date: Wed, 26 Aug 2009 11:51:21 +0200
> From: jan at horde.org
> To: horde at lists.horde.org
> Subject: Re: [horde] Login over SSL
> 
> Zitat von Luis campo <lcr_2505 at hotmail.com>:
> 
> >
> > Dear sirs,
> >
> > Is it possible to have only LOGIN Over ssl and the rest of the 
> > session over NO SSL ?
> 
> Yes, see the configuration.
> 
> Jan.
> 
> -- 
> Do you need professional PHP or Horde consulting?
> http://horde.org/consulting/
> 
> -- 
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org

_________________________________________________________________
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE

From rpjday at crashcourse.ca  Wed Aug 26 15:18:25 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Wed, 26 Aug 2009 11:18:25 -0400
Subject: [horde] expanding on the "pear install MDB2_Schema" step	during
	upgrade
In-Reply-To: <20090826111537.82grwwgw68kk04co@crashcourse.ca>
References: <20090826111537.82grwwgw68kk04co@crashcourse.ca>
Message-ID: <20090826111825.skff453ogk844800@crashcourse.ca>

Quoting "Robert P. J. Day" <rpjday at crashcourse.ca>:

>   unrelated to what's been going on so far, i read ahead and in the
> 3.2.x -> 3.3.x upgrade step, the user is told to:
>
>   #  pear install MDB2_Schema
>
> from a position of *total* pear ignorance, i typed exactly that and got:
>
> Failed to download pear/MDB2_Schema within preferred state "stable",
> latest release is version 0.8.5, stability "beta", use
> "channel://pear.php.net/MDB2_Schema-0.8.5" to install
> Cannot initialize 'channel://pear.php.net/MDB2_Schema', invalid or
> missing package file
> Package "channel://pear.php.net/MDB2_Schema" is not valid
> install failed
>
>
>   that's exactly the kind of thing that throws someone off.  based on
> what i read, it would appear that i'm configured to only allow "stable"
> content, while MDB2_Schema-0.8.5 is labelled as "beta", is that why
> it's failing?
>
>   if i run:
>
>   # pear config-show
>
> i can see:
>
> ...
> Preferred Package State        preferred_state  stable
> ...
>
>   i'm going to guess that i just have to switch that to accept beta
> content, yes?  it shouldn't be hard for me to figure out how, but
> that's *precisely* the sort of thing that should be addressed in the
> documentation -- what might go wrong at various stages and how to fix
> it.

   by the way, the solution(s):

http://www.ducea.com/2008/02/01/installing-pear-beta-packages/

rday




From lst_hoe02 at kwsoft.de  Wed Aug 26 15:30:29 2009
From: lst_hoe02 at kwsoft.de (lst_hoe02 at kwsoft.de)
Date: Wed, 26 Aug 2009 17:30:29 +0200
Subject: [horde] Login over SSL
In-Reply-To: <COL103-W23CF85A04D62C30A70BB698F70@phx.gbl>
References: <SNT112-W41892DE54D0C445D786F3AEFF80@phx.gbl>
	<20090826115121.10816cg3ik352b4s@neo.wg.de>
	<COL103-W23CF85A04D62C30A70BB698F70@phx.gbl>
Message-ID: <20090826173029.65554vt59ie65no0@webmail.kwsoft.de>

Zitat von Jose Luis Marin Perez <jolumape_al at hotmail.com>:

>
> Dear Sirs,
>
> I'm also interested to use SSL only for login, could please tell me  
> in which part of the documentation could find information?
>
> Thanks


Login as administrative user to horde
go to "Administration" -> "Konfiguration" -> "Horde"
and set in the "general" tab in URL-settings $conf[use_ssl] to the  
appropriate value.

Regards

Andreas



From rpjday at crashcourse.ca  Wed Aug 26 15:29:41 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Wed, 26 Aug 2009 11:29:41 -0400 (EDT)
Subject: [horde] upgrading a *new* database doesn't look like it's going
 to work
In-Reply-To: <20090826164919.110385yctkic8wog@webmail.kwsoft.de>
References: <alpine.LFD.2.00.0908260950460.3522@localhost>
	<20090826161832.18431j3skmfcgnr4@webmail.kwsoft.de>
	<alpine.LFD.2.00.0908261018540.3796@localhost>
	<20090826164919.110385yctkic8wog@webmail.kwsoft.de>
Message-ID: <alpine.LFD.2.00.0908261119180.4384@localhost>

On Wed, 26 Aug 2009, lst_hoe02 at kwsoft.de wrote:

> You don't need every intermediate version of Horde, the most recent
> will be sufficient.

  so far, so good.  what i have is the following:

  .../horde/...    (existing, 3.0.9 install)
  .../horde334/... (new, unloaded, pristine 3.3.4 tarball)

  let's leave the horde apps *completely* out of this, since all i
want to do is get the upgraded *framework* in place and, in fact, the
only critical app i want to get up and running is a NON-horde ticket
system which is already up to date, so that will be trivial.  in
short, all i'm after is to upgrade the horde framework itself, nothing
more.

  the (old) mysql horde database is named "horde", and it's already
had the 3.0_to_3.1.mysql.sql upgrade script run on it -- i can verify
that since that database has a new horde_histories table it didn't
have before.  so that first upgrade step has been done.

  at this point ... what?  as you point out, i need to run the second
3.0->3.1 upgrade script (move history out of datatree) within the
confines of a horde install.  but can i run it within the confines of
a 3.3.4 horde install?

  as in, at some point, i'm going to go into the 3.3.4 configuration
and start filling in config info, based on what i can read out of the
old 3.0.9 conf.php file.  but can i point the 3.3.4 install at that
old database?  will that be compatible?  because if it is, that sounds
like it would solve my problem.  the 3.3.4 install would then be
running off of the *old* database, at which point i can do the rest of
the upgrade steps.  is that possible?  will a 3.3.4 install accept
being configured against a 3.0.9 format database?  or am i just
hopelessly confused by now?

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From rpjday at crashcourse.ca  Wed Aug 26 15:36:59 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Wed, 26 Aug 2009 11:36:59 -0400 (EDT)
Subject: [horde] upgrading a *new* database doesn't look like it's going
 to work
In-Reply-To: <20090826164919.110385yctkic8wog@webmail.kwsoft.de>
References: <alpine.LFD.2.00.0908260950460.3522@localhost>
	<20090826161832.18431j3skmfcgnr4@webmail.kwsoft.de>
	<alpine.LFD.2.00.0908261018540.3796@localhost>
	<20090826164919.110385yctkic8wog@webmail.kwsoft.de>
Message-ID: <alpine.LFD.2.00.0908261133220.4511@localhost>

On Wed, 26 Aug 2009, lst_hoe02 at kwsoft.de wrote:

> -Apply all schema changes since 3.0. If you prepare in advance this
> will not even take a minute to actually apply.

> - Now the trickier Part : You need a new working Horde version to
> run the update scripts. If your brave this can be done with a
> separate Webroot pointing to the same database ;-)

  (just about to head out for lunch, so i'll dash this off.)

  ah, i think i see what you're getting at (maybe).  even without a
working horde install, i can certainly run the scripts that
represent just *schema* changes, since they can be done outside the
context of a working install.

  however, some of the other upgrade steps (move history out of
datatree) need a working install but they can be left until later, is
that what you're saying?  so i can upgrade the DB with all the
possible schema changes, then configure 3.3.4 to refer to that DB, and
finally go back and run the scripts that needed an install context.
is that what you're suggesting.

  off to lunch.  back in a bit.

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From mtecles at biof.ufrj.br  Wed Aug 26 15:37:12 2009
From: mtecles at biof.ufrj.br (mtecles at biof.ufrj.br)
Date: Wed, 26 Aug 2009 12:37:12 -0300
Subject: [horde] expanding on the "pear install MDB2_Schema" step during
	upgrade
In-Reply-To: <20090826111825.skff453ogk844800@crashcourse.ca>
References: <20090826111537.82grwwgw68kk04co@crashcourse.ca>,
	<20090826111825.skff453ogk844800@crashcourse.ca>
Message-ID: <4A952C78.15347.735DD0@mtecles.biof.ufrj.br>

Sorry, resending to the list.

You should install the respective DB driver. At the time I upgraded 
from Horde 3.1.5 to 3.3.4 I used a beta version:

pear install -a MDB2-2.5.0b2 MDB2_Driver_mysql-1.5.0b2 
MDB2_Driver_mysqli-1.5.0b2 MDB2_Schema-0.8.4

I believe that with Mysql 5 you can use mysqli or mysql driver.

Have your horde/config/conf.php set up, specially [sql][phptype], 
horde user, horde DB and password. 

Mauricio


On 26 Aug 2009 at 11:18, Robert P. J. Day wrote:

> Quoting "Robert P. J. Day" <rpjday at crashcourse.ca>:
> 
> >   unrelated to what's been going on so far, i read ahead and in the
> > 3.2.x -> 3.3.x upgrade step, the user is told to:
> >
> >   #  pear install MDB2_Schema
> >
> > from a position of *total* pear ignorance, i typed exactly that and got:
> >
> > Failed to download pear/MDB2_Schema within preferred state "stable",
> > latest release is version 0.8.5, stability "beta", use
> > "channel://pear.php.net/MDB2_Schema-0.8.5" to install
> > Cannot initialize 'channel://pear.php.net/MDB2_Schema', invalid or
> > missing package file
> > Package "channel://pear.php.net/MDB2_Schema" is not valid
> > install failed
> >
> >
> >   that's exactly the kind of thing that throws someone off.  based on
> > what i read, it would appear that i'm configured to only allow "stable"
> > content, while MDB2_Schema-0.8.5 is labelled as "beta", is that why
> > it's failing?
> >
> >   if i run:
> >
> >   # pear config-show
> >
> > i can see:
> >
> > ...
> > Preferred Package State        preferred_state  stable
> > ...
> >
> >   i'm going to guess that i just have to switch that to accept beta
> > content, yes?  it shouldn't be hard for me to figure out how, but
> > that's *precisely* the sort of thing that should be addressed in the
> > documentation -- what might go wrong at various stages and how to fix
> > it.
> 
>    by the way, the solution(s):
> 
> http://www.ducea.com/2008/02/01/installing-pear-beta-packages/
> 
> rday
> 
> 
> 
> -- 
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org


--------------------------------------------------------
Mauricio J. T. Tecles
Instituto de Biofisica Carlos Chagas Filho - UFRJ
Edificio do Centro de Ciencias da Saude, Bloco G
Av. Carlos Chagas Filho, 373
Cidade Universitaria, Ilha do Fundao
Rio de Janeiro, RJ
Brasil
21941-902
Telefone: 55 21 2562-6544
FAX: 55 21 2280-8193
mtecles at biof.ufrj.br


From jolumape_al at hotmail.com  Wed Aug 26 15:56:48 2009
From: jolumape_al at hotmail.com (Jose Luis Marin Perez)
Date: Wed, 26 Aug 2009 10:56:48 -0500
Subject: [horde] Login over SSL
In-Reply-To: <20090826173029.65554vt59ie65no0@webmail.kwsoft.de>
References: <SNT112-W41892DE54D0C445D786F3AEFF80@phx.gbl>
	<20090826115121.10816cg3ik352b4s@neo.wg.de>
	<COL103-W23CF85A04D62C30A70BB698F70@phx.gbl> 
	<20090826173029.65554vt59ie65no0@webmail.kwsoft.de>
Message-ID: <COL103-W12643AC0FEAB22856442A098F70@phx.gbl>


Dear Andreas, 

I can not find any menu or icon labeled Administration, in any case I have installed horde-webmail-1.0.1 this version allows login a administrator? 

Thanks
 

Jose Luis
 
> Date: Wed, 26 Aug 2009 17:30:29 +0200
> From: lst_hoe02 at kwsoft.de
> To: horde at lists.horde.org
> Subject: Re: [horde] Login over SSL
> 
> Zitat von Jose Luis Marin Perez <jolumape_al at hotmail.com>:
> 
> >
> > Dear Sirs,
> >
> > I'm also interested to use SSL only for login, could please tell me 
> > in which part of the documentation could find information?
> >
> > Thanks
> 
> 
> Login as administrative user to horde
> go to "Administration" -> "Konfiguration" -> "Horde"
> and set in the "general" tab in URL-settings $conf[use_ssl] to the 
> appropriate value.
> 
> Regards
> 
> Andreas
> 
> 
> -- 
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org

_________________________________________________________________
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx

From rpjday at crashcourse.ca  Wed Aug 26 16:52:48 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Wed, 26 Aug 2009 12:52:48 -0400
Subject: [horde] partway thru the upgrade, looking good
Message-ID: <20090826125248.14b142rwgwwgc88k@crashcourse.ca>

   so here's what i've got away with so far.  i ran all of the upgrade  
scripts to go from 3.0.9 to 3.3.4 that represented just changing the  
schema of the horde database; that is:

   * 3.0_to_3.1.mysql.sql
   * 2006-06-29_horde_prefs_indexes.sql
   * 3.1_to_3.2.mysql.sql

it all seemed to work so, theoretically, i should have a valid 3.2  
version database.  at this point, i'm going to install 3.3.4 and,  
among other things, point it at that database, hoping it's not going  
to complain, at which point i can worry about history and that  
fix_mdb2_sequences script to finish things off.

   does that make sense?  and, yes, i'm getting as bored of this as  
you are. :-)

rday


From rpjday at crashcourse.ca  Wed Aug 26 18:18:26 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Wed, 26 Aug 2009 14:18:26 -0400
Subject: [horde] with new 3.3.4, attempts to login to horde fail
Message-ID: <20090826141826.rce4kbr1w8gggg0g@crashcourse.ca>

   *sigh*.  progress seems to be slow and painful.  i have my new  
3.3.4 install that i can browse to, connected to the allegedly  
upgraded horde database, but initially, there was not a single  
username/password combination i could use that would work.  so  
question 1:  can i use mysql to check in the horde database for what  
constitutes a valid name/password to horde.

   as a quick attempt, i edited conf.php and changed the existing line to:

$conf['auth']['admins'] = array('rpjday');

to try my own account to log in.  when i tried it, the horde log file gave me:

Aug 26 14:08:12 HORDE [notice] [horde] Login success for rpjday  
[192.168.169.1] to Horde [pid 12547 on line 138 of  
"/var/www/XXXXXX/horde-3.3.4/login.php"]

which looked good, until i tail'ed /var/log/syslog and read:

Aug 26 14:14:51 main dovecot: imap-login: Login: user=<rpjday>,  
method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, TLS
Aug 26 14:14:51 main dovecot: IMAP(rpjday): Disconnected: Logged out

   that *seems* to be telling me that the imap-login itself is  
rejecting the login.  so this seems like not really a horde problem at  
this point, but i'm open to suggestions.  when i configured 3.3.4, i  
explicitly selected what was being used before for authentication  
(from conf.php):

$conf['auth']['params']['protocol'] = 'imap/ssl/novalidate-cert';

so can someone explain why the imap-login seems to be using TLS?  that  
doesn't seem right.  do i have to reconfigure imap to match the way i  
configured horde?

rday


From rpjday at crashcourse.ca  Wed Aug 26 19:07:50 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Wed, 26 Aug 2009 15:07:50 -0400
Subject: [horde] logging into horde just fails quietly
Message-ID: <20090826150750.yc5pqfl08w88s08g@crashcourse.ca>

   i am fresh out of ideas here, and i apologize for abusing this list  
as much as i have.

   with my new 3.3.4 install, i have an account and password that  
seems to be valid.  when i use it to login to horde, the log file  
(/tmp/horde334.log) shows:

Aug 26 14:58:02 HORDE [notice] [horde] Login success for rpjday  
[192.168.169.1] to Horde [pid 16754 on line 138 of  
"/var/www/XXXXXX/horde/login.php"]

   should i then assume that the authentication worked?  except that,  
rather than getting dumped into a horde session, the name and password  
test fields are cleared and i stay at the horde login screen.  no  
errors, no diagnostics i can see.  just quietly resetting everything  
and waiting for the next login.  as if, somehow, there's a bad  
redirect or URL or something.

   given that my log file doesn't show any errors, what other log file  
can i check to see what's happening?  my biggest frustration right now  
is that i don't see any error messages being printed *anywhere*.  if i  
could at least see an error message, i'd have something to go on.

rday

p.s.  after i had earlier unloaded the 3.3.4 tarball and set up  
initial config/*.php files, i could at least get into horde and start  
the configuration.  now i can't get there at all.  help?



From vilius at lnk.lt  Wed Aug 26 19:20:02 2009
From: vilius at lnk.lt (=?utf-8?Q?Vilius_=C5=A0umskas?=)
Date: Wed, 26 Aug 2009 22:20:02 +0300
Subject: [horde] logging into horde just fails quietly
In-Reply-To: <20090826150750.yc5pqfl08w88s08g@crashcourse.ca>
References: <20090826150750.yc5pqfl08w88s08g@crashcourse.ca>
Message-ID: <1427209774.20090826222002@lnk.lt>

Sveiki,

Wednesday, August 26, 2009, 10:07:50 PM, you wrote:

>    i am fresh out of ideas here, and i apologize for abusing this list
> as much as i have.

>    with my new 3.3.4 install, i have an account and password that  
> seems to be valid.  when i use it to login to horde, the log file  
> (/tmp/horde334.log) shows:

> Aug 26 14:58:02 HORDE [notice] [horde] Login success for rpjday  
> [192.168.169.1] to Horde [pid 16754 on line 138 of  
> "/var/www/XXXXXX/horde/login.php"]

You     have     reported     that     your    Horde    lives    under
/var/www/xxxx/horde-3.3.4  folder  and  now  you are saying that it is
under   /var/www/xxxx/horde.   You've   probably messed   up   cookie  path  in
horde/config/conf.php        and/or        Horde's       path       in
/horde/config/registry.php

And  please  make one thread, name it "horde upgrade" or something and
stick to it. It is really hard to follow what you are trying to do.

-- 
Best regards,
 Vilius


From lst_hoe02 at kwsoft.de  Wed Aug 26 19:30:39 2009
From: lst_hoe02 at kwsoft.de (lst_hoe02 at kwsoft.de)
Date: Wed, 26 Aug 2009 21:30:39 +0200
Subject: [horde] upgrading a *new* database doesn't look like it's going
 to work
In-Reply-To: <alpine.LFD.2.00.0908261133220.4511@localhost>
References: <alpine.LFD.2.00.0908260950460.3522@localhost>
	<20090826161832.18431j3skmfcgnr4@webmail.kwsoft.de>
	<alpine.LFD.2.00.0908261018540.3796@localhost>
	<20090826164919.110385yctkic8wog@webmail.kwsoft.de>
	<alpine.LFD.2.00.0908261133220.4511@localhost>
Message-ID: <20090826213039.59922ewm5095o95w@webmail.kwsoft.de>

Zitat von "Robert P. J. Day" <rpjday at crashcourse.ca>:

> On Wed, 26 Aug 2009, lst_hoe02 at kwsoft.de wrote:
>
>> -Apply all schema changes since 3.0. If you prepare in advance this
>> will not even take a minute to actually apply.
>
>> - Now the trickier Part : You need a new working Horde version to
>> run the update scripts. If your brave this can be done with a
>> separate Webroot pointing to the same database ;-)
>
>   (just about to head out for lunch, so i'll dash this off.)
>
>   ah, i think i see what you're getting at (maybe).  even without a
> working horde install, i can certainly run the scripts that
> represent just *schema* changes, since they can be done outside the
> context of a working install.

Yes, first all schema changes to get horde happy.
Then use the scripts to migrate data if required.

>   however, some of the other upgrade steps (move history out of
> datatree) need a working install but they can be left until later, is
> that what you're saying?  so i can upgrade the DB with all the
> possible schema changes, then configure 3.3.4 to refer to that DB, and
> finally go back and run the scripts that needed an install context.
> is that what you're suggesting.

Yes...

The only thing to get you go is the authentication and the admin user.  
Both is set in horde/config/conf.php. As start you can copy over the  
old one with only adjusting some paths, but you should upgrade it with  
the UI after login.

Regards

Andreas



From rpjday at crashcourse.ca  Wed Aug 26 19:34:44 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Wed, 26 Aug 2009 15:34:44 -0400 (EDT)
Subject: [horde] logging into horde just fails quietly
In-Reply-To: <1427209774.20090826222002@lnk.lt>
References: <20090826150750.yc5pqfl08w88s08g@crashcourse.ca>
	<1427209774.20090826222002@lnk.lt>
Message-ID: <alpine.LFD.2.00.0908261530070.6438@localhost>

On Wed, 26 Aug 2009, Vilius ?umskas wrote:

> Sveiki,
>
> Wednesday, August 26, 2009, 10:07:50 PM, you wrote:
>
> >    i am fresh out of ideas here, and i apologize for abusing this
> > list as much as i have.
>
> >    with my new 3.3.4 install, i have an account and password that
> > seems to be valid.  when i use it to login to horde, the log file
> > (/tmp/horde334.log) shows:
>
> > Aug 26 14:58:02 HORDE [notice] [horde] Login success for rpjday
> > [192.168.169.1] to Horde [pid 16754 on line 138 of
> > "/var/www/XXXXXX/horde/login.php"]
>
> You have reported that your Horde lives under
> /var/www/xxxx/horde-3.3.4 folder and now you are saying that it is
> under /var/www/xxxx/horde.  You've probably messed up cookie path in
> horde/config/conf.php and/or Horde's path in
> /horde/config/registry.php

 i moved all of this back under the old name of "horde" for
consistency, and i've made sure all of the PHP files reflect that.
there are no remaining traces of the name "horde-3.3.4".

> And please make one thread, name it "horde upgrade" or something and
> stick to it. It is really hard to follow what you are trying to do.

  i apologize for that.  i sometimes start a new thread if i think the
problem is sufficiently different and independent from older ones.
personally, i think a subject of just "horde upgrade" is overly vague
and uninformative, but i see your point and i apologize.

  at the moment, as i mentioned, logins that the log file claim
succeeded don't put me into a horde session, but i don't see a single
diagnostic anywhere.  if i could find an error message somewhere, at
least i'd have a place to start.  i'll keep looking.

rday
--


========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From slusarz at horde.org  Wed Aug 26 19:46:59 2009
From: slusarz at horde.org (Michael M Slusarz)
Date: Wed, 26 Aug 2009 13:46:59 -0600
Subject: [horde] with new 3.3.4, attempts to login to horde fail
In-Reply-To: <20090826141826.rce4kbr1w8gggg0g@crashcourse.ca>
References: <20090826141826.rce4kbr1w8gggg0g@crashcourse.ca>
Message-ID: <20090826134659.k8ok08o8cs00g@bigworm.curecanti.org>

Quoting "Robert P. J. Day" <rpjday at crashcourse.ca>:

> Aug 26 14:14:51 main dovecot: imap-login: Login: user=<rpjday>,  
> method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, TLS
> Aug 26 14:14:51 main dovecot: IMAP(rpjday): Disconnected: Logged out
>
>   that *seems* to be telling me that the imap-login itself is  
> rejecting the login.

No it's not.  It instead informs you that the user was properly logged  
in.  The second entry occurs because the IMAP connection is always  
closed at the end of a page access, since state can't be maintained in  
PHP between two different page accesses (this is the main reason to  
use an imapproxy).

michael

-- 
___________________________________
Michael Slusarz [slusarz at horde.org]


From rmcauley at ca.afilias.info  Wed Aug 26 20:33:23 2009
From: rmcauley at ca.afilias.info (Robert McAuley)
Date: Wed, 26 Aug 2009 16:33:23 -0400
Subject: [horde] Horde Alarm Emails Repeating Themselves
Message-ID: <4A959C13.5080506@ca.afilias.info>

Hello,

My email alarms are repeating themselves.  It seems Horde forgets or overwrites the "sent" flag that gets serialized into the alarms_internal column.  The problem is this only happens on occasion - sometimes I will only see 1 reminder, sometimes I see 5 reminders.  My cron is set to run every 5 minutes, sometimes I see behaviour such as:

15 minutes before - Alarm sent as specified
10 minutes before - Alarm sent again when it shouldn't
5 minutes before - Nothing
Time of event - Nothing.
5 minutes after - Alarm sent
10 minutes after - Nothing
15 minutes after - Alarm sent

... there is no rhyme or reason.  My Horde may send an alarm repeatedly for 30 minutes, then stop for 20, then send 1.  It's incomprehensible.

What could be happening that overwrites the sent flag?

It may have something to do with me currently working around this bug:

http://bugs.horde.org/ticket/8381

... where I am forcefully changing the time that the _list alarm function uses, shifting it 4 hours to bring it into EDT. (the timezone of 99% of my users)  Without this, I can't get any alarms.

- Rob

From rmcauley at ca.afilias.info  Wed Aug 26 20:37:19 2009
From: rmcauley at ca.afilias.info (Robert McAuley)
Date: Wed, 26 Aug 2009 16:37:19 -0400
Subject: [horde] [kronolith] Problem with FB URL
In-Reply-To: <20090826220053.208219nj4zsbrvr4@portal.4schiefer.de>
References: <20090826220053.208219nj4zsbrvr4@portal.4schiefer.de>
Message-ID: <4A959CFF.8060603@ca.afilias.info>

Check the actual address book entry of the person/people you're adding. There should be a "Freebusy URL" entry there - if it's blank, you'll get this 404 error.

If you're using an LDAP address book, you'll need to configure your LDAP server to use the RFC 2739 schema and then populate entries with calFBURL attributes, which if I remember correctly comes inside the Horde tarball. (if not, it is found easily)

- Rob

Helmut Schiefer wrote:
> Hello,
> 
> I'm a german user of the horde application software. Now I've little bit 
> time to search a solution for a problem in my installation. I've search 
> the web and also the faq but I didn't find any idea to solve it. I hope 
> for some new ideas from list.
> 
> Problem:
> Kronolith -> New Event -> Attendees -> Add Attendees -> Select one from 
> the Address Book.
> 
> Then I got the error: Error retrieving free/busy information for 
> XXX at yyyy.de: The free/busy url for XXX at 4yyyy.de cannot be retrieved.
> 
> Configuration:
> Calendar (kronolith)  H3 (2.3.1)
> FBURL in the Adresse Book: https://xxx.yyyy.de/kronolith/fb.php?u=xxx
> 
> I checked the apache logfile and I didn't find any error in it. I also 
> checked the horde logfile and I also didn't find any erorr in the logfile.
> 
> If I put the fb-url in the browser line I got the following information:
> ==============
> BEGIN:VCALENDAR
> 
> VERSION:2.0
> 
> PRODID:-//The Horde Project//Kronolith H3 (2.3.1)//EN
> 
> METHOD:PUBLISH
> 
> BEGIN:VFREEBUSY
> 
> ORGANIZER;CN=XXXX XXXX:mailto:xxx at XXXX.de
> 
> DTSTAMP:20090826T195134Z
> 
> DTSTART:20090825T220000Z
> 
> DTEND:20090924T220000Z
> 
> URL:https://xxxx.xxxxx.de/kronolith/fb.php?u=xxx
> 
> END:VFREEBUSY
> 
> END:VCALENDAR
> ==============
> 
> I'm looking for some further idea to catch the error. In the web I found 
> only the tip with 401 Error in the Apache Log, I checked this without 
> any result.
> 
> Thanks for any ideas.
> 


From lst_hoe02 at kwsoft.de  Wed Aug 26 21:12:40 2009
From: lst_hoe02 at kwsoft.de (lst_hoe02 at kwsoft.de)
Date: Wed, 26 Aug 2009 23:12:40 +0200
Subject: [horde] logging into horde just fails quietly
In-Reply-To: <alpine.LFD.2.00.0908261530070.6438@localhost>
References: <20090826150750.yc5pqfl08w88s08g@crashcourse.ca>
	<1427209774.20090826222002@lnk.lt>
	<alpine.LFD.2.00.0908261530070.6438@localhost>
Message-ID: <20090826231240.3105519bsqgc81gc@webmail.kwsoft.de>

Zitat von "Robert P. J. Day" <rpjday at crashcourse.ca>:

> On Wed, 26 Aug 2009, Vilius ?umskas wrote:
>
>> Sveiki,
>>
>> Wednesday, August 26, 2009, 10:07:50 PM, you wrote:
>>
>> >    i am fresh out of ideas here, and i apologize for abusing this
>> > list as much as i have.
>>
>> >    with my new 3.3.4 install, i have an account and password that
>> > seems to be valid.  when i use it to login to horde, the log file
>> > (/tmp/horde334.log) shows:
>>
>> > Aug 26 14:58:02 HORDE [notice] [horde] Login success for rpjday
>> > [192.168.169.1] to Horde [pid 16754 on line 138 of
>> > "/var/www/XXXXXX/horde/login.php"]
>>
>> You have reported that your Horde lives under
>> /var/www/xxxx/horde-3.3.4 folder and now you are saying that it is
>> under /var/www/xxxx/horde.  You've probably messed up cookie path in
>> horde/config/conf.php and/or Horde's path in
>> /horde/config/registry.php
>
>  i moved all of this back under the old name of "horde" for
> consistency, and i've made sure all of the PHP files reflect that.
> there are no remaining traces of the name "horde-3.3.4".
>
>> And please make one thread, name it "horde upgrade" or something and
>> stick to it. It is really hard to follow what you are trying to do.
>
>   i apologize for that.  i sometimes start a new thread if i think the
> problem is sufficiently different and independent from older ones.
> personally, i think a subject of just "horde upgrade" is overly vague
> and uninformative, but i see your point and i apologize.
>
>   at the moment, as i mentioned, logins that the log file claim
> succeeded don't put me into a horde session, but i don't see a single
> diagnostic anywhere.  if i could find an error message somewhere, at
> least i'd have a place to start.  i'll keep looking.

Check if your sessions cookies are okay. Clear the cookies in your  
browser and verify that cookies are allowed. Have a look at your PHP  
settings to see where the sessions are stored and if the permissions  
are correct.
Seams to me that your session is destroyed after login.

Regards

Andreas


From rpjday at crashcourse.ca  Wed Aug 26 21:09:55 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Wed, 26 Aug 2009 17:09:55 -0400 (EDT)
Subject: [horde] with new 3.3.4, attempts to login to horde fail
In-Reply-To: <20090826134659.k8ok08o8cs00g@bigworm.curecanti.org>
References: <20090826141826.rce4kbr1w8gggg0g@crashcourse.ca>
	<20090826134659.k8ok08o8cs00g@bigworm.curecanti.org>
Message-ID: <alpine.LFD.2.00.0908261706090.2707@localhost>

On Wed, 26 Aug 2009, Michael M Slusarz wrote:

> Quoting "Robert P. J. Day" <rpjday at crashcourse.ca>:
>
> > Aug 26 14:14:51 main dovecot: imap-login: Login: user=<rpjday>,
> > method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, TLS
> > Aug 26 14:14:51 main dovecot: IMAP(rpjday): Disconnected: Logged out
> >
> >  that *seems* to be telling me that the imap-login itself is rejecting the
> > login.
>
> No it's not.  It instead informs you that the user was properly
> logged in. The second entry occurs because the IMAP connection is
> always closed at the end of a page access, since state can't be
> maintained in PHP between two different page accesses (this is the
> main reason to use an imapproxy).

  oh, dear.

  at the risk of asking a hideously embarrassing question, are you
saying that i *need* imapproxy running for my horde login to work?
because, at the moment, it isn't since it's broken somehow in this
upgraded version of lenny.  i've been fighting with imapproxy for days
now, and can't get it installed without it failing with a config
error so i finally just took it out.

  and based on what you wrote, that kind of explains what i'm seeing
(maybe).  it appears that the horde login works fine, only to
instantly drop the authentication and start all over again.  is that
why i get told "successful login," only to keep returning to the login
screen over and over?

  if that's the case, i guess i better figure out what's wrong with
imapproxy.

rday
--


========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From rpjday at crashcourse.ca  Thu Aug 27 06:11:11 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Thu, 27 Aug 2009 02:11:11 -0400 (EDT)
Subject: [horde] logging into horde just fails quietly
In-Reply-To: <20090826231240.3105519bsqgc81gc@webmail.kwsoft.de>
References: <20090826150750.yc5pqfl08w88s08g@crashcourse.ca>
	<1427209774.20090826222002@lnk.lt>
	<alpine.LFD.2.00.0908261530070.6438@localhost>
	<20090826231240.3105519bsqgc81gc@webmail.kwsoft.de>
Message-ID: <alpine.LFD.2.00.0908270206130.6586@localhost>

On Wed, 26 Aug 2009, lst_hoe02 at kwsoft.de wrote:

> Check if your sessions cookies are okay. Clear the cookies in your
> browser and verify that cookies are allowed. Have a look at your PHP
> settings to see where the sessions are stored and if the permissions
> are correct. Seams to me that your session is destroyed after login.

  that sounds plausible, since horde verifies that the login succeeds,
only to dump me back at a blank login screen.  so perhaps it starts a
session, only to terminate it almost immediately and start the process
over again.  it would certainly resemble what i'm seeing.  (other
users have tried to log in with their normal accounts and passwords,
and the horde log file claims that *their* logins succeeded as well.)

  cookies don't appear to be an issue -- an attempt to log in stores
exactly two cookies on my system:

  * one with the name "Horde3.3.4" (the name i gave the app)
  * one with the name "auth_key"

both from the proper URL.  so i don't think cookies are the problem.
continuing to investigate, thanks.

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From rpjday at crashcourse.ca  Thu Aug 27 07:28:08 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Thu, 27 Aug 2009 03:28:08 -0400 (EDT)
Subject: [horde] logging into horde just fails quietly
In-Reply-To: <20090826231240.3105519bsqgc81gc@webmail.kwsoft.de>
References: <20090826150750.yc5pqfl08w88s08g@crashcourse.ca>
	<1427209774.20090826222002@lnk.lt>
	<alpine.LFD.2.00.0908261530070.6438@localhost>
	<20090826231240.3105519bsqgc81gc@webmail.kwsoft.de>
Message-ID: <alpine.LFD.2.00.0908270324170.8097@localhost>

On Wed, 26 Aug 2009, lst_hoe02 at kwsoft.de wrote:

  ... snip ...

> Check if your sessions cookies are okay. Clear the cookies in your
> browser and verify that cookies are allowed. Have a look at your PHP
> settings to see where the sessions are stored and if the permissions
> are correct. Seams to me that your session is destroyed after login.

  here's a bit more info.  i checked the differences between the old
(3.0.9) conf.php file and the new one, related to session settings:

3.0.9:

$conf['session']['name'] = 'Horde';
$conf['session']['cache_limiter'] = 'nocache';
$conf['session']['timeout'] = 0;
$conf['sessionhandler']['type'] = 'none';

3.3.4:

$conf['session']['name'] = 'Horde3.3.4';
$conf['session']['use_only_cookies'] = true;
$conf['session']['cache_limiter'] = 'nocache';
$conf['session']['timeout'] = 0;
$conf['sessionhandler']['type'] = 'none';
$conf['sessionhandler']['memcache'] = false;

  i can't say i understand what's going on underneath, but is there
something in the above that might explain why sessions seem to
terminate almost immediately?  in setting up 3.3.4, i just tried to
duplicate as many of the 3.0.9 settings as possible.

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From lst_hoe02 at kwsoft.de  Thu Aug 27 08:00:31 2009
From: lst_hoe02 at kwsoft.de (lst_hoe02 at kwsoft.de)
Date: Thu, 27 Aug 2009 10:00:31 +0200
Subject: [horde] logging into horde just fails quietly
In-Reply-To: <alpine.LFD.2.00.0908270206130.6586@localhost>
References: <20090826150750.yc5pqfl08w88s08g@crashcourse.ca>
	<1427209774.20090826222002@lnk.lt>
	<alpine.LFD.2.00.0908261530070.6438@localhost>
	<20090826231240.3105519bsqgc81gc@webmail.kwsoft.de>
	<alpine.LFD.2.00.0908270206130.6586@localhost>
Message-ID: <20090827100031.18331i1qwdby0vgk@webmail.kwsoft.de>

Zitat von "Robert P. J. Day" <rpjday at crashcourse.ca>:

> On Wed, 26 Aug 2009, lst_hoe02 at kwsoft.de wrote:
>
>> Check if your sessions cookies are okay. Clear the cookies in your
>> browser and verify that cookies are allowed. Have a look at your PHP
>> settings to see where the sessions are stored and if the permissions
>> are correct. Seams to me that your session is destroyed after login.
>
>   that sounds plausible, since horde verifies that the login succeeds,
> only to dump me back at a blank login screen.  so perhaps it starts a
> session, only to terminate it almost immediately and start the process
> over again.  it would certainly resemble what i'm seeing.  (other
> users have tried to log in with their normal accounts and passwords,
> and the horde log file claims that *their* logins succeeded as well.)
>
>   cookies don't appear to be an issue -- an attempt to log in stores
> exactly two cookies on my system:
>
>   * one with the name "Horde3.3.4" (the name i gave the app)
>   * one with the name "auth_key"
>
> both from the proper URL.  so i don't think cookies are the problem.
> continuing to investigate, thanks.

The cookies in your browser are only one side of the coin. Check your  
PHP settings where sessions are stored and have a look if the  
Webserver user is able to write there and if you see some session  
files in there.
Next is to grep all your logfiles (/var/log/ on Linux) for PHP related errors.

Regards

Andreas



From vilius at lnk.lt  Thu Aug 27 08:06:13 2009
From: vilius at lnk.lt (=?windows-1257?Q?Vilius_=D0umskas?=)
Date: Thu, 27 Aug 2009 11:06:13 +0300
Subject: [horde] logging into horde just fails quietly
In-Reply-To: <alpine.LFD.2.00.0908270324170.8097@localhost>
References: <20090826150750.yc5pqfl08w88s08g@crashcourse.ca>	<1427209774.20090826222002@lnk.lt>	<alpine.LFD.2.00.0908261530070.6438@localhost>	<20090826231240.3105519bsqgc81gc@webmail.kwsoft.de>
	<alpine.LFD.2.00.0908270324170.8097@localhost>
Message-ID: <005b01ca26ed$3eb319b0$bc194d10$@lt>

> $conf['session']['name'] = 'Horde3.3.4';

Try using alphanumeric characters only. Like "horde334".

-- 
  Vilius


From rpjday at crashcourse.ca  Thu Aug 27 08:37:40 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Thu, 27 Aug 2009 04:37:40 -0400 (EDT)
Subject: [horde] logging into horde just fails quietly
In-Reply-To: <005b01ca26ed$3eb319b0$bc194d10$@lt>
References: <20090826150750.yc5pqfl08w88s08g@crashcourse.ca>
	<1427209774.20090826222002@lnk.lt>
	<alpine.LFD.2.00.0908261530070.6438@localhost>
	<20090826231240.3105519bsqgc81gc@webmail.kwsoft.de>
	<alpine.LFD.2.00.0908270324170.8097@localhost>
	<005b01ca26ed$3eb319b0$bc194d10$@lt>
Message-ID: <alpine.LFD.2.00.0908270436590.8684@localhost>

On Thu, 27 Aug 2009, Vilius ?umskas wrote:

> > $conf['session']['name'] = 'Horde3.3.4';
>
> Try using alphanumeric characters only. Like "horde334".

  you have *got* to be kidding.  that worked.  how embarrassed should
i be?

rday
--


========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From vilius at lnk.lt  Thu Aug 27 08:49:54 2009
From: vilius at lnk.lt (=?windows-1257?Q?Vilius_=D0umskas?=)
Date: Thu, 27 Aug 2009 11:49:54 +0300
Subject: [horde] logging into horde just fails quietly
In-Reply-To: <alpine.LFD.2.00.0908270436590.8684@localhost>
References: <20090826150750.yc5pqfl08w88s08g@crashcourse.ca>
	<1427209774.20090826222002@lnk.lt>
	<alpine.LFD.2.00.0908261530070.6438@localhost>
	<20090826231240.3105519bsqgc81gc@webmail.kwsoft.de>
	<alpine.LFD.2.00.0908270324170.8097@localhost>
	<005b01ca26ed$3eb319b0$bc194d10$@lt>
	<alpine.LFD.2.00.0908270436590.8684@localhost>
Message-ID: <006c01ca26f3$58fa7d80$0aef7880$@lt>

> > > $conf['session']['name'] = 'Horde3.3.4';
> >
> > Try using alphanumeric characters only. Like "horde334".
> 
>   you have *got* to be kidding.  that worked.  how embarrassed should
> i be?

That's a known PHP problem. Reminds me the old days when I was a programmer
:)

-- 
  Vilius


From rpjday at crashcourse.ca  Thu Aug 27 09:13:39 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Thu, 27 Aug 2009 05:13:39 -0400 (EDT)
Subject: [horde] logging into horde just fails quietly
In-Reply-To: <006c01ca26f3$58fa7d80$0aef7880$@lt>
References: <20090826150750.yc5pqfl08w88s08g@crashcourse.ca>
	<1427209774.20090826222002@lnk.lt>
	<alpine.LFD.2.00.0908261530070.6438@localhost>
	<20090826231240.3105519bsqgc81gc@webmail.kwsoft.de>
	<alpine.LFD.2.00.0908270324170.8097@localhost>
	<005b01ca26ed$3eb319b0$bc194d10$@lt>
	<alpine.LFD.2.00.0908270436590.8684@localhost>
	<006c01ca26f3$58fa7d80$0aef7880$@lt>
Message-ID: <alpine.LFD.2.00.0908270509200.8958@localhost>

On Thu, 27 Aug 2009, Vilius ?umskas wrote:

> > > > $conf['session']['name'] = 'Horde3.3.4';
> > >
> > > Try using alphanumeric characters only. Like "horde334".
> >
> >   you have *got* to be kidding.  that worked.  how embarrassed
> > should i be?
>
> That's a known PHP problem. Reminds me the old days when I was a
> programmer :)

  is it reasonable to suggest that that's a bug?  not in PHP, but in
horde, in the sense that if using special characters in a session
name has a good chance of breaking things, the horde configuration
process should at least warn the user about it.

  instead, the horde configuration happily accepted that session name
without complaint.  i think it's only fair that *somewhere*, there
should have been a warning about what was happening.  horde and/or PHP
experts might know what to avoid, but a simple diagnostic would have
saved me *hours* of debugging time.

  i'd be happy to submit a ticket at http://bugs.horde.org if people
think this is something that should be addressed.  if only to save the
sanity of the next person who makes the same mistake. :-)

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From vilius at lnk.lt  Thu Aug 27 10:45:32 2009
From: vilius at lnk.lt (=?windows-1257?Q?Vilius_=D0umskas?=)
Date: Thu, 27 Aug 2009 13:45:32 +0300
Subject: [horde] logging into horde just fails quietly
In-Reply-To: <alpine.LFD.2.00.0908270509200.8958@localhost>
References: <20090826150750.yc5pqfl08w88s08g@crashcourse.ca>
	<1427209774.20090826222002@lnk.lt>
	<alpine.LFD.2.00.0908261530070.6438@localhost>
	<20090826231240.3105519bsqgc81gc@webmail.kwsoft.de>
	<alpine.LFD.2.00.0908270324170.8097@localhost>
	<005b01ca26ed$3eb319b0$bc194d10$@lt>
	<alpine.LFD.2.00.0908270436590.8684@localhost>
	<006c01ca26f3$58fa7d80$0aef7880$@lt>
	<alpine.LFD.2.00.0908270509200.8958@localhost>
Message-ID: <007a01ca2703$803c2190$80b464b0$@lt>

>   i'd be happy to submit a ticket at http://bugs.horde.org if people
> think this is something that should be addressed.  if only to save the
> sanity of the next person who makes the same mistake. :-)

Yeah, it should be at least possible to warn administrators on Configuration
screen.

-- 
  Vilius


From rpjday at crashcourse.ca  Thu Aug 27 10:54:44 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Thu, 27 Aug 2009 06:54:44 -0400 (EDT)
Subject: [horde] logging into horde just fails quietly
In-Reply-To: <007a01ca2703$803c2190$80b464b0$@lt>
References: <20090826150750.yc5pqfl08w88s08g@crashcourse.ca>
	<1427209774.20090826222002@lnk.lt>
	<alpine.LFD.2.00.0908261530070.6438@localhost>
	<20090826231240.3105519bsqgc81gc@webmail.kwsoft.de>
	<alpine.LFD.2.00.0908270324170.8097@localhost>
	<005b01ca26ed$3eb319b0$bc194d10$@lt>
	<alpine.LFD.2.00.0908270436590.8684@localhost>
	<006c01ca26f3$58fa7d80$0aef7880$@lt>
	<alpine.LFD.2.00.0908270509200.8958@localhost>
	<007a01ca2703$803c2190$80b464b0$@lt>
Message-ID: <alpine.LFD.2.00.0908270654080.9591@localhost>

On Thu, 27 Aug 2009, Vilius ?umskas wrote:

> >   i'd be happy to submit a ticket at http://bugs.horde.org if
> > people think this is something that should be addressed.  if only
> > to save the sanity of the next person who makes the same mistake.
> > :-)
>
> Yeah, it should be at least possible to warn administrators on
> Configuration screen.

http://bugs.horde.org/ticket/8531

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From rpjday at crashcourse.ca  Thu Aug 27 13:52:30 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Thu, 27 Aug 2009 09:52:30 -0400 (EDT)
Subject: [horde] much thanks for all the help so far
Message-ID: <alpine.LFD.2.00.0908270949080.3758@localhost>


  i appreciate all the assistance as i've frantically tried to upgrade
and configure horde over the last few days, knowing as little about it
as i did when i started.

  i'll almost certainly have more questions in the near future but,
for now, the database appears to be upgraded, i can log in, and i'm
starting to install the additional apps, so at least future questions
will involve how to *add to* or *enhance* what i've got, as opposed to
just trying to fix or salvage it something that's broken.

  again, lots of thanks.

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

        Linux Consulting, Training and Annoying Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================

From rpjday at crashcourse.ca  Thu Aug 27 15:00:28 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Thu, 27 Aug 2009 11:00:28 -0400 (EDT)
Subject: [horde] "best practices" for adding an external app to horde menus?
Message-ID: <alpine.LFD.2.00.0908271054050.4296@localhost>


 finally, i have a question just asking for advice -- how best to add
an *external* app into the horde menus.

 consider the following directory structure (inherited from previous
3.0.9 setup but i'm free to make changes if they make sense):

 /var/www/<EXTURL>/
     tts/                 (non-horde ticketing system)
     horde/               (webroot)
         config/          (you get the idea)
         local_apps/      (some other non-horde apps)
             webstats/    (for website stats)
             tts/         (same ticketing system as above)

  how the first (webstats) app was added -- add a new menu heading in
registry.php, and an entry for webstats:

$this->applications['website'] = array(
   'name' => _("Web Site"),
   'status' => 'heading',
);

$this->applications['webstats'] = array(
   'fileroot' => dirname(__FILE__) . '/../local_apps/webstats',
   'webroot' => $this->applications['horde']['webroot'] . '/local_apps/webstats',
   'name' => _("Website Stats"),
   'allow_guests' => false,
   'status' => 'active',
   'menu_parent' => 'website'
);

  then add local_apps/webstats/index.php, which takes one to an
external site:

<HTML>
<HEAD>
<META HTTP-EQUIV="Refresh"
CONTENT="0;URL=http://extremetracking.com/open?login=XXXXXX">
<SCRIPT LANGUAGE="JavaScript"><!--
function redirect () { setTimeout("go_now()",1000); }
function go_now ()   { window.location.href =
"http://extremetracking.com/open?login=XXXXXX"; }
//--></SCRIPT>
</HEAD>
<BODY onLoad="redirect()">
</BODY>
</HTML>

  pretty straightforward, registry points to appropriate local_apps
directory, under which the index.php file then redirects *explicitly*
to an external site. that's how it was set up before, and it works
just fine.  now, here's the issue.

  i want to add another external app under that same heading -- the
"tts" ticketing system.  so i add another equivalent entry to
registry.php:

$this->applications['tts'] = array(
   'fileroot' => dirname(__FILE__) . '/../local_apps/tts',
   'webroot' => $this->applications['horde']['webroot'] . '/local_apps/tts',
   'name' => _("Ticket System"),
   'allow_guests' => false,
   'status' => 'active',
   'menu_parent' => 'website'
);

  but the difference is that *that* index.php file reads thusly:

<HTML>
<HEAD>
<META HTTP-EQUIV="Refresh" CONTENT="0;URL=http://../../../tts/">
<SCRIPT LANGUAGE="JavaScript"><!--
function redirect () { setTimeout("go_now()",1000); }
function go_now ()   { window.location.href = "../../../tts/"; }
//--></SCRIPT>
</HEAD>
<BODY onLoad="redirect()">
</BODY>
</HTML>

  as in, head up three directory levels, *above* the webroot.
however, while that entry shows up in the menus, if i try to run that
app, i get the diagnostic:

 ".." could not be found

this *used* to work in 3.0.9, but not now in 3.3.4.

  one obvious solution is to just hardcode the http url in that
index.php file to go straight to "http://<EXTURL>/tts, which is in
fact externally visible, and which seems to work just fine.  but i'm
not i should count on that.

  so the question is, what's the best practice for adding to the horde
menus apps that live *above* the webroot, the way that "tts" app does?
clearly, using the "../../.." notation used to work once, but not
anymore for reasons i don't understand.  is there a way to fix that?
or am i better off just putting in the actual URL?

  personally, i'd prefer to install non-horde apps above the webroot
to keep them philosophically separate from horde-related content and
not clutter up the webroot directory, but i'll defer to the expertise
of those who know better.

rday





From elier.delgado at gmail.com  Thu Aug 27 21:55:35 2009
From: elier.delgado at gmail.com (Elier Delgado)
Date: Thu, 27 Aug 2009 17:55:35 -0400
Subject: [horde] Problem in Rdo/RelationshipTest testing clotho example
	in MySQL
In-Reply-To: <20090825230541.s80gs04@technest.org>
References: <6ec714020810122153h421ed2cncc1bfcc644d84b22@mail.gmail.com>
	<20090825002202.owc4kck@technest.org>
	<6ec714020908250946ve3bad26sf15e70de188c9cbe@mail.gmail.com>
	<20090825230541.s80gs04@technest.org>
Message-ID: <6ec714020908271455v7385fafcycf58bf5f7c511e46@mail.gmail.com>

>>> I reproduced it and have fixed this specific issue. I've also fixed a few other things in
>>> Rdo that weren't working right, and updated the clotho example to work
>>> with the PHP 5 Horde_Db and Horde_Rdo libs. There's one more bug in there
>>> somewhere when running RelationshipTest.php; hopefully it's the last one,
>>> and I'll try to work on it more tomorrow.
>>>
>>> -chuck
>>
>> Dear Chuck,
>>
>> Thanks you very much, casually, I began to work on this yesterday,
>> because I need use it ..
>> so I'm available to test it or help you in you need.
>
> Great! I just pushed the commits that I think fix the remaining issues. I'm
> sure there are some things that should be done sooner rather than later -
> for instance, *_TO_MANY relationships can only be lazy right now - but the
> code is in better shape.
>
> Thanks for the (however long ago) push to fix this, and thanks in advance
> for any testing and suggestions and patches.
>
> -chuck
>

Hi Chuck,

I was testing the Clotho example, all seem ok, just I see this problem:

In RelationshipTest, if we have more than one availabilty for one resource,

INSERT INTO `clotho_resource_availability` VALUES ('1', '1', '1121404095', '2');
INSERT INTO `clotho_resource_availability` VALUES ('2', '1', '1121404096', '3');

The count in the asociated mapper do not work fine in this case:

// one-to-many
echo "Resource ({$r->resource_id}) {$r->resource_name} has " .
count($r->availabilities) . " availabilities:";

count($r->availabilities) = 1, when must be 2

while in CountTest work fine:

$ram = new ResourceAvailabilityMapper();
echo count($ram); // = 2

Great job! I will begin to testing it in a new context.

Best regards, Elier

From eculp at encontacto.net  Thu Aug 27 22:50:33 2009
From: eculp at encontacto.net (eculp)
Date: Thu, 27 Aug 2009 17:50:33 -0500
Subject: [horde] I've been confused about horde versioning since git
	partially	took the place of cvs head.
Message-ID: <20090827175033.11562ymeuivmjqas@econet.encontacto.net>

Since there have been many changes en FRAMEWORK_3, I want to update my  
horde installation.  For years I just ran cvs head without major  
problems.  I just backed up the working version, ran cvs,  updated  
database and configuration and if there were problems, restored the  
previous version and waited until things stabilized and tried again.


I want to start doing something similar again to get the many changes  
that aren't in the last releases.

I'm not sure what my options are.  I'm assuming that I could combine  
cvs head with git and get the very latest bleeding edge code or I  
could use the  FRAMEWORK_3 tag.   I am assuming that the head version  
on cvs needs to be combined with git.  Could someone confirm that and  
or other combinations.

I don't plan to upgrade my old system but prefer to build in new from  
scratch both code and databases.  I'll only reuse my ldap for users.   
I really don't care if a few tools are temporally broken I just want  
to get back to following horde development.

Any suggestions and/or links would be greatly appreciated.

ed

From rpjday at crashcourse.ca  Fri Aug 28 12:49:36 2009
From: rpjday at crashcourse.ca (Robert P. J. Day)
Date: Fri, 28 Aug 2009 08:49:36 -0400
Subject: [horde] why does horde install doc suggest the "beta"
	Services_Weather?
Message-ID: <20090828084936.64ma2p7v48okwc4o@crashcourse.ca>

   getting pickier in my old age, i'm verifying my horde install  
against what i read here:

   http://www.horde.org/horde/docs/?f=INSTALL.html

and i read:

   Install PEAR packages:

   pear install -o Log Mail Mail_Mime DB Date File
   pear -d preferred_state=beta install -a Services_Weather
                           ^^^^ ?

why "beta" in that last line?  since:

# pear info Services_Weather
About Services_Weather-1.3.2
============================
... blah blah blah ...
Release State   stable
...

   is that "beta" state just a historical leftover that can now be deleted?

rday




From btj at havleik.no  Fri Aug 28 14:52:12 2009
From: btj at havleik.no (=?ISO-8859-1?Q?Bj=F8rn?= T Johansen)
Date: Fri, 28 Aug 2009 16:52:12 +0200
Subject: [horde] Where does Ingo maintain the id for the primary key for the
 ingu_rules table?
Message-ID: <20090828165212.73f3c0b3@pennywise.havleik.no>

I am trying to copy the rows in the ingo_rules table to a new installation but when I try to create a new rule, the sql insert fails because of of
duplicate key... And that makes sense, cause the id it tries to use is already used... Where can I update Ingo so that it knows how many rules it has
already created?


Regards,

BTJ

-- 
-----------------------------------------------------------------------------------------------
Bj?rn T Johansen

btj at havleik.no
-----------------------------------------------------------------------------------------------
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"
-----------------------------------------------------------------------------------------------

From jan at horde.org  Fri Aug 28 14:58:52 2009
From: jan at horde.org (Jan Schneider)
Date: Fri, 28 Aug 2009 16:58:52 +0200
Subject: [horde] Where does Ingo maintain the id for the primary key for
 the ingu_rules table?
In-Reply-To: <20090828165212.73f3c0b3@pennywise.havleik.no>
References: <20090828165212.73f3c0b3@pennywise.havleik.no>
Message-ID: <20090828165852.80531bg0kcupp3us@neo.wg.de>

Zitat von Bj?rn T Johansen <btj at havleik.no>:

> I am trying to copy the rows in the ingo_rules table to a new  
> installation but when I try to create a new rule, the sql insert  
> fails because of of
> duplicate key... And that makes sense, cause the id it tries to use  
> is already used... Where can I update Ingo so that it knows how many  
> rules it has
> already created?

It depends on your database. We use sequences for all incrementing  
primary keys. If your database doesn't support sequences, the DB  
package's sequence emulation is used, usually with a table name called  
..._seq.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/


From btj at havleik.no  Fri Aug 28 15:30:25 2009
From: btj at havleik.no (=?ISO-8859-1?Q?Bj=F8rn?= T Johansen)
Date: Fri, 28 Aug 2009 17:30:25 +0200
Subject: [horde] Where does Ingo maintain the id for the primary key for
 the ingu_rules table?
In-Reply-To: <20090828165852.80531bg0kcupp3us@neo.wg.de>
References: <20090828165212.73f3c0b3@pennywise.havleik.no>
	<20090828165852.80531bg0kcupp3us@neo.wg.de>
Message-ID: <20090828173025.0cb00519@pennywise.havleik.no>

On Fri, 28 Aug 2009 16:58:52 +0200
Jan Schneider <jan at horde.org> wrote:

> Zitat von Bj?rn T Johansen <btj at havleik.no>:
> 
> > I am trying to copy the rows in the ingo_rules table to a new  
> > installation but when I try to create a new rule, the sql insert  
> > fails because of of
> > duplicate key... And that makes sense, cause the id it tries to use  
> > is already used... Where can I update Ingo so that it knows how many  
> > rules it has
> > already created?
> 
> It depends on your database. We use sequences for all incrementing  
> primary keys. If your database doesn't support sequences, the DB  
> package's sequence emulation is used, usually with a table name called  
> ..._seq.
> 
> Jan.
> 

Hmmm... I should have checked the sequences before I asked; I use PostgreSQL mysself also and should have known... :-|
But thx... :)


BTJ

From patrickdk at patrickdk.com  Fri Aug 28 23:17:50 2009
From: patrickdk at patrickdk.com (Patrick Domack)
Date: Fri, 28 Aug 2009 19:17:50 -0400
Subject: [horde] index.php/Contacts
Message-ID: <20090828191750.ct5zuba0gs8c8c44@tenchi.patrickdk.com>

As far as I can tell, this is a complete attack and not anything  
ligit. But before I went on a complete rampage, I wanted to make sure.

I have started getting thousands of these per second on my webmail  
servers. I don't see them in my logs before today.

85.197.219.69 - - [28/Aug/2009:19:06:49 -0400] "HEAD  
/index.php/Contacts/V%C3%AD%C3%B0ista%C3%B0ask%C3%B3li-2574.EML  
HTTP/1.1" 302 - "-" "Translator (unknown version) CFNetwork/438.14  
Darwin/9.8.0 (i386) (MacBookPro4%2C1)"



From miguipda at hotmail.com  Sun Aug 30 15:29:29 2009
From: miguipda at hotmail.com (Lau Mig)
Date: Sun, 30 Aug 2009 15:29:29 +0000
Subject: [horde] How To install horde on lighttp on OpenWRT ?
Message-ID: <BAY120-W16805624503891A327926C5F30@phx.gbl>



_________________________________________________________________
More than messages?check out the rest of the Windows Live?.
http://www.microsoft.com/windows/windowslive/