Database Config and Automatic Table Creation

Hey James Langridge

Easy and clear solution, great that you shared it!

Cheers!

I was getting these errors with this command: ./bin/console doctrine:database:create

In AbstractMySQLDriver.php line 115: An exception occured in driver: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
In PDOConnection.php line 47: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
In PDOConnection.php line 43: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'

And this worked for me:

$ sudo mysql -u root -p
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<enter_a_password_here>';
mysql> exit
$ sudo service mysql stop
$ sudo service mysql start

make sure database_user in parameters.yml is root
make sure database_password in parameters.yml is the password you just set in mysql

$ ./bin/console doctrine:database:create
Created database `aqua_note` for connection named default

I found the solution here: https://stackoverflow.com/q...

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.

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, I keep getting this error after following every step on the internet. I can connect to the MySql server using the command mysql -u root -p. when I run the "status" command I get the information that the user is root@localhost
But when i run the command: php bin/console doctrine:database:create, I keeping getting this error:

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

This is my configuration file for doctrine.
app/config/packages/doctrine.yml:

parameters:
database_host: localhost
database_name: article_data
database_user: root
database_password: password
env(DATABASE_URL): 'mysql://%database_user%:%database_password%@localhost:3306/%database_name%'

doctrine:
dbal:
# configure these for your database server
server_version: '5.7'
charset: utf8mb4
default_table_options:
charset: utf8mb4
collate: utf8mb4_unicode_ci

url: '%env(resolve:DATABASE_URL)%'
orm:
auto_generate_proxy_classes: true
naming_strategy: doctrine.orm.naming_strategy.underscore
auto_mapping: true
mappings:
App:
is_bundle: false
type: annotation
dir: '%kernel.project_dir%/src/Entity'
prefix: 'App\Entity'
alias: App


would appreciate if someone can help me out.

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

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!

If you did not have MySql already installed on Mac I found 2 good resources.
https://youtu.be/q9S51sykd1A
and
https://stackoverflow.com/q...

Hey @Tom

Yeah, in order to make that command to work, you have to create a user in your DB server and give him some privileges (if needed). I'm glad to hear that you could fix your problem :)

Cheers!

Update: I solved it. I think my issue was that I had been editting parameters.yml.dist as well as parameters.yml. Oh, and I also used "localhost" for the database_host, as suggested by the symfony 3.4 documentation: https://symfony.com/doc/3.4...

For anyone still stuck at this, this is the thing that worked for me:

In parameters.yml:

parameters:
database_host: localhost
database_port: null
database_name: aqua_notenote
database_user: root
database_password: password
secret: ThisTokenIsNotSoSecretChangeIt

In Genus.php, I tried AppBundle\Controller\Entity. Don't do this! Just keep it like this:

namespace AppBundle\Entity;

Hello,

I'm dealing with some issues while trying to run the $ ./bin/console doctrine:database:create command. The error I keep getting is:

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

[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)

[PDOException]
SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)

I have tried the other things out in the comment section but I still can't get it to work. Could I get some help with this? I'm using MariaDB by the way.

Hey Szymon Chomej!

So, it's basically *not* possible for the user to create an entity. In theory it's possible, but it's not how Doctrine is meant to work - so probably not a good solution to investigate :).

And unfortunately, Doctrine doesn't really have any support for what you're trying to do: there is no easy way to create a relationship that can link one table to many other tables. The *simplest* way to do this, is to create a "fake" relationship - e.g. add two columns to your entity: "relation_id" and "relation_type". Here, you would store the id of the related row (in relation_id) and the "name" of the other table that it is related to (in relation_type). But, you would be handling all of this manually, so it's not a super pretty solution.

I wish I could offer more help! Good luck!

Hello.

In my database i have the same table for diffrent product - i mean the structure of table is the same but i have diffrent name for each table.
The tables are create by website user.

Is it possible in Doctrine to link one entity to many tables in database?
Or is it possible to create entity with php script? - then user could make entity and tables in database.

Hey Bikash,

Wow, nice discover then! Actually, I have never used Kali Linux OS, but that's a bit weird behavior. Anyway, I'm glad you nailed it ;)

And thanks for sharing it with other users!

Cheers!

Hi,
No, i donot use any kind of virtualisation
I have kali linux os installed on my laptop
I tried every possible solution that i found in internet but none of them were effective
At the end i just tried to give this a shot and hurrah!! DATABASE created

Hey Bikash Singh ,

Thanks for sharing it with others, it could be really helpful for someone.

