Koozali.org formerly Contribs.org

Contribs.org Forums => SME 9.x Contribs => Topic started by: ReetP on July 25, 2018, 09:24:14 PM

Title: Corebos CRM
Post by: ReetP 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.
Title: Re: Corebos CRM
Post by: ReetP 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 :-)
Title: Re: Corebos CRM
Post by: Bud 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


Title: Re: Corebos CRM
Post by: ReetP on April 05, 2019, 09:19:49 AM
I'll take a look later.

You should really run mysql55


Title: Re: Corebos CRM
Post by: ReetP 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.
Title: Re: Corebos CRM
Post by: Bud 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
Title: Re: Corebos CRM
Post by: ReetP 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??
Title: Re: Corebos CRM
Post by: Bud 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



Title: Re: Corebos CRM
Post by: ReetP 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.
Title: Re: Corebos CRM
Post by: Bud 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
Title: Re: Corebos CRM
Post by: ReetP 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.
Title: Re: Corebos CRM
Post by: Bud on April 09, 2019, 07:43:44 AM
ReetP

ok, i will await your reply
Title: Re: Corebos CRM
Post by: ReetP 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
Title: Re: Corebos CRM
Post by: Bud 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


Title: Re: Corebos CRM
Post by: Jean-Philippe Pialasse 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 ;) )
Title: Re: Corebos CRM
Post by: ReetP on April 09, 2019, 04:01:56 PM
Sorry... phone is on the blink and back in UK for a few days so all a bit tied up.

MaxInputVars=5000

See my config. It is staring you in the face.....

Try....

config setprop php71 MaxInputVars 5000

One of the template should use this.

Db.. I need to check this. Get PHP right first.
Title: Re: Corebos CRM
Post by: ReetP on April 09, 2019, 04:06:36 PM
There is an old vtiger contribs around. Would it worth the try updating it to this fork ?

Possibly for setting up some a SSME aacount, config vars for php & mysql

Everything else comes from git.

Quote
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 ;) )

See if we can get it running and then refine it from there.

Not sure about the SQL issue. Might need to speak to Joe about that.
Title: Re: Corebos CRM
Post by: Bud on April 10, 2019, 08:38:34 AM
ReetP thank you for all your help

i have implemented the changes and still have an issue with the mysql 5.7 database

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

really need to get CoreBOS up and running.
tired of vtiger

more than willing to support  Joe Bordes instead

Title: Re: Corebos CRM
Post by: ReetP on April 10, 2019, 10:54:41 AM
Please give me a chance - I can see the error. Just got to work though it one bit at a time. Not helped because I am away from home on business and my normal access is restricted.

Now you have the PHP issues resolved I'll try and see what we can do about SQL.

First - is the MysqSQL 57 port enabled (rather than socket) Please show...

Code: [Select]
config show mysql57-mysqld
When you did the setup, what URL did you use for the SQL DB?

It should be

127.0.0.1:3307

DON'T USE localhost:3307

Title: Re: Corebos CRM
Post by: Jean-Philippe Pialasse on April 10, 2019, 11:49:27 AM
The error should not be related to utf8 but rather is because there was no proper test of the connection until this command fails. So this is probably a connection issue.

Socket should not be an issue and the mysql connector should be able to handle it.
There is indeed recurent issue with how to indicating to use localhost which frequently fails and 127.0.0.1 should be tried also.

See https://wiki.contribs.org/Software_Collections:MySQL57 for reference the possible way to enter it


127.0.0.1:/var/lib/mysql/mysql57.sock
127.0.0.1;unix_socket=/var/lib/mysql/mysql57.sock

And if you enable network
127.0.0.1:3309

Title: Re: Corebos CRM
Post by: ReetP on April 10, 2019, 11:58:29 AM
Socket should not be an issue and the mysql connector should be able to handle it.

Nope - it has to be a port (currently)

There is some way old vtiger code in there that used to handle sockets but it isn't currently enabled. I was going to possible take a look and re-enable it as it wouldn't be hard.

https://github.com/tsolucio/corebos/issues/367

So this is the way (I forgot it is 3309 on Mysql 57)

Code: [Select]
127.0.0.1:3309

config.inc.php should end up looking like this:

Code: [Select]
$dbconfig['db_server'] = '127.0.0.1';
$dbconfig['db_port'] = ':3309';
$dbconfig['db_username'] = 'user';
$dbconfig['db_password'] = 'pass';
$dbconfig['db_name'] = 'database';
$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'];

