INSTALLING MYSQL ON SERVER DIGITAL OCEAN

- March 16, 2017

Installing mysql on Digital Ocean :-

we will refer :-

https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-16-04

You can use this :-

gem 'mysql'

Path :- /usr/bin/mysql

development:
adapter: mysql2
encoding: utf8
reconnect: false
database: data_dev
pool: 5
username: root
password: root
socket: /var/run/mysqld/mysqld.sock

production:
adapter: mysql2
encoding: utf8
reconnect: false
database: data_pro
pool: 5
username: root
password: root
socket: /var/run/mysqld/mysqld.sock

Comments

CARRIERWAVE - UPLOAD ANY MEDIA (AUDIO , VIDEO AND IMAGE ) FILE IN RAILS

- November 17, 2017

Read more

psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

- May 16, 2018

If we are getting error after creating database in postgres like this :-psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? Then use following link :- https://stackoverflow.com/questions/42653690/psql-could-not-connect-to-server-no-such-file-or-directory-5432-errorsudo chmod 777 -R /var/run/postgresql/Then restart the postgres:- sudo service postgresql restart orsudo systemctl start postgresql@9.6-main

Read more

SELECT COUNTRY WITH STATE AND IT'S CITIES RAILS

- November 01, 2017

Country State Select is a library that provides an easy API to generate Country , State / Province and City dropdowns for use in forms.We will refer :-

https://github.com/arvindvyas/Country-State-Select Gemfilegem 'chosen-rails'
gem 'country_state_select', git: 'git://github.com/arvindvyas/Country-State-Select', branch: :master
gem "simple_form"#, "~> 3.2"
gem "reform"#, "~> 2.0"
gem "reform-rails" orders_controller.rbclass OrdersController < ApplicationController
    def shipping_address
        @location = Address.new
    end
end shipping_address.html.erb<%= simple_form_for @location, :html => {class: 'subscribe-from'} ,url: orders_shipping_address_path do |f| %>
<div class="row">
    <div class="col-md-6">
      <div class="form-group">
        <%= f.input :address_line1, label: "Country", collection: CountryStateSelect.countries_co…

Read more

RAILS: UPLOADING PHOTOS VIA AMAZON S3 AND PAPERCLIP (UPLOADING FILES TO S3 IN RUBY WITH PAPERCLIP)

- January 14, 2018

Set up Ruby on Rails with Paperclip and S3 using AWS SDK
Uploading Files to S3 in Ruby with Paperclip Paperclip requires the following gems added to your Gemfile. If your paperclip version is 5.1.0 then we are using 'aws-sdk' version 2.3.# Gemfile
gem 'paperclip'
gem 'aws-sdk', '~> 2.3' or our paperclip version is 4.1.0 then we need to use 'aws-sdk' version < 2 (note: add version less than 2.0 otherwise you will get paperclip error)gem 'paperclip'
gem 'aws-sdk', '< 2.0'

Run bundle install and restart the Rails server after modifying the Gemfile. Then run the command :-rails generate paperclip user image Define the file attribute in the Modelclass User < ActiveRecord::Base
    has_attached_file :image, styles: { medium: "300x300>", thumb: "100x100>" }, default_url: "/images/:style/missing.png"
    validates_attachment_content_type :image, content_type: /\Aimage\/.*\z/
end Migration…

Read more

SEARCHING USING AJAX IN RAILS

- September 13, 2017

Search any entry from Database using ajaxRoutes
get 'search'

Controller

def search
          @companies = Company.search(params[:search].split("=").last)
          respond_to :js
      end

Model

def self.search(search)
          if search
                Company.where("name LIKE '%#{search}%'")
          else
                Company.all
          end
      end

index.html.erb :-

      <%= text_field_tag :search, "", class: "search_companies" %>

      <tbody class="company_tbody_content">
           <%= render 'index_content' %>
      </tbody>

      <script type="text/javascript">
           $(".search_companies").keyup(function() {
               $.ajax({
                  url: '/super_admin/companies/search',
                  data: {search: $(this).serialize()}
               });
           });
      </script>

