William Jones

Thanks

I have options for a select field from 2 sources (this years options and last years options). In the drop down list I would like to distinguish the options between the sources (e.g. this years options with a green background, last years with a pink background).

Thanks.

It turns out to be really easy. Just click and hold over the email attachment and drop it on the choose file button on the file field on the application and let go of the mouse button. That's it.

I have a rails application that can upload an image using CarrierWave and MiniMagick and a file_field. This seems to be the usual way to do things and works well. I have a user that wants to open an email that has an image attachment and drag and drop that image into my application. This would be quicker than them downloading the email attachment and then attaching it in the application from the download folder. Is there an easy way to code this?

Thanks for your help.

Thanks Daniel. There is a bit of paranoia amongst management here about storing company data outside the network. We have plenty of storage on the company servers, I am just not sure how to access the images if they are not stored in the Rails app. Do you know of any way to do that?

I have a Rails app that lets users select an invoice from a list of invoices. When selected a view of the image of the invoice is displayed with an image of the customer signature overlayed on top. This is all working well with the test invoice and signature images I am using (9 of each). They are all kept in the app/assets/images folder. However the production data contains hundreds of thousands of invoice and signature images. What is best practise for storing these images so they are accessible by the Rails app?

Hello Chris,
I am only using Puma or Passenger, definitely not both at the same time. When using Puma I start the rails server (i.e rails s -e production) from the application directory and the pages of the app display correctly showing data from the database calls made by the app. After stoping Puma (CTRL C) I start apache with the command 'sudo service apache2 start'. This starts correctly and when I try to access the app I get the "TinyTds::Error (closed connection):" displayed in the rails production log file. The log messages are shown below,

I, [2019-02-04T17:11:14.815714 #2769] INFO -- : [6933cfd7-efa5-492c-a538-87f5e04e9723] Started GET "/" for 10.2.0.137 at 2019-02-04 17:11:14 -0500
I, [2019-02-04T17:11:14.904719 #2769] INFO -- : [6933cfd7-efa5-492c-a538-87f5e04e9723] Processing by TurkeytoteController#totals as HTML
I, [2019-02-04T17:11:14.942821 #2769] INFO -- : [6933cfd7-efa5-492c-a538-87f5e04e9723] Completed 500 Internal Server Error in 38ms
F, [2019-02-04T17:11:14.943925 #2769] FATAL -- : [6933cfd7-efa5-492c-a538-87f5e04e9723]

F, [2019-02-04T17:11:14.943996 #2769] FATAL -- : [6933cfd7-efa5-492c-a538-87f5e04e9723] TinyTds::Error (closed connection):
F, [2019-02-04T17:11:14.944074 #2769] FATAL -- : [6933cfd7-efa5-492c-a538-87f5e04e9723]

F, [2019-02-04T17:11:14.944163 #2769] FATAL -- : [6933cfd7-efa5-492c-a538-87f5e04e9723] app/controllers/turkeytote_controller.rb:95:in get_totals'
[6933cfd7-efa5-492c-a538-87f5e04e9723] app/controllers/turkeytote_controller.rb:76:intotals'

I am not sure how to produce a full stacktrace, any advice would be welcome.

Thanks for all your help.

Regards,

Bill.

Hello Chris,
Thanks for the prompt response.
There is no problem connecting to the database when using just Puma. I can create, read, update and delete with no issues. When I use apache/passenger to access the application then I get the error.
When you mention 'ENV variables' can you be a little more specific? Perhaps there is something that I have not set correctly and I am ignorant of.

Regards,

Bill.

When I start my application using Puma on port 3000 everything works as expected (no error). When I try to access the application after starting Apache, using the default port 80, I get the error "TinyTds::Error (closed connection):". The code at the point of the error is trying to read a remote MSSQL database. What could be some of the reasons that the connection is closed when using Apache/Passenger? I am using Ruby 2.5.3, Rails 5.1.6.1, Apache2 2.4.29, Ubuntu 18.4, Passenger 6.0.1, Tiny_tds 1.3.0, Activerecord-sqlserver-adapter 5.1.6.