There is indeed recurent issue with how to indicating to use localhost which frequently fails and 127.0.0.1 should be tried also.

See https://wiki.contribs.org/Software_Collections:MySQL57 for reference the possible way to enter it


127.0.0.1:/var/lib/mysql/mysql57.sock
127.0.0.1;unix_socket=/var/lib/mysql/mysql57.sock

And if you enable network
127.0.0.1:3309


[/quote]
Title: Re: Corebos CRM
Post by: Bud on April 10, 2019, 02:42:48 PM
ReetP thank you

# config show mysql57-mysqld
mysql57-mysqld=service
    LocalNetworkingOnly=no
    port=3309
    status=enabled

Hostname: 127.0.0.1:3309
User Name: as per mysql user name
Password: as per mysql user password
Database Name: webcrm

Ok so the installation error i now get is: webcrm -> This Database is not found.Try changing the Database settings

including error: Database UTF-8 Support   Not Enabled

just to make it fool proof please can you as an example show me what i must type in exactly to create a mysql database, user, password and UTF-8 support

sorry ReetP for the noob questions, just want to make sure it is done correctly

thank you again
Title: Re: Corebos CRM
Post by: ReetP on April 10, 2019, 03:43:36 PM
just to make it fool proof please can you as an example show me what i must type in exactly to create a mysql database, user, password and UTF-8 support

Ha good question. CLI MySQL scares the hell out of me. I used phpmyadmin :-)

I'll have to go check for some syntax here.

Quote
sorry ReetP for the noob questions, just want to make sure it is done correctly

NP - we were all noobs once !
Title: Re: Corebos CRM
Post by: ReetP on April 10, 2019, 04:47:35 PM
Try something like this - make sure you have removed your old DB and users first.

Code: [Select]
mysql57
Now execute these lines:

Code: [Select]
CREATE USER 'webcrm'@'localhost' IDENTIFIED BY  'password';

GRANT USAGE ON *.* TO 'webcrm'@'localhost' IDENTIFIED BY 'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

CREATE DATABASE webcrm CHARACTER SET utf8 COLLATE utf8_general_ci;

GRANT ALL PRIVILEGES ON  `webcrm` . * TO  'webcrm'@'localhost';

You should then a have a DB called webcrm, user webcrm and password who can only access the DB from the same machine eg localhost.

Tweak as required.
Title: Re: Corebos CRM
Post by: Bud on April 11, 2019, 02:31:59 AM
ReetP thank you for your support

it works!!

finally!

i will create the wiki asap

much appreciated
Title: Re: Corebos CRM
Post by: ReetP on April 11, 2019, 09:44:46 AM
Yay !!!!!!!!!!!!!!!!!!!!

OK. Writing it up for us would be REALLY good.

If you do you get a shiny new badge here in the foros :-)

Let me know if you get stuck making an account.

You can speak direct to Joe and me and some others using Gitter. They are in CoreBOS/discuss.

B. Rgds
John
Title: Re: Corebos CRM
Post by: Bud on April 23, 2019, 02:09:05 PM
ReetP

i have built a new SME 9.2 Server just to make sure that i am doing the installation correctly.
Please note my steps and comment if required

Installed PHP Software Collections for SME Server as per - https://wiki.contribs.org/PHP_Software_Collections
Installed MySQL 5.7 as per - https://wiki.contribs.org/Software_Collections:MySQL57
Installed PHPMYADMIN as per - https://wiki.contribs.org/PHPMyAdmin#tab=For_SME9

Created an " ibay " called " crm " as an example:
Information bay name = crm
Description = My coreBOS 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

Went to " Server Manager > PHP-SCL Versions > crm ( Modify to use PHP71 ) then click on " save "

Make a new dir

# 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



Using Shell i did the Following: ( NOTE I AM USING php71 and NOT php 71 )
# config show php71
# config setprop php71 MaxExecutionTime 600
# config setprop php71 MemoryLimit 256M
# config setprop php71 PostMaxSize 64M
# config setprop php71 UploadMaxFilesize 64M
# config setprop php71 AllowUrlFopen Off
# config setprop php71 MaxInputVars 9000   ?????
# signal-event php-update


