Workice CRM is build with Laravel Framework
The applications requires PHP >= 7.1.3 and MySQL.
Required PHP Extensions
- OpenSSL
- PDO
- Mbstring
- Tokenizer
- JSON
- CURL
- Mysqli
- IMAP
- Zip
- GD
Release Notes: Changelogs
Any feature you need to see on Workice? Request it here
Create Database
You’ll need to create a new database along with a user to access it. Most hosting companies provide an interface to handle this or you can run the SQL statements below.
- Give your database a name e.g workicecrm
- Create a database user and set up a password
- Add the user to the database and give the user All privileges to the database
CREATE DATABASE workicecrm;
CREATE USER 'workicecrm' IDENTIFIED BY 'workicecrm@@';
GRANT ALL PRIVILEGES ON workicecrm.* to workicecrm@'%' identified by 'workicecrm@@';
FLUSH PRIVILEGES;
- You will need to enter this credentials in the steps below.
There are 2 steps to install Workice CRM
- Using the built in web installer
- Artisan install method (Requires terminal)
Web Installer
Download the code from Envato Market Downloads page.
The zipped file includes all dependencies.
The following steps shows how to install Workice CRM;
Shared hosting with cpanel (Sub Domain)
Use this method only if you want to install Workice on a sub domain e.g crm.yourdomain.com
The steps below shows how you can install workice to be accessible via a sub domain e.g https://crm.yourdomain.com
- Create a folder inside public_html or www e.g workice and upload your downloaded files into the folder /public_html/workice (Make sure it includes hidden files e.g .env)
- Go to sub domains on your cpanel dashboard and create a sub domain
- Enter your preferred sub domain e.g crm.yourdomain.com
- Enter /public_html/workice/public as your sub domain Document Root
- Save it and access http://crm.yourdomain.com/installer
The url /installer does not point to a folder so do not attempt to create a folder named installer
Shared hosting with cpanel (ROOT FOLDER)
Use this method only if you want to install Workice on your main domain e.g yourdomain.com
The steps below shows how you can install workice to be accessible via main domain e.g https://yourdomain.com
- Create a folder e.g workice in the same location where public_html or www folder is located (NOT INSIDE public_html or www)
- Open folder workice and upload workice-crm.zip file (downloaded from envato)
- Extract the contents of the zip into this folder
- Now move the public folder alone to public_html or www folder.
- Edit file public/index.php
- Change line
require __DIR__.'/../bootstrap/autoload.php'; to require __DIR__.'/../workice/bootstrap/autoload.php';
- Change line
$app = require_once __DIR__.'/../bootstrap/app.php'; to $app = require_once __DIR__.'/../workice/bootstrap/app.php';
- You can now access the web installer by visiting http://yourdomain.com/installer
If you encounter an issue displaying images refer to troubleshooting tips below.
Installer
Once you can access the site the initial setup screen will enable you to configure the database and email settings as well as create the initial admin user.
The first page of the web installer checks if your server meets the requirements for Workice to run.
Workice requires PHP 7.1.3+ ensure your PHP CLI is greater than 7.1.3
Click Next if everything is alright if an extension is missing please contact your hosting provider or install it.
The next step checks directory permissions. The folders listed should be writable please do NOT set your permissions to 777.
The next step requires database and account information.
Enter the information and complete the installation.
You will need to setup CRON to run every minute as shown below otherwise invoices/estimates will not be sent or calculated.
File Permissions
The webserver should be able to write to this directories storage, public and bootstrap/cache.
Here is a sample of how you can set the permissions in ubuntu server.
sudo chown -R ubuntu:www-data /path/to/workice
cd /path/to/workice
sudo find -type f -exec chmod 664 {} \;
sudo find -type d -exec chmod 775 {} \;
sudo chgrp -R www-data bootstrap/cache storage
sudo chmod -R ug+rwx bootstrap/cache storage
- Enter your application name and application URL (e.g https://crm.yourdomain.com)
- Enter your database access information that you used when creating database.
- Enter your admin account information. (This is the admin account you are going to login with)
- Click on install and Workice will perform the migrations and seeding.
- If everything went well, you should get a success screen. Click on Exit and login using admin account you created above.
You will need to setup email inorder to verify users accounts. More on that in next article (Configure)
Artisan Installer
If you need to install Workice CRM using php artisan command proceed as follows;
- Open .env file and update your database credentials i.e DB host,DB User etc (You can change other configurations later).
- Run command
php artisan workice:install to start the installation.
- You will be asked to enter admin email and password.
- After successfull install you can now access your dashboard using http://crm.yourdomain.com
- Use your admin account to login.
Admin account created using php artisan workice:install command does not require email verification.
Email Configuration
- Workice CRM supports SMTP, Mailgun, Postmark, SparkPost, Amazon SES, and sendmail.
- If you have no idea how to configure email sending, read on the next guide Configuration.
CRON Configuration
Add a CRON job as shown below;
* * * * * cd /path/to/workice && php artisan schedule:run >> /dev/null 2>&1
This Cron will call Workice command scheduler every minute. When the schedule:run command is executed, Workice will evaluate your scheduled tasks and runs the tasks that are due.
Queue Configuration
Workice CRM relies heavily on queue workers.
For VPS or AWS EC2 users, we recommend installing Supervisord to monitor your processes. Steps on how to install Supervisor on ubuntu are described below
To run queue workers use this command;
php artisan queue:work --queue=default,high,normal,low --tries=3
Queues on Shared Hosting
To run queues on shared hosting;
- Open app/Console/Kernel.php and uncomment the line
$schedule->command('queue:work --workicedaemon --queue=default,high,normal,low --tries=3')....
- Now setup your CRON
* * * * * php /path/to/workice/artisan schedule:run >/dev/null
- We have modified the queue command to only run jobs and exit to avoid server memory issues.
Installing Supervisor
Supervisor is a process monitor for the Linux operating system, and will automatically restart your queue:work process if it fails. To install Supervisor on Ubuntu, you may use the following command:
sudo apt-get install supervisor
Supervisor configuration files are typically stored in the /etc/supervisor/conf.d directory. Within this directory, you may create any number of configuration files that instruct supervisor how your processes should be monitored. For example, let's create a workice-worker.conf file that starts and monitors a queue:work process:
[program:workice-worker]
process_name=%(program_name)s_%(process_num)02d
command=php /path/to/workice/artisan queue:work --queue=default,high,normal,low --tries=3
autostart=true
autorestart=true
user=ubuntu
numprocs=1
redirect_stderr=true
stdout_logfile=/path/to/workice/worker.log
You can refer to laravel docs
Starting Supervisor
Once the configuration file has been created, you may update the Supervisor configuration and start the processes using the following commands:
sudo supervisorctl reread
sudo supervisorctl update
sudo supervisorctl restart all
For more information on Supervisor, consult the Supervisor documentation.
See the details here <configure.html>_ for additional configuration options.
Troubleshooting
- Check your webserver log (ie, /var/log/apache2/error.log) and the application logs (storage/logs/laravel-error.log) for more details or set
APP_DEBUG=true in .env
- Getting 404 not found when i access http://crm.mydomain.com/installer - Ensure your sub domain ROOT Document points to /path/to/workice/public folder and not /path/to/workice folder.
- I cannot see a folder named installer - The url /installer is a laravel route and not a folder. You will be redirected to /installer if the application detects that the app needs to be installed.
- To resolve
file_put_contents(...): failed to open stream: Permission denied run chmod -R 777 storage then chmod -R 755 storage
- Running
composer install --no-dev and composer dump-autoload can sometimes help with composer problems.
- Composer install error:
Fatal error: Allowed memory size of... Try the following: php -d memory_limit=-1 /usr/local/bin/composer install --no-dev
- If you are installing on PHP 7.3 and encounter an error
preg_match_all(): JIT compilation failed: no more memory you will need to modify your php.ini file and enter pcre.jit=0 to fix the issue.
- My images are not loading - May be caused by wrong symlink. Edit public/index.php file and write this line at the top of the code after
<?php opening tag symlink('../your-crm-folder/storage/app/public', './storage');
- My CRONs are not running and i get an error ErrorException with message 'Invalid argument supplied for foreach()' in /home/project/vendor/symfony/console/Input/ArgvInput.php to fix this, enter your CRON to run every minute as shown
php -d register_argc_argv=On /path/to/workice/artisan schedule:run >/dev/null
- Not receiving emails and invoices/estimates balances are not shown correctly. You need to setup CRONS as shown above to fix that.
