Database Config and Automatic Table Creation

Hi 3amprogrammer
is work also for a Windows operating system?

I miss this step:
Add the following line at the end of your shell configuration file (~/.bash_profile or ~/.zshrc) :

Hey Teo!

Yes and no. That library definitely won't be able to give you auto-completion for Windows cmd prompt. BUT, if you use Cygwin, I believe it's supported - here is some information about the bash_profile file with Cywgin: http://cs.nyu.edu/~yap/prog...

I hope this helps you get it working!

Great tip - I use it too and love it!

Hey Sara,

Thanks for sharing it with others. I'd personally prefer to install MySQL with Homebrew as well as PHP, web servers, and other console things :)

Cheers!

Yep this was me. I brewed up some MySQL and the Doctrine create command worked perfectly.

FWIW I had the same issue with the metadata error message, and my problem was the namespace incorrectly ended up as src\AppBundle\Entity. Removing the src\ prefix corrected the issue. Likely not the problem you were having, but for the sake of contributing in case anyone else bumps their head against this, I figured it was worth sharing.

Hey Michael,

I think it's worth! Thanks for sharing it ;)

Cheers!

Hey Kaiser!

Ok, let's get you fixed up :). My guess is that you had one error, and may have caused other little errors while debugging the first. If we straighten everything out, we should be good! So let's look at each thing, one-by-one.

First, about the database password. Obviously, it turns out that you don't have a password, which is why null worked. But, I agree that it's a little weird that when you *did* add a password, it still said password NO, instead of password YES. But honestly, I would just ignore that if it's working, because I'm guessing there was some small misconfiguration causing this confusion. I just tried locally - if I set my password to something, I get an access denied password YES.

Second, about the database name. This seems similar to the database password! It seems that we're having some configuration confusion somewhere, but I'm not sure where. As you already know (based on your comment), when you set database_name in parameters.yml, this only works because that parameter is referenced in config.yml, under the doctrine.dbal.dbname key. So, if you are setting that key directly - which I know you tried - then there's other magic happening: this *should* set the database name. The fact that you're having this problem and the password problem makes me wonder if there isn't - somehow - some other database configuration somewhere else. Look in all of the files in app/config for a "doctrine" root key. In short: your configuration is not behaving as it should. And although you should not need to ever do this, you should try clearing your cache (bin/console cache:clear) just in case. Also, are you using a VM? I'm trying to think if it's possible that you're editing the files, but they're not actually updating on your VM (or something). It just doesn't make sense!