P.S. That's interesting that localhost works for you but 127.0.0.1 don't, in most cases it's the reverse. But probably you use some kind of virtualization like Docker, VirtualBox, etc. In this case it really might be.

Cheers!

I got the same problem while creating database
I am using mariaDB
But it did solve when i changed to

database_host: localhost

instead of 127.0.0.1

Note: I know your problem is solved , but i posted if anyone like me comes here can try this

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...

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

Thank's all
:)

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 ?...

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/curr...

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 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 !

thX for your replay. I restarted the PC and now everything's working fine. I have php 5.6, 7.0 and 7.1.
I only installed 7.0 and 7.1 but 5.6 is somewhere in the system altough I can't run it beacuse I changed the "php" command to php 7.1. Anyway, I'm trying to figure out what happened but now everything's working after a restart.

:D

Hey Ali,

It's weird! For Doctrine you need to have pdo_mysql extension - you can check it with "$ php -m | grep pdo". To install it for PHP 7.1 you need to run "sudo apt-get install php7.0-mysql". I suppose "php-mysql" is a legacy extension for a different PHP 5.x version . Also double check you have "database_driver: pdo_mysql" in your app/config/parameters.yml and better use IP address instead of localhost for DB host: "database_host: 127.0.0.1".

Btw, do you have only PHP 7.0 installed? I mean do you have other installed PHP version? Probably in Nginx/Apache virtual host configs you point to the wrong (old) PHP-FPM socket.

If you're using Symfony - you can find your PHP version and "View phpinfo()" link in the right corner of Symfony Web Debug Toolbar. Click the link to see all loaded PHP extensions and try to find pdo_mysql there.

TL;DR In shorts, you don't need to install "php-mysql", it should work just with "php7.0-mysql", but you need to debug why it doesn't work.

P.S. Don't forget to clear the cache - it could cause some unexpected behavior in prod environment :)

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

Hey there,
so I've got a problem, when I run:
./bin/console doctrine:database:create
I get:
[Doctrine\DBAL\Exception\DriverException]
An exception occured in driver: could not find driver

[Doctrine\DBAL\Driver\PDOException]
could not find driver

[PDOException]
could not find driver

I just need to mention that I have other projects on my system and they are all working fine with msql.
I mean php7.0-mysql is installed and working.
I'll be glad if anyone can help me with this.

Hey jian su

I don't think you can do that by only using doctrine's schema, but if you are using GIT or any other version control, you can move to a previous commit with the desired schema, and then run "doctrine:schema:update", that should do the trick, but you have to be extra careful because you might end up losing your data (Making a backup would be wise)

Cheers!

Hi Guys:

Is it possible to roll back you doctrine schema. I know you are going to introduce Doctrine Migrations bundle for the following lesson. But my old project doesn't have Doctrine Migrations bundle, and I want to roll back it back. How do I do that?



 app/console doctrine:schema:rollback --force    //Does it work?

Ha! The smaller the bug, the tougher it is to find :D. Glad you spotted it!

Yep. You got it.

When I went to fix that, I noticed my major mistake (which you had referenced in other comments, but I just keept not seeing in my code): I had created the Entity folder in the wrong location. ***facepalm***

Thank you!

Hey Tony!

This is one of those errors that can have several causes, and they're all really subtle. In this case, I can see the problem (thank you for posting this good code!): the namespace in Genus should be AppBundle\Entity In theory, I think Doctrine could probably throw an error, instead of silently not finding your class, but there may be some subtle reason why it's not able to do that.

Update this namespace and you should be golden :).

Cheers!

Nice to see you're on top of things! ^_^

Hey Tony!

I think it's a good idea! We have a thread in our backlog internally already about making the setup / requirements instructions even more robust and error-proof than now. I've just added this to that discussion.

Cheers!

Another case of "No Metadata Classes to process".

`doctrine:database:create` worked correctly, which I verified from mysql CLI.

But, `doctrine:schema:update` does not seem to see any of the entities.

to simplify:

