Koozali.org: home of the SME Server
Obsolete Releases => SME Server 9.x => Topic started by: mrjhb3 on July 15, 2014, 02:03:20 AM
-
For Testing purposes only!!!
I've been working on the latest versions of the horde framework, and now that SME 9 and horde 5.2 have been released, I'm ready to share for wider testing. For anyone that wants to give them a try, here's how:
ssh to your SME Server
cd /root
wget http://mirror.contribs.org/contribs/jbennett/horde/horde52-rpms.zip
#wget http://mirror.contribs.org/contribs/jbennett/horde/horde52-srpms.zip
#wget http://mirror.contribs.org/contribs/jbennett/horde/horde52-rpms.zip.md5sum
#wget http://mirror.contribs.org/contribs/jbennett/horde/horde52-srpms.zip.md5sum
# Above is optional
unzip horde52-rpms.zip
cd horde52
sh Install-horde52.sh
signal-event post-upgrade ; signal-event reboot
If you are watching your logs after the reboot, you will see some log noise as the horde tables are migrated or created.
Notice I stated for testing purposes only. I haven't personally upgraded my home server to SME9 yet, but have tested various upgrades, installs etc, and everything works for me on my various test servers, but YMMV.
Another caveat, what I've done is no guarantee that it will be implemented into a future version of SME Server. You can follow some discussion, here, http://bugs.contribs.org/show_bug.cgi?id=6653 (http://bugs.contribs.org/show_bug.cgi?id=6653). There are others working on other webmail alternatives, so one of those may be considered for the future.
It is a big download:
71289322 Jul 13 22:03 horde52-rpms.zip
58647874 Jul 13 22:03 horde52-srpms.zip
The install size is:
i686
191 files
Install 174
Upgrade 17
177M
x64
193 files
Install 176
Upgrade 17
180M
The UI is completely redone in this version of horde, so you will need to spend some time getting familiar with it.
Please don't post any issues or problems to the above referenced bug at this time, especially since this isn't an official install, let's keep the discussion here.
I'll try to help here as much as I can, as time permits.
Good Luck for those of you that try.
Thanks,
John
-
Please for any takers...go ahead and test this really interesting software
-
Sounds great. Does it depend on the installed PHP version? I'd be looking at upgrading PHP to support Owncloud, but wouldn't want to break Horde in the process.
Edit: Heck, I can test that myself easily enough.
I notice that your install script calls for the RPMS to be in /root/horde52--does this directory need to be hardcoded? It seems it'd be just as easy to use a relative path, which would allow this to be unpacked in any directory (like an ibay, as is sometimes recommended for installation of extra software). Also, if you packaged it in a .tgz or .tar.bz2 file rather than .zip, it would preserve permissions (so the install script could be executable).
-
I installed these in a test server running SME 9.0, onto which I restored a backup of my production 8.1 server. I also upgraded to PHP 5.5.14 from the remi repository as discussed here: http://forums.contribs.org/index.php/topic,50961.0.html
Using it in Google Chrome on the desktop, it runs well and looks very nice. It also works (in a brief test) on my iPad. More testing to follow.
-
I've run into what may be a bug. At least sometimes (it doesn't seem to happen all the time, but I haven't nailed down specific circumstances to make it repeatable), using the "hide deleted messages" option will result in _all_ messages being hidden. Toggling that option off and back on seems to clear the problem, and results in the messages being visible, with the exception of those that are marked as deleted. I'll see if I can figure out what triggers this.
-
I've run into what may be a bug. At least sometimes (it doesn't seem to happen all the time, but I haven't nailed down specific circumstances to make it repeatable), using the "hide deleted messages" option will result in _all_ messages being hidden. Toggling that option off and back on seems to clear the problem, and results in the messages being visible, with the exception of those that are marked as deleted. I'll see if I can figure out what triggers this.
Hi Dan,
I can't duplicate this. I have three physical servers that I have horde 5.2 installed on. When I choose to hide deleted, only the deleted emails are removed. I haven't run across what you are saying with any of the horde 5.1 and above releases. There is nothing that I'm doing that would cause this behavior. If you can find how to duplicate it, and it's repeatable, then then we can report it to the horde devs, There are many others running this in their production networks, and I'm subscribed to all the horde mailing lists, and no one has reported this behavior, nor is there an open bug. Could this be related to the php upgrade you did? I'm running the php version that comes with SME 9
[root@www john]# php -v
PHP 5.3.3 (cli) (built: Dec 11 2013 03:29:57)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
-
It seems odd that it would be related to the PHP build, but I guess it's possible. I haven't been able to find a repeatable set of circumstances myself, though--I saw it a couple of times yesterday, but not since. If I can come up with a way to make it repeatable I'll post further.
-
thank you works perfectly for me on a new sme 9 server
-
hello
im now testing sme 9 and after i upgraded php55 remi i'm getting an error installing horde 5.2
Error: Package: php-intl-5.3.3-27.el6_5.x86_64 (/php-intl-5.3.3-27.el6_5.x86_64)
Requires: php-common(x86-64) = 5.3.3-27.el6_5
Installed: php-common-5.5.15-1.el6.remi.x86_64 (@remi-php55)
php-common(x86-64) = 5.5.15-1.el6.remi
now it's ok
i just installed php-intl from remi and now its working
yum install php-intl --enablerepo=remi,remi-php55
-
I think I may have found a bug. When I attempt to log in with incorrect information, I get this:
A fatal error has occurred
QUERY FAILED: Table 'horde.horde_histories_modseq' doesn't exist INSERT INTO horde_histories_modseq (history_modseqempty) VALUES(0)
Details have been logged for the administrator.
At the same time, a wall message is sent to the console and any logged in sessions:
Message from syslogd@e-smith at Aug 26 10:22:03 ...
HORDE: [horde] QUERY FAILED: Table 'horde.horde_histories_modseq' doesn't exist INSERT INTO horde_histories_modseq (history_modseqempty) VALUES(0) [pid 5738 on line 360 of "/usr/share/pear/Horde/Auth/Base.php"]
Having this go as a wall seems rather unnecessary.
In any event, the horde_histories_modseq table doesn't seem to be present:
[root@e-smith horde]# mysql horde
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 189434
Server version: 5.1.73 Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show tables;
+-----------------------------+
| Tables_in_horde |
+-----------------------------+
| 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_sentmail |
| ingo_forwards |
| ingo_lists |
| ingo_rules |
| ingo_shares |
| ingo_shares_groups |
| ingo_shares_users |
| ingo_spam |
| ingo_vacations |
| turba_objects |
| turba_shares |
| turba_shares_groups |
| turba_shares_users |
+-----------------------------+
34 rows in set (0.00 sec)
mysql>
I looked for the database scripts that horde has had in the past, but I couldn't find them anywhere in the horde directory.
-
Hi Dan,
I can't reproduce this. I've just done 6 new installs of SME 9, then installed horde 5.2.1, no issues. I also installed sme 8.1, backed up, installed sme 9, restored, then updated to horde 5.2.1, and finally installed sme9, restored my production server sme 8.1 data on it, then updated to horde 5.2.1, both with no errors.
Are you still running an upgraded version of PHP? If so, please test with the stock version that comes with SME 9. I'm not going to be able to support any deviations. There have been reports with incompatibility issues with php, but I think it's mostly with php 5.6.
You can login to horde as admin, and look at the configuration and see if any of the DB's show out of date, or from the command line run - php /usr/bin/horde-db-migrate and see if the output shows anything. If all is good, then you should see output that shows OK at the end.
Horde 5 doesn't use the old database scheme it did in 3. The horde-db-migrate script is what is used to update the database tables. All of my test servers are currently re-loading, so I can't tell you the exact location of the various database schema files.
John
-
It doesn't seem like something that should tie to a newer PHP version, but I guess it's possible. I'll try to test with the stock PHP version, though it may take a while to get to that.
The command-line horde-db-migrate returned nothing, but when I logged in as admin most db schemas were shown as out of date. The entry for Horde didn't (and still doesn't) list any database/schema status--I suspect this might be where the problem lies. I updated them, logged out, and the problem persists.
I note that most or all of the other apps have a *_schema_info table which isn't present for horde. A little bit of googling suggests that there should actually be several such tables--horde_alarms_schema_info, horde_group_schema_info, etc. I don't have any of these. (I'm also baffled as to why that information is on the parallels.com knowledge base, but that's neither here nor there). Time to do some more digging, it seems.
Interestingly, my SME 9 test server (which I used to test the migration from 8 to 9) has the upgraded PHP, and also has a completely different set of horde_* tables:
| horde_activesync_cache |
| horde_activesync_device |
| horde_activesync_device_users |
| horde_activesync_mailmap |
| horde_activesync_map |
| horde_activesync_schema_info |
| horde_activesync_state |
| horde_alarm_schema_info |
| horde_alarms |
| horde_auth_schema_info |
| horde_cache |
| horde_cache_schema_info |
| horde_categories |
| horde_categories_categories |
| horde_core_schema_info |
| horde_datatree |
| horde_datatree_attributes |
| horde_datatree_seq |
| horde_dav_collections |
| horde_dav_objects |
| horde_dav_schema_info |
| horde_group_schema_info |
| horde_groups |
| horde_groups_members |
| horde_histories |
| horde_histories_modseq |
| horde_history_schema_info |
| horde_imap_client_data |
| horde_imap_client_message |
| horde_imap_client_metadata |
| horde_imap_client_schema_info |
| horde_lock_schema_info |
| horde_locks |
| horde_muvfs |
| horde_perms |
| horde_perms_schema_info |
| horde_prefs |
| horde_prefs_schema_info |
| horde_queue_schema_info |
| horde_queue_tasks |
| horde_sessionhandler |
| horde_sessionhandler_schema_info |
| horde_signups |
| horde_syncml_anchors |
| horde_syncml_map |
| horde_syncml_schema_info |
| horde_token_schema_info |
| horde_tokens |
| horde_users |
| horde_vfs |
| horde_vfs_schema_info |
It does handle failed logins correctly. I can't say with certainty, though, whether I upgraded PHP before or after I upgraded Horde.
-
Don't forget if you upgrade php with the remi repository....you upgrade also mysql....maybe it tied to your issue.
-
No, mysql is the stock version from the DVD:
[dan@e-smith ~]$ rpm -q mysql
mysql-5.1.73-3.el6_5.x86_64
It does look like (if I'm using yum history correctly) I upgraded PHP after horde on the test server, and before horde on my production server. If this is a php version issue, that would explain the different results.
-
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
-
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
-
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:
(http://www.familybrown.org/transfer/Screen%20Shot%202014-08-27%20at%203.24.21%20PM.png)
Here's the current list of tables:
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:
(http://www.familybrown.org/transfer/Screen%20Shot%202014-08-27%20at%203.34.37%20PM.png)
-
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
pear list -c hordeYou should have these modules installed if you've used the latest files from my contribs directory.
[/code]
[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
-
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?
-
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
-
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:
[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.
-
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'.
-
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
-
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.
-
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
-
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.
-
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
-
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
-
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
-
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.
-
Yep, that's for the correction. I didn't see on the sogo.nu demo site that I could create or change them yesterday, but today I found it.
-
For anyone following this, I have regained access to my contribs directory, and have updated the horde files to the latest versions, current as of this comment. Should be available once the mirrors sync. http://bugs.contribs.org/show_bug.cgi?id=6653 (http://bugs.contribs.org/show_bug.cgi?id=6653).
Thanks,
John
-
Hi John
I install horde 5.2 as per your last files since long time ( don't remember when exactly) . Run good without problem for my use.
Just got your last files and install it. No problem during installation.
Start to use it, let you know if i got problem with it.
First impression, the filter for mail look great. Need to test it.
Thanks for your work. :-) :-)
Note: Do you expect to add Gollem and Trean in the package.
-
Yes, I have them made and use them also. They are not as good as the v3 ones, yet. Gollem, the webdav was removed, so you can no longer click on the gollem icon when composing an email and attach a file from your home directory on the server. I used this a lot when I was traveling and needed a file. Trean you can't create folders to group your bookmarks in.
When the mirrors sync, they will be in the horde directory.
John
-
I installed gollem from your mirror. No error message during the process.
Open my webmail ( horde ) to check the new apps and get no file manager menu.
After some investigation find out that we need to add properties horde database.
config setprop horde smb enabled
That the one i use.
Now the file manager menu appear in horde. Run good. No problem for now.
:pint: Thanks for the job.
-
Hi John
Install trean from your depot. Both addons ( trean & gollem ) work great and no bugs to report.
Work to import calendar to thunderbird program and get ADMIN ACCESS problem to view url for it. Found solution, apply patch from https://bugs.horde.org/ticket/13808 (https://bugs.horde.org/ticket/13808) and get ADMIN ACCESS to see url for thunderbird. Work OK now.
I start to play with wicked & ansel. Both work ok now with manual config file.
Thanks for your work on horde.
-
Yes, I'm aware of this bug, and it's been fixed in imp 6.2.7. I hadn't been updating my contribs dir as often because I didn't know if anyone was really using this as much as I am. I will update it today. I will also update it with wicked, ansel, and whups if you want to have a go at those.
John
-
That great :-P
I will check your contribs for the latest rpm.
-
When I try to install Horde 5.2, following Remi's description, I get lots of error messages similar to this:
Error: Package: Horde_Share-2.0.7-1.el6.noarch (/Horde_Share-2.0.7-1.el6.noarch)
Requires: Horde_Url < 3.0.0alpha1
Where might I find the missing package?
-
not sure that is a good idea since often remi's rpm can ask some upgrade of php/mysql. I would prefer that you use the jBennet way
http://forums.contribs.org/index.php/topic,50969.msg257624.html#msg257624
-
When I try to install Horde 5.2, following Remi's description, I get lots of error messages similar to this:
Error: Package: Horde_Share-2.0.7-1.el6.noarch (/Horde_Share-2.0.7-1.el6.noarch)
Requires: Horde_Url < 3.0.0alpha1
Where might I find the missing package?
That's on me. I accidentally deleted it and didn't realize it. Give me a couple of days.
John
-
thank john
-
When the repos sync, you should be back in business. File dates should show 8/26/2015
John
-
Thank you! Now I succeeded in installing Horde 5.2.
Unfortunately, many things don't work. I can login and check my mail, that's fine. But I get database errors, whenever I try to explore the new version. If I, e.g., select Calendar, I get:
HORDE: QUERY FAILED: Unknown column 'share_parents' in 'field list' INSERT INTO kronolith_shares (share_name, share_parents, share_owner, attribute_name, attribute_color, perm_creator, perm_default, perm_guest, share_flags) VALUES ('thN6FmM7fpmc01of3B_ZIVt', NULL, 'holck@dk', 'Calendar of holck', '#a3dd66', 0, 0, 0, 0) [pid 10941 on line 1669 of "/usr/share/pear/Horde/Registry.php"]
I guess I need to do some database-related update?
-
I've never seen this, and I've upgraded my test boxes from horde 3 to horde 5 more times that I can say. Is this test or production?
share_parents is a valid field for the kronolith_shares table on all of my servers.
Were you using shared calendars with horde 3?
I just manually dropped that field on my test server
mysql
connect horde;
drop table kronolith_shares;
quit;
then signal-event post-upgrade ; signal-event reboot, and the field wasn't added back.
We can try to TS and see if we can figure out what's going on, or we can try to fix the table, but that may result in you not having any shared calendars if you were using any.
You can dump the current horde db using something like this
mysqldump --opt horde > /root/old_horde_db.sql That way, you have a backup of all of the data before any changes were made.
Then if you want to re-add that field to the table
mysql
connect horde;
DROP TABLE kronolith_schema_info;
quit;Once that is done, then run
php /usr/bin/horde-db-migrate You should see the kronolith tables being rebuilt.
Finally do this:
mysql
connect horde;
describe kronolith_shares;
quit;
You should see the share_parents field as the last item in that table.
This worked for me on my test servers. If you try this, I will be real interested in your results.
Good Luck,
John
-
Thank you very much for your help and suggestions. The server is in production, but running Horde is not critical.
My problems are not only related to the Kronolith tables, they occur all over. I've tried this
$ /usr/bin/horde-db-migrate
it showed no errors, no output at all. But if I run the script from PHP, I get:
$ php -f /usr/bin/horde-db-migrate
PHP Warning: require_once(/usr/share/pear/www/horde/lib/Application.php): failed to open stream: No such file or directory in /usr/bin/horde-db-migrate on line 29
PHP Fatal error: require_once(): Failed opening required '/usr/share/pear/www/horde/lib/Application.php' (include_path='.:/usr/share/pear-addons:/usr/share/pear') in /usr/bin/horde-db-migrate on line 29
So I guess this is part of an answer to my problems... Is /home/httpd/html/horde/lib/Application.php the file to use?
-
I can't reproduce your issues, workable here in one shot on sme9 X64
-
What version of PHP are you using?
php -vIf anything other than the current version included with SME Server, then I'll have a hard time helping. What contribs do you have installed? Have you made any other system modifications? If you execute pear list then pear list -c horde and paste that, then I will compare what you installed vs what all my systems have for horde. My three test servers, and my production server show the exact same version info. Lastly, what does your include_path show in php.ini? Mine shows, include_path = ".:/usr/share/pear-addons:/usr/share/pear"
John
-
The php script horde-db-migrate was installed in /usr/bin, and that caused problems for me. This script, as well as a number of other horde-* scripts, comes from the installation of horde-5.2.7-1.el6.noarch . Now I've copied all these scripts to a new directory, /home/httpd/html/horde/bin, and most things seem to run smoothly :-)
If you take a look at the code in horde-db-migrate, it's obvious that this file doesn't belong in /usr/bin :
$baseFile = __DIR__ . '/../lib/Application.php';
So I think this is an error in the horde-5.2.7-1.el6.noarch file I downloaded:
[holck@karoline bin]$ rpm -q --filesbypkg horde | grep bin
horde /home/httpd/html/horde/themes/default/graphics/mime/binary.png
horde /usr/bin/horde-active-sessions
horde /usr/bin/horde-alarms
horde /usr/bin/horde-check-logger
horde /usr/bin/horde-clear-cache
horde /usr/bin/horde-crond
horde /usr/bin/horde-db-migrate
horde /usr/bin/horde-import-openxchange-prefs
horde /usr/bin/horde-import-squirrelmail-prefs
horde /usr/bin/horde-memcache-stats
horde /usr/bin/horde-pref-remove
horde /usr/bin/horde-queue-run-tasks
horde /usr/bin/horde-remove-user-data
horde /usr/bin/horde-run-task
horde /usr/bin/horde-sessions-gc
horde /usr/bin/horde-set-perms
horde /usr/bin/horde-sql-shell
horde /usr/bin/horde-themes
horde /usr/bin/horde-translation
-
The file DOES belong in user bin. It's there on all 4 of my systems. It's been that same way, since the first time I released the packages. You didn't provide me the output or answer the other questions I asked for, so I have no way of knowing what your issue is/was.
John
-
Sorry, I wanted to help and thought I found a bug. I don't know much about php, but as I read the source code in horde-db-migrate, it tries to find /usr/lib/Application.php which isn't there, and then the program fails. So the problem may be related to the include_path. The file /etc/php.ini on my server shows
include_path = ".:/usr/share/pear-addons:/usr/share/pear"$ php -v
PHP 5.3.3 (cli) (built: Jul 9 2015 17:39:00)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
$ pear list
Installed packages, channel pear.php.net:
=========================================
Package Version State
Archive_Tar 1.4.0 stable
Auth_SASL 1.0.6 stable
Auth_SASL2 0.1.0 beta
Cache 1.5.6 stable
Cache_Lite 1.7.16 stable
Console_Color 1.0.3 stable
Console_Getargs 1.3.5 stable
Console_Getopt 1.3.1 stable
Console_GetoptPlus 1.0.0RC1 beta
Console_Table 1.2.1 stable
Crypt_Blowfish 1.1.0RC2 beta
DB 1.8.2 stable
Date 1.5.0a4 alpha
Date_Holidays 0.21.8 alpha
Date_Holidays_Australia 0.2.2 alpha
Date_Holidays_Denmark 0.1.3 alpha
Date_Holidays_Germany 0.1.2 alpha
Date_Holidays_Italy 0.1.1 alpha
Date_Holidays_Netherlands 0.1.4 alpha
Date_Holidays_Norway 0.1.2 alpha
Date_Holidays_Portugal 0.1.1 alpha
Date_Holidays_Russia 0.1.0 alpha
Date_Holidays_Slovenia 0.1.2 alpha
Date_Holidays_Sweden 0.1.3 alpha
Date_Holidays_Turkey 0.1.1 alpha
Date_Holidays_USA 0.1.1 alpha
File 1.4.1 stable
File_CSV 1.0.0 stable
File_Find 1.3.3 stable
File_Fstab 2.0.3 stable
File_Util 1.0.0 stable
HTTP 1.4.1 stable
HTTP_Request 1.4.4 stable
HTTP_Request2 2.2.1 stable
HTTP_WebDAV_Server 1.0.0RC8 beta
Image_Text 0.6.1 beta
Log 1.12.9 stable
MDB2 2.5.0b5 beta
MDB2_Driver_mysql 1.5.0b4 beta
Mail 1.2.0 stable
Mail_Mime 1.9.0 stable
Mail_mimeDecode 1.5.5 stable
Math_BigInteger 1.0.2 stable
Net_DIME 1.0.2 stable
Net_DNS2 1.4.1 stable
Net_FTP 1.4.0 stable
Net_IDNA2 0.1.1 beta
Net_IMAP 1.1.3 stable
Net_SMTP 1.6.3 stable
Net_Sieve 1.3.4 stable
Net_Socket 1.0.14 stable
Net_URL 1.0.15 stable
Net_URL2 2.2.0 stable
Numbers_Words 0.16.2 beta
PEAR 1.9.5 stable
SOAP 0.13.0 beta
Services_Weather 1.4.7 stable
Structures_Graph 1.0.4 stable
Text_CAPTCHA 0.4.4 alpha
Text_Figlet 1.0.2 stable
Text_Password 1.1.1 stable
XML_Parser 1.3.4 stable
XML_Parser2 0.1.0 beta
XML_RPC 1.5.5 stable
XML_RPC2 1.1.2 stable
XML_SVG 1.1.0 stable
XML_Serializer 0.20.2 beta
XML_Util 1.2.3 stable
]$ pear list -c horde
Installed packages, channel pear.horde.org:
===========================================
Package Version State
Horde_ActiveSync 2.29.0 stable
Horde_Alarm 2.2.5 stable
Horde_Argv 2.0.11 stable
Horde_Auth 2.1.10 stable
Horde_Autoloader 2.1.1 stable
Horde_Browser 2.0.10 stable
Horde_Cache 2.5.0 stable
Horde_Cli 2.0.6 stable
Horde_Compress 2.1.3 stable
Horde_Compress_Fast 1.1.0 stable
Horde_Constraint 2.0.2 stable
Horde_Controller 2.0.3 stable
Horde_Core 2.20.8 stable
Horde_Crypt 2.6.1 stable
Horde_Crypt_Blowfish 1.1.0 stable
Horde_CssMinify 1.0.2 stable
Horde_Css_Parser 1.0.7 stable
Horde_Data 2.1.3 stable
Horde_Date 2.1.1 stable
Horde_Date_Parser 2.0.4 stable
Horde_Dav 1.1.2 stable
Horde_Db 2.2.3 stable
Horde_Editor 2.0.4 stable
Horde_ElasticSearch 1.0.3 stable
Horde_Exception 2.0.6 stable
Horde_Feed 2.0.3 stable
Horde_Form 2.0.11 stable
Horde_Group 2.0.5 stable
Horde_HashTable 1.2.3 stable
Horde_History 2.3.5 stable
Horde_Http 2.1.5 stable
Horde_Icalendar 2.1.1 stable
Horde_Idna 1.0.3 stable
Horde_Image 2.3.2 stable
Horde_Imap_Client 2.29.1 stable
Horde_Injector 2.0.4 stable
Horde_Itip 2.1.0 stable
Horde_JavascriptMinify 1.1.2 stable
Horde_JavascriptMinify_Jsmin 1.0.1 stable
Horde_Ldap 2.3.1 stable
Horde_ListHeaders 1.2.2 stable
Horde_Lock 2.1.1 stable
Horde_Log 2.1.2 stable
Horde_LoginTasks 2.0.5 stable
Horde_Mail 2.6.2 stable
Horde_Mail_Autoconfig 1.0.2 stable
Horde_Mapi 1.0.5 stable
Horde_Mime 2.9.1 stable
Horde_Mime_Viewer 2.1.1 stable
Horde_Nls 2.0.5 stable
Horde_Notification 2.0.2 stable
Horde_Oauth 2.0.3 stable
Horde_Pack 1.0.5 stable
Horde_Pdf 2.0.5 stable
Horde_Perms 2.1.5 stable
Horde_Prefs 2.7.4 stable
Horde_Queue 1.1.2 stable
Horde_Rdo 2.0.4 stable
Horde_Role 1.0.1 stable
Horde_Routes 2.0.4 stable
Horde_Rpc 2.1.5 stable
Horde_Scribe 2.0.2 stable
Horde_Secret 2.0.4 stable
Horde_Serialize 2.0.4 stable
Horde_Service_Facebook 2.0.8 stable
Horde_Service_Twitter 2.1.5 stable
Horde_Service_Weather 2.1.6 stable
Horde_SessionHandler 2.2.4 stable
Horde_Share 2.0.7 stable
Horde_Smtp 1.9.1 stable
Horde_Socket_Client 2.0.0 stable
Horde_SpellChecker 2.1.2 stable
Horde_Stream 1.6.2 stable
Horde_Stream_Filter 2.0.3 stable
Horde_Stream_Wrapper 2.1.2 stable
Horde_Stringprep 1.0.2 stable
Horde_Support 2.1.4 stable
Horde_SyncMl 2.0.5 stable
Horde_Template 2.0.2 stable
Horde_Text_Diff 2.1.1 stable
Horde_Text_Filter 2.3.2 stable
Horde_Text_Filter_Csstidy 2.0.1 stable
Horde_Text_Flowed 2.0.2 stable
Horde_Thrift 2.0.2 stable
Horde_Timezone 1.0.9 stable
Horde_Token 2.0.6 stable
Horde_Translation 2.2.0 stable
Horde_Tree 2.0.4 stable
Horde_Url 2.2.4 stable
Horde_Util 2.5.6 stable
Horde_Vfs 2.3.0 stable
Horde_View 2.0.5 stable
Horde_Xml_Element 2.0.3 stable
Horde_Xml_Wbxml 2.0.2 stable
content 2.0.4 stable
horde 5.2.7 stable
horde_lz4 1.0.7 stable
imp 6.2.10 stable
ingo 3.2.6 stable
kronolith 4.2.9 stable
mnemo 4.2.7 stable
nag 4.2.5 stable
timeobjects 2.1.0 stable
turba 4.2.8 stable
-
From what I can tell, it looks like you have installed some packages from remi's repo. If you have, then that could be very well why you are having issues. I don't include horde_lz4, but remi has built an rpm for it. Remi's PEAR-1.9.5 rpm broke things, so I don't use that either. I also don't include net_IDNA2, Numbers_Words, Text_Captcha, Text_Passwords. You will have to verify if you used files from him. A standard SME server 9 install with all updates works with no issues when adding horde in all tests I have done.
Thank you,
John
-
Hi guys sorry I'm confused how to get the admin login and settings as per the screenshot on this thread.
If I login as admin I do not get the "configuration" section on the left pane. On my SME consoile I see this error at the same time - it looks like horde does not think I am an admin?
HORDE: [horde] Permission denied. [pid 2229 on line 373 of "/usr/share/pear/Horde/Registry.php"]
I also tried editing /home/httpd/html/horde/config/conf.php to set as below but still it does not think I'm ad admin!
$conf['auth']['admins'] = array('admin@mydomain.local', 'admin');
So what do I do to get the admin interface please?
-
The admin user is automatically added. To add more:
config setprop horde Admins user1,user2expand-template /home/httpd/html/horde/config/conf.php
When you login, you should be able to click on the gear icon, choose Administration, configuration. If you still don't see it, click on the word horde at the top left, then look at the right and note who you are logged in as. Reply back with that, and show what you have listed in
$conf['auth']['admins'] = array
from /home/httpd/html/horde/config/conf.php
John
-
Hi John, that's great I now see the administration menu thanks. I had to add manually my user which was admin@number into the config file.
I also had to increase the php memory limit so I could see the horde config page
-
Upgraded without errors, works great, especially the mobile version.
Should be pushed for everyone, old H3 freezes on phones after login.
-
Hi John,
I have downloaded the latest Horde 5.2 RPMS zip archive dated July 29th. I do have two issues/questions:
1. There is no installation script in the zip file (missing Install-horde52.sh) only RPMS
2. I would like to install on SME 9.1 64 bit version, in the RPMS there are Horde_Form-2.0.13-1.el6.noarch.rpm and Horde_Form-2.0.14-1.el6.noarch.rpm which makes an issue to just execute yum localinstall *.rpm
Any guidance how to proceed?
Thanks,
Miro
-
I noticed the missing script too. You need to copy all RPMs from the subdir coresponding to your architecture and then try: yum localinstall *.rpm
-
"localinstall" isn't necessary with current versions of yum; "yum install whatever" works just as well.
-
Sorry about that. I was uploading some updates, and forgot that file. I'm re-uploading everything as of this post.
John
-
Hi John,
Thank you for the updated files. Now the install script is there. However there are several older files which has to be removed to perform installation:
Horde_Mime_Viewer-2.1.3-1.el6.noarch.rpm
Horde_Form-2.0.13-1.el6.noarch.rpm
Horde_Core-2.24.0-1.el6.noarch.rpm
Horde_Auth-2.1.12-1.el6.noarch.rpm
Since there are newer files as well in the RPMS folder which makes conflict in the installation. After removing the above mentioned files, the installation went flawlessly.
Thanks,
Miro
PS I have noticed an issue with the Horde 5.2.11 RPM's. I don't know why, but instead the whole domain name in the mail, it takes only last two (example org.rs instead of beta.org.rs). You can change it in the default identity settings, but it shouldn't happen like this.
Any clue what might be the issue or any other facing the same issue with the 5.2.11 RPM's?
-
Hi John,
The new RPMS of Horde 5.2.12 looks good. Update went smooth, no issues found.
I do have the same issues with users who didn't enter information in their identity settings, or to be more precise The default e-mail address to use with this identity:.
Thanks,
Miro
-
Hi John,
The new RPMS of Horde 5.2.12 looks good. Update went smooth, no issues found.
I do have the same issues with users who didn't enter information in their identity settings, or to be more precise The default e-mail address to use with this identity:.
Thanks,
Miro
Hi Miro,
I haven't been checking this for a while. I think I might know where the issue is, but I'm not a real coder, so I don't know if I can fix it, or will need the help of the community to do so. I"m pretty sure, it has something to do with the way the hook is coded in /home/httpd/html/horde/config/hooks.local.php. I'll have a look some time soon, and see what I can do.
Thank you,
John
-
Hi John,
You are right, you have nailed the problem! It looks that /home/httpd/html/horde/config/hooks.local.php is the issue.
For a test I have just inserted a line in the hooks.local.php and the issue was gone. I have created a new one, but I'm not a php coder either. I'll try to figure out where the problem occurs.
Thank you!
Miro
-
For a test I have just inserted a line in the hooks.local.php and the issue was gone.
What exactly have you done, so Joh and others can verify please?
-
Actually I've been updating through Administration > Configuration > Check for new versions
and then pear install horde/module_name for every module that has an update. Is that ok?
-
What exactly have you done, so Joh and others can verify please?
Hi,
As I have mentioned, I was adding only one line (bold in the code) which was for testing purposes only. This is not a solution and makes new issues with the second loging, it just solved the problem with truncated domain. The original code should be checked and modified with knowledge of php and horde/SME internals, it is not a solution.
public function authusername($userId, $toHorde)
{
// Example #1: Append the virtual domain to the username.
// ex. $HTTP_HOST = 'mail.mydomain.com', $userId = 'myname' returns:
// 'myname@mydomain.com'
$vdomain = getenv('HTTP_HOST');
preg_match('/[^.]+\.[^.]+$/', $vdomain, $matches);
$vdomain = $matches[0];
$vdomain = 'mydomain.com.mk';
if ($userId == 'adminremoveuser') {
return $userId;
} else {
if ($toHorde) {
return $userId . '@' . $vdomain;
} else {
return (substr($userId, -strlen($vdomain)) == $vdomain)
? substr($userId, 0, -strlen($vdomain)-1)
: $userId;
}
}
}
-
Hi as I said, it was only one line (bold in the code) which was for testing purposes only. This is not a solution and makes new issues with the second loging, it just solved the problem with truncated domain. The original code should be checked and
public function authusername($userId, $toHorde)
{
// Example #1: Append the virtual domain to the username.
// ex. $HTTP_HOST = 'mail.mydomain.com', $userId = 'myname' returns:
// 'myname@mydomain.com'
$vdomain = getenv('HTTP_HOST');
preg_match('/[^.]+\.[^.]+$/', $vdomain, $matches);
$vdomain = $matches[0];
$vdomain = 'mydomqin.com.mk';
if ($userId == 'adminremoveuser') {
return $userId;
} else {
if ($toHorde) {
return $userId . '@' . $vdomain;
} else {
return (substr($userId, -strlen($vdomain)) == $vdomain)
? substr($userId, 0, -strlen($vdomain)-1)
: $userId;
}
}
}
That works when you only have 1 domain configured on your server. If you have more, and want users to login to webmail using the other domain, then all of those user settings will be saved in mysql using whatever is hard-coded in $vdomain. It might be a moot point, since all users are part of the same system. I had thought about setting up a template to use the main domain as $vdomain a long time ago, but didn't thinking it might be better to be able to save user settings using the domain they used to login with. I think there's a way to do this better using specific conf.d directives, which can be set unique for each domain, and also allow in turba to filter names based on the domain you are using. I haven't looked or tested any of that.
John
-
Actually I've been updating through Administration > Configuration > Check for new versions
and then pear install horde/module_name for every module that has an update. Is that ok?
On my dev box, I do a pear ua about once a month to see what's been updated, or when a new major release comes out. Then I update the necessary RPM's. Both work, but I believe a long while back one of the core devs was against individual users doing something like this to update their systems, or using other methods other than RPM installs, as it could be harder to diagnose problems.
John
-
That works when you only have 1 domain configured on your server. If you have more, and want users to login to webmail using the other domain, then all of those user settings will be saved in mysql using whatever is hard-coded in $vdomain. It might be a moot point, since all users are part of the same system. I had thought about setting up a template to use the main domain as $vdomain a long time ago, but didn't thinking it might be better to be able to save user settings using the domain they used to login with. I think there's a way to do this better using specific conf.d directives, which can be set unique for each domain, and also allow in turba to filter names based on the domain you are using. I haven't looked or tested any of that.
John
Hi John,
Fully agree, I do have only one domain, and as I said, I have only used the line to test whether this is solving the problem I had. I was previously looking in the mysql tables to find the domain somewhere stored, but without success. Your proposal looks as proper and long term solution, but unfortunately beyond my knowledge of Horde and SME.
Miro
-
SMEserver9.1
Had the SoGo contrib installed and saw this update thread for Horde 5.2 so I installed as per wiki instructions and all appeared to go fine.
When I went to www.domain.com/webmail it immediately went to SoGo so I removed SoGo as per wiki instructions for that contrib.
After the reconfig and restart now I cannot access webmail at all.
When I go to www.domain.com/webmail this is what I see:
#------------------------------------------------------------ # !!DO NOT MODIFY THIS FILE!! # # Manual changes will be lost when this file is regenerated. # # Please read the developer's guide, which is available # at http://www.contribs.org/development/ # # Copyright (C) 1999-2006 Mitel Networks Corporation #------------------------------------------------------------ // 110AppRegistryHorde $this->applications['horde'] = array( 'fileroot' => dirname(__FILE__) . '/..', 'webroot' => '/horde', 'initial_page' => 'login.php', 'name' => _("My - Web Mail"), 'status' => 'active', 'templates' => dirname(__FILE__) . '/../templates', 'provides' => 'horde' );
Would anyone have any advise for how I can fix this delema I have? Is there a way to uninstall horde 5.2 and then reinstall again?
Thanks in advance
-edb
-
Ok I uninstalled and then reinstall horde 5.2 and now I can access the webmail interface.
I can see my email but when I click on Calendar I get error
"dynamic/sidebar.html.php" not found in template path ("/home/httpd/html/horde/templates/:./")
also when I click the address book I get the following error:
A fatal error has occurred
QUERY FAILED: Unknown column 'share_parents' in 'field list' INSERT INTO turba_shares (share_name, share_parents, share_owner, attribute_name, attribute_params, perm_creator, perm_default, perm_guest, share_flags) VALUES ('H4CUfhEG3hvJNxw8Yzmzg93', NULL, 'admin@10.25', 'Address book of admin', 'a:3:{s:6:\"source\";s:8:\"localsql\";s:7:\"default\";b:1;s:4:\"name\";s:11:\"admin@10.25\";}', 0, 0, 0, 0)
Any idea as to how I can fix this issue? Thanks
-
Ok I uninstalled and then reinstall horde 5.2 and now I can access the webmail interface.
I can see my email but when I click on Calendar I get error
"dynamic/sidebar.html.php" not found in template path ("/home/httpd/html/horde/templates/:./")
also when I click the address book I get the following error:
A fatal error has occurred
QUERY FAILED: Unknown column 'share_parents' in 'field list' INSERT INTO turba_shares (share_name, share_parents, share_owner, attribute_name, attribute_params, perm_creator, perm_default, perm_guest, share_flags) VALUES ('H4CUfhEG3hvJNxw8Yzmzg93', NULL, 'admin@10.25', 'Address book of admin', 'a:3:{s:6:\"source\";s:8:\"localsql\";s:7:\"default\";b:1;s:4:\"name\";s:11:\"admin@10.25\";}', 0, 0, 0, 0)
Any idea as to how I can fix this issue? Thanks
I don't really know how you got into that situation. That column is valid on my system. Did you do a post-upgrade and reboot? From the server console, you can run this:
php /usr/bin/horde-db-migrate
Watch the screen, all of the items should say INFO. If they don't run it again, then post the output and I'll see if I can help.
John
-
Hi John and thank you very much for your reply.
I also don't know how I got into this situation very strange as the server was completely updated but not sure if the SoGo contrib had anything to do with it but I think it may be coincidence.
I issued that command php /usr/bin/horde-db-migrate however I see no output from the command.
-
Hi John
It looks like I may have some missing mysql tables.
When I click on the Calendar, Address Book, Tasks or Notes it generates an error about not finding the table.
When I have a look at the listed Horde tables some are missing hence the errors from the browser interface.
Is there a way to repair/restore the tables? Something with the table migration may not have gone right at some point.
Thank for your help
-
Hi John
It looks like I may have some missing mysql tables.
When I click on the Calendar, Address Book, Tasks or Notes it generates an error about not finding the table.
When I have a look at the listed Horde tables some are missing hence the errors from the browser interface.
Is there a way to repair/restore the tables? Something with the table migration may not have gone right at some point.
Thank for your help
Yes, that is what I figured, which is why I was having you run the horde-db-migrate script. It updates/migrates the tables. What php version are you running?
On my system:
php -v
PHP 5.3.3 (cli) (built: Aug 11 2016 20:33:53)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
If you happen to be running anything else, I'm not going to be able to help much.
Try running the migrate script again, but in another session tail -f /var/log/messages and see what it's showing. Also, what do you get when you run pear list -c horde.
-
Hi John,
I ran the command again and here is the output of the log
[root@~]# tail -f /var/log/messages
Oct 6 22:01:32 defcon1 HORDE: [mnemo] SQL QUERY FAILED: Table 'horde.mnemo_shar
es' doesn't exist #011SHOW FIELDS FROM `mnemo_shares` [pid 2401 on line 316 of
"/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Oct 6 22:01:32 defcon1 HORDE: [mnemo] QUERY FAILED: Table 'horde.mnemo_shares'
doesn't exist SHOW FIELDS FROM `mnemo_shares` [pid 2401 on line 317 of "/usr/sh
are/pear/Horde/Db/Adapter/Mysqli.php"]
[root@~]# php -v
PHP 5.3.3 (cli) (built: Aug 11 2016 20:33:53)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
with Zend Guard Loader v3.3, Copyright (c) 1998-2010, by Zend Technologies
Installed packages, channel pear.horde.org:
===========================================
Package Version State
Horde_ActiveSync 2.35.0 stable
Horde_Alarm 2.2.8 stable
Horde_Argv 2.0.12 stable
Horde_Auth 2.2.0 stable
Horde_Autoloader 2.1.2 stable
Horde_Browser 2.0.12 stable
Horde_Cache 2.5.4 stable
Horde_Cli 2.0.7 stable
Horde_Compress 2.1.5 stable
Horde_Compress_Fast 1.1.1 stable
Horde_Constraint 2.0.3 stable
Horde_Controller 2.0.4 stable
Horde_Core 2.26.1 stable
Horde_Crypt 2.7.3 stable
Horde_Crypt_Blowfish 1.1.2 stable
Horde_CssMinify 1.0.2 stable
Horde_Css_Parser 1.0.11 stable
Horde_Data 2.1.4 stable
Horde_Date 2.3.1 stable
Horde_Date_Parser 2.0.6 stable
Horde_Dav 1.1.3 stable
Horde_Db 2.3.3 stable
Horde_Editor 2.0.4 stable
Horde_ElasticSearch 1.0.3 stable
Horde_Exception 2.0.8 stable
Horde_Form 2.0.15 stable
Horde_Group 2.1.1 stable
Horde_HashTable 1.2.6 stable
Horde_History 2.3.6 stable
Horde_Http 2.1.7 stable
Horde_Icalendar 2.1.4 stable
Horde_Idna 1.0.4 stable
Horde_Image 2.3.6 stable
Horde_Imap_Client 2.29.9 stable
Horde_Injector 2.0.5 stable
Horde_Itip 2.1.2 stable
Horde_JavascriptMinify 1.1.3 stable
Horde_JavascriptMinify_Jsmin 1.0.2 stable
Horde_Ldap 2.3.2 stable
Horde_ListHeaders 1.2.4 stable
Horde_Lock 2.1.4 stable
Horde_Log 2.2.0 stable
Horde_LoginTasks 2.0.7 stable
Horde_Mail 2.6.3 stable
Horde_Mail_Autoconfig 1.0.3 stable
Horde_Mapi 1.0.8 stable
Horde_Mime 2.10.1 stable
Horde_Mime_Viewer 2.2.1 stable
Horde_Nls 2.2.0 stable
Horde_Notification 2.0.4 stable
Horde_Oauth 2.0.3 stable
Horde_Pack 1.0.6 stable
Horde_Pdf 2.0.7 stable
Horde_Perms 2.1.7 stable
Horde_Prefs 2.8.0 stable
Horde_Queue 1.1.4 stable
Horde_Rdo 2.1.0 stable
Horde_Role 1.0.1 stable
Horde_Routes 2.0.5 stable
Horde_Rpc 2.1.7 stable
Horde_Scribe 2.0.2 stable
Horde_Secret 2.0.6 stable
Horde_Serialize 2.0.5 stable
Horde_Service_Facebook 2.0.9 stable
Horde_Service_Twitter 2.1.5 stable
Horde_Service_Weather 2.4.0 stable
Horde_SessionHandler 2.2.8 stable
Horde_Share 2.1.1 stable
Horde_Smtp 1.9.3 stable
Horde_Socket_Client 2.1.1 stable
Horde_SpellChecker 2.1.3 stable
Horde_Stream 1.6.3 stable
Horde_Stream_Filter 2.0.4 stable
Horde_Stream_Wrapper 2.1.3 stable
Horde_Stringprep 1.0.3 stable
Horde_Support 2.1.5 stable
Horde_SyncMl 2.0.7 stable
Horde_Template 2.0.3 stable
Horde_Text_Diff 2.1.2 stable
Horde_Text_Filter 2.3.5 stable
Horde_Text_Filter_Csstidy 2.0.1 stable
Horde_Text_Flowed 2.0.3 stable
Horde_Thrift 2.0.2 stable
Horde_Timezone 1.0.11 stable
Horde_Token 2.0.9 stable
Horde_Translation 2.2.1 stable
Horde_Tree 2.0.4 stable
Horde_Url 2.2.5 stable
Horde_Util 2.5.8 stable
Horde_Vfs 2.3.3 stable
Horde_View 2.0.6 stable
Horde_Xml_Element 2.0.4 stable
Horde_Xml_Wbxml 2.0.3 stable
content 2.0.5 stable
horde 5.2.12 stable
imp 6.2.16 stable
ingo 3.2.12 stable
kronolith 4.2.18 stable
mnemo 4.2.11 stable
nag 4.2.11 stable
timeobjects 2.1.2 stable
turba 4.2.16 stable
-
John how would I do a complete removal or reverse of the install script.
Since it was a yum localinstall of *.rpm how would I uninstall all of them or is that possible.
What would the command be to do that?
I may not have done it completely the last time as I manually selected all of the newly installed horde rpms and removed them then ran the install script again but I don't think I removed everything that was installed which may be why I have the issue.
Likely there is no easy way to do this ...
It seems that kronolith, mnemo, nag and turba seem to have the problem with the mysql tables.
Maybe these components didn't install properly or at all therefore the tables were not created.
Does simply running the script install all of those components or does one have to do additional steps?
-
Hi John,
I gave up on that particular install and fired up another VM of SME Server 9.1 with all updates installed then installed via the script.
Install went through with signal-event post-upgrade; signal-event reboot.
I noticed at the point where the migration was to happen a few items in red but it went past to quick for me to get a good look at what may have failed.
Upon reboot I logged into Webmail again and I again have the same results as before.
This is what I could capture as output from running the script: Will send separately as it is too big to attach
Also attached at bottom of file the output of tail -f /var/log/messages after the reboot.
-
I've been looking for a replacement for SoGo on a number of SME 9.1 servers, saw this thread and decided to try it. Download and install all went without any visible problems, and after a restart I can access the new Horde login page. However, when I enter my username and password, it waits fora second or two and then cycles back to the login prompt.
Looking at the logs, I've got this:
Nov 2 19:31:12 goldie HORDE: [horde] Login success for paul@co.uk to horde (2.102.163.33) [pid 2775 on line 164 of "/home/httpd/html/horde/login.php"]
Nov 2 19:31:12 goldie HORDE: [imp] Login success for paul (Horde user paul@co.uk) (2.102.163.33) to {imap://localhost/} [pid 2775 on line 157 of "/home/httpd/html/horde/imp/lib/Auth.php"]
When I deliberately mistyped my password, I got this:
Nov 2 19:31:37 goldie HORDE: [imp] [login] Authentication failed. [pid 2780 on line 730 of "/home/httpd/html/horde/imp/lib/Imap.php"]
Nov 2 19:31:37 goldie HORDE: [horde] FAILED LOGIN for paul to horde (2.102.163.33) [pid 2780 on line 199 of "/home/httpd/html/horde/login.php"]
This is a remote login attempt, using https://domain/webmail to access the page. I notice in the log that the domain name is truncated, but did see some mention of that in some of the earlier posts.
It seems to be accepting my correct password, just not loading Horde for me.
Any ideas? I'd really like to try this one - never very happy with the older version of Horde.
Paul.
-
Try doing the same from this post, https://forums.contribs.org/index.php/topic,50969.msg271247.html#msg271247. I haven't had time to look into how to possibly permanently fix this yet.
John
-
Try doing the same from this post, https://forums.contribs.org/index.php/topic,50969.msg271247.html#msg271247. I haven't had time to look into how to possibly permanently fix this yet.
John
Thanks John. That fixed the truncated domain name problem, but I still can't login:
ov 2 23:45:33 goldie HORDE: [horde] Login success for paul@xxxx.co.uk to horde (2.102.163.33) [pid 2691 on line 164 of "/home/httpd/html/horde/login.php"]
Nov 2 23:45:33 goldie HORDE: [imp] Login success for paul (Horde user paul@xxxxx.co.uk) (2.102.163.33) to {imap://localhost/} [pid 2691 on line 157 of "/home/httpd/html/horde/imp/lib/Auth.php"]
Nov 2 23:45:34 goldie HORDE: Guest user is not authorized for Mail (Host: host-2-102-163-33.as13285.net). [pid 2691 on line 324 of "/usr/share/pear/Horde/Registry.php"]
The SME server I'm using is a production server, but its been around for a long time - it has been migrated through every version since 2007, and does have a couple of odd problems, though I've never had problems logging into the standard Horde. I checked that I could do so before I went through the 5.2 install.
Any other ideas?
Paul
-
Just a small follow-up on this. My earlier attempts were all from remote. I'm now on site and I've been able to log in without any problems from within the local network. Looks good once I got there...
I've also been able to send mail successfully from within the local network. Now all I need to know is what is preventing me logging in when I'm not in the local network.
Paul.
-
I've had some problems myself right after upgrade, had to clear cache/cookies.
Kept seeing in the logs users failing to log in, but after running CCleaner it worked.
No ideea what was the cause of this, maybe some cookies from Horde3 were conflicting.
-
I've had some problems myself right after upgrade, had to clear cache/cookies.
Kept seeing in the logs users failing to log in, but after running CCleaner it worked.
No ideea what was the cause of this, maybe some cookies from Horde3 were conflicting.
Thanks. Seems something like that may have been causing my login problems. When I tried logging in from the local network this morning, I used Chromium rather than Seamonkey. I'm now back home and I can log in with either Chromium or Seamonkey. So whatever it was seems to have been cleared by my using a different browser for login.
Paul.
-
Hi John,
today I have upgraded to Horde 5.2
Install went well.
I did have issue logging in at first, but after clearing my cookies and restarting the browser, I logged in fine.
Now I have another issue, when I go to my calendar, all the events I had inputted before are gone.
As per your suggestion in earlier post, I did run:
php /usr/bin/horde-db-migrate
But afterwards, calendar is still empty.
When I first start calendar, I see following message pup-up for few seconds on top of calendar:
(https://i.imgsafe.org/2a226434bb.jpg)
-UPDATE-
When I go to Log Files I see this:
HORDE: [kronolith] SQL QUERY FAILED: Unknown column 'event_timezone' in 'field list' #011SELECT event_id, event_uid, event_description, event_location, #011 event_private, event_status, event_attendees, event_title, #011 event_recurcount, event_url, event_timezone, event_recurtype, #011 event_recurenddate, event_recurinterval, event_recurdays, event_start, #011 event_end, event_allday, event_alarm, event_alarm_methods, #011 event_modified, event_exceptions, event_creator_id, event_resources, #011 event_baseid, event_exceptionoriginaldate FROM kronolith_events WHERE #011 calendar_id = 'xxxxx@xxxxxx' AND ((event_end >= '2017-01-29 #011 08:00:00' AND event_start <= '2017-03-05 07:59:59') OR #011 (event_recurenddate >= '2017-01-29 08:00:00' AND event_start <= #011 '2017-03-05 07:59:59' AND event_recurtype <> 0)) [pid 16839 on line 316 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
I have several of these notices.
Also one strange notice:
HORDE: Guest user is not authorized for Horde (Host: c-##-##-##-##.xx.comcast.net). [pid 16683 on line 324 of "/usr/share/pear/Horde/Registry.php"]
but that is my IP address and I am logged in, so why it is saying "Guest"?
Also, my address book is empty.
-
Did you have any custom templates that you used with the older version of horde? What is the output of the php /usr/bin/horde-db-migrate command?
-
@calisun
Close your browsers, clear your cache and cookies (run CCleaner). See above...
-
@calisun
Close your browsers, clear your cache and cookies (run CCleaner). See above...
bunkobugsy, your suggestion only works on fixing log in issues (which I had and which I fixed by clearing cache)
This is a database issue.
John, what is the command to Uninstall Horde 5.2 ? I did this update on my production server and I need it back up ASAP.
I will continue testing on my test server, but I need production server working.
-
To my knowledge, the database tables can't be reverted. For the restore process, this is pure speculation. You'll have to uninstall all of the horde rpm's, then install whatever version you were using before, then restore the horde db to a time before you did your upgrade, then signal-event post-upgrade ; signal-event reboot, and hope it comes back. I've never personally done this.
Might be better to try and fix what happened when you upgraded. I would run the migrate command again and post the output of it, might want to tail -f /var/log/messages as well in case there is anything different being shown. If you have a lot of data, then it's possible the 2 times this is run by default, isn't enough for your installation. I haven't experienced this, but I believe a few people did on the horde list and that was the suggestion given.
John
-
Hi John,
Here are some outputs you asked for in previous posts:
php -v
[root@x ~]# php -v
PHP 5.3.3 (cli) (built: Aug 11 2016 20:33:53)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
pear list
[root@x ~]# pear list
Installed packages, channel pear.php.net:
=========================================
Package Version State
Archive_Tar 1.4.2 stable
Auth_SASL 1.0.6 stable
Auth_SASL2 0.1.0 beta
Cache 1.5.6 stable
Cache_Lite 1.7.16 stable
Console_Color 1.0.3 stable
Console_Getargs 1.3.5 stable
Console_Getopt 1.3.1 stable
Console_GetoptPlus 1.0.0RC1 beta
Console_Table 1.3.0 stable
Crypt_Blowfish 1.0.1 stable
DB 1.8.2 stable
Date 1.5.0a4 alpha
Date_Holidays 0.21.8 alpha
Date_Holidays_Australia 0.2.2 alpha
Date_Holidays_Denmark 0.1.3 alpha
Date_Holidays_Germany 0.1.2 alpha
Date_Holidays_Italy 0.1.1 alpha
Date_Holidays_Netherlands 0.1.4 alpha
Date_Holidays_Norway 0.1.2 alpha
Date_Holidays_Portugal 0.1.1 alpha
Date_Holidays_Russia 0.1.0 alpha
Date_Holidays_Slovenia 0.1.2 alpha
Date_Holidays_Sweden 0.1.3 alpha
Date_Holidays_Turkey 0.1.1 alpha
Date_Holidays_USA 0.1.1 alpha
File 1.4.1 stable
File_CSV 1.0.0 stable
File_Find 1.3.3 stable
File_Fstab 2.0.3 stable
File_Util 1.0.0 stable
HTTP 1.4.1 stable
HTTP_Request 1.4.4 stable
HTTP_Request2 2.3.0 stable
HTTP_WebDAV_Server 1.0.0RC8 beta
Log 1.13.1 stable
MDB2 2.5.0b5 beta
MDB2_Driver_mysql 1.5.0b4 beta
Mail 1.3.0 stable
Mail_Mime 1.10.0 stable
Math_BigInteger 1.0.3 stable
Net_DIME 1.0.2 stable
Net_DNS2 1.4.2 stable
Net_FTP 1.4.0 stable
Net_IMAP 1.1.3 stable
Net_SMTP 1.6.3 stable
Net_Sieve 1.3.4 stable
Net_Socket 1.0.14 stable
Net_URL 1.0.15 stable
Net_URL2 2.2.1 stable
PEAR 1.9.5 stable
SOAP 0.13.0 beta
Services_Weather 1.4.7 stable
Structures_Graph 1.0.4 stable
Text_Figlet 1.0.2 stable
XML_Parser 1.3.7 stable
XML_Parser2 0.1.0 beta
XML_RPC 1.5.5 stable
XML_RPC2 1.1.3 stable
XML_SVG 1.1.0 stable
XML_Serializer 0.20.2 beta
XML_Util 1.2.3 stable
pear list -c horde
Nothing shows up
php /usr/bin/horde-db-migrate
[root@x ~]# php /usr/bin/horde-db-migrate
[ INFO ] Migrating DB up.
[ INFO ] Current imp schema version: 3
[ INFO ] Ending imp schema version: 3
[ INFO ] Current ingo schema version: 7
[ INFO ] Ending ingo schema version: 7
[ INFO ] Current kronolith schema version: 17
Migrating to KronolithUpgradeCategoriesToTags (18)
== 18 KronolithUpgradeCategoriesToTags: migrating =============================
== 18 KronolithUpgradeCategoriesToTags: Migrating event categories to tags. ===
-- select('SELECT event_uid, event_category, event_creator_id, calendar_id FROM kronolith_events')
-> 0.0006s
QUERY FAILED: Duplicate entry 'User1@my-domain.com' for key 'rampage_users_user_name'
INSERT INTO `rampage_users` (user_name) VALUES ('User1@my-domain.com')
[ INFO ] Current turba schema version: 9
Migrating to TurbaUpgradeCategoriesToTags (10)
== 10 TurbaUpgradeCategoriesToTags: migrating =================================
== 10 TurbaUpgradeCategoriesToTags: Migrating contact categories to tags. =====
-- select('SELECT object_uid, object_category, owner_id FROM turba_objects')
-> 0.0000s
QUERY FAILED: Duplicate entry 'user2@my-domain.com' for key 'rampage_users_user_name'
INSERT INTO `rampage_users` (user_name) VALUES ('user2@my-domain.com')
[ INFO ] Current nag schema version: 14
[ INFO ] Ending nag schema version: 14
[ INFO ] Current mnemo schema version: 8
[ INFO ] Ending mnemo schema version: 8
[ INFO ] Current content schema version: 2
[ INFO ] Ending content schema version: 2
[ INFO ] Current Horde_ActiveSync schema version: 23
[ INFO ] Ending Horde_ActiveSync schema version: 23
[ INFO ] Current Horde_Alarm schema version: 2
[ INFO ] Ending Horde_Alarm schema version: 2
[ INFO ] Current Horde_Auth schema version: 1
[ INFO ] Ending Horde_Auth schema version: 1
[ INFO ] Current Horde_Cache schema version: 2
[ INFO ] Ending Horde_Cache schema version: 2
[ INFO ] Current Horde_Core schema version: 1
[ INFO ] Ending Horde_Core schema version: 1
[ INFO ] Current Horde_Dav schema version: 2
[ INFO ] Ending Horde_Dav schema version: 2
[ INFO ] Current Horde_Group schema version: 3
[ INFO ] Ending Horde_Group schema version: 3
[ INFO ] Current Horde_History schema version: 6
[ INFO ] Ending Horde_History schema version: 6
[ INFO ] Current Horde_Imap_Client schema version: 2
[ INFO ] Ending Horde_Imap_Client schema version: 2
[ INFO ] Current Horde_Lock schema version: 3
[ INFO ] Ending Horde_Lock schema version: 3
[ INFO ] Current Horde_Perms schema version: 3
[ INFO ] Ending Horde_Perms schema version: 3
[ INFO ] Current Horde_Prefs schema version: 3
[ INFO ] Ending Horde_Prefs schema version: 3
[ INFO ] Current Horde_Queue schema version: 1
[ INFO ] Ending Horde_Queue schema version: 1
[ INFO ] Current Horde_Service_Weather schema version: 2
[ INFO ] Ending Horde_Service_Weather schema version: 2
[ INFO ] Current Horde_SessionHandler schema version: 2
[ INFO ] Ending Horde_SessionHandler schema version: 2
[ INFO ] Current Horde_SyncMl schema version: 1
[ INFO ] Ending Horde_SyncMl schema version: 1
[ INFO ] Current Horde_Token schema version: 1
[ INFO ] Ending Horde_Token schema version: 1
[ INFO ] Current Horde_Vfs schema version: 4
[ INFO ] Ending Horde_Vfs schema version: 4
-
This is what I get when I run the command:
[root@www ~]# pear list -c horde
Installed packages, channel pear.horde.org:
===========================================
Package Version State
Horde_ActiveSync 2.37.4 stable
Horde_Alarm 2.2.8 stable
Horde_Argv 2.0.12 stable
Horde_Auth 2.2.1 stable
Horde_Autoloader 2.1.2 stable
Horde_Browser 2.0.13 stable
Horde_Cache 2.5.4 stable
Horde_Cli 2.0.7 stable
Horde_Compress 2.1.6 stable
Horde_Compress_Fast 1.1.1 stable
Horde_Constraint 2.0.3 stable
Horde_Controller 2.0.4 stable
Horde_Core 2.27.6 stable
Horde_Crypt 2.7.5 stable
Horde_Crypt_Blowfish 1.1.2 stable
Horde_CssMinify 1.0.3 stable
Horde_Css_Parser 1.0.11 stable
Horde_Data 2.1.4 stable
Horde_Date 2.3.2 stable
Horde_Date_Parser 2.0.6 stable
Horde_Dav 1.1.4 stable
Horde_Db 2.3.4 stable
Horde_Editor 2.0.4 stable
Horde_ElasticSearch 1.0.3 stable
Horde_Exception 2.0.8 stable
Horde_Feed 2.0.4 stable
Horde_Form 2.0.15 stable
Horde_Group 2.1.1 stable
Horde_HashTable 1.2.6 stable
Horde_History 2.3.6 stable
Horde_Http 2.1.7 stable
Horde_Icalendar 2.1.4 stable
Horde_Idna 1.0.4 stable
Horde_Image 2.3.6 stable
Horde_Imap_Client 2.29.12 stable
Horde_Injector 2.0.5 stable
Horde_Itip 2.1.2 stable
Horde_JavascriptMinify 1.1.3 stable
Horde_JavascriptMinify_Jsmin 1.0.2 stable
Horde_Ldap 2.3.2 stable
Horde_ListHeaders 1.2.4 stable
Horde_Lock 2.1.4 stable
Horde_Log 2.2.0 stable
Horde_LoginTasks 2.0.7 stable
Horde_Mail 2.6.3 stable
Horde_Mail_Autoconfig 1.0.3 stable
Horde_Mapi 1.0.8 stable
Horde_Mime 2.10.2 stable
Horde_Mime_Viewer 2.2.1 stable
Horde_Nls 2.2.1 stable
Horde_Notification 2.0.4 stable
Horde_Oauth 2.0.3 stable
Horde_Pack 1.0.7 stable
Horde_Pdf 2.0.7 stable
Horde_Perms 2.1.7 stable
Horde_Prefs 2.8.0 stable
Horde_Queue 1.1.4 stable
Horde_Rdo 2.1.0 stable
Horde_Role 1.0.1 stable
Horde_Routes 2.0.5 stable
Horde_Rpc 2.1.7 stable
Horde_Scribe 2.0.2 stable
Horde_Secret 2.0.6 stable
Horde_Serialize 2.0.5 stable
Horde_Service_Facebook 2.0.9 stable
Horde_Service_Twitter 2.1.5 stable
Horde_Service_Weather 2.5.3 stable
Horde_SessionHandler 2.2.8 stable
Horde_Share 2.1.1 stable
Horde_Smtp 1.9.4 stable
Horde_Socket_Client 2.1.1 stable
Horde_SpellChecker 2.1.3 stable
Horde_Stream 1.6.3 stable
Horde_Stream_Filter 2.0.4 stable
Horde_Stream_Wrapper 2.1.3 stable
Horde_Stringprep 1.0.3 stable
Horde_Support 2.1.5 stable
Horde_SyncMl 2.0.7 stable
Horde_Template 2.0.3 stable
Horde_Text_Diff 2.1.2 stable
Horde_Text_Filter 2.3.5 stable
Horde_Text_Filter_Csstidy 2.0.1 stable
Horde_Text_Flowed 2.0.3 stable
Horde_Thrift 2.0.2 stable
Horde_Timezone 1.0.11 stable
Horde_Token 2.0.9 stable
Horde_Translation 2.2.1 stable
Horde_Tree 2.0.4 stable
Horde_Url 2.2.5 stable
Horde_Util 2.5.8 stable
Horde_Vfs 2.3.4 stable
Horde_View 2.0.6 stable
Horde_Xml_Element 2.0.4 stable
Horde_Xml_Wbxml 2.0.3 stable
content 2.0.5 stable
gollem 3.0.10 stable
horde 5.2.13 stable
imp 6.2.17 stable
ingo 3.2.13 stable
kronolith 4.2.19 stable
mnemo 4.2.12 stable
nag 4.2.13 stable
timeobjects 2.1.3 stable
trean 1.1.7 stable
turba 4.2.18 stable
Any errors in /var/log/messages when you run it? That probably isn't your issue, but you should be getting some output. You are having issues converting the old categories to the new tag system. You are going to have to post this to the horde list and do what their devs tell you to do. I have no idea how a system gets into that situation, nor how to really help you out. I'm on the horde list, so it will be interesting to see what they say.
Sorry that I can't help any further,
John
-
When trying to install Horde5.2 I get the following error at the end
--> Processing Dependency: php-common(x86-64) = 5.3.3-48.el6_8 for package: php-process-5.3.3-48.el6_8.x86_64
---> Package smeserver-kronolith.noarch 0:2.3-18.el6 will be installed
---> Package smeserver-mnemo.noarch 0:2.3-10.el6 will be installed
---> Package smeserver-nag.noarch 0:2.3-11.el6 will be installed
---> Package timeobjects.noarch 0:2.1.2-1.el6 will be installed
---> Package turba-h3.noarch 0:2.3.5-1.el6.sme will be obsoleted
---> Package turba-h5.noarch 0:4.2.16-1.el6 will be obsoleting
---> Package urw-fonts.noarch 0:2.4-11.el6 will be installed
--> Finished Dependency Resolution
Error: Package: php-process-5.3.3-48.el6_8.x86_64 (/php-process-5.3.3-48.el6_8.x86_64)
Requires: php-common(x86-64) = 5.3.3-48.el6_8
Installed: php-common-5.3.3-49.el6.x86_64 (@base)
php-common(x86-64) = 5.3.3-49.el6
Error: Package: php-intl-5.3.3-48.el6_8.x86_64 (/php-intl-5.3.3-48.el6_8.x86_64)
Requires: php-common(x86-64) = 5.3.3-48.el6_8
Installed: php-common-5.3.3-49.el6.x86_64 (@base)
php-common(x86-64) = 5.3.3-49.el6
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
Installation of horde 5.x rpms for SME Server 9 is complete
If you aren't installing anything else, then you need to execute
signal-event post-upgrade ; signal-event reboot
Any ideas as to how I can straighten this out?
Thanks
-
Yes, wait for me to upload new files. The conflicts are due to CentOS 6.9 being released that has updated packages. Today horde released some updates as well. I should have them uploaded by the weekend.
-
Ok, thank you very much! I will wait.
-
I have finished uploading the new files to work with SME 9.2, CentOS 6.9. You will need to wait for the mirrors to sync.
-
Great ... thank you very much!
-
Hmm having an issue again now where after install I get errors on the restart where it tries to load the mysql tables (failed).
Loading mysql_upgrade into mysql (OK)
Loading horde_mysql_create_tables into mysql (failed)
Loading kronolith_db_upgrade into mysql (failed)
Loading Ingo_Deltatree_to_SQL into mysql (failed)
Loading Kronolith_Deltatree_to_SQL into mysql (failed)
there may be a couple others that I missed as it flashed past pretty quickly.
After the restart when I go to webmail login and login fine but only the email works, the calendar and contacts, notes , tasks all give errors.
When I click on Calendar I get:
A fatal error has occurred
"dynamic/sidebar.html.php" not found in template path ("/home/httpd/html/horde/templates/:./")
Details have been logged for the administrator.
When I click on Address Book I get:
A fatal error has occurred
QUERY FAILED: Unknown column 'share_parents' in 'field list' INSERT INTO turba_shares (share_name, share_parents, share_owner, attribute_name, attribute_params, perm_creator, perm_default, perm_guest, share_flags) VALUES ('i7OyN1ZTDcBoh_AbbCZnwPn', NULL, 'edb@10.25', 'Address book of edb', 'a:3:{s:6:\"source\";s:8:\"localsql\";s:7:\"default\";b:1;s:4:\"name\";s:9:\"edb@10.25\";}', 0, 0, 0, 0)
Details have been logged for the administrator.
When I click Tasks I get:
A fatal error has occurred
QUERY FAILED: Table 'horde.nag_shares' doesn't exist SHOW FIELDS FROM `nag_shares`
Details have been logged for the administrator.
When I click Notes I get:
A fatal error has occurred
QUERY FAILED: Table 'horde.mnemo_shares' doesn't exist SHOW FIELDS FROM `mnemo_shares`
Details have been logged for the administrator.
[root@ ~]# [code]pear list -c horde[/code]
Installed packages, channel pear.horde.org:
===========================================
Package Version State
Horde_ActiveSync 2.38.4 stable
Horde_Alarm 2.2.9 stable
Horde_Argv 2.1.0 stable
Horde_Auth 2.2.1 stable
Horde_Autoloader 2.1.2 stable
Horde_Browser 2.0.13 stable
Horde_Cache 2.5.5 stable
Horde_Cli 2.2.2 stable
Horde_Compress 2.2.0 stable
Horde_Compress_Fast 1.1.1 stable
Horde_Constraint 2.0.3 stable
Horde_Controller 2.0.4 stable
Horde_Core 2.28.3 stable
Horde_Crypt 2.7.8 stable
Horde_Crypt_Blowfish 1.1.2 stable
Horde_CssMinify 1.0.3 stable
Horde_Css_Parser 1.0.11 stable
Horde_Data 2.1.4 stable
Horde_Date 2.3.2 stable
Horde_Date_Parser 2.0.6 stable
Horde_Dav 1.1.4 stable
Horde_Db 2.4.0 stable
Horde_Editor 2.0.4 stable
Horde_ElasticSearch 1.0.3 stable
Horde_Exception 2.0.8 stable
Horde_Form 2.0.17 stable
Horde_Group 2.1.1 stable
Horde_HashTable 1.2.6 stable
Horde_History 2.3.6 stable
Horde_Http 2.1.7 stable
Horde_Icalendar 2.1.6 stable
Horde_Idna 1.1.0 stable
Horde_Image 2.4.1 stable
Horde_Imap_Client 2.29.12 stable
Horde_Injector 2.0.5 stable
Horde_Itip 2.1.2 stable
Horde_JavascriptMinify 1.1.3 stable
Horde_JavascriptMinify_Jsmin 1.0.2 stable
Horde_Ldap 2.4.0 stable
Horde_ListHeaders 1.2.4 stable
Horde_Lock 2.1.4 stable
Horde_Log 2.3.0 stable
Horde_LoginTasks 2.0.7 stable
Horde_Mail 2.6.3 stable
Horde_Mail_Autoconfig 1.0.3 stable
Horde_Mapi 1.0.8 stable
Horde_Mime 2.10.3 stable
Horde_Mime_Viewer 2.2.1 stable
Horde_Nls 2.2.1 stable
Horde_Notification 2.0.4 stable
Horde_Oauth 2.0.3 stable
Horde_Pack 1.0.7 stable
Horde_Pdf 2.0.7 stable
Horde_Perms 2.1.7 stable
Horde_Prefs 2.8.1 stable
Horde_Queue 1.1.4 stable
Horde_Rdo 2.1.0 stable
Horde_Role 1.0.1 stable
Horde_Routes 2.0.5 stable
Horde_Rpc 2.1.7 stable
Horde_Scribe 2.0.2 stable
Horde_Secret 2.0.6 stable
Horde_Serialize 2.0.5 stable
Horde_Service_Facebook 2.0.9 stable
Horde_Service_Twitter 2.1.5 stable
Horde_Service_Weather 2.5.4 stable
Horde_SessionHandler 2.2.9 stable
Horde_Share 2.1.2 stable
Horde_Smtp 1.9.4 stable
Horde_Socket_Client 2.1.1 stable
Horde_SpellChecker 2.1.3 stable
Horde_Stream 1.6.3 stable
Horde_Stream_Filter 2.0.4 stable
Horde_Stream_Wrapper 2.1.3 stable
Horde_Stringprep 1.0.3 stable
Horde_Support 2.2.0 stable
Horde_SyncMl 2.0.7 stable
Horde_Template 2.0.3 stable
Horde_Text_Diff 2.2.0 stable
Horde_Text_Filter 2.3.5 stable
Horde_Text_Filter_Csstidy 2.0.1 stable
Horde_Text_Flowed 2.0.3 stable
Horde_Thrift 2.0.2 stable
Horde_Timezone 1.1.0 stable
Horde_Token 2.0.9 stable
Horde_Translation 2.2.2 stable
Horde_Tree 2.0.4 stable
Horde_Url 2.2.5 stable
Horde_Util 2.5.8 stable
Horde_Vfs 2.4.0 stable
Horde_View 2.0.6 stable
Horde_Xml_Element 2.0.4 stable
Horde_Xml_Wbxml 2.0.3 stable
content 2.0.5 stable
horde 5.2.15 stable
imp 6.2.19 stable
ingo 3.2.15 stable
kronolith 4.2.21 stable
mnemo 4.2.13 stable
nag 4.2.14 stable
timeobjects 2.1.3 stable
turba 4.2.19 stable
[root@ ~]# pear listInstalled packages, channel pear.php.net:
=========================================
Package Version State
Archive_Tar 1.4.2 stable
Auth_SASL 1.0.6 stable
Auth_SASL2 0.1.0 beta
Cache 1.5.6 stable
Cache_Lite 1.7.16 stable
Console_Color 1.0.3 stable
Console_Getargs 1.3.5 stable
Console_Getopt 1.3.1 stable
Console_GetoptPlus 1.0.0RC1 beta
Console_Table 1.3.0 stable
Crypt_Blowfish 1.0.1 stable
DB 1.8.2 stable
Date 1.5.0a4 alpha
Date_Holidays 0.21.8 alpha
Date_Holidays_Australia 0.2.2 alpha
Date_Holidays_Denmark 0.1.3 alpha
Date_Holidays_Germany 0.1.2 alpha
Date_Holidays_Italy 0.1.1 alpha
Date_Holidays_Netherlands 0.1.4 alpha
Date_Holidays_Norway 0.1.2 alpha
Date_Holidays_Portugal 0.1.1 alpha
Date_Holidays_Russia 0.1.0 alpha
Date_Holidays_Slovenia 0.1.2 alpha
Date_Holidays_Sweden 0.1.3 alpha
Date_Holidays_Turkey 0.1.1 alpha
Date_Holidays_USA 0.1.1 alpha
File 1.4.1 stable
File_CSV 1.0.0 stable
File_Find 1.3.3 stable
File_Fstab 2.0.3 stable
File_Util 1.0.0 stable
HTTP 1.4.1 stable
HTTP_Request 1.4.4 stable
HTTP_Request2 2.3.0 stable
HTTP_WebDAV_Server 1.0.0RC8 beta
Log 1.13.1 stable
MDB2 2.5.0b5 beta
MDB2_Driver_mysql 1.5.0b4 beta
Mail 1.3.0 stable
Mail_Mime 1.10.0 stable
Math_BigInteger 1.0.3 stable
Net_DIME 1.0.2 stable
Net_DNS2 1.4.3 stable
Net_FTP 1.4.0 stable
Net_IMAP 1.1.3 stable
Net_SMTP 1.6.3 stable
Net_Sieve 1.3.4 stable
Net_Socket 1.0.14 stable
Net_URL 1.0.15 stable
Net_URL2 2.2.1 stable
PEAR 1.9.5 stable
SOAP 0.13.0 beta
Services_Weather 1.4.7 stable
Structures_Graph 1.0.4 stable
Text_Figlet 1.0.2 stable
XML_Parser 1.3.7 stable
XML_Parser2 0.1.0 beta
XML_RPC 1.5.5 stable
XML_RPC2 1.1.3 stable
XML_SVG 1.1.0 stable
XML_Serializer 0.20.2 beta
XML_Util 1.2.3 stable
[root@defcon1 ~]# php -vPHP 5.3.3 (cli) (built: Mar 22 2017 12:27:09)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
with Zend Guard Loader v3.3, Copyright (c) 1998-2010, by Zend Technologies
Any ideas as to why this may be happening and how to fix?
Oh BTW
[root@~]# php /usr/bin/horde-db-migrate (returns nothing at all).
Thanks
-edb
-
Here are the listed tables within my Horde database:
mysql> show tables;+---------------------------+
| Tables_in_horde |
+---------------------------+
| horde_alarms |
| horde_cache |
| horde_datatree |
| horde_datatree_attributes |
| 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_sentmail |
| ingo_forwards |
| ingo_lists |
| ingo_rules |
| ingo_shares |
| ingo_shares_groups |
| ingo_shares_users |
| ingo_spam |
| ingo_vacations |
| turba_objects |
| turba_shares |
| turba_shares_groups |
| turba_shares_users |
+---------------------------+
31 rows in set (0.00 sec)
I think some tables are missing.
-
Turns out I had to go to
/home/httpd/html/horde/config/conf.php
and add the ‘admin@10.25’ (in my case) to the admin array section.
Then login with that user and go to Administration-Configuration- Update Schema All until they all read “SQL DB schema is ready”.
Now when I login as a user all features work as they should. A bit bizzar ... but at least it works now.
-
This also created the missing tables for me so now I have the following tables listed:
mysql> show tables;
+-----------------------------------+
| Tables_in_horde |
+-----------------------------------+
| content_schema_info |
| horde_activesync_cache |
| horde_activesync_device |
| horde_activesync_device_users |
| horde_activesync_mailmap |
| horde_activesync_map |
| horde_activesync_schema_info |
| horde_activesync_state |
| horde_alarm_schema_info |
| horde_alarms |
| horde_auth_schema_info |
| horde_cache |
| horde_cache_schema_info |
| horde_core_schema_info |
| horde_datatree |
| horde_datatree_attributes |
| horde_dav_collections |
| horde_dav_objects |
| horde_dav_schema_info |
| horde_group_schema_info |
| horde_groups |
| horde_groups_members |
| horde_histories |
| horde_histories_modseq |
| horde_history_schema_info |
| horde_imap_client_data |
| horde_imap_client_message |
| horde_imap_client_metadata |
| horde_imap_client_schema_info |
| horde_lock_schema_info |
| horde_locks |
| horde_metar_airports |
| horde_muvfs |
| horde_perms |
| horde_perms_schema_info |
| horde_prefs |
| horde_prefs_schema_info |
| horde_queue_schema_info |
| horde_queue_tasks |
| horde_service_weather_schema_info |
| horde_sessionhandler |
| horde_sessionhandler_schema_info |
| horde_signups |
| horde_syncml_anchors |
| horde_syncml_map |
| horde_syncml_schema_info |
| horde_token_schema_info |
| horde_tokens |
| horde_users |
| horde_vfs |
| horde_vfs_schema_info |
| 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 |
+-----------------------------------+
108 rows in set (0.00 sec)
-
I'm getting errors while viewing emails. I think this describes the problem:
http://horde.690.n7.nabble.com/Error-on-viewing-some-emails-td138497.html
Maybe anybody could confirm the same problem?
Assumed that Michael J. Rubinski is right with the outdated Horde_Css package, how can this be fixed?
Regards,
stefan
-
Update your system by downloading and installing the latest files from my contribs directory, mirror.contribs.org/contribs/jbennett/horde.
John
-
John,
thank you for your reply.
I'll do and will report.
regards,
stefan
-
Update your system by downloading and installing the latest files from my contribs directory, mirror.contribs.org/contribs/jbennett/horde.
John
This leads to a default horde. Means all settings are gone, calendar is gone, adressbook is gone, tasks are gone, synced devices are gone...
As we are doing twice a day a backup, I have one around 4 hours ago. How can I revert or restore the data for horde from the database? Backup has been done with affa.
regards,
stefan
-
Are you running 32 or 64-bit SME 9.2? If you don't know, then post the output of uname -a. If using 32-bit, I actually stopped testing this version, as it seems most had moved on the 64-bit servers. If you are using 32-bit, then I'll reload using that, and test the upgrade process.
The install script doesn't drop any mysql tables, nor does it rename any directories. I use the same process to update my main and test servers. Copy zip file to server, unzip, cd /root/horde52, sh Install-horde52.sh. Did you make any customizations to the main files without creating custom templates, as those would be lost? I have performed 3 64-bit installs using the zip files from an older version, then upgraded the systems using the new zip file. All three times worked as expected.
Did you do a post-upgrade and reboot? Do you have any errors in your logs.
John
-
John,
thank you for your reply.
# uname -a
Linux saturn 2.6.32-696.3.2.el6.i686 #1 SMP Tue Jun 20 00:48:23 UTC 2017 i686 i686 i386 GNU/Linux
During installation sh Install-horde52.sh, this comes up:
This script will install the horde 5.x rpms for SME Server 9
for either i386 or 64-bit systems
32-Bit server installation
To abort the install press Control-C within 30 seconds.
Yes, I did a post-upgrade and reboot.
Yes there are two custom templates. Interesting thing: the "spam" button in webmail is also gone...?
Where/how can I check horde logs?
Regards,
stefan
-
John,
before following your advice I did several times a pear ua - could this be the reason?
-
Mhmm, I checked with phpmyadmin the kronolith events. Also the contacts in turba. It seems to me, it's everything there. I assume also all other data. Why not displayed?
-
John,
I restored *ONLY* the files from my affa-box for /home/httpd/html/horde/
I didn't touch the database.
You guess what - everything is back again.
If you need any more information I'll pleased to give you what ever I can. For the moment I'm happy, my users can work tomorrow. I'll see if the problem with some email is still there (what I assume). I will be back if so.
regards,
stefan
-
John,
did a pear ua:
# pear ua
Will upgrade channel://pear.php.net/auth_sasl
Will upgrade channel://pear.php.net/console_getopt
Will upgrade channel://pear.php.net/net_socket
Will upgrade channel://pear.php.net/structures_graph
Will upgrade channel://pear.php.net/db
Will upgrade channel://pear.php.net/xml_util
Will upgrade channel://pear.php.net/net_smtp
Will upgrade channel://pear.php.net/pear
Will upgrade channel://pear.php.net/auth_sasl2
Will upgrade channel://pear.php.net/cache_lite
pear/auth_sasl is already installed and is the same as the released version 1.0.6
pear/console_getopt is already installed and is the same as the released version 1.3.1
pear/net_socket is already installed and is the same as the released version 1.0.14
WARNING: "pear/DB" is deprecated in favor of "pear/MDB2"
pear/net_smtp is already installed and is the same as the released version 1.6.3
pear/pear is already installed and is the same as the released version 1.9.5
pear/auth_sasl2 is already installed and is the same as the released version 0.1.0
pear/cache_lite is already installed and is the same as the released version 1.7.16
Failed to download pear/PEAR, latest release is version 1.10.0, but it requires PHP version "5.4.0", use "channel://pear.php.net/PEAR-1.10.0" to install
pear/pear dependency package "pear/Structures_Graph" downloaded version 1.1.1 is not the recommended version 1.0.4, but may be compatible, use --force to install
pear/Structures_Graph cannot be installed, conflicts with installed packages
pear/DB requires package "pear/PEAR" (version >= 1.10.0), installed version is 1.9.5
pear/pear dependency package "pear/XML_Util" downloaded version 1.3.0 is not the recommended version 1.2.3, but may be compatible, use --force to install
pear/XML_Util cannot be installed, conflicts with installed packages
No valid packages found
upgrade-all failed
Maybe it helps.
regards,
stefan
-
Had you said you had done a pear ua, then I wouldn't have suggested you upgrade via the script, as you would have already downloaded the latest updates. The script would install any updated rpms that hadn't been updated. Pear and rpm don't talk to each other, so neither knows what the other has done. There seems to be a way to disable the pear function within an rpm, but I haven't looked into how that is done, that way, only updates would be applied via rpm. I also do a pear ua on my test servers to get the updates, then run the script as well to make sure all of the rpm's install and webmail functions afterwards.
I just finished installing SME 9.2 i386 version, and then ran the horde5 script, and it ran smoothly with no issues. Webmail came up fine. I went ahead and did a yum update after the fact, and some of the non horde core files were updated.
I can't pinpoint anything that would have caused you to have a completely new install from running the script, especially since it doesn't delete anything. But, I am glad you are back up, up to date, and ready for tomorrow.
If you are OK with doing a pear ua, then I would only do that to update your system in the future.
John
-
Don't know what to say... The amazing thing is that all data was/is in the databases - but have not been displayed.
I'm getting errors while viewing emails. I think this describes the problem:
http://horde.690.n7.nabble.com/Error-on-viewing-some-emails-td138497.html
Maybe anybody could confirm the same problem?
Assumed that Michael J. Rubinski is right with the outdated Horde_Css package, how can this be fixed?
Regards,
stefan
But this is still an issue. Loosing the connection and webmail is dead...
How can this be solved/checked? What css is used?
regards,
stefan
-
Check your logs.. I suspect some issues with PHP and memory
-
Yep, I agree.
I have 4GB of RAM. Here are my production settings for php and the php.ini db settings.
[root@jwww]# php -v
PHP 5.3.3 (cli) (built: Mar 22 2017 12:27:09)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
[root@www]# config show php
php=service
AllowUrlFopen=Off
MaxExecutionTime=1800
MemoryLimit=250M
PostMaxSize=35M
UploadMaxFilesize=35M
status=enabled
John
-
# php -v
PHP 5.3.3 (cli) (built: Mar 22 2017 12:17:33)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
# config show php
php=service
AllowUrlFopen=Off
MemoryLimit=64M
status=enabled
Sould I add/change settings to those of John? Server has 8GB RAM
regards,
stefan
-
I changed the settings:
# config show php
php=service
AllowUrlFopen=Off
MaxExecutionTime=1800
MemoryLimit=250M
PostMaxSize=15M
UploadMaxFilesize=15M
status=enabled
But this is making no difference.
What I see is, that tagging this email as spam kills the connection, while simply deleting or blacklisting is possible.
Return-Path: <ohnoxfm@hostepro.co.ua>
Delivered-To: maillog@saturn.foobar.com
Received: (qmail 12153 invoked by alias); 5 Jul 2017 01:20:31 -0000
Delivered-To: alias-localdelivery-maillog@foobar.com
Received: (qmail 12147 invoked by uid 453); 5 Jul 2017 01:20:31 -0000
X-Virus-Checked: by ClamAV 0.99.2 on saturn.foobar.com
X-Virus-Found: No
X-Spam-Status: No, score=2.7 required=4.0 autolearn=no autolearn_force=no
X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on saturn.foobar.com
X-Spam-Details: * -0.0 SPF_PASS SPF: sender matches SPF record
* -0.0 RP_MATCHES_RCVD Envelope sender domain matches handover relay domain
* 0.8 HTML_IMAGE_RATIO_02 BODY: HTML has a low ratio of text to image area
* 0.0 HTML_MESSAGE BODY: HTML included in message
* 1.8 HTML_IMAGE_ONLY_08 BODY: HTML: images with 400-800 bytes of words
* 0.1 HTML_SHORT_LINK_IMG_1 HTML is very short with a linked image
X-Spam-Level: **
X-Spam-User: qpsmtpd, 2 recipients
X-HELO: mail.hostepro.co.ua
Authentication-Results: saturn.foobar.com; auth=none; spf=pass smtp.mailfrom=hostepro.co.ua; dkim=none
Received: from vds3.hostepro.co.ua (HELO mail.hostepro.co.ua) (204.12.202.237)
by saturn.foobar.com (qpsmtpd/0.96) with ESMTP ; Wed, 05 Jul 2017 03:20:20 +0200
Received-SPF: pass (hostepro.co.ua: 204.12.202.237 is authorized to use 'ohnoxfm@hostepro.co.ua' in 'mfrom' identity (mechanism 'a/24' matched)) receiver=saturn.foobar.com; identity=mailfrom; envelope-from="ohnoxfm@hostepro.co.ua"; helo=mail.hostepro.co.ua; client-ip=204.12.202.237
Received: from hostepro.co.ua (mail.hostepro.co.ua [204.12.202.234])
by mail.hostepro.co.ua (Postfix) with ESMTPA id 9EC484E582;
Wed, 5 Jul 2017 02:19:48 +0300 (EEST)
Message-ID: <ohnoxfm52022474.32445882@mail.hostepro.co.ua>
From: "Mangosteen" <ohnoxfm@hostepro.co.ua>
To: <zentrale@iris-egris.de>
Subject: Beginnen Sie die FETTBEKAMPFUNG jetzt sofort!
Date: Wed, 05 Jul 2017 02:20:01 +0300
MIME-Version: 1.0
Content-Type: multipart/related;
type="multipart/alternative";
boundary="----=_NextPart_000_0018_01D2F534.A544F4F0"
Precedence: bulk
List-Id: b46626536v86275203
X-Complaints-To: abuse@hostepro.co.ua
List-Unsubscribe: <http://hostepro.co.ua/ru/unsubscribe/do?hash=2717271682876460>
This is a multi-part message in MIME format.
------=_NextPart_000_0018_01D2F534.A544F4F0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0019_01D2F534.A544F4F0"
------=_NextPart_000_0019_01D2F534.A544F4F0
Content-Type: text/plain;
charset="windows-1251"
Content-Transfer-Encoding: quoted-printable
=0D=0A=0D=0A=0D=0A=0D=0A =0D=0AArt der Anwendung =0D=0A>>&g=
t;=0D=0A=0D=0A
------=_NextPart_000_0019_01D2F534.A544F4F0
Content-Type: text/html;
charset="windows-1251"
Content-Transfer-Encoding: quoted-printable
<HTML><HEAD>=0D=0A<META content=3D"text/html; charset=3Dwindows-1=
251" http-equiv=3DContent-Type>=0D=0A</HEAD>=0D=0A<BODY bgColor=3D=
#ffffff>=0D=0A<DIV align=3Dcenter><A href=3D"http://m.new-line-we=
b.eu/mangosteen/index.html"><IMG border=3D0 hspace=3D0 alt=3D"" s=
rc=3D"cid:51a4001d2f535234fd41103a3bf977@ohnoxfm" width=3D720 hei=
ght=3D474></DIV> =0D=0A<DIV align=3Dcenter><FONT color=3D#0000ff=20=
size=3D4 face=3DArial><STRONG><A =0D=0Ahref=3D"http://m.new-line-=
web.eu/mangosteen/index.html">Art der Anwendung =0D=0A>>>=
;</A></STRONG></FONT></DIV></BODY></HTML>=0D=0A=0D=0A
------=_NextPart_000_0019_01D2F534.A544F4F0--
------=_NextPart_000_0018_01D2F534.A544F4F0
Content-Type: image/jpeg;
name="hx.jpeg"
Content-Transfer-Encoding: base64
Content-ID: <51a4001d2f535234fd41103a3bf977@ohnoxfm>
Horde says in the preview:
This part contains an attachment that can not be displayed within this part:
[multipart/alternative] Alternative 1 KB
This one can be tagged without any problem:
Return-Path: <facts@facts.axandra.com>
Delivered-To: maillog@saturn.foobar.com
Received: (qmail 10234 invoked by alias); 4 Jul 2017 22:18:41 -0000
Delivered-To: alias-localdelivery-maillog@foobar.com
Received: (qmail 10229 invoked by uid 453); 4 Jul 2017 22:18:41 -0000
X-Virus-Checked: by ClamAV 0.99.2 on saturn.foobar.com
X-Virus-Found: No
X-Spam-Status: No, score=0.0 required=4.0 autolearn=ham autolearn_force=no
X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on saturn.foobar.com
X-Spam-Details: * -0.0 RP_MATCHES_RCVD Envelope sender domain matches handover relay domain
* 0.0 HTML_MESSAGE BODY: HTML included in message
X-Spam-Level:
X-Spam-User: qpsmtpd, 2 recipients
X-HELO: news.axandra.com
Authentication-Results: saturn.foobar.com; auth=none; spf=none smtp.mailfrom=facts.axandra.com; dkim=none
Received: from news.axandra.com (HELO news.axandra.com) (178.77.77.121)
by saturn.foobar.com (qpsmtpd/0.96) with ESMTPS (DHE-RSA-AES256-SHA encrypted); Wed, 05 Jul 2017 00:18:30 +0200
Received-SPF: none (facts.axandra.com: No applicable sender policy available) receiver=saturn.foobar.com; identity=mailfrom; envelope-from="facts@facts.axandra.com"; helo=news.axandra.com; client-ip=178.77.77.121
Return-Path: <facts@facts.axandra.com>
Received: by news.axandra.com for <info.konto@foobar.com>; Tue, 4 Jul 2017 21:51:05 GMT
Message-ID: <20170704120258-1.1.du.tsyl.0.qp1fka715f@facts.axandra.com>
Date: Tue, 4 Jul 2017 21:51:05 GMT
From: "Axandra Search Engine Facts" <facts@facts.axandra.com>
To: <info.konto@foobar.com>
Subject: Search Engine Facts 4 July 2017
X-Mailer: OpenEMM V2013
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="-==AGNITASOUTER164240059B290001F2=="
This is a multi-part message in MIME format.
---==AGNITASOUTER164240059B290001F2==
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
You're receiving this newsletter because you subscribed to it on our web =
site or through our software programs or because you submitted your web s=
ite to AxxaSearch.com.
This is an HTML newsletter. You can view the full version on this page: h=
ttp://news.axandra.com/r.html?uid=3D1.du.tsyl.fn9.2o9rwcllrm
To stop getting this newsletter, go to: http://news.axandra.com/r.html?ui=
d=3D1.du.tsyl.fna.900kxcnpq8
---==AGNITASOUTER164240059B290001F2==
Content-Type: text/html; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/h=
tml4/strict.dtd">
<html>
<head>
<meta http-equiv=3D"Content-Type"
content=3D"text/html; charset=3DUTF-8">
<!-- Facebook sharing information tags -->
<meta name=3D"viewport" content=3D"width=3Ddevice-width">
<title>SEOprofiler newsletter</title>
<style type=3D"text/css">
Checking /var/log/messages /httpd/access /httpd/error brings up nothing. Somewhere else to check?
I don't know if it's a css problem. Regarding that the spam-tagging kills the connection. What brings me back to the Horde_Css package. How can the version be checked?
regards,
stefan
-
I have no idea what you are experiencing. You are free to forward me a copy of the troublesome email if you want, to bennettj at johnbennettservices dot com.
From the CLI, you can see what versions of the horde pear packages you are using by issuing the command pear list -c horde
Here is my output:
Installed packages, channel pear.horde.org:
===========================================
Package Version State
Horde_ActiveSync 2.38.6 stable
Horde_Alarm 2.2.10 stable
Horde_Argv 2.1.0 stable
Horde_Auth 2.2.2 stable
Horde_Autoloader 2.1.2 stable
Horde_Browser 2.0.13 stable
Horde_Cache 2.5.5 stable
Horde_Cli 2.2.4 stable
Horde_Compress 2.2.0 stable
Horde_Compress_Fast 1.1.1 stable
Horde_Constraint 2.0.3 stable
Horde_Controller 2.0.4 stable
Horde_Core 2.29.1 stable
Horde_Crypt 2.7.9 stable
Horde_Crypt_Blowfish 1.1.2 stable
Horde_CssMinify 1.0.3 stable
Horde_Css_Parser 1.0.11 stable
Horde_Data 2.1.4 stable
Horde_Date 2.4.0 stable
Horde_Date_Parser 2.0.6 stable
Horde_Dav 1.1.4 stable
Horde_Db 2.4.0 stable
Horde_Editor 2.0.4 stable
Horde_ElasticSearch 1.0.3 stable
Horde_Exception 2.0.8 stable
Horde_Feed 2.0.4 stable
Horde_Form 2.0.17 stable
Horde_Group 2.1.1 stable
Horde_HashTable 1.2.6 stable
Horde_History 2.3.6 stable
Horde_Http 2.1.7 stable
Horde_Icalendar 2.1.6 stable
Horde_Idna 1.1.1 stable
Horde_Image 2.5.1 stable
Horde_Imap_Client 2.29.13 stable
Horde_Injector 2.0.5 stable
Horde_Itip 2.1.2 stable
Horde_JavascriptMinify 1.1.4 stable
Horde_JavascriptMinify_Jsmin 1.0.2 stable
Horde_Ldap 2.4.0 stable
Horde_ListHeaders 1.2.5 stable
Horde_Lock 2.1.4 stable
Horde_Log 2.3.0 stable
Horde_LoginTasks 2.0.7 stable
Horde_Mail 2.6.4 stable
Horde_Mail_Autoconfig 1.0.3 stable
Horde_Mapi 1.0.8 stable
Horde_Mime 2.10.3 stable
Horde_Mime_Viewer 2.2.1 stable
Horde_Nls 2.2.1 stable
Horde_Notification 2.0.4 stable
Horde_Oauth 2.0.3 stable
Horde_Pack 1.0.7 stable
Horde_Pdf 2.0.7 stable
Horde_Perms 2.1.7 stable
Horde_Prefs 2.8.1 stable
Horde_Queue 1.1.4 stable
Horde_Rdo 2.1.0 stable
Horde_Role 1.0.1 stable
Horde_Routes 2.0.5 stable
Horde_Rpc 2.1.7 stable
Horde_Scribe 2.0.2 stable
Horde_Secret 2.0.6 stable
Horde_Serialize 2.0.5 stable
Horde_Service_Facebook 2.0.9 stable
Horde_Service_Twitter 2.1.5 stable
Horde_Service_Weather 2.5.4 stable
Horde_SessionHandler 2.2.9 stable
Horde_Share 2.1.2 stable
Horde_Smtp 1.9.5 stable
Horde_Socket_Client 2.1.1 stable
Horde_SpellChecker 2.1.3 stable
Horde_Stream 1.6.3 stable
Horde_Stream_Filter 2.0.4 stable
Horde_Stream_Wrapper 2.1.3 stable
Horde_Stringprep 1.0.3 stable
Horde_Support 2.2.0 stable
Horde_SyncMl 2.0.7 stable
Horde_Template 2.0.3 stable
Horde_Text_Diff 2.2.0 stable
Horde_Text_Filter 2.3.5 stable
Horde_Text_Filter_Csstidy 2.0.1 stable
Horde_Text_Flowed 2.0.3 stable
Horde_Thrift 2.0.2 stable
Horde_Timezone 1.1.0 stable
Horde_Token 2.0.9 stable
Horde_Translation 2.2.2 stable
Horde_Tree 2.0.4 stable
Horde_Url 2.2.5 stable
Horde_Util 2.5.8 stable
Horde_Vfs 2.4.0 stable
Horde_View 2.0.6 stable
Horde_Xml_Element 2.0.4 stable
Horde_Xml_Wbxml 2.0.3 stable
content 2.0.5 stable
gollem 3.0.10 stable
horde 5.2.15 stable
imp 6.2.19 stable
ingo 3.2.15 stable
kronolith 4.2.21 stable
mnemo 4.2.13 stable
nag 4.2.14 stable
timeobjects 2.1.3 stable
trean 1.1.7 stable
turba 4.2.19 stable
-
You can enable PHP debug too.. Check the wiki to find how
-
John,
here's my output of
# pear list -c horde
Installed packages, channel pear.horde.org:
===========================================
Package Version State
Horde_ActiveSync 2.38.6 stable
Horde_Alarm 2.2.10 stable
Horde_Argv 2.1.0 stable
Horde_Auth 2.2.2 stable
Horde_Autoloader 2.1.2 stable
Horde_Browser 2.0.13 stable
Horde_Cache 2.5.5 stable
Horde_Cli 2.2.4 stable
Horde_Compress 2.2.0 stable
Horde_Compress_Fast 1.1.1 stable
Horde_Constraint 2.0.3 stable
Horde_Controller 2.0.4 stable
Horde_Core 2.29.1 stable
Horde_Crypt 2.7.9 stable
Horde_Crypt_Blowfish 1.1.2 stable
Horde_CssMinify 1.0.3 stable
Horde_Css_Parser 1.0.11 stable
Horde_Data 2.1.4 stable
Horde_Date 2.4.0 stable
Horde_Date_Parser 2.0.6 stable
Horde_Dav 1.1.4 stable
Horde_Db 2.4.0 stable
Horde_Editor 2.0.4 stable
Horde_ElasticSearch 1.0.3 stable
Horde_Exception 2.0.8 stable
Horde_Form 2.0.17 stable
Horde_Group 2.1.1 stable
Horde_HashTable 1.2.6 stable
Horde_History 2.3.6 stable
Horde_Http 2.1.7 stable
Horde_Icalendar 2.1.6 stable
Horde_Idna 1.1.1 stable
Horde_Image 2.5.1 stable
Horde_Imap_Client 2.29.13 stable
Horde_Injector 2.0.5 stable
Horde_Itip 2.1.2 stable
Horde_JavascriptMinify 1.1.4 stable
Horde_JavascriptMinify_Jsmin 1.0.2 stable
Horde_Ldap 2.4.0 stable
Horde_ListHeaders 1.2.5 stable
Horde_Lock 2.1.4 stable
Horde_Log 2.3.0 stable
Horde_LoginTasks 2.0.7 stable
Horde_Mail 2.6.4 stable
Horde_Mail_Autoconfig 1.0.3 stable
Horde_Mapi 1.0.8 stable
Horde_Mime 2.10.3 stable
Horde_Mime_Viewer 2.2.1 stable
Horde_Nls 2.2.1 stable
Horde_Notification 2.0.4 stable
Horde_Oauth 2.0.3 stable
Horde_Pack 1.0.7 stable
Horde_Pdf 2.0.7 stable
Horde_Perms 2.1.7 stable
Horde_Prefs 2.8.1 stable
Horde_Queue 1.1.4 stable
Horde_Rdo 2.1.0 stable
Horde_Role 1.0.1 stable
Horde_Routes 2.0.5 stable
Horde_Rpc 2.1.7 stable
Horde_Scribe 2.0.2 stable
Horde_Secret 2.0.6 stable
Horde_Serialize 2.0.5 stable
Horde_Service_Facebook 2.0.9 stable
Horde_Service_Twitter 2.1.5 stable
Horde_Service_Weather 2.5.4 stable
Horde_SessionHandler 2.2.9 stable
Horde_Share 2.1.2 stable
Horde_Smtp 1.9.5 stable
Horde_Socket_Client 2.1.1 stable
Horde_SpellChecker 2.1.3 stable
Horde_Stream 1.6.3 stable
Horde_Stream_Filter 2.0.4 stable
Horde_Stream_Wrapper 2.1.3 stable
Horde_Stringprep 1.0.3 stable
Horde_Support 2.2.0 stable
Horde_SyncMl 2.0.7 stable
Horde_Template 2.0.3 stable
Horde_Text_Diff 2.2.0 stable
Horde_Text_Filter 2.3.5 stable
Horde_Text_Filter_Csstidy 2.0.1 stable
Horde_Text_Flowed 2.0.3 stable
Horde_Thrift 2.0.2 stable
Horde_Timezone 1.1.0 stable
Horde_Token 2.0.9 stable
Horde_Translation 2.2.2 stable
Horde_Tree 2.0.4 stable
Horde_Url 2.2.5 stable
Horde_Util 2.5.8 stable
Horde_Vfs 2.4.0 stable
Horde_View 2.0.6 stable
Horde_Xml_Element 2.0.4 stable
Horde_Xml_Wbxml 2.0.3 stable
content 2.0.5 stable
horde 5.2.15 stable
imp 6.2.19 stable
ingo 3.2.15 stable
kronolith 4.2.21 stable
mnemo 4.2.13 stable
nag 4.2.14 stable
timeobjects 2.1.3 stable
turba 4.2.19 stable
Versions seems to be the same.
In my installation is missing:
- Horde_Feed 2.0.4 stable
- gollem 3.0.10 stable
- trean 01.01.07 stable
I used your horde52.zip. Did I miss something?
One more question: do you have in webmail a spam-button for marking email manually as spam?
regards,
stefan
-
No, I just have the file manager and bookmark programs also installed. Horde-Feed provides, Support for working with feed formats such as RSS and Atom. Not having that, doesn't seem to be your issue, but you can install that if you want. It'll be there the next time I push out some updates. I must have deleted the rpm, but still have the src rpm.
-
John,
in webmail, do you have a spam-button to tag single emails manually?
-
Yes, I made it available in one of the patches I did. The template is in /etc/e-smith/templates/home/httpd/html/horde/imp/config/backends.local.php/120IMAPServers
partial...
if (($spamassassin{'UseBayes'} || '0') eq '1' and (($spamd{'SpamLearning'} || 'disabled') eq 'enabled'))
{
$OUT .= " 'spam' => array(\n";
$OUT .= " 'innocent' => array(\n";
$OUT .= " 'display' => true,\n";
$OUT .= " 'program' => '/usr/bin/spamc -C revoke -u %l',\n";
$OUT .= " ),\n";
$OUT .= " 'spam' => array(\n";
$OUT .= " 'display' => false,\n";
$OUT .= " 'program' => '/usr/bin/spamc -C report -u %l',\n";
$OUT .= " )\n";
$OUT .= " ),\n";
}
$OUT .= ");\n";
}
You need to set UseBayes to 1 for the spamassassin prop and SpamLearning to enabled for the spamd prop for the spam and innocent buttons to show up. Probably an easier way, but those props were already present, and I just used them.
-
Yes, template is there and those button has been there before I did the update.
# config show spamassassin
spamassassin=service
BayesAutoLearnThresholdNonspam=0.10
BayesAutoLearnThresholdSpam=6.00
DNSAvailable=yes
MessageRetentionTime=90
OkLanguages=all
OkLocales=all
RejectLevel=9
ReportSafe=0
Sensitivity=custom
SkipRBLChecks=0
SortSpam=enabled
Subject=[SPAM]
SubjectTag=enabled
TagLevel=4
UseBayes=1
status=enabled
# config show spamd
spamd=service
status=enabled
# less /etc/e-smith/templates/home/httpd/html/horde/imp/config/backends.local.php/120IMAPServers
if (($spamassassin{'UseBayes'} || '0') eq '1' and (($spamd{'SpamLearning'} || 'disabled') eq 'enabled'))
{
$OUT .= " 'spam' => array(\n";
$OUT .= " 'innocent' => array(\n";
$OUT .= " 'display' => true,\n";
$OUT .= " 'program' => '/usr/bin/spamc -C revoke -u %l',\n";
$OUT .= " ),\n";
$OUT .= " 'spam' => array(\n";
$OUT .= " 'display' => false,\n";
$OUT .= " 'program' => '/usr/bin/spamc -C report -u %l',\n";
$OUT .= " )\n";
$OUT .= " ),\n";
}
$OUT .= ");\n";
# expand-template /home/httpd/html/horde/imp/config/backends.local.php
leads to:
<?php
/*
#------------------------------------------------------------
# !!DO NOT MODIFY THIS FILE!!
#
# Manual changes will be lost when this file is regenerated.
#
# Please read the developer's guide, which is available
# at http://www.contribs.org/development/
#
# Copyright (C) 1999-2006 Mitel Networks Corporation
#------------------------------------------------------------
*/
//100Overrides
$servers['imap']['disabled'] = true;
//120IMAPServers
$servers['ivbonline.de'] = array(
'disabled' => false,
'name' => 'IMAP Server',
'hostspec' => 'localhost',
'hordeauth' => true,
'protocol' => 'imap',
'port' => '143',
'secure' => 'notls',
'maildomain' => 'domain.de',
'smtphost' => 'localhost',
'smtpport' => '25',
'cache' => false,
);
$servers['eyeseetv.de'] = array(
'disabled' => false,
'name' => 'IMAP Server',
'hostspec' => 'localhost',
'hordeauth' => true,
'protocol' => 'imap',
'port' => '143',
'secure' => 'notls',
'maildomain' => 'foobar.de',
'smtphost' => 'localhost',
'smtpport' => '25',
'cache' => false,
);
$servers['fax'] = array(
'disabled' => false,
'name' => 'IMAP Server',
'hostspec' => 'localhost',
'hordeauth' => true,
'protocol' => 'imap',
'port' => '143',
'secure' => 'notls',
'maildomain' => 'fax',
'smtphost' => 'localhost',
'smtpport' => '25',
'cache' => false,
);
$servers['objektschilder.de'] = array(
'disabled' => false,
'name' => 'IMAP Server',
'hostspec' => 'localhost',
'hordeauth' => true,
'protocol' => 'imap',
'port' => '143',
'secure' => 'notls',
'maildomain' => 'xyz.de',
'smtphost' => 'localhost',
'smtpport' => '25',
'cache' => false,
);
?>
I.e. in the directory horde/imp/config
# ls -l
insgesamt 228
-rw-r----- 1 root apache 1786 5. Jul 10:16 backends.local.php
-rw-r--r-- 1 root root 21220 20. Mai 10:28 backends.php
-rw-r----- 1 root apache 1257 3. Dez 2016 conf.php
-rw-r--r-- 1 root root 8217 20. Mai 10:28 conf.xml
-rw-r----- 1 root apache 674 14. Jan 2015 header.txt
-rw-r--r-- 1 root root 27740 20. Mai 10:28 hooks.php.dist
-rw-r----- 1 root apache 3016 2. Dez 2016 hooks.php.rpmsave
-rw-r--r-- 1 root root 1755 20. Mai 10:28 menu.php.dist
-rw-r----- 1 root apache 609 27. Nov 2016 mime_drivers.local.php
-rw-r--r-- 1 root root 9107 20. Mai 10:28 mime_drivers.php
-rw-r----- 1 root apache 8312 2. Dez 2016 mime_drivers.php.rpmsave
-rw-r----- 1 root apache 1008 27. Nov 2016 prefs.local.php
-rw-r--r-- 1 root root 51652 20. Mai 10:28 prefs.php
-rw-r----- 1 root apache 54392 2. Dez 2016 prefs.php.rpmsave
-rw-r----- 1 root apache 2436 2. Dez 2016 servers.php.rpmsave
-rw-r----- 1 root apache 0 2. Dez 2016 trailer.txt.rpmsave
Is it correct to assume that the owner of /home/httpd/html/horde should be apache:apache?
-
if (($spamassassin{'UseBayes'} || '0') eq '1' and (($spamd{'SpamLearning'} || 'disabled') eq 'enabled'))
You need to set UseBayes to 1 for the spamassassin prop and SpamLearning to enabled for the spamd prop for the spam and innocent buttons to show up. Probably an easier way, but those props were already present, and I just used them.
John,
as I posted my settings of spamassassin and spamd - does those match to work with the spam-buttons in horde? I can't find the spamd prop SpamLearning? Where is this supposed to be?
regards,
stefan
-
Meanwhile I found this:
https://bugs.contribs.org/show_bug.cgi?id=10138
Not yet in the email wiki...
# rpm -q smeserver-spamassassin
smeserver-spamassassin-2.4.0-8.el6.sme.noarch
I assume I have to set db configuration setprop spamd SpamLearning enabled
What brings up the spam button in horde.
-
No, you still need to do this:
db setprop spamd SpamLearning enabled
signal-event email-update
That will satisfy the and statement, and then the spam buttons should appear after a logout and login.
In /var/service/spamd/run, there is this:
#!/usr/bin/perl -w
use strict;
use esmith::ConfigDB;
open(STDERR, ">&STDOUT") or warn "Failed to redirect stderr to stdout: $!";
my $c = esmith::ConfigDB->open_ro || die "Couldn't open the configuration database";
my $spamd = $c->get('spamd');
my $spamass = $c->get('spamassassin');
if ( ($spamass->prop('status') || 'disabled') ne 'enabled'){
exec('/usr/bin/sv', 'd', '.');
}
else{
my $bayes = $spamass->prop('UseBayes') || '0';
my $tell = $spamd->prop('SpamLearning') || 'disabled';
my @args = qw(-u spamd --syslog=stderr --ipv4-only);
if ($bayes =~ m/^1|yes|on|enabled$/ && $tell =~ m/^1|yes|on|enabled$/){
push @args, '--allow-tell';
}
exec('/usr/bin/spamd', @args);
}
That enables the tell function for spamd. Before this enhancement was made, you had to have a custom-template, which I hadn't advertised, because I was going to put in a request to enable the tell function, but someone had the same idea as I. I've no idea what you did to make them appear before, as you said you had them. Maybe a custom-template as well, that needs to be re-looked at?
Are both DB settings needed to enable the spam buttons in horde, maybe not, but why would I want to do learning without using bayes? I can't answer that, so that is why both db settings are needed in order to display the spam buttons.
John
-
No, you still need to do this:
db setprop spamd SpamLearning enabled
signal-event email-update
John
This leads to:
# db setprop spamd SpamLearning enabled
usage:
/sbin/e-smith/db dbfile keys
/sbin/e-smith/db dbfile print [key]
/sbin/e-smith/db dbfile show [key]
/sbin/e-smith/db dbfile get key
/sbin/e-smith/db dbfile set key type [prop1 val1] [prop2 val2] ...
/sbin/e-smith/db dbfile setdefault key type [prop1 val1] [prop2 val2] ...
/sbin/e-smith/db dbfile delete key
/sbin/e-smith/db dbfile printtype [key]
/sbin/e-smith/db dbfile gettype key
/sbin/e-smith/db dbfile settype key type
/sbin/e-smith/db dbfile printprop key [prop1] [prop2] [prop3] ...
/sbin/e-smith/db dbfile getprop key prop
/sbin/e-smith/db dbfile setprop key prop1 val1 [prop2 val2] [prop3 val3] ...
/sbin/e-smith/db dbfile delprop key prop1 [prop2] [prop3] ...
In other words - it does not work in this way.
I did:
db configuration setprop spamd SpamLearning enabled
That brought up the buttons.
# config show spamd
spamd=service
SpamLearning=enabled
status=enabled
# config show spamassassin
spamassassin=service
BayesAutoLearnThresholdNonspam=0.10
BayesAutoLearnThresholdSpam=6.00
DNSAvailable=yes
MessageRetentionTime=90
OkLanguages=all
OkLocales=all
RejectLevel=9
ReportSafe=0
Sensitivity=custom
SkipRBLChecks=0
SortSpam=enabled
Subject=[SPAM]
SubjectTag=enabled
TagLevel=4
UseBayes=1
status=enabled
Don't know, if this is correct now...?
regards,
stefan
-
Just a small reminder, John,
do not forget to propagate those good improvement to the sme10 branch, let me know if you need help doing so!
-
Stefan, typo, but you knew what to do. AFAICT, things are good. You can - tail -f /var/log/spamd/current - and see that when you mark a mail as spam, it gets reported. That is what I do. Or, if you have Daniel's newer RPM's, then this will be done when you drag a mail to the junkmail folder. Not sure how many people are using those. If that makes it into SME10, then the spam buttons may could go away, or kept for another method. That is a discussion for another time.
JPP, Yep, I will. I have them already built for it, and I tested them on A2, but want to re-test on A3, when I have some extended time. Then create the bug reports, and get things built/tested/verified/committed.
John
-
JPP, Yep, I will. I have them already built for it, and I tested them on A2, but want to re-test on A3, when I have some extended time. Then create the bug reports, and get things built/tested/verified/committed.
John,
thanks for your dedication on Horde for the community. Just let me know if I can be of any help.
JP
-
guys please can you help
using sme 9.2 with all the latest updates
PHP Software Collections Contrib is installed
mysql 5.7 is installed
phpmod version set to php5.5
i need to share and synchronize " calendars " and " contacts " with 200+ users with ms outlook and mobile phones - HORDE GROUPWARE WEBMAIL ??
after i run the " sh Install-horde52.sh " script i get the following error
Error: Multilib version problems found. This often means that the root
cause is something else and multilib version checking is just
pointing out that there is a problem. Eg.:
1. You have an upgrade for turba-h5 which is missing some
dependency that another package requires. Yum is trying to
solve this by installing an older version of turba-h5 of the
different architecture. If you exclude the bad architecture
yum will tell you what the root cause is (which package
requires what). You can try redoing the upgrade with
--exclude turba-h5.otherarch ... this should give you an error
message showing the root cause of the problem.
2. You have multiple architectures of turba-h5 installed, but
yum can only see an upgrade for one of those arcitectures.
If you don't want/need both architectures anymore then you
can remove the one with the missing update and everything
will work.
3. You have duplicate versions of turba-h5 installed already.
You can use "yum check" to get yum show these errors.
...you can also use --setopt=protected_multilib=false to remove
this checking, however this is almost never the correct thing to
do as something else is very likely to go wrong (often causing
much more problems).
Protected multilib versions: turba-h5-4.2.25-1.el6.noarch != turba-h5-4.2.24-1.el6.noarch
Installation of horde 5.x rpms for SME Server 9 is complete
after doing " signal-event post-upgrade ; signal-event reboot "
when i go to " https://myspeip/horde " or " https://mysmeip/webmail/ " it seems as if Horde 5.2 is not working or not installed.
when i do: # pear list -c horde
i get
Channel "horde" does not exist
any ideas what i am doing wrong? :D
-
The errror tells you that there are two turba rpms. To fix - rm turba-h5-4.2.24-1.el6.noarch.rpm from your unzipped files, or wait for me to re-upload the zip files later tonight in my day.
Thank you,
John
-
mrjhb3
thank you for your support
i will await for you to re-upload the new files
much appreciated
-
I'm, not sure what versions of PHP that Horde 5.2 runs with but please be conscious of the state of play regarding PHP versions.
https://wiki.contribs.org/PHP_Software_Collections
Currently:
Server version PHP 5.3.3 is supported for security updates by Redhat until the End of Life for RH/CentOS 6 However, less and less web applications will run on it, hence SCL.
Other installed versions - the current lowest supported version today is PHP 7.1 and that is only supported until 30th Nov 2019 - in 5 months time.
So the minimum supported version that should be used now is at least 7.1 and preferably 7.2
This is for your own safety and security.
It also means any other 5.x versions and 7.0 are now unsupported and should not be used.
Rgds
John
(Nope - I hate the rapid pace of change but it is what it is)
-
New files have been uploaded.
Yes, the horde5 modules have support for php7. I've been running the scl on my test servers for a while. php72, works just fine, with no errors that I have run across. php73 throws some errors with ingo, but still seems to work. I haven't had a chance to find out if the errors can simply be ignored for now.
Thank you,
John
-
Cool. Thanks John.
-
I have installed this on my test server (default settings) following your install instructions in 1st post.
Install went smooth and everything seems to work fine.
I will report if I find any issues
Thanks John for working on this.
-
First, thanks to John for doing all this work. This is great!
We ran the Horde 5 update script on a test VM running SME 9.2. Here is the system info I notice you have requested in the past:
[root@sme ~]# pear -V
PEAR Version: 1.9.5
PHP Version: 5.3.3
Zend Engine Version: 2.3.0
Running on: Linux sme 2.6.32-754.17.1.el6.x86_64 #1 SMP Tue Jul 2 12:42:48 UTC 2019 x86_64
[root@sme ~]#
[root@sme ~]# php -v
PHP 5.3.3 (cli) (built: Mar 22 2017 12:27:09)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
[root@sme ~]# mysql -V
mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1
Command pear list gave some results, but pear list -c horde returned zero results.
For the test VM, the install terminated normally and webmail opened up as desired. We did see an error when accessing the "add content" function. All in all, we see the installation as a success. 8-)
We then ran the update script on a server that has been in production for a long time. In this case, we saw lots of warnings at the end of the end of the yum install. Here is one that is typical; there were a great many. All referenced "/usr/share/pear/".
Transaction Check Error:
file /usr/share/pear/Horde/Url/Exception.php from install of Horde_Url-2.2.6-1.el6.noarch conflicts with file from package php-horde-Horde-Url-2.2.3-1.el6.noarch
Here is the system info for the production server:
# pear -V
PEAR Version: 1.9.4
PHP Version: 5.3.3
Zend Engine Version: 2.3.0
Running on: Linux japatul 2.6.32-754.17.1.el6.x86_64 #1 SMP Tue Jul 2 12:42:48 UTC 2019 x86_64
#
# php -v
PHP 5.3.3 (cli) (built: Mar 22 2017 12:27:09)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
#
# mysql -V
mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1
Command pear list returned a number of packages, but pear list -c horde returned a large number of results from pear.horde.org, pear.php.net and pecl.php.net. Nearly all of these are named in the conflict messages.
This system also has software collections installed and we are using PHP 7.1 and PHP 7.3 on selected iBays.
I don't recall what pear may have been used for on this server other than software collections. From reading the previous posts on this thread it looks like an update of pear packages may be necessary. That is just a guess.
I would be very grateful for your thoughts and suggestions.
-
I don't use the horde portal much at all any more, but I get an error as well, when clicking on add content. On my test server, I fixed it by editing line 167, and changing &new to new. I changed it on my production server as well. Now add content works.
If you don't get anything when running pear list -c horde, then something went wrong. The packages that I update, are not compatible with any of the horde5 rpms from remi, which it seems you have previously installed on the production server. I believe his changes the pear directory location, and adds a lot more information to the pear.conf file that I don't know about. Somehow, you are going to need to resolve those conflicts. How, I'm not 100% sure what the best way is. None of my horde5 rpm's start with php-horde, so that is how I know you have installed someone else's packages.
I have recently started using the software collections contrib, and am running my production server with php73 enabled. I did have to make some small changes to reduce some of the log errors, but I didn't get rid of them all, as well as copy the current php scl pear.conf files, and create a symlink to the one I use for webmail. I'm letting all of this soak on my home system, but all seems good so far. I'll have to retest the portal fix on a base install, and then with the various php SCL versions enabled. All of these changes will be included the next time I upload the files, so more people can test and confirm things are good.
I don't know how much, or if any, that I've helped here.
John
-
Of course it helps, John. I completely understand the time constraints and the challenge of keeping up with the changes in the environment and related packages.
I am glad to hear you are working with software collections. I think that is a great concept and hope it will be fruitful.
Please accept my encouragement. I look forward to your next update.
-
php-horde-Horde-Rpc-2.1.8-1.el6.noarch.rpm is from epel
php-horde-Horde-Url-2.2.6-1.el6.noarch.rpm is also from epel
there are high chances you tried to install an extension for horde 3 a while ago.
remi would provide php-horde-Horde-Url-2.2.6-1.el6.remi.noarch.rpm.
rpm -qa|grep "php-horde" would help to see all the rpm installed.
and for John, adding somethinf like this to the corresponding spec files
could help those in the case of Mark to update without issue.
Provides php-horde-Horde-Url
-
Following Jean-Philippe's suggestion, I looked for related files.
# rpm -qa|grep "php-horde";I see a lot of files but none include reference to remi; e.g. php-horde-Horde-Url-2.2.3-1.el6.noarch is typical.
I then ran a check for remi packages. The results list only the php packages for software collections.
# rpm -qa | grep "remi.noarch";
php71-php-pear-1.10.9-2.el6.remi.noarch
php73-php-pear-1.10.9-2.el6.remi.noarch
php70-php-pear-1.10.9-2.el6.remi.noarch
php72-php-pear-1.10.9-2.el6.remi.noarch
php55-php-pear-1.10.9-2.el6.remi.noarch
php54-php-pear-1.10.9-2.el6.remi.noarch
php56-php-pear-1.10.9-2.el6.remi.noarch
Ran another variant...
# rpm -qa | grep "remi";which returned many more files but none include "horde" in the file name. All appear to be part of the software collections for php.
Still curious, I ran a more general search on the disk.
# updatedb;
# locate php-horde;The results listed files in /usr/share/pear/ and /var/lib/yum/yumdb/. No surprises there.
I am perplexed. In the OP, I noted that the horde files on disk appear to be newer than those in John's package. The conflicting files are in the local pear repo.
I wonder whether I can simply remove the horde files from the local pear repo and run John's script again?
-
I wonder whether I can simply remove the horde files from the local pear repo and run John's script again?
as i said they are from epel.
as long as you have the list of rpm you should be safe to remove them and reinstall them at worst.
just check if they are not required by other rpms and create an awfull cascade of removal. If a yum remove of this list only remove those rpm you are pretty safe, otherwise you might have to remember those other rpm and decide if it is worth the risk.
finally the new rpm as they conflict in providing files shoudl be a 1:1 replacement. Except the newer version might break older script depending on them if you keep some old horde 3 packages, which should not be the case with John script.
-
What's the chance this will be updated?
--> Finished Dependency Resolution
Error: Package: php-bcmath-5.3.3-49.el6.x86_64 (/php-bcmath-5.3.3-49.el6.x86_64)
Requires: php-common(x86-64) = 5.3.3-49.el6
Installed: php-common-5.3.3-50.el6_10.x86_64 (@updates)
php-common(x86-64) = 5.3.3-50.el6_10
Error: Package: php-process-5.3.3-49.el6.x86_64 (/php-process-5.3.3-49.el6.x86_64)
Requires: php-common(x86-64) = 5.3.3-49.el6
Installed: php-common-5.3.3-50.el6_10.x86_64 (@updates)
php-common(x86-64) = 5.3.3-50.el6_10
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
Installation of horde 5.x rpms for SME Server 9 is complete
-
What's the chance this will be updated?
None whatsoever.
Please see notes about SME/CentOS 6 EOL.
You would have also hit this issue and workaround.
https://forums.contribs.org/index.php/topic,54339.0.html
-
None whatsoever.
Please see notes about SME/CentOS 6 EOL.
You would have also hit this issue and workaround.
https://forums.contribs.org/index.php/topic,54339.0.html
Thanks for the info, we have done what you linked to previously. Was just hoping to get horde 5.2 working, but from previous messages about mismatched file versions wasn't sure if we should use:
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
or try rolling back php. If the above commands won't cause some sort of catastrophic failure/issue we would love to do this. Again Thanks.
-
What's the chance this will be updated?
--> Finished Dependency Resolution
Error: Package: php-bcmath-5.3.3-49.el6.x86_64 (/php-bcmath-5.3.3-49.el6.x86_64)
Requires: php-common(x86-64) = 5.3.3-49.el6
Installed: php-common-5.3.3-50.el6_10.x86_64 (@updates)
php-common(x86-64) = 5.3.3-50.el6_10
Error: Package: php-process-5.3.3-49.el6.x86_64 (/php-process-5.3.3-49.el6.x86_64)
Requires: php-common(x86-64) = 5.3.3-49.el6
Installed: php-common-5.3.3-50.el6_10.x86_64 (@updates)
php-common(x86-64) = 5.3.3-50.el6_10
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
Installation of horde 5.x rpms for SME Server 9 is complete
Despite what has been said, yes I will get this updated. I'm still running these and have php-process-5.3.3-50.el6_10.x86_64 installed on my home server. I seem to have messed something up the last time I prepped things. Look for updates to have been made sometime tomorrow.
Thank you,
John
-
Despite what has been said, yes I will get this updated. I'm still running these and have php-process-5.3.3-50.el6_10.x86_64 installed on my home server. I seem to have messed something up the last time I prepped things. Look for updates to have been made sometime tomorrow.
Thank you,
John
Thank you.
-
Despite what has been said, yes I will get this updated. I'm still running these and have php-process-5.3.3-50.el6_10.x86_64 installed on my home server. I seem to have messed something up the last time I prepped things. Look for updates to have been made sometime tomorrow.
Thank you,
John
Install went great. I did have to modify VirturalHosts so my redirection worked, but that's minor (I can say that now, but it is amazing how long it took me to figure out to change 'DocumentRoot /home/httpd/html/horde/imp' to 'DocumentRoot /home/httpd/html/horde'.
Again thanks, many people are happy with the change :D :-D