Finally, about the "No Metadata Classes to Process". Assuming you have normal, default doctrine configuration (which, we're not sure is true at this point!) then this only happens if your entity class has a bug in it. Things to check:

A) That your class matches your filename (so, Post.php)
B) That the file lives in the Entity directory and the namespace is correct (your namespace IS correct)
C) That there is an <?php tag on top (this happens more often than you would think!)
D) That your annotations have /** (with two stars) - you're good here too!

But also, remove the "mappings" config key you added. I'm guessing you did this while trying to debug, but it's not necessary: the auto_mapping: true above tells Doctrine to look in the Entity/ directory of all of your bundles :).

Phew! Ok, let me know what you find out!

Hey Oda

That's weird! I can think of a couple of reasons:
1) You may have installed a very old version of the Doctrine bundle, so perhaps you could upgrade it and try again
2) Something weird happened when installing your vendors, try removing the vendor directory and run composer install

Cheers!

Hey james-langridge

Easy and clear solution, great that you shared it!

Cheers!

Hey Oscar

For some reason you are trying to access to the DB as "db_user" user but in your parameters I see you defined "database_user" as "root". So, probably you are overriding the "database_user" parameter in somewhere. But, you should define an environment variable for your DB connection

// .env
DATABASE_URL=mysql://root:password@127.0.0.1:3306/db_name

Cheers!

Hey, THANK YOU. I didn't check to see if the .env file existed so everytime I ran the database creation command, the default DATABASE_URL in the file was been used instead of the parameters I specified. Thanks so much.

Hi Claire!

Welcome to Symfony! :) You did a great job creating the database in sqlite. In fact, in the future, you might even be able to do a little less work - you shouldn't need to create the aqua_note_database file - Doctrine should even create that when you run doctrine:database:create :).

But anyways, one tricky thing with sqlite is that it doesn't have a fancy "mysql" command line tool. There a few GUI tools for visualizing an SQLite database (just google for them - I don't have a favorite, and they're dependent on your OS). OR, there is a better idea :). Symfony has an bin/console command that will make a raw SQL query for you. Try this:

bin/console doctrine:query:sql 'DESCRIBE genus'

It's not quite as convenient as the "mysql" utility, since you need to prefix everything with the "bin/console doctrine:query:sql", but it works awesome!

Let me know if it helps!

Hi there!

I'm not *too* good with Windows, unfortunately :). But, I can tell you that you should be able to execute the mysql command using the *long* version, even if your path isn't setup correclty:

C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql

Also, you can cheat! Symfony has a console command that allows you to run queries through it:

php bin/console doctrine:query:sql "DESCRIBE genus"

I hope that helps!

ok. I found what was my problem. The thing is I'm using cmder and I thought it was able to read path variables, which is not true. I just add to create aliases. Anayway thanks for your answer Ryan.

namespace AppBundle\Entiry;

use Doctrine\ORM\Mapping as ORM;

/**
* @ORM\Entity
* @ORM\Table(name="posts")
*/
class Posts {

/**
* @ORM\Id
* @ORM\GeneratedValue(stratergy="AUTO")
* @ORM\Column(type="interger")
*/
private $id;

/**
* @ORM\Column(type="string")
*/
private $name;

I'm guessing it can't spot my variables... but I have no idea how to resolve this >.>

Yo!

Yep, you're thinking about it correctly. I'm guessing you get this error if you run the doctrine:schema:update command, or generally try to do anything related to Doctrine? Here's how it works:

1) When the system loads, Doctrine needs to know about *all* of the entities in the system.
2) By default, it looks in the Entity directory of all of your bundles and looks inside any classes there for the annotations

So, the error you're getting is basically Doctrine saying "Hi! I don't see any annotated classes in your Entity directory".

So, a few things to check for:

1) Make sure you have the <?php tag in your Entity class. This sounds silly - but it's actually the most common thing to forget :)

2) Make sure your directory is called Entity exactly

3) Though I would have expected a different error, you do have a typo in your namespace - you have Entiry - change that to Entity :).

Let me know how it goes!

Ah, man! A cliff hanger!! Any chance I can get the rest of your thoughts on this? :p Glad to see I was on the right path, anyway ^_^

Oh man, lame! I didn't realize my message got cut off! I just updated it above - my <php killed the message at first :).

Glad you got it working - and good working using PhpStorm :)

Hi peons :),

Is there a way to change the default behaviour of Doctrine and make it look in another directory than "Entity".
I mean I want my enteties Classes in another directory...
I tried the mapping options but it didn't do the job.
May
you provide an exemple of the config portion of the Doctrine mapping I
could use to tell doctrine than the entity classes are not in the
default 'Entity' directory. The one that should be in :
./src/AppBundle/Entity

But look in another directory let's say :
./src/AppBundle/LetsSayMyEntity

I tried this :

doctrine:

[...]

orm:
auto_generate_proxy_classes: "%kernel.debug%"
naming_strategy: doctrine.orm.naming_strategy.underscore
auto_mapping: true
mappings:
AppBundle:
mapping: true
type: annotation
dir: LetsSayMyEntity
alias: AppBundle

Thank you all !

Hey Abou

