Koozali.org: home of the SME Server

Horde 5.2 on SME9

Offline stephdl

  • *
  • 1,519
  • +0/-0
    • Linux et Geekeries
Re: Horde 5.2 on SME9
« Reply #15 on: August 27, 2014, 05:40:24 PM »
hi guys
there is another issue with horde 5.2 after upgrading php and mysql 55.
please see : http://forums.contribs.org/index.php/topic,51033.0.html

follow bug 8529 http://bugs.contribs.org/show_bug.cgi?id=8529
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

!!! Please write your knowledge to the Wiki !!!

Offline DanB35

  • ****
  • 764
  • +0/-0
    • http://www.familybrown.org
Re: Horde 5.2 on SME9
« Reply #16 on: August 27, 2014, 09:39:16 PM »
OK, so a bit more testing.  I installed John's updated RPMs (Horde 5.2.1 etc.).  The upgrade completed without errors, the signal-event post-upgrade completed without errors, but on rebooting the system a number of the SQL scripts failed:


Here's the current list of tables:
Code: [Select]
mysql> show tables;
+-----------------------------+
| Tables_in_horde             |
+-----------------------------+
| content_schema_info         |
| horde_alarms                |
| horde_cache                 |
| horde_categories            |
| horde_categories_categories |
| horde_datatree              |
| horde_datatree_attributes   |
| horde_datatree_seq          |
| horde_groups                |
| horde_groups_members        |
| horde_histories             |
| horde_histories_seq         |
| horde_locks                 |
| horde_perms                 |
| horde_prefs                 |
| horde_sessionhandler        |
| horde_signups               |
| horde_syncml_anchors        |
| horde_syncml_map            |
| horde_tokens                |
| horde_users                 |
| horde_vfs                   |
| imp_schema_info             |
| imp_sentmail                |
| ingo_forwards               |
| ingo_lists                  |
| ingo_rules                  |
| ingo_schema_info            |
| ingo_shares                 |
| ingo_shares_groups          |
| ingo_shares_users           |
| ingo_sharesng               |
| ingo_sharesng_groups        |
| ingo_sharesng_users         |
| ingo_spam                   |
| ingo_vacations              |
| kronolith_events            |
| kronolith_events_geo        |
| kronolith_events_mysqlgeo   |
| kronolith_resources         |
| kronolith_schema_info       |
| kronolith_shares            |
| kronolith_shares_groups     |
| kronolith_shares_users      |
| kronolith_sharesng          |
| kronolith_sharesng_groups   |
| kronolith_sharesng_users    |
| kronolith_storage           |
| mnemo_memos                 |
| mnemo_schema_info           |
| mnemo_shares                |
| mnemo_shares_groups         |
| mnemo_shares_users          |
| mnemo_sharesng              |
| mnemo_sharesng_groups       |
| mnemo_sharesng_users        |
| nag_schema_info             |
| nag_shares                  |
| nag_shares_groups           |
| nag_shares_users            |
| nag_sharesng                |
| nag_sharesng_groups         |
| nag_sharesng_users          |
| nag_tasks                   |
| rampage_objects             |
| rampage_tag_stats           |
| rampage_tagged              |
| rampage_tags                |
| rampage_types               |
| rampage_user_tag_stats      |
| rampage_users               |
| turba_objects               |
| turba_schema_info           |
| turba_shares                |
| turba_shares_groups         |
| turba_shares_users          |
| turba_sharesng              |
| turba_sharesng_groups       |
| turba_sharesng_users        |
+-----------------------------+
79 rows in set (0.00 sec)

mysql> quit

...and here's the current status on the Horde admin page:

......

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Re: Horde 5.2 on SME9
« Reply #17 on: August 28, 2014, 01:05:19 AM »
Remember what I stated.  If you have modified your SME 9 install (newer php, mysql), I'm not going to be able to support that.  I just did another install of SME 9, downloaded the horde zip files from my contribs directory (Which I didn't do yesterday), checked md5sum's, and installed horde 5.2.1.  No issues.  It installs, reboots, and modifies/creates tables, and I'm able to login.  Do a
Code: [Select]
pear list -c hordeYou should have these modules installed if you've used the latest files from my contribs directory.
[/code]
Code: [Select]


