Messages

1

Apache / Re: Unable to write .htaccess in my CWP

« on: February 27, 2019, 04:30:12 PM »

same problem here... fresh installation, changed to php 7.2.x and my htaccess not works. any solution?

2

MySQL / Re: Hide/block remote connection phpmyadmin

« on: November 29, 2017, 09:34:54 PM »

Check this tutorial:- https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-with-apache-on-a-centos-7-server

Yeah i think we can do the same as Step Two — Secure your phpMyAdmin Instance with CWP at Apache redirect's /index.php?module=system_redirects

But some1 told me if we change that redirects it will mess with some features. any1 can confirm?
If we go to /index.php?module=system_redirects
and change
Redirect permanent /phpmyadmin
and
Redirect permanent /phpMyAdmin

to something else it will work fine or we'll get some problems?

3

MySQL / Hide/block remote connection phpmyadmin

« on: November 29, 2017, 03:37:27 PM »

Hey, whats the better way to secure phpmyadmin access from external?
Like now, we can access to our phpmyadmin using domain/phpmyadmin

Whats the better thing to do?

4

PHP / Re: 100% CPU usage

« on: October 23, 2017, 08:19:00 PM »

What does top say is using it all ?

shuld give anoutput like when i looked at my server doing a backup

Code: [Select]

root@srv41:/# top
top - 21:35:04 up 43 min,  1 user,  load average: 1.53, 1.92, 1.93
Tasks:  73 total,   3 running,  70 sleeping,   0 stopped,   0 zombie
%Cpu(s): 14.6 us,  1.7 sy,  0.0 ni, 83.3 id,  0.5 wa,  0.0 hi,  0.0 si,  0.0 st
KiB Mem:  25165824 total,  7278060 used, 17887764 free,        0 buffers
KiB Swap:  8388608 total,        0 used,  8388608 free.  5399584 cached Mem

  PID USER      PR  NI    VIRT    RES    SHR S  %CPU %MEM     TIME+ COMMAND
21562 root      20   0    4440    812    416 R  76.2  0.0   0:02.29 gzip
  925 admin     20   0  784392 369236  71260 R  19.6  1.5   5:56.17 apache2
  921 mysql     20   0 1287324  64608   8072 S   5.7  0.3   3:37.33 mysqld
  941 root      20   0  876584  10772   2928 S   0.7  0.0   0:02.26 fail2ban-server
Bare in mind this was a debian server but it is the same on a centos server.

pleas post output here so we can help

Here is a print when i type top


its so strange, got a good vps and its so slow with magento 2....

5

PHP / 100% CPU usage

« on: October 23, 2017, 07:05:45 PM »

Hey , need some help here, recently installed Magento 2 with CWPanel PRO at my new server.
its very slow. when i open my website the CPU usage is 100% and takes a lot of time to load the website..

Any help?
Memory RAM (with Cache): 2.84GB / 14GB
Memory RAM (NO Cache): 0.84GB / 14GB

Apache version: Apache/2.4.27
PHP version: 7.0.10
CPU Details: 4 Core (2400 MHz)
CWPpro version: 0.9.8.359

6

Installation / Re: fresh instal with MySQL

« on: March 17, 2017, 09:18:14 PM »

mariadb have all the feature of mysql what extra you need ?

For me.. with Magento + MariaDB i have a lot of database corrupted.
The site was installed on another server with mysql 5.x and had no problems,
I dont know what happened when I imported here because I made a dump to mysql since phpmyadmin was not working ..
This is why i prefer mysql 5.x instead mariadb for now.

2017-03-17 19:01:36 140099315718176 [Note] InnoDB: 128 rollback segment(s) are active.
2017-03-17 19:01:36 140099315718176 [Note] InnoDB: Waiting for purge to start
2017-03-17 19:01:36 140099315718176 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 427068511
2017-03-17 19:01:36 140098563704576 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-03-17 19:01:36 140099315718176 [Note] Plugin 'FEEDBACK' is disabled.
2017-03-17 19:01:36 140099315718176 [Note] Recovering after a crash using tc.log
2017-03-17 19:01:36 140099315718176 [Note] Starting crash recovery...
2017-03-17 19:01:36 140099315718176 [Note] Crash recovery finished.
2017-03-17 19:01:36 140099315718176 [Note] Server socket created on IP: '::'.
2017-03-17 19:01:36 140099315718176 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.21-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
2017-03-17 19:13:32 140099314494208 [ERROR] mysqld: Table './xxxxxxxx/catalogsearch_fulltext' is marked as crashed and should be repaired
2017-03-17 19:13:32 140099314494208 [Warning] Checking table:   './xxxxxxxx/catalogsearch_fulltext'

