Koozali.org: home of the SME Server

horde 3 update

cwherley

horde installation on SME7-alpha7
« Reply #30 on: April 28, 2005, 08:25:09 PM »
I have installed SME7a7 to experiment with new versions of Horde and IMP.
I get some goofy messages when trying to set up Trash folder for deleting. It says it creates the Trash folder and it does. But it does not save the settings and gives me this error?
A fatal error has occurred
DB Error: insufficient data supplied
Details have been logged for the administrator.

Is this a database user, password error?

Not sure where to start the troubleshooting.

Thanks,
chris

Offline CharlieBrady

  • *
  • 6,918
  • +3/-0
Re: horde installation on SME7-alpha7
« Reply #31 on: April 28, 2005, 09:08:42 PM »
Quote from: "cwherley"
I have installed SME7a7 to experiment with new versions of Horde and IMP.
I get some goofy messages when trying to set up Trash folder for deleting.


Please provide all 7.0alpha feedback via the bug tracker at smeserver.sourceforge.net.

Thanks

Offline CharlieBrady

  • *
  • 6,918
  • +3/-0
horde 3 update
« Reply #32 on: April 28, 2005, 09:11:32 PM »
Quote from: "dhardy"
I was thinking that only yesterday ......

Will SME 7.0a7 upgrade a 6.01 SMEPlussed / Horde 3 scripted / MX Backup and Hylafax (http://www.schirrms.net/sme/index.php) ?

I know, wrong thread ... but ... will it upgrade cleanly?


Probably not. That's why I've been asking the upgrade people to be less radical in their package choices - but there still isn't any discussion about the pros and cons of any of the updates.

dhardy

horde 3 update
« Reply #33 on: April 29, 2005, 01:37:43 PM »
Thanks Charlie,

I'll do a backup and restore with tapeware onto some spare disks and see what happens if I do upgrade straight to 7a7.

Ta

David.

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
horde 3 update
« Reply #34 on: April 30, 2005, 06:47:04 PM »
Quote from: "dhardy"
I was thinking that only yesterday ......

Will SME 7.0a7 upgrade a 6.01 SMEPlussed / Horde 3 scripted / MX Backup and Hylafax (http://www.schirrms.net/sme/index.php) ?

I know, wrong thread ... but ... will it upgrade cleanly?


D.


I would venture to guess you may have some issues.  For instance, since the horde3 script really doesn't install any rpm's, horde 3 will be re-installed and any settings you have will be over-written when the templates are expanded.
......

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
horde 3 update
« Reply #35 on: May 01, 2005, 02:34:39 AM »
Quote from: "gregswallow"
If you guys would like to start testing SME7, now might be a good time.  7.0a7 now has Horde3/IMP4/Turba2.


This looks good on the surface.  You have chosen to use some different settings than I did with the script.  Are you planning on adding any of the other modules?  If you are just trying to match what was in previous versions, then you should at least add ingo for filter support since that is now separated in the horde 3 framework.

Just my opinion,

JB
......

Offline gregswallow

  • *
  • 651
  • +1/-0
horde 3 update
« Reply #36 on: May 02, 2005, 07:23:12 PM »
I can make an rpm for ingo (and others).  Do you have Kronolith working perfectly yet?  If you could post your conf.php for each app (and any other config files you had to change from the default) that would help.

If you want to note the specific differences from the settings in the conf files in my rpms versus what you're using we can discuss them.

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
horde 3 update
« Reply #37 on: May 03, 2005, 07:54:12 AM »
With some assistance from hordeuser, yes I do.  Here are the conf.php files:

Ingo
<?php
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: ingo/config/conf.xml,v 1.13 2004/02/11 19:24:23 slusarz Exp $
$conf['menu']['apps'] = array('accounts', 'imp', 'ingo', 'kronolith', 'mnemo', 'nag', 'turba');
$conf['storage']['driver'] = 'prefs';
$conf['storage']['maxblacklist'] = 0;
$conf['storage']['maxwhitelist'] = 0;
$conf['rules']['userheader'] = true;
$conf['rules']['usefolderapi'] = true;
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */

mnemo
<?php
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: mnemo/config/conf.xml,v 1.17 2004/10/03 13:07:37 stuart Exp $
$conf['storage']['params']['table'] = 'mnemo_memos';
$conf['storage']['params']['driverconfig'] = 'horde';
$conf['storage']['driver'] = 'sql';
$conf['menu']['print'] = true;
$conf['menu']['import_export'] = true;
$conf['menu']['apps'] = array('accounts', 'imp', 'ingo', 'kronolith', 'mnemo', 'nag', 'turba');
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */

nag
<?php
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: nag/config/conf.xml,v 1.25 2004/10/03 13:23:28 stuart Exp $
$conf['storage']['params']['table'] = 'nag_tasks';
$conf['storage']['params']['driverconfig'] = 'horde';
$conf['storage']['driver'] = 'sql';
$conf['menu']['print'] = true;
$conf['menu']['import_export'] = true;
$conf['menu']['apps'] = array('accounts', 'imp', 'ingo', 'kronolith', 'mnemo', 'nag', 'turba');
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */

kronolith  - This whole file is templated
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: kronolith/config/conf.xml,v 1.14.10.1 2005/03/04 04:04:31 ben Exp $
$conf['calendar']['params']['table'] = 'kronolith_events';
$conf['calendar']['params']['driverconfig'] = 'horde';
$conf['calendar']['driver'] = 'sql';
$conf['storage']['default_domain'] = '{$DomainName}';
$conf['storage']['params']['table'] = 'kronolith_storage';
$conf['storage']['params']['driverconfig'] = 'horde';
$conf['storage']['driver'] = 'sql';
$conf['metadata']['keywords'] = false;
$conf['reminder']['server_name'] = '{$SystemName}';
$conf['reminder']['from_addr'] = 'reminders@{$DomainName}';
$conf['menu']['print'] = true;
$conf['menu']['import_export'] = true;
$conf['menu']['apps'] = array('accounts', 'imp', 'ingo', 'kronolith', 'mnemo', 'nag', 'turba');
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */

All of the $conf['menu']['apps'] = array sections could be templated with some code that Dan Brown orignally provided
in the nag/kronolith/mnemo 2.x RPM's.  If you want to look at that let me know.

Here is also a link that tries to detail how to migrate filters from imp 2.x to ingo
as well as tips to get free/busy to work.  This only works with users in your personal address book.
I'm not that versed in LDAP to see what it would take to extend the schema and have this
information stored via ldap.
http://mirror.contribs.org/smeserver/contribs/jbennett/howto/Additional%20Horde%20Functionality%20Howto.htm

I'm trying to DL alpha 9 and will post back the differences I see in the Horde/imp/turba conf.php files.
I'm not saying the settings I have set are correct.  I would just like to understand the differences and go
with what makes the best sense.

If you have a spare box, it may be easier to load 6.5rc1 and then run the script located at http://mirror.contribs.org/smeserver/contribs/jbennett/install_horde30.sh then we both can compare notes.

JB
......

Offline gregswallow

  • *
  • 651
  • +1/-0
horde 3 update
« Reply #38 on: May 03, 2005, 06:46:23 PM »
I made a few mistakes in the rpms in 7.0, there is one bug here:
http://sourceforge.net/tracker/index.php?func=detail&aid=1189640&group_id=96750&atid=615772
...I noted what mistakes I made, just have to fix the rpm.

Thanks for the other config files.  That will help.

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
horde 3 update
« Reply #39 on: May 04, 2005, 05:22:04 AM »
Greg,

I loaded SME7-a9 and am getting these errors from horde in my log:

May  3 22:14:50 sme70a9 httpd: PHP Notice:  Undefined offset:  0 in /home/httpd/html/horde/imp/lib/IMP.php on line 585    - This is fixed in the latest imp release
May  3 22:14:50 sme70a9 httpd: PHP Notice:  Use of undefined constant DB_PORTABILITY_LOWERCASE - assumed 'DB_PORTABILITY_LOWERCASE' in /home/httpd/html/horde/lib/Horde/DataTree/sql.php on line 1310 - Don't really know what this is

Also the format of the inbox has changed from ;INBOX to .INBOX, which is fine.  I am just curious if you happen to know where this is configured?  I tried to google but didn't come up with anything usefull.  This folder isn't created until you login to webmail the first time, but your maildir with cur, new, tmp, and .junkmail is created via /etc/e-smith/skel/user.
......

Offline gregswallow

  • *
  • 651
  • +1/-0
horde 3 update
« Reply #40 on: May 04, 2005, 06:39:04 PM »
Quote from: "mrjhb3"

May  3 22:14:50 sme70a9 httpd: PHP Notice:  Undefined offset:  0 in /home/httpd/html/horde/imp/lib/IMP.php on line 585    - This is fixed in the latest imp release

Thanks, I noticed a new release was out, it was on my to-do list.  

Quote from: "mrjhb3"

May  3 22:14:50 sme70a9 httpd: PHP Notice:  Use of undefined constant DB_PORTABILITY_LOWERCASE - assumed 'DB_PORTABILITY_LOWERCASE' in /home/httpd/html/horde/lib/Horde/DataTree/sql.php on line 1310 - Don't really know what this is

I think the Pear DB rpm needs to be updated/fixed (one was added in Alpha8).  I found this reference:
http://lists.horde.org/archives/kronolith/Week-of-Mon-20050103/005038.html - I saw this in my logs on Alpha7 as well, I'm not up to Alpha9 yet.

Maybe add these to the sourceforge bugtracker (both bugs seperately)

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
horde 3 update
« Reply #41 on: May 05, 2005, 04:17:23 AM »
Quote from: "gregswallow"
Quote from: "mrjhb3"

May  3 22:14:50 sme70a9 httpd: PHP Notice:  Undefined offset:  0 in /home/httpd/html/horde/imp/lib/IMP.php on line 585    - This is fixed in the latest imp release

Thanks, I noticed a new release was out, it was on my to-do list.  

Quote from: "mrjhb3"

May  3 22:14:50 sme70a9 httpd: PHP Notice:  Use of undefined constant DB_PORTABILITY_LOWERCASE - assumed 'DB_PORTABILITY_LOWERCASE' in /home/httpd/html/horde/lib/Horde/DataTree/sql.php on line 1310 - Don't really know what this is

I think the Pear DB rpm needs to be updated/fixed (one was added in Alpha8).  I found this reference:
http://lists.horde.org/archives/kronolith/Week-of-Mon-20050103/005038.html - I saw this in my logs on Alpha7 as well, I'm not up to Alpha9 yet.

Maybe add these to the sourceforge bugtracker (both bugs seperately)


Yeah that fixes it.
pear ua
downloading Archive_Tar-1.3.1.tgz ...
...done: 15,102 bytes
upgrade-all ok: Archive_Tar 1.3.1
downloading Console_Getopt-1.2.tgz ...
...done: 3,370 bytes
upgrade-all ok: Console_Getopt 1.2
downloading DB-1.7.6.tgz ...
...done: 124,807 bytes
upgrade-all ok: DB 1.7.6
downloading HTTP-1.3.5.tgz ...
...done: 4,601 bytes
upgrade-all ok: HTTP 1.3.5
downloading Mail-1.1.4.tgz ...
...done: 14,548 bytes
upgrade-all ok: Mail 1.1.4
downloading Net_SMTP-1.2.6.tgz ...
...done: 9,106 bytes
requires package Auth_SASL'
Net_SMTP: dependencies failed

Since you also know about the other fix for imp, do you really want me to raise this as a bug?

JB
......

Offline CharlieBrady

  • *
  • 6,918
  • +3/-0
horde 3 update
« Reply #42 on: May 05, 2005, 04:49:59 AM »
Quote from: "mrjhb3"

Since you also know about the other fix for imp, do you really want me to raise this as a bug?


Great to see you two working on these issues. Yes - please follow up on the bug tracker, separate bugs for each issue.

Offline gregswallow

  • *
  • 651
  • +1/-0
horde 3 update
« Reply #43 on: May 06, 2005, 06:24:12 PM »
It's tempting to do 'pear ua', but I think the better approach would be to only do what is required (so you can continue to report bugs in SME7).  For example I had made a pear 1.3.5 rpm, but files in it conflicted (overwrote) files in the php rpm, so that isn't included in SME7.  For sure we need a newer db though, but best to do one at a time, rather than all of them.  It's ok if you're not going to build the rpm, you can report that 'pear upgrade db' fixed the error, and someone will buil a new pear-db rpm.

And yes, please report to the bug tracker, because I am having trouble finding time to work on this.

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
horde 3 update
« Reply #44 on: May 13, 2005, 03:37:55 AM »
Greg et all,

I just loaded SME7A12.  Glad to see you got the latest imp created.  If anyone is following the bug tracker at sourceforge, then you will know about the pear module situation.

A while back I said I would try to note some differences from the horde 3 rpm's vs. the script I put together.  Here are the major ones I see:

horde conf.php
sme
$conf['sql']['socket'] = '/var/lib/mysql/mysql.sock';
$conf['mailer']['type'] = 'smtp';
$conf['mailer']['params'] = array();
$conf['mailer']['params'] = array('server' => 'mail.youdomain.xxx);
$conf['vfs']['params']['vfsroot'] = '/tmp';
$conf['vfs']['type'] = 'file';

jbs
$conf['mailer']['params']['sendmail_path'] = '/usr/lib/sendmail';
$conf['mailer']['params']['sendmail_args'] = '-oi';
$conf['mailer']['type'] = 'sendmail';
$conf['vfs']['params']['vfs_table'] = 'horde_vfs';
$conf['vfs']['params']['driverconfig'] = 'horde';
$conf['vfs']['type'] = 'sql';

I just left the path to the socket blank, it doesn't really seem to help or hurt to have or not have it in there.  Is there any advantage to having the mailer set to smtp vs. the default of sendmail?  You have chosen to use the file system for the VFS table where as I am currently using mysql.  I had also put together a script for sme7 using the same parameters as I have for sme 6.x and horde seemed to function just fine.  I think you have done a great job putting this together, and hope you find the time to package the rest of the modules.  Thanks for yours and everyone elses time and hard work getting these updates out the door.

JB
......