Koozali.org: home of the SME Server

Corebos CRM

Offline ReetP

  • *
  • 3,722
  • +5/-0
Corebos CRM
« on: July 25, 2018, 09:24:14 PM »
Bit of a FYI.

I finally got my vtiger upgraded and chose to use the corebos fork of vtiger 5.x which I had been running.

See https://github.com/tsolucio/

I have it running on PHP 7.1 and MySql 5.5 on a virtual SME.

I chose corebos as we were used to vtiger, but there was nothing much in the newer versions that we needed, some free stuff suddenly became paid for, and their attitude to open source sucks.

I've known Joe Bordes at TSolucio for years having met him in the vtiger foros, and subsequently face to face. He's a great bloke with a great attitude.

If you are after a CRM, and don't want to be tied in to some of the commercial offerings, they are worth a look.

Yes they have a commercial side, and some commercial plugins, but Joe is pretty flexible.... :-)

Well worth a look.
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Corebos CRM
« Reply #1 on: July 25, 2018, 09:27:50 PM »
P.S. yes it's a bit of a shameless plug for him, but he deserves it :-)
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline Bud

  • *
  • 487
  • +0/-0
Re: Corebos CRM
« Reply #2 on: April 05, 2019, 07:54:46 AM »
ReetP please can you help me with CoreBOS

i am trying to install corebos on my SME 9.2 Server however i seem to have a database issue.
this is what i have done

i have used the " PHP Software Collections Contrib " to change the php version of the " crm " ibay to php71

a created an ibay called " crm "
Group = Admin
User access via file sharing or user ftp = Write = group, Read = everyone
Public access via web or anonymous ftp = Entire Internet ( no password required )
Execution of dynamic content ( CGI, PHP, SSI ) = Enable
Force secure connections = Disabled

# chown -R admin:www /home/e-smith/files/ibays/crm/html
db accounts setprop crm \
AllowOverride All \
FollowSymLinks enabled \
Group www \
PHPBaseDir /home/e-smith/files/ibays/crm/html/:/tmp/ \
PublicAccess global \
UserAccess wr-group-rd-everyone

#signal-event ibay-modify crm

# db accounts setprop crm MemoryLimit 256M
# db accounts setprop crm UpMaxFileSize 64M
# db accounts setprop crm PostMaxSize 64M
# db accounts setprop crm MaxExecTime 600
# db accounts setprop crm DisplayErrors Off
# signal-event ibay-modify crm

MySQL
# mysql
# mysqladmin create 'webcrm' --default-character-set=utf8
# ALTER DATABASE webcrm CHARACTER SET utf8 COLLATE utf8_general_ci;
# CREATE USER 'crmadminuser'@'localhost' IDENTIFIED BY 'mytiger';
# GRANT SELECT ON webcrm.* TO 'crmadminuser'@'localhost' IDENTIFIED BY 'myvtiger';
# FLUSH PRIVILEGES;
# exit

i then changed the folder privileges as required

when i do finish the installation process i keep getting an " HTTP ERROR 500 "

when i look at the MySQL " webcrm " database it has NO Entries in it. So the My SQL database was not populated with the fields.

any ideas what i am doing wrong?
 
any help greatly appreciated



Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Corebos CRM
« Reply #3 on: April 05, 2019, 09:19:49 AM »
I'll take a look later.

You should really run mysql55


...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Corebos CRM
« Reply #4 on: April 05, 2019, 11:45:50 AM »
I think you are going a bit mad on your settings here.

KISS

Quote from: Bud
Code: [Select]
#signal-event ibay-modify crm

# db accounts setprop crm MemoryLimit 256M
# db accounts setprop crm UpMaxFileSize 64M

Those settings you had as per above will make ZERO difference to PHP 7.1 because they only affect the base installed PHP 5.3

Please read more on using SCL/Remi/PHP - https://wiki.contribs.org/PHP_Software_Collections#Usage

You will need PHP 7.1 + and MySQL 5.5 +

Code: [Select]
config show php 71
php=service
    AllowUrlFopen=Off
    MaxExecutionTime=600
    MemoryLimit=128M
    PostMaxSize=20000000
    UploadMaxFilesize=20000000
    status=enabled

Code: [Select]
mysql55-mysqld=service
    LocalNetworkingOnly=no
    status=enabled

Code: [Select]
crm=ibay
    CgiBin=enabled
    Gid=5038
    Group=shared
    Name=crm
    PHPBaseDir=/home/e-smith/files/ibays/crm/html/:/usr/share/pear/:/usr/share/pear-addons/:/tmp/:/opt/remi/php71/root/usr/share/pear/
    PHPTmpDir=enabled
    PHPUploadDir=/home/e-smith/files/ibays/crm/html/tmp/
    PasswordSet=no
    PublicAccess=global
    SSL=enabled
    Uid=5038
    UserAccess=wr-group-rd-everyone


Some relevant bits from my config.inc.php

