Topic: Horde 2.2.5, IMP 3.2.3, Turba 1.2.2 plus addons question?

[daley]

Hi,

Has anyone try install the any above from http://no.longer.valid/mylinks/visit.php?cid=117&lid=416 onto the SME5.6?

If i have already the plug-in programs installed on my SME5.6 machine (previous version by Dan Brown), can i upgrade it?

Thank you,
Daley

[ergozd]

I actually was looking for the latest releases for Horde & co.

I will try in on a fesh installed SMEServer 6.01 next week and will let the forum know.

[wellsi]

I only tried these on a 6.01 which had already had the php 4.3.5 upgrade.

I have everything but mnemo working although I had to download two Pear packages.

However there has just been a new release of all the Horde applications - you may want to wait until these have been packaged up.

[Rigger]

Has anyone try install the any above from http://no.longer.valid/mylinks/visit.php?cid=117&lid=416 onto the SME5.6?

I can't say. I didn't have a 5.6 machine to try them out on. Horde, IMP and Turba were based on the 6.0.1-01 sources. The only changes were to the IMP and Turba package to recognize the addons were present and displayed on the menu.

Mnemo, Nag and Turba were all based on Dan Browns source will only work on 6.0 or greater. Changes were made so these packages will use the right mysql database password in 6.0 instead of everyone having to change the password to 'horde' and I believe this change will make it incompatable with 5.6.

I actually was looking for the latest releases for Horde & co.

I will try in on a fesh installed SMEServer 6.01 next week and will let the forum know.

Let me know how it works out for you. I've been using them for three weeks now with no problems.

I have everything but mnemo working although I had to download two Pear packages.

However there has just been a new release of all the Horde applications - you may want to wait until these have been packaged up.

What problems did you have with the Mnemo package? Was it just the pear package download? Which pear packages did you have to download?

Seeing that all the packages were update was what prompted me to put together these rpms.


--
Doug M.
"Rigger"

[wellsi]

Pear Packages:
Log - this was after the PHP 4.3.5 upgrade so not really related to your RPMs. It solves the classic 'blank screen' problem when logging into webmail.

Date - due to this warning in the messages log...
PHP Warning:  main(Date/Calc.php): failed to open stream: No such file or directory in /home/httpd/html/horde/kronolith/lib/base.php on line 63

The problem with mnemo is shown below.

[webmail6]# rpm -Uvh --test e-smith-mnemo-0.8.0-03.noarch.rpm
Preparing...                ########################################### [100%]
file /home/httpd/html/horde/scripts/db/mysql_create_tables.sql from install of e-smith-mnemo-0.8.0-03 conflicts with file from package e-smith-horde-1.10.0-02
file /home/httpd/html/horde/scripts/db/mysql_update_privs.sql from install of e-smith-mnemo-0.8.0-03 conflicts with file from package e-smith-horde-1.10.0-02

Due to this I didn't install this RPM, and I did have to remove references to mnemo to make webmail work. But after that all was well.

Thanks for putting together the RPMs - I appreciate your effort.

I'm now eagerly awaiting IMP4 as that finally has working Japanese support. I have seen from the IMP mailing list that Dan is working on these at the moment.

[ergozd]

Hi everyone...

1 - I download the files from dmusty's contrib area and run

# rpm -Uvh *rpm
Preparing...                ########################################### [100%]
file /home/httpd/html/horde/scripts/db/mysql_create_tables.sql from install of e-smith-mnemo-0.8.0-03 conflicts with file from package e-smith-horde-1.10.0-02
file /home/httpd/html/horde/scripts/db/mysql_update_privs.sql from install of e-smith-mnemo-0.8.0-03 conflicts with file from package e-smith-horde-1.10.0-02

2 - To "solve" that I use force

[root@erginsme07 root]# rpm -Uvh --force *rpm
Preparing...                ########################################### [100%]
   1:horde                  warning: /home/httpd/html/horde/config/horde.php sav
ed as /home/httpd/html/horde/config/horde.php.rpmsave
warning: /home/httpd/html/horde/config/mime_drivers.php saved as /home/httpd/htm
l/horde/config/mime_drivers.php.rpmsave
warning: /home/httpd/html/horde/config/registry.php saved as /home/httpd/html/ho
rde/config/registry.php.rpmsave
########################################### [ 10%]
   2:imp                    warning: /home/httpd/html/horde/imp/config/conf.php
saved as /home/httpd/html/horde/imp/config/conf.php.rpmsave
warning: /home/httpd/html/horde/imp/config/trailer.txt saved as /home/httpd/html
/horde/imp/config/trailer.txt.rpmsave
########################################### [ 20%]
   3:e-smith-imp            ########################################### [ 30%]
   4:kronolith              ########################################### [ 40%]
You must manually configure Kronolith and create any required database tables!
See "CONFIGURING Kronolith" in /home/httpd/html/horde/kronolith/docs/INSTALL
You must also restart Apache with "service httpd restart"!
   5:e-smith-kronolith      ########################################### [ 50%]
Loading 20kronolith.sql into mysql [   OK   ]
   6:mnemo                  ########################################### [ 60%]
You must manually configure Mnemo and create any required database tables!
See "CONFIGURING Mnemo" in /home/httpd/html/horde/mnemo/docs/INSTALL
You must also restart Apache with "service httpd restart"!
   7:e-smith-mnemo          ########################################### [ 70%]
