Koozali.org: home of the SME Server
Obsolete Releases => SME 9.x Contribs => Topic started 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.
-
P.S. yes it's a bit of a shameless plug for him, but he deserves it :-)
-
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
-
I'll take a look later.
You should really run mysql55
-
I think you are going a bit mad on your settings here.
KISS
#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 +
config show php 71
php=service
AllowUrlFopen=Off
MaxExecutionTime=600
MemoryLimit=128M
PostMaxSize=20000000
UploadMaxFilesize=20000000
status=enabled
mysql55-mysqld=service
LocalNetworkingOnly=no
status=enabled
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
# 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.
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.
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.
-
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
-
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 +"
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:
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
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:
db accounts show crm
Again I pasted this for comparison.
yes i would like to create the wiki for corebos with your help if at all possible
Good - have you got a wiki login??
-
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
-
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.
-
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
-
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.
-
ReetP
ok, i will await your reply
-
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
-
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
-
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 ;) )
-
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.
-
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.
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.
-
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
-
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...
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
-
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
-
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)
127.0.0.1:3309
config.inc.php should end up looking like this:
$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]
-
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
-
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.
sorry ReetP for the noob questions, just want to make sure it is done correctly
NP - we were all noobs once !
-
Try something like this - make sure you have removed your old DB and users first.
mysql57
Now execute these lines:
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.
-
ReetP thank you for your support
it works!!
finally!
i will create the wiki asap
much appreciated
-
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
-
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
-
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??)
-
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 ????
:(
-
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?
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.
-
As a follow up to your templates.
Add this to /etc/e-smith/templates-custom/opt/remi/php71/root/etc/php.ini/20ResourceLimits
max_input_vars = {
my $iv = $php71{MaxInputVars} || "1000";
$OUT .= "$iv";
}
You can then do:
config setprop php71 MaxInputVars 9000signal-event php-update
I also have this (it works!):
30ErrorHandling
error_reporting = E_ALL & ~E_NOTICE
-
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!
-
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):
ps -e |grep mysql
ps -e |grep mysql
4494 ? 00:55:56 mysqld
4551 ? 00:26:26 mysqld
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
-
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
show variables like '%_database'
Variable_name Value
character_set_database utf8
collation_database utf8_general_ci
skip_show_database OFF
-
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?
-
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
which netstat/bin/netstat
netstat -atnnetstat -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?
-
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.
-
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:
config setprop mysql57-mysqld port 3309 LocalNetworkingOnly no
signal-event post-upgrade;signal-event reboot
(Not sure why you have no port for the existing MySQL but one thing at a time)
-
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
-
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
-
Collaboration at its finest :-)
-
Collaboration at its finest :-)
Indeed !
Wiki pages modded. Please check.
-
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 "
-
i need to increase the UploadMaxFile Size
OK
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.
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?
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???
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?
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:
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)
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.
-
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
-
ReetP and all thank you for your support
so when i issue the following commands
grep UploadMaxFile /etc/e-smith/templates/opt/remi/php71/root/etc/php.ini/*
Result:
/etc/e-smith/templates/opt/remi/php71/root/etc/php.ini/60FileUploads: my $mf = $php71{UploadMaxFilesize} || "10M";
grep -ir Upload /etc/opt/remi/php71/php.ini
i get the following:
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
-
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
-
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?