Rails - Oct 2006 - file upload to MySQL blob on Apache

I have a good question for a guru...

I have a Rails app (of course) that has a page where the visitor uploads 
an image file.  This image file is then saved as a blob in the MySQL 
database.

And, this works.  But.. it only works when I run the application in 
development mode on Webrick.  When I deploy the app to my production 
server with Apache2, then it doesn''t work.  Therein lies my question. 
What am I doing wrong or not doing?

Clearly the code is correct.  When I look at the log files I see the 
same results, except that the production/Apache2 does not have the image 
file being passed as blob type parameter in the SQL statement.

So my suspicion is that the Apache2 is not configured correctly to allow 
the image types.  But what to do?

my httpd.conf is as follows...


<VirtualHost 192.168.xx.xxx:80>
	ServerName localhost.localdomain
	DocumentRoot /var/local/my_app/public/
	ErrorLog /var/local/my_app/log/server.log
	
	<Directory /var/local/my_app/public/>
		Options ExecCGI FollowSymLinks
		AddHandler cgi-script .cgi
		AllowOverride all
		Allow from all
		Order allow,deny
	</Directory>
</VirtualHost>

<IfModule mod_fcgid.c>
   AddHandler fcgid-script .fcgi
   SocketPath /var/lib/apache2/fcgid/sock
   IdleTimeout 3600
   ProcessLifeTime 7200
   MaxProcessCount 8
   DefaultMaxClassProcessCount 2
   IPCConnectTimeout 8
   IPCCommTimeout 60
   DefaultInitEnv RAILS_ENV production
</IfModule>

any help is most appreciated.

Thank You Railers!

Andy Koch


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

solved my own problem,

turns out it was an issue of relative vs. absolute paths

since Webrick runs in the root of the app it was happy with the relative 
file path.  Apache runs elsewhere, as such it required an absolute path.

Hope this helps the next guy...


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---