[ FreeScout ] [ 1.7.9 ] Free self-hosted help desk & shared mailbox

[QNAP_Stephane]

Source : https://github.com/freescout-helpdesk/freescout

Download :


Apache73https://www.qnapclub.eu/fr/qpkg/1050
Apache74https://www.qnapclub.eu/fr/qpkg/1051
Apache80https://www.qnapclub.eu/fr/qpkg/1149


About :

FreeScout is the super lightweight free open source help desk and shared inbox written in PHP7 (Laravel 5.5 framework) – self hosted clone of HelpScout. Now you can enjoy free Zendesk & Help Scout without giving up privacy or locking yourself into a service you don't control.

FreeScout has been developed from scratch and is not using any copyrighted Help Scout materials to comply with GitHub's DMCA Policy (trademark, logos, icons, CSS, JS, HTML files are copyrighted; idea, look and feel cannot be copyrighted).

[yanuk]

Just installed this using QPostgresql 10 as database.

Freescout version on the qnapclub repo is 1.6.13, latest is 1.7, no problem though, we can update it after installing.

I run into issues installing this so I'm writing this guide to help anyone who might encounter the same issue.

I installed this using Postgresql as DB provider.
You'll need to create the DB and user I assume you're also using QPostgresql 10 or later and knows how to ssh into your box.

Code: Select all

cd /opt/QPostgreSQL/bin/

change user to postgres

Code: Select all

./su postgres

create DB and user

Code: Select all

./createdb freescout
./createuser fsadmin

grant user priv

Code: Select all

./psql
alter user fsadmin with encrypted password 'mYsuperSecureP@55WORD!';
grant all privileges on database freescout to fsadmin ;
\q

(Please change mYsuperSecureP@55WORD! into your own password. leave the single quotes there)

Code: Select all

exit

to return to qnap root user
During the setup
use 127.0.0.1 instead of localhost, port will be 5432 if you haven't changed it.
to check which port you are using. while still in postgres user (./su postgres)

Code: Select all

./psql
\conninfo

use \q to quit.

if you faced installation problems during the "migration" process of fresh install
I followed this thred and used the 2 given files attached and replaced them inside /opt/FreeScout73/www/database/migrations
then you might encounter some " sql_require_primary_key (SQL: SET SESSION sql_require_primary_key= 0)" error.
go to /opt/Freescout73/www
run

Code: Select all

 /opt/Apache73/bin/php artisan migrate:status

depending on where your PHP bin is it might be Apache73 74 or 80 or even Qapache, just change it accordingly

the database that didn't get migrated will have a status N
in my case it was the create notifications table

Code: Select all

vim database/migrations/2018_09_05_024109_create_notifications_table.php 

comment out the line SqlRequirePrimaryKey or similar and run migation again

Code: Select all

/opt/Apache73/bin/php artisan migrate:refresh

along the way i managed to delete my only user (admin)

Code: Select all

/opt/Apache73/bin/php artisan freescout:create-user

solves it
Updating the app

Code: Select all

/opt/Apache73/bin/php artisan freescout:update

Code: Select all

/opt/Apache73/bin/php artisan freescout:after-app-update

if you get into some PHP not found error,
use

Code: Select all

export PATH=/opt/Apache73/bin:$PATH 

Hope this will help someone out there.

[QNAP_Stephane]

updated to 1.7.9