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>   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

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...