Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
31
MySQL / Re: can not export magento database via PhpMyAdmin
« on: August 03, 2018, 03:31:11 AM »
any suggestion?
32
Apache / mod_cloudflare not work
« on: July 24, 2018, 01:44:08 AM »
I install the mod_cloudflare by following command. but I found the mod_cloudflare do not work, the $_SERVER['REMOTE_ADDR'] return IP of CloudFlare.
I have checked the /usr/local/apache/conf/httpd.conf, there is no # on the LoadModule cloudflare_module modules/mod_cloudflare.so. so the mod_cloudflare should be loaded.
Any suggestion?
yum install libtool git -y
git clone https://github.com/cloudflare/mod_cloudflare.git && cd mod_cloudflare
/usr/local/apache/bin/apxs -a -i -c mod_cloudflare.c
systemctl restart httpd && /usr/local/apache/bin/httpd -M|grep cloudflare
I have checked the /usr/local/apache/conf/httpd.conf, there is no # on the LoadModule cloudflare_module modules/mod_cloudflare.so. so the mod_cloudflare should be loaded.
Any suggestion?
yum install libtool git -y
git clone https://github.com/cloudflare/mod_cloudflare.git && cd mod_cloudflare
/usr/local/apache/bin/apxs -a -i -c mod_cloudflare.c
systemctl restart httpd && /usr/local/apache/bin/httpd -M|grep cloudflare
33
MySQL / can not export magento database via PhpMyAdmin
« on: May 30, 2018, 02:55:57 AM »
My CWP7 work fine, but when I export Magento database via PhpMyAdmin, it has an error "a form on this page has more than 1000 fields. on submission, some of the fields might be ignored, due to PHP's max_input_var configuration".
So I change the max_input_vars to 10000 in /usr/local/php/php.ini and restart apache, Varnish and mysql server. But still can't export Magento database.
I install XAMPP on my local computer, the max_input_vars is disable, I can export Magento successful.
So I change the max_input_vars to 10000 in /usr/local/php/php.ini and restart apache, Varnish and mysql server. But still can't export Magento database.
I install XAMPP on my local computer, the max_input_vars is disable, I can export Magento successful.
34
CentOS-WebPanel Bugs / Installing shared extensions error
« on: May 28, 2018, 08:07:28 AM »
I switch to PHP 7.026
I got below error, and the installing is stop
Build complete.
Don't forget to run 'make test'.
Installing shared extensions: /usr/local/lib/php/extensions/no-debug-non-zts-20151012/
I run sestatus
SELinux status: disabled
Anyone know how to fix it
I got below error, and the installing is stop
Build complete.
Don't forget to run 'make test'.
Installing shared extensions: /usr/local/lib/php/extensions/no-debug-non-zts-20151012/
I run sestatus
SELinux status: disabled
Anyone know how to fix it
35
Apache / Re: Leverage browser caching
« on: May 14, 2018, 03:44:52 AM »
:)Still wait for response
36
Apache / Leverage browser caching
« on: May 13, 2018, 03:44:58 AM »
Hi
Before my VPS ran Apache Only, and I add blow codes in .htaccess, Google PageSpeed Insights said the "Leverage browser caching" working fine.
<FilesMatch "\.(ico|pdf|flv|jpg|jpeg|png|gif|webp|js|css|swf|x-html|css|xml|js|woff|woff2|ttf|svg|eot)(\.gz)?$">
<IfModule mod_expires.c>
AddType application/font-woff2 .woff2
ExpiresActive On
ExpiresDefault A0
ExpiresByType image/webp A2592000
ExpiresByType image/gif A2592000
ExpiresByType image/png A2592000
ExpiresByType image/jpg A2592000
ExpiresByType image/jpeg A2592000
ExpiresByType image/ico A2592000
ExpiresByType image/svg+xml A2592000
ExpiresByType text/css A2592000
ExpiresByType text/javascript A2592000
ExpiresByType application/javascript A2592000
ExpiresByType application/x-javascript A2592000
ExpiresByType application/font-woff2 A2592000
</IfModule>
<IfModule mod_headers.c>
Header set Expires "max-age=2592000, public"
Header unset ETag
Header set Connection keep-alive
FileETag None
</IfModule>
</FilesMatch>
# END LBCWpFastestCache
Now I switch the server to Apache & Varnish Cache & Nginx Reverse Proxy, the previous codes has stopped work, so I search on google and add below codes, but PageSpeed Insights still said my website do not support "Leverage browser caching," how to do let my website support Leverage browser caching?
## EXPIRES CACHING ##
<IfModule mod_expires.c>
ExpiresActive On
ExpiresByType image/jpg "access plus 1 year"
ExpiresByType image/jpeg "access plus 1 year"
ExpiresByType image/gif "access plus 1 year"
ExpiresByType image/png "access plus 1 year"
ExpiresByType text/css "access plus 1 month"
ExpiresByType application/pdf "access plus 1 month"
ExpiresByType text/x-javascript "access plus 1 month"
ExpiresByType application/x-shockwave-flash "access plus 1 month"
ExpiresByType image/x-icon "access plus 1 year"
ExpiresDefault "access plus 1 month"
</IfModule>
## EXPIRES CACHING ##
Before my VPS ran Apache Only, and I add blow codes in .htaccess, Google PageSpeed Insights said the "Leverage browser caching" working fine.
<FilesMatch "\.(ico|pdf|flv|jpg|jpeg|png|gif|webp|js|css|swf|x-html|css|xml|js|woff|woff2|ttf|svg|eot)(\.gz)?$">
<IfModule mod_expires.c>
AddType application/font-woff2 .woff2
ExpiresActive On
ExpiresDefault A0
ExpiresByType image/webp A2592000
ExpiresByType image/gif A2592000
ExpiresByType image/png A2592000
ExpiresByType image/jpg A2592000
ExpiresByType image/jpeg A2592000
ExpiresByType image/ico A2592000
ExpiresByType image/svg+xml A2592000
ExpiresByType text/css A2592000
ExpiresByType text/javascript A2592000
ExpiresByType application/javascript A2592000
ExpiresByType application/x-javascript A2592000
ExpiresByType application/font-woff2 A2592000
</IfModule>
<IfModule mod_headers.c>
Header set Expires "max-age=2592000, public"
Header unset ETag
Header set Connection keep-alive
FileETag None
</IfModule>
</FilesMatch>
# END LBCWpFastestCache
Now I switch the server to Apache & Varnish Cache & Nginx Reverse Proxy, the previous codes has stopped work, so I search on google and add below codes, but PageSpeed Insights still said my website do not support "Leverage browser caching," how to do let my website support Leverage browser caching?
## EXPIRES CACHING ##
<IfModule mod_expires.c>
ExpiresActive On
ExpiresByType image/jpg "access plus 1 year"
ExpiresByType image/jpeg "access plus 1 year"
ExpiresByType image/gif "access plus 1 year"
ExpiresByType image/png "access plus 1 year"
ExpiresByType text/css "access plus 1 month"
ExpiresByType application/pdf "access plus 1 month"
ExpiresByType text/x-javascript "access plus 1 month"
ExpiresByType application/x-shockwave-flash "access plus 1 month"
ExpiresByType image/x-icon "access plus 1 year"
ExpiresDefault "access plus 1 month"
</IfModule>
## EXPIRES CACHING ##
37
FTP / can not login FTP
« on: January 24, 2018, 03:24:07 AM »
My FTP often have such a problem.
Response: 331 User ****** OK. Password required
Command: PASS *********
Response: 230 OK. Current restricted directory is /
Status: Server does not support non-ASCII characters.
Status: Connected
Status: Retrieving directory listing...
Command: PWD
Response: 257 "/" is your current location
Command: TYPE I
Response: 200 TYPE is now 8-bit binary
Command: PASV
Response: 227 Entering Passive Mode (*******)
Command: MLSD
Error: Connection timed out
Error: Failed to retrieve directory listing
Please tell me how to fix this problem?
Response: 331 User ****** OK. Password required
Command: PASS *********
Response: 230 OK. Current restricted directory is /
Status: Server does not support non-ASCII characters.
Status: Connected
Status: Retrieving directory listing...
Command: PWD
Response: 257 "/" is your current location
Command: TYPE I
Response: 200 TYPE is now 8-bit binary
Command: PASV
Response: 227 Entering Passive Mode (*******)
Command: MLSD
Error: Connection timed out
Error: Failed to retrieve directory listing
Please tell me how to fix this problem?
38
Varnish / Install Varnish SSL error
« on: January 18, 2018, 08:49:10 AM »
Intall the vanish buy selected Apache & Varnish Cache & Nginx Reverse Proxy and click "Save & Rebuild Configuration", but the CWP show some error as below
Nginx ERROR Detected ! nginx: [emerg] SSL_CTX_use_PrivateKey_file("/etc/pki/tls/private/www.***.com.key") failed (SSL: error:0B080074:x509 certificate routines:X509_check_private_key:key values mismatch) nginx: configuration file /etc/nginx/nginx.conf test failed
i have use SSL checker verify my website, the SSL work fine.
any suggestion?
Nginx ERROR Detected ! nginx: [emerg] SSL_CTX_use_PrivateKey_file("/etc/pki/tls/private/www.***.com.key") failed (SSL: error:0B080074:x509 certificate routines:X509_check_private_key:key values mismatch) nginx: configuration file /etc/nginx/nginx.conf test failed
i have use SSL checker verify my website, the SSL work fine.
any suggestion?
39
Apache / enable Gzip
« on: January 11, 2018, 03:06:33 AM »
Hi
I enable Gzip by this guide http://idroot.net/tutorials/how-to-enable-gzip-compression-on-apache/
#LoadModule deflate_module modules/mod_deflate.so change to LoadModule deflate_module modules/mod_deflate.so
Open httpd.conf file using a text editor and place the following in it:
# mod_deflate configuration
<IfModule mod_deflate.c>
# Restrict compression to these MIME types
AddOutputFilterByType DEFLATE text/plain
AddOutputFilterByType DEFLATE text/html
AddOutputFilterByType DEFLATE application/xhtml+xml
AddOutputFilterByType DEFLATE text/xml
AddOutputFilterByType DEFLATE application/xml
AddOutputFilterByType DEFLATE application/x-javascript
AddOutputFilterByType DEFLATE text/javascript
AddOutputFilterByType DEFLATE text/css
# Level of compression (Highest 9 - Lowest 1)
DeflateCompressionLevel 9
# Netscape 4.x has some problems.
BrowserMatch ^Mozilla/4 gzip-only-text/html
# Netscape 4.06-4.08 have some more problems
BrowserMatch ^Mozilla/4\.0[678] no-gzip
# MSIE masquerades as Netscape, but it is fine
BrowserMatch \bMSI[E] !no-gzip !gzip-only-text/html
</IfModule>
and then retart the apache server
Now i use Gizp checker tool https://checkgzipcompression.com/, my website support Gizp, but when i use https://developers.google.com/speed/pagespeed/insights/ check speed of my website, google PageSpeed Insights show i need to enable Gzip compression, what's the problem?
I use https://nixcp.com/tools/gzip-test/, it is said my website does not support Gzip compression.
my Centos webpanel has install Varnish by select webservers->Apache & Varnish Cache & Nginx Reverse Proxy->Save& rebuild configuration
I enable Gzip by this guide http://idroot.net/tutorials/how-to-enable-gzip-compression-on-apache/
#LoadModule deflate_module modules/mod_deflate.so change to LoadModule deflate_module modules/mod_deflate.so
Open httpd.conf file using a text editor and place the following in it:
# mod_deflate configuration
<IfModule mod_deflate.c>
# Restrict compression to these MIME types
AddOutputFilterByType DEFLATE text/plain
AddOutputFilterByType DEFLATE text/html
AddOutputFilterByType DEFLATE application/xhtml+xml
AddOutputFilterByType DEFLATE text/xml
AddOutputFilterByType DEFLATE application/xml
AddOutputFilterByType DEFLATE application/x-javascript
AddOutputFilterByType DEFLATE text/javascript
AddOutputFilterByType DEFLATE text/css
# Level of compression (Highest 9 - Lowest 1)
DeflateCompressionLevel 9
# Netscape 4.x has some problems.
BrowserMatch ^Mozilla/4 gzip-only-text/html
# Netscape 4.06-4.08 have some more problems
BrowserMatch ^Mozilla/4\.0[678] no-gzip
# MSIE masquerades as Netscape, but it is fine
BrowserMatch \bMSI[E] !no-gzip !gzip-only-text/html
</IfModule>
and then retart the apache server
Now i use Gizp checker tool https://checkgzipcompression.com/, my website support Gizp, but when i use https://developers.google.com/speed/pagespeed/insights/ check speed of my website, google PageSpeed Insights show i need to enable Gzip compression, what's the problem?
I use https://nixcp.com/tools/gzip-test/, it is said my website does not support Gzip compression.
my Centos webpanel has install Varnish by select webservers->Apache & Varnish Cache & Nginx Reverse Proxy->Save& rebuild configuration
