Installation

wmandai

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.

test11

Hi , I can't find how to install on sub folder example domain.com/folder , how I can rum the installer ?

markomobili

test11 - I interested this question too!

markomobili

Cool script and cool design!

I have a question for this instruction:
"Enter /public_html/workice/public as your sub domain Document Root"

Question : Is it means that i must to create some folder, or to make some DNS entry, or to adjust some file?

Best regards.

wmandai

markomobili If you have a folder named workice in /public_html/workice with all the files just point the sub domain root path to /public_html/workice/public folder.

wmandai

markomobili Because of how Laravel is structured it's not possible to install to a sub folder e.g https://domain.com/crm

BMD

Hi, I can't seem to make CRM functional. If anyone can help please let me know.
Thank you

markomobili

BMD It took my team a month to run the script, but it didn't work out yet. It looks like the script is not working yet. Don't waste time.

BMD

markomobili
Thank you for getting back to me. I wasn't clear enough in my issue. The CRM seems to be functional; all the options appear to work until I get to CRON jobs.
I followed the installation instructions and installed the app twice, in the public_html and www. Made all tutorial settings, even got to my hosting provider support to confirm that the issue is not from my side.
I contacted support via Envato twice, and no response from the developer yet.
I am disappointed. This CRM has all the +++ that other CRM I worked with are missing but is useless without CRON Jobs.

baldevp

I had some 500 internal error with workice subscription so I reinstalled it. And after installation, I am staring at a blank white screen. I purchased workice and rated it five stars but its now not working for me.

wmandai

baldevp which version please? Thanks

raihan12

Highly available disk stacks are Morocco Phone Number List nothing new. At the time of writing, Dell will happily sell you a no-single-point-of-failure MD3000 (SAS) or an MD3000i (iSCSI) array with a pair of 146GB 15K RPM SAS drives for Morocco Phone Number List about $4,500. Not bad, eh? Still, if you're on a first name basis with Linux and have a couple of machines to spare, you can set Morocco Phone Number List up a shared-nothing disk cluster for next to nothing. Just how might that be? The good folks at LINBIT Morocco Phone Number List have kindly offered their Distributed Replicated Block Device (DRBD) under the GPL license. DRBD is an online disk clustering suite that, as stated in their own words, can be seen as a "network-based raid1″. Morocco Phone Number List About DRBD DRBD works by injecting a thin layer in between the file system (and the buff upstream to the file system driver. The two-at-a-time rule does not actually limit DRBD from operating on more than two nodes. DRBD supports further "stacking", where a higher level DRBD module Morocco Phone Number List appearing as a block device to the operating system forks to a pair of lower-level block devices which themselves are DRBD modules (and so on). Replication takes place using one of Morocco Phone Number List three protocols: Protocol A queues the data written on the primary node to the secondary node, but doesn't wait for the secondary

node to confirm the receipt of the Morocco Phone Number List data before acknowledging to its own host that the data has been safely committed. Those familiar with NFS will draw relationships to "asynchronous replication" for this is, indeed, the case. Morocco Phone Number List Being asynchronous, it is the fastest of Morocco Phone Number List all replication protocols but suffers from one major drawback - Morocco Phone Number List the failure of the primary device does not guarantee that all of the data is available on the secondary device. However, the data on the Morocco Phone Number List secondary device is always consistent, that is, it accurately represents the data stored on the primary device at the time of the last synchronisation. Protocol B awaits the Morocco Phone Number List response from the secondary host prior to acknowledging the successful commit of the data to its own host. However, the secondary host is not required to immediately persist the replicated changes to stable storage - it may do so some time after confirming the receipt of the changes from the primary host. This ensures that, in the event of a failure, the secondary node is not only consistent, Morocco Phone Number List but completely up-to-date with respect to the primary node's data. In the authors' own words, this protocol can be seen as "semi-synchronous" replication. This protocol is somewhat slower than protocol A, as it

exercises the network on each and Morocco Phone Number List every write operation. Protocol C not only awaits the response from the secondary host, but also mandates that the secondary host secures the updates to stable storage prior to responding to the primary. Because of the added disk I/O overhead, Protocol C is considerably slower than Morocco Phone Number List protocol B. Drawing back to our NFS example, this protocol equates to fully synchronous replication. The protocols above represent varying levels of assurance with Morocco Phone Number List respect to the integrity of the data replication process and trade speed for security. Protocol A is the fastest of all, but is not particularly safe. Protocol C offers the most resiliency to failure, Morocco Phone Number List but incurs the most amount of latency. LINBID claim that most customers should be using protocol C. This is debatable - protocol B is just as safe, while incurring far less overheads. Morocco Phone Number List Protocol B only comes unstuck if both nodes were to black out or power cycle at exactly the same time. This scenario should be guarded against using a UPS and/or Morocco Phone Number List redundant power lines. If re