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

From Freeside
Jump to: navigation, search
(Apache & Web GUI)
(Configure package repositories)
 
(4 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.
Line 96: Line 98:
 
= Apache & Web GUI =
 
= Apache & Web GUI =
 
* Edit /etc/apache2/envvars and set APACHE_RUN_USER and APACHE_RUN_GROUP to <code>freeside</code>
 
* Edit /etc/apache2/envvars and set APACHE_RUN_USER and APACHE_RUN_GROUP to <code>freeside</code>
* <code>a2enconf freeside-base2</code> or for apache 2.4 <code>a2enconf freeside-base2.4</code>
+
* <code>a2enconf freeside-base2.4</code>
 
* <code>a2enconf freeside-rt</code>
 
* <code>a2enconf freeside-rt</code>
 
* <code>a2dismod mpm_event</code>
 
* <code>a2dismod mpm_event</code>

Latest revision as of 16: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.