mysql exec returning 1 instead of 0
newguy
I am running in to a strange problem, I have a bunch of puppet
modules and one of them has an exec which changes the root password
and there is another which runs mysql import command to import dump
file in to the database, the problem is both these exec are returning
the following error:
err: //par/Exec[root password]/returns: change from notrun to 0
failed: /usr/bin/mysqladmin -u root PASSWORD papa returned 1 instead
of one of [0] at /etc/puppet/environments/development/modules/par/
manifests/init.pp:39
err: //par/Exec[Get db]/returns: change from notrun to 0 failed: /usr/
bin/mysql -uroot -ppapa par < download.sql returned 1 instead of one
of [0] at /etc/puppet/environments/development/modules/par/manifests/
init.pp:35
but still once the catalog has finished I am able to access mysql
through root password ring but there is no database par formed, i have
checked the dump file its correct.
I don't know how to go about this, please help.
newguy
exec {"Retrieve dump":
cwd => "/var/www/r",
command => "/usr/bin/wget http://xyz.com/asc.sql",
timeout => 360,
require=>Class[subversion],
}
exec {"Get db":
cwd => "/var/www/r",
command => "/usr/bin/mysql -uroot -ppapa < asc.sql",
require =>Class[mysql],
}
MYSQL CLASS:
class mysql {
package { "mysql-server-5.1":
ensure=>present,
require=>Class[vim],
}
package {"mysql-client":
ensure=>present,
require=>Class[vim],
}
exec {"root password":
command=>"/usr/bin/mysqladmin -u root PASSWORD papa",
require=>package["mysql-server-5.1"],
Nan Liu
Enable logoutput => on_failure.
> --
> You received this message because you are subscribed to the Google Groups "Puppet Users" group.
> To post to this group, send email to puppet...@googlegroups.com.
> To unsubscribe from this group, send email to puppet-users...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
>
Stefan Schulte
> Here are my Execs, sorry didnt pasted them in the first post:
>
> exec {"Retrieve dump":
> cwd => "/var/www/r",
> command => "/usr/bin/wget http://xyz.com/asc.sql",
> timeout => 360,
> require=>Class[subversion],
> }
>
> exec {"Get db":
> cwd => "/var/www/r",
> command => "/usr/bin/mysql -uroot -ppapa < asc.sql",
> require =>Class[mysql],
> }
>
> MYSQL CLASS:
> class mysql {
> package { "mysql-server-5.1":
> ensure=>present,
> require=>Class[vim],
> }
>
> package {"mysql-client":
> ensure=>present,
> require=>Class[vim],
> }
>
> exec {"root password":
> command=>"/usr/bin/mysqladmin -u root PASSWORD papa",
> require=>package["mysql-server-5.1"],
> }
>
> }
Try to run the command on the command line and check the error code
# /usr/bin/mysqladmin -u root PASSWORD papa
# echo $?
What is the output of both commands? Then you should read the manual
what the returncode of 1 actually means. Normally a returncode that is
not zero indicates an error and that is why puppet complains. If a
returncode of 1 is actually expected when running mysqladmin you can
specify your resource with the returns parameter[1]
exec { 'root password':
command => '/usr/bin/mysqladmin -u root PASSWORD papa',
returns => '1', # or even returns => ['0','1'] to allow both
require => Package['mysql-server-5.1'],
}
[1] http://docs.puppetlabs.com/references/stable/type.html#returns-1
-Stefan
newguy
realize that mysql dump contains bad data, thats why this problem is
occurring, still have no clue about the mysqladmin command
On Jul 20, 12:57 pm, Stefan Schulte <stefan.schu...@taunusstein.net>
wrote:
> > Here are my Execs, sorry didnt pasted them in the first post:
>
> > exec {"Retrieve dump":
> > cwd => "/var/www/r",