7

MySQL / Re: 413 Request Entity Too Large by phpmyadmin

« on: March 06, 2017, 01:20:29 PM »

Not helping for me.
I change this line but still cant import SQL 1MB

Same here... any1 find a solution to fix the import database at phpmyadmin?

8

MySQL / Re: Can't import db

« on: March 06, 2017, 01:15:11 PM »

Alternative option: SSH

You can try this:

Code: [Select]

mysql -uUSERNAME -pPASSWORD DATABASE_NAME < /home/USERNAME/public_html/BACKUP.sql

Yes it worked well thank you very much but i'm still wondering why i couldn't import on phpMyAdmin

I'm happy..

For phpMyAdmin:

Code: [Select]

yum install -y nano
nano /usr/local/cwp/php71/php.ini

Code: [Select]

post_max_size = 500M

same for me.. why we cant import databases with phpmyadmin? only with ssh...

9

CentOS 6 Problems / Re: Warning: [obfuscated]():....

« on: January 30, 2017, 11:14:01 AM »

Code: [Select]

170124 15:45:45 mysqld_safe Number of processes running now: 0
170124 15:45:46 mysqld_safe mysqld restarted
170124 15:45:47  InnoDB: Initializing buffer pool, size = 8.0M
170124 15:45:47  InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 20 332212424
170124 15:45:47  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 20 332215443
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 1 row operations to undo
InnoDB: Trx id counter is 0 389444352
170124 15:45:47  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
170124 15:45:47  InnoDB: Started; log sequence number 20 332215443
InnoDB: Starting in background the rollback of uncommitted transactions
170124 15:45:47  InnoDB: Rolling back trx with id 0 389443928, 1 rows to undo
170124 15:45:48 [Note] Event Scheduler: Loaded 0 events
170124 15:45:48 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

InnoDB: Rolling back of trx id 0 389443928 completed
170124 15:45:48  InnoDB: Rollback of non-prepared transactions completed
170124 15:46:37 mysqld_safe Number of processes running now: 0
170124 15:46:37 mysqld_safe mysqld restarted
170124 15:46:41  InnoDB: Initializing buffer pool, size = 8.0M
170124 15:46:41  InnoDB: Completed initialization of buffer pool
InnoDB: Error: pthread_create returned 11
170124 15:46:42 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170124 15:59:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170124 15:59:36  InnoDB: Initializing buffer pool, size = 8.0M
170124 15:59:36  InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 20 332275616
170124 15:59:36  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 20 332282842
170124 15:59:36  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
170124 15:59:37  InnoDB: Started; log sequence number 20 332282842
170124 15:59:37 [Note] Event Scheduler: Loaded 0 events
170124 15:59:37 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170125  3:44:02 [Note] /usr/libexec/mysqld: Normal shutdown

170125  3:44:02 [Note] Event Scheduler: Purging the queue. 0 events
170125  3:44:04  InnoDB: Starting shutdown...
170125  3:44:06  InnoDB: Shutdown completed; log sequence number 20 366796198
170125  3:44:06 [Note] /usr/libexec/mysqld: Shutdown complete

170125 03:44:06 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170125 08:53:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170125  8:53:21  InnoDB: Initializing buffer pool, size = 8.0M
170125  8:53:21  InnoDB: Completed initialization of buffer pool
170125  8:53:21  InnoDB: Started; log sequence number 20 366796198
170125  8:53:21 [Note] Event Scheduler: Loaded 0 events
170125  8:53:21 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170126  3:30:01 [Note] /usr/libexec/mysqld: Normal shutdown

170126  3:30:01 [Note] Event Scheduler: Purging the queue. 0 events
170126  3:30:03  InnoDB: Starting shutdown...
170126  3:30:06  InnoDB: Shutdown completed; log sequence number 20 497452229
170126  3:30:06 [Note] /usr/libexec/mysqld: Shutdown complete

170126 03:30:06 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170126 09:51:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170126  9:51:24  InnoDB: Initializing buffer pool, size = 8.0M
170126  9:51:24  InnoDB: Completed initialization of buffer pool
170126  9:51:24  InnoDB: Started; log sequence number 20 497452229
170126  9:51:24 [Note] Event Scheduler: Loaded 0 events
170126  9:51:24 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170127  3:14:02 [Note] /usr/libexec/mysqld: Normal shutdown

170127  3:14:02 [Note] Event Scheduler: Purging the queue. 0 events
170127  3:14:04  InnoDB: Starting shutdown...
170127  3:14:06  InnoDB: Shutdown completed; log sequence number 20 688640035
170127  3:14:06 [Note] /usr/libexec/mysqld: Shutdown complete

