Difference between revisions of "Freeside:4:Documentation:InstallingOnDebian8"

From Freeside
Jump to: navigation, search
(Employees)
Line 84: Line 84:
 
<pre>
 
<pre>
 
$ su freeside
 
$ su freeside
$ freeside-adduser -g 1 username
+
$ freeside-adduser -g 1 username password
$ htpasswd /usr/local/etc/freeside/htpasswd username
 
Password:
 
 
</pre>
 
</pre>
 
Additional users can be added using the same command or from the web interface.
 
Additional users can be added using the same command or from the web interface.

Revision as of 19:18, 6 March 2017

Configure package repositories

  • Add the following apt sources to /etc/apt/sources.list (for Debian 8.x "jessie"):
deb http://freeside.biz/~ivan/freeside-jessie/ ./
deb http://freeside.biz/~jeremyd/freeside4-jessie-stable/ ./
  • Run aptitude update.

Install

aptitude install freeside freeside-lib freeside-webui
apt-mark hold freeside*

Database setup

Database User

  • Allow the freeside user full access to the freeside database.

with Postgresql:

[ as postgres/pgsql user ]
$ createuser -P -d freeside 
Enter password for new role: 
Enter it again: 

or with MySQL:

$ mysqladmin -u root password 'set_a_root_database_password'
$ mysql -u root -p
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE,DROP on freeside.* TO freeside@localhost IDENTIFIED BY 'set_a_freeside_database_password';

Database Access

  • Configure /usr/local/etc/freeside/secrets if necessary. This file contains three lines: DBI datasource, username and password
    • See the DBI manpage and the manpage for your DBD for the exact syntax of your DBI data source.

Database

  • Add the freeside database to your database engine:

with Postgres:

$ su freeside
$ createdb -E UTF8 freeside

or with MySQL:

$ mysqladmin -u freeside -p create freeside 

Bootstrap Freeside

Freeside database

  • As the freeside UNIX user, run freeside-setup -d your.domain.name to create the database tables and initial data.
$ su freeside
$ freeside-setup -d example.com

RT database

  • As the freeside UNIX user, run:
$ su freeside
$ /opt/rt3/sbin/rt-setup-database --action schema
$ /opt/rt3/sbin/rt-setup-database --action coredata
$ /opt/rt3/sbin/rt-setup-database --action insert --datafile /opt/rt3/etc/initialdata

System users

  • Create the Freeside system users:
$ su freeside
$ freeside-adduser -g 1 fs_queue
$ freeside-adduser -g 1 fs_daily
$ freeside-adduser -g 1 fs_selfservice
$ freeside-adduser -g 1 fs_api

Employees

  • Create one or more Freeside users (your internal sales/tech folks, not customer accounts):
$ su freeside
$ freeside-adduser -g 1 username password

Additional users can be added using the same command or from the web interface.

Restart freeside

  • /etc/init.d/freeside restart

Apache & Web GUI

  • Edit /etc/apache2/envvars and set APACHE_RUN_USER and APACHE_RUN_GROUP to freeside
  • a2enconf freeside-base2.4
  • a2enconf freeside-rt
  • a2dismod mpm_event
  • a2enmod mpm_prefork
  • a2enmod rewrite
  • a2enmod perl
  • chown freeside /var/lock/apache2
  • Restart Apache
  • The web interface will be available at /freeside

Next steps

  • Log into the web interface using the username and password you entered above.
  • Proceed to the initial administration of your installation.