Hello.
This is my mysql-server.pp file, both master and client are runing
ubuntu.
--------------------
class mysql-server {
package { "mysql-server": ensure => installed }
package { "mysql-client": ensure => installed }
service { "mysql":
enable => true,
ensure => running,
require => Package["mysql-server"],
}
file { "/etc/mysql/my.cnf":
owner => "mysql", group => "mysql",
source => "puppet:///modules/mysql-server/my.cnf",
notify => Service["mysql"],
require => Package["mysql-server"],
}
exec { "set-mysql-password":
unless => "mysqladmin -uroot -psecret",
path => ["/bin", "/usr/bin"],
command => "mysqladmin -uroot password secret",
require => Service["mysql"],
}
exec { "set-nagios-password":
unless => "mysqladmin -unagiostest -psecret",
path => ["/bin", "/usr/bin"],
command => "mysqladmin -unagiostest password secret",
require => Service["mysql"],
}
}
-----------------------------------
When I run /etc/init.d/mysql start sql doesnt run
Code:
root@cloneubuntu:/var/log/mysql# date
Mon Oct 10 19:32:56 PDT 2011
root@cloneubuntu:/var/log/mysql# /etc/init.d/mysql start
Rather than invoking init scripts through /etc/init.d, use the
service(8)
utility, e.g. service mysql start
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the start(8) utility, e.g. start mysql
start: Job is already running: mysql
root@cloneubuntu:/var/log/mysql# cat /var/log/mysql/error.log
root@cloneubuntu:/var/log/mysql# ps ax | grep sql
4797 pts/0 S+ 0:00 grep --color=auto sql
root@cloneubuntu:/var/log/mysql# cat /etc/mysql/my.cnf
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
user = mysql
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
skip-external-locking
bind-address = 0.0.0.0
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
myisam-recover = BACKUP
query_cache_limit = 1M
query_cache_size = 16M
log_error = /var/log/mysql/error.log
expire_logs_days = 10
max_binlog_size = 100M
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer = 16M
!includedir /etc/mysql/conf.d/
root@cloneubuntu:/var/log/mysql#
However when i run mysqld alone, it works
Code:
root@cloneubuntu:/var/log/mysql# date
Mon Oct 10 19:34:21 PDT 2011
root@cloneubuntu:/var/log/mysql# mysqld &
[1] 4815
root@cloneubuntu:/var/log/mysql# cat /var/log/mysql/error.log
111010 19:34:30 [Note] Plugin 'FEDERATED' is disabled.
111010 19:34:30 InnoDB: Started; log sequence number 0 44233
111010 19:34:30 [Note] Event Scheduler: Loaded 0 events
111010 19:34:30 [Note] mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.10' socket: '/var/run/mysqld/mysqld.sock'
port: 3306 (Ubuntu)
root@cloneubuntu:/var/log/mysql# ps ax | grep sql
4815 pts/0 Sl 0:00 mysqld
4830 pts/0 S+ 0:00 grep --color=auto sql
root@cloneubuntu:/var/log/mysql# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.41-3ubuntu12.10 (Ubuntu)
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
mysql>
I cannot reinstall mysql, I have a feeling it's an issue with the
init.d script or somethign along those lines.
Please help :S
--
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.
