Knowledge Base/Engine Yard Local/Engine Yard Local Bugs

PlannedDoneNot planned

ey-local wants to setup a PG database instead of MySQL

Barnabas Debreczeni
suggested this on November 26, 2012 06:09 AM

Hi,

I am running ey-local up and the command fails with ey-local trying to set up a PostgreSQL despite there's no mention of it anywhere. The project requires MySQL.

Gist here: https://gist.github.com/5859f8308dedbc4e4750

From the gist it can be seen that there's another problem: it tries to set up a database with a dash in the database name. I guess the app name is magically guessed from somewhere. How can I override that?

Host is Mac OS X 10.8.2

VirtualBox: 4.2.4r81684

ey-local: 1.0.2

vagrant: 1.0.5

Thanks!

 

 

Comments

User photo
Keri Meredith
Engine Yard Inc.

Hi Barnabas, Thanks for your input. Our development team is reviewing this now. We'll post an update soon. kjm

[EYL-1]

November 27, 2012 09:57 AM
User photo
Joachim Nolten
viewbook

I am having the same issue.

November 29, 2012 04:50 AM
User photo
Josh Hamilton
Engine Yard Inc.

Hi Barnabas and Joachim,

Engine Yard Local uses our default stack, which consists of PostgreSQL, Passenger 3, Ruby 1.9.3 and a few other components. We're going to offer a release soon that will give you more flexibility with which databases you would like to use. I'll update this as soon as we have that release ready.

Thanks,

Josh

November 29, 2012 09:16 AM
User photo
Mcomm Group
mcomm

Is mySQL yet available in ey-local? I see it failing at db create because the socket is not there.

thanks 

December 08, 2012 06:45 AM
User photo
Pierre Ozoux
PierreO

Same issue for me, I though it was my fault :)

December 10, 2012 09:49 AM
User photo
Josh Hamilton
Engine Yard Inc.

We'll be offering a version of ey-local that will allow you to choose which database you would like to use. Right now the default is PostgreSQL. I'll update as soon as that's available.

Thanks!

December 11, 2012 10:20 AM
User photo
Brian Sullivan
Practical-Evolution-LLC

I am having a problem with the other issue mentioned at the top: ey-local is guessing the application name. Specifically, it is using 'civic' as the app name which I haven't used for a long time. Where is it guessing this from so I can correct it?

 

