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

From Freeside
Jump to: navigation, search
(Configure package repositories)
 
(3 intermediate revisions by the same user not shown)
Line 3: Line 3:
  
 
<pre>
 
<pre>
deb http://freeside.biz/~ivan/freeside-jessie/ ./
+
deb [trusted=yes] http://pkg.freeside.biz/freeside-jessie/ ./
deb http://freeside.biz/~jeremyd/freeside4-jessie-stable/ ./
+
deb [trusted=yes] http://pkg.freeside.biz/freeside4-jessie-stable/ ./
 
</pre>
 
</pre>
  
Line 27: Line 27:
 
Enter it again:  
 
Enter it again:  
 
</pre>
 
</pre>
 +
<!--
 
or with MySQL:
 
or with MySQL:
 
<pre>
 
<pre>
Line 33: Line 34:
 
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE,DROP on freeside.* TO freeside@localhost IDENTIFIED BY 'set_a_freeside_database_password';
 
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE,DROP on freeside.* TO freeside@localhost IDENTIFIED BY 'set_a_freeside_database_password';
 
</pre>
 
</pre>
 +
-->
  
 
== Database Access ==
 
== Database Access ==
Line 45: Line 47:
 
$ createdb -E UTF8 freeside
 
$ createdb -E UTF8 freeside
 
</pre>
 
</pre>
 +
<!--
 
or with MySQL:  
 
or with MySQL:  
 
<pre>
 
<pre>
 
$ mysqladmin -u freeside -p create freeside  
 
$ mysqladmin -u freeside -p create freeside  
 
</pre>
 
</pre>
 +
-->
  
 
= Bootstrap Freeside =
 
= Bootstrap Freeside =
Line 84: Line 88:
 
<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.

Latest revision as of 15:35, 21 November 2017

Configure package repositories

  • Add the following apt sources to /etc/apt/sources.list (for Debian 8.x "jessie"):
deb [trusted=yes] http://pkg.freeside.biz/freeside-jessie/ ./
deb [trusted=yes] http://pkg.freeside.biz/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: 

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

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.