PHP CONFIG SETUP SHOWS
# config show php71
php71=configuration
    AllowUrlFopen=Off
    MaxExecutionTime=600
    MaxFileUpload=20
    MaxInputTime=60
    MaxInputVars=9000
    MemoryLimit=256M
    PhpModule=disabled
    PostMaxSize=64M
    UploadMaxFilesize=64M

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

Copied the Following Templates From " /etc/e-smith/templates/opt/remi/php71/root/etc/php.ini " to the Created Folder
10LanguageOptions
20ResourceLimits
30ErrorHandling


Created the Database:
mysql57
CREATE USER 'webcrmuser'@'localhost' IDENTIFIED BY  'mdWebcrm';
GRANT USAGE ON *.* TO 'webcrmuser'@'localhost' IDENTIFIED BY 'mdWebcrm' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
CREATE DATABASE webcrm CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL PRIVILEGES ON  `webcrm` . * TO  'webcrmuser'@'localhost';
FLUSH PRIVILEGES;
exit


MYSQL SETUP SHOWS
config show mysql57-mysqld
mysql57-mysqld=service
    LocalNetworkingOnly=yes
    status=enabled


Now i copied all the coreBOS Files and Folder to - # /home/e-smith/files/ibays/crm/html

i have changed the required file and folder rights

run the installation script: http://mysmeip/crm


INSTALLATION SETUP
MySQL 57 Database Link = 127.0.0.1:3309
Database = webcrm
Database Username = webcrmuser
Database User Password = mdWebcrm

THESE ARE THE PROBLEMS I AM GETTING FROM THE INSTALLATION

PROBLEMS:
Directive            Recommended    PHP.ini value
max_input_vars            9000            1000  ????
error_reporting    E_ERROR    NOT RECOMMENDED  ????
short_open_tag            Off            On   ????



CONFIRMATION CONFIGURATION SETTINGS
Database UTF-8 Support    Not Enabled  ????

i cannot continue with the installation

any help greatly appreciated



Title: Re: Corebos CRM
Post by: ReetP on April 23, 2019, 08:39:34 PM
grep is your friend....

You really need to try and think some of this through yourself logically.and use some tools help you search, including search engines.

I'm doing this on a mobile phone on a bar and it isn't easy.....

Ok, the templates generate this file

/etc/opt/remi/php71/php.ini

You know where they are stored so you start to grep for which templates hold which bits.

So... look for the tags setting

E.g.

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

grep -rn open_tag *

10LanguageOptions:5:short_open_tag                         =
 On;

So it looks like that is hard coded. Edit in your custome template & move on.

Have a look for the actual php max input vars setting, and if there is a SME db key.

The error reporting is not a biggy but can be fixed... again have a look for the key.

UTF 8 in your DB. Should have been created with utf8-general collation.

Check your SQL (it was correct in an earlier post??)
Title: Re: Corebos CRM
Post by: Bud on April 24, 2019, 10:10:45 PM
ReetP thank you for your patience

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

Copied the Following Templates From " /etc/e-smith/templates/opt/remi/php71/root/etc/php.ini " to the Created Folder
10LanguageOptions
20ResourceLimits
30ErrorHandling


Using PHPMYADMIN i see under " current server " it give me two options
localhost (root)
Mysql57 (root)


The " webcrm " Database is under " Mysql57 (root) "
Collation for " webcrm " Database is " utf8_general_ci "

i have tried to reinstall coreBOS 8 but keep getting stuck with the Mysql57 Database error:

Database UTF-8 Support    Not Enabled  ????

 :(
Title: Re: Corebos CRM
Post by: ReetP on April 25, 2019, 06:29:34 PM
Must be getting close then !

Yes, we want to be using Mysql57.

The localhost (root) is the existing MySQL53 installation

The Mysql57 (root) is the MySQL57 installation

OK. lets just check some basics again

1. Are you sure you do not have a webcrm DB in 'localhost(root)' ?
2. Is MySQl57 running OK?

Code: [Select]
netstat -tulpn |grep mysql
Something like this?

tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      4551/mysqld         
tcp        0      0 0.0.0.0:3309                0.0.0.0:*                   LISTEN      4494/mysqld   

3. Are we sure we are trying to connect to the MySQl 57 DB on port 3309 ? So using 127.0.0.1:3309 ?

I can only see one place in the install code it does this check. I've asked Joe about it and will get back to your ASAP. He may be able to tell me how to test the connection.

Title: Re: Corebos CRM
Post by: ReetP on April 25, 2019, 06:44:06 PM
As a follow up to your templates.

Add this to /etc/e-smith/templates-custom/opt/remi/php71/root/etc/php.ini/20ResourceLimits

Code: [Select]
max_input_vars                     = {
    my $iv = $php71{MaxInputVars} || "1000";
    $OUT .= "$iv";
}

You can then do:

Code: [Select]
config setprop php71 MaxInputVars 9000
Code: [Select]
signal-event php-update
I also have this (it works!):

30ErrorHandling

Code: [Select]
error_reporting                        = E_ALL & ~E_NOTICE
Title: Re: Corebos CRM
Post by: Bud on April 26, 2019, 06:36:20 AM
ReetP thank you for your support

when i issue
# netstat -tulpn | grep mysql

the output is NOTHING!

so i guess that MySQL57 is not running?  :-o

help!

Title: Re: Corebos CRM
Post by: ReetP on April 26, 2019, 01:16:56 PM
Odd because I think myphpadmin might have a hissy fit without them running.

Can you try (note I am on Mysql55 so it runs on 3307):

Code: [Select]
ps -e |grep mysql
ps -e |grep mysql
 4494 ?        00:55:56 mysqld
 4551 ?        00:26:26 mysqld


Code: [Select]
netstat -atn |grep 330
netstat -atn |grep 330
tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN     
tcp        0      0 0.0.0.0:3307                0.0.0.0:*                   LISTEN 
Title: Re: Corebos CRM
Post by: ReetP on April 26, 2019, 03:41:07 PM
OK, Joe said you can check your collation with the following command in your DB

I went to my DB with phpmyadmin and pasted this in the SQL box

Code: [Select]
show variables like '%_database'
Variable_name                   Value    
character_set_database    utf8
collation_database            utf8_general_ci
skip_show_database            OFF
Title: Re: Corebos CRM
Post by: Bud on April 27, 2019, 06:57:24 AM
ReetP

ps -e |grep mysql
 1832 ?        00:02:27 mysqld
17134 ?        00:00:27 mysqld

 netstat -atn |grep 330
Shows Nothing

The Following Script shows the same values as yours of my " webcrm " MyQL 5.7 Database
Code: [Select]
show variables like '%_database'

Variable_name                   Value   
character_set_database    utf8
collation_database            utf8_general_ci
skip_show_database            OFF

any ideas?
Title: Re: Corebos CRM
Post by: ReetP on April 27, 2019, 06:32:55 PM
OK, so you have 2 mysql processes so the likelihood is one ois MSQL 5.3 and the other 5.7

I don't understand why netsta doesn't work. Can you try it without the pipe and grep eg

Code: [Select]
which netstat/bin/netstat

Code: [Select]
netstat -atn
Code: [Select]
netstat -tulpn
Manually type - don't copy just to be sure

So your DB appears to be UTF-8

Are you sure you don't have one called the same in MySQL53 (the exiting stock MySQL)

Also, you did get this installed before, but were trying to document the steps, correct?
Title: Re: Corebos CRM
Post by: Bud on April 28, 2019, 07:04:39 AM
ReetP

# which netstat
/bin/netstat

# netstat -atn
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address               Foreign Address             State
tcp        0      0 127.0.0.1:3128              0.0.0.0:*                   LISTEN
tcp        0      0 10.0.10.222:3128            0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:25                  0.0.0.0:*                   LISTEN
tcp        0      0 127.0.0.1:26                0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:443                 0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:1723                0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:636                 0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:993                 0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:515                 0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:995                 0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:389                 0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:873                 0.0.0.0:*                   LISTEN
tcp        0      0 127.0.0.1:139               0.0.0.0:*                   LISTEN
tcp        0      0 10.0.10.222:139             0.0.0.0:*                   LISTEN
tcp        0      0 127.0.0.1:1870              0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:110                 0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:143                 0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:80                  0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:465                 0.0.0.0:*                   LISTEN
tcp        0      0 127.0.0.1:980               0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:21                  0.0.0.0:*                   LISTEN
tcp        0      0 127.0.0.2:53                0.0.0.0:*                   LISTEN
tcp        0      0 10.0.10.222:53              0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:22                  0.0.0.0:*                   LISTEN
tcp        0      0 10.0.10.222:22              10.0.10.20:62376            ESTABLISHED
tcp        0      0 :::873                      :::*                        LISTEN

# netstat -tulpn
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address               Foreign Address             State       PID/Program name
tcp        0      0 127.0.0.1:3128              0.0.0.0:*                   LISTEN      2257/squid
tcp        0      0 10.0.10.222:3128            0.0.0.0:*                   LISTEN      2257/squid
tcp        0      0 0.0.0.0:25                  0.0.0.0:*                   LISTEN      2070/perl
tcp        0      0 127.0.0.1:26                0.0.0.0:*                   LISTEN      1079/perl
tcp        0      0 0.0.0.0:443                 0.0.0.0:*                   LISTEN      2147/httpd
tcp        0      0 0.0.0.0:1723                0.0.0.0:*                   LISTEN      2167/pptpd
tcp        0      0 0.0.0.0:636                 0.0.0.0:*                   LISTEN      1732/slapd
tcp        0      0 0.0.0.0:993                 0.0.0.0:*                   LISTEN      1971/dovecot
tcp        0      0 0.0.0.0:515                 0.0.0.0:*                   LISTEN      1902/lpd
tcp        0      0 0.0.0.0:995                 0.0.0.0:*                   LISTEN      1865/tcpsvd
tcp        0      0 0.0.0.0:389                 0.0.0.0:*                   LISTEN      1732/slapd
tcp        0      0 0.0.0.0:873                 0.0.0.0:*                   LISTEN      2326/rsync
tcp        0      0 127.0.0.1:139               0.0.0.0:*                   LISTEN      2301/smbd
tcp        0      0 10.0.10.222:139             0.0.0.0:*                   LISTEN      2301/smbd
tcp        0      0 127.0.0.1:1870              0.0.0.0:*                   LISTEN      2520/shellinaboxd
tcp        0      0 0.0.0.0:110                 0.0.0.0:*                   LISTEN      1914/tcpsvd
tcp        0      0 0.0.0.0:143                 0.0.0.0:*                   LISTEN      1971/dovecot
tcp        0      0 0.0.0.0:80                  0.0.0.0:*                   LISTEN      2147/httpd
tcp        0      0 0.0.0.0:465                 0.0.0.0:*                   LISTEN      2085/perl
tcp        0      0 127.0.0.1:980               0.0.0.0:*                   LISTEN      2126/httpd-admin
tcp        0      0 0.0.0.0:21                  0.0.0.0:*                   LISTEN      2071/tcpsvd
tcp        0      0 127.0.0.2:53                0.0.0.0:*                   LISTEN      1916/dnscache
tcp        0      0 10.0.10.222:53              0.0.0.0:*                   LISTEN      1826/dnscache
tcp        0      0 0.0.0.0:22                  0.0.0.0:*                   LISTEN      2104/sshd
tcp        0      0 :::873                      :::*                        LISTEN      2326/rsync
udp        0      0 10.0.10.222:123             0.0.0.0:*                               2008/ntpd
udp        0      0 127.0.0.1:123               0.0.0.0:*                               2008/ntpd
udp        0      0 0.0.0.0:123                 0.0.0.0:*                               2008/ntpd
udp        0      0 10.0.10.255:137             0.0.0.0:*                               2291/nmbd
udp        0      0 10.0.10.222:137             0.0.0.0:*                               2291/nmbd
udp        0      0 0.0.0.0:137                 0.0.0.0:*                               2291/nmbd
udp        0      0 10.0.10.255:138             0.0.0.0:*                               2291/nmbd
udp        0      0 10.0.10.222:138             0.0.0.0:*                               2291/nmbd
udp        0      0 0.0.0.0:138                 0.0.0.0:*                               2291/nmbd
udp        0      0 0.0.0.0:1812                0.0.0.0:*                               2187/radiusd
udp        0      0 0.0.0.0:1813                0.0.0.0:*                               2187/radiusd
udp        0      0 0.0.0.0:44204               0.0.0.0:*                               2257/squid
udp        0      0 127.0.0.1:53                0.0.0.0:*                               1969/tinydns
udp        0      0 127.0.0.2:53                0.0.0.0:*                               1916/dnscache
udp        0      0 10.0.10.222:53              0.0.0.0:*                               1826/dnscache
udp        0      0 :::123                      :::*                                    2008/ntpd

Also, you did get this installed before, but were trying to document the steps, correct? - yes i did, and the coreBOS system did work however i must have not documented that ONE thing that get's it to work.
Title: Re: Corebos CRM
Post by: ReetP on April 28, 2019, 10:48:31 AM
No ports.

I think there is a bit missing in the Usage section of the wiki page.

See this:
https://wiki.contribs.org/Software_Collections:MySQL55

Compare it to the MySQL57 page.

I think you might be missing this:

Code: [Select]
config setprop mysql57-mysqld port 3309 LocalNetworkingOnly no
Code: [Select]
signal-event post-upgrade;signal-event reboot
(Not sure why you have no port for the existing MySQL but one thing at a time)
Title: Re: Corebos CRM
Post by: Bud on May 01, 2019, 08:07:31 AM
ReetP thank you very much for your support and time

doh  :grin:

RTFM right!

so you are absolutely correct
you need to make sure you issue the commands as stated by ReetP for the MySQL 5.7 Database to function for the installation requirements

# config setprop mysql57-mysqld port 3309 LocalNetworkingOnly no

# signal-event post-upgrade;signal-event reboot

now the installation works perfectly!

i will do some final testing and start writing up the Installation How To on the Wiki

thank you again ReetP

Title: Re: Corebos CRM
Post by: ReetP on May 01, 2019, 10:15:59 AM
Yay......

I almost lost the will to live :-)

