Can't finish Spree deployment of a Spree demo site

[Genís]

Hi

I'm testing spree deployment service and everything goes correct until
the mysql configuration, looks that is something related with database
password or user access rights.

I tried a spree demo deployment, version 1.0.0, app and db on same
machine

The machine is a ubuntu 10.04 server just installed and updated.


The installation seems to go correct until:

notice: /Stage[main]/Mysql::Server/File[/root/.my.cnf]/mode: mode
changed '0644' to '0600'
err: Could not prefetch mysql_database provider 'mysql': #<IO:
0x7fef3e5b4e08>
err: /Stage[main]/Dbserver/Mysql::Database[spree]/
Mysql_database[spree]: Could not evaluate: Execution of '/usr/bin/
mysql mysql -NBe show databases' returned 1: ERROR 1045 (28000):
Access denied for user 'root'@'localhost' (using password: NO)

err: Could not prefetch mysql_user provider 'mysql': #<IO:
0x7fef3e544518>

I then try the update command and doesn't work. The error is:

FACTER_db_pass=password puppet agent --test
info: Creating a new SSL key for aaa.aaaaa.aa
warning: peer certificate won't be verified in this SSL session
info: Caching certificate for ca
warning: peer certificate won't be verified in this SSL session
info: Caching certificate for aaa.aaaaa.aa
err: Could not request certificate: Retrieved certificate does not
match private key; please remove certificate from server and
regenerate it with the current key


What I'm doing wrong?



Genís

[Sean Schofield]

Genis,

Brian is the expert on the deployment service so I'l let him answer
this one. Since you're going to be at SpreeConf you'll be interested
to know he's going to talk about this somewhat in depth. Hopefully he
can answer your question before then.

Sean

> --
> You received this message because you are subscribed to the Google Groups "Spree" group.
> To post to this group, send email to spree...@googlegroups.com.
> To unsubscribe from this group, send email to spree-user+...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/spree-user?hl=en.
>

[Brian Quinn]

It looks like you've got two issues:

1) The mysql provider for puppet seems to be having a problem loading. When you run the "Initialize Configuration" command it actually runs the puppet agent three times as the first time it has to install the mysql puppet provider, and second time can use it to make the necessary mysql changes. All the testing has been done on Racksapce Cloud Servers which are pretty blank to begin with, so I'm wondering if mysql was already installed / configured on this machine before you ran the initialize configuration command? 

2) The " Creating a new SSL key for aaa.aaaaa.aa" error indicates that the hostname doesn't match what you supplied to Deployment Service, the initialize command should reset the FQDN to match but thats failing too for some reason. You can override the actual local FQDN and supply the one you used on the Deployment Service by adding the --certname option as below:

FACTER_db_pass=password puppet agent --test --certname app1.yourdomain.com

My overall recommendation would be to reset the server, ensure that mysql is not already installed and that the hostname matches the intended name. Then re-run the "Initialize Configuration" command.

HTH,

--

Brian Quinn

Co-Founder, CTO

Spree Commerce, Inc.

http://spreecommerce.com

[Genís]

Hi Brian

Thanks for your answer.

1) The machine is a clean ubuntu server 10.04 64 bits minimal
installation, I installed manually wget, nano and SSH. Also updated
the system.
2) Sorry about the  aaa.aaaa.aaa, I changed just for security, its a
true domain with its ip. It doesn't has SSL certificate so. Could this
be the problem?
3) Its on a private virtualized server, I tried two times reseting to
the starting point.
4) I checked on the initial starting point and mysql is not installed


I've found this http://that-matt.com/2010/08/puppet-retrieved-certificate-does-not-match-private-key/
, maybe in Rackspace servers there is a basic package install of
certificates.

Checked again and couldn't complete, got also other errors before,
maybe I dind't see them previously . If you want I can send you the
log by email.

Looking forward to meet you next week.



Thanks again,

Genís

On 12 feb, 17:29, Brian Quinn <br...@spreecommerce.com> wrote:
> It looks like you've got two issues:
>
> 1) The mysql provider for puppet seems to be having a problem loading. When you run the "Initialize Configuration" command it actually runs the puppet agent three times as the first time it has to install the mysql puppet provider, and second time can use it to make the necessary mysql changes. All the testing has been done on Racksapce Cloud Servers which are pretty blank to begin with, so I'm wondering if mysql was already installed / configured on this machine before you ran the initialize configuration command?
>
> 2) The " Creating a new SSL key for aaa.aaaaa.aa" error indicates that the hostname doesn't match what you supplied to Deployment Service, the initialize command should reset the FQDN to match but thats failing too for some reason. You can override the actual local FQDN and supply the one you used on the Deployment Service by adding the --certname option as below:
>
> FACTER_db_pass=password puppet agent --test --certname app1.yourdomain.com
>
> My overall recommendation would be to reset the server, ensure that mysql is not already installed and that the hostname matches the intended name. Then re-run the "Initialize Configuration" command.
>
> HTH,
>
> --
> Brian Quinn
>
> Co-Founder, CTO

> Spree Commerce, Inc.http://spreecommerce.com

>
> On Sunday 12 February 2012 at 02:35, Sean Schofield wrote:
>
>
>
>
>
>
>
> > Genis,
>
> > Brian is the expert on the deployment service so I'l let him answer
> > this one. Since you're going to be at SpreeConf you'll be interested
> > to know he's going to talk about this somewhat in depth. Hopefully he
> > can answer your question before then.
>
> > Sean
>

> > > To post to this group, send email to spree...@googlegroups.com (mailto:spree...@googlegroups.com).
> > > To unsubscribe from this group, send email to spree-user+...@googlegroups.com (mailto:spree-user+...@googlegroups.com).
> > > For more options, visit this group athttp://groups.google.com/group/spree-user?hl=en.

>
> > --
> > You received this message because you are subscribed to the Google Groups "Spree" group.

> > To post to this group, send email to spree...@googlegroups.com (mailto:spree...@googlegroups.com).
> > To unsubscribe from this group, send email to spree-user+...@googlegroups.com (mailto:spree-user+...@googlegroups.com).