Koozali.org: home of the SME Server
Legacy Forums => Experienced User Forum => Topic started by: mrjhb3 on January 21, 2005, 04:55:11 AM
-
Hello all,
I have created 2 howtos for installing the Horde 3.0 framework. One for a new installation, and one for an upgrade.
None of this is official, but I have been using it for about 3 weeks now. From my testing there are 2 things that don't work. Kronolith reminders and Kronolith free/busy. If anyone has time to investigate if it's possible to get these to work on SME, that would be great.
Thanks goes to Dan Brown for the original howto on CentOS.
Good Luck,
JB
[edit]I keep getting hits on my webserver so I removed the references to the two links I previously posted as they are outdated. I keep upgrading the script and it is located at http://mirror.contribs.org/smeserver/contribs/jbennett
John
-
Looks good John, I like the upgrade instructions :)
I ran into the same problems you did with Dan Browns PHP 4.3.10 RPMS - some message like 'No version found - regenerate configuration' in horde stup and when you clicked on it, it either went nowhere using firefox, or to an error page using IE. I did get it working with the 4.3.9 RPMS from Laurent Dinclaux.
A note about the fileinfo bit - you need to add/edit a custom template to add 'extension=fileinfo.so' in php.ini next to the others and restart httpd.
Also from my experience following your upgrade instructions, you assume people have nag, mnemo and kronolith installed, where they may not - so you have to use the install .sql file, not the upgrade one.
-
You are correct about that. I'll adjust the instructions in the next few days.
I never got fileinfo to install for me as I didn't install the other RPM's. Please tell me what the 'extension=fileinfo.so' in php.ini will do for me.
Lastly, I know you already sent it to me, but send the the list of RPM's needed to get fileinfo installed and where I can find them. I had some mail issues and lost that email.
thx,
JB
-
If you install fileinfo, but don't add 'extension=fileinfo.so' to php.ini, then if you check horde's test.php, it will say that fileinfo is not installed. I guess addding that makes it available to php.
It was in the devinfo list that I posted the list of dev rpms needed. But it is also now in the update script at the link below.
-
I also found you can avoid
...You will need to copy the generated config file and save it to...
by doing this first:
chown www:www -R /home/httpd/html/horde/config
chown www:www -R /home/httpd/html/horde/imp/config
chown www:www -R /home/httpd/html/horde/turba/config
chown www:www -R /home/httpd/html/horde/kronolith/config
chown www:www -R /home/httpd/html/horde/mnemo/config
chown www:www -R /home/httpd/html/horde/nag/config
chown www:www -R /home/httpd/html/horde/ingo/config
...then horde can save the conf.php files itself.
There is a script called set_perms.sh in /horde/scripts that can reset the recommended ownership/permissions later.
-
I tested the upgrade procedure as well as the new installation procedure.
At some point some settings on the Authentication tab of the Horde configuration need to be done. I noticed that if you change these settings to the required values while IMP configuration has not been done yet, you are unable to continue after that moment (authentication errors in browser).
My workaround was to postpone the settings in the Authentication tab until the IMP configuration was done.
At first the whole Horde suite seemed to work very fine. It's quite an improvement compared to the 2.x suite.
However at some point display of email messages got messed up: if I tried to view a message, the complete email headers were displayed (with all newline characters removed) on the location where you would expect the message body. So the actual message was not displayed at all anymore.
This strange phenomenon suddenly occured at all accounts. Believing that I played too much with global (horde/imp) settings, I restored original settings, however without any positive results.
I wonder whether some bug was bugging me or if I made some stupid mistake?? If so, I must have made it twice as I ran into this problem after the upgrade as well as after the new installation procedure.
Any ideas?
-
At some point some settings on the Authentication tab of the Horde configuration need to be done. I noticed that if you change these settings to the required values while IMP configuration has not been done yet, you are unable to continue after that moment (authentication errors in browser).
My workaround was to postpone the settings in the Authentication tab until the IMP configuration was done.
I did get an error once, but just restored conf.php and was able to access the configuration again. I don't think it was because of IMP though, it happened after I saved the logging settings in horde.
However at some point display of email messages got messed up: if I tried to view a message, the complete email headers were displayed (with all newline characters removed) on the location where you would expect the message body. So the actual message was not displayed at all anymore.
How does your test.php page look for horde and for imp? Any errors?
-
I also found you can avoid ...You will need to copy the generated config file and save it to...
by doing this first:
chown www:www -R /home/httpd/html/horde/config
chown www:www -R /home/httpd/html/horde/imp/config
chown www:www -R /home/httpd/html/horde/turba/config
chown www:www -R /home/httpd/html/horde/kronolith/config
chown www:www -R /home/httpd/html/horde/mnemo/config
chown www:www -R /home/httpd/html/horde/nag/config
chown www:www -R /home/httpd/html/horde/ingo/config
...then horde can save the conf.php files itself.
There is a script called set_perms.sh in /horde/scripts that can reset the recommended ownership/permissions later.
Yes, I saw all of that, but I just didn't investigate it. I have now incorporated those changes in my howto. Looks like you have moved on the 6.5B1 and are running into some issues. I haven't tried to install this on 6.5B1 yet. Thanks for your help and suggestions.
JB
-
How does your test.php page look for horde and for imp? Any errors?
To answer your question I reinstalled Horde 3.0 again (I did a back out to Horde 2.X). I examined the test.php page and didn't find any errors. Just a few warnings which didn't seem fatal at all.
As experienced before everything worked fine until suddenly (a few hours after the reinstall) display of messages got messed up again. Being sure I did not make any configuration changes, I was a bit confused at first... :-?
I had a look at the test.php page again which didn't report anything strange and also had a look at the phpinfo() page to see if there was anything strange going on. While looking at this page I was reminded that some time ago I installed a php accelerator (turck-mmcache). I thought it to be not unlikely that turck-mmcache could be interfering with horde so I removed it.
And guess what: problem solved! :-)
-
I read in the horde mailing list I think people were having problems with turk-mmcache - the developpers said it was a bug with turk, not horde. Turck is not being developed anymore, but there is a replacement that is - http://eaccelerator.net/HomeUk
Or Mastersleepy has a turck rpm that you can enable or disable turck for certain ibays, but not sure about enabling/disabling for horde.
-
contribs.org is running that specific contrib ;-)
-
contribs.org is running that specific contrib ;-)
I assume you mean MasterSleepy's rpm and not eaccelerator?
Can you disable it (using the server-manager panel) from "accelerating" horde?
-
Nope, it's eaccelerator.
-
mrjhb3,
you need to change the link to the rpm's that are downloaded in your how-to due to the release of beta2.
The link now need to be wget -nc http://www.ibiblio.org/pub/linux/distributions/smeserver/releases/6.5beta2/os/e-smith/RPMS/ instead of
wget -nc http://www.ibiblio.org/pub/linux/distributions/smeserver/releases/6.5beta1/os/e-smith/RPMS
Also there's a new version of nag - nag-h3-2.0.1.tar.gz
Great how-to by the way. Works perfectly on a test box so I'm going to give it a go on my main box.
Thanks
Howard
-
..and the dev rpms you list are for 6.5 - there are slight differences for 6.0.1.
Also, for some reason fileinfo doesn't seem to install on 6.5beta1 like it did on 6.0.1, but it is optional, not required.
-
Great how-to by the way. Works perfectly on a test box so I'm going to give it a go on my main box.
I'd watch out for now - there are old templates for horde2/imp3 that have not been updated. Once you have it working properly, back up all the /config directories. All the conf.php files need to me re-templated, plus a few others.
Does anyone know if there is an action/event command that expands all the horde/imp/etc templates rather than doing one-by-one?
-
To all monitoring this thread. Can I guy take a break now and then? :pint:
I'll get the howto updated soon with the beta2 stuff.
I haven't had any problems installing this on SME 6.5 Beta 1. I did it today 4 different times, and will probably install it a couple of times tomorrow on beta 2. Fileinfo installs fine for me on beta1, what issues are you seeing? The only major difference I can see between what I am using and the 6.5 upgrade script is MySQL. I am using version 4.0.21 as opposed to 4.0.23.
Also, I have pretty much stopped looking at this for 6.01-01 and looking forward to 6.5. So, I will change my wording to say 6.5 as well.
Anything else anyone want?
Thanks for the heads up,
John Bennett
-
I'm getting an error:
'phpize' failed
...when trying to install fileinfo. The little info I found on the error seems to indicate it's because of an incompatible version of libtool, autoconf or automake. But phpize comes with the php-devel rpm, so that could be it too. I am using the 4.3.9 rpms now, and I think I was using 4.3.10 when I had installed it before. I can't remember if I did have fileinfo installed on beta1, this is beta2 I'm trying it on now without success. I will try to make an rpm of this package when I get it installed. I think it can be done with 'pear makerpm Fileinfo'. (Maybe someone will beat me to it ;-) ). That way people won't need to mess around with installing the dev. rpms.
[EDIT] - Yup, confirmed that the 'phpize' failed message comes only with Laurent's 4.3.9 rpm's, when I intall Dan's 4.3.10 rpm's over top I can install Fileinfo - go back, it fails again. But then Dan's don't work (for me at least) with Horde 3. Maybe I will have to learn to make rpms to get the best of both. The 'pear makerpm Fileinfo' command fails - forget that.
-
In the old 6.01-01 upgrade script there used to be a path to someone else's php-4.30.10 rpm's. Those are the ones I am using and testing with. Do you still have access to those?
Here is some output if it helps:
[root@testing65 php-4.3.10]# rpm -qpi php-4.3.10-0.i386.rpm | more
Name : php Relocations: (not relocateable)
Version : 4.3.10 Vendor: (none)
Release : 0 Build Date: Thu 16 Dec 2004 07:22:41 AM CST
Install date: (not installed) Build Host: elemiah.mirko.lan
Group : Development/Languages Source RPM: php-4.3.10-0.src.rpm
Size : 8869561 License: The PHP License, version 2.02
URL : http://www.php.net/
Summary : The PHP HTML-embedded scripting language. (PHP: Hypertext Preprocessor)
Description :
PHP is an HTML-embedded scripting language. PHP attempts to make it
easy for developers to write dynamically generated webpages. PHP also
offers built-in database integration for several commercial and
non-commercial database management systems, so writing a
database-enabled webpage with PHP is fairly simple. The most common
use of PHP coding is probably as a replacement for CGI scripts. The
mod_php module enables the Apache Web server to understand and process
the embedded PHP language in Web pages.
If not, I have these and could send them to you.
JB
-
I think the ones you're using are from:
http://open.rhx.it/apt/redhat/7.3/i386/RPMS.rhx/
I worked around the problem for now. But I will check those ones out. I'm going to try building some php rpms myself with all the configure options recommended for horde 3.
-
Long post...Sorry
Here is a script I am using to install horde3.0 on SME 6.5b2. Thanks Greg for the devrpms and fileino help. It basically follows the howto I wrote, but I added some extra items so that the install would survive an email-update, post-install, console-save, etc. Limited testing has been done, but it seems to be working. Make sure you have already downloaded the latest versions of the horde components, and php- 4.3.10. There are a few versions of the php rpm's that people are using, so I didn't include them in the script. I haven't tested this with anything other than php-4.3.10. Also download this file - file-4.12-3db_rh73.i386.rpm from Dan Browns directory on contribs.org. Make sure to have php and file installed before proceeding. Any Horde components newer than what are in the script, then you will have to modify the specific lines accordingly. I have tested this with MySQL that comes with 6.5 and with MySQL 4.0.21.
install_horde30.sh
#!/bin/bash
# This sets the script to verbose mode so I can see what is running
# set -v
clear
echo
echo "Installing horde 3.0 compononets,"
echo "Horde (framework), imp (mail), turba (contacts),"
echo "Kronolith (Calender), NAG (Tasks), Mnemo (Notes), Ingo (Filters)"
echo
mv /home/httpd/html/horde/ /home/httpd/html/horde.old
mkdir -p /root/plus/devrpms
cd /root/plus/devrpms
wget -nc http://www.ibiblio.org/pub/linux/distributions/smeserver/releases/6.5beta1/os/e-smith/RPMS/autoconf-2.13-17.noarch.rpm
wget -nc http://www.ibiblio.org/pub/linux/distributions/smeserver/releases/6.5beta1/os/e-smith/RPMS/automake-1.4p5-4.noarch.rpm
wget -nc http://www.ibiblio.org/pub/linux/distributions/smeserver/releases/6.5beta1/os/e-smith/RPMS/cpp-2.96-113.i386.rpm
wget -nc http://www.ibiblio.org/pub/linux/distributions/smeserver/releases/6.5beta1/os/e-smith/RPMS/gcc-2.96-113.i386.rpm
wget -nc http://www.ibiblio.org/pub/linux/distributions/smeserver/releases/6.5beta1/os/e-smith/RPMS/glibc-devel-2.2.5-44.legacy.3.i386.rpm
wget -nc http://www.ibiblio.org/pub/linux/distributions/smeserver/releases/6.5beta1/os/e-smith/RPMS/glibc-kernheaders-2.4-7.16.i386.rpm
wget -nc http://www.ibiblio.org/pub/linux/distributions/smeserver/releases/6.5beta1/os/e-smith/RPMS/libtool-libs-1.4.2-13.legacy.i386.rpm
wget -nc http://www.ibiblio.org/pub/linux/distributions/smeserver/releases/6.5beta1/os/e-smith/RPMS/m4-1.4.1-7.i386.rpm
wget -nc http://download.fedoralegacy.org/redhat/7.3/updates/i386/libtool-1.4.2-13.legacy.i386.rpm
rpm -Uvh *.rpm
cd /root/horde30
rm -rf /root/plus/devrpms
pear install Log
pear install Date
pear install file
pear ua
pear -d preferred_state=beta install -a Services_Weather
pear -d preferred_state=beta install -a Fileinfo
rpm -e autoconf automake cpp gcc glibc-devel glibc-kernheaders libtool m4
touch /etc/e-smith/templates-custom/etc/php.ini/85FileInfo
echo ' ' >> /etc/e-smith/templates-custom/etc/php.ini/85FileInfo
echo '[Fileinfo]' >> /etc/e-smith/templates-custom/etc/php.ini/85FileInfo
echo 'extension=fileinfo.so' >> /etc/e-smith/templates-custom/etc/php.ini/85FileInfo
mysqladmin drop horde < /root/horde30/y
tar zxf horde-3.0.2.tar.gz
tar zxf imp-h3-4.0.1.tar.gz
tar zxf turba-h3-2.0.tar.gz
tar zxf kronolith-h3-2.0.1.tar.gz
tar zxf mnemo-h3-2.0.1.tar.gz
tar zxf nag-h3-2.0.1.tar.gz
tar zxf ingo-h3-1.0.1.tar.gz
mv horde-3.0.2 /home/httpd/html/horde
mv imp-h3-4.0.1 /home/httpd/html/horde/imp
mv turba-h3-2.0 /home/httpd/html/horde/turba
mv kronolith-h3-2.0.1 /home/httpd/html/horde/kronolith
mv mnemo-h3-2.0.1 /home/httpd/html/horde/mnemo
mv nag-h3-2.0.1 /home/httpd/html/horde/nag
mv ingo-h3-1.0.1 /home/httpd/html/horde/ingo
/sbin/e-smith/config show horde
cd /home/httpd/html/horde/scripts/sql
echo
echo "Copy Horde Database Password, to input on next screen, and"
echo "For use during the configuration of Horde."
echo
echo "Press any key to continue."
read x
pico -w create.mysql.sql
mysql < create.mysql.sql
cd ../../config
for f in *.dist; do cp $f basename $f .dist; done
rm hooks.php < /root/horde30/y
cd ../imp/config
for f in *.dist; do cp $f basename $f .dist; done
rm trailer.txt < /root/horde30/y
cd ../../turba/config
for f in *.dist; do cp $f basename $f .dist; done
clear
echo "Edit sources.php. Delete everyththing down to localsql section."
echo "For the localldap section:"
echo "For server use localhost"
echo "For root= use your domain, then com"
echo "Delete bind_dn and bind_password lines"
echo "Also delete personal_ldap, prefs, imsp, kolab-global, and kolab-local sections."
echo
echo "Press any key to continue."
read x
pico -w sources.php
cd ../scripts/sql
mysql horde < turba_objects.mysql.sql
cd ../../../kronolith/config
for f in *.dist; do cp $f basename $f .dist; done
cd ../scripts/sql
mysql horde < kronolith.mysql.sql
cd ../../../mnemo/config
for f in *.dist; do cp $f basename $f .dist; done
cd ../scripts/sql
mysql horde < mnemo.sql
cd ../../../nag/config
for f in *.dist; do cp $f basename $f .dist; done
cd ../scripts/sql
mysql horde < nag.sql
cd ../../../ingo/config
for f in *.dist; do cp $f basename $f .dist; done
mkdir -p /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf
cp /etc/e-smith/templates/etc/httpd/conf/httpd.conf/85HordeAccess /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/
cd /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/
clear
echo "Edit 85HordeAccess and remove lines 55-58."
echo
echo "Press any key to continue"
read x
pico -w 85HordeAccess
clear
cp /home/httpd/html/horde/test.php /home/httpd/html/horde/test1.php
/sbin/e-smith/expand-template /etc/php.ini
/sbin/e-smith/expand-template /etc/httpd/conf/httpd.conf
/etc/e-smith/events/actions/restart-httpd-full
chown -R www.www /home/httpd/html/horde
clear
echo "With a web browser, visit <address of your host>/horde/test1.php and make sure all is looking good."
echo "If the settings look ok, then with a web browser, goto <address of your host>/horde to finish"
echo "setting up Horde."
echo "For further instructions, press any key to continue."
read x
rm /home/httpd/html/horde/test1.php
clear
echo
echo "In the sidebar on the left, go under Administration, to Setup:"
echo
echo "Choose Mail (imp)."
echo "On the External Utilities tab, enter /usr/bin/ispell and /usr/bin/gpg in the appropriate fields."
echo "For the location of the CA certificates bundle, enter /etc/httpd/conf/ssl.crt/ca-bundle.crt"
echo "Under the Menu Settings heading, click on imp, ingo, kronolith, mnemo, nag, turba."
echo
echo "Under Mailbox and Fetchmail, check for message previews and display message priority"
echo "The other options can be set depending on your preferences."
echo "Click Generate Mail Configuration button when finished."
echo
echo "Go back to Setup and choose Address Book (turba)"
echo "Under the Menu Settings heading, click on imp, ingo, kronolith, mnemo, nag, turba, then click Generate Address Book Configuration."
echo
echo "Go back to Setup and choose Calendar (kronolith)"
echo "Under the Menu Settings heading, click on imp, ingo, kronolith, mnemo, nag, turba."
echo "Under Reminder Settings, enter your server name and any email address (reminders@yourserver.com)."
echo "Click Generate Calendar Configuration."
echo
echo "Go back to Setup and choose Notes (mnemo)"
echo "Under the Menu Settings heading, click on imp, ingo, kronolith, mnemo, nag, turba. Click Generate Notes Configuration."
echo
echo "Go back to Setup and choose Tasks (nag)"
echo "Under the Menu Settings heading, click on imp, ingo, kronolith, mnemo, nag, turba. Click Generate Tasks Configuration."
echo
echo "Go back to Setup and choose Filters (ingo)"
echo "Under the Menu Settings heading, click on imp, ingo, kronolith, mnemo, nag, turba. Click Generate Filters Configuration"
echo
echo "Go back to Setup and choose Horde configuration."
echo "On the Database tab, make sure to enter the correct database password."
echo
echo "On the Authentication tab you will want to specify one or more users on"
echo "your system that Horde will treat as administrators (Those who are able"
echo "to change the configuration. You need to enter these as user@domain.com)."
echo "Set the backend to \"Let a horde application handle authentication\", and"
echo "set the application to imp."
echo
echo "On the Logging tab, set the log driver to Syslog, and the syslog facility to LOG_SYSLOG."
echo
echo "On the Preference System tab, set the preferences driver to SQL database. The preferences"
echo "table should be set to horde_prefs."
echo
echo "On the DataTree System tab, set the datatree driver to SQL database."
echo "The table should be set to horde_datatree."
echo
echo "On the Menu Settings tab, set the problem reporting to Never."
echo "Click Generate Horde Configuration button."
echo
echo "If the settings look ok, then press any key to continue."
read x
/sbin/e-smith/expand-template /home/httpd/html/horde/imp/config/servers.php
echo
clear
echo "Modify imp mailbox.php to add logged in user information."
echo "go to the end and paste the following contents."
echo
more /root/horde30/mailbox.php
echo
echo "Press enter to continue"
read x
pico -w /home/httpd/html/horde/imp/mailbox.php
clear
echo "Modify turba index.php to add logged in user information."
echo "go to the end paste the following contents."
echo
more /root/horde30/mailbox.php
echo
echo "Press enter to continue"
read x
pico -w /home/httpd/html/horde/turba/index.php
clear
echo "Modify kronolith index.php to add logged in user information."
echo "go to the end paste the following contents."
echo
more /root/horde30/mailbox.php
echo
echo "Press enter to continue"
read x
pico -w /home/httpd/html/horde/kronolith/index.php
clear
echo "Modify mnemo index.php to add logged in user information."
echo "go to the end paste the following contents."
echo
more /root/horde30/mailbox.php
echo
echo "Press enter to continue"
read x
pico -w /home/httpd/html/horde/mnemo/index.php
clear
echo "Modify nag index.php to add logged in user information."
echo "go to the end paste the following contents."
echo
more /root/horde30/mailbox.php
echo
echo "Press enter to continue"
read x
pico -w /home/httpd/html/horde/nag/index.php
clear
echo "Modify ingo index.php to add logged in user information."
echo "go to the end paste the following contents."
echo
more /root/horde30/mailbox.php
echo
echo "Press enter to continue"
read x
pico -w /home/httpd/html/horde/ingo/index.php
clear
echo "Modify imp login.php so phrase welcome to webmail is displayed."
echo "go to line 131 and replace that line with the below text in login.inc"
echo
more /root/horde30/implogin.php.txt
echo
echo "Press enter to continue"
read x
pico -w /home/httpd/html/horde/imp/login.php
clear
cd /home/httpd/html/horde
echo "Setting horde permissions. Type in www as the group."
echo "Press any key to continue."
sh scripts/set_perms.sh
#mkdir -p /root/horde20-restore
mkdir -p /root/horde30-restore
mkdir -p /root/horde30-restore/horde
mkdir -p /root/horde30-restore/imp
mkdir -p /root/horde30-restore/turba
mkdir -p /root/horde30-restore/kronolith
mkdir -p /root/horde30-restore/mnemo
mkdir -p /root/horde30-restore/nag
mkdir -p /root/horde30-restore/ingo
cp /home/httpd/html/horde/config/*.php /root/horde30-restore/horde
cp /home/httpd/html/horde/imp/config/*.php /root/horde30-restore/imp
cp /home/httpd/html/horde/turba/config/*.php /root/horde30-restore/turba
cp /home/httpd/html/horde/kronolith/config/*.php /root/horde30-restore/kronolith
cp /home/httpd/html/horde/mnemo/config/*.php /root/horde30-restore/mnemo
cp /home/httpd/html/horde/nag/config/*.php /root/horde30-restore/nag
cp /home/httpd/html/horde/ingo/config/*.php /root/horde30-restore/ingo
cp /root/horde30-restore.sh /root/horde30-restore
#cp /root/horde20-restore.sh /root/horde20-restore
rm /etc/e-smith/events/post-install/S55conf-horde-startup < /root/horde30/y
rm /etc/e-smith/events/post-install/S60conf-horde < /root/horde30/y
rm /etc/e-smith/events/post-install/S70conf-turba-startup < /root/horde30/y
rm /etc/e-smith/events/post-upgrade/S55conf-horde-startup < /root/horde30/y
rm /etc/e-smith/events/post-upgrade/S60conf-horde < /root/horde30/y
rm /etc/e-smith/events/post-upgrade/S70conf-turba-startup < /root/horde30/y
rm /etc/e-smith/events/email-update/S60conf-imp < /root/horde30/y
rm /etc/e-smith/events/email-update/S70conf-turba < /root/horde30/y
rm /etc/e-smith/events/bootstrap-console-save/S60conf-imp < /root/horde30/y
rm /etc/e-smith/events/bootstrap-console-save/S70conf-turba < /root/horde30/y
cd /root
echo
echo "Horde 3.0 Components have been successfully installed"
echo
==== Next File ====
/root/horde30/y
y
==== Next File ====
mailbox.php
echo "<font color=\"blue\">";
echo "<b><center>You are currently logged in as ";
echo $imp['user']."@";
echo $imp['maildomain'];
echo "</center></b>";
echo "</font>";
==== Next File ====
implogin.php.txt
$title = sprintf(_("Welcome to Web%s"), $registry->get('name', ($imp_auth) ? 'imp' : null));
==== horde30-restore.sh
horde30-restore
#!/bin/bash
echo "Restoring horde 3.0 settings
chown -R www.www /home/httpd/html/horde
#chmod -R 777 /home/httpd/html/horde
cp /root/horde30-restore/horde/*.php /home/httpd/html/horde/config
cp /root/horde30-restore/imp/*.php /home/httpd/html/horde/imp/config
cp /root/horde30-restore/turba/*.php /home/httpd/html/horde/turba/config
cp /root/horde30-restore/kronolith/*.php /home/httpd/html/horde/kronolith/config
cp /root/horde30-restore/mnemo/*.php /home/httpd/html/horde/mnemo/config
cp /root/horde30-restore/nag/*.php /home/httpd/html/horde/nag/config
cp /root/horde30-restore/ingo/*.php /home/httpd/html/horde/ingo/config
cd /home/httpd/html/horde
echo "Setting horde permissions. Type in www as the group."
echo "Press any key to continue."
sh scripts/set_perms.sh
===========================
You don't have to use any of the optional files. Mailbox.php shows you who you are logged into the mail system as. You can get the same info, by clicking on the horde icon in the sidebar, but I like to see it at a glance. Use at your own risk. But, if you do use it, let me know your results. I really don't plan on supporting this version of the script much, so if someone likes it, feel free to do as you wish. The one I use at home just has items in different directories.
I also have a horde20-restore.sh that should put the symlinks back to the specific events directories in the event you need to roll back. I haven't tested this fully yet, but will post that once I do if anyone is interested. Templating of these horde components still needs to be done. Is anyone working on this?
If you got this far thanks for reading.
Good Luck,
JB
-
I was going to work on the templating part - but I wondered what action triggers all the current horde templates to be 'expanded'. I should probably ask in the devinfo mailing list. We would have new templates, so they would have to be included somehow when the other templates are 'expanded'. I'm not sure how that would work.
John, you are welcome to add your horde install script to the wiki page I started here if you want: http://no.longer.valid/phpwiki/index.php/SME6.5UpdateScripts
-
I might give that a shot. I haven't used a/the wiki before, so I don't want to muck anything up.
As far as the events that trigger mail updates, these are the only ones that I found.
post-install
post-upgrade
email-update
bootstrap-console-save
I ran a console-save, post-install, and made a change in server-manager for webmail and my horde install survived. I may be able to help with the templating, let me know your thoughts and directions. We could move this conversation to devinfo or between us if you like.
JB
-
I just posted devinfo with the links to my wiki page and your howto, and a question along these lines...Maybe we'll find a few more people eager to help.
About the wiki, if you enclose your text like this:
<verbatim>
Text
More Text
</verbatim>
...the wiki won't screw it up by adding its own auto-formatting.
-
Has anyone experienced any problems with this howto?
I ran into problems when I ran this step:
Set the backend to “Let a horde application handle authentication", and set the application to imp.
before I had a change to even set imp as the application, the page threw a server error. Now, when I log back in to horde, the setup function is not present!
Anyone run into this before?
Geoffrey
-
yup, horde makes a backup of conf.php called conf.php.backup??? (I forget) Just overwrite conf.php with the backup and you should be ok again.
Maybe configure imp and then try it again.
-
Thanks Greg, that did the trick.
I think it fell over because I was trying to specify a user@domain to be treated as an Admin. I had to go through the process a few times before I realised that I just had to specify Administrator.
thanks,
Geoffrey
-
Hi Greg!
I have compiled newer PHP v4.3.10 RPMS with some more options
http://lists.contribs.org/mailman/public/devinfo/msg07797.html
Do you happen to know what other options might be useful for Horde3/IMP4 ?
(i.e. --with-xmlrpc=shared --with-domxml=shared would create php-xmlrpc and php-domxml packages with domxml.so / xmlrpc.so shared modules)
Best rgds, Ergin
-
Ergin, I saw your other post announcing your rpms, but I didnt try them yet. Dan Browns 4.3.10 rpms didn't work for me with Horde on 6.5beta. Can you check if they are built '--with-gettext', '--with-dom' and '--with-xml' - those are required according to horde.org - They don't mention --with-domxml or --with-xmlrpc. You can check the INSTALL docs on horde - eg. http://www.horde.org/horde/docs/?f=INSTALL.html#prerequisites - the other applications (IMP, Turba, etc) may have other recommended php build options too, and there is another one listed in the performance section http://www.horde.org/horde/docs/?f=PERFORMANCE.html#apache-php-tuning
-
They are built with options you mention.
I have modified the options a little and created a few more rpms just incase anyone needs them. ;-)
php-mhash
php-domxml
php-xmlrpc
They can be found
http://mirror.contribs.org/smeserver/contribs/ergozd/scripts/phprpms/
http://ergin.dyndns.org/download/RPMS/contribs/php/
Best rgds, Ergin
-
Thanks Greg, that did the trick.
I think it fell over because I was trying to specify a user@domain to be treated as an Admin. I had to go through the process a few times before I realised that I just had to specify Administrator.
thanks,
Geoffrey
Not sure why you were having an issue. I just installed with 6.01-01 and 6.5 and if I don't use a user@domain.com for admins, the administration icon never appears.
Interesting,
JB
-
I just posted devinfo with the links to my wiki page and your howto, and a question along these lines...Maybe we'll find a few more people eager to help.
About the wiki, if you enclose your text like this:
<verbatim>
Text
More Text
</verbatim>
...the wiki won't screw it up by adding its own auto-formatting.
Greg,
I haven't abandoned you. I have gotten some file space on contribs.org and am getting things uploaded to it. I will still work on updating the wiki after I get the files uploaded. I don't want my cable modem to get over-run with traffic. Kids take the precendence for my time, so when time permits, I'll get things updated.
JB
-
Not sure why you were having an issue. I just installed with 6.01-01 and 6.5 and if I don't use a user@domain.com for admins, the administration icon never appears.
Me too - I used admin@domain.com as the administrator account for horde. That is one of the items in the conf.php file that will need to be templated. I'm sure there is code already written in another template that outputs this.
I havent had time to work any more on this either John, no worries.
-
Only for information
I have runing ok horde with mysql 4.1.8 and 4.1.9
A question. What happen if I use the script to upgrade horde into my sme 6.0.1-01 box?
Off topic:
Ergin, I can't access your eaccelerator directory
-
What will happen is if you do it correctly, you should have a running horde 3.0 system. Using the correct howto instructions. :lol:
But, if you make any changes to your webmail, or do a signal-event post-install, etc. you will break your webmail. :-o
I am working on an official script that should help with this until the templating is complete. I am trying to get the info sent to my contribs directory space and organized. The jist of it is in the long post I posted in this thread. It is working for me, but I can't guarentee it for anyone else. When I get the necessary time, I get it together and let everyone know where it is at so people can test it.
JB
-
I am working on an official script ...
JB
Yeah, I can't read. That should be unofficial script..
Sorry,
John Bennett
-
About the wiki, if you enclose your text like this:
<verbatim>
Text
More Text
</verbatim>
...the wiki won't screw it up by adding its own auto-formatting.
Thank you for this info. I have just posted the Horde 3.0 install/upgrade script that I have been using and testing. It has quite a bit more meat to it than the howto.
Things that need to be looked into:
1. Migrating filters from imp 2.x to ingo. I can't seem to get this script to work. I keep getting errors.
2. Kronolith reminders don't work. There is a php file that you can set to run in cron, but I keep getting errors when I run this.
John Bennett
P.S. Greg or someone, please show me how to put the link to the upgrade script as my footer. I tried various things, but nothing worked.
-
P.S. Greg or someone, please show me how to put the link to the upgrade script as my footer. I tried various things, but nothing worked.
Click Edit Account in the User Menu and add something like this to the signature section...
eg.
Greg Swallow
[url=no.longer.valid/phpwiki/index.php/SME6.5UpdateScripts]SME 6.5Beta2 Update Scripts[/url]
It won't automatically appear for your old posts (without a signature) but it will start appearing for new ones.
PS. Nice work by the way! Maybe post to devinfo with a link to the Wiki page to see if anyone else wants to help. The wiki is pretty good for shared development, you can easily see the changes others have made with the Page History function - even better if you leave good comments when you make a change.
I am so busy right now, but I'll try to test it out as soon as I can.
-
i just tried the second version 3 script as an upgrade over the previous version. no errors seen while running the script, but after rebooting, i'm getting this error at the console perpetually:
/usr/sbin/httpd: relocation error: /usr/lib/php4/mhash.so: undefined symbol: ap_php_snprintf
stopping httpd, httpd-admin and httpd-e-smith paused the errors. Looking at /var/log/messages shows this:
Dec 16 15:58:26 proton httpd: PHP Warning: domxml: Unable to register functions, unable to load in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_version in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - xmldoc in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_open_mem in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - xmldocfile in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_open_file in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - html_doc in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - html_doc_file in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_xmltree in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - xmltree in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_substitute_entities_default in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_doc_document_element in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_doc_add_root in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_doc_set_root in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_dump_mem in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_dump_mem_file in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_dump_node in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_html_dump_mem in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_node_attributes in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_elem_get_attribute in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_elem_set_attribute in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_node_children in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_node_has_attributes in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_node_new_child in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_node in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_node_unlink_node in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_node_set_content in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_node_get_content in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_node_add_namespace in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_node_set_namespace in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_new_xmldoc in Unknown on line 0
Dec 16 15:58:27 proton httpd: PHP Warning: Function registration failed - duplicate name - domxml_new_doc in Unknown on line 0
there is more, but this is a start... not really sure what to look at to fix... am I going to need to rebuild from scratch???
THis is a test box...
-JL
-
hello everybody
it's my first post and for a problem,
i tried to install horde 3 (on 6.5b2) and only appear a beautifull white page.
i looked at error message and found fileinfo error that i corrected in php.ini then restarted and still the same white page
what's going wrong
pleae help, i have no more webmail
thank's
-
Did you run any of the other upgrade scripts? Probably not. If that is the case, goto your console and type
Pear install Log
Pear install Date
Then check your webmail again.
I currently don't check to see if these are installed. If this works for you, then maybe I'll just include the commands to install them, until we come up with a final 6.5 unofficial upgrade script.
Also, look at the upgrade script page for the 50pathdirectories info. You need to make sure you have that as well. If you have to add this info, then do a /sbin/e-smith/expand-template /etc/php.ini, then a service httpd restart.
The fileinfo piece should have been handled by the script. I have never had that piece fail
GL,
JB
-
Has anyone else had a chance to do anything with this? I was able to get my filters migrated, but am having a heck of a time getting the reminders and freebusy to work. I could sure use the help. I will be modifying the script soon to take out more of the manual configurations. I have also created a hack so I can choose to change my horde settings via server-manager. It's not where I want it, but it will work. What happens is, there is a selection for horde admin setup, which basically runs a chown -R www.www /home/httpd/html/horde, then you can make your changes, then run horde admin save, which runs a modified set_perms.sh. That way, I don't have to worry about templating. Since the horde team created a good gui for configuration, I figured I might as well use it.
If any one has any time to help, I would be appreciated.
JB
-
I'll try to help - I would really like to see this in the ISO for some release sometime :-)
-
I'll try to help - I would really like to see this in the ISO for some release sometime :-)
Me too !
I broke my 6.5b2 testserver completely, running update step 4.
I have since tried the manual steps (according to the howto lines in the script) but to no avail.
Webmail is set to https-access in server manager, but no go.
I'll hold my horses with 6.5rc1, but I see it as a natural extension of SME to utilize the Horde/Imp framework in full.
It's a mystery to me why Php 4.3.10, MySQL 4.0.23 (or even 4.1.0) and Horde 3.0/Imp 4.0 haven't been implemented on this release candidate.
That said, I admire the extensive work of Shad and other developers, and can only attempt to understand how timeconsuming a process it is to maintain a stable distribution, even though basic.
-
The issues I have seen have been with the various versions of php-4.3.10 floating around in the various upgrade scripts. If you install 6.5 RC1, then you should be able to run step 2, the 50pathsdirecories, pear upgrade log, and date from step 3. If you prefer I can change the step4 script so that it can be run without any of the above pre-reqs. I'll just add the necessary info to the script. We also need to get a handle on just which pear modules are needed.
I'll reload my test box over the weekend and run each of the steps and see what shape my server is in after that to see what can and can't be run.
At some point, we need to weed out the redundancy in the various upgrade scripts.
At this time, I don't know how to make an RPM, so the script is what I can contribute.
Thanks,
JB
-
Patching an existing RPM is not so difficult - I've even managed to do this :-) It's also in the doucmentation/development pages.
Making the TGZs into RPMs is not something that I have tried.
I can understand that Shad & Charlie want to keep in line with the fedora-legacy versions of the main apps. It makes sense from a distro point of view. This is something that we must live with.
So in the fedora7.3 lifetime this would remain a community add-on. Either as a script or RPMs.
The main push should be to get this in a good shape whilst the move to CentOS4 is underway.
In order to get this into any ISO the scripts/hacks need to be slowly removed leading to modifications to the e-smith-xxx RPMs. This work would largely be common for both RH7.3 & CentOS4 bases (I hope)
I certainly will help with this.
-
a response for mrjhb3 from the 18 Feb 2005 23:24 ;
no problem with pear, no problem with php.ini and 50path...
fileinfo was written about 10 times in php.ini ( rewritten in several steps and at differents custom templates). i changes every custom templates in order to keep only one "extension=fileinfo.so"
but still the same white page.
I'm wondering if it isn't a typo error in a horde file as a ?> missing. I'll check this
thanks for your response and sorry for my late response
pldtm
-
a response for mrjhb3 from the 18 Feb 2005 23:24 ;
no problem with pear, no problem with php.ini and 50path...
fileinfo was written about 10 times in php.ini ( rewritten in several steps and at differents custom templates). i changes every custom templates in order to keep only one "extension=fileinfo.so"
but still the same white page.
I'm wondering if it isn't a typo error in a horde file as a ?> missing. I'll check this
thanks for your response and sorry for my late response
pldtm
Look in /var/log/messages and see/post what error you are getting when you try to go to http://yourserver/horde or http://yourserver/webmail.
I had problems this weekend downloading some of the pear modules and if I wasn't watching my install, it would error out and continue. I then get the blank white page. At a minimum, here are the pear modules and versions, you should see with a pear list
root@my65test root]# pear list
Installed packages:
===================
Package Version State
Archive_Tar 1.2 stable
Cache 1.5.4 stable
Console_Getopt 1.2 stable
DB 1.6.8 stable
Date 1.4.3 stable
File 1.1.0 stable
Fileinfo 0.2 beta
HTTP 1.3.4 stable
HTTP_Request 1.2.4 stable
Log 1.8.7 stable
Mail 1.1.4 stable
Mail_Mime 1.2.1 stable
Net_DIME 0.3 beta
Net_SMTP 1.2.6 stable
Net_Socket 1.0.6 stable
Net_URL 1.0.14 stable
PEAR 1.3.5 stable
SOAP 0.8.1 beta
Services_Weather 1.3.1 stable
XML_Parser 1.2.5 stable
XML_RPC 1.2.0 stable
XML_Serializer 0.15.0 beta
XML_Util 1.1.1 stable
If you don't see the above versions, then that could be the issue.
JB
-
A little questions
What happens with original rpms for horde and imp (2.x)?
What happens with template located at /etc/templates/home/httpd/html/horde?
What happens with post-upgrade/S65conf-kronolith, mnemo and nag?
And issue for Greg. Your eaccelerator with files run ok, but rpm version don't work with horde because in the inbox show me only the header of the email message, and not body. Ufff, very hard to discover this iisue. I have ins/uninstalled several times horde for this iisue :hammer:
I have installed TREAN for horde and run ok (bookmarks) but only run previus version of HEAD, because the latest don't run with the latest stable horde version.
I have installed MIMP (webmail for mobile phones) and run prefect!!!!!!
Download the latest HEAD version, untar, all .dist without .dist, copy the imp servers.php template to custom-templates/home/httpd/html/horde/mimp/config/servers.php and expand
Configure in administration panel, and then activate in registry.php into horde config folder. If you want to see, set to active,, else set to hidden (better).
Follow this how to to set horde authentication to imp AND mimp.
http://wiki.horde.org/display.php?page=MIMPHowTo
The last question. I can't compile fileinfo, but in other machine. I can copy the file fileinfo.so and paste into /usr/lib/php4 to load in my server?
I use php4.3.10-3.eo script for greg
-
All answers pertain to the unofficial upgrade script.
A little questions
What happens with original rpms for horde and imp (2.x)?
Nothing. They are still installed. If needed, you could roll back to Horde 2.x. See horde20-restore.sh in /root/horde20-restore
What happens with template located at /etc/templates/home/httpd/html/horde?
What happens with post-upgrade/S65conf-kronolith, mnemo and nag?
Currently nothing, they are left in tack. The kronolith, mnemo, and nag files may cause some issues for others if webmail settings are changed. I forgot about those files. I'll have to re-load my test server and modify the script to remove those actions, then place them back in the horde20-restore.sh file.
The last question. I can't compile fileinfo, but in other machine. I can copy the file fileinfo.so and paste into /usr/lib/php4 to load in my server?
I use php4.3.10-3.eo script for greg
I have been thinking about modifying the script to just copy this file in the correct place and trying to get rid of the devrpms needed. I may look into doing this as well.
-
hi
i did pear list and all is ok.
Could my white page be a permission problem?
because typo seems ok
in message there are no error
If there's no solution can i re install horde 2 from my cd?
pldtm
-
hi
i did pear list and all is ok.
Could my white page be a permission problem?
because typo seems ok
in message there are no error
If there's no solution can i re install horde 2 from my cd?
pldtm
I can't duplicate this issue. Here are my thoughts. Did you already have php-4.3.10 installed? If so, remove that and install the php rpm's from the script, then expand the php.ini template, and restart httpd and try again. I had some initial issues when using the earlier releases of Dan Brown's PHP rpm's. I haven't tested the latest versions.
If you need to revert back, look in /root/horde20-restore. There should be a file called horde20-restore.sh that you could run. I'd also reccommend getting the most current one from my contribs directory.
That's all I got. I have installed this many times on my two test boxes, which are different, and for 6.0.1 and 6.5 without the issue you have. If you are getting a blank page, some log should be showing you something. If not /var/log/messages, then var/log/httpd/acess something, I believe. I'm not in front of my server to give you the correct path.
JB
-
Yes, i'd say try again and skip my "step 3" that installs php, and use johns step 4 that includes that.
-
Hello all,
I just updated the Horde 3.0 section of the upgrade script (Step 4). I have removed all of the manual entry. You should be able to install and let it go.
It's probably not the most elegant script, but hey, I'm not really a programmer. I have tested this on 6.0 and 6.5RC1. Give it a go on a test box and let me know your results. One thing I would be interested in is if anyone has any issue with the fileinfo.so that gets copied to the system. I wanted to try to eliminate the need for the devrpms. If people have issues, then I'll get that added back in.
Thanks,
John H. Bennett III
SME 6.5RC1 Update Scripts (http://no.longer.valid/phpwiki/index.php/SME6.5UpdateScripts)
-
I have installed MIMP (webmail for mobile phones) and run prefect!!!!!!
Download the latest HEAD version, untar, all .dist without .dist, copy the imp servers.php template to custom-templates/home/httpd/html/horde/mimp/config/servers.php and expand
Configure in administration panel, and then activate in registry.php into horde config folder. If you want to see, set to active,, else set to hidden (better).
Follow this how to to set horde authentication to imp AND mimp.
http://wiki.horde.org/display.php?page=MIMPHowTo
I tried following your instructions for MIMP, but I can't get this to work all the way? Whenever I change to use the composite driver, then add the info from the mimp howto, when I try to login, I get just a blank screen. When I remove the composite and mimp additions, all is back to normal. Then I can click on mobile mail and it will work from there. Just not when you try to go to the initial page either using /webmail /horde, or /horde/imp. If you still have a copy of your horde/conf.php would you post it. I'd like to compare it with the one I am using and see where I might be wrong at.
Thanks,
JB
-
I just got a 6.5RC1 into production yesterday.
Ran your new script, jb, and Horde works like a charm !!!
By the way . . anyone know where I can get at the locale file?
The danish translation leaves some room for improvement - plenty of room, actually !
I'd be happy to return the result to the organization in charge of development as a token of my gratitude.
-
Sorry for the long post
Mini Howto
Donwload latest MIMP HEAD version
Untart it
Copy contents to /horde/mimp
Into config folder:
for f in *.dist; do cp $f basename $f .dist; done
Change in horde config file registry.php mimp status to ACTIVE
Login into horde and go to Administration, Configuration and choose MIMP
Under Mail Server Settings set to False to display servers.
Under Composse settings check CC header and BCC header
Then Save COnfiguration
mkdir -p /etc/e-smith/templates-custom/home/httpd/html/horde/mimp/config
cp -r /etc/e-smith/templates/home/httpd/html/horde/imp/config/servers.php /etc/e-smith/templates-custom/home/httpd/html/horde/mimp/config
/sbin/e-smith/expand-template /home/httpd/html/horde/mimp/config/servers.php
Now, go to Mobile Mail in horde and click. You see in the rigth panel the login screen. Login with the same user name and password of the current mailbox you are using. Sen a message to the surrent email and if all are ok you receive the email the email. If you go to normal horde you see the same email in your inbox.
Well, all run ok. Logout from mimp.
To avoid the doubble authentication in the mobile phone, you need change authentication mode in horde congiruation
Go to horde configuration, authentication tab, and set backend to "Composite authentication". Save your configuration file
Now, open your horde conf.php file and paste at the end following code:
$conf['auth']['params']['drivers'] = array(
'imp' => array('driver' => 'application',
'params' => array('app' => 'imp')),
'mimp' => array('driver' => 'application',
'params' => array('app' => 'mimp')));
$conf['auth']['params']['loginscreen_switch'] = _horde_select_loginscreen';
if (!function_exists('_horde_select_loginscreen')) {
function _horde_select_loginscreen()
{
require_once 'Horde/Browser.php';
$browser = &new Browser();
if ($browser->isMobile()) {
return 'mimp';
}
return 'imp';
}
}
Go to horde registry.php file again and set mimp to hidden, because you don't need mimp into imp. When you logged via web you see IMP. but via cellular phone you see MIMP.
For JB, this is my conf.php file:
<?php
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: horde/config/conf.xml,v 1.74.2.3 2005/02/03 16:57:42 jan Exp $
$conf['debug_level'] = E_ALL;
$conf['max_exec_time'] = 0;
$conf['use_ssl'] = 2;
$conf['server']['name'] = $_SERVER['SERVER_NAME'];
$conf['server']['port'] = $_SERVER['SERVER_PORT'];
$conf['compress_pages'] = true;
$conf['umask'] = 077;
$conf['session']['name'] = 'Horde';
$conf['session']['cache_limiter'] = 'nocache';
$conf['session']['timeout'] = 0;
$conf['cookie']['domain'] = $_SERVER['SERVER_NAME'];
$conf['cookie']['path'] = '/horde';
$conf['sql']['phptype'] = 'mysql';
$conf['sql']['persistent'] = false;
$conf['sql']['protocol'] = 'unix';
$conf['sql']['hostspec'] = 'localhost';
$conf['sql']['username'] = 'horde';
$conf['sql']['password'] = 'xxxxxxxx';
$conf['sql']['database'] = 'horde';
$conf['sql']['charset'] = 'iso-8859-1';
$conf['auth']['admins'] = array('xxxxxx@printing.com.ar');
$conf['auth']['checkip'] = true;
$conf['auth']['driver'] = 'composite';
$conf['signup']['allow'] = false;
$conf['signup']['approve'] = true;
$conf['signup']['preprocess'] = false;
$conf['signup']['queue'] = false;
$conf['log']['priority'] = PEAR_LOG_NOTICE;
$conf['log']['ident'] = 'HORDE';
$conf['log']['params'] = array();
$conf['log']['name'] = LOG_SYSLOG;
$conf['log']['type'] = 'syslog';
$conf['log']['enabled'] = true;
$conf['log_accesskeys'] = false;
$conf['prefs']['params']['table'] = 'horde_prefs';
$conf['prefs']['params']['driverconfig'] = 'horde';
$conf['prefs']['driver'] = 'sql';
$conf['datatree']['params']['table'] = 'horde_datatree';
$conf['datatree']['params']['driverconfig'] = 'horde';
$conf['datatree']['driver'] = 'sql';
$conf['group']['driver'] = 'datatree';
$conf['cache']['default_lifetime'] = 1800;
$conf['cache']['params']['dir'] = Horde::getTempDir();
$conf['cache']['driver'] = 'file';
$conf['token']['driver'] = 'none';
$conf['mailer']['params']['sendmail_path'] = '/usr/lib/sendmail';
$conf['mailer']['params']['sendmail_args'] = '-oi';
$conf['mailer']['type'] = 'sendmail';
$conf['vfs']['params']['vfsroot'] = '/tmp';
$conf['vfs']['type'] = 'file';
$conf['sessionhandler']['type'] = 'none';
$conf['image']['convert'] = '/usr/X11R6/bin';
$conf['problems']['email'] = 'webmaster@example.com';
$conf['menu']['always'] = false;
$conf['menu']['links']['help'] = 'all';
$conf['menu']['links']['options'] = 'authenticated';
$conf['menu']['links']['problem'] = 'never';
$conf['menu']['links']['login'] = 'all';
$conf['menu']['links']['logout'] = 'authenticated';
$conf['hooks']['username'] = false;
$conf['hooks']['preauthenticate'] = false;
$conf['hooks']['postauthenticate'] = false;
$conf['hooks']['authldap'] = false;
$conf['kolab']['enabled'] = false;
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */
$conf['auth']['params']['drivers'] = array(
'imp' => array('driver' => 'application',
'params' => array('app' => 'imp')),
'mimp' => array('driver' => 'application',
'params' => array('app' => 'mimp')));
$conf['auth']['params']['loginscreen_switch'] = '_horde_select_loginscreen';
if (!function_exists('_horde_select_loginscreen')) {
function _horde_select_loginscreen()
{
require_once 'Horde/Browser.php';
$browser = &new Browser();
if ($browser->isMobile()) {
return 'mimp';
}
return 'imp';
}
}
-
The script works great. One question though:
Does anyone have the correct rpms that will install wvhtml?
This message appears when I try to open a .doc attachment:
The program used to view this data type (/usr/bin/wvHtml) was not found on the system.
-
Long story shortened. I'm working on configuring INGO to use procmail. I have it somewhat set-up. The rules part works (Ingo sets up the sorting via procmail on the server). Using the change root contrib I had to change the ftp root to unrestricted...also had to change the permissions for that directory in proftpd.conf. Changed the folder delimiter from . to ; in /lib/script/procmail.php. Added this line to .procmailrc:
INCLUDERC=$HOME/.procmailrc.horde
Altered /config/backends.php to fit my needs.
Obviously a better way may exist.
Anway, my problem right now is vacation. This line for vacation in .procmailrc.horde doesn't work:
FILEDATE=ls -lcn --time-style=+%s 'vacation.username@mydomain.org' | awk '{ print $6 + (604800) }'
I get this error message in my procmail log:
ls: unrecognized option --time-style=+%s'
The whole vacation part is here:
:0
{
FILEDATE=ls -lcn --time-style=+%s 'vacation.username@mydomain.org' | awk '{ print $6 + (604800) }'
DATE=date +%s
DUMMY=test $FILEDATE -le $DATE && rm 'vacation.username@mydomain.org'
:0 Whc: vacation.lock
* $^To:.*username@mydomain.org
* !^X-Loop: username@mydomain.org
* !^FROM_DAEMON
| formail -rD 8192 vacation.username@mydomain.org
:0 ehc
| (formail -rI"Precedence: junk" \
-A"X-Loop: username@mydomain.org" \
-i"Subject: on vacation" ; \
echo "because" \
) | $SENDMAIL -oi -t
}
Any idea what can be done to fix this? IMHO, I think having Ingo use procmail and generate vacation messages would be nice.
-
For JB, this is my conf.php file:
Thanks for posting this. I was missing the last }. I have this now working in the script, which I will post later on today.
JB
-
Long story shortened. I'm working on configuring INGO to use procmail.
Is it better to use procmail for this? One of the reasons I included the accounts portion was to provide a link to user-manager, then the users can set their own settings via a somewhat easy interface.
Just asking.
JB
-
Is it better to use procmail for this? One of the reasons I included the accounts portion was to provide a link to user-manager, then the users can set their own settings via a somewhat easy interface.
Just asking.
JB[/quote]
For my users, thats a big YES. They are used to being able to change the vacation via horde (on the current server I have the vacation module set-up). Also, the user-manager doesn't have external access(of course that can also be changed) and the majority of my users are external. I'll get it working eventually...the problem seems to be the version of 'ls' on SME doesn't support the function needed.
-
As promised, I have updated the script to include MIMP. It even worked with my phone. 8-)
There are other slight modifications to make the script flow a little better.
Enjoy,
John Bennett
SME 6.5RC1 Unofficial Update Scripts (http://no.longer.valid/phpwiki/index.php/SME6.5UpdateScripts)
-
I did manage to get ingo to fully control procmail (blacklist/whitelist/sorting/vacation) and it seems to work really well. More testing is needed and I need to verify my 'method' works on a fresh 6.5 install. Basicly I removed the ability to indicate how many days between replies to a sender. (Here are a couple of screen shots...
http://www.welcome2cncs.com/ingo/Image3.jpg
http://www.welcome2cncs.com/ingo/Image4.jpg
-
In "10TurbaSources" at line 85 is a mistake:
} 'root' => 'dc={$turba_ldap},dc=com',
Geo
-
In "10TurbaSources" at line 85 is a mistake:
} 'root' => 'dc={$turba_ldap},dc=com',
Geo
No, this is not a mistake. They are on the same line so that when you expand the template, it doesn't insert a blank line.
JB
-
my server is in .xx not .com domain.
-
my server is in .xx not .com domain.
Well then that would be an issue I'd have to look at trying to correct some time. For now, you will have to manually edit that file and expand it for your domain suffix.
JB
-
For now, you will have to manually edit that file and expand it for your domain suffix. JB
Doesn't help one little bit.
After expansion of the sources.php
the line reads
...
'root' => 'dc=domain.xx,dc=xx',
...
so instead you'll have to erase the ($turba_ldap) parenthesis in line 85 of the 10TurbaSources-template, and replace with your own
....
'root' => 'dc=domain,dc=xx',
....
then expand the sources.php again.
That should take care of your problem.
Perhaps that ought to be documented in the 'update-scripts howto' as a reminder for those of us who don't have a .com domain.
Oh, by the way, JohnB
I love your scripts - they've saved me (and probably lots of others) many hours of tedious work.
Also lots of gratitude directed towards the other contributors.
You have all done some wonderful work!
-
Doesn't help one little bit.
After expansion of the sources.php
the line reads
...
'root' => 'dc=domain.xx,dc=xx',
...
It was just a guess. My test servers are down as I am reloading them again. Sorry that didn't work. I'm not sure how I can fix this. The next thing that will happen is someone will say, well I have mydomain.mysubdomain.xxx and the file should read dc=domain,dc=subdomain,dc=xx. So, I am open to suggestions, ok some code, from a real programmer.
Here is what I currently have:
/sbin/e-smith/config get DomainName > /root/plus/horde30/ldap
sed 's/.com//g' /root/plus/horde30/ldap > /root/plus/horde30/hordeldap
The above 2 lines get the value of the DomainName, chop off the .com (currently) and saves it to a file
#! /usr/bin/perl -w
$data_file="/root/plus/horde30/hordeldap";
open(DAT, $data_file) || die("Could not open file!");
@raw_data=<DAT>;
close(DAT);
foreach $ldapdomain (@raw_data)
{
chop($ldapdomain);
($ldap_domain)=split(/\|/,$ldapdomain);
}
exec "\/sbin\/e-smith\/config setprop horde LdapDomainName $ldap_domain";
exit 0
The perl script reads the file that was created and adds an entry into the config database for horde, which the 10TurbaSources fragment reads
So, I think the code needs to change so that it can output the dc= lines instead of trying to insert the proper values as I have them now. All suggestions welcomed.
Thanks,
JB
P.S. Thanks also for the kind words.
-
Try
'root' => ''
instead
'root' => 'dc=domain.xx,dc=xx'
Work for me
-
Try
'root' => ''
instead of
'root' => 'dc=domain.xx,dc=xx'
Work for me
Actually it shouldn't work.
the $turba_ldap puts the contents on both sides of a period (.) inside the DC 'container'.
To my best knowledge the system cannot interpret this, or, for that matter, a string that isn't there.
-
Try
'root' => ''
instead of
'root' => 'dc=domain.xx,dc=xx'
Work for me
Actually it shouldn't work.
the $turba_ldap puts the contents on both sides of a period (.) inside the DC 'container'.
To my best knowledge the system cannot interpret this, or, for that matter, a string that isn't there.
I think he means to just use 'root' => ''. I tried that and it seems to work. I am testing more just to verify.
JB
-
I think he means to just use 'root' => ''. I tried that and it seems to work. I am testing more just to verify.
Yes, correct. Sorry for my bad english.
I extracted this for the previus turba source.php file.
About kronolith reminders, I read your thread at horde list, and I tryed this and run ok.
I use at command line:
/usr/bin/php /home/httpd/html/horde/kronolith/scripts/reminders.php
Run ok, and I get the reminders emails.
I use php 4.3.10 from Greg script
http://ergin.dyndns.org/download/php4.3.10-upgrade.sh
If you want to try, remove your current php version, and all extensions
Before execute, uncomment the lines for curl, mcrypt, mhash, domxml, xmlrpc
Then create a php custom template file named 70DynamicExtension71 and write this:
extension=domxml.so
extension=curl.so
Save, expand php, and restart httpd.
I use curl because moregroupware use it.
Ofcourse, you can load other extensions if you need it.
Tell me if you can run reminders ok with this php version.
Another module use reminders is nag, but I not tested yet.
Other issue for kronolith is the free/busyURL.
-
About kronolith reminders, I read your thread at horde list, and I tryed this and run ok. I use at command line:
/usr/bin/php /home/httpd/html/horde/kronolith/scripts/reminders.php
Other issue for kronolith is the free/busyURL.
EDIT
OK, 2 down 1 to go. Using 'root' => '' does seem to work. I have also been able to get the reminders to work. I never ever set my default identity. The initial setup seems to be inconsistent for me. It seems that my reminders don't work until I invite myself to 1 event, then they all start working. Need to test this more for my sanity. Thanks for the help.
JB
-
I don't have cron configured yet.
I run only through command line
In the kronolith configuration the server name is "localhost" and email "reminders". I don't know what happens if set to the real server name and a real email.
Other issue. In my log searching for "fileinfo" I see this:
Mar 13 14:18:51 internetserver php: PHP Warning: Unknown(): Unable to load dynamic library '/usr/lib/php4/fileinfo.so' - libmagic.so.1: cannot open shared object file: No such file or directory in Unknown on line 0
PicsOne
-
It looks like to fix your libmagic.so.1 error, you need to install the file-4.12-3db_rh73.i386.rpm. The php rpm's you install don't include that. You can get that from Dan Brown's contribs directory, he originally put it together, or from my contribs directory.
JB
-
About kronolith reminders, I read your thread at horde list, and I tryed this and run ok. I use at command line:
/usr/bin/php /home/httpd/html/horde/kronolith/scripts/reminders.php
Run ok, and I get the reminders emails.
I use php 4.3.10 from Greg script
http://ergin.dyndns.org/download/php4.3.10-upgrade.sh
If you want to try, remove your current php version, and all extensions
Before execute, uncomment the lines for curl, mcrypt, mhash, domxml, xmlrpc
Then create a php custom template file named 70DynamicExtension71 and write this:
extension=domxml.so
extension=curl.so
Save, expand php, and restart httpd.
I use curl because moregroupware use it.
Of course, you can load other extensions if you need it.
Tell me if you can run reminders ok with this php version.
Another module use reminders is nag, but I not tested yet.
Other issue for kronolith is the free/busyURL.
OK, now that my head is out of my hind-end, I am ready to move a little further with this. I have been able to get reminders working with the PHP rpm's in my contrib directory and with the PHP rpm's mentioned above. I don't know much about the various PHP modules and what value they add, so whatever the majority wants, that is what I will use. I also found a libmycrypt and libmhash rpm to use so you don't have to install with --nodeps, and all of the php modules in the php.ini file load fine when httpd is restarted. I don't know who I downloaded those PHP rpm's from, but I can get them put on my contribs space. The last piece to get working, IMO, is free/busy. It looks like there are 2 ways to make this work. One with an LDAP schema extension, and one using the mysql backend. I don't know enough about LDAP, so I have chosen the latter.
I have setup a default calender, set permissions, , set my default address book to use for free/busy lookups, added another user on the system to my personal address book. Tried to add an event, then invite attendees, and get the error that no freebusyURL exists. I have posted a quesiton on the Kronolith to see if anyone can shed some light on what else needs to be done.
JB
-
free/busy needs to have the free/busy url for your own name as well as the users you want to invite in the addressbook you select. Then my error was from not setting allow_url_fopen = ON in php.ini. After changing that it works. My plan was to use mysql to create a shared addressbook for everyone, put in the free/busy url for all those addresses, and use it for free/busy look-ups. Of course it would be nice if the free/busy url was filled in automatically. (I already use multiple shared mysql addressbooks with the old horde version)
-
Better (for security) to edit or make a httpd.conf template adding something like this:
<Directory /home/httpd/html/horde>
php_admin_flag allow_url_fopen on
</Directory>
I'm working on Horde 3 rpms for SME 7. What I'm up to right now is figuring out what templates need to be made, and how best to break down each one. I'll keep you all updated.
Greg
-
Then my error was from not setting allow_url_fopen = ON in php.ini. After changing that it works.
I can't seem to find the template fragment where you set the allow_url_fopen to on.
The fragment in templates/etc/php.ini only refers to a variable?
-
I just got rid of the variable and set it directly. Keep in mind this is a test server I'm working with. Testing the feasibility of switching to the latest horde version via SME. This is the better way to do it (in a httpd.conf template):
<Directory /home/httpd/html/horde>
php_admin_flag allow_url_fopen on
</Directory>
FYI, this is also need for horde weather(which works very nice, my users will like it)
All we use is webmail (horde/imp/etc...) for email, so everything has to work perfect. This is why I messed around with ingo/procmail so the vacation part will work for my users--I like the server side sorting into folders part of it. IMP's PGP encryption stuff works nice. I found a bug in nag that will be fixed in the next release. Using phpa increased the speed greatly (had to up the size to 16 mb) and decreased server load. Gollem(file manager) also works nice. If someone wants to take a look at it, send me an email and I'll set you up with a temp userid/password.
-
free/busy needs to have the free/busy url for your own name as well as the users you want to invite in the addressbook you select. Then my error was from not setting allow_url_fopen = ON in php.ini. After changing that it works. My plan was to use mysql to create a shared addressbook for everyone, put in the free/busy url for all those addresses, and use it for free/busy look-ups. Of course it would be nice if the free/busy url was filled in automatically. (I already use multiple shared mysql addressbooks with the old horde version)
hordeusr,
I have one thing to say. "Hell yeah, you da man!!" 8-)
I was missing that allow_url_fopen = ON as well. All is now working. I don't know mysql that well. How do you or have you created additional shared address books for your users?
Thanks again,
JB
-
Then my error was from not setting allow_url_fopen = ON in php.ini. After changing that it works.
I can't seem to find the template fragment where you set the allow_url_fopen to on.
The fragment in templates/etc/php.ini only refers to a variable?
It's part of the config db, you can do this?
/sbin/e-smith/config setprop php AllowUrlFopen On
/sbin/e-smith/expand-template /etc/php.ini
/etc/e-smith/events/actions/restart-httpd-full
JB
-
I just got rid of the variable and set it directly. Keep in mind this is a test server I'm working with. Testing the feasibility of switching to the latest horde version via SME. This is the better way to do it (in a httpd.conf template):
<Directory /home/httpd/html/horde>
php_admin_flag allow_url_fopen on
</Directory>
FYI, this is also need for horde weather(which works very nice, my users will like it)
All we use is webmail (horde/imp/etc...) for email, so everything has to work perfect. This is why I messed around with ingo/procmail so the vacation part will work for my users--I like the server side sorting into folders part of it. IMP's PGP encryption stuff works nice. I found a bug in nag that will be fixed in the next release. Using phpa increased the speed greatly (had to up the size to 16 mb) and decreased server load. Gollem(file manager) also works nice. If someone wants to take a look at it, send me an email and I'll set you up with a temp userid/password.
You think it's better to set it in the httpd.conf file rather than setting the config db setting? Got a howto for phpa? I haven't tried Gollem, I'll be dropping you a line.
JB
-
You think it's better to set it in the httpd.conf file rather than setting the config db setting? Got a howto for phpa? I haven't tried Gollem, I'll be dropping you a line.
JB
Yes because then it's only set for the horde folder and not globally. I don't have a howto, but the install instructions are pretty easy.
Download the correct version of phpa
created a file: /etc/e-smith/templates-custom/etc/php.ini/70DynamicExtension76phpa
with this text:
zend_extension="/usr/lib/php4/php_accelerator_1.3.3r2.so"
phpa.shm_size = 16
put the php_accelerator_1.3.3r2.so file in that folder
put the phpa_cache_admin in the root folder
expand the php.ini template
restart httpd
login into horde
move through all the horde modules a few times to cache the php stuff.
after you have moved through the modules a few times everything should load quicker.
in the root folder run
./phpa_cache_admin -mv and see how much memory is being used to verify it's working. I use it on our production server with excellent results. It's most noticeable when I have lots of horde users using horde and the server just laughs (instead of slowing down).
-
I've discovered an error notice in my 'messages' log:
Several lines over the past few days state...
PHP notice: Undefined offset: 0 in /home/httpd/html/horde/imp/lib/IMP.php on line 585
That line is in the section to add the list of mailboxes to the lists, and it simply reads: if (is_null($filter[0]))
I don't get it - how can that be an undefined offset ??
-
I've discovered an error notice in my 'messages' log:
Several lines over the past few days state...
PHP notice: Undefined offset: 0 in /home/httpd/html/horde/imp/lib/IMP.php on line 585
That line is in the section to add the list of mailboxes to the lists, and it simply reads: if (is_null($filter[0]))
I don't get it - how can that be an undefined offset ??
That is a bug in Horde and will be fixed in their next stable release. If you want to fix it now, you need to read the Horde archives and find the fix someone posted a while back..
JB
-
ok so no errors on a fresh install of 6.5, but when using the server-manager I get the following error "The requested URL /horde/sme/index.html was not found on this server." I have looked and sure enough there is no index.html... did I miss something?
Regards
-
ok so no errors on a fresh install of 6.5, but when using the server-manager I get the following error "The requested URL /horde/sme/index.html was not found on this server." I have looked and sure enough there is no index.html... did I miss something?
Regards
No, you didn't miss anything, you just caught me in mid-change. I take you are trying to click on the Horde Admin Setup? I believe I had a typo. I have just tested the install on a new server with an updated script and it seems to work fine for me. I'll be uploading that shortly. I can try to help you fix what you have now, or you can just reload the server after I have updated the script, etc.
To fix:
mkdir -p /home/httpd/html/horde/sme [may already be there]
mkdir -p /etc/e-smith/templates-custom/home/httpd/html/horde/sme/index.html [may already be there]
wget -nc mirror.contribs.org/smeserver/contribs/jbennett/horde30/10sme.index.html
cp 10sme.index.html /etc/e-smith/templates-custom/home/httpd/html/horde/sme/index.html/
cp /etc/e-smith/templates-default/template-begin-html /etc/e-smith/templates-custom/home/httpd/html/horde/sme/index.html/template-begin
/sbin/e-smith/expand-template /home/httpd/html/horde/sme/index.html
HTH and sorry about that,
JB
-
Hi there
Gollem(file manager) also works nice.
I've set up Syncback (http://www.2brightsparks.com/syncback) running backups for some friends and relatives, it copies their data into their home folder by ftp, giving them an offsite backup.
However, I would like to remove the 'FTP' bit as most kids/ordinary users are just confused by the terminology and don't understand the semantics of using an FTP client to recover/manage their remote copies of files.
Hence I'm very interested in Gollem - have you got a howto (or maybe a script :-P ) to add it to Horde 3?
Cheers,
David.
-
ok so no errors on a fresh install of 6.5, but when using the server-manager I get the following error "The requested URL /horde/sme/index.html was not found on this server." I have looked and sure enough there is no index.html... did I miss something?
Regards
To fix:
<massive snips>
wget -nc mirror.contribs.org/smeserver/contribs/jbennett/horde30/10sme.index.html
<massive snips>
JB
Dear JB
I did a fresh installation of 6.5RC1. Installing Horde, I used the the excellent script made by you which I acquire from the 6.5 Contribs page ver May 1st.
I had the same problem as dswillia and when I saw your quick fix as quoted above, I was somewhat relieved. when I got to the html file, turns out that it has been removed.
I supposed the script dated May 1st should not require the quick fix above and I may have done an improper installation since the quick-fix was dated way back in March.
Can you help please...
Sincere regards and thanks
DK
-
To fix:
<massive snips>
wget -nc mirror.contribs.org/smeserver/contribs/jbennett/horde30/10sme.index.html
<massive snips>
JB
Dear JB
I did a fresh installation of 6.5RC1. Installing Horde, I used the the excellent script made by you which I acquire from the 6.5 Contribs page ver May 1st.
I had the same problem as dswillia and when I saw your quick fix as quoted above, I was somewhat relieved. when I got to the html file, turns out that it has been removed.
I supposed the script dated May 1st should not require the quick fix above and I may have done an improper installation since the quick-fix was dated way back in March.
Can you help please...
Sincere regards and thanks
DK
deunan,
Those file locations have changed. The reason was that if webmail was set to just http only, then the setup panel would error out. The new location is /home/e-smith/files/ibays/Primary/html/smehorde/. I just re-installed my test server and the script ran fine and the 2 server-manager panels worked as well. I have a proxy cache in front of my connection and I have found that when I have uploaded a new script, I must clear the cache to get the latest updates to work. I will re-upload the script and update the wiki page as well. Could you try running it again. It should be available by the 22nd.
Dis-regard my last post. I can't login to my contribs directory. I'll need to check what is going on with that, after the site change. So, you will need to copy and paste the script from the wiki page located Here (http://no.longer.valid/phpwiki/index.php/SME6.5Contribs)
JB
-
Just installed this and loving it, but two quick questions/issues:
1.) In server-manager, the Launch Horde Web Administration button defaults to www.mydomain.com/horde/admin/setup despite my being at server-manager through local IP address. (Since that domain isn't valid, I get a 404 error every time and have to manually retype the address.) Is this locked into the primary domain for the server? Can it default to append /horde/admin/setup to the end of whatever address server-manager is accessed through?
2.) In the Horde setup page, logging tab, it says "Syslog facility to use, this field is required." I don't know what to put there and can't save the configuration until that is filled in. Help?
Other than that, the installation on my 6.01 machine was smooth and effortless.
-
Just installed this and loving it, but two quick questions/issues:
1.) In server-manager, the Launch Horde Web Administration button defaults to www.mydomain.com/horde/admin/setup despite my being at server-manager through local IP address. (Since that domain isn't valid, I get a 404 error every time and have to manually retype the address.) Is this locked into the primary domain for the server? Can it default to append /horde/admin/setup to the end of whatever address server-manager is accessed through?
Probably. I may look into that. My test server is down for a while.
2.) In the Horde setup page, logging tab, it says "Syslog facility to use, this field is required." I don't know what to put there and can't save the configuration until that is filled in. Help?
Other than that, the installation on my 6.01 machine was smooth and effortless.
Interesting, you are getting that. Is this from the latest script? I remember having this issue, but had corrected it. Put in LOG_SYSLOG.
Note: Remember the server-manager selections are a hack made by me because I wanted to use the horde developed web manager and really didn't want to template the various conf files. As is the accounts section in webmail. This will be an issue when you upgrade to 6.5 or 7.0. For 6.5, you will be taken back to horde 2 and will need to run the script again. For 7, you will have the horde 3 versions of horde, imp, turba. Currently, Kronolith, mnemo, nag, and ingo are not part of the standard distro. Greg mentioned that you may create RPM's for these and see if they can possibly be included in the standard distro.
Just some things to think about.
JB
-
I had downloaded the script yesterday morning from the Contribs site.
After I had botched the syslog facility entry by setting it to the email option (which resulted in an inability to log into Horde at all!) I restored to previous configuration by overwriting the conf.php file with the conf.php.bak file. This worked.
Interestingly, this morning when I went back into Horde to enter the LOG_SYSLOG value that you had provided, it was already there. I'm not sure then how it vanished the first time.
The only other glitches I've found:
1) it always shows the last login as "Never." Previous version of IMP displayed this correctly.
2) Kronolith doesn't seem to indicate which calendar you're currently looking at when you choose one from the drop down menu "My Calendars".
Anyone know of a good place to get docs on these applications? horde.org is kinda thin, and there are a lot of settings and tweaks for a newbie :)
Thanks!
-
I had downloaded the script yesterday morning from the Contribs site.
After I had botched the syslog facility entry by setting it to the email option (which resulted in an inability to log into Horde at all!) I restored to previous configuration by overwriting the conf.php file with the conf.php.bak file. This worked.
Interestingly, this morning when I went back into Horde to enter the LOG_SYSLOG value that you had provided, it was already there. I'm not sure then how it vanished the first time.
The only other glitches I've found:
1) it always shows the last login as "Never." Previous version of IMP displayed this correctly.
2) Kronolith doesn't seem to indicate which calendar you're currently looking at when you choose one from the drop down menu "My Calendars".
Anyone know of a good place to get docs on these applications? horde.org is kinda thin, and there are a lot of settings and tweaks for a newbie :)
Thanks!
You could have also used the horde30-restore script in the root/horde30-restore directory to restore your old settings.
Here is a link for the last login stuff: http://marc.theaimsgroup.com/?l=imp&m=111103499527498&w=2
The jist is this attribute is owned by horde now and not imp. I had to manually fix mine, don't know how to write a MySQL script to change globally.
Kronolith calendars I have had to trial an error this, but I see what you mean.
JB
-
Is there any chance that the Horde upgrade would have removed a phpmyadmin install as a result of the PHP upgrade included in the script? I used to have phpmyadmin installed on this box, and when I went to access it to do the change in the link you provided, the URL didn't work. Now, it's not listed in my installed RPMs.
Is it safe to reinstall, or should I be looking for a newer version (old version was 2.5.0-5 from Darrel May.)
-
Is there any chance that the Horde upgrade would have removed a phpmyadmin install as a result of the PHP upgrade included in the script? I used to have phpmyadmin installed on this box, and when I went to access it to do the change in the link you provided, the URL didn't work. Now, it's not listed in my installed RPMs.
Is it safe to reinstall, or should I be looking for a newer version (old version was 2.5.0-5 from Darrel May.)
AFAIK no. When you go to access phpmyadmin, what do your logs say? If you send me a link the the phpmyadmin rpm, I'll install it on my test box, then run the horde script and see what I can see.
JB
-
AFAIK no. When you go to access phpmyadmin, what do your logs say? If you send me a link the the phpmyadmin rpm, I'll install it on my test box, then run the horde script and see what I can see.
JB
K. I'll tackle this Monday when I get back to the office with this server. Thanks!
-
OK, I uploaded a new version of the script. I made the change so that the server-manager panel doesn't use the local domain name. Also, there seems to be a problem with php accelerator running under 6.5. It will work if a service httpd restart is issued. Don't know the real issue there yet. So, for 6.5 I added an entry to /etc/rc.d/rc.local to restart httpd.
If anyone can find the real reason php accelerator doesn't run natively under 6.5, I'd appreciate an answer. 6.0x seems to run just fine without any further modifications.
JB
-
AFAIK no. When you go to access phpmyadmin, what do your logs say? If you send me a link the the phpmyadmin rpm, I'll install it on my test box, then run the horde script and see what I can see.
JB
K. I'll tackle this Monday when I get back to the office with this server. Thanks!
I installed the phpmyadmin contrib from Darrell's contrib directory today on a 6.0 and 6.5 server. I didn't have any issues on the 6.0 server, except needing to make sure I changed to https. Initially, when I tried to run it under 6.5 it would not run. So, I did an service httpd restart and then was able to get to it. Why this works, I don't know, but it also fixes the php accelerator issue I have been having. So, if you run the latest script, I issue a service httpd restart and also put this in the /etc/rc.d/rc.local so it gets run when the server reboots.
HTH,
JB
-
Okay.. false alarm on the phpmyadmin stuff. After checking through my records, I realize now it was not installed at the time I upgraded Horde, so no worries there. I removed it about 2 weeks ago and completely forgot - good thing I log that sorta stuff, huh?
-
Most of you are talking about an upgrade to Horde 3.0 on SME6.5, but is there also an update-script for SME6.01?
-
EdelingF,
My install was on 6.01 and went quite smoothly. I used the same script as posted in this forum.
-
Most of you are talking about an upgrade to Horde 3.0 on SME6.5, but is there also an update-script for SME6.01?
The horde script I wrote, works quite nicely on 6.0, 6.01-01 and 6.5RC1.
JB
-
The horde script I wrote, works quite nicely on 6.0, 6.01-01 and 6.5RC1.JB
Is this the http://mirror.contribs.org/smeserver/contribs/jbennett/install_horde30.sh script?
Freek
-
The horde script I wrote, works quite nicely on 6.0, 6.01-01 and 6.5RC1.JB
Is this the http://mirror.contribs.org/smeserver/contribs/jbennett/install_horde30.sh script?
Freek
I wouldn't use that site. I have not had good luck with the files from contribs.org replicating there. The script is located at:
http://mirror.contribs.org/smeserver/contribs/jbennett/install_horde30.sh where you can download it
or
http://no.longer.valid/phpwiki/index.php/SME6.5Contribs - where you can copy and paste it.
If you do decide to get it from ibiblio I'd be interested to know if the install works for you. That used to be my secondary site until I actually tried to install from it and the install did not work.
JB
-
Install went farely well, had to manually upgrade PHP to 4.3.10 (Ergin's script) before I could login webmail. (got a white page)
For so far as I can see the only things that are not working properly are:
kronolith gives an error:
Fatal error
You need the domxml PHP extension to use the configuration tool.
[line 25 of /home/httpd/html/horde/admin/setup/config.php]
and I'm getting a reminder:
the ionCube PHP Accelerator requires Zend Engine API version 20021010.
The Zend Engine API version 20010710 which is installed, is outdated.
X-Powered-By: PHP/4.1.2
Content-type: text/html
and I can't add or change users
For the rest, it looks great!
Freek
-
Install went farely well, had to manually upgrade PHP to 4.3.10 (Ergin's script) before I could login webmail. (got a white page)
For so far as I can see the only things that are not working properly are:
kronolith gives an error:
Fatal error
You need the domxml PHP extension to use the configuration tool.
[line 25 of /home/httpd/html/horde/admin/setup/config.php]
The script installs a specific version of php-4.3.10 that someone created and recommended. The domxml module is one of them. If you are using a different or newer version of php, then you will need to find the appropriate php-domxml rpm.
and I'm getting a reminder:
the ionCube PHP Accelerator requires Zend Engine API version 20021010.
The Zend Engine API version 20010710 which is installed, is outdated.
X-Powered-By: PHP/4.1.2
Content-type: text/html
I don't know what the above error is referring to? It looks like you are running php 4.1.2 and not 4.3.x. I have only used the php 4.3.10 that the script installs. You may have to research that error on the ioncube homepage.
and I can't add or change users
For the rest, it looks great!
Freek
What do you mean here? For SME you have to add users via the server-manager panel
JB
-
I've mailed Ergin to ask him which RPM would be the right php-domxml rpm, he has several RPM's in his contribs/script area; I think I need php-domxml-4.3.10-3eo.i386.rpm
The reminder-email was send several times after installing, after a reinstall I didn't receive any reminders anymore
The thirt question was a stupid question I didn't actually asked :hammer:
-
Installed the script on my 6.01-01, where I host a few sites and found that when logging in through a virtual domain, the user would be shown at the bottom of the page as if logged into my primary domain:
You are currently logged in as user@domain.xx
Have made a small hack that changes this so that the user is shown as:
You are currently logged in as user@virtualdomain.xx
------------------
(changes is in red)
pico /home/httpd/html/horde/templates/sme-common-header.inc
<?php
$vdomain = getenv('HTTP_HOST');
$vdomain = preg_replace('|^www.|i', '', $vdomain);
$vdomain = strtolower($vdomain);
/* Added by John H. Bennett III bennettj at thebennetthome.com */
echo "<font color=blue>";
echo "<p>";
echo "<b><center>You are currently logged in as ";
echo $imp['user']."@";
echo $vdomain;
echo "</center></b>";
echo "</font>";
?>
CTRL-X and save file
Hope it's usefull
Frederik
-
Installed the script on my 6.01-01, where I host a few sites and found that when logging in through a virtual domain, the user would be shown at the bottom of the page as if logged into my primary domain:
You are currently logged in as user@domain.xx
Have made a small hack that changes this so that the user is shown as:
You are currently logged in as user@virtualdomain.xx
------------------
(changes is in red)
pico /home/httpd/html/horde/templates/sme-common-header.inc
<?php
$vdomain = getenv('HTTP_HOST');
$vdomain = preg_replace('|^www.|i', '', $vdomain);
$vdomain = strtolower($vdomain);
/* Added by John H. Bennett III bennettj at thebennetthome.com */
echo "<font color=blue>";
echo "<p>";
echo "<b><center>You are currently logged in as ";
echo $imp['user']."@";
echo $vdomain;
echo "</center></b>";
echo "</font>";
?>
CTRL-X and save file
Hope it's usefull
Frederik
Excellent, thank you for this update.
JB
-
I'm running PHP 4.3.11 and MYSQL 4.1.11-standard
Will the upgrade script mentioned above for SME6.0.1 work with what I have installed or will I need to edit the script? If I would have to edit what should I edit? Thanks in advance
Ed
-
I'm running PHP 4.3.11 and MYSQL 4.1.11-standard
Will the upgrade script mentioned above for SME6.0.1 work with what I have installed or will I need to edit the script? If I would have to edit what should I edit? Thanks in advance
Ed
I have not personally used php 4.3.11. Others have and have had success. Some extra pear modules had to be installed. I have also not testing anything with mysql 4.1.
-
Thanks mrjhb3
If anyone else out there has successfully upgraded to Horde 3 with PHP 4.3.11 and MSQL 4.1.11 please jump in and let me know what you did.
Thanks to all for a great support forum!
-
Ok, I tried installing after removing the references to PHP 4.3.10 and all seemed to go fine right until the end where it displayed the following message:
Installing base Horde configurations
Finishing up horde installation...
ERROR: No templates were found for /home/httpd/html/horde/kronolith/config/conf.
php.
at /sbin/e-smith/expand-template line 49
Shutting down http: [ OK ]
Starting httpd: [ FAILED ]
serviceControl: Couldn't system(/etc/rc.d/rc7.d/S85httpd-e-smith, restart):
Couldn't restart httpd-e-smith at /etc/e-smith/events/actions/restart-httpd-full
line 45.
Stopping crond: [ OK ]
Starting crond: [ OK ]
Rebuilding Web Server Manager Left Panel Cache... Can take up to a minute.
Horde 3.0 Components have been successfully installed
Now since httpd will not restart I cannot access server manager or my websites.
Is this because of a pear module?
If so, which one/ones do I need to install?
Thanks again.
-
How do you run the script?
-
Just type "sh install_horde30.sh" at the server prompt in the directory where you saved the script file.
-
Thank you
-
I figured out that a conflict between my previously installed ZEND optimizer and the phpaccelerator installed with the script. I removed the phpini customtemplate for the phpaccelerator expanded the template and restarted httpd and my web stuff is working again.
I do have one issue though, when I try to access <host address>/horde/test1.php I get:
Forbidden
You don't have permission to access /horde/test1.php on this server.
If I try to navigate to <https://host address>/horde I get:
A fatal error has occurred
DB Error: connect failed
Details have been logged for the administrator.
<http://host address>/horde gives me:
Forbidden
You don't have permission to access /horde/ on this server.
If I try to Launch Horde Web Administration through server manager I get:
Forbidden
You don't have permission to access /horde/admin/setup on this server.
What are the permission setting suppose to be so I can get it configured?
-
Ok, I tried installing after removing the references to PHP 4.3.10 and all seemed to go fine right until the end where it displayed the following message:
Installing base Horde configurations
Finishing up horde installation...
ERROR: No templates were found for /home/httpd/html/horde/kronolith/config/conf.
php.
at /sbin/e-smith/expand-template line 49
Shutting down http: [ OK ]
Starting httpd: [ FAILED ]
serviceControl: Couldn't system(/etc/rc.d/rc7.d/S85httpd-e-smith, restart):
Couldn't restart httpd-e-smith at /etc/e-smith/events/actions/restart-httpd-full
line 45.
Stopping crond: [ OK ]
Starting crond: [ OK ]
Rebuilding Web Server Manager Left Panel Cache... Can take up to a minute.
Horde 3.0 Components have been successfully installed
Now since httpd will not restart I cannot access server manager or my websites.
Is this because of a pear module?
If so, which one/ones do I need to install?
Thanks again.
Your issue doesn't appear to be pear related at this time.
I can't duplicate any of the above. I rebuilt my sme6.5 RC1 test box and have ran the script about 10 times without error. I have even ran the horde20-restore script 3 times to return my system back to teh default state, then ran the script.
It looks like you don't have the template fragment files 10AllKronolith and template-begin. Do you have anything in this directory: /etc/e-smith/templates-custom/home/httpd/html/horde/kronolith/config/conf.php? That is where those two files should be.
I have not seen any http restart errors. What do the logs say? See if you can do a simple - service httpd restart, or service httpd start to get it going.
I also made a change to the script today. I modified all of the wget commands to use a variable. That way you can supply more or less commands that wget will use. To turn off the quiet mode so that you can see what is being downloaded just remove the -q from the variable or add what you want. The variable line is located on line 65 of the script. As you can tell from the remarks, I hadn't thought about adding commands for wget until just now. Partial below:
#####
# If you would like to see the status of the files
# being downloaded remove the -q from the next line.
#####
DL="wget -nc -q"
JB
-
Thanks for your reply
I do have thetwo files but they are in the path
/etc/e-smith/templates-custom/home/httpd/html/horde/kronolith/config/conf.php1 not conf.php for whatever reason.
-
I renamed the directory to conf.php and expanded the template and did a service httpd restart but it still gives me the error:
A fatal error has occurred
DB Error: connect failed
Details have been logged for the administrator.
-
I figured out that a conflict between my previously installed ZEND optimizer and the phpaccelerator installed with the script. I removed the phpini customtemplate for the phpaccelerator expanded the template and restarted httpd and my web stuff is working again.
I am glad to hear that. If you have any suggestions on how to detect ZEND optimizer, maybe just look for a file, then I could try to check for this and not install phpaccelerator. If you have a howto for ZEND, I will install it and see what I can do on my own.
I do have one issue though, when I try to access <host address>/horde/test1.php I get:
Forbidden
You don't have permission to access /horde/test1.php on this server.
If I try to navigate to <https://host address>/horde I get:
A fatal error has occurred
DB Error: connect failed
Details have been logged for the administrator.
<http://host address>/horde gives me:
Forbidden
You don't have permission to access /horde/ on this server.
Do a /sbin/e-smith/config show horde and see what the DbPassword is and compare that to horde/conf.php. They should be the same. If not, try expanding the horde/conf.php template again and see if you can get to the web page. If that doesn't work, you could try to re-expand the httpd.conf template, then restart httpd and see if that corrects anything. I am reaching here.
If I try to Launch Horde Web Administration through server manager I get:
Forbidden
You don't have permission to access /horde/admin/setup on this server.
What are the permission setting suppose to be so I can get it configured?
The files for the server-manager panel are located at
/etc/e-smith/web/functions - adminhordesave and adminhordesetup.
adminhordesetup runs - exec '/bin/chown -R www.www /home/httpd/html/horde'; Those are the permissions needed to modify via the web, then adminhordesave runs - exec '/etc/e-smith/events/actions/horde-admin-save';
Hopefully, we are getting closer to getting this solved.
JB
-
ZEND can be recognized by the presence of 81ZendOptimizer in the /etc/e-smith/templates-custom/etc/php.ini directory. Greg Swallow had the great script for installing ZEND optimizer.
The horde conf.php has the following entry for password:
$horde_pw = $horderec->prop('DbPassword') || 'horde';
[root@mail root]# /sbin/e-smith/config show horde
horde=service
access=SSL
imp=installed
kronolith=installed
mnemo=installed
nag=installed
status=enabled
Does not appear to have a password.
Re-expanded the template file to no avail.
The permissions in etc/e-smith/web/functions appear to be fine and read the same as all the others.
adminhordesetup runs - exec '/bin/chown -R www.www /home/httpd/html/horde'
Appear to be www.www 755 recursively
Still no go?
-
mrjhb3
I finally figured out what the heck my problem was and fixed it.
Basically, the issue was of course with the new version of MYSQL 4.1.11 and the way it handles passwords.
That's why I was getting the ....
"A fatal error has occurred
DB Error: connect failed
Details have been logged for the administrator" error.
What I did to fix it is so simple it's almost laughable but unless you know what to do it's rather impossible to fix. ;-)
Here is what I had to do:
At the command line type this:
1) mysql
2) UPDATE user SET Password=OLD_PASSWORD('your_Horde_password_here') WHERE User='horde';
3) FLUSH PRIVILIGES;
That's it!! Now it all works like a dream :pint:
Thanks for your help and maybe others that will inevitably run into the same situation will now know how to resolve it.
Cheers
Ed
-
Every 5 min I get this message sent to root@myserver. There are two other errors which I believe are related. Could someone point me the right direction to fix this. I have installed the Horde 3.0 script. It is installed on a 6.0.1 box. Thanks heaps.
Subject: Cron <root@gateway> /usr/bin/php /home/httpd/html/horde/kronolith/scripts/reminders.php
A fatal error has occurred
Unable to load the definition of Kronolith_Driver_.
Details have been logged for the administrator.
If I log into webmail as admin and go in administration, setup. The application status for Calendar (kronolith) displays this.
Missing configuration. You have to generate it now if you want to use this application.
If I log into webmail as a user and go into Organizing then Calendar this is displayed.
Some of Kronolith's configuration files are missing or unreadable conf.php
This is the main Kronolith configuration file. It contains paths and options for the Kronolith scripts. You need to login as an administrator and create the file with the web frontend under "Administration => Configuration". Create these files from their .dist versions in /home/httpd/html/horde/kronolith/config and change them according to your needs.
-
mrjhb3
I finally figured out what the heck my problem was and fixed it.
Basically, the issue was of course with the new version of MYSQL 4.1.11 and the way it handles passwords.
That's why I was getting the ....
"A fatal error has occurred
DB Error: connect failed
Details have been logged for the administrator" error.
What I did to fix it is so simple it's almost laughable but unless you know what to do it's rather impossible to fix.
Here is what I had to do:
At the command line type this:
1) mysql
2) UPDATE user SET Password=OLD_PASSWORD('your_Horde_password_here') WHERE User='horde';
3) FLUSH PRIVILIGES;
That's it!! Now it all works like a dream
Thanks for your help and maybe others that will inevitably run into the same situation will now know how to resolve it.
Cheers
Ed
I too am having this problem.
However, the solution above didn't work for me as mysql kept giving me errors about not selecting a database.
So I used phpmyadmin to reset the password, which seems to have gone in OK - only I still can't use horde webmail (fallen back on the not so familiar Twig).
Here's what I've got in phpmyadmin for the users table in the 'mysql' database:
Edit Delete localhost root XXXXX Y Y Y Y Y Y Y Y Y Y Y Y Y Y
Edit Delete fleable root XXXXX Y Y Y Y Y Y Y Y Y Y Y Y Y Y
Edit Delete localhost horde YYYYY N N N N N N N N N N N N N N
Edit Delete % radius ZZZZZ N N N N N N N N N N N N N N
Edit Delete % horde YYYYY N N N N N N N N N N N N N N
Edit Delete localhost www AAAAA N N N N N N N N N N N N N N
Edit Delete localhost twig CCCCC N N N N N N N N N N N N N N
Edit Delete fleable horde YYYYY N N N N N N N N N N N N N N
Is this as it should be?
Where else can I tweak things
This all started when my ssl certificate expired and I made a new one. I followed the SSL how-to in the documentation and updated the .pem files for the securemail daemons - is there somewhere in Horde that I should have copied the ssl certificate to as well?
All advice gratefully received!
David.
-
If it is the same error as I was getting then this should fix it.
Are you running MySQL 4.1.11?
I may have missed one step:
1) mysql
2) use mysql
3) UPDATE user SET Password=OLD_PASSWORD('your_Horde_password_here') WHERE User='horde';
4) FLUSH PRIVILIGES;
I think that maybe that is why you were being ask which database. Step two should take care of that.
Once done, try webmail again and it should work now.
Let me know if it works now.
PS: Do this from the command line not through phpmyadmin
Ed
-
I tried the fix as above and got the following:
[root@rusty e-smith]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1181 to server version: 3.23.56
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> UPDATE user SET Password=('password') WHERE User='horde';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> FLUSH PRIVILIGES;
ERROR 1064: You have an error in your SQL syntax near 'PRIVILIGES' at line 1
mysql> Aborted
I know I still have a lot to learn but could tell me what I'm doing wrong?
TIA,
Tony
-
I tried the fix as above and got the following:
[root@rusty e-smith]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1181 to server version: 3.23.56
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> UPDATE user SET Password=('password') WHERE User='horde';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> FLUSH PRIVILIGES;
ERROR 1064: You have an error in your SQL syntax near 'PRIVILIGES' at line 1
mysql> Aborted
I know I still have a lot to learn but could tell me what I'm doing wrong?
TIA,
Tony
You need to spell it correctly.
flush privileges;
-
Every 5 min I get this message sent to root@myserver. There are two other errors which I believe are related. Could someone point me the right direction to fix this. I have installed the Horde 3.0 script. It is installed on a 6.0.1 box. Thanks heaps.
Subject: Cron <root@gateway> /usr/bin/php /home/httpd/html/horde/kronolith/scripts/reminders.php
A fatal error has occurred
Unable to load the definition of Kronolith_Driver_.
Details have been logged for the administrator.
If I log into webmail as admin and go in administration, setup. The application status for Calendar (kronolith) displays this.
Missing configuration. You have to generate it now if you want to use this application.
If I log into webmail as a user and go into Organizing then Calendar this is displayed.
Some of Kronolith's configuration files are missing or unreadable conf.php
This is the main Kronolith configuration file. It contains paths and options for the Kronolith scripts. You need to login as an administrator and create the file with the web frontend under "Administration => Configuration". Create these files from their .dist versions in /home/httpd/html/horde/kronolith/config and change them according to your needs.
Steven,
I am just now seeing this. For some reason xoops stops sending me e-mails after a certain amount of time in an active forum. Don't know why. Your error from above looks to be because you either don't have a kronolith directory or the kronolith conf.php file wasn't expanded correctly. If you previously had kronolith installed with horde 2.0 there was a bug in the script that wouldn't expand the kronolith templates. I have fixed that so if you download the latest version of the script and run it, your kronolith stuff should be fixed, which will also fix the cron error. Sorry, this is so late, and I hope it helps you.
JB
-
You need to spell it correctly.
flush privileges;
Thanks. I looked at it for ages and obviously couldn't see the wood for the trees. :-)
Tony
Dyslexia rules KO
-
While attempting to use John Bennet's script install_horde30.sh, the procedure stopped dead at the PEAR installation leaving me with no webmail at all. I retried the script several times, with the same brick wall each time.
I then ran old_install_horde30.sh for the hell of it, and this seemed to run the PEAR install, but generated a stream of failure messages from that point on, and I finished up with the same complete loss of webmail.
Having nothing to lose, I re-ran install_horde30.sh at this point, and it ran through and appeared to work - I can now access and use all of the Horde suite, and access the administration from the server-manager panels as well.
But!!! I'm getting one of these every five minutes...
Failed loading /usr/lib/php4/php_accelerator_1.3.3r2.so: /usr/lib/php4/php_accelerator_1.3.3r2.so: cannot open shared object file: No such file or directory.
Why is the PHP accelerator involved at all? Does the script try to install it?
Any easy cure?
Ed Form
-
Ed,
Look at the notes in the install_horde30.sh and you will see that the new install no longer uses php-accelerator, but uses php-eaccelerator. So running the old_install tried to install things that are no longer in the downloads area. To fix this, look in /etc/e-smith/templates-custom/etc/php.ini and remove the lines for php-accelerator, expand /etc/php.ini, verify that the php-accelerator line is no longer present, then restart httpd-e-smith, and those messages should go away.
Also, I ran into an issue when I rebooted my server, where the old php-eaccelerator cache files wasn't rendering my mesages correctly. Only showing the headers.
I have fixed this by adding the following to /etc/rc.local
rm -f /var/cache/php-eaccelerator/*
That way, when I reboot my server, the stale cache entries are removed.
You can also verify that you are running php-eaccelerator by running php -v via the console
PHP 4.3.10 (cli) (built: Mar 1 2005 08:30:27)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
with eAccelerator v0.9.2, Copyright (c) 2004-2005 eAccelerator, by eAccelerator
Also, the pear lines seem to hang, because I send the output to /dev/null so you don't see it. Everytime, you run the script, it tries to do a pear ua (upgrade-all currently installed pear modules), depending on the last time you ran it, it could take a while. You can remove the /dev/null from the pear portion and see what it's doing at that time.
I'll update the script as time permits with the above change.
HTH,
JB
-
Thanaks for all that JB. I've sorted it out
You said...
Also, the pear lines seem to hang, because I send the output to /dev/null so you don't see it. Everytime, you run the script, it tries to do a pear ua (upgrade-all currently installed pear modules), depending on the last time you ran it, it could take a while. You can remove the /dev/null from the pear portion and see what it's doing at that time.
But my situation wasn't like that. When I ran the old script the PHP download could be seen flashing away like crazy on my router, but with the normal script absolutely nothing happened; the system just sat and looked at me - no download ever took place.
Ed Form
-
Ed,
I think I know what you are talking about. When the pear.php.net site is not available, then the pear portion just hangs until it times out. At least that is what I experienced tonight. Then the script continues, but when I try to open webmail, I get a blank page. So, being dependent on that website being availabe is an issue. I'll have to think and see if I can find a way around that. Suggestions welcomed.
JB
-
Since I've installed Horde3 on my SME6.5RC1 and upgraded PHP to php4.4.1 (Ergin's script), every 5 minutes I get this message:
Cron <root@server> /usr/bin/php /home/httpd/html/horde/kronolith/scripts/reminders.php
eAccelerator requires Zend Engine API version 20021010.
The Zend Engine API version 20050606 which is installed, is newer.
Contact eAccelerator at http://eaccelerator.sourceforge.net for a later version of eAccelerator.
There seems to be nothing wrong (I think), It's just not practical to clean up your administrator emailbox every day.
Is there a way to stop this reminder, or if I'm wrong (I wouldn't be surprised) what is wrong with Kronolith and is it fixable?
Freek
-
Disclaimer - With any PHP version greater than what the script installs by default, you are pretty much on your own. The script installs 4.3.10, The warning states this.
You can check your pear modules with pear list. This is what is on my server:
[root@myserver root]# pear list
Installed packages, channel pear.php.net:
=========================================
Package Version State
Archive_Tar 1.3.1 stable
Cache 1.5.5RC4 beta
Console_Getopt 1.2 stable
DB 1.7.6 stable
Date 1.4.6 stable
File 1.2.2 stable
HTTP 1.4.0 stable
HTTP_Request 1.3.0 stable
Log 1.9.2 stable
Mail 1.1.9 stable
Mail_Mime 1.3.1 stable
Net_SMTP 1.2.7 stable
Net_Socket 1.0.6 stable
Net_URL 1.0.14 stable
PEAR 1.4.5 stable
SOAP 0.9.1 beta
Services_Weather 1.3.2 stable
XML_Parser 1.2.7 stable
XML_RPC 1.4.4 stable
XML_Serializer 0.18.0 beta
XML_Util 1.1.1 stable
The reminders.php is for sending out Calendar reminders. It is in /etc/crontab. If you don't want that, then remove this file: /etc/e-smith/templates-custom/etc/crontab/80HordeReminders
Then expand-template /etc/cron.d, then restart cron
/etc/e-smith/events/actions/restart-crond.
You should look in your logs and see what error is being given. More than likely, it's because of a non-installed Pear module. Others have used that version and have had install additional pear modules. You should be able to search on horde php 4.4
GL,
JB
-
Hey all,
I just did a fresh intall of SME 7.opre1 and run yum update
All went well.
Now I want to upgrade to Horde 3.0, specificly I want Kronolith.
So I downloaded and ran the script install_horde30_sme7.sh
from http://mirror.contribs.org/smeserver/contribs//jbennett/
Ran the script and this is what I got:
Downloading files from http://mirror.contribs.org/smeserver/contribs/jbennett/horde30
Downloading and Installing user-manager
Preparing... ########################################### [100%]
1:perl-Unicode-String ########################################### [ 50%]
2:perl-Unicode-IMAPUtf7 ########################################### [100%]
Preparing... ########################################### [100%]
1:e-smith-userpanel ########################################### [100%]
WARNING in /etc/e-smith/templates//etc/httpd/admin-conf/httpd.conf/90e-smithAcce ss30user: *WARNING* esmith::config(/home/e-smith/accounts) called with old datab ase path. The following package needs to be updated: at /usr/lib/perl5/site_per l/esmith/config.pm line 374
esmith::config::TIEHASH('esmith::config', '/home/e-smith/accounts') call ed at /etc/e-smith/templates//etc/httpd/admin-conf/httpd.conf/90e-smithAccess30u ser line 9
eval 'E;
foreach $file (@files)
{
next unless ( defined ($panelshash{$file}) );
$OUT .= "\\n";
$OUT .= " <Files $file>\\n";
$OUT .= " AuthName \\"SME User manager\\"\\n";
$OUT .= " AuthType Basic\\n";
$OUT .= " AuthExternal pwauth\\n";
$OUT .= " require user admin$panelshash{$file}\\n";
$OUT .= " </Files>\\n";
}
$OUT .= "</Directory>\\n";
;' called at /usr/lib/perl5/vendor_perl/5.8.5/Text/Template.pm line 319
Text::Template::fill_in('Text::Template=HASH(0x8476c78)', 'HASH', 'ARRAY (0x82da10c)', 'PACKAGE', 'esmith::__TEMPLATE__::1', 'BROKEN', 'CODE(0x845e468)', 'UNTAINT', 1, ...) called at /usr/lib/perl5/vendor_perl/5.8.5/Text/Template.pm line 382
Text::Template::fill_in_file('/etc/e-smith/templates//etc/httpd/admin-co nf/httpd.conf/90e-s...', 'HASH', 'ARRAY(0x82da10c)', 'PACKAGE', 'esmith::__TEMPL ATE__::1', 'BROKEN', 'CODE(0x845e468)', 'UNTAINT', 1, ...) called at /usr/lib/pe rl5/site_perl/esmith/templates.pm line 528
esmith::templates::processTemplate('HASH(0x813df54)') called at /sbin/e- smith/expand-template line 45
WARNING: Template processing succeeded for //etc/httpd/admin-conf/httpd.conf: 1 fragment generated warnings
at /sbin/e-smith/expand-template line 45
Restarting httpd-admin [ OK ]
Restarting httpd-e-smith [ OK ]
This installation only supports SME 7.0.x - Exiting...
I don't get it. Can anyone help?
Thanks
Greg
-
Greg,
That script for sme7 is very, very old and not tested for pre1. There have been many changes to sme7, since I put that together. I will remove that file so no one else runs into this issue. Greg Swallow has been working on the horde rpms for 7.x. He has done a great job of putting the packages together complete with templates. If Greg happens to read this, maybe he won't mind me or him including the link to his WIP RPM's.
If you really still need to use Kronolith with sme7, then you should be able to pick out the items in the script that you need to use. But, you will have to make sure you modify it to download the appropriate tar.gz files.
I have not touched or looked at this for a long time.
John Bennett
-
OK, well thank you for the reply. But now my webmail is completely broken.
Is there anyway to undo what was done?
I am not a newbi, but then I am not that experianced at coding.
Could you give me an idea as to what was changed and how I could change it back?
Any help would be great. If anything I'll just wipe it and start it over with a fresh install. No biggie, good learning experiance.
By the way nice family :-)
Regards
Greg
-
OK I got my web mail back
I un installed the one RPM that did work and my mail came back.
:pint: Miller time.
I'll work on the Kronolith
Thanks
-
G'Day all
I have an annoying issue with one both upgraded to H3.0
Every time I modify an email setting and the email-update routine runs it bombs H3.0 so that I get a blank page instead of the login page; the H3.0 restore fixes the prob.
Anyone got some suggetions of what/where to focus on to resolve this issue.
Couldn't find anything useful in the logs
BTW - system is a fully yum'd 6.0.1 with lots of contribs installed (I do have the exclusions in yum.conf for the webmail modules)
Cheers
-
I would not recomment upgrading to Horde3 on SME 6 or 6.5. If you ever decide to upgrade to SME7, it will give you upgrade problems.
If I were you, I would upgrade to 7pre2 it is 99% production ready and it comes with Horde3.
Many contribs will give problems, SME delopers do state to use contribs at your own risk. Before upgrading to SME7, run contribs removal script:
http://no.longer.valid/phpwiki/index.php/SME6.0.1Contribs-RemovalScript
Once you upgrade to SME7, just follow steps in attached link to install kronolith.
http://forums.contribs.org/index.php?topic=28690.0
-
This box is a fresh build of 6.0.1 and if I want SME7 on it it will be rebuilt from scratch - coming from the Windows world my philosophy is to always do a clean build instead of an upgrade. The extra work upfront pays off in the long run with a more reliable and robust system.
Now about that prob .....
-
I would not recomment upgrading to Horde3 on SME 6 or 6.5. If you ever decide to upgrade to SME7, it will give you upgrade problems.
I have opened bug 760 to deal with this and have uploaded a removal script. Link to bug report, http://bugs.contribs.org/show_bug.cgi?id=760. Link to other forum post, http://forums.contribs.org/index.php?topic=30680.msg128487#msg128487
If I were you, I would upgrade to 7pre2 it is 99% production ready and it comes with Horde3.
Yes, it comes with Horde 3, but currently you get only horde/imp/turba/ingo. There are WIP RPM's available from Greg Swallow for Kronolith/Nag/Mnemo/Gollem/Mimp
John Bennett
-
That is why in my post I have provided a link to Gregs post where he explains how to install Kronolth.
If you know a link to rpm's and "how-to" page for Nag/Mnemo/Gollem/Mimp, I would greatly appreciate it.
-
That is why in my post I have provided a link to Gregs post where he explains how to install Kronolth.
If you know a link to rpm's and "how-to" page for Nag/Mnemo/Gollem/Mimp, I would greatly appreciate it.
I am working on those, building off of Greg's start. It will take some time to learn the SME way. Currently the RPM modules are built, but still need some work in the areas of automatically creating the SQL tables, probably some minor tweaks. The smeserver-xxx specific modules that create the templates, need to be created.
JB
-
That is why in my post I have provided a link to Gregs post where he explains how to install Kronolth.
If you know a link to rpm's and "how-to" page for Nag/Mnemo/Gollem/Mimp, I would greatly appreciate it.
I've just uploaded updated SME 7 RPM's for Kronolith, Nag, Mnemo, and Gollem to http://mirror.contribs.org/smeserver/contribs//jbennett/sme7/
Thanks goes to Greg Swallow for getting these started.
There were some older ones in these directories, so give the mirrors time to sync.
Here are some additional details you need to know to do.
Grant the horde user additional rights
From the console or ssh console
mysql
GRANT SELECT , INSERT , UPDATE , DELETE , CREATE ON horde . * TO 'horde'@'localhost';
flush privileges;
exit
Modify gollem default template
cd /etc/e-smith/templates/home/httpd/html/horde/config/registry.php
pico -w 620AppRegistryGollem
change gollem to active
change gollem-block inactive
signal-event post-upgrade ; signal-event reboot
For gollem to work
server-manager/remote access
ftp settings
Allow access only from local networks
Accept password only from local networks
gollem
Defaults to users home dir, but users can click on root and see other users dir can't currently find a way to not allow access to root
kronolith reminders won't work because of php version included in SME7/CentOS 4.2. It's the CGI version instead of the CLI version.
JB
-
Anyone that has used the horde script on their 6.x box, should probably run the lastest version to update to horde 3.0.10. I say this because I subscribe to the horde list and people are reporting being hacked that are not running 3.0.10.
JB
-
The script works great. One question though:
Does anyone have the correct rpms that will install wvhtml?
This message appears when I try to open a .doc attachment:
The program used to view this data type (/usr/bin/wvHtml) was not found on the system.
I found the rpm here (http://ftp://ftp.pbone.net/mirror/apt.unl.edu/apt/fedora/redhat/7/RPMS.stable/wv-1.0.0-0.fdr.0.rh73.i386.rpm). Installed nicely and seems to work.
Jesper
-
Hi
Are you plan to write one of you magic SH scripts to auto this for us ??
Paul
-
I'm able to install all the rpms for the new horde stuff, on an SME RC3 server. That works fine. My problem is any calendar, notepad, or task list I create to share, I am unable to give any permissions to it. I select the calendar, the permissions button appears under it, but I never get to the permission popup window. At one time earlier in the year I had this working on an SME server b3, b5 or b7, one of the earlier beta versions. Any insights would be appreciated.
-
http://forums.contribs.org/index.php?topic=30680.0
I'm about to test this bug fix.
I'll come back later.