I've checked Insoshi whith both MySQL, PostgreSQL, and SQLite, and the rake specs only works with SQLite.
Here, you have a config/database.yml example file for PSQL and MySQL: ------------------------------------------- # PostgreSQL. Versions 7.4 and 8.x are supported. # # Install the ruby-postgres driver: # gem install ruby-postgres # On Mac OS X: # gem install ruby-postgres -- --include=/usr/local/pgsql # On Windows: # gem install ruby-postgres # Choose the win32 build. # Install PostgreSQL and put its /bin directory on your path. development: adapter: postgresql encoding: unicode database: insoshi username: Rails password: rails # Connect on a TCP socket. Omitted by default since the client uses a # domain socket that doesn't need configuration. Windows does not have # domain sockets, so uncomment these lines. #host: localhost #port: 5432 # Schema search path. The server defaults to $user,public #schema_search_path: myapp,sharedapp,public # Minimum log levels, in increasing order: # debug5, debug4, debug3, debug2, debug1, # log, notice, warning, error, fatal, and panic # The server defaults to notice. #min_messages: warning # Warning: The database defined as 'test' will be erased and # re-generated from your development database when you run 'rake'. # Do not set this db to the same as development or production. test: adapter: postgresql encoding: unicode database: insoshi_test username: Rails password: rails production: adapter: postgresql encoding: unicode database: insoshi_production username: Rails password: rails ------------------------------------------- ------------------------------------------- # MySQL. Versions 4.1 and 5.0 are recommended. # # Install the MySQL driver: # gem install mysql # On Mac OS X: # sudo gem install mysql -- --with-mysql-dir=/usr/local/mysql # On Mac OS X Leopard: # sudo env ARCHFLAGS="-arch i386" gem install mysql -- --with-mysql- config=/usr/local/mysql/bin/mysql_config # This sets the ARCHFLAGS environment variable to your native architecture # On Windows: # gem install mysql # Choose the win32 build. # Install MySQL and put its /bin directory on your path. # # And be sure to use new-style password hashing: # http://dev.mysql.com/doc/refman/5.0/en/old-client.html development: adapter: mysql encoding: utf8 database: insoshi username: Rails password: rails socket: /var/run/mysqld/mysqld.sock # Warning: The database defined as 'test' will be erased and # re-generated from your development database when you run 'rake'. # Do not set this db to the same as development or production. test: adapter: mysql encoding: utf8 database: insoshi_test username: Rails password: rails socket: /var/run/mysqld/mysqld.sock production: adapter: mysql encoding: utf8 database: insoshi_production username: Rails password: rails socket: /var/run/mysqld/mysqld.sock ------------------------------------------- And to create the data base: ------------- $ mysql -u root -p > create database insoshi; create database insoshi_test; create database insoshi_production; > GRANT ALL PRIVILEGES ON insoshi.* to 'Rails'@'localhost' IDENTIFIED BY 'rails'; > GRANT ALL PRIVILEGES ON insoshi_test.* to 'Rails'@'localhost' IDENTIFIED BY 'rails'; > GRANT ALL PRIVILEGES ON insoshi_production.* to 'Rails'@'localhost' IDENTIFIED BY 'rails'; > \q ------------- ------------- # sudo -u postgres createuser Rails --pwprompt --encrypted \ --superuser --no-createrole --no-createdb # sudo -u postgres createdb insoshi --owner Rails # sudo -u postgres createdb insoshi_test --owner Rails # sudo -u postgres createdb insoshi_production --owner Rails ------------- --~--~---------~--~----~------------~-------~--~----~ Insoshi developer site: http://dogfood.insoshi.com/ Insoshi documentation: http://docs.insoshi.com/ You received this message because you are subscribed to the Google Groups "Insoshi" 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/insoshi?hl=en -~----------~----~----~----~------~----~------~--~---
