Thanks Stèphane, with your link i find to fix my problem. Symfony use for its query the standard socket link in /tmp/mysql.sock for make it running under MAMP and mac user we need to make a symbolic link to the real sock of mysql under MAMP.
For do this just run this: sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /tmp/mysql.sock After this the command: php symfony doctrine:insert-sql make this output and the table are create into db: doctrine created tables successfully Thanks a lot. Il giorno 28/gen/2010, alle ore 17.42, Stéphane ha scritto: > I'm not using MAMP so you might take a look at this thread : > http://forum.symfony-project.org/index.php/t/11364/ > > Hope this helps, > > Cheers, > > Before Printing, Think about Your Environmental Responsibility! > Avant d'Imprimer, Pensez à Votre Responsabilitée Environnementale! > > > On Thu, Jan 28, 2010 at 5:38 PM, Andrea Marin <[email protected]> wrote: > Hi Stèphane, > > thanks i correct my mistake but there are something other wrong. > Now the error change and is: > > Warning: PDO::__construct(): [2002] No such file or directory (trying to > connect via unix:///tmp/mysql.sock) in > /Users/andrea/sfprojects/jobeet/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php > on line 470 > > > PDO Connection Error: SQLSTATE[HY000] [2002] No such file or directory > > How can I fix it? > Thanks Andrea > > Il giorno 28/gen/2010, alle ore 17.32, Stéphane ha scritto: > >> You have an error in your DB DSN declaration. >> >> mysql:host=localhost;dbname=jobeet >> >> It is not a "," but a ";". >> >> Cheers, >> >> >> Before Printing, Think about Your Environmental Responsibility! >> Avant d'Imprimer, Pensez à Votre Responsabilitée Environnementale! >> >> >> On Thu, Jan 28, 2010 at 5:27 PM, Andrea Marin <[email protected]> wrote: >> > What do you have in config/doctrine/schema.yml and in config/ >> > databases.yml ? >> > If you run "symfony doctrine:build --all --and-load --no-confirmation" >> > do you get the same error? >> >> Hi all, >> >> thanks for reply, >> in my config/doctrine/schema.yml I have: >> >> # config/doctrine/schema.yml >> JobeetCategory: >> actAs: { Timestampable: ~ } >> columns: >> name: { type: string(255), notnull: true, unique: true } >> >> JobeetJob: >> actAs: { Timestampable: ~ } >> columns: >> category_id: { type: integer, notnull: true } >> type: { type: string(255) } >> company: { type: string(255), notnull: true } >> logo: { type: string(255) } >> url: { type: string(255) } >> position: { type: string(255), notnull: true } >> location: { type: string(255), notnull: true } >> description: { type: string(4000), notnull: true } >> how_to_apply: { type: string(4000), notnull: true } >> token: { type: string(255), notnull: true, unique: true } >> is_public: { type: boolean, notnull: true, default: 1 } >> is_activated: { type: boolean, notnull: true, default: 0 } >> email: { type: string(255), notnull: true } >> expires_at: { type: timestamp, notnull: true } >> relations: >> JobeetCategory: { onDelete: CASCADE, local: category_id, foreign: id, >> foreignAlias: JobeetJobs } >> >> JobeetAffiliate: >> actAs: { Timestampable: ~ } >> columns: >> url: { type: string(255), notnull: true } >> email: { type: string(255), notnull: true, unique: true } >> token: { type: string(255), notnull: true } >> is_active: { type: boolean, notnull: true, default: 0 } >> relations: >> JobeetCategories: { class: JobeetCategory, refClass: >> JobeetCategoryAffiliate, local: affiliate_id, foreign: category_id, >> foreignAlias: JobeetAffiliates } >> >> JobeetCategoryAffiliate: >> columns: >> category_id: { type: integer, primary: true } >> affiliate_id: { type: integer, primary: true } >> relations: >> JobeetCategory: { onDelete: CASCADE, local: category_id, foreign: id } >> JobeetAffiliate: { onDelete: CASCADE, local: affiliate_id, foreign: >> id } >> >> in config/databases.yml I have >> >> all: >> doctrine: >> class: sfDoctrineDatabase >> param: >> dsn: 'mysql:host=localhost,dbname=jobeet' >> username: root >> password: root >> >> If I run: >> >> "symfony doctrine:build --all --and-load --no-confirmation" >> >> I receive the same error: >> >> Warning: PDO::__construct(): php_network_getaddresses: getaddrinfo failed: >> nodename nor servname provided, or not known in >> /Users/andrea/sfprojects/jobeet/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php >> on line 470 >> >> Warning: PDO::__construct(): [2002] php_network_getaddresses: getaddrinfo >> failed: nodename nor servn (trying to connect via >> tcp://localhost,dbname=jobeet:3306) in >> /Users/andrea/sfprojects/jobeet/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php >> on line 470 >> >> >> PDO Connection Error: SQLSTATE[HY000] [2002] php_network_getaddresses: >> getaddrinfo failed: nodename nor servname provided, or not known >> >> I try to delete all and re-install all symfony and MAMP but I have the same >> problem. >> >> Il giorno 28/gen/2010, alle ore 15.04, Tom Ptacnik ha scritto: >> >> -- >> You received this message because you are subscribed to the Google Groups >> "symfony users" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/symfony-users?hl=en. >> >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "symfony users" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/symfony-users?hl=en. > > > -- > You received this message because you are subscribed to the Google Groups > "symfony users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/symfony-users?hl=en. > > > -- > You received this message because you are subscribed to the Google Groups > "symfony users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/symfony-users?hl=en. -- You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en.
