Horde,Squirrell and U'Mail

fusionictnl

Verified User
Joined
Jun 22, 2004
Messages
1,052
Location
Netherlands
DA Webmail Plugin Expirimental in this STAGE!

Webmail DA Plugin v1.0 07-OKT-2004 (GMT+1)

Use the above url in your DA Plugin Management to install (Admin-Level).

This will move/unlink your /var/www/html/squirrelmail dir to squirrelmail_old and webmail to webmail_old.

After that you get 3 options from within the webmail through the Contol panel like this

The domain/webmail is standard setup for Horde. If you want to change it, change the symbolic link /var/www/html/webmail

to /var/www/html/squirrelmail/umail (UebiMiau)
to /var/www/html/squirrelmail/squirrelmail (Squirrelmail)
to /var/www/html/squirrelmail/squirrelmail (Horde)

For settings issues you have to create/set mysql configuration manually:

in the /var/www/html/squirrelmail/horde/config/horde.php

Alter these lines:

$conf['prefs']['params']['password'] = 'yourpassword';
$conf['prefs']['params']['database'] = 'yourdatabase';

After that's done and you've created a database to put the settings in, create the tables:

Code:
CREATE TABLE `horde_prefs` (
  `pref_uid` varchar(255) NOT NULL default '',
  `pref_scope` varchar(16) NOT NULL default '',
  `pref_name` varchar(32) NOT NULL default '',
  `pref_value` text,
  PRIMARY KEY  (`pref_uid`,`pref_scope`,`pref_name`)
) TYPE=MyISAM;

CREATE TABLE `nag_tasks` (
  `task_owner` varchar(255) NOT NULL default '',
  `task_id` int(11) NOT NULL default '0',
  `task_name` varchar(64) NOT NULL default '',
  `task_desc` text,
  `task_modified` int(11) NOT NULL default '0',
  `task_due` int(11) default NULL,
  `task_priority` int(11) NOT NULL default '0',
  `task_category` int(11) NOT NULL default '0',
  `task_completed` smallint(6) NOT NULL default '0',
  `task_private` smallint(6) NOT NULL default '1',
  PRIMARY KEY  (`task_owner`,`task_id`)
) TYPE=MyISAM;

Good luck!


Let me know how it goes!
 
Last edited:
Thanks. I was hoping it was different :) Any chance this could be modified? I wouldn't want to offer three different webmail systems.

Does the horde in the plugin have full functionality like Kronolith, etc?
 
Thanks. I was hoping it was different Any chance this could be modified? I wouldn't want to offer three different webmail systems.

Does the horde in the plugin have full functionality like Kronolith, etc?

The three webmail options are only offered when clicking on "webmail" IN the control panel. If you go to http://domain/webmail you will see Horde (Standard, can be changed)

Kronolith is not implemented in this version. In the Final the administrator could choose wich modules will be activated and setup the databases automaticaly.

This is an experimental version, just to see if it works. Horde is normaly a pain in the *ss to install. :p
 
fusionictnl said:
The three webmail options are only offered when clicking on "webmail" IN the control panel. If you go to http://domain/webmail you will see Horde (Standard, can be changed)

Kronolith is not implemented in this version. In the Final the administrator could choose wich modules will be activated and setup the databases automaticaly.

This is an experimental version, just to see if it works. Horde is normaly a pain in the *ss to install. :p
This is truly brilliant. Damn I swear you should be on the DA payroll! You have been answering more questions for DA support then even John I think. Well... You know what I mean. GOOD WORK!

I love Horde. In fact it might just be worth devoting the whole plugin to Horde.:confused:

Also what OS are you using? I'm using FreeBSD 4.8 and FreeBSD 5.2.1. Do you think that this plugin will work with all platforms or ?

thanks!
 
On a payroll is a whole other thing. They work on the core and I'm just implementing plugins for my own customers and for people of the DA community.

Also what OS are you using? I'm using FreeBSD 4.8 and FreeBSD 5.2.1. Do you think that this plugin will work with all platforms or ?

I use DA with Fedora Core 1.

Is it supported on all platforms ? I don't know it's just php scripts so it shouldn't have anything to do with the distro.

