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 -~----------~----~----~----~------~----~------~--~---
