I have a very very simple question. How can I use Instiki with MySQL? I downloaded the instiki''s zip and changed "database.yml." What should I do next?
Assuming that in updating database.yml, you''ve also created a MySQL db for Instiki, then you just need to run "rake migrate". If you''re on Windows using the all-in-one bundle zipfile, you may need to do this as: path\to\ruby\bin\ruby.exe path\to\ruby\bin\rake migrate (The rake tool is just a ruby script, and it typically lives in the ruby/bin directory.) -- John On Dec 5, 2006, at 8:39 PM, keiya at kanno.com wrote:> I have a very very simple question. How can I use Instiki with > MySQL? I > downloaded the instiki''s zip and changed "database.yml." What should I > do next? > _______________________________________________ > Instiki-users mailing list > Instiki-users at rubyforge.org > http://rubyforge.org/mailman/listinfo/instiki-users
Thank you very much for your answer. I''m done with migration. Then I runed the "instiki.cmd" and opened the http://localhost:2500/ but only blank page appears. What is wrong? Am I missing something that I should do? John Whitley wrote:> Assuming that in updating database.yml, you''ve also created a MySQL > db for Instiki, then you just need to run "rake migrate". If you''re > on Windows using the all-in-one bundle zipfile, you may need to do > this as: > > path\to\ruby\bin\ruby.exe path\to\ruby\bin\rake migrate > > (The rake tool is just a ruby script, and it typically lives in the > ruby/bin directory.) > > -- John > > On Dec 5, 2006, at 8:39 PM, keiya at kanno.com wrote: > >> I have a very very simple question. How can I use Instiki with >> MySQL? I >> downloaded the instiki''s zip and changed "database.yml." What should I >> do next? >> _______________________________________________ >> Instiki-users mailing list >> Instiki-users at rubyforge.org >> http://rubyforge.org/mailman/listinfo/instiki-users > > _______________________________________________ > Instiki-users mailing list > Instiki-users at rubyforge.org > http://rubyforge.org/mailman/listinfo/instiki-users > > > >
Argh. It occurs to me that I probably left out a step which may have caused the migration to run incorrectly. You need to explicitly tell rake db:migrate to use the production (vs. development) database defined in database.yml. Thus the command should be: ruby rake migrate RAILS_ENV=production (Again, you may need to use full paths for ruby & rake.) If that doesn''t work, check what log files were created in the log/ directory. Check the end of those file(s) for messages that suggest a problem, and post those fragments here if the answer isn''t obvious (e.g. database name misspelled or not created, etc.). -- John On Dec 6, 2006, at 2:37 PM, keiya at kanno.com wrote:> Thank you very much for your answer. > > I''m done with migration. Then I runed the "instiki.cmd" and opened the > http://localhost:2500/ but only blank page appears. What is wrong? > Am I > missing something that I should do? > > John Whitley wrote: >> Assuming that in updating database.yml, you''ve also created a MySQL >> db for Instiki, then you just need to run "rake migrate". If you''re >> on Windows using the all-in-one bundle zipfile, you may need to do >> this as: >> >> path\to\ruby\bin\ruby.exe path\to\ruby\bin\rake migrate >> >> (The rake tool is just a ruby script, and it typically lives in the >> ruby/bin directory.) >> >> -- John >> >> On Dec 5, 2006, at 8:39 PM, keiya at kanno.com wrote: >> >>> I have a very very simple question. How can I use Instiki with >>> MySQL? I >>> downloaded the instiki''s zip and changed "database.yml." What >>> should I >>> do next? >>> _______________________________________________ >>> Instiki-users mailing list >>> Instiki-users at rubyforge.org >>> http://rubyforge.org/mailman/listinfo/instiki-users >> >> _______________________________________________ >> Instiki-users mailing list >> Instiki-users at rubyforge.org >> http://rubyforge.org/mailman/listinfo/instiki-users >> >> >> >> > > _______________________________________________ > Instiki-users mailing list > Instiki-users at rubyforge.org > http://rubyforge.org/mailman/listinfo/instiki-users
Thank you very much John! It worked properly and I started to use it to organize my documents. Also I want to inform you there was a page in instiki.org that explains how to switch Instiki''s database to MySQL http://instiki.org/show/Instiki+and+MySQL Again I want to thank you for your very very particular answer. John Whitley wrote:> Argh. It occurs to me that I probably left out a step which may have > caused the migration to run incorrectly. You need to explicitly tell > rake db:migrate to use the production (vs. development) database > defined in database.yml. Thus the command should be: > > ruby rake migrate RAILS_ENV=production > > (Again, you may need to use full paths for ruby & rake.) > > If that doesn''t work, check what log files were created in the log/ > directory. Check the end of those file(s) for messages that suggest > a problem, and post those fragments here if the answer isn''t obvious > (e.g. database name misspelled or not created, etc.). > > -- John > > > On Dec 6, 2006, at 2:37 PM, keiya at kanno.com wrote: > >> Thank you very much for your answer. >> >> I''m done with migration. Then I runed the "instiki.cmd" and opened the >> http://localhost:2500/ but only blank page appears. What is wrong? >> Am I >> missing something that I should do? >> >> John Whitley wrote: >>> Assuming that in updating database.yml, you''ve also created a MySQL >>> db for Instiki, then you just need to run "rake migrate". If you''re >>> on Windows using the all-in-one bundle zipfile, you may need to do >>> this as: >>> >>> path\to\ruby\bin\ruby.exe path\to\ruby\bin\rake migrate >>> >>> (The rake tool is just a ruby script, and it typically lives in the >>> ruby/bin directory.) >>> >>> -- John >>> >>> On Dec 5, 2006, at 8:39 PM, keiya at kanno.com wrote: >>> >>>> I have a very very simple question. How can I use Instiki with >>>> MySQL? I >>>> downloaded the instiki''s zip and changed "database.yml." What >>>> should I >>>> do next? >>>> _______________________________________________ >>>> Instiki-users mailing list >>>> Instiki-users at rubyforge.org >>>> http://rubyforge.org/mailman/listinfo/instiki-users >>> _______________________________________________ >>> Instiki-users mailing list >>> Instiki-users at rubyforge.org >>> http://rubyforge.org/mailman/listinfo/instiki-users >>> >>> >>> >>> >> _______________________________________________ >> Instiki-users mailing list >> Instiki-users at rubyforge.org >> http://rubyforge.org/mailman/listinfo/instiki-users > > _______________________________________________ > Instiki-users mailing list > Instiki-users at rubyforge.org > http://rubyforge.org/mailman/listinfo/instiki-users