This is an experimental release, because I've tested it on 3 machines. 1 Fedora C1 (productional), 1 RedHat 9 (productional on intranet) and 1 FreeBSD 5.1 (Testbed on intranet).

Only the Fedora C1 is carrying DA, so the others where just for script testing and for testing standard functions that are within each distro.

So please just try it. It shouldn't harm you're current settings except webmail offcourse :p
 
Hello,

It seems like it doesn't work on FreeBSD 4.10.
Plugin is installed and activaded, but here is the list of files:


server# cd squirrelmail
server# ls
AUTHORS ReleaseNotes contrib images po
COPYING UPGRADE data include src
ChangeLog class doc index.php themes
INSTALL config functions locale
README configure help plugins

I will take a look at this in weekend. But hopefully someone will figure this out sooner ;-)

kamsel
 
The list of files you specify is the original squirrelmail. The files weren't installed @ all ;)

The plugin installs the mail clients in /var/www/html/squirrellmail

before it does that it mv (renames/moves/) the original to squirellmail_old, but that didn't happen with you're machine ;)

Try reinstalling the plugin OR check if the dirs I described here exists on your machine on that location.
 
Love the idea

I love the idea of this plugin, however, it doesn't seem to work.
1. /squirrelmail doesn't work, nor does the link inside the control panel

2. The directories mentioned with squirrel, horde, and neo did not get isntalled.

Are there other sites that may be down?
 
Could you enter the following cmd in SSH: ls -la /var/www/html/

Give the list of files.

Next:

cd /usr/local/directadmin/plugins/webmail/scripts/
export DOCUMENT_ROOT="/usr/local/directadmin/plugins/webmail/"

./install.sh

Give me the output.

Thx!
 