[root@www ~]# pear list -c horde
Installed packages, channel pear.horde.org:
===========================================
Package                      Version State
Horde_ActiveSync             2.17.0  stable
Horde_Alarm                  2.2.1   stable
Horde_Argv                   2.0.9   stable
Horde_Auth                   2.1.5   stable
Horde_Autoloader             2.1.0   stable
Horde_Browser                2.0.7   stable
Horde_Cache                  2.5.0   stable
Horde_Cli                    2.0.5   stable
Horde_Compress               2.0.8   stable
Horde_Compress_Fast          1.0.3   stable
Horde_Constraint             2.0.1   stable
Horde_Controller             2.0.1   stable
Horde_Core                   2.13.0  stable
Horde_Crypt                  2.5.0   stable
Horde_Crypt_Blowfish         1.0.2   stable
Horde_CssMinify              1.0.1   stable
Horde_Css_Parser             1.0.4   stable
Horde_Data                   2.1.0   stable
Horde_Date                   2.0.12  stable
Horde_Date_Parser            2.0.2   stable
Horde_Dav                    1.0.7   stable
Horde_Db                     2.1.3   stable
Horde_Editor                 2.0.4   stable
Horde_ElasticSearch          1.0.2   stable
Horde_Exception              2.0.4   stable
Horde_Feed                   2.0.2   stable
Horde_Form                   2.0.8   stable
Horde_Group                  2.0.4   stable
Horde_HashTable              1.2.0   stable
Horde_History                2.3.1   stable
Horde_Http                   2.1.1   stable
Horde_Icalendar              2.0.9   stable
Horde_Image                  2.1.0   stable
Horde_Imap_Client            2.24.2  stable
Horde_Injector               2.0.3   stable
Horde_Itip                   2.0.6   stable
Horde_JavascriptMinify       1.1.0   stable
Horde_JavascriptMinify_Jsmin 1.0.1   stable
Horde_Ldap                   2.2.0   stable
Horde_ListHeaders            1.1.5   stable
Horde_Lock                   2.1.1   stable
Horde_Log                    2.1.0   stable
Horde_LoginTasks             2.0.3   stable
Horde_Mail                   2.4.0   stable
Horde_Mail_Autoconfig        1.0.0   stable
Horde_Mapi                   1.0.3   stable
Horde_Mime                   2.4.4   stable
Horde_Mime_Viewer            2.0.7   stable
Horde_Nls                    2.0.4   stable
Horde_Notification           2.0.1   stable
Horde_Oauth                  2.0.1   stable
Horde_Pack                   1.0.2   stable
Horde_Pdf                    2.0.3   stable
Horde_Perms                  2.1.2   stable
Horde_Prefs                  2.6.0   stable
Horde_Queue                  1.1.1   stable
Horde_Rdo                    2.0.2   stable
Horde_Role                   1.0.1   stable
Horde_Routes                 2.0.2   stable
Horde_Rpc                    2.1.1   stable
Horde_Scribe                 2.0.1   stable
Horde_Secret                 2.0.3   stable
Horde_Serialize              2.0.2   stable
Horde_Service_Facebook       2.0.6   stable
Horde_Service_Twitter        2.1.1   stable
Horde_Service_Weather        2.1.3   stable
Horde_SessionHandler         2.2.4   stable
Horde_Share                  2.0.5   stable
Horde_Smtp                   1.6.0   stable
Horde_Socket_Client          1.1.2   stable
Horde_SpellChecker           2.1.1   stable
Horde_Stream                 1.6.1   stable
Horde_Stream_Filter          2.0.2   stable
Horde_Stream_Wrapper         2.1.0   stable
Horde_Support                2.1.1   stable
Horde_SyncMl                 2.0.4   stable
Horde_Template               2.0.1   stable
Horde_Text_Diff              2.1.0   stable
Horde_Text_Filter            2.2.1   stable
Horde_Text_Filter_Csstidy    2.0.1   stable
Horde_Text_Flowed            2.0.1   stable
Horde_Thrift                 2.0.1   stable
Horde_Timezone               1.0.6   stable
Horde_Token                  2.0.5   stable
Horde_Translation            2.1.0   stable
Horde_Tree                   2.0.2   stable
Horde_Url                    2.2.3   stable
Horde_Util                   2.5.0   stable
Horde_Vfs                    2.2.0   stable
Horde_View                   2.0.4   stable
Horde_Xml_Element            2.0.1   stable
Horde_Xml_Wbxml              2.0.1   stable
content                      2.0.4   stable
horde                        5.2.1   stable
imp                          6.2.1   stable
ingo                         3.2.0   stable
kronolith                    4.2.1   stable
mnemo                        4.2.1   stable
nag                          4.2.1   stable
timeobjects                  2.1.0   stable
turba                        4.2.1   stable


