Koozali.org: home of the SME Server

Corebos CRM

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Corebos CRM
« Reply #15 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.
...
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 #16 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.
...
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 #17 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


Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Corebos CRM
« Reply #18 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

...
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 Jean-Philippe Pialasse

  • *
  • 2,746
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: Corebos CRM
« Reply #19 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


Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Corebos CRM
« Reply #20 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]
...
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 #21 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

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Corebos CRM
« Reply #22 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 !
...
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 #23 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.
...
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 #24 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

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Corebos CRM
« Reply #25 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
...
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 #26 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



« Last Edit: April 24, 2019, 10:06:58 PM by Bud »

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Corebos CRM
« Reply #27 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??)
...
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 #28 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  ????

 :(
« Last Edit: April 24, 2019, 10:50:10 PM by Bud »

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Corebos CRM
« Reply #29 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.

...
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