I'm having the same problem in Ubuntu Oneiric 11.10 64-bit.
It seems puppet runs this command:
debug: Service[mysql](provider=debian): Executing '/etc/init.d/mysql
status'
which outputs :
$ /etc/init.d/mysql status
Rather than invoking init scripts through /etc/init.d, use the
service(8)
utility, e.g. service mysql status
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the status(8) utility, e.g. status mysql
mysql stop/waiting
Using:
status => '/usr/sbin/service mysql status',
still doesn't solve the problem.
I'm still confused..
On Oct 11 2011, 9:47 am, John Bower <olympus.sta...@gmail.com> wrote:
> 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 puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.