Code: [Select]
# If you wish to connect thru a different port than default, substitute "127.0.0.1" for localhost.
# db_server has to be set to 127.0.0.1 or it will not connect to the mysql55 DB
# That is a PHP bug, not corebos
$dbconfig['db_server'] = '127.0.0.1';
$dbconfig['db_port'] = ':3307';
$dbconfig['db_username'] = 'user';
$dbconfig['db_password'] = 'password';
$dbconfig['db_name'] = 'crm';
$dbconfig['db_type'] = 'mysqli';
$dbconfig['db_status'] = 'true';
$dbconfig['persistent'] = false;
$dbconfig['db_hostname'] = $dbconfig['db_server'].$dbconfig['db_port'];
$host_name = $dbconfig['db_hostname'];
$site_URL = 'https://corebos.mydomain.com';
// root directory path
$root_directory = '/home/e-smith/files/ibays/crm/html/'

With letsencrypt you have zero excuses not to use https.

Quote from: Bud
Code: [Select]
chown -R admin:www /home/e-smith/files/ibays/crm/html

You don't need to do this as a signal-event ibay-modify should set the correct permissions on the ibay.

If you are going to use git then pull it and then ibay modify afterwards to set the correct permissions.

Code: [Select]
cd /home/e-smith/files/ibays/crm/html
git clone https://github.com/tsolucio/corebos.git .
signal-event ibay-modify crm

That should clone directly into the html directory . Don't miss the '.'

I'd make the perms fairly open to start and you can tighten it up later if required.

HTH. We ought to do a Corebos wiki page.
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline Bud

  • *
  • 487
  • +0/-0
Re: Corebos CRM
« Reply #5 on: April 05, 2019, 12:22:50 PM »
ReetP thank you for your support, much appreciated

i have done the following changes:
# config setprop php71 MaxExecutionTime 600
# config setprop php71 MemoryLimit 256M
# config setprop php71 PostMaxSize 64M
# config setprop php71 UploadMaxFilesize 64M
# signal-event php-update
# config show php71

DO I NEED TO INSTALL MYSQL 5.5? AND THEN PLACE THE FOLLOWING CODE WHERE?
Code: [Select] -
mysql55-mysqld=service
    LocalNetworkingOnly=no
    status=enabled

WHERE DO I PLACE THE FOLLOWING CODE?
Code: [Select]
crm=ibay
    CgiBin=enabled
    Gid=5038
    Group=shared
    Name=crm
    PHPBaseDir=/home/e-smith/files/ibays/crm/html/:/usr/share/pear/:/usr/share/pear-addons/:/tmp/:/opt/remi/php71/root/usr/share/pear/
    PHPTmpDir=enabled
    PHPUploadDir=/home/e-smith/files/ibays/crm/html/tmp/
    PasswordSet=no
    PublicAccess=global
    SSL=enabled
    Uid=5038
    UserAccess=wr-group-rd-everyone

yes i would like to create the wiki for corebos with your help if at all possible

thank you again
« Last Edit: April 05, 2019, 12:25:21 PM by Bud »

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Corebos CRM
« Reply #6 on: April 05, 2019, 02:21:03 PM »
DO I NEED TO INSTALL MYSQL 5.5?

See my answer above... to be clear...

"You will need PHP 7.1 + and MySQL 5.5 +"


Quote
AND THEN PLACE THE FOLLOWING CODE WHERE?
Code: [Select] -
mysql55-mysqld=service
    LocalNetworkingOnly=no
    status=enabled

It isn't 'code' - it is the output of:

Code: [Select]
config show mysql55-mysqld
mysql55-mysqld=service
    LocalNetworkingOnly=no
    status=enabled