Loading 20mnemo_memos.sql into mysql [   OK   ]
   8:nag                    ########################################### [ 80%]
You must manually configure Nag and create any required database tables!
See "CONFIGURING Nag" in /home/httpd/html/horde/nag/docs/INSTALL
You must also restart Apache with "service httpd restart"!
   9:e-smith-nag            ########################################### [ 90%]
Loading 20nag_tasks.sql into mysql [   OK   ]
  10:turba                  warning: /home/httpd/html/horde/turba/config/sources.php saved as /home/httpd/html/horde/turba/config/sources.php.rpmsave
########################################### [100%]

3 - After running /sbin/e-smith/signal-event post-upgarde and reboot got follwoing messages

Apr  4 19:44:40 erginsme07 mysql.init: Loading 20horde.mysql_update_privs.sql into mysql succeeded
Apr  4 19:44:40 erginsme07 mysql.init: Loading 20mysql_migrate_horde.sql into mysql succeeded
Apr  4 19:44:40 erginsme07 mysql.init: Loading 21horde.mysql_set_password.sql into mysql succeeded
Apr  4 19:44:41 erginsme07 mysql.init: Loading 30mysql_create_tables.sql into mysql succeeded
Apr  4 19:44:46 erginsme07 50turba_upgrade_1.1_to_1.2: DBD::mysql::st execute failed: alter command denied to user: 'horde@localhost' for table 'turba_objects' at /etc/e-smith/sql/init/50turba_upgrade_1.1_to_1.2 line 66.
Apr  4 19:44:46 erginsme07 50turba_upgrade_1.1_to_1.2: DBD::mysql::st execute failed: alter command denied to user: 'horde@localhost' for table 'turba_objects' at /etc/e-smith/sql/init/50turba_upgrade_1.1_to_1.2 line 66.
Apr  4 19:44:46 erginsme07 mysql.init: Loading 50turba_upgrade_1.1_to_1.2 into mysql failed
Apr  4 19:44:50 erginsme07 mysql.init: Loading 60migrate-imp-to-turba into mysql succeeded

4 - By the end of this upgrade I could login to webmail and all modules seem to work.

I had following DB structure and php version

[root@erginsme07 root]# mysqlshow horde
Database: horde
+-----------------------------+
|           Tables            |
+-----------------------------+
| horde_categories            |
| horde_categories_categories |
| horde_prefs                 |
| horde_users                 |
| kronolith_events            |
| mnemo_memos                 |
| nag_tasks                   |
| turba_objects               |
+-----------------------------+

[root@erginsme07 root]# php -v
4.1.2


5 - So far so good, I decide to upgrade PHP to 4.3.5


I get the files from DanBrowns contrib area and

[root@erginsme07 root]# rpm -Uvh php*
Preparing...                ########################################### [100%]
   1:php                    warning: /etc/php.ini created as /etc/php.ini.rpmnew
########################################### [ 25%]
   2:php-imap               ########################################### [ 50%]
   3:php-ldap               ########################################### [ 75%]
   4:php-mysql              ########################################### [100%]
[root@erginsme07 root]# service httpd restart
Stopping httpd:                                            [   OK   ]
Starting httpd:                                            [   OK   ]
[root@erginsme07 root]#
[root@erginsme07 root]# php -v
PHP 4.3.5 (cli) (built: Mar 27 2004 17:15:15)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
[root@erginsme07 root]#

I try to login to webmail but got blank screen (pear issue)

Install pear packages Log and Date

[root@erginsme07 root]# pear install Log
downloading Log-1.8.4.tgz ...
Starting to download Log-1.8.4.tgz (29,453 bytes)
.........done: 29,453 bytes
Optional dependencies:
'sqlite' PHP extension is recommended to utilize some features
install ok: Log 1.8.4

[root@erginsme07 root]# pear install Date
downloading Date-1.4.2.tgz ...
Starting to download Date-1.4.2.tgz (42,318 bytes)
............done: 42,318 bytes
install ok: Date 1.4.2

Modify php.ini
[root@erginsme07 root]# vi /etc/php.ini
include_path            = ".:/usr/share/php TO
include_path            = ".:/usr/share/pear"

Restart httpd
[root@erginsme07 root]# service httpd restart
Stopping httpd:                                            [   OK   ]
Starting httpd:                                            [   OK   ]
[root@erginsme07 root]#

Now I have (as far I can see in my test machine) functioning webmail...

Thank you dmusty... I hope this helps...

[Rigger]

Ok,

Fixed the problem with the e-smith-mnemo package.

%changelog
* Sun Apr  4 2004
- [0.8.1-04]
- Fixed file conflict from e-smith-horde install.
- Fixed kronolith not being displayed on menu when installed.
- Mnemo sql database files removed on uninstall now.

To address the Pear - Date and Log problems I made a note about it in the readme.txt files. Don't know if
I could include those functions as part of the packages so I'll leave it at that for now.

Will look into the turba problems on the reboot later tonight or tomorrow. Hopefully an easy fix too.

--
Doug M.
"Rigger"

[Rigger]

Hey,

New update of the kronolith package.

kronolith-1.1.2-1es.noarch.rpm

Will only need to update this rpm, no post-update required.

Fixes problem in the sql.php causing events not being display on the calender .


--
Doug M.
"Rigger"