From LedHed's Wiki
Jump to: navigation, search
(Database Setup)
(Database Setup)
Line 51: Line 51:
 
mysql> quit
 
mysql> quit
  
'''Import RoundCube Tables'''<br>
+
'''Import RoundCube Database Tables'''<br>
 
mysql -u root -p roundcube < /var/www/roundcube/SQL/mysql.initial.sql<br>
 
mysql -u root -p roundcube < /var/www/roundcube/SQL/mysql.initial.sql<br>
 
''(When prompted for a password enter the root password)''
 
''(When prompted for a password enter the root password)''

Revision as of 06:43, 29 July 2006

NOTE: This HowTo assumes you are using a RedHat or Fedora based distro, but most of this info can be applied to any Unix based Operating System.



Download

  • Download the latest version of Roundcube

wget http://easynews.dl.sourceforge.net/sourceforge/roundcubemail/roundcubemail-0.1beta.tar.gz

If the Above link is broken or out of date, get the latest version Here


UnTar

tar -xvzf roundcubemail-0.1beta.tar.gz


Move

mv roundcubemail-0.1beta /var/www/roundcube

Read the Documentation

cd /var/www/roundcube less README (press q to quit)

less INSTALL (press q to quit)

Change Ownership & Premissions

chown -R root.root roundcube/ cd roundbube/ chmod 755 log/ temp/


Database Setup

(This Assumes you already have MySQL installed)


Creating the RoundCube Database

  • Login as root

mysql -u root -p (When prompted for a password enter the root password)

mysql> CREATE DATABASE `roundcube` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


Create RoundCube User and Grant Privileges
mysql> GRANT ALL PRIVILEGES ON roundcube.* TO roundcube@localhost IDENTIFIED BY 'Your-Password-Here';
(where 'Your-Password-Here' is the password you want for the roundcube user)

Exit MySQL
mysql> quit

Import RoundCube Database Tables
mysql -u root -p roundcube < /var/www/roundcube/SQL/mysql.initial.sql
(When prompted for a password enter the root password)