search.js.erb

$(".company_tbody_content").html("<…

Read more

AWS::S3::ERRORS::ACCESSDENIED (ACCESS DENIED):

- January 10, 2018

Paperclip S3 AccessDenied Aws::S3::Errors::AccessDenied (Access Denied): Assuming you are using AWS’s IAM and you created a dedicated User for these uploads.If you get this error when trying to upload to S3, you need to assign this IAM User the “AmazonS3FullAccess” Policy.

Read more

UNINITIALIZED CONSTANT PAPERCLIP::STORAGE::S3::AWS

- January 09, 2018

Set up Ruby on Rails with Paperclip and S3 using AWS SDK Paperclip requires the following gems added to your Gemfile. If your paperclip version is 5.1.0 then we are using 'aws-sdk' version 2.3.gem 'paperclip'
gem 'aws-sdk', '~> 2.3' or our paperclip version is 4.1.0 then we need to use 'aws-sdk' version < 2 (note: add version less than 2.0 otherwise you will get paperclip error)gem 'paperclip'
gem 'aws-sdk', '< 2.0'

Run bundle install and restart the Rails server after modifying the Gemfile.

WE CAN FOLLOW THE LINK BELOW :-

https://github.com/thoughtbot/paperclip/issues/2388
https://coderwall.com/p/vv1iwg/set-up-ruby-on-rails-with-paperclip-5-and-s3-using-aws-sdk-v2

Read more

UPLOAD ANY MEDIA FILE IN RAILS USING PAPERCLIP

- January 12, 2017

Steps to Upload any type of media in ruby on rails by paperclip Upload video in RailsGemfile

gem 'paperclip'
gem 'paperclip-ffmpeg'
gem 'paperclip-av-transcoder' Apply validation in modelhas_attached_file :file, :styles => {:medium => { :geometry => "300x300", :format => 'flv'},:thumb => {:geometry => "100x100#", :format => 'jpg', :time => 15}
    }, :processors => [:ffmpeg]
When you will get some validation errors then we can use this below code :-validates_attachment_content_type :file, content_type: %w(video/mp4 video/3gp video/webm image/jpeg image/jpg image/png) Install ffmpeg on your systemsudo apt-add-repository ppa:jon-severinsson/ffmpeg
sudo apt-get update
sudo apt-get install ffmpeg

When we will get some ppa error then run:-

http://stackoverflow.com/questions/29125229/how-to-reinstall-ffmpeg-clean-on-ubuntu-14-04

Play video in rails using video_tag

video_tag("trailer.ogg", controls: true,…

Read more

Building native extensions. This could take a while... ERROR: Error installing mysql: ERROR: Failed to build gem native extension.

- April 12, 2018

When we are getting problem with mysql like :-Building native extensions. This could take a while... ERROR: Error installing mysql: ERROR: Failed to build gem native extension.If we want to solve this problem so firstly we need to uninstall the mysql :-
Uninstall mysql :- https://www.linuxhelp.com/how-to-remove-mysql-package-completely-on-ubuntu-16-04/Then we need to install the mysql :-
https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-16-04
Then install the mysql gem :-
gem install mysql
After that run the below command :-
sudo apt-get install libmysqlclient-dev

Read more

HOW TO CALL RAILS API FROM SIMPLE HTML PAGE.

- January 11, 2018

Calling the rails API from simple HTML page. Step 1: Create new form in the HTML page. index.html.erb<form action="javascript:void(0)">
<input type="text" name="first_name" id="first_name">
<select name="resident" id="resident">
    <option value="">Select</option>
    <option value="true">true</option>
    <option value="false">false</option>
</select>
<textarea type="textarea" name="notes" id="notes"></textarea>
<input type="file" name="image" id="image">
<button type="button" name="submit" id="form_submit_api">Send Data</button>
</form> <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.js" integrity="sha256-DZAnKJ/6XZ9si04Hgrsxu/8s717jcIzLy3oi35EouyE=" crossorigi…

Read more

Search This Blog

ROHIT YADAV