Tag Archives: development

Step-by-step quick installation of Redmine + SVN on Windows

Through trial and error, I have done a quick setup of Redmine + SVN on Windows.  This does not use Apache and WebDAV.  The Ruby on Rails webserver, Mongrel, is used, and SVN is accessed through svnserve (svn://).  If you need a full deployment of Redmine, with automatic generation of SVN repositories and SVN accounts, this can be a starting point (let me know how you got it to work!).  If you want a quick and dirty setup, this may be the only guide you need!

Here are the steps:

  1. Go to http://rubyonrails.org/download
  2. Install Ruby
  3. Install RubyGems
  4. Run [ gem install rails ]
  5. Run [ gem install mysql ]  (in case we want to use mysql as db, sqlite is fine though)
  6. Run [ gem install rake ]
  7. Run [ gem install sqlite3-ruby ]
  8. Extract redmine (I extracted to C:\Ruby\redmine-0.8.4)
  9. Browse to redmine folder/config
  10. Copy database.yml.example to database.yml
  11. Set database options for production:
    1. In production:
      1. adapter: sqlite3
      2. dbfile: db/prod.db
      3. host: localhost
  12. Get sqlite3.dll from sqlite 3 distribution (http://www.sqlite.org) and put in Ruby/bin directory
  13. Browse to Redmine directory in command prompt
  14. Run [ rake db:migrate RAILS_ENV=”production” ]
  15. Run [ rake redmine:load_default_data RAILS_ENV=”production” ]
  16. Run [ gem install mongrel ]
  17. Run [ gem install mongrel_service ]
  18. Run [ mongrel_rails service::install -N Redmine_Server -D “Redmine Server on Mongrel” -e “production” ]
  19. Start service and set to “Automatic”
  20. Username: admin Password: admin
  21. Refer to http://www.redmine.org/wiki/redmine/RedmineInstall for SMTP config (If you want emails generated for tickets, etc.)
  22. Install CollabNet SVN as svnservice (WebDAV not needed), svn root C:\svn_repository
  23. Start service “CollabNet Subversion svnserve”
  24. Run [ svnadmin create c:\svn_repository ]
  25. Uncomment anon-access = read, auth-access = write, password-db = passwd in svnserve.conf
  26. Add users to Redmine, have user change password to whatever they want it to
  27. Add users to passwd (same username), all plaintext, so create random passwords for each user and have them record it (cannot be changed unless requested by admin, and admin will know what pw is)
  28. Restart Redmine_Server service
  29. Create subfolders for projects, and trunk/tags/branches for each project
  30. Add svn://localhost/projectname as project root for each project in Redmine
VN:F [1.9.22_1171]
Rating: 4.8/5 (4 votes cast)
VN:F [1.9.22_1171]
Rating: +4 (from 4 votes)

Wrapper classes for using SQLite on iPhone/Cocoa

Information on using SQLite for local storage on Cocoa isn’t all that easy to find. The best resource, as always, is Google, and you can find a few tutorials with step by step instructions and code samples on how to use it. Well, here’s another basic step by step set of instructions, but rather than including code samples, I have written a couple of wrapper classes for creating databases, making queries, and getting results.


1: Include the SQLite framework in your project. It’s usually located somewhere like “/Developer/Platforms/iPhoneOS.platform/Developer/SDKs/iPhoneOS2.1.sdk/usr/lib/libsqlite3.0.dylib” (why is developer in there twice?)

2: Create a base sqlite database file, and modify SQLite.m so that the filename method refers to it. Place it in your main resource path. This will be copied out of your bundle into your application’s Documents directory. If you need help on creating one of these and managing it, there is a fantastic FireFox extension that does it for you!

3: Add the source files to your project.

Usage can be as simple as:

SQLiteResult *result = [SQLite query:@"SELECT * from test;"];
NSArray *row = [result.rows objectAtIndex:0];
NSString *firstValue = [row objectAtIndex:0];

NSArray columnNames contains NSStrings of all the names.
NSArray columnTypes contains NSStrings of all the types.
NSArray rows contains NSArrays, where each of these contains NSStrings of all the row values in that row.

Attached Files:

VN:F [1.9.22_1171]
Rating: 4.5/5 (11 votes cast)
VN:F [1.9.22_1171]
Rating: +5 (from 7 votes)