[chef] Re: Re: Re: Re: mysql recipe on ubuntu

[Raphael Bauduin < >]

On Mon, Aug 22, 2011 at 12:54 PM, Ranjib Dey 
<
 >
 wrote:
>
>
> On Mon, Aug 22, 2011 at 2:57 PM, Raphael Bauduin 
> <
 >
>  wrote:
>>
>> Hi Madhurranjan,
>>
>> On Thu, Aug 18, 2011 at 8:20 PM, Madhurranjan Mohaan
>> <
 >
>>  wrote:
>> > Hi Raphael,
>> > Not sure if this would help your case but this is more for a centos
>> > installation .We had trouble to make sure that we assign the password
>> > only
>> > the first time and do certain checks. Basically we wanted it to be
>> > idempotent. We used something to this effect:. It wouldn't enter this
>> > block
>> > if mysql server was already installed and we added definitions to
>> > create/delete DBs and modify passwords.
>>
>> thanks, but this does not apply to my problem. I need the recipe to
>> wait until the mysql server is ready.
>>
>> Raph
>>
>>
> Hi Raph,
> you can use this ruby_block resource for that:
>
> ruby_block "wait for mysql to come up" do
>  block do
>   my_sock = TCPSocket.new('127.0.0.1', 3306)
>         readable = IO.select([my_sock], nil, nil, 5)
>         if readable
>           puts ("mysql  accepting connections on  banner is
> #{my_sock.gets}")
>           true
>         else
>           false
>         end
>       rescue
>           Chef::Log.info ("mysql is not awake after 5 seconds ")
>       ensure
>         my_sock && my_sock.close
>       end
>  end
> end
>
> but this block is not idempotent, and will be executed in every run, you may
> use the not_if {`ps --no-headers -C mysqld`} to make this idempotent  , or
> set the action to :nothing and notify this resource from some other resource
> with action run.
>
> hope this helps
> ranjib

Thanks ranjib, I'll give this a try!

raph


>
>> > if ! File.exists?("/var/lib/mysql/mysql/user.MYD")
>> >   package "mysql-server" do
>> >         action :install
>> >   end
>> >   service "mysqld" do
>> >         action [:start,:enable]
>> >   end
>> >   execute "creating 'mysqladmin' required files at '/var/lib/mysql'" do
>> >     command "/etc/init.d/mysqld restart >> /tmp/mysql.log"
>> >   end
>> >   execute "set_password" do
>> >     command "<set password>"
>> >   end
>> > end
>> > thanks
>> > Madhurranjan
>> > On Thu, Aug 18, 2011 at 1:52 PM, Raphael Bauduin 
>> > <
 >
>> > wrote:
>> >>
>> >> Hi,
>> >>
>> >> I'm using the mysql recipe (
>> >> https://github.com/opscode/cookbooks/tree/master/mysql ;) with vagrant
>> >> and ubuntu 10.04.
>> >> The problem I encounter is that this code
>> >>
>> >> execute "mysql-install-privileges" do
>> >>  command "/usr/bin/mysql -u root
>> >> #{node['mysql']['server_root_password'].empty? ? '' : '-p'
>> >> }#{node['mysql']['server_root_password']} < #{grants_path}"
>> >>  action :nothing
>> >>  subscribes :run, resources("template[#{grants_path}]"), :immediately
>> >> end
>> >>
>> >> is run when the mysql daemon is not yet ready. In my own recipe, I
>> >> have put this code to wait for mysqld:
>> >>
>> >> execute "wait for mysql" do
>> >>  action :run
>> >>  command "i=0 && while ! ps ax | grep mysqld | grep -v grep ; do echo
>> >> \"waiting.... $i\" >> /tmp/debug ; sleep 1; i=$((i+1)); [ $i -eq 29 ]
>> >> && break; done ;  sleep 5; exit 0"
>> >> end
>> >>
>> >> but this approach won't work as mysql-install-privileges is run by a
>> >> "subscribes :run".
>> >>
>> >> Is there a way to tell an execute block to wait for a certain
>> >> condition? Or am I doing something wrong here, as the recipe is
>> >> indicated as being tested with ubuntu 10.04?
>> >>
>> >> Thanks
>> >>
>> >> raphaël
>> >
>> >
>>
>>
>>
>> --
>> Web database: http://www.myowndb.com
>> Free Software Developers Meeting: http://www.fosdem.org
>
>



-- 
Web database: http://www.myowndb.com
Free Software Developers Meeting: http://www.fosdem.org