Revision as of 17:17, 15 July 2024

Configure package repositories

• Add the following apt sources to /etc/apt/sources.list (for Debian 12.x "bookworm"):

deb [trusted=yes] http://pkg.freeside.biz/freeside-bullseye/ ./
deb [trusted=yes] http://pkg.freeside.biz/freeside4-stretch-testing/ ./   #XXX (no bullseye-specific repo yet) -testing only for now on deb 12, -stable when 4.3 releases

• Run aptitude update.

Install

aptitude install freeside freeside-lib freeside-webui
aptitude hold 'freeside*'
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.
• Example:

DBI:Pg:dbname=freeside
freeside
db_password_if_set

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
• service apache2 restart
• 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.