Installing: Manual Installation

If the quick_install.rb script fails to work for you, you can manually execute the steps necessary to get Webiva set up correctly.

A master webiva database needs to be created, database users with the appopriate permissions need to be added, the config/cms.yml and config/cms_migrator.yml configuration files need to be setup and a number of rake tasks need to be executed correctly.

First, jump into the mysql shell and create the master database and two users (one webiva only user and one migrator user), we’re going to assume your master database is going to be called webiva:

$ mysql -u root -p
Enter password: [enter root mysql password]
mysql> CREATE DATABASE `webiva`
mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON  webiva.*  to 'webiva_u'@localhost identified by 'webiva_user_passwrd'
mysql> GRANT ALL ON *.* TO 'webiva_m'@localhost IDENTIFIED BY 'webiva_migrator_password' WITH GRANT OPTION

webiva_user_password and webiva_migrator_password should be set to real passwords. Don’t forget the WITH GRANT OPTION otherwise you the system won’t be able to initialize website databases.

Next, you need create the cms.yml, cms_migrator.yml, backgroundrb.yml and defaults.yml configuration files:

$ cd config
$ cp cms.yml.example cms.yml
$ vi cms.yml 
# Edit the file as necessary (adding in your webiva_u user name and password) - development and production should have the same information
$ cp cms_migrator.yml.example cms_migrator.yml
$ vi cms_migrator.yml
# Edit the file as necessary (adding in your webiva_m user name and password)
$ cp backgroundrb.yml.example backgroundrb.yml
$ cp defaults.yml.example defaults.yml

Next you need to rebuild your local gems:

$ rake gems:build:force

Now we need to migrate the system database (the master webiva db)

$ rake cms:migrate_system_db

Next we need to initialize the system with a initial client domain, and system admin user

$ rake cms:initialize_system CLIENT=YourClientName  DOMAIN=inital_domain.com USERNAME=YourUserName  PASSWORD=YourAdminPassword

Replace the values for the CLIENT, DOMAIN, USERNAME, and PASSWORD variables with appropriate values for you and make sure you make all parameter names passed to rake UPPERCASE. The DOMAIN will need to be a domain that points to localhost and is accessible from your browser. You may need to enter a dummy domain into your /etc/hosts file so that you have a domain you can play with, as Webiva looks at the incoming domain name to decide which database to access, an entry like:

127.0.0.1 www.mydomain.com mydomain.com

Should do the trick (use mydomain.com - without the www - as the domain name above)

Lastly you need to actually create and migrate the domain database:

$ rake cms:create_domain_db DOMAIN_ID=1

After that you should be good to go, try running ./script/server and bringing up http://www.mydomain.com:3000/website in your browser to access the administrative backend - you can login wtih the username and password you set above.