I'll try the reactor compiler and / or the mysql4 solution. I'll post back if either works.
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: [email protected]
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 -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
--
Brian Rinaldi
blog - http://www.remotesynthesis.com/blogColdFusion Open Source List - http://www.remotesynthesis.com/cfopensourcelistBoston ColdFusion User Group - http://www.bostoncfug.org-- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
-- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/-- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
-- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
