syslog-ng: Plugin module not found … module=’afsql’

 I encountered the error

“Plugin module not found in ‘module-path’; module-path=’/lib64/syslog-ng’, module=’afsql’
this article describes how I fixed it.

After updating syslog-ng and restarting it this happened:

[root /etc] #>/etc/rc.d/init.d/syslog-ng restart
Stopping syslog-ng: [ OK ]
Plugin module not found in 'module-path'; module-path='/lib64/syslog-ng', module='afsql'
Starting syslog-ng: Plugin module not found in 'module-path'; module-path='/lib64/syslog-ng', module='afsql' [ OK ]

After some search I found that I had to install the syslog-ng-libdbi package for enabling SQL support:

[root /etc] #>yum install syslog-ng-libdbi
Loaded plugins: fastestmirror
Setting up Install Process
Loading mirror speeds from cached hostfile

Resolving Dependencies
--> Running transaction check
---> Package syslog-ng-libdbi.x86_64 0:3.2.5-4.el6 will be installed
--> Processing Dependency: libdbi.so.0()(64bit) for package: syslog-ng-libdbi-3.2.5-4.el6.x86_64
--> Running transaction check
---> Package libdbi.x86_64 0:0.8.3-4.el6 will be installed
--> Finished Dependency Resolution
...
...
...
Total download size: 70 k
Installed size: 144 k
Is this ok [y/N]: y
Downloading Packages:
(1/2):libdbi-.8.3-4.el6.x86_64.rpm
(2/2): syslog-ng-libdbi-.2.5-4.el6.x86_64.rpm
-----------------------------------------------------------------
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : libdbi-0.8.3-4.el6.x86_64
  Installing : syslog-ng-libdbi-.2.5-4.el6.x86_64
  Verifying  : libdbi-0.8.3-4.el6.x86_64
  Verifying  : syslog-ng-libdbi-3.2.5-4.el6.x86_64
Installed:
  syslog-ng-libdbi.x86_64 0:3.2.5-4.el6
Dependency Installed:
  libdbi.x86_640:0.8.3-4.el6
Complete!

Restarting the syslog-ng deamon will now have no errors:

[root /etc] #>/etc/rc.d/init.d/syslog-ng restart
Stopping syslog-ng:                                        [  OK  ]
Starting syslog-ng:                                        [  OK  ]

Continue reading syslog-ng: Plugin module not found … module=’afsql’

Example MySQL my.cnf optimized

 

[client]
	port = 3306
	socket = /var/run/mysqld/mysqld.sock
	# This was formally known as [safe_mysqld]. Both versions are currently parsed.
	[mysqld_safe]
	socket = /var/run/mysqld/mysqld.sock
	nice = 0
	syslog
	[mysqld]
	# Basic Settings
	user = mysql
	pid-file = /var/run/mysqld/mysqld.pid
	socket = /var/run/mysqld/mysqld.sock
	port = 3306
	basedir = /usr
	datadir = /var/lib/mysql
	tmpdir = /tmp
	lc-messages-dir = /usr/share/mysql
	skip-external-locking
	# Engine
	default-storage-engine = InnoDB
	# Listening IP
	bind-address = 0.0.0.0
	# Safety
	max-connect-errors = 1000000
	max_allowed_packet = 64M
	skip-name-resolve
	sysdate-is-now = 1
	innodb = FORCE
	innodb-strict-mode = 1
	wait_timeout = 60
	interactive_timeout = 60
	# Buffers
	sort_buffer_size = 4M
	read_buffer_size = 2M
	join_buffer_size = 8M
	read_rnd_buffer_size = 16M
	thread_concurrency = 8 # Max CPU * 2
	# MyISAM
	key-buffer-size = 32M
	myisam-recover = FORCE,BACKUP
	myisam_sort_buffer_size = 64M
	# CACHES AND LIMITS #
	tmp-table-size = 128M
	max-heap-table-size = 128M
	query-cache-type = 0
	query-cache-size = 0
	query_cache_limit = 1M
	max-connections = 5000
	thread-cache-size = 50
	thread_stack = 192K
	open-files-limit = 65535
	table-definition-cache = 1024
	table-open-cache = 2048
	# Bin logs
	binlog-format = ROW
	log-bin = /var/lib/mysql/mysql-bin
	log-slave-updates = 1
	expire-logs-days = 5
	sync-binlog = 1
	max_binlog_size = 100M
	server-id = 1 # randomize it incase of multiple servers
	# InnoDB
	innodb-buffer-pool-size = 2048M
	innodb_buffer_pool_instances = 8
	innodb_additional_mem_pool_size = 20M
	innodb_log_buffer_size = 8M
	innodb-log-files-in-group = 2
	innodb-log-file-size = 256M
	innodb-file-per-table = 1
	innodb-flush-log-at-trx-commit = 1
	innodb-flush-method = O_DIRECT
	# With virtual synchrony redundancy, make write queries faster
	innodb_doublewrite = 1
	# This is a recommended tuning variable for performance
	innodb_locks_unsafe_for_binlog = 1
	# LOGGING
	general_log_file = /var/log/mysql/mysql.log
	log-error = /var/log/mysql/mysql-error.log
	log-queries-not-using-indexes = 1
	[mysqldump]
	quick
	quote-names
	max_allowed_packet = 16M
	[isamchk]
	key_buffer = 16M
	#
	# * IMPORTANT: Additional settings that can override those from this file!
	# The files must end with '.cnf', otherwise they'll be ignored.
	#
	!includedir /etc/mysql/conf.d/

Continue reading Example MySQL my.cnf optimized