There are two newer files:
Horde_ActiveSync-2.18.0
Horde_Core-2.13.1

So if you look at this from the admin page, it could be misleading.

Also, my stock system is running:

[root@www ~]# mysql -V
mysql  Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (i386) using readline 5.1

[root@www ~]# php -v
PHP 5.3.3 (cli) (built: Aug  6 2014 05:40:05)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies

[root@www init]# pear -V
PEAR Version: 1.9.4
PHP Version: 5.3.3
Zend Engine Version: 2.3.0
Running on: Linux www 2.6.32-431.23.3.el6.i686 #1 SMP Thu Jul 31 14:37:53 UTC 2014 i686

Lastly, the screen shot you posted is showing the mysql.init events for horde 3, or maybe a mix of horde 3 and 5, but not only the ones needed for horde 5.  They both won't work together.  I'm not sure how you got into that state. 


John
......

Offline DanB35

  • ****
  • 764
  • +0/-0
    • http://www.familybrown.org
Re: Horde 5.2 on SME9
« Reply #18 on: August 28, 2014, 07:30:40 PM »
This server has been through several SME versions, and I honestly don't remember its complete history.  It was upgraded at least from 7.something to 8.0, then to 8.1.  That was backed up (using the built-in backup to workstation), a clean copy of SME 9.0 installed, and then restored from that backup.  I'd expect some of the mysql.init entries are left over from that history.

Since none of the mysql.init files appear to be owned by any package, is there any way to determine which should be there and which shouldn't?
......

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Re: Horde 5.2 on SME9
« Reply #19 on: August 28, 2014, 08:00:41 PM »
Would you have happened to run the restore after you upgraded to horde 5.2?  I actually don't believe /etc/e-smith/templates is restored, at least on a tape restore.  I don't know about any of the other restore methods.


Here are the files I have in, /etc/e-smith/templates/etc/e-smith/sql/init on a test server with horde 5.2.1 installed.
  • -rw-r--r-- 1 root root  443 Apr 26 13:04 00_restore_dumped_dbs
  • -rw-r--r-- 1 root root  298 Apr 26 13:04 10mysql_upgrade
  • -rw-r--r-- 1 root root   82 May 29  2008 20mysql_migrate_horde
  • -rw-r--r-- 1 root root   87 May 29  2008 21horde.mysql_set_password
  • -rw-r--r-- 1 root root   84 May 23  2013 30horde_mysql_create_db
  • -rw-r--r-- 1 root root   55 Aug  6 21:40 31horde_mysql_create_tables
  • -rw-r--r-- 1 root root   81 Jul 11 08:23 32turba_mysql_create_objects
  • -rw-r--r-- 1 root root   87 May 29  2008 77horde_mysql_update_privs
  • -rw-r--r-- 1 root root  129 Mar 30 21:15 80kronolith_db_upgrade
  • -rw-r--r-- 1 root root  192 Mar 30 21:15 85kronolith_utc_upgrade
  • -rw-r--r-- 1 root root  176 Jun 30 21:37 99Ingo_Datatree_to_SQL
  • -rw-r--r-- 1 root root  193 Mar 30 21:15 99Kronolith_Datatree_to_SQL
  • -rw-r--r-- 1 root root  177 Mar 26 22:06 99Mnemo_Datatree_to_SQL
  • -rw-r--r-- 1 root root  186 Mar 26 22:08 99Nag_Datatree_to_SQL
  • -rw-r--r-- 1 root root  188 Jul 11 08:23 99Turba_Datatree_to_SQL
