1) not a puppet problem
2) run initdb
On Oct 10, 2011 7:47 PM, "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.
>
>
--
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.
