bonjour,
j'ai un petit soucis avec le tuto askeet.
http://www.symfony-project.com/askeet/en/2
tout fonctionne bien jusqu'a l'insertion du shema en BDD
en fait c'est a l'étape juste avant que ça coince, tout semble
fonctionner mais je n'ai pas de fichier data/sql/schema.sql de créé.
j'ai tout copié collé, si quelqu'un a une idée...
[EMAIL PROTECTED] ~ $ symfony init-project jazz
>> dir+ /home/jazz/batch
>> dir+ /home/jazz/test
>> dir+ /home/jazz/test/unit
>> dir+ /home/jazz/test/functional
>> dir+ /home/jazz/test/bootstrap
>> file+ /home/jazz/test/bootstrap/unit.php
>> file+ /home/jazz/test/bootstrap/functional.php
>> dir+ /home/jazz/log
>> dir+ /home/jazz/web
>> dir+ /home/jazz/web/images
>> dir+ /home/jazz/web/js
>> file+ /home/jazz/web/.htaccess
>> file+ /home/jazz/web/robots.txt
>> dir+ /home/jazz/web/uploads
>> dir+ /home/jazz/web/uploads/assets
>> dir+ /home/jazz/web/css
>> file+ /home/jazz/web/css/main.css
>> dir+ /home/jazz/plugins
>> dir+ /home/jazz/config
>> file+ /home/jazz/config/propel.ini
>> file+ /home/jazz/config/schema.yml
>> file+ /home/jazz/config/databases.yml
>> file+ /home/jazz/config/properties.ini
>> file+ /home/jazz/config/rsync_exclude.txt
>> file+ /home/jazz/config/config.php
>> dir+ /home/jazz/cache
>> dir+ /home/jazz/data
>> dir+ /home/jazz/data/model
>> dir+ /home/jazz/data/sql
>> dir+ /home/jazz/doc
>> dir+ /home/jazz/lib
>> dir+ /home/jazz/lib/model
>> dir+ /home/jazz/apps
>> file+ /home/jazz/symfony
>> tokens /home/jazz/config/propel.ini
>> tokens /home/jazz/config/properties.ini
>> tokens /home/jazz/config/propel.ini
>> tokens /home/jazz/config/config.php
>> chmod 777 /home/jazz/cache
>> chmod 777 /home/jazz/log
>> chmod 777 /home/jazz/web/uploads
>> chmod 777 /home/jazz/symfony
>> chmod 777 web/uploads/assets
[EMAIL PROTECTED] ~ $ symfony init-app frontend
>> dir+ /home/jazz/apps/frontend/config
>> file+ /home/jazz/apps/frontend/config/view.yml
>> file+ /home/jazz/apps/frontend/config/security.yml
>> file+ /home/jazz/apps/frontend/config/app.yml
>> file+ /home/jazz/apps/frontend/config/cache.yml
>> file+ /home/jazz/apps/frontend/config/i18n.yml
>> file+ /home/jazz/apps/frontend/config/factories.yml
>> file+ /home/jazz/apps/frontend/config/routing.yml
>> file+ /home/jazz/apps/frontend/config/config.php
>> file+ /home/jazz/apps/frontend/config/settings.yml
>> file+ /home/jazz/apps/frontend/config/logging.yml
>> file+ /home/jazz/apps/frontend/config/filters.yml
>> dir+ /home/jazz/apps/frontend/i18n
>> dir+ /home/jazz/apps/frontend/lib
>> file+ /home/jazz/apps/frontend/lib/myUser.class.php
>> dir+ /home/jazz/apps/frontend/templates
>> file+ /home/jazz/apps/frontend/templates/layout.php
>> dir+ /home/jazz/apps/frontend/modules
>> tokens /home/jazz/apps/frontend/config/settings.yml
>> file+ /home/jazz/web/index.php
>> file+ /home/jazz/web/frontend_dev.php
>> tokens /home/jazz/web/index.php
>> tokens /home/jazz/web/frontend_dev.php
>> chmod 777 /home/jazz/cache
>> chmod 777 /home/jazz/log
>> chmod 777 /home/jazz/web/uploads
>> chmod 777 /home/jazz/symfony
>> chmod 777 web/uploads/assets
>> dir+ /home/jazz/test/functional/frontend
[EMAIL PROTECTED] ~ $
je cree le fichier config/schema.xml et je verifie que je ne me suis pas
trrompé ds le nom de fichier :
[EMAIL PROTECTED] ~ $ cat config/schema.xml
<?xml version="1.0" encoding="UTF-8"?>
<database name="propel" defaultIdMethod="native" noxsd="true">
<table name="ask_question" phpName="Question">
<column name="id" type="integer" required="true" primaryKey="true"
autoIncrement="true" />
<column name="user_id" type="integer" />
<foreign-key foreignTable="ask_user">
<reference local="user_id" foreign="id"/>
</foreign-key>
<column name="title" type="longvarchar" />
<column name="body" type="longvarchar" />
<column name="created_at" type="timestamp" />
<column name="updated_at" type="timestamp" />
</table>
<table name="ask_answer" phpName="Answer">
<column name="id" type="integer" required="true" primaryKey="true"
autoIncrement="true" />
<column name="question_id" type="integer" />
<foreign-key foreignTable="ask_question">
<reference local="question_id" foreign="id"/>
</foreign-key>
<column name="user_id" type="integer" />
<foreign-key foreignTable="ask_user">
<reference local="user_id" foreign="id"/>
</foreign-key>
<column name="body" type="longvarchar" />
<column name="created_at" type="timestamp" />
</table>
<table name="ask_user" phpName="User">
<column name="id" type="integer" required="true" primaryKey="true"
autoIncrement="true" />
<column name="nickname" type="varchar" size="50" />
<column name="first_name" type="varchar" size="100" />
<column name="last_name" type="varchar" size="100" />
<column name="created_at" type="timestamp" />
</table>
<table name="ask_interest" phpName="Interest">
<column name="question_id" type="integer" primaryKey="true" />
<foreign-key foreignTable="ask_question">
<reference local="question_id" foreign="id"/>
</foreign-key>
<column name="user_id" type="integer" primaryKey="true" />
<foreign-key foreignTable="ask_user">
<reference local="user_id" foreign="id"/>
</foreign-key>
<column name="created_at" type="timestamp" />
</table>
<table name="ask_relevancy" phpName="Relevancy">
<column name="answer_id" type="integer" primaryKey="true" />
<foreign-key foreignTable="ask_answer">
<reference local="answer_id" foreign="id"/>
</foreign-key>
<column name="user_id" type="integer" primaryKey="true" />
<foreign-key foreignTable="ask_user">
<reference local="user_id" foreign="id"/>
</foreign-key>
<column name="score" type="integer" />
<column name="created_at" type="timestamp" />
</table>
</database>[EMAIL PROTECTED] ~ $
[EMAIL PROTECTED] ~ $ symfony propel-build-schema
Buildfile: /usr/share/php/symfony/vendor/propel-generator/build.xml
[resolvepath] Resolved /home/jazz/config to /home/jazz/config
propel-project-builder > check-project-or-dir-set:
propel-project-builder > check-project-set:
propel-project-builder > set-project-dir:
propel-project-builder > check-buildprops-exists:
propel-project-builder > check-buildprops-for-propel-gen:
propel-project-builder > check-buildprops:
propel-project-builder > configure:
[echo] Loading project-specific props from /home/jazz/config/propel.ini
[property] Loading /home/jazz/config/propel.ini
propel-project-builder > creole:
[phing] Calling Buildfile
'/usr/share/php/symfony/vendor/propel-generator/build-propel.xml' with
target 'creole'
[property] Loading
/usr/share/php/symfony/vendor/propel-generator/./default.properties
propel > creole:
[echo] +-----------------------------------------------+
[echo] | |
[echo] | Generating XML from Creole connection ! |
[echo] | |
[echo] +-----------------------------------------------+
[propel-creole-transform] Propel - CreoleToXMLSchema starting
[propel-creole-transform] Your DB settings are:
[propel-creole-transform] driver : (default)
[propel-creole-transform] URL : mysql://localhost/jazz
[propel-creole-transform] There was an error building XML from metadata:
connect failed [Native Error: Access denied for user
\'root\'@\'localhost\' (using password: NO)] [User Info: Array]
[propel-creole-transform] Propel - CreoleToXMLSchema finished
BUILD FINISHED
Total time: 0.4005 seconds
>> schema putting /home/jazz/config/schema.yml
>> file- /home/jazz/config/schema.xml
[EMAIL PROTECTED] ~ $ symfony propel-build-schema
Buildfile: /usr/share/php/symfony/vendor/propel-generator/build.xml
[resolvepath] Resolved /home/jazz/config to /home/jazz/config
propel-project-builder > check-project-or-dir-set:
propel-project-builder > check-project-set:
propel-project-builder > set-project-dir:
propel-project-builder > check-buildprops-exists:
propel-project-builder > check-buildprops-for-propel-gen:
propel-project-builder > check-buildprops:
propel-project-builder > configure:
[echo] Loading project-specific props from /home/jazz/config/propel.ini
[property] Loading /home/jazz/config/propel.ini
propel-project-builder > creole:
[phing] Calling Buildfile
'/usr/share/php/symfony/vendor/propel-generator/build-propel.xml' with
target 'creole'
[property] Loading
/usr/share/php/symfony/vendor/propel-generator/./default.properties
propel > creole:
[echo] +-----------------------------------------------+
[echo] | |
[echo] | Generating XML from Creole connection ! |
[echo] | |
[echo] +-----------------------------------------------+
[propel-creole-transform] Propel - CreoleToXMLSchema starting
[propel-creole-transform] Your DB settings are:
[propel-creole-transform] driver : (default)
[propel-creole-transform] URL : mysql://localhost/jazz
[propel-creole-transform] There was an error building XML from metadata:
connect failed [Native Error: Access denied for user
\'root\'@\'localhost\' (using password: NO)] [User Info: Array]
[propel-creole-transform] Propel - CreoleToXMLSchema finished
BUILD FINISHED
Total time: 0.4009 seconds
[EMAIL PROTECTED] ~ $ symfony propel-build-model
>> schema converting "/home/jazz/config/schema.yml" to XML
>> schema putting /home/jazz/config/generated-schema.xml
Buildfile: /usr/share/php/symfony/vendor/propel-generator/build.xml
[resolvepath] Resolved /home/jazz/config to /home/jazz/config
propel-project-builder > check-project-or-dir-set:
propel-project-builder > check-project-set:
propel-project-builder > set-project-dir:
propel-project-builder > check-buildprops-exists:
propel-project-builder > check-buildprops-for-propel-gen:
propel-project-builder > check-buildprops:
propel-project-builder > configure:
[echo] Loading project-specific props from /home/jazz/config/propel.ini
[property] Loading /home/jazz/config/propel.ini
propel-project-builder > om:
[phing] Calling Buildfile
'/usr/share/php/symfony/vendor/propel-generator/build-propel.xml' with
target 'om'
[property] Loading
/usr/share/php/symfony/vendor/propel-generator/./default.properties
propel > check-run-only-on-schema-change:
propel > om-check:
propel > om:
[echo] +------------------------------------------+
[echo] | |
[echo] | Generating Peer-based Object Model for |
[echo] | YOUR Propel project! (NEW OM BUILDERS)! |
[echo] | |
[echo] +------------------------------------------+
[phingcall] Calling Buildfile
'/usr/share/php/symfony/vendor/propel-generator/build-propel.xml' with
target 'om-template'
[property] Loading
/usr/share/php/symfony/vendor/propel-generator/./default.properties
propel > om-template:
[propel-om] Target database type: mysql
[propel-om] Target package: lib.model
[propel-om] Using template path:
/usr/share/php/symfony/vendor/propel-generator/templates
[propel-om] Output directory: /home/jazz
[propel-om] Processing: generated-schema.xml
[propel-om] Processing Datamodel : JoinedDataModel
[propel-om] - processing database : propel
[propel-om] + ask_question
[propel-om] -> BaseQuestionPeer [builder: SfPeerBuilder]
[propel-om] -> BaseQuestion [builder: SfObjectBuilder]
[propel-om] -> QuestionMapBuilder [builder: SfMapBuilderBuilder]
[propel-om] -> QuestionPeer [builder: SfExtensionPeerBuilder]
[propel-om] -> Question [builder: SfExtensionObjectBuilder]
[propel-om] + ask_answer
[propel-om] -> BaseAnswerPeer [builder: SfPeerBuilder]
[propel-om] -> BaseAnswer [builder: SfObjectBuilder]
[propel-om] -> AnswerMapBuilder [builder: SfMapBuilderBuilder]
[propel-om] -> AnswerPeer [builder: SfExtensionPeerBuilder]
[propel-om] -> Answer [builder: SfExtensionObjectBuilder]
[propel-om] + ask_user
[propel-om] -> BaseUserPeer [builder: SfPeerBuilder]
[propel-om] -> BaseUser [builder: SfObjectBuilder]
[propel-om] -> UserMapBuilder [builder: SfMapBuilderBuilder]
[propel-om] -> UserPeer [builder: SfExtensionPeerBuilder]
[propel-om] -> User [builder: SfExtensionObjectBuilder]
[propel-om] + ask_interest
[propel-om] -> BaseInterestPeer [builder: SfPeerBuilder]
[propel-om] -> BaseInterest [builder: SfObjectBuilder]
[propel-om] -> InterestMapBuilder [builder: SfMapBuilderBuilder]
[propel-om] -> InterestPeer [builder: SfExtensionPeerBuilder]
[propel-om] -> Interest [builder: SfExtensionObjectBuilder]
[propel-om] + ask_relevancy
[propel-om] -> BaseRelevancyPeer [builder: SfPeerBuilder]
[propel-om] -> BaseRelevancy [builder: SfObjectBuilder]
[propel-om] -> RelevancyMapBuilder [builder:
SfMapBuilderBuilder]
[propel-om] -> RelevancyPeer [builder: SfExtensionPeerBuilder]
[propel-om] -> Relevancy [builder: SfExtensionObjectBuilder]
BUILD FINISHED
Total time: 0.8680 seconds
>> file- /home/jazz/config/generated-schema.xml
[EMAIL PROTECTED] ~ $
=>Pas de fichier data/sql/schema.sql de créé :
[EMAIL PROTECTED] ~ $ cat data/sql/schema.sql
cat: data/sql/schema.sql: Aucun fichier ou répertoire de ce type
[EMAIL PROTECTED] ~ $
la je coince, quelqu'un a déjà eu le cas ?
--~--~---------~--~----~------------~-------~--~----~
Vous avez reçu ce message, car vous êtes abonné au groupe Groupe "Symfony-fr"
de Google Groupes.
Pour transmettre des messages à ce groupe, envoyez un e-mail à
l'adresse [email protected]
Pour résilier votre abonnement à ce groupe, envoyez un e-mail à
l'adresse [EMAIL PROTECTED]
Pour afficher d'autres options, visitez ce groupe à l'adresse
http://groups.google.com/group/symfony-fr?hl=fr
-~----------~----~----~----~------~----~------~--~---