Is totally possible what you want to achieve, actually there are two ways you can do it, changing the mapping inside a bundle (your case), or outside a bundle
I'll leave you here the link to the docs if you want to dive deeper http://symfony.com/doc/current/reference/configuration/doctrine.html#custom-mapping-entities-in-a-bundle

For your case, you will have to do something like this:

// config.yml
doctrine:
    orm:
        auto_mapping: true
        mappings:
            AppBundle:
                type: annotation
                dir: LetsSayMyEntity

In this case, doctrine will look inside AppBundle/LetsSayMyEntity folder

I hope it helps you :)
Cheers!

Hi diego,

Thank you for your answer !

But the snippet of code you gave me is the exact same code I posted as tryed. It doesn't do the job as I said...

Do you have any idea of what could be wrong, maybe elsewhere my implementation ?...

Ah... I think I shouldn't use 'auto_mapping' set to 'true'... I'll give it try later ;)

Thank's all
:)

I don't think that's the case, because below that, you are overriding the default values

Oh sorry, it is kind of dificult to see without a format :)

Hmm, it should work that way, check that you are using the right namespaces for your entities
You could try to use the other type of configuration, outside of a bundle http://symfony.com/doc/curr...

Don't worry. What ever I did fixed it. I think it helps that I'm using PHPstorm now, too =p

Hey Marco!

Hmm, connection refused us when there is no database running on the server. Do you have MySQL installed? Alternatively, you could use Sqlite, which doesn't require to have a database running. There are instructions in the config.yml file for how to use Sqlite, but here is a gist if it helps: https://gist.github.com/wea.... But, installing/starting MySQL is also a good idea :).

Cheers!

Hello,
I guess I installed mySQL now I'm getting a different error

[Doctrine\DBAL\Exception\ConnectionException]

An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)

some help anyone please :)
thank you

Hey Marco!

Ah, this is a good step forward! The database is now running, and you're using the user "root", but the password is incorrect. The correct password depends on how you installed mysql - a common option is either a blank password (that's the default in parameters.yml) *or* "root" also for the password. Check the documentation for how you installed it and then update parameters.yml and try again.

You're close!

After fighting with the same error as Marco and not finding a solution, I thought I'd share mine here:
I am running Symfony from Ubuntu, and in the parameters.yml file, I actually needed to specify the Ubuntu root password that I had set on initializing the OS. So that row in parameters.yml is not set to null, but looks something like this:
database_password: XYZ123
Hope I could help some fellow newbies.

Thanks for sharing Andrea! The password is *usually* null on MySQL installs... but certainly not always - an important detail indeed!

Hi Yoni!

I don't see any problem with this. In fact, it's important to make sure that your tables use utf8 in the beginning (changing them later is a pain!). I usually create my database with a utf8 charset, and then let my tables inherit that from the database. However, if you do what you have here, then you will definitely not have any problems.

But actually, you can also set this globally. See the "Setting up the Database to be UTF8" title under this section: http://symfony.com/doc/curr...

That's the way to go :)

Cheers!

btw the yml files are properly indented.

Hey fmm8 ,

There're could be a few reasons, but the all of them are related to invalid DB credentials. Please, double check your MySQL credentials like port, login, password, etc. Is your MySQL server running? Have you tried successfully to connect to the MySQL database in other project? Or probably connection to a DB with PhpMyAdmin, MySQL Workbench or similar utility? Which credentials do you use there?

Cheers!

OK! this is wired. I installed:
sudo apt-get install php-mysql
and everything is working now!!
but...
what is the difference between "php7.0-mysql" and "php-mysql" ?!?! Why I can have both installed at the same time!

and then...
I was using MYSQL Workbench before, and I have a connection to to the localhost. There are 3 databases there and I just added anotherone using symfony's Doctrine.

However, I can't see it with MYSQL Workbench, but when I check it through the terminal, it's there! :|
what is going on?! :))

BTW, I'm still getting this error when I try to put some data in the database from a controller:
Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occured in driver: could not find driver