server# ls -la /var/www/html/
total 2076
drwxr-xr-x 7 root wheel 1536 Oct 16 12:32 .
drwxr-xr-x 5 root wheel 512 Aug 15 23:56 ..
-rw-r--r-- 1 501 staff 2326 Jul 3 1996 apache_pb.gif
-rw-r--r-- 1 root wheel 2673 Aug 15 23:56 index.html
drwxr-xr-x 8 root wheel 3072 Aug 25 16:08 manual
-rw-r--r-- 1 root wheel 2065448 Oct 12 13:45 phpMyAdmin-2.6.0-pl2.tar.gz
drwxr-xr-x 7 admin admin 2560 Oct 16 11:52 phpmyadmin
-rwxr-xr-x 1 root wheel 65 Aug 15 23:54 redirect.php
drwxr-xr-x 16 root wheel 512 Oct 1 2003 squirrelmail
drwxr-xr-x 16 root wheel 512 Jun 3 02:06 squirrelmail-1.4.3a
lrwxr-xr-x 1 root wheel 32 Oct 16 12:28 webmail -> /var/www/html/squirrelmail/horde
drwxr-xr-x 9 root wheel 1024 Oct 16 12:28 webmail_old
server# cd /usr/local/directadmin/plugins/webmail/scripts/
server# export DOCUMENT_ROOT="/usr/local/directadmin/plugins/webmail/"
export: Command not found.
server# ./install.sh
./install.sh: //this: not found
chmod: user/*: No such file or directory
chown: user/*: No such file or directory
chmod: reseller/*: No such file or directory
chown: reseller/*: No such file or directory
chmod: admin/*: No such file or directory
chown: admin/*: No such file or directory
chmod: /hooks/*: No such file or directory
mv: rename /hooks/squirrelmail to /var/www/html/squirrelmail_old: No such file or directory
unlink: /var/www/html/squirrelmail: is a directory
cp: /hooks/squirrelmail: No such file or directory
unlink: /var/www/html/webmail: No such file or directory
Everything is installed!
 
Last edited:
./install.sh
./install.sh: line 3: //this: No such file or directory
chmod: failed to get attributes of `user/*': No such file or directory
chown: failed to get attributes of `user/*': No such file or directory
chmod: failed to get attributes of `reseller/*': No such file or directory
chown: failed to get attributes of `reseller/*': No such file or directory
chmod: failed to get attributes of `admin/*': No such file or directory
chown: failed to get attributes of `admin/*': No such file or directory
unlink: cannot unlink `/var/www/html/squirrelmail': No such file or directory
cp: cannot stat `/usr/local/directadmin/plugins/webmail//hooks/squirrelmail': No such file or directory
mv: cannot overwrite directory `/var/www/html/webmail_old/webmail'
unlink: cannot unlink `/var/www/html/webmail': Is a directory
ln: `/var/www/html/webmail/horde': File exists
Everything is installed!
 
welch said:
./install.sh
./install.sh: line 3: //this: No such file or directory
chmod: failed to get attributes of `user/*': No such file or directory
chown: failed to get attributes of `user/*': No such file or directory
chmod: failed to get attributes of `reseller/*': No such file or directory
chown: failed to get attributes of `reseller/*': No such file or directory
chmod: failed to get attributes of `admin/*': No such file or directory
chown: failed to get attributes of `admin/*': No such file or directory
unlink: cannot unlink `/var/www/html/squirrelmail': No such file or directory
cp: cannot stat `/usr/local/directadmin/plugins/webmail//hooks/squirrelmail': No such file or directory
mv: cannot overwrite directory `/var/www/html/webmail_old/webmail'
unlink: cannot unlink `/var/www/html/webmail': Is a directory
ln: `/var/www/html/webmail/horde': File exists
Everything is installed!

cp: cannot stat `/usr/local/directadmin/plugins/webmail//hooks/squirrelmail': No such file or directory

This line indicates that you're missing the the webmail clients delivered with the plugin. This dir MUST be there. If it is not, there went something wrong with downloading/untarring the plugin with DA's plugin manager. Please check this and try to re-install it.

Kamsel

Could you please check if the directory I specified above exists on you're machine ? If not try redownloading the plugin again and check if it DOES exists, before hitting install ;)
 
I wanted to play with the plugin on a FBSD 5.2.1 box. Just wanted to let you know it did not work so well for me.

Here is the output of the install.sh script

Code:
./install.sh: //this: not found
chmod: user/*: No such file or directory
chown: user/*: No such file or directory
chmod: reseller/*: No such file or directory
chown: reseller/*: No such file or directory
chmod: admin/*: No such file or directory
chown: admin/*: No such file or directory
chmod: /hooks/*: No such file or directory
mv: rename /hooks/squirrelmail to /var/www/html/squirrelmail_old: No such file or directory
unlink: /var/www/html/squirrelmail: is a directory
cp: /hooks/squirrelmail: No such file or directory
unlink: /var/www/html/webmail: No such file or directory
Everything is installed!

Check the ..../html directory

Code:
drwxr-xr-x   6 root  wheel  1536 Oct 19 14:55 .
drwxr-xr-x   5 root  wheel   512 Aug  4 19:32 ..
-rw-r--r--   1 501   staff  2326 Jul  3  1996 apache_pb.gif
-rw-r--r--   1 root  wheel  2673 Aug  4 19:32 index.html
-rw-r--r--   1 501   staff  1884 Jun 26  2001 index.html.ca
-rw-r--r--   1 501   staff  1583 Jun 27  2001 index.html.cz
-rw-r--r--   1 501   staff  2274 Sep 17  2001 index.html.de
-rw-r--r--   1 501   staff  1557 Jun 27  2001 index.html.dk
-rw-r--r--   1 501   staff  1877 Jun 27  2001 index.html.ee
-rw-r--r--   1 501   staff  1677 Jun 27  2001 index.html.el
-rw-r--r--   1 root  staff  2673 Aug  4 19:31 index.html.en
-rw-r--r--   1 501   staff  1799 Jun 27  2001 index.html.es
-rw-r--r--   1 501   staff  1525 Jun 27  2001 index.html.fr
-rw-r--r--   1 501   staff  3706 Jun 27  2001 index.html.he.iso8859-8
-rw-r--r--   1 501   staff  2585 Feb  2  2004 index.html.hu
-rw-r--r--   1 501   staff  1847 Nov  7  2001 index.html.it
-rw-r--r--   1 501   staff  1799 Dec 14  2001 index.html.ja.jis
-rw-r--r--   1 501   staff  1333 Jun 28  2001 index.html.kr.iso-kr
-rw-r--r--   1 501   staff  1896 May 21  2002 index.html.lb.utf8
-rw-r--r--   1 501   staff  2007 Jun 28  2001 index.html.nl
-rw-r--r--   1 501   staff  1534 Sep  6  2001 index.html.nn
-rw-r--r--   1 501   staff  1526 Jun 28  2001 index.html.no
-rw-r--r--   1 501   staff  1497 Jun 28  2001 index.html.po.iso-pl
-rw-r--r--   1 501   staff  1842 Jun 28  2001 index.html.pt
-rw-r--r--   1 501   staff  2035 Mar 22  2001 index.html.pt-br
-rw-r--r--   1 501   staff  1591 Jun 28  2001 index.html.ru.cp-1251
-rw-r--r--   1 501   staff  1585 Jun 28  2001 index.html.ru.cp866
-rw-r--r--   1 501   staff  1589 Jun 28  2001 index.html.ru.iso-ru
-rw-r--r--   1 501   staff  1585 Jun 28  2001 index.html.ru.koi8-r
-rw-r--r--   1 501   staff  3134 Jan 27  2001 index.html.ru.ucs2
-rw-r--r--   1 501   staff  6268 Jan 27  2001 index.html.ru.ucs4
-rw-r--r--   1 501   staff  2318 Jun 28  2001 index.html.ru.utf8
-rw-r--r--   1 501   staff  1700 Jun 28  2001 index.html.se
-rw-r--r--   1 501   staff  1062 May 13  2003 index.html.zh-tw.big5
drwxr-xr-x   8 root  wheel  3072 Aug  4 19:32 manual
lrwxr-xr-x   1 root  wheel    16 Aug  4 19:28 phpMyAdmin -> phpMyAdmin-2.5.6
drwxr-xr-x   7 root  wheel  2560 Aug  4 19:28 phpMyAdmin-2.5.6
-rwxr-xr-x   1 root  wheel    65 Aug  4 19:28 redirect.php
drwxr-xr-x  16 root  wheel   512 Sep 23 12:58 squirrelmail
lrwxr-xr-x   1 root  wheel    32 Oct 19 14:55 webmail -> /var/www/html/squirrelmail/horde
drwxr-xr-x   9 root  wheel  1024 Oct 19 14:55 webmail_old
 
I seem to be missing ALOT of requirments for horde, is there another step i should have taken:


Horde Versions
Horde: 2.2.5
IMP: 3.2.4 (run IMP tests)
Nag: 1.1.1
PHP Version
View phpinfo() screen
PHP Version: 4.3.8
PHP Major Version: 4.3
PHP Minor Version: 8
PHP Version Classification: release
You are running a supported version of PHP.
PHP Module Capabilities
DOM XML Support: No
FTP Support: Yes
Gettext Support: Yes
IMAP Support: No
LDAP Support: No
MCAL Support: No
Mcrypt Support: Yes
MySQL Support: Yes
PostgreSQL Support: No
XML Support: Yes
Miscellaneous PHP Settings
magic_quotes_runtime disabled: Yes
file_uploads enabled: Yes
safe_mode disabled: Yes
trans_sid disabled: Yes
PHP Sessions
Session counter: 3
To unregister the session: click here
PEAR
PEAR - Yes
Recent PEAR - Yes
Mail - Yes
Log - No
Make sure you are using a version of PEAR which includes the Log classes, or that you have installed the Log package seperately. See the INSTALL file for instructions on installing Log.
DB - Yes
Net_Socket - Yes
Date - No
Horde requires the Date_Calc class for Kronolith to calculate dates.
HTML_Common/HTML_Select - No
Horde requires the HTML_Common and HTML_Select classes only for Kronolith 1.0 to display forms correctly.
 
welch

Standardly DA's PHP Includes the right set of mod's for horde. Custom compiled php's probaly don't include them for RH/FC machines. For FreeBSD I don't know, because I don't have any testing machine available now.

existenz

You can't just execute ./install.sh if you haven't have the Enviroment variable DOCUMENT_ROOT set. For this you'll need to set this to /usr/local/directadmin/plugins/webmail/

On RH/Fedora the command is: 'export'. This one doesn't seem to be working on FreeBSD, so you'll have to figure out yourself.
 
Back
Top