So the MySQL57 page needs updating at a new CoreBos one creating.

I'll try & fix the 57 a bit later today
Title: Re: Corebos CRM
Post by: TerryF on May 01, 2019, 11:53:23 AM
Collaboration at its finest :-)
Title: Re: Corebos CRM
Post by: ReetP on May 01, 2019, 12:09:13 PM
Collaboration at its finest :-)

Indeed !

Wiki pages modded. Please check.
Title: Re: Corebos CRM
Post by: Bud on June 12, 2019, 06:58:56 PM
ReetP

thank you for your help

i need to increase the UploadMaxFile Size

i have issued the following commands

# db configuration setprop php71 MemoryLimit 256M
# db configuration setprop php71 PostMaxSize 64M
# db configuration setprop php71 UploadMaxFilesize 64M
# signal-event php-update


including:

i did Add this to /etc/e-smith/templates-custom/opt/remi/php71/root/etc/php.ini/20ResourceLimits

upload_max_filesize                     = {
    my $iv = $php71{UploadMaxFilesize} || "";
    $OUT .= "$iv";
}



then i issued the command:

config setprop php71 UploadMaxFilesize
signal-event php-update


i even rebooted the sme 9.2 server however when i go to corebos to UPLOAD a file bigger than 3mb i get an error stating that i cannot upload a file bigger than 3mb

