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.
181
CentOS-WebPanel GUI / Re: Resources monitor per user/website
« on: September 03, 2018, 01:50:38 PM »Thanks for the fix BulltenSo it's not only me...
182
Backup / Re: Error found on the email from - Anacron job 'cron.daily'
« on: September 03, 2018, 01:49:12 PM »
The last time I did it through SSH.
I still get the same error that MariaDB is not running.
I still get the same error that MariaDB is not running.
183
Backup / Re: Error found on the email from - Anacron job 'cron.daily'
« on: September 03, 2018, 12:58:14 PM »
Oh, damn... I've uncommented the [mysqld], saved the file and restarted mysqld.
But the status still shows the error message (though mysqldump doesn't).
But the status still shows the error message (though mysqldump doesn't).
184
Backup / Re: Error found on the email from - Anacron job 'cron.daily'
« on: September 03, 2018, 12:56:31 PM »
Oh, this time it doesn't restart (I was using the restart button in CWP's dashboard before that, and I didn't get an error then).
Running service mysqld status after the restart command resolves in "ERROR! MariaDB is not running".
And mysqldump resolves in " unknown variable 'local-infile=0' " indeed.
I'll uncomment the [mysqld] and restart mysql again.
But... how come my wordpress sites are working then if the mysql is not running?
Running service mysqld status after the restart command resolves in "ERROR! MariaDB is not running".
And mysqldump resolves in " unknown variable 'local-infile=0' " indeed.
I'll uncomment the [mysqld] and restart mysql again.
But... how come my wordpress sites are working then if the mysql is not running?
185
Backup / Re: Error found on the email from - Anacron job 'cron.daily'
« on: September 03, 2018, 12:47:05 PM »
Sorry, what exactly should I have to run? 
186
CentOS-WebPanel GUI / Re: Resources monitor per user/website
« on: September 03, 2018, 12:41:08 PM »
Correct. I will have to investigate how to do it. As a newbie, everything looks so difficult (throws me back to the MS-DOS days before the Windows era, but I haven't used command line ever since)...
Any chance you have a guide up your sleeve to share how to put this password protection in place?
Any chance you have a guide up your sleeve to share how to put this password protection in place?
187
Backup / Re: Error found on the email from - Anacron job 'cron.daily'
« on: September 03, 2018, 12:38:45 PM »
Yes. It does restart!
188
CentOS-WebPanel GUI / Re: Resources monitor per user/website
« on: September 03, 2018, 12:34:25 PM »
Sorry for so many questions...
What if I won't password protect it. Is there any vulnerability in leaving it open to all?
Do you protect yours?
What if I won't password protect it. Is there any vulnerability in leaving it open to all?
Do you protect yours?
189
Backup / Re: Error found on the email from - Anacron job 'cron.daily'
« on: September 03, 2018, 12:25:21 PM »You didnt read my whole reply. i told you it should be under [mysqld]Sorry. I'm quite new to VPS in general and CWP in particular. I thought that's what you meant.
I don't really know. I only follow tutorials. Though I'm quite sure I made a server restart 2 days ago...
Also when you added local-infile=0 you didnt restart mysql?
so now added it under [mysqld]Quote#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
#
# Disable LOAD DATA LOCAL commands in MySQL
#
[mysqld]
local-infile=0
Also dont forget to restart mysql
I will change according to your guidance, restart mysql and will keep an eye on further emails hopping it'll be resolved.
Thanks!
190
How to / Re: [Tutorial] Installing Netdata on Centos Web Panel
« on: September 03, 2018, 12:03:01 PM »
Thank you so much!
191
CentOS-WebPanel GUI / Re: Resources monitor per user/website
« on: September 03, 2018, 12:01:58 PM »Did you try to run the following command for permissionWow you're a savior! Thank you!
chown -R netdata:netdata /usr/local/apache/htdocs/netdata
Wasn't it part of the tutorial, though? I can swear there was such a command in there...
192
Backup / Re: Error found on the email from - Anacron job 'cron.daily'
« on: September 03, 2018, 11:56:10 AM »cat /etc/my.cnf:
Code: [Select]
[xxx@cwp ~]# cat /etc/my.cnf
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
#
# Disable LOAD DATA LOCAL commands in MySQL
#
local-infile=0
As you can see, the
Code: [Select]
local-infile=0 is there...
193
How to / Re: [Tutorial] Installing Netdata on Centos Web Panel
« on: September 03, 2018, 11:00:59 AM »
Any idea what this error mean (tcp listen drops)?
Warning screenshot from email:
https://pasteboard.co/HCagjN0.png
Recovery screenshot from email:
https://pasteboard.co/HCafQi3.png
Warning screenshot from email:
https://pasteboard.co/HCagjN0.png
Recovery screenshot from email:
https://pasteboard.co/HCafQi3.png
194
CentOS-WebPanel GUI / Re: Resources monitor per user/website
« on: September 03, 2018, 05:57:03 AM »
I got to work now, and am trying to access netdata from my workplace's PC, and get this:
Is it related at all to the fact I'm trying to access it from another PC?
I've also tried from my mobile, and got the same.
Any idea what's wrong?
Code: [Select]
Access to file is not permitted: /usr/local/apache/htdocs/netdata/usr/share/netdata/web//index.htmlIs it related at all to the fact I'm trying to access it from another PC?
I've also tried from my mobile, and got the same.
Any idea what's wrong?
195
Backup / Error found on the email from - Anacron job 'cron.daily'
« on: September 03, 2018, 05:44:00 AM »
For the first time I've looked deeply into the email received for the daily backups and found some errors (marked the errors in Red):
---
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dba --> /backup/mysql/daily//dbb_dba.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbb --> /backup/mysql/daily//dbb_dbb.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbc --> /backup/mysql/daily//dbb_dbc.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbd --> /backup/mysql/daily//dbb_dbd.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbe --> /backup/mysql/daily//dbb_dbe.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbf --> /backup/mysql/daily//dbb_dbf.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbg --> /backup/mysql/daily//dbb_dbg.sql
Skipping database: information_schema.
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbh --> /backup/mysql/daily//dbb_dbh.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: mysql --> /backup/mysql/daily//mysql.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: oauthv2 --> /backup/mysql/daily//oauthv2.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: performance_schema --> /backup/mysql/daily//performance_schema.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: postfix --> /backup/mysql/daily//postfix.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: root_cwp --> /backup/mysql/daily//root_cwp.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: roundcube --> /backup/mysql/daily//roundcube.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbi --> /backup/mysql/daily//dbb_dbi.sql
warning: /var/tmp/rpm-tmp.RpBiRK: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEYerror: Failed dependencies:
perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-2.2.16-1.noarch
---
Any idea what might be wrong?
---
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dba --> /backup/mysql/daily//dbb_dba.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbb --> /backup/mysql/daily//dbb_dbb.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbc --> /backup/mysql/daily//dbb_dbc.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbd --> /backup/mysql/daily//dbb_dbd.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbe --> /backup/mysql/daily//dbb_dbe.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbf --> /backup/mysql/daily//dbb_dbf.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbg --> /backup/mysql/daily//dbb_dbg.sql
Skipping database: information_schema.
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbh --> /backup/mysql/daily//dbb_dbh.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: mysql --> /backup/mysql/daily//mysql.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: oauthv2 --> /backup/mysql/daily//oauthv2.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: performance_schema --> /backup/mysql/daily//performance_schema.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: postfix --> /backup/mysql/daily//postfix.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: root_cwp --> /backup/mysql/daily//root_cwp.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: roundcube --> /backup/mysql/daily//roundcube.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbi --> /backup/mysql/daily//dbb_dbi.sql
warning: /var/tmp/rpm-tmp.RpBiRK: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEYerror: Failed dependencies:
perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-2.2.16-1.noarch
---
Any idea what might be wrong?