"engineyard": {
"this": "ey-local",
"environment": {
"apps": [
{
"name": "civic",

December 20, 2012 10:02 PM
User photo
Brian Sullivan
Practical-Evolution-LLC

Here is one way that ey-local is guessing the app name:

It reads it from app_directory/.git/config

from the url for the repo, extracting the repo_name as shown below

url = git@github.com:my_git_account/repo_name.git

 

ey-local is a great idea, but it needs to mature more before it is ready for primetime

December 20, 2012 10:39 PM
User photo
Ches Martin
Admin500

Bummer. Postgres has been the default stack DB for all of a few months now. :-(

February 09, 2013 01:20 PM
User photo
tyler rooney
4ormat

Any update on this? It's been months since this issue was opened. We're blocked on it.

February 17, 2013 09:17 AM
User photo
Josh Hamilton
Engine Yard Inc.

Hi Tyler - there is no update at this time. The default database is still Postgres and we will release a version that will allow you to choose other options. Will update this as soon as that is available.

Thanks!

February 19, 2013 08:56 AM
User photo
Kirk Haines
Engine Yard Inc.

The default for EY Local is to use Postgres, since that is the EY stack default. You can manually change this by changing the /etc/chef/dna.json. Change the 'db_stack_name' to be mysql5_1 or mysql5_5. You will have to then run chef manually, however:

as root:

PATH=/usr/local/ey_resin/bin:/sbin:/bin:/usr/sbin:/usr/bin chef-solo -j /etc/chef/dna.json -c /etc/chef/solo.rb

The main drawback to this approach is that ey-local will overwrite your manually edited dna.json the next time that you do an 'ey-local up'.

The 1.1.0 release of ey-local will allow a number of stack choice options that will make this issue go away.

February 19, 2013 09:16 AM
User photo
Juan F. Pérez
Emergia

I would like to be notified when it is possible to setup MySQL as default.

March 28, 2013 03:01 AM
User photo
Keri Meredith
Engine Yard Inc.

Hi Juan, No problem; by adding a comment to this issue, you are automatically subscribed to updates. We will update this issue when we update the software. thanks! kjm

March 28, 2013 07:28 AM
User photo
Wesley Middaugh
Independent Television Service

I would like to know when ey-local is updated as well.

April 16, 2013 01:59 PM
User photo
Barnabas Debreczeni
TerraCycle

Hi,

 

any news on this?

 

 

thanks.

 

 

Barnabas

April 21, 2013 09:41 AM
User photo
Josh Hamilton
Engine Yard Inc.

Hi Barnabas,

We do not have any updates on changing the default stack at this time. The current method is still to edit the dna.json file and trigger a Chef run. I will update this as soon as we release a version that supports this option from the command line.

Thanks!

April 22, 2013 09:34 AM
User photo
Anthony Crumley
GradesFirst

Hey, 

I think you guys would find some of your client are motivated and capable of helping with this project.  Would you consider providing us with access to the repo so we can fork, enhance and send pull requests?

June 18, 2013 07:25 AM
User photo
Pierre Ozoux
PierreO

Hey!

 

Was thinking about the same, or even put the project in github, and happy forking between us.

But there is no licence in the code, so it means : All rights reserved...

 

Please Engine Yard, do something :) I already have a modified version of the gem on my computer, and I would be very glad to share with other folks!

June 18, 2013 07:29 AM
User photo
Kirk Haines
Engine Yard Inc.

I am personally in favor of this.  I am pursuing the issue as I would be happy to take pull requests and contributions. Stay tuned and I will see what I can find out.

June 18, 2013 10:42 AM
User photo
Josh Hamilton
Engine Yard Inc.

Hi Anthony & Pierre,

We definitely will take this into consideration and are currently looking into this. Will update soon. Thanks!

June 18, 2013 11:03 AM
User photo
Anthony Crumley
GradesFirst

Hey guys,

Is there any update on allowing folks to contribute to ey-local?

Anthony

July 08, 2013 09:20 AM
User photo
Noah Slater
Engine Yard Inc.

Hi,

I'm working with the engineers to figure out how we might best do this.

Thanks!

 

July 08, 2013 09:36 AM
User photo
Pierre Ozoux
PierreO

For those interested, this an attempt for a workaround :)

July 09, 2013 08:54 AM
User photo
Pierre Ozoux
PierreO
July 09, 2013 08:54 AM
User photo
Anthony Crumley
GradesFirst

Noah,

Any update on this?

Anthony

August 09, 2013 06:57 AM
User photo
Joachim Nolten
viewbook

@Pierre: Great stuff, we are already using your patches and will try to contribute something back.

However, we are still looking forward to a more longterm solution from EY.

August 12, 2013 06:55 AM
User photo
Noah Slater
Engine Yard Inc.

We've got the internal go-ahead to open source EY Local. We're just putting together the plan of action now.

August 17, 2013 09:53 AM
User photo
Anthony Crumley
GradesFirst

Awesome!!  Thanks for the update.  :)

August 19, 2013 07:44 AM
User photo
Federico Keen
MUBI

Hi guys, is there any update on this from EY? I'm also having the same problem with the official release. 

October 03, 2013 08:11 AM
User photo
Noah Slater
Engine Yard Inc.

As part of our review of the Engine Yard Local codebase, we concluded that our next generation architecture will allow you to run Engine Yard stacks more easily and directly with minimal tooling. So that’s the new direction we’re going to take. Which is great news! It means that developing locally and deploying to Engine Yard will be simpler than ever.

This also means it no longer makes sense to open source Engine Yard Local in its current form. Instead, we will continue to focus our efforts on our next generation offering, so that we can deliver a new Engine Yard Local capability as soon as possible.

In the meantime, however, we are open to feedback on the current Engine Yard Local version so we can take this into account for the new offering.

October 15, 2013 01:20 AM
User photo
Jason Fowler
ACL US Ltd

If you use a "-" in your app name, such as "my-app", you will get an error while ey-local up tries to set up a default postgresql database.  I don't even want the default database, I am creating multiple databases via chef recipes.  If I find out how to customize the postgresql install, I'll report back to this post.

October 30, 2013 04:34 PM