Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Bob Todd on March 14, 2003, 07:07:36 PM

Title: Horde Upgrades
Post by: Bob Todd on March 14, 2003, 07:07:36 PM
Anyone else used Dan's upgrade RPMS for Horde,Imp, Turba ? Are they all working as expected?

Looks like there are a couple of nice features been added but it seems to have screwed up my address books. Anyone else seen this or is it me mucked up?

Bob
Title: Re: Horde Upgrades
Post by: Dan Brown on March 14, 2003, 07:40:41 PM
Did you do the signal-event email-update step?  Your symptoms sound like Turba (and possibly other things) are running using the default config files, not the templated ones.
Title: Re: Horde Upgrades
Post by: Bob Todd on March 14, 2003, 07:46:34 PM
yes I did complete the instructions as you had passed on to me this morning. I did have an issue with Turba install - I had to install turba-1.2 using --nodeps - didnt work without it. I then was able to install the e-smith-turba-1.1 rpm. Did also get a MySQL error during setup if thats any help?
Title: Re: Horde Upgrades
Post by: Bob Todd on March 14, 2003, 07:56:53 PM
hmm okies I have now gotten slightly further on. I rpm -e both the e-smith-turba and the turba rpms and then reinstalled the turba rpm - so far so good

Now I get a dependency error when I try to install the e-smith-turba rpm - it claims to require turba 1.0 yet I've just installed 1.2

If I try and force it using --nodeps it tells me S10turba_sql_create exists and then it  complains "loading turba_sql_create into mysql execvp: Permission denied [Failed]

On the plus point at this stage the address book on the clients now has the return to e-mail button and only lists address book and local ldap instead of all the other garbage. Unfortunately it still doesnt read the local ldap.

Any suggestions
Title: Re: Horde Upgrades
Post by: Dan Brown on March 14, 2003, 08:11:02 PM
You need to be using e-smith-turba-1.1.0, not -1.1.  1.1 is a very old version.  Yes, it's confusing; I need to go back and figure out exactly what 1.1 was for and (probably) remove it.
Title: Re: Horde Upgrades
Post by: Bob Todd on March 14, 2003, 08:32:26 PM
hmm ok I removed e-smith-turba and tried to reinstall using the correct version this time. First stage completed okay and the S20... file seems to have been inserted into the SQL as expected but I still got the earlier SQL error following right after that and having followed the sequence to expand templates etc it all works far better than before but it refuses to show any contacts from my local LDAP address book. Could this be some leftover from the S10... file that was modified by e-smith-turba-1.1.1 ? I have tried this having removed the S10 file from /etc/e-smith/sql/init folder as well.
Title: Re: Horde Upgrades
Post by: Bob Todd on March 14, 2003, 09:02:24 PM
I've rebooted the server and now looking at the messages log I see 3 errors related to the horde apps

Mar 14 17:49:11 portal mysql: ERROR 1060 at line 26: Duplicate column name 'object_type'
Mar 14 17:49:11 portal mysql.init: Loading 20mysql_upgrade_1.1_to_1.2.sql into mysql failed

Mar 14 17:49:33 portal httpd: PHP Warning:  Undefined index:  change_folders in /home/httpd/html/horde/imp/templates/login/login.inc on line 127

Mar 14 17:49:42 portal httpd: PHP Warning:  Undefined index:  change_folders in /home/httpd/html/horde/imp/lib/IMP.php on line 115

Again dont know if this helps explain whats gone wrong but any advice / pointers appreciated.
Title: Re: Horde Upgrades
Post by: Dan Brown on March 15, 2003, 01:09:48 AM
OK, the mysql.init error is probably caused by the script already having been run, so you should be able to safely delete it from /etc/e-smith/sql/init or wherever it lives.

Not sure on the change_folders issue at the moment.  It's also on my server and doesn't seem to be causing a problem, but I need to track down where it's coming from.

Now, a couple of general things that would have saved both of us some time, and you some frustration:

1.  If you encounter errors in installation, say so, and give the EXACT text of the error message.

2.  Don't use the --nodeps flag unless you (1) have been told to do so by the packager, or (2) know what you're doing.  RPMs have dependancies for a reason, and usually using --nodeps will break things.
Title: Re: Horde Upgrades
Post by: Bob Todd on March 15, 2003, 12:09:24 PM
thanks Dan for all the help with this. I'll keep your points in mind. (2) is where I really went wrong, trying to fix it myself without actually knowing what I was doing. Seeing the dependancy error I was getting (from trying to install the wrong module - duh) I thought I'd try being clever and look up how to install ignoring the error messages. Just goes to show what trying to be smart does!

Still cannot get turba to talk to my LDAP - churns away and then gives me an empty address list. Is there an easy way of going back to the old version so see if that works and then I can try the upgrade again?
Title: Re: Horde Upgrades
Post by: Aavo on March 17, 2003, 12:20:35 AM
About PHP Warning: Undefined index: change_folders:
It is enough to define it in /home/httpd/html/horde/imp/config/conf.php
in  Mail Server Settings  section:

// If we are not using the server list, should we allow users to
// select the mail server's folder prefix?
$conf['server']['change_folders'] = false;

(this is from conf.php.dist)
and add this alsou in template:
/etc/e-smith/templates/home/httpd/html/horde/imp/config/conf.php/160MailServerSettings

...Something is limitting attachment size to 1MB in compose window - not figured out, what...
IMHO it's not in php.ini.
Title: Re: Horde Upgrades
Post by: Bob Todd on March 18, 2003, 03:47:10 PM
Apparently this problem with ldap is a known issue with the turba upgrade. Dont know enough about ldap myself to fully explain but its to do with 'objectclass' definitions in turba 1.2. Apparently they are necessary now whereas they were optional before. It means modifying the turba/config/sources.php to include an 'objectclass' definition for the local ldap server. Theres a link here from the turba mailing list archive of a "working" configuration for the ldap settings.
Title: Re: Horde Upgrades
Post by: Bob Todd on March 18, 2003, 03:47:43 PM
oops helps if you actually post the link I suppose :-)


http://marc.theaimsgroup.com/?l=turba&m=104767884812105&w=2
Title: Re: Horde Upgrades
Post by: Bob Todd on March 18, 2003, 05:42:23 PM
Ok latest update - adding 'objectclass' => 'person' to the ldap settings in sources.php does indeed give a list of users in the ldap directory. Unfortunately it doesnt restore any of the To,CC,BCC,Send Message icons etc that were all present for the last version.

Anyone got any ideas? Am I the only person still having problems with this update?
Title: Re: Horde Upgrades
Post by: Dan Brown on March 18, 2003, 05:46:15 PM
You're probably the only person who's checked the LDAP functionality is all.  I'll take a look soon.