Koozali.org: home of the SME Server

Corebos CRM

Offline ReetP

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


Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Corebos CRM
« Reply #32 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 
...
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 #33 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
...
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 #34 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?
« Last Edit: April 27, 2019, 06:59:51 AM by Bud »

Offline ReetP

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

Offline ReetP

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


Offline ReetP

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

Online TerryF

  • grumpy old man
  • *
  • 1,821
  • +6/-0
Re: Corebos CRM
« Reply #40 on: May 01, 2019, 11:53:23 AM »
Collaboration at its finest :-)
--
qui scribit bis legit

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Corebos CRM
« Reply #41 on: May 01, 2019, 12:09:13 PM »
Collaboration at its finest :-)

Indeed !

Wiki pages modded. Please check.
...
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 #42 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 "
« Last Edit: June 12, 2019, 07:03:30 PM by Bud »

Offline ReetP

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

  • ****
  • 739
  • +0/-0
    • Security Warehouse, trade security equipment
Re: Corebos CRM
« Reply #44 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