Admin Blog

53 articles
thumbnail (i.e. miniature image)

Server monitoring using munin + additional Apache monitoring and WordPress coexistence

Server monitoring is essential for stable server operation. However, it is impossible to monitor the servers 24 hours a day, so we use "munin," "AWS's management screen," and "pingdom" to monitor our servers. munin - A server and network monitoring tool. It is open source. aws admin screen - allows us to check the status of various resources. pingdom - A service that checks for dead or alive servers from data centers around the world. This article will show you how to use munin to monitor Apache and the precautions you should take if you are running Wordpress or other applications. Prerequisites This article has been tested in the following environments Amazon Web Services' AmazonLinux with Apache 2.4 installed. Installing Munin Munin can be installed by following the steps below. sudo yum install munin munin-node # installation sudo chkconfig munin-node on Set to start # service automatically sudo service munin-node start # service sudo htpasswd -c /etc/munin/munin-htpasswd admin Set # password Now after about 5 minutes, you will see the server monitoring results in /munin/. If the monitoring results do not exist, the following screen will be displayed. (only if you allow directory indexing (= list of files in a directory)) When the monitoring results are generated, a screen similar to the following is displayed. Now you can use munin, but the password you set earlier is ignored and anyone can see the monitoring results. This is a security issue. (It exposes a weakness to an attacker.) Restart Apache Restarting Apache will activate Munin's login restrictions. This completes the basic setup for basic server monitoring with munin. sudo service httpd restart Adding Monitoring Items Even with just a basic setup, we can now get fairly detailed information about the server. Disk, network, CPU, and many other items that should be cared about at the OS level are covered. In version 2.0.20, 38 monitoring items are enabled by default (some of them monitor about 10 values within a single item), but overall, 232 monitoring items are prepared. You may think that you should add all of them, but we do not recommend it. Doing so will cause a load for monitoring, require extra space for storing monitoring results, and in the first place, make it difficult to find the desired item by listing unnecessary items on munin's screen. Monitoring items enabled by default ls /etc/munin/plugins/ cpu diskstats fw_packets interrupts memory ntp_kernel_pll_freq ntp_states processes sendmail_mailstats threads vmstat df entropy if_err_eth0 irqstats netstat ntp_kernel_pll_off open_files proc_pri sendmail_mailtraffic uptime df_inode forks if_eth0 load ntp_kernel_err ntp_offset open_inodes sendmail_mailqueue swap users Monitoring items that can be used immediately by simply linking ls /usr/share/munin/plugins/ acpi diskstat_ ip_ nfs4_client postgres_checkpoints snmp__cpuload snort_traffic amavis diskstats ipac-ng nfs_client postgres_connections_ snmp__df spamstats apache_accesses ejabberd_ ipmi_ nfsd postgres_connections_db snmp__df_ram squeezebox_ apache_processes entropy ipmi_sensor_ nfsd4 postgres_locks_ snmp__fc_if_ squid_cache apache_volume exim_mailqueue ircu nginx_request postgres_oldest_prepared_xact_ snmp__fc_if_err_ squid_icp apc_envunit_ exim_mailqueue_alt irqstats nginx_status postgres_prepared_xacts_ snmp__if_ squid_objectsize apc_nis exim_mailstats jmx_tomcat_dbpools nomadix_users_ postgres_querylength_ snmp__if_err_ squid_requests apt fail2ban load ntp_kernel_err postgres_scans_ snmp__if_multi squid_traffic apt_all files_ loggrep ntp_kernel_pll_freq postgres_size_ snmp__load surfboard asterisk_channels foldingathome lpar_cpu ntp_kernel_pll_off postgres_streaming_ snmp__memory swap asterisk_channelstypes foldingathome_rank lpstat ntp_offset postgres_transactions_ snmp__netapp_diskusage_ tcp asterisk_codecs foldingathome_wu mailman ntp_states postgres_tuples_ snmp__netapp_inodeusage_ threads asterisk_meetme forks mailscanner nut_misc postgres_users snmp__netstat tomcat_access asterisk_meetmeusers freeradius_acct mbmon_ nutups_ postgres_xlog snmp__print_pages tomcat_jvm asterisk_sipchannels freeradius_auth memcached_ nut_volts proc snmp__print_supplies tomcat_threads asterisk_sippeers freeradius_proxy_acct meminfo nvidia_ processes snmp__processes tomcat_volume asterisk_voicemail freeradius_proxy_auth memory open_files proc_pri snmp__rdp_users uptime bind9 fw_conntrack mhttping open_inodes proxy_plugin snmp__sensors_fsc_bx_fan users bind9_rndc fw_forwarded_local multiping openvpn ps_ snmp__sensors_fsc_bx_temp varnish_ bonding_err_ fw_packets multips perdition psu_ snmp__sensors_fsc_fan vlan_ buddyinfo haproxy_ multips_memory pgbouncer_connections qmailqstat snmp__sensors_fsc_temp vlan_inetuse_ cmc_tc_sensor_ haproxy_ng munin_stats pgbouncer_requests qmailscan snmp__sensors_mbm_fan vlan_linkuse_ courier_ hddtemp munin_update ping_ qmailscan-simple snmp__sensors_mbm_temp vmstat courier_mta_mailqueue hddtemp2 mysql_ plugin.sh quota_usage_ snmp__sensors_mbm_volt vserver_cpu_ courier_mta_mailstats hddtempd mysql_bytes plugins.history samba snmp__swap vserver_loadavg courier_mta_mailvolume hddtemp_smartctl mysql_innodb pm3users_ selinux_avcstat snmp__uptime vserver_resources cps_ hp2000_ mysql_isam_space_ pop_stats sendmail_mailqueue snmp__users yum cpu http_loadtime mysql_queries port_ sendmail_mailstats snmp__winload zimbra_ cpuspeed if_ mysql_slowqueries postfix_mailqueue sendmail_mailtraffic snmp__winmem cupsys_pages if_err_ mysql_threads postfix_mailstats sensors_ snort_alerts df ifx_concurrent_sessions_ named postfix_mailvolume slapd_ snort_bytes_pkt df_abs interrupts netopia postgres_autovacuum slapd_bdb_cache_ snort_drop_rate df_inode iostat netstat postgres_bgwriter slony_lag_ snort_pattern_match digitemp_ iostat_ios netstat_multi postgres_cache_ smart_ snort_pkts Adding Monitoring Items for Apache Now, let's add a monitoring item for Apache. It can be set up in the following 3 steps. (If you don't have Wordpress, it is often a two-step process) Enable the extended status display for Apache Modify .htaccess description if it is misbehaving (only if necessary) Add monitoring targets to munin Enable Apache extended status display Add the following configuration to the end of /etc/httpd/conf/httpd.conf When /server-status is accessed, it is specified to be handled by the server-status handler. Also, if it can be accessed from outside, there is a security problem, so only access from the local host is allowed. SetHandler server-status Order Deny,Allow Deny from all Allow from localhost Allow from localhost is used for access from munin. If you can access /server-status and get the server status, there is no problem. Since access from the outside is not permitted, check if it is possible to access the server by wget http://localhost/server-status or other means. If you have a CMS such as Wordpress, modify the .htaccess file of the CMS to avoid any problems. Modify .htaccess (only if necessary) URL rewrite settings in /var/www/html/.htaccess may be causing problems. RewriteCond %{REQUEST_URI} ! =//server-status" to exclude the server status acquisition URL from the rewrite. # BEGIN WordPress RewriteEngine On RewriteBase / RewriteRule ^index\.php$ - [L]. RewriteCond %{REQUEST_FILENAME} ! -f RewriteCond %{REQUEST_FILENAME} ! -d RewriteCond %{REQUEST_URI} ! =/server-status RewriteRule . /index.php [L]. Add monitoring target to munin. Just add a symbolic link. You can add monitoring items related to Apache by copying and pasting the following. sudo ln -s /usr/share/munin/plugins/apache_accesses /etc/munin/plugins/apache_accesses sudo ln -s /usr/share/munin/plugins/apache_processes /etc/munin/plugins/apache_processes sudo ln -s /usr/share/munin/plugins/apache_volume /etc/munin/plugins/apache_volume Be sure to restart munin-node after adding the symbolic link. service munin-node restart If the configuration is successful, the apache entry will be added and the graph will begin to be drawn. Conclusion Server monitoring can be easily started using munin. In this example, we specified additional monitoring for Apache, but you can add appropriate plug-ins as needed to build a practical server monitoring system.
thumbnail (i.e. miniature image)

Release of QuizGenerator(beta) with new features of member management and saving grades

We are pleased to announce the release of our new QuizGenerator (beta)! This service has added member management and grade storage. Four major functions of ▼learningBOX  Answer questions】・・・ Solving questions  Create questions】・・・Create and manage 8 types of questions  Save Results】・・・・You can view the results of members.  Create and manage groups and members Outline Since 2011, we have been offering QuizGenerator (https://quizgenerator.net/), a tool that allows users to create free quizzes from text (.txt) files on the web. Thanks to this tool, we have been ranked No. 1 in Google search for keywords such as "quiz creator," and we have been receiving more inquiries than ever before. We believe that the reason why users are using this tool is because it is free for commercial use, anyone can easily create quizzes with text files, and it supports 8 different types of questions such as fill-in-the-blanks and reordering. The applications are as follows, Review materials for students at cram schools. To help students memorize manuals for restaurants. To have new graduates learn basic knowledge in the company The main use of the system is for small-scale applications. One of the questions we received was, "Can you save students' grades?" One of the inquiries we received was, "Can you save the grades of the students? QuizGenerator is a quiz-making software, so it is not possible to save grades by itself. Therefore, in December of last year, we started developing a service that can save QuizGenerator grades, based on the policy of "developing into an e-learning web system that can be introduced by small businesses without difficulty. What we were concerned about was the price. In order to store grades, there are inevitably server costs and other expenses. Normally, e-learning systems are offered at 300-500 yen per account per month. However, we need a service that can be used by small businesses (or divisions of large companies). Therefore, by simplifying and simplifying the question submission system and integrating it into a single quiz management system, we have been able to reduce costs and offer the service at 2,500 yen/month for 11 to 100 accounts (lowest price: 25 yen/month per account). Even if there are 100 employees or students, we hope that this system will be loved by companies that have not been able to afford e-learning until now, because we have made it possible for them to pay only 2,500 yen/month. We hope that this system will be used as an educational system for small and medium-sized companies, as a learning management system for private tutoring schools, and as manual teaching materials for restaurants. Below is the URL of the learningBOX site. Please click here to apply.  ⇒https://lms.quizgenerator.net/ Please take a look. If you have any questions or concerns, please feel free to contact us.