how do i increase the file upload size for corebos?

any help greatly appreciated  :P

PS: i am trying to create the coreBos Wiki however on my profile it says " Approval Pending "
Title: Re: Corebos CRM
Post by: ReetP on June 12, 2019, 10:55:14 PM
i need to increase the UploadMaxFile Size

OK

Quote
i have issued the following commands

# db configuration setprop php71 MemoryLimit 256M
# db configuration setprop php71 PostMaxSize 64M
# db configuration setprop php71 UploadMaxFilesize 64M
# signal-event php-update


64M MaxFileSize seems a bit excessive but anyway.... your server.

Quote
i did Add this to /etc/e-smith/templates-custom/opt/remi/php71/root/etc/php.ini/20ResourceLimits

upload_max_filesize                     = {
    my $iv = $php71{UploadMaxFilesize} || "";
    $OUT .= "$iv";
}


Errrrrr why?

Have you checked the commands?

Quote
then i issued the command:

config setprop php71 UploadMaxFilesize
signal-event php-update


Ahhh - yes you did.

So you know a key exists, forgot that it might actually have a setting in a template, so created a NEW setting in the template, reused an existing variable in the template (my $iv - not impossible, but may cause unexpected issues in different scenarios - read some more on perl to see what you actually did) AND then for good measure deleted the actual key value.

You knew there was a key so why didn't you check if it was used???

