The specs pass for me with MySQL. There is a ticket at Lighthouse regarding PostgreSQL (http://insoshi.lighthouseapp.com/projects/9331/tickets/75-postgresql-database-issue#ticket-75-3).
Michael On Tue, May 20, 2008 at 10:27 AM, Michael Hartl <[EMAIL PROTECTED]> wrote: > We're on it. Thanks for letting us know. > > Michael > > On Tue, May 20, 2008 at 9:40 AM, Kless <[EMAIL PROTECTED]> wrote: >> >> 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 -~----------~----~----~----~------~----~------~--~---
