RE: [Reactor For CF] Hosting and Reactor

[Chris Blackwell]

As I understand it (sure someone will correct me if I’m wrong).. Reactor needs access to the information_schema when running in development mode as it will recheck the table structures and recreate the record/dao/gateways etc. However in production mode it shouldn’t need to access the schema.  I would use the utils/ReactorCompiler.cfc to create all your objects before deploying the application to your host.   As a thought, using reactor in mysql4 mode should still work on mysql5, and wouldn’t require access to the schema, although I’ve not tested this.   Hth, chris   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sam Clement Sent: 13 May 2006 01:51 To: reactor@doughughes.net Subject: Re: [Reactor For CF] Hosting and Reactor   Well, that's interesting, and gives me some hope. I set the app to production mode, ran it locally and uploaded the project files in the Reactor directory.  The app was able to initialise and now it seems that database reads work, but inserts or updates don't.  I get the same error when trying to insert or update.  I guess this begs the question, does Reactor need access to the 'information_schema' database in MySQL to work?  Anyone? Anyway, in the meantime I'll see if I can try a few more things to get it to work. Thanks, Sam On 5/12/06, Brian Rinaldi < [EMAIL PROTECTED]> wrote: I have it working fine at hostmysite. Are you running in production mode? Not sure if this matters, but it might. Sam Clement wrote: Has anyone else tried to get Reactor working at hostmysite.com?  I'm trying to get it to work in a shared environment with MySQL and I'm getting this error: General error: Access denied for user 'myDSN'@'%' to database 'information_schema'   The error occurred in C:\websites\iqqgte\webroot\reactor\data\mysql\ObjectDao.cfc: line 18 When I contacted hostmysite.com they told me that their policy was to not give access to the information_schema database.  Does this make sense?  Is it worth taking up with them? Cheers, Sam -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Brian Rinaldi blog - http://www.remotesynthesis.com/blog ColdFusion Open Source List - http://www.remotesynthesis.com/cfopensourcelist Boston ColdFusion User Group - http://www.bostoncfug.org -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/