1. Copy the schema.yml to the yourproject/config directory 2. php symfony propel:build-model
3. php symfony cc 4. php symfony configure:database "mysql://root:@localhost/rtdb1" (Suppose you want to make database "rtdb1", Login: root, Password: None) 5. php symfony propel:build-sql 6. mysqladmin -u root -p create rtdb1 (Create the database rtdb1) 7. mysql -u root -p rtdb1 < data/sql/lib.model.schema.sql 8. php symfony propel:insert-sql 9. php symfony propel:build-schema 10. php symfony propel:build-schema --xml On Feb 12, 12:08 pm, Sid Bachtiar <[email protected]> wrote: > Just making sure, have you: > > symfony cc > > or > > symfony cache:clear > > ? > > > > > > On Thu, Feb 12, 2009 at 7:41 PM, Ben Novakovic <[email protected]> wrote: > > > No luck :( > > > On Feb 12, 3:32 pm, Sid Bachtiar <[email protected]> wrote: > >> Try without single quotes for the dsn in databases.yml > > >> On Thu, Feb 12, 2009 at 6:08 PM, Ben Novakovic <[email protected]> > >> wrote: > > >> > Hi everyone, I'm new to symfony and am currently still testing to see > >> > whether it suits my needs. But I don't seem to be getting very far > >> > with that I am doing. > > >> > I'm using the sandbox install on linux, I have the vhost working and > >> > can browse the new demo project that comes with the sandbox install, > >> > but not I would like to try and build an admin panel to an existing > >> > database schema I have. > > >> > I'm trying to run: propel-build-schema like this: > > >> > -------------------------------------- > >> > 04:58:22|b...@dev:/srv/www/sym/sf_sandbox$ ./symfony propel-build- > >> > schema > >> >>> propel Running "reverse" phing task > >> > [propel-schema-reverse] There was an error building XML from metadata: > >> > SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected > > >> > Some problems occurred when executing the task: > >> > Read the logs to fix them > > >> > 04:58:26|b...@dev:/srv/www/sym/sf_sandbox$ > >> > -------------------------------------- > > >> > I'm trying to work out what the problem is, I can only assume its > >> > referring to the fact that it can't find the database I'm wanting to > >> > use. I have the database.yml and propel.ini files setup as per the > >> > documentation > > >> > database.yml: > >> > -------------------------------------- > >> > all: > >> > propel: > >> > class: sfPropelDatabase > >> > param: > >> > phptype: mysql > >> > dsn: 'mysql://user:x...@localhost/dbname' > > >> > propel.ini > >> > -------------------------------------- > >> > propel.database.createUrl = mysql://user:x...@localhost > >> > propel.database.url = mysql://user:x...@localhost/dbname > >> > propel.database.user = user > >> > propel.database.password = xxx > > >> > Am I missing some other config file that needs to be changed too? I > >> > noticed it says I need to rebuild all my models if i change > >> > propel.ini, but I don't have any yet.. I'm trying to create them! > > >> > Any help would be greatly appreciated! > > >> > Cheers, > >> > Ben > > >> -- > >> Blue Horn Ltd - System Developmenthttp://bluehorn.co.nz > > -- > Blue Horn Ltd - System Developmenthttp://bluehorn.co.nz- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
