Difference between revisions of "Freeside:3:Documentation:InstallingOnDebian7"
From Freeside
(→Add the freeside repository) |
(→Apache & Web GUI) |
||
(14 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | = | + | = Configure package repositories = |
− | + | * Add the following apt sources to <code>/etc/apt/sources.list</code> (for Debian 7.x "wheezy"): | |
− | |||
− | |||
− | * Add the following apt | ||
<pre> | <pre> | ||
deb http://freeside.biz/~ivan/freeside-wheezy/ ./ | deb http://freeside.biz/~ivan/freeside-wheezy/ ./ | ||
+ | deb http://freeside.biz/~jeremyd/freeside3-wheezy-stable/ ./ | ||
</pre> | </pre> | ||
* Run <code>aptitude update</code>. | * Run <code>aptitude update</code>. | ||
− | + | = Install = | |
+ | |||
+ | <pre> | ||
+ | aptitude install freeside | ||
+ | apt-mark hold freeside* | ||
+ | </pre> | ||
− | + | = Database setup = | |
+ | == Database User == | ||
+ | * Allow the freeside user full access to the freeside database. | ||
+ | with Postgresql: | ||
+ | <pre> | ||
+ | [ as postgres/pgsql user ] | ||
+ | $ createuser -P freeside | ||
+ | Enter password for new role: | ||
+ | Enter it again: | ||
+ | Shall the new role be a superuser? (y/n) n | ||
+ | Shall the new role be allowed to create databases? (y/n) y | ||
+ | Shall the new role be allowed to create more new roles? (y/n) n | ||
+ | </pre> | ||
+ | or with MySQL: | ||
<pre> | <pre> | ||
− | + | $ 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'; | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
</pre> | </pre> | ||
− | = | + | == 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: | ||
+ | <pre> | ||
+ | $ su freeside | ||
+ | $ createdb -E UTF8 freeside | ||
+ | </pre> | ||
+ | or with MySQL: | ||
+ | <pre> | ||
+ | $ mysqladmin -u freeside -p create freeside | ||
+ | </pre> | ||
+ | |||
+ | = Bootstrap Freeside = | ||
+ | |||
+ | == Freeside database == | ||
+ | |||
+ | * As the freeside UNIX user, run <code>freeside-setup -d your.domain.name</code> to create the database tables and initial data. | ||
+ | <pre> | ||
+ | $ su freeside | ||
+ | $ freeside-setup -d example.com | ||
+ | </pre> | ||
+ | |||
+ | == RT database == | ||
+ | |||
+ | * As the freeside UNIX user, run: | ||
+ | <pre> | ||
+ | $ 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 | ||
+ | </pre> | ||
+ | |||
+ | == System users == | ||
+ | * Create the Freeside system users: | ||
+ | <pre> | ||
+ | $ 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 | ||
+ | </pre> | ||
+ | |||
+ | == Employees == | ||
+ | * Create one or more Freeside users (your internal sales/tech folks, not customer accounts): | ||
+ | <pre> | ||
+ | $ su freeside | ||
+ | $ freeside-adduser -g 1 username | ||
+ | $ htpasswd /usr/local/etc/freeside/htpasswd username | ||
+ | Password: | ||
+ | </pre> | ||
+ | Additional users can be added using the same command or from the web interface. | ||
+ | |||
+ | = Restart freeside = | ||
+ | |||
+ | * <code>/etc/init.d/freeside restart</code> | ||
+ | |||
+ | = Apache & Web GUI = | ||
+ | * Edit /etc/apache2/envvars and set APACHE_RUN_USER and APACHE_RUN_GROUP to <code>freeside</code> | ||
+ | * <code>a2enconf freeside-base2</code> | ||
+ | * <code>a2enconf freeside-rt</code> | ||
+ | * <code>chown freeside /var/lock/apache2</code> | ||
+ | * 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 [[Freeside:3:Documentation:Administration|administration]] of your installation. |
Latest revision as of 16:42, 3 December 2015
Contents
Configure package repositories
- Add the following apt sources to
/etc/apt/sources.list
(for Debian 7.x "wheezy"):
deb http://freeside.biz/~ivan/freeside-wheezy/ ./ deb http://freeside.biz/~jeremyd/freeside3-wheezy-stable/ ./
- Run
aptitude update
.
Install
aptitude install 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 freeside Enter password for new role: Enter it again: Shall the new role be a superuser? (y/n) n Shall the new role be allowed to create databases? (y/n) y Shall the new role be allowed to create more new roles? (y/n) n
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 $ htpasswd /usr/local/etc/freeside/htpasswd 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
-
a2enconf freeside-rt
-
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.