Code: [Select]
grep UploadMaxFile /etc/e-smith/templates/opt/remi/php71/root/etc/php.ini/*
/etc/e-smith/templates/opt/remi/php71/root/etc/php.ini/60FileUploads:    my $mf = $php71{UploadMaxFilesize} || "10M";

Surprise surprise...... already there.

So after that failed, did you actually look at php.ini too see what had happened?

Code: [Select]
grep -ir Upload /etc/opt/remi/php71/php.ini
file_uploads                           = On
upload_max_filesize                    = 10M
; added by stephdl see $php71MaxFileUpload
max_file_upload                        = 20


So all we actually needed to do was:

Code: [Select]
db configuration setprop php71 UploadMaxFilesize 64M
signal-event php-update

And then check php.ini for the values. Simples.

Sorry - but having a long day and had a sense of humour failure hours ago.

You really MUST read more, and think before you act. Learn to use tools like cat and grep to search for stuff in templates. Be more logical in your work.

If a key is stated on the wiki there is a good chance it is used somewhere. Don't ignore that. Go and look for it. See how it is used. (occasionally you may even find an undocumented one)

Quote
PS: i am trying to create the coreBos Wiki however on my profile it says " Approval Pending "

I'll ask JPP to look at it.
Title: Re: Corebos CRM
Post by: jameswilson on June 13, 2019, 10:03:38 PM
ReetP

i have built a new SME 9.2 Server just to make sure that i am doing the installation correctly.
Please note my steps and comment if required

Installed PHP Software Collections for SME Server as per - https://wiki.contribs.org/PHP_Software_Collections
Installed MySQL 5.7 as per - https://wiki.contribs.org/Software_Collections:MySQL57
Installed PHPMYADMIN as per - https://wiki.contribs.org/PHPMyAdmin#tab=For_SME9

Created an " ibay " called " crm " as an example:
Information bay name = crm
Description = My coreBOS 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

Went to " Server Manager > PHP-SCL Versions > crm ( Modify to use PHP71 ) then click on " save "

Make a new dir

# 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[/b]



Using Shell i did the Following:
# config show php73
# config setprop php73 MaxExecutionTime 600
# config setprop php73 MemoryLimit 256M
# config setprop php73 PostMaxSize 64M
# config setprop php73 UploadMaxFilesize 64M
# signal-event php-update



   

Created the Database:
mysql57
CREATE USER 'webcrmuser'@'localhost' IDENTIFIED BY  'mdWebcrm';
GRANT USAGE ON *.* TO 'webcrmuser'@'localhost' IDENTIFIED BY 'mdWebcrm' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
CREATE DATABASE webcrm CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL PRIVILEGES ON  `webcrm` . * TO  'webcrmuser'@'localhost';
FLUSH PRIVILEGES;
exit

Didnt do the above used phpMyAdmin and created it there

Chnaged mysql57 to be localnetworkingonly=no

Now i copied all the coreBOS Files and Folder to - # /home/e-smith/files/ibays/crm/html



run the installation script: http://mysmeip/crm


INSTALLATION SETUP
MySQL 57 Database Link = 127.0.0.1:3309
Database = webcrm
Database Username = webcrmuser
Database User Password = mdWebcrm



Can confirm working on a test sme9.2
Title: Re: Corebos CRM
Post by: Bud on June 14, 2019, 07:20:27 AM
ReetP and all thank you for your support

so when i issue the following commands

Code: [Select]
grep UploadMaxFile /etc/e-smith/templates/opt/remi/php71/root/etc/php.ini/*
Result:
Quote
/etc/e-smith/templates/opt/remi/php71/root/etc/php.ini/60FileUploads:    my $mf = $php71{UploadMaxFilesize} || "10M";

Code: [Select]
grep -ir Upload /etc/opt/remi/php71/php.ini
i get the following:

Quote
upload_max_filesize                     = 64M
file_uploads                           = On
upload_max_filesize                    = 64M
; added by stephdl see $php71MaxFileUpload
max_file_upload                        = 64M

however when i try to upload a file it still says:

Maximum upload size is 3MB

amy ideas what i am doing wrong?  :D

Title: Re: Corebos CRM
Post by: mmccarn on June 14, 2019, 11:47:53 AM
According to the coreBOS FAQ (http://corebos.com/documentation/doku.php?id=en:adminmanual:faq#how_to_increment_maximum_file) you need to edit the value of upload_maxsize in the coreBOS config.inc.php
Title: Re: Corebos CRM
Post by: Bud on June 16, 2019, 05:09:03 PM
mmccarn thank you for pointing that out

i have already done the following:

edit the following files
1.  " /home/e-smith/files/ibays/mycrm/html/config.inc.php "
2. " /home/e-smith/files/ibays/mycrm/html/config.template.php "

add the line " $upload_maxsize = 25000000; " in both files

restarted the SME 9.2 Server

same problem when i try to upload a 20mb file

Maximum upload size is 3MB

what to do?