John
......

Offline DanB35

  • ****
  • 764
  • +0/-0
    • http://www.familybrown.org
Re: Horde 5.2 on SME9
« Reply #20 on: August 28, 2014, 08:34:19 PM »
I'm pretty sure I ran the restore before upgrading to Horde 5.2.  However, your reply pointed out something I hadn't realized--/etc/e-smith/sql/init/* is templated.  The contents of that directory and /etc/e-smith/templates/etc/e-smith/sql/init/ don't match:
Code: [Select]
[root@e-smith ~]# ls -l /etc/e-smith/sql/init/
total 68
-r-xr----- 1 root root  88 Jul 29 13:30 30horde_mysql_create_tables
-r-xr----- 1 root root  55 Jul 29 13:48 31horde_mysql_create_tables
-r-xr----- 1 root root  59 Jul 29 13:30 31horde_upgrade
-r-xr----- 1 root root 130 Jul 29 13:30 35imp_mysql_create_tables
-r-xr----- 1 root root  46 Jul 29 13:30 36imp_upgrade
-r-xr--r-- 1 root root 131 Jul 29 13:30 40mysql.create.turba
-r-xr--r-- 1 root root  58 Jul 29 13:30 50turba_upgrade
-r-xr--r-- 1 root root  96 Jul 29 13:30 57turba_mysql_reset_addressbook_pref
-r-xr--r-- 1 root root 117 Jul 29 13:30 60migrate-imp-to-turba
-r-xr----- 1 root root 135 Jul 29 13:30 78mysql.create.ingo
-r-xr----- 1 root root  58 Jul 29 13:30 79ingo_upgrade
-r-xr----- 1 root root 129 Jul 29 13:48 80kronolith_db_upgrade
-r-xr----- 1 root root 176 Jul 29 13:48 99Ingo_Datatree_to_SQL
-r-xr----- 1 root root 193 Jul 29 13:48 99Kronolith_Datatree_to_SQL
-r-xr----- 1 root root 177 Jul 29 13:48 99Mnemo_Datatree_to_SQL
-r-xr----- 1 root root 186 Jul 29 13:48 99Nag_Datatree_to_SQL
-r-xr----- 1 root root 188 Jul 29 13:48 99Turba_Datatree_to_SQL
[root@e-smith ~]# ls -l /etc/e-smith/templates/etc/e-smith/sql/init/
total 64
-rw-r--r-- 1 root root  443 Apr 26 14:04 00_restore_dumped_dbs
-rw-r--r-- 1 root root  298 Apr 26 14:04 10mysql_upgrade
-rw-r--r-- 1 root root   82 May 29  2008 20mysql_migrate_horde
-rw-r--r-- 1 root root   87 May 29  2008 21horde.mysql_set_password
-rw-r--r-- 1 root root   84 May 23  2013 30horde_mysql_create_db
-rw-r--r-- 1 root root   55 Aug  6 22:40 31horde_mysql_create_tables
-rw-r--r-- 1 root root   81 Jul 11 09:23 32turba_mysql_create_objects
-rw-r--r-- 1 root root   87 May 29  2008 77horde_mysql_update_privs
-rw-r--r-- 1 root root  129 Mar 30 22:15 80kronolith_db_upgrade
-rw-r--r-- 1 root root 1260 May 11 09:41 80roundcube
-rw-r--r-- 1 root root  192 Mar 30 22:15 85kronolith_utc_upgrade
-rw-r--r-- 1 root root  176 Jun 30 22:37 99Ingo_Datatree_to_SQL
-rw-r--r-- 1 root root  193 Mar 30 22:15 99Kronolith_Datatree_to_SQL
-rw-r--r-- 1 root root  177 Mar 26 23:06 99Mnemo_Datatree_to_SQL
-rw-r--r-- 1 root root  186 Mar 26 23:08 99Nag_Datatree_to_SQL
-rw-r--r-- 1 root root  188 Jul 11 09:23 99Turba_Datatree_to_SQL
Everything in the templates directory appears to be owned by the currently-installed versions of something (mostly horde et al.)  I'm thinking if I rm /etc/e-smith/sql/init/* && signal-event post-upgrade && signal-event reboot, that should at least get the old sql init scripts gone.
......

Offline DanB35

  • ****
  • 764
  • +0/-0
    • http://www.familybrown.org
Re: Horde 5.2 on SME9
« Reply #21 on: August 29, 2014, 07:50:26 PM »
Well, I've made some more progress, but still not all there.  I took a look at the logs (better late than never), and saw PHP fatal errors that "allow_call_time_pass_reference" is no longer supported.  Apparently this directive has been deprecated since PHP 5.0.0, but it was actually removed in 5.4.0.  Since this directive appears in php.ini, it was causing errors.  I'm not at all clear how PHP pages continued to function with this fatal error in place, but they did.  I made a new custom template fragment for 10LanguageOptions commenting out that line, removed everything in /etc/e-smith/sql/init, did signal-event post-upgrade, and rebooted.

The improvement is that all the SQL init scripts ran without errors.  After rebooting, horde-db-migrate also (1) returned some output, and (2) appeared to complete successfully--but it didn't say anything about horde itself, just the other component apps.  The horde database tables in mysql aren't changed, either.

Further investigation suggests that my pear installation is borked, or at least not what it should be for this application--there is no horde channel, for instance.  Several of your php-pear packages had already been installed from the remi repository, almost all of them the same versions.

For the conflicting packages, I ran yum downgrade to force installation of your packages.  I then did yum reinstall Horde* php-pear*, post-upgrade, reboot.  pear list now shows a lot more packages than before, but pear list -c horde still says 'Channel "horde" does not exist'.
......

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Re: Horde 5.2 on SME9
« Reply #22 on: August 29, 2014, 10:17:36 PM »
You upgraded most of the packages from Remi, that might mean Remi's package numbers were greater than mine and the system thought it needed to be updated.  That's going to be a problem.  From the console type Pear -V, if you see version 1.9.5, then that's also going to be your problem.  Remi's php-pear-1.9.5 package breaks horde on sme9.  His package adds a metadata setting and changes the pear data_dir from /usr/share/pear/data to /usr/share/pear-data.  I haven't been able to get around this yet.  I'm not going to be much help.  My honest suggestion, if this is running on a test server, then re-install using stock SME server and the horde rpms, and you will be fine.  If you need/must have the different php versions, then you'll have to search the 'NET for a solution.  I haven't found one for the upgrade PEAR issue.  If you run pear upgrade for the command line, pear will be updated to 1.9.5 and horde will still work.  It's only Remi's RPM that breaks things.


I'll have to enable Remi's repo and test and see what of his packages appear to be newer than what I have provided, and either use those, as I had originally done, or rename the ones I have, which most were Remi's that I could get to build, so to try to not have any conflicts.  But, that won't happen any time soon.



John
......

Offline DanB35

  • ****
  • 764
  • +0/-0
    • http://www.familybrown.org
Re: Horde 5.2 on SME9
« Reply #23 on: August 29, 2014, 11:16:08 PM »
I had had remi's pear 1.9.5 installed, but I've since used yum downgrade to install your pear 1.9.4 instead.  pear -V reports version 1.9.4.  There were only a few of the remi pear RPMs that were a newer version than yours, but unfortunately I didn't keep notes of which ones they were.

When I downgraded to your pear RPM, /etc/pear.conf was saved as pear.conf.rpmnew, so even with your RPM installed, I was using the remi config file setting the data_dir to /usr/share/pear-data.  I renamed the .rpmnew file to pear.conf, and pear config-show now reports data_dir as /usr/share/pear/data.  I then did yum reinstall Horde* php-pear*, post-upgrade, reboot.  Pear was still reporting 'Channel "horde" does not exist".  I tried adding that channel manually (pear channel-discover pear.horde.org, thinking that making pear aware of that channel might help it "see" the packages already installed), which succeeded, but pear now reports "(no packages installed from channel pear.horde.org)".

This is a production server, but "production" is my home rather than a business environment.  So, I can be a bit flexible with downtime, but I still can't just blow everything away and start over.  The funny thing is, though, that imp works--I can log in and do all the usual mail stuff without any apparent problems.  I would have expected more usability problems from how messed up my installation appears to be.
......

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Re: Horde 5.2 on SME9
« Reply #24 on: September 08, 2014, 01:38:26 AM »
Hi Dan,


I've finally been able to get my home server upgraded to sme9, and am now running the latest horde 5.2.1.  If you are still having issues, I can try to help you by duplicating your issue on my test servers.  If you still need help, I'll need to know exactly what you done.


John
......

Offline soundrolf

  • *
  • 38
  • +0/-0
Re: Horde 5.2 on SME9
« Reply #25 on: September 14, 2014, 02:58:16 PM »
Works great on my SME 9.0 Looks good.

Calendar Kronolith
How can I have different colors for different Appointments like "Work, Musik, and so on"
I don't see a way to change it somewhere.
« Last Edit: September 14, 2014, 03:02:26 PM by soundrolf »

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Re: Horde 5.2 on SME9
« Reply #26 on: September 15, 2014, 02:22:46 AM »
Works great on my SME 9.0 Looks good.

Calendar Kronolith
How can I have different colors for different Appointments like "Work, Musik, and so on"
I don't see a way to change it somewhere.

You have to create separate calenders for that.  This is one of the few features I do not like with the newer version.  Since they stopped supported categories, even though the option to create them are still there, you can't have or use different colors on a single calendar.  Only way to have multi-colored events is using separate calenders for everything you want to distinguish.  You can search the horde archives for lively discussion on this topic.  It has been asked to be able to have mult-colored tags, which is being considered, but having that feature, then being able to color you calendar by tag color, hasn't been discussed.  Hope that makes sense.

John
......

Offline soundrolf

  • *
  • 38
  • +0/-0
Re: Horde 5.2 on SME9
« Reply #27 on: September 15, 2014, 01:06:37 PM »
Thanks for your answer. Maybe we have to wait until somebody will code this feature into kronolith.
I am no coder. Just a user. To have different calendars is useless for my partners. So I have to check out if sogo is a solution to them.

THX

Rolf

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Re: Horde 5.2 on SME9
« Reply #28 on: September 16, 2014, 01:04:38 AM »
SOGO does the same.  You can go to their website and login to their demo server and have a look.  egroupware and zarafa  look to support colored categories.  egroupware lets you create new categories, zarafa's are hard-coded.  Again, I'd suggest going to the sites and having a look at their demo.

John
......

Offline stephdl

  • *
  • 1,519
  • +0/-0
    • Linux et Geekeries
Re: Horde 5.2 on SME9
« Reply #29 on: September 16, 2014, 08:31:59 AM »
SOGO lets you to have colored categories, but you have to set the color in your preference. However Sogo and Horde are really integrated with sme server, egroupware less. I know nothing about zarafa, so I cannot speak

Edit: something different between the sogo.nu website and the sme version, the categories are full colored in sogo.nu and not in the sme version, there is something different in the configuration file.
« Last Edit: September 16, 2014, 08:47:06 AM by stephdl »
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

!!! Please write your knowledge to the Wiki !!!