Yours needs to match (which by default it won't). Please read the wiki page thoroughly to understand what you are doing and how to modify it.

<tip> By default mysql55 will use a socket, but you need it to run on a port


Quote
WHERE DO I PLACE THE FOLLOWING CODE?
Code: [Select]
crm=ibay
    CgiBin=enabled
    Gid=5038
    Group=shared
    Name=crm
    PHPBaseDir=/home/e-smith/files/ibays/crm/html/:/usr/share/pear/:/usr/share/pear-addons/:/tmp/:/opt/remi/php71/root/usr/share/pear/
    PHPTmpDir=enabled
    PHPUploadDir=/home/e-smith/files/ibays/crm/html/tmp/
    PasswordSet=no
    PublicAccess=global
    SSL=enabled
    Uid=5038
    UserAccess=wr-group-rd-everyone

It is the output of:

Code: [Select]
db accounts show crm
Again I pasted this for comparison.

Quote
yes i would like to create the wiki for corebos with your help if at all possible

Good - have you got a wiki login??
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline Bud

  • *
  • 487
  • +0/-0
Re: Corebos CRM
« Reply #7 on: April 06, 2019, 12:55:42 PM »
ReetP thank you for your help

i will create a wiki account and start with CoreBOS

i will keep you posted

so do you recommend i install MySQL5.5 - https://wiki.contribs.org/Software_Collections:MySQL55
or do i install MySQL 5.7 - https://wiki.contribs.org/Software_Collections:MySQL57

thank you again



« Last Edit: April 06, 2019, 12:58:26 PM by Bud »

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Corebos CRM
« Reply #8 on: April 06, 2019, 11:01:42 PM »
Cool..Think for a wiki account you just open a documentation bug and someone will sort it for you.

Mysql... 55 is the minimum but 57 should work.... up.to you.

Let me know if you have queries on corebos itself.
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline Bud

  • *
  • 487
  • +0/-0
Re: Corebos CRM
« Reply #9 on: April 08, 2019, 06:41:07 PM »
ReetP here are my findings with CoreBOS 8 and SME 9.2 Server

i have installed MySQL 5.7 - https://wiki.contribs.org/Software_Collections:MySQL57

i have used the " PHP Software Collections Contrib " to change the php version of the " crm " ibay to php71

a created an ibay called " crm "
Group = Admin
User access via file sharing or user ftp = Write = group, Read = everyone
Public access via web or anonymous ftp = Entire Internet ( no password required )
Execution of dynamic content ( CGI, PHP, SSI ) = Enable
Force secure connections = Disabled

MySQL 5.7
# mysql57
# CREATE DATABASE webcrm CHARACTER SET utf8 COLLATE utf8_general_ci;
# CREATE USER 'crmadminuser'@'localhost' IDENTIFIED BY 'mytiger';
# GRANT SELECT ON webcrm.* TO 'crmadminuser'@'localhost' IDENTIFIED BY 'myvtiger';
# FLUSH PRIVILEGES;
# exit

i then changed the folder privileges as required

The following are my issues

Recommended PHP Settings:
Directive                      Recommended   PHP.ini value
max_execution_time           600                   30
max_input_vars                   9000                   1000
error_reporting                   E_ERROR           NOT RECOMMENDED
short_open_tag                   Off                   On


Database UTF-8 Support   Not Enabled

how do i issue the command for the php7.1 for php.ini for the ibay " crm " ?
max_execution_time           600  ??           
max_input_vars                   9000  ??
error_reporting                   E_ERROR  ??
short_open_tag                   Off  ??

how do i enable " utf-8 support " for the mysql 5.7 " webcrm " database ?

any help greatly appreciated

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Corebos CRM
« Reply #10 on: April 08, 2019, 09:01:43 PM »
Hi. Sorry as I'm country hopping this week plus changing phones so all my ssh keys are AWOL.......

I'll try and look tomorrow.

The php settings aren't too hard if I can find the templates.

Sql I'm not sure, but I had coffee with Joe Bordes last week, so we'll find a fix.....

Bear with me a few days.
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline Bud

  • *
  • 487
  • +0/-0
Re: Corebos CRM
« Reply #11 on: April 09, 2019, 07:43:44 AM »
ReetP

ok, i will await your reply

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Corebos CRM
« Reply #12 on: April 09, 2019, 11:28:14 AM »
OK - I presume you are going to apply the PHP version globally - just so much easier.

Make a new dir (assuming PHP 7.1 here)

mkdir -p /etc/e-smith/templates-custom/opt/remi/php71/root/etc/php.ini

From:

/etc/e-smith/templates/opt/remi/php71/root/etc/php.ini

Copy over the following templates and then edit to suit

10LanguageOptions
20ResourceLimits
30ErrorHandling

Note that 20ResourceLimits gets values from the PHP 71 key if they are set.

Mine is like this:

config show php71

php71=configuration
    AllowUrlFopen=Off
    MaxExecutionTime=600
    MaxFileUpload=20
    MaxInputTime=60
    MaxInputVars=5000
    MemoryLimit=256M
    PhpModule=enabled
    PostMaxSize=20M
    UploadMaxFilesize=10M

Play about with that and then run signal-event php-update and you should get rid of the PHP errors
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline Bud

  • *
  • 487
  • +0/-0
Re: Corebos CRM
« Reply #13 on: April 09, 2019, 02:01:45 PM »
ReetP

my config show php71
php71=configuration
    AllowUrlFopen=On
    MaxExecutionTime=600
    MaxFileUpload=20
    MaxInputTime=60
    MemoryLimit=256M
    PhpModule=enabled
    PostMaxSize=64M
    UploadMaxFilesize=64M

MaxInputVars=5000 - need to sort this, HOW?

on my CoreBos installation i keep getting the following error:

Database UTF-8 Support   Not Enabled - how do i sort this out as when i created the mysql5.7 database i did issue the following command " CREATE DATABASE webcrm CHARACTER SET utf8 COLLATE utf8_general_ci; "
hence the installation will not complete as it does not create the database fields

any help greatly appreciated



Online Jean-Philippe Pialasse

  • *
  • 2,747
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: Corebos CRM
« Reply #14 on: April 09, 2019, 03:08:54 PM »
There is an old vtiger contribs around. Would it worth the try updating it to this fork ?

In the mean time i could put effort to enable it for php scl or better fpm. (Just offering my time for the php side here ;) )