Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Tips/Tricks/Mods

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 16th December 2010, 04:21
ByteMe Networking ByteMe Networking is offline
Junior Member
 
Join Date: Dec 2010
Location: Virginia Beach VA.
Posts: 24
Thanks: 7
Thanked 7 Times in 3 Posts
Post Horde Groupware Webmail Edition

I made this guide to help with the installation of Horde Groupware Webmail Edition. I found it was quite difficult when setting this up at first as I was trying to install the full version of Horde and did not need it. This is not the full version of Horde but the Webmail edition which is all I needed for my clients that have used Horde in the past. EX. Ones moving from cAnal.

Note: I am not an expert by any means. This is only what has worked for me. The information listed below is to be used at your own risk. If you have any questions about this post or helpful insight that is not listed please post.

Prerequisite:
First prerequisite to this guide of course is to have ISPConfig up and running. The second part is to have followed the directions listed at the below link on setting up your server to have multiple webmail clients. You can find the directions here: "Webmail Alias not working"

Once you have configured your server to have multiple webmail clients we can get started with setting up Horde.

Step 1: Create a User and Database for your new Horde install
Note: You can use an existing account on your server to add a database and user. I will not cover this as it should be basic knowledge.
Note 2: If you have a primary website this would be the place to create one.

Step 2: Create folder where Horde installs to
From root type:
Code:
# mkdir /usr/share/horde
Step 3: If you have not already done so using "Webmail Alias not working" create a symlink to that folder
Code:
# ln -s /usr/share/horde/ /var/www/webmail/horde
Step 4: Download and extract Horde Groupware Webmail Edition (I'm sure there are better ways to do this but I do not profess to be an expert)
Code:
# cd /usr/share/horde
# wget ftp://ftp.horde.org/pub/horde-webmail/horde-webmail-latest.tar.gz
# tar -zxvpf horde-webmail-latest.tar.gz
# cp -r horde-webmail-1.2.9/* /var/www/webmail/horde
Step 5: Remove unneeded files we just downloaded and moved
Code:
# rm -rf horde-webmail-1.2.9/ horde-webmail-latest.tar.gz
Step 6: Run the install script
Code:
# ./scripts/setup.php
Step 6a: Install options
Here I typed /webmail/horde because that is where I am calling it from in a browser but as you will see later the script ignores this.
Code:
What is the web root path on your web server for this installation, i.e. the 
path of the address you use to access Horde Groupware Webmail Edition in your 
browser? [/horde] /webmail/horde
Step 6b: Install tables
Here I choose 1 to Configure database settings
Code:
Horde Groupware Webmail Edition Configuration Menu
    (0) Exit
    (1) Configure database settings
    (2) Create database or tables
    (3) Configure administrator settings
    (4) Update PEAR for a new or changed location
    (5) Update from an older Horde Groupware Webmail Edition version

Type your choice: 1
Step 6c: What Database to use
Here I have chosen mysql
Note: If you have followed the perfect setup guides then you more than likely would have chosen MySQL for your databases
Code:
What database backend should we use? [false]
    (false) [None]
    (dbase) dBase
    (ibase) Firebird/InterBase
    (fbsql) Frontbase
    (ifx) Informix
    (msql) mSQL
    (mssql) MS SQL Server
    (mysql) MySQL
    (mysqli) MySQL (mysqli)
    (oci8) Oracle
    (odbc) ODBC
    (pgsql) PostgreSQL
    (sqlite) SQLite
    (sybase) Sybase

Type your choice: mysql
Step 6d: Persistent connections
Here I choose no 0
Code:
Request persistent connections? [0]
    (1) Yes
    (0) No

Type your choice: 0
Step 6e: Config your database user
Fill in your_dbuser with your real database username
Code:
Username to connect to the database as* [] your_dbuser
Step 6f: Config your database password
Fill in your_dbpass with your real database password
Code:
Password to connect with [] your_dbpass
Step 6g: Connection
Here I choose tcp because most applications just want to know a host
Code:
How should we connect to the database? [unix]
    (unix) UNIX Sockets
    (tcp) TCP/IP

Type your choice: tcp
Step 6h: Host or Server
Put in localhost
Code:
Database server/host* [] localhost
Step 6i: Port for MySQL
Here just press enter for the default port of 3306
Code:
Port the DB is running on, if non-standard [3306]
Step 6j: What database to use
Fill in your_db with your real database name you created
Code:
Database name to use* [] your_db
Step 6k: Pick charset
Just use the defaults unless you need something different. Press enter
Code:
Internally used charset* [utf-8]
Step 6l: Use SSL or not
I choose 0 for no to keep things easy
Code:
Use SSL to connect to the server? [0]
    (1) Yes
    (0) No

Type your choice: 0
Step 6m: Certification Authority to use for SSL connections
Just press enter
Code:
Certification Authority to use for SSL connections []
Step 6n: Split reads
I choose false for this
Code:
Split reads to a different server? [false]
    (false) Disabled
    (true) Enabled

Type your choice: false
After that you should get this message:
Here I choose option 2 to now write our tables to our database
Code:
Writing main configuration file
Done configuring database settings.


Horde Groupware Webmail Edition Configuration Menu
    (0) Exit
    (1) Configure database settings
    (2) Create database or tables
    (3) Configure administrator settings
    (4) Update PEAR for a new or changed location
    (5) Update from an older Horde Groupware Webmail Edition version

Type your choice: 2
Step 7: Write tables to database
Here I choose n for no to create a database
Code:
Should we create the database for you? If yes, you need to provide a database
user that has permissions to create new databases on your system. If no, we
will only create the database tables for you. [y]
    (y) Yes
    (n) No

Type your choice: n
Step 7a: Provide database user again
Here you will want to type in your_dbuser from step 6e
Code:
Database superuser for creating the tables if necessary for your database system: your_dbuser
Step 7b: Provide the database user password again
Here you will want to type in your_dbpass from step 6f
Code:
Specify a password for the database user: your_dbpass
Step 8: After the above it should successfully write the tables
You should receive messages like this
Code:
Loading database module...
Creating database...
[   OK   ] Successfully created the global tables.
[   OK   ] Successfully created the tables for Mail (imp).
[   OK   ] Successfully created the tables for Filters (ingo).
[   OK   ] Successfully created the tables for Address Book (turba).
[   OK   ] Successfully created the tables for Calendar (kronolith).
[   OK   ] Successfully created the tables for Tasks (nag).
[   OK   ] Successfully created the tables for Notes (mnemo).
Step 9: You will be asked one last question for the tables
Here I choose n for no to keep things easy
Code:
Should we build the database with METAR weather stations now? This is necessary if you want to display METAR weather information. Building the database requires a network connection. [y]
    (y) Yes
    (n) No

Type your choice: n
Then you will receive a message of completion:
Code:
Done creating tables.
Step 10: Finish the install
Choose 0 to exit
Code:
Horde Groupware Webmail Edition Configuration Menu
    (0) Exit
    (1) Configure database settings
    (2) Create database or tables
    (3) Configure administrator settings
    (4) Update PEAR for a new or changed location
    (5) Update from an older Horde Groupware Webmail Edition version

Type your choice: 0
Thank you for using Horde Groupware Webmail Edition!
Now if everything went as it should you should be able to navigate to http://your.tld/webmail/horde

There you should be prompted with a login page for Horde.

Note: If you visit http://your.tld/webmail/horde and it redirects you to http://your.tld/login.php and will not load,
you will have to edit the /usr/share/horde/config/registry.php file.

To do this:
Code:
# nano /usr/share/horde/config/registry.php
Search for this line:
Code:
'webroot' => _detect_webroot(),
And change it to this:
Code:
'webroot' => '/webmail/horde',
Once you have saved the changes try your site again http://your.tld/webmail/horde. It should now load correctly.

With that, I hope this has helped. If you have any questions I would be happy to try and assist. Or if I have missed anything please let me know.

Thanks for the read,
Casey

Last edited by ByteMe Networking; 16th December 2010 at 19:18. Reason: Forgot one part at the end.
Reply With Quote
The Following 3 Users Say Thank You to ByteMe Networking For This Useful Post:
falko (16th December 2010), Horfic (16th December 2010), till (16th December 2010)
Sponsored Links
  #2  
Old 31st January 2011, 22:48
findafriend findafriend is offline
Member
 
Join Date: May 2007
Posts: 49
Thanks: 10
Thanked 3 Times in 3 Posts
Default

Hi

I have tried the above, but horde will not login, it keeps reloading on the frontpage.
You can find it here :

http://horde.easywebhost.dk

When I use a user, I know that works e.g. it just reloads and awaits new login.
But when i use wrong login credentials it gives me an error.
I can't get it to login into horde.

Help on installing it will be appreciated.

BR

Mogens
Reply With Quote
  #3  
Old 31st January 2011, 23:30
ByteMe Networking ByteMe Networking is offline
Junior Member
 
Join Date: Dec 2010
Location: Virginia Beach VA.
Posts: 24
Thanks: 7
Thanked 7 Times in 3 Posts
Default

Hello findafriend,

Double check the /usr/share/horde/config/registry.php and make sure you have the correct path set for 'webroot' =>

When I first installed horde it would not automatically save the correct path settings that you input in the first question of the install script.

Edit the registry.php file and search for:
Code:
'webroot' => _detect_webroot(),
If you see the above then you need to set the full path to your horde install folder.

For example I installed horde to "/usr/share/horde/" and created a symlink to "/var/www/webmail/horde" so my settings look like this:
Code:
'webroot' => '/webmail/horde',
If that does not work shoot me a PM with a test account so I can see exactly what it is doing when logging in.

Hope that helps,
Casey
__________________
Have hope.
Take care of your local Veterans and Community.
http://vbelks.org
Reply With Quote
  #4  
Old 31st January 2011, 23:32
findafriend findafriend is offline
Member
 
Join Date: May 2007
Posts: 49
Thanks: 10
Thanked 3 Times in 3 Posts
Default

I have tried that solution without luck
Reply With Quote
  #5  
Old 31st January 2011, 23:51
ByteMe Networking ByteMe Networking is offline
Junior Member
 
Join Date: Dec 2010
Location: Virginia Beach VA.
Posts: 24
Thanks: 7
Thanked 7 Times in 3 Posts
Default

Hmmm,

I noticed you are using a subdomain for horde access and I am wondering if maybe that has something to do with it. Did you install horde to the usr/share folder and then symlink it to your subdomain or did you just set the path of the subdomain to point to the horde folder? Or did you create a new subdomain site and install horde to the new sub site in the document root?

Any chance you can provide a test email account? Not quite sure as to why it would just refresh the page instead of logging in but would help to be able to replicate the problem on this end so I can get a better idea of where to go next in troubleshooting.

Thanks,
Casey
__________________
Have hope.
Take care of your local Veterans and Community.
http://vbelks.org
Reply With Quote
  #6  
Old 1st February 2011, 17:49
findafriend findafriend is offline
Member
 
Join Date: May 2007
Posts: 49
Thanks: 10
Thanked 3 Times in 3 Posts
Default

Quote:
Originally Posted by ByteMe Networking View Post
Hmmm,

Did you install horde to the usr/share folder and then symlink it to your subdomain or did you just set the path of the subdomain to point to the horde folder? Or did you create a new subdomain site and install horde to the new sub site in the document root?
Tried both solutions, but didn't work

Quote:
Originally Posted by ByteMe Networking View Post
Any chance you can provide a test email account? Not quite sure as to why it would just refresh the page instead of logging in but would help to be able to replicate the problem on this end so I can get a better idea of where to go next in troubleshooting.
Just an email test account ?
Made inside from ispconfig the normal way i presume ?

BR

Mogens
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Horde Webmail login too slow :( mj40 Server Operation 1 21st September 2010 19:37
Mail Server Setup With Exim, MySQL, Cyrus-Imapd, Horde Webmail On Centos 5.1 - issue c0mrade HOWTO-Related Questions 25 19th April 2009 19:11
[need advice] Postfix/Dovecot (Virtual domains, users) with horde groupware webmail? MAO Installation/Configuration 4 26th August 2008 10:26
[need advice] Postfix/Dovecot (Virtual domains, users) with horde groupware webmail? MAO Server Operation 1 25th August 2008 09:48
Support for other Webmail programs (HORDE) pontifex Feature Requests 14 1st December 2005 17:57


All times are GMT +2. The time now is 04:58.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.