Show Posts

91

Backup / Re: Error found on the email from - Anacron job 'cron.daily'

« on: September 03, 2018, 02:14:24 PM »

what does below command shows

Code: [Select]

service mysqld status

92

CentOS-WebPanel GUI / Re: Resources monitor per user/website

« on: September 03, 2018, 02:13:17 PM »

Well you can password protect it like below

Quote

nano /usr/local/apache/htdocs/netdata/etc/netdata/netdata.conf

Find # bind to = under [web] and uncomment it and change it to bind to = localhost

Before

Quote

[web]
# mode = static-threaded
# listen backlog = 4096
# default port = 19999
# bind to =
# web files owner = netdata
# web files group = netdata

After

Quote

[web]
# mode = static-threaded
# listen backlog = 4096
# default port = 19999
bind to = localhost
# web files owner = netdata
# web files group = netdata

Create Password

Code: [Select]

ln -s /usr/local/apache/bin/htpasswd /usr/sbin/htpasswd
htpasswd -bc /usr/local/apache/htdocs/netdata/usr/share/netdata/web/.htpasswd yourusername yourpassword

Copy and Paste all lines not one by one

Quote

cat > /usr/local/apache/conf.d/netdata-auth.conf << "EOF"
<VirtualHost *:80>

   RewriteEngine On
   ProxyRequests Off
   ProxyPreserveHost On

   <Proxy *>
      Require all granted
   </Proxy>

   # Local netdata server accessed with '/netdata/', at localhost:19999
   ProxyPass "/netdata/" "http://localhost:19999/" connectiontimeout=5 timeout=30 keepalive=on
   ProxyPassReverse "/netdata/" "http://localhost:19999/"

   # if the user did not give the trailing /, add it
   # for HTTP (if the virtualhost is HTTP, use this)
   RewriteRule ^/netdata$ http://%{HTTP_HOST}/netdata/ [L,R=301]
   # for HTTPS (if the virtualhost is HTTPS, use this)
   #RewriteRule ^/netdata$ https://%{HTTP_HOST}/netdata/ [L,R=301]

<Location /netdata/>
AuthType Basic
AuthName "Protected site"
     AuthUserFile /usr/local/apache/htdocs/netdata/usr/share/netdata/web/.htpasswd
     Require valid-user
     Order deny,allow
     Allow from all
</Location>

</VirtualHost>
EOF

Restart Apache

Code: [Select]

service httpd restart
Note: Now you cant access netdata using port you need to access like http://yourserverip/netdata/

93

Backup / Re: Error found on the email from - Anacron job 'cron.daily'

« on: September 03, 2018, 01:51:11 PM »

stop mysql

Code: [Select]

service mysqld stop
service mysql stop

Now start from cwp gui

94

Backup / Re: Error found on the email from - Anacron job 'cron.daily'

« on: September 03, 2018, 01:08:36 PM »

Adding that line I think you didnt restart mysql and thats why it happened.

by uncommenting [mysqld] and restarting through ssh did it give any error?

95

Backup / Re: Error found on the email from - Anacron job 'cron.daily'

« on: September 03, 2018, 12:50:36 PM »

make /etc/my.cnf to look like below as I comment out [mysqld]

nano /etc/my.cnf

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

restart mysql

Code: [Select]

service mysqld restart
Does it restart?

run the command below

Code: [Select]

mysqldump
Does the above command gives same warning as you mentioned in the first thread.

96

Backup / Re: Error found on the email from - Anacron job 'cron.daily'

« on: September 03, 2018, 12:39:28 PM »

what is output of

mysqldump

Does it gives same warning like you mentioned above?

97

CentOS-WebPanel GUI / Re: Resources monitor per user/website

« on: September 03, 2018, 12:36:26 PM »

Yes we do password protect it. Obviously its not good to keep it open. anyone can come and change settings see things. Thats not a vulnerability but why would I allow someone to see my chart

98

Backup / Re: Error found on the email from - Anacron job 'cron.daily'

« on: September 03, 2018, 12:30:42 PM »

Well you can replicate the issue easily.

in /etc/my.cnf file remove [mysqld] and restart mysql. See if it starts.

99

CentOS-WebPanel GUI / Re: Resources monitor per user/website

« on: September 03, 2018, 12:29:00 PM »

You can actually password protect it using /usr/local/apache/bin/htpasswd and adding it in vhost file.

Search online to know how.

Well there was command in tutorial but I don't know why it didn't execute.

100

Backup / Re: Error found on the email from - Anacron job 'cron.daily'

« on: September 03, 2018, 12:15:02 PM »

You didnt read my whole reply. i told you it should be under [mysqld]

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

101

Backup / Re: Error found on the email from - Anacron job 'cron.daily'

« on: September 03, 2018, 11:31:06 AM »

What is output of

Code: [Select]

cat /etc/my.cnf
Did you added local-infile=0 under [mysqld] so it would look like

Code: [Select]

[mysqld] 
local-infile=0

102

CentOS-WebPanel GUI / Re: Resources monitor per user/website

« on: September 03, 2018, 11:28:47 AM »

Well you cannot monitor per site basis. Its for those who who to see how their server is functioning and using resources based on GUI. This send notification too on desktop to let user know if something is wrong.

Well that error is related to permission I think

Did you try to run the following command for permission

chown -R netdata:netdata /usr/local/apache/htdocs/netdata

103