170127 03:14:06 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170127 09:36:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170127  9:36:12  InnoDB: Initializing buffer pool, size = 8.0M
170127  9:36:12  InnoDB: Completed initialization of buffer pool
170127  9:36:12  InnoDB: Started; log sequence number 20 688640035
170127  9:36:12 [Note] Event Scheduler: Loaded 0 events
170127  9:36:12 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170128  3:35:02 [Note] /usr/libexec/mysqld: Normal shutdown

170128  3:35:02 [Note] Event Scheduler: Purging the queue. 0 events
170128  3:35:04  InnoDB: Starting shutdown...
170128  3:35:05  InnoDB: Shutdown completed; log sequence number 20 821454141
170128  3:35:05 [Note] /usr/libexec/mysqld: Shutdown complete

170128 03:35:05 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170128 03:37:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170128  3:37:20  InnoDB: Initializing buffer pool, size = 8.0M
170128  3:37:20  InnoDB: Completed initialization of buffer pool
170128  3:37:20  InnoDB: Started; log sequence number 20 821454141
170128  3:37:20 [Note] Event Scheduler: Loaded 0 events
170128  3:37:20 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170129  3:49:01 [Note] /usr/libexec/mysqld: Normal shutdown

170129  3:49:01 [Note] Event Scheduler: Purging the queue. 0 events
170129  3:49:03  InnoDB: Starting shutdown...
170129  3:49:08  InnoDB: Shutdown completed; log sequence number 20 1033231499
170129  3:49:08 [Note] /usr/libexec/mysqld: Shutdown complete

170129 03:49:08 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170129 08:40:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170129  8:40:51  InnoDB: Initializing buffer pool, size = 8.0M
170129  8:40:51  InnoDB: Completed initialization of buffer pool
170129  8:40:51  InnoDB: Started; log sequence number 20 1033231499
170129  8:40:51 [Note] Event Scheduler: Loaded 0 events
170129  8:40:51 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170130  3:28:02 [Note] /usr/libexec/mysqld: Normal shutdown

170130  3:28:02 [Note] Event Scheduler: Purging the queue. 0 events
170130  3:28:04  InnoDB: Starting shutdown...
170130  3:28:08  InnoDB: Shutdown completed; log sequence number 20 1275828139
170130  3:28:08 [Note] /usr/libexec/mysqld: Shutdown complete

170130 03:28:08 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170130 08:32:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170130  8:32:04  InnoDB: Initializing buffer pool, size = 8.0M
170130  8:32:04  InnoDB: Completed initialization of buffer pool
170130  8:32:05  InnoDB: Started; log sequence number 20 1275828139
170130  8:32:05 [Note] Event Scheduler: Loaded 0 events
170130  8:32:05 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution


10

CentOS 6 Problems / Re: Warning: [obfuscated]():....

« on: January 30, 2017, 09:57:48 AM »

same problem here for 6 days in a row...
same hour when i use a user_backup script with a cronjob.

11

PHP / Re: magento cron can't work on CWP.admin

« on: February 23, 2016, 05:18:18 PM »

add the follow cron job on CWP.admin cron tab:
*/5 * * * * /bin/sh /home/magento/public_html/cron.sh &> /dev/null

On magento dashboard,magento cron can't run(can see run or not using aoe_scheduler module);

how to setting the magento cron on CWP.admin cron job tab?
Please help!

Did you fixed that?

12

Postfix / Re: email send mark as spam

« on: January 25, 2016, 11:31:19 PM »

ok ... if I send an email from the IP/roundcube everything is fine. if i use domain/roundcube or host.domain/roundcube all emails go to spam. any tips?

have you checked do you have a proper rdns and hostname A record set ?

yap, i think its working now

13

CentOS-WebPanel Bugs / Re: error 500

« on: January 25, 2016, 02:12:21 PM »

Olá amigo, tudo bem? é só ir ao seu painel do CWP, em User accounts, fix permissions, voce escolhe o utilizador e faz fix!
Está aqui o exemplo: http://prntscr.com/9um8hd

14

Postfix / Re: email send mark as spam

« on: January 22, 2016, 06:31:25 PM »

ok ... if I send an email from the IP/roundcube everything is fine. if i use domain/roundcube or host.domain/roundcube all emails go to spam. any tips?

15

Postfix / Re: email send mark as spam

« on: January 21, 2016, 12:57:15 PM »

have you checked your email here https://www.mail-tester.com ?

also you should check blacklisting and rDNS
http://mxtoolbox.com/blacklists.aspx
http://www.senderbase.org/

10/10
http://prntscr.com/9swxex

0blacklist's

RDNS are ok
http://prntscr.com/9swykm

And they continue to be sent As spam...