Postinstall for SVN version

postinstall-en.txt (text/plain), 1.63 KB, created by Arthur Zapparoli on 2006-06-30 12:29:10 UTC

Almost done!

1. Setup the database tables:

  For MySQL:

    New install:
      Create the database:
        mysql -u root -p create DB_NAME

      Create the needed tables:
        mysql -u root -p < /usr/share/webapps/roundcube-svn/VERSION/sqlscripts/mysql/VERSION_create.sql DB_NAME

      Create roundcube_webmail MySQL user:
        mysql -u root -p -e "GRANT ALL ON DB_NAME.* TO DB_USER@localhost IDENTIFIED BY 'DB_PASSWORD';FLUSH PRIVILEGES;"


    Update from 0.1-20051007:
      mysql -u root -p < /usr/share/webapps/roundcube-svn/VERSION/sqlscripts/mysql/0.1-20051007_to_VERSION.sql DB_NAME


  For SQLite:
    
    New install:
      sqlite -init /usr/share/webapps/roundcube-svn/VERSION/sqlscripts/sqlite/VERSION_create.sql DB_NAME


  For PostgreSQL:

    New install:
      Create roundcube_webmail PostgreSQL user::
        createuser DB_USER

      Create the database:
        createdb -O DB_USER DB_NAME

      Create the needed tables:
        psql DB_NAME
          DB_NAME =# ALTER USER DB_USER WITH PASSWORD 'DB_PASSWORD';
          DB_NAME =# \c - DB_NAME
          DB_NAME => \i /usr/share/webapps/roundcube-svn/VERSION/sqlscripts/pqsql/VERSION_create.sql


2. Edit the files: db.inc.php and main.inc.php in the config sub-directory of
the roundcube_webmail installation. In order to connect to the database you'll
need to change the following line in db.inc.php to look something like this:

For MySQL:
  $rcmail_config['db_dsnw'] = 'mysql://roundcube:roundcube@localhost/roundcube';

For SQLite:
  $rcmail_config['db_dsnw'] = 'sqlite://./sqlite.db?mode=0646';


3. Finally, point your browser to http://${VHOST_HOSTNAME}/${VHOST_APPDIR}