#\app\config\config.yml
```yml
doctrine:
    dbal:
        driver:   pdo_mysql
        host:     127.0.0.1
        port:     3306
        dbname:   aqua_note
        user:     root
        password: ***
        charset:  UTF8

// \src\AppBundle\Entity\Genus.php

namespace Entity;

use Doctrine\ORM\Mapping as ORM;
//use Doctrine\ORM\Mapping\MappedSuperclass as ORM;

/**
* @ORM\Entity
* @ORM\Table(name="genus")
*/
class Genus
{
    /**
    * @ORM\Id
    * @ORM\GeneratedValue(strategy="AUTO")
    * @ORM\Column(type="integer")
    */
    private $id;

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

I'm noticing a trend in these tuts. Each one assumes a certain subset of software is already installed. Ch1: Php, PhpStorm, Git; Ch2: composer. Ch2: mysql. Perhaps you could start each tut with a *Requirements* section?

Hey @Hunte!

I'm pretty sure I just replied to you via email, but for others, here's the short answer:

1) Delete one of the use statements - you should only have use Doctrine\ORM\Mapping as ORM;
2) Make sure all of your use statements start with @ORM\, like @ORM\Id or @ORM\Column

The use statement "as ORM" should correspond with how your annotations start "@ORM". Ultimately, these work like normal use statements - the ultimately point to a class. In other words, when you say @ORM\Column you are actually referring to a real class: Doctrine\ORM\Mapping\Column

Cheers!

I can't run the bin/console doctrine:schema:update --dump-sql without getting an error: Compile Error: Cannot use Doctrine\ORM\Mapping as ORM because the name is already in use

This is because I am using the following
use Doctrine\ORM\Mapping\Column as ORM;
use Doctrine\ORM\Mapping as ORM;

but if I remove either, I get this error:

[Doctrine\Common\Annotations\AnnotationException]
[Semantical Error] The annotation "@Doctrine\ORM\Mapping" in property AppBundle\Entity\Genus::$id does not exist, or could not be auto-loaded.

Hey Michael,

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

Cheers!

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 Teolan!

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!

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) :

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

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.

Hi again Boran!

Hmm, let's try clearing out your database entirely and starting from scratch:

bin/console doctrine:database:drop --force
bin/console doctrine:database:create
bin/console doctrine:migrations:migrate

Let me know if that works! This error can happen if somehow the genus table (or any other tables) were added to your database via some method *other* than running your migrations, e.g. by running doctrine:schema:update. When this happens, it looks like you have *not* run any of your migrations (because you haven't), so it tries to run all of your migrations, but has an error when the genus table already exists. The trick is to keep a good workflow where you never run doctrine:schema:update and always use doctrine:migrations:migrate to keep your database structure updated.

Cheers!

hi weaverry ,

could you please help me in this issue , when i try to make doctrine:migration:migrate
i get the below error :

Error An exception occurred while executing 'CREATE TABLE genus (id INT AUTO_INCREMENT NOT NULL, sub_family_id INT NOT NULL, name VARCHAR(255) NOT NULL, species_count INT NOT NULL, fun_fact VARCHAR(255) DEFAULT NULL, is_published TINYINT(1) NOT NULL, first_discovered_at DATE NOT NULL, INDEX IDX_38C5106ED15310D4 (sub_family_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB':

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'genus' already exists

thanks ,

Yo Boran!

If that doesn't work, it could also be a "mysql.sock" problem, which is where your php.ini setting of "pdo_mysql.default_socket" points to a socket location (e.g. /tmp/mysql.sock), but your MySQL server creates the socket file somewhere else. This is kind of annoying, because different installations of MySQL put the mysql.sock file in different places, so you need to do some digging to find it, and then update your php.ini file (you can find its location by running php --ini from the command line and look for "Loaded Configuration File").

Cheers!

Hey Boran,

Try to change your `database_host` in parameters.yml to the "127.0.0.1" instead of "localhost" which is by default, it should help. Let me know if it still doesn't work.

Cheers!

hey guys ,,

I am getting this error every time I run $ ./bin/console doctrine:database:create

./bin/console doctrine:database:create

[Doctrine\DBAL\Exception\ConnectionException]
An exception occured in driver: SQLSTATE[HY000] [2002] No such file or dire
ctory

[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[HY000] [2002] No such file or directory

[PDOException]
SQLSTATE[HY000] [2002] No such file or directory

doctrine:database:create [--shard SHARD] [--connection [CONNECTION]] [--if-not-exists] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] <command>

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!

btw the yml files are properly indented.

Hi there,

I am getting this error every time I run $ ./bin/console doctrine:database:create

[Doctrine\DBAL\Exception\ConnectionException]
An exception occured in driver: SQLSTATE[HY000] [2002] Connection refused

[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[HY000] [2002] Connection refused

[PDOException]
SQLSTATE[HY000] [2002] Connection refused

doctrine:database:create [--shard SHARD] [--connection [CONNECTION]] [--if-not-exists] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] <command>

However, my configurations are as follow below;

config.yml

# Doctrine Configuration
doctrine:
dbal:
default_connection: default
connections:
default:
driver: pdo_mysql
dbname: "%database_name%"
user: "%database_user%"
host: "%database_host%"
password: "%database_password%"
unix_socket: /tmp/mysql.sock
charset: UTF8

parameters.yml

parameters:
database_host: 127.0.0.1
database_port: null
database_name: aqua_note
database_user: root
database_password: null
secret: 0b719bbdb89bd1ce9774b1069c9696d8ce3f1b08

mailer_transport: smtp
mailer_host: 127.0.0.1
mailer_user: ~
mailer_password: ~

Can someone please help? I will really appreciate it.

Thanks!

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!

Hi.

I've been struggling with this part for a few days now and I've reached a point where i simply cant figure it out on my own.
I changed the settings for my local connection in parameter.yml, but i kept getting an error saying access denied to root@localhost password: no. No matter what I put in parameter.yml this was my response.
I changed my root password to null and boom. It worked. i could run doctrine:database:create however... It creates a DB called 'symfony' even though I changed the db_name first in parameter.yml and then hardcoded in config.yml.

When i then try to run doctrine:schema:update --dump-sql it results in an error saying "No Metadata Classes to process."

My EntityClass looks like this:

namespace AppBundle\Entity;


use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity
 * @ORM\Table(name="blog_posts")
 */
class Post
{
    /**
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     * @ORM\Column(type="integer")
     */
    private $id;

    /**
     * @ORM\Column(type="string", length=100)
     */
    private $title;

    /**
     * @ORM\Column(type="text")
     */
    private $description;

    /**
     * @ORM\Column(type="text")
     */
    private $content;

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

}

And I've trying to change the config.yml to contain this under orm:

orm:
        auto_generate_proxy_classes: "%kernel.debug%"
        naming_strategy: doctrine.orm.naming_strategy.underscore
        auto_mapping: true
        mappings:
                AppBundle:
                    type: annotation
                    is_bundle: false
                    dir: %kernel.root_dir%/../src/AppBundle/Entity/
                    prefix: AppBundle\Entity
                    alias: AppBundle

The directory structure is as shown throughout these great tutorials :)
I hope you can help me resolve this, or clearify the error for me. Which seems to me like the changes made in/for config.yml ain't being saved for some reason.?

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,
I'm really new to Symfony and have been really enjoying these tutorials. I have come across a problem and was wondering if you can point me in the right direction. I am using Sqlite and had to do do a few things differently to create a table. Under app, resources, I created a database directory and within that a 'aqua_note_database' as a datasource. Ran the ./bin/console doctrine:database:create and yay it created a database. But when you did 'mysql -u root ...', i tried to compensate with 'sqlite -u root...' and it is not recognizing the command.

my question is, having to use sqlite, is the way I created a database ok? and what is the command for '-u root..'?

Thank you :)

Great tip - I use it too and love it!

I find it very usefull to use https://github.com/bamarni/.... This way you dont have to look at some reference all the time when dealing with ./bin/console :)

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 :)

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

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 ^_^

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!

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

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've wandered off the beaten path a little and managed to get...not an error as such (Techincally) But I am getting this "No Metadata Classes to process."... any ideas? This is my PHP

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.

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!

Hello everyone. I used to use wamp for development, everything I know is self learning and I only dev for my pleasure.

I'm using the server that symfony provides. I installed MySql, the database have been created and it seem to be working. The only thing is that I can't use 'mysql' as a command line so I tried to add that path:"C:\Program Files\MySQL\MySQL Server 5.7\bin" to my environnement variables but it still doesn't work. Any idea ? Btw I'm on Windows 8.1.

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!

Hi thank you for this, is there any problem to use utf8mb4 charset, in annotation i found that you can add collation info in table annotation like this:
@ORM\Table(name="genus", options={"collate"="utf8mb4_general_ci", "charset"="utf8mb4"})
is it a good practice or some kind of black magic?

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!

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!

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 as I launch the ./bin/console doctrine:database:create I get this error :"[Doctrine\DBAL\Exception\ConnectionException]

An exception occured in driver: SQLSTATE[HY000] [2002] Connection refused

[Doctrine\DBAL\Driver\PDOException]

SQLSTATE[HY000] [2002] Connection refused

[PDOException]

SQLSTATE[HY000] [2002] Connection refused

"
Can someone help me out with that? I guess there are probably some problems with my parameters. I'm not using MAMP by the way.
this are my parameters:

parameters:
database_host: 127.0.0.1
database_port: ~
database_name: aqua_note
database_user: root
database_password: null
mailer_transport: smtp
mailer_host: 127.0.0.1
mailer_user: null
mailer_password: null
secret: 03b3f955112e8fd6629f3379f556cd72c9008251