Home / user-63376

Ramon Tayag's questions

Martin Hope
Ramon Tayag
Asked: 2017-02-21 02:30:38 +0800 CST
  • 0

What would be the recommeded way of copying the production database into staging? Let's say the a link to the production db dump is already available to the staging server.

When doing it by hand, I have to:

  • stop any pods with apps that are connected to the db. In my case, it's the web app and the worker app
  • drop and recreate the staging db
  • run pg_restore on a pod (via Job, or I create a one-off pod to call pg_restore from)

I have some ideas but I'd like to know what others have made.
I'm hoping for something that can be as simple as heroku:

heroku pg:backups restore `heroku pg:backups public-url -r production` -r staging
kubernetes
Martin Hope
Ramon Tayag
Asked: 2012-10-28 22:38:35 +0800 CST
  • 7

In Apache, if 1) I have multiple virtual hosts listening to one port and 2) if no requests match any of the virtual host, then the first virtual host will be the one that will answer the request. For example, given I have this config:

<VirtualHost *:8080>
  ServerName www.fallbacksite.com:8080
  ServerAlias *.fallbacksite.com
  # ...
</VirtualHost>

<VirtualHost *:8080>
  ServerName www.specific-site.com:8080
  ServerAlias *.specific-site.com
  # ...
</VirtualHost>

Then:

  • When someone specific-site.com:8080, then the second virtual host will be answer the request (no surprise here)
  • When someone visits fallbacksite.com:8080, then the first virtual host will answer the request (no surprise here)
  • When someone visits hellohowareyou.com:8080 (and hellohowareyou.com points to the server), then the first virtual host will answer the request

It's the last scenario I'm trying to implement with nginx, but could not see anything in the nginx.org site talking about this. I tried over-eager wildcards but it complains that it is not valid.

How would you do the above confiuration in nginx? Thanks in advance!

nginx
Martin Hope
Ramon Tayag
Asked: 2011-10-03 06:05:20 +0800 CST
  • 2

I'm following this tutorial to install apache + unicorn but it seems that apache doesn't serve any of the static files. Here's the config I came up with (take a look at Redirect all non-static requests to unicorn in particular):

<VirtualHost *:80>
  ServerName www.unstilted.com:80
  ServerAlias *.unstilted.com
  DocumentRoot /var/www/unstilted/current/public

  ErrorDocument 503 /system/maintenance.html

  RewriteEngine On

  RewriteCond %{DOCUMENT_ROOT}/system/maintenance.html -f
  RewriteCond %{REQUEST_FILENAME} !/system/maintenance.html
  RewriteRule ^.*$    /system/maintenance.html [L]

  # Rewrite to check for Rails non-html cached pages (i.e. xml, json, atom, etc)
  RewriteCond  %{THE_REQUEST} ^(GET|HEAD)
  RewriteCond  %{DOCUMENT_ROOT}/cache/%{HTTP_HOST}%{REQUEST_URI} -f
  RewriteRule  ^(.*)$ /cache/%{HTTP_HOST}$1 [QSA,L]

  # Rewrite to check for Rails cached html page
  RewriteCond  %{THE_REQUEST} ^(GET|HEAD)
  RewriteCond  %{DOCUMENT_ROOT}/cache/%{HTTP_HOST}%{REQUEST_URI}.html -f
  RewriteRule  ^(.*)$ /cache/%{HTTP_HOST}$1.html [QSA,L]

  # no www
  RewriteCond %{HTTP_HOST} ^www\.(.*)$ [NC]
  RewriteRule ^(.*)$ http://%1$1 [R=301,L]

  <Proxy balancer://unicornservers>
    BalancerMember http://127.0.0.1:5000
  </Proxy>

  # Redirect all non-static requests to unicorn
  RewriteCond %{DOCUMENT_ROOT}/%{REQUEST_FILENAME} !-f
  RewriteRule ^/(.*)$ balancer://unicornservers%{REQUEST_URI} [P,QSA,L]

  ProxyPass / balancer://unicornservers/
  ProxyPassReverse / balancer://unicornservers/
  ProxyPreserveHost on

  <Proxy *>
    Order deny,allow
    Allow from all
  </Proxy>
</VirtualHost>

In my /var/www/unstilted/current/public directory I have robots.txt, but when I go to mydomain.com/robots.txt, the request goes to unicorn, and it's not handled by apache.

What's wrong with my config? And how do I get Apache to serve the static files?

Thanks!

apache-2.2 mod-rewrite unicorn
Martin Hope
Ramon Tayag
Asked: 2011-09-22 05:47:26 +0800 CST
  • 0

I use a program that calls ImageMagick's command-line commands. These are supposed to run instantly -- perhaps 1 or 2 seconds. However, lately I've noticed a bunch of them got stuck.

Frozen processes

I use monit to monitor the server and watch certain things when the memory goes overboard. What would be a good way to watch ImageMagick? I'd like to kill the processes if they've been alive for 1 minute. However, I don't want to do a blanket kill all convert processes.

What do I do?

Thanks!

monitoring imagemagick
Martin Hope
Ramon Tayag
Asked: 2011-02-27 23:52:47 +0800 CST
  • 1

I'm using backup_fu to backup my database. In the crontab, you have this command:

* * * * * cd /var/www/amplify/current && RAILS_ENV=production /usr/bin/env rake backup

Yes, I know a backup a minute is intense, but I'm just doing it to test. I will change the interval once I get it working.

  • However, running it in cron doesn't it backup. When I check my Amazon S3 account, I don't see a .tar.gz file.
  • When I SSH in, and I paste the command exactly, it backs up and I see the .tar.gz in Amazon S3.

Note:

  • I'm using RVM. However, as shown in this thread, if I cd into the directory, the proper ruby selection happens.
  • I'm on CentOS: Linux version 2.6.18-194.8.1.el5.028stab070.5 (root@rhel5-build-x64) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-46)) #1 SMP Fri Sep 17 19:10:36 MSD 2010
  • I checked /var/log/cron and it seems that it runs: Feb 27 00:20:01 amplify crond[1667]: (ramon) CMD (cd /var/www/amplify/current && RAILS_ENV=production /usr/bin/env /usr/bin/rake backup)

Any help is appreciated, thanks!

centos cron
Martin Hope
Ramon Tayag
Asked: 2010-12-15 23:05:31 +0800 CST
  • 1

If I'm correct when I think that a line of

30193 ramon     16   0  170M  119M  3628 S  0.0 11.6  0:08.47 Rack: /var/www/salcedoauctions/current

in htop means that there's one spawn of the salcedoauctions app, then how come there are so many more spawns than I've specified?

Here's my httpd.conf:

....
PassengerMaxPoolSize 4
PassengerMaxInstancesPerApp 2
....

Here's the semi-complete htop:

  PID USER     PRI  NI  VIRT   RES   SHR S CPU% MEM%   TIME+  Command
30193 ramon     16   0  170M  119M  3628 S  0.0 11.6  0:08.47 Rack: /var/www/salcedoauctions/current
30197 ramon     18   0  170M  119M  3628 S  0.0 11.6  0:02.08 Rack: /var/www/salcedoauctions/current
30198 ramon     18   0  170M  119M  3628 S  0.0 11.6  0:01.96 Rack: /var/www/salcedoauctions/current
30199 ramon     18   0  170M  119M  3628 S  0.0 11.6  0:01.96 Rack: /var/www/salcedoauctions/current
30067 ramon     15   0  167M  117M  3648 S  0.0 11.5  0:08.77 Rack: /var/www/salcedoauctions/current
30202 ramon     16   0  167M  117M  3648 S  0.0 11.5  0:04.55 Rack: /var/www/salcedoauctions/current
30203 ramon     16   0  167M  117M  3648 S  0.0 11.5  0:03.43 Rack: /var/www/salcedoauctions/current
30204 ramon     16   0  167M  117M  3648 S  0.0 11.5  0:03.32 Rack: /var/www/salcedoauctions/current
28454 ramon     16   0 73764 51732  2520 S  0.0  4.9  0:00.66 Rack: /var/www/unstilted/current
.....

Some notes:

  • Yes, I've restarted apache so it can reload the config (several times, in fact, since the server was running out of memory)
  • CentOS 5.5
  • Ruby EE 1.8.7
  • Rails 3.0.1

  • Passenger 3.0.0

  • UPDATE #1 Doing passenger-status shows the numbers I expect to see though though. I suppose I just understood it wrong. The reason I'm asking is because my 1GB memory is getting used up and sometimes the server grinds to a halt. It seems that those processes are hogging the RAM.

  • UPDATE #2: I asked around in #rubyonrails and I was asked if any of the apps were forking any processes. Both apps don't fork anything, but I do use Dragonfly to handle my images and attachments. However, I don't know how I can pinpoint if this is the cause of the problem.
  • UPDATE #3 (Oct 14, 2011): I upgraded to Ruby 1.9.2, Rails 3.1.x, dragonfly 0.9.3, ImageMagick 6.7; and I'm still getting the same problem. It's not Dragonfly anymore because the newer versions don't use rmagick. It does a command line call to convert images.
ruby-on-rails phusion-passenger ruby-rack
Martin Hope
Ramon Tayag
Asked: 2010-12-13 07:58:03 +0800 CST
  • 0

System specs

  • CentOS 5.5
  • Postfix 2.3.3

Scenario

I've been following Configure Postfix to send/relay emails Gmail (smtp.gmail.com) via port 587 to try and get the connection between Postfix and Gmail to work properly. The instructions are clear. After doing what the chosen answer says, I get this error in my maillog:

Dec 12 08:45:00 stiltify postfix/smtp[21745]: certificate verification failed for smtp.gmail.com: num=20:unable to get local issuer certificate
Dec 12 08:45:00 stiltify postfix/smtp[21745]: certificate verification failed for smtp.gmail.com: num=27:certificate not trusted
Dec 12 08:45:00 stiltify postfix/smtp[21745]: warning: SASL authentication failure: No worthy mechs found
Dec 12 08:45:00 stiltify postfix/smtp[21745]: 6BC962B58006: to=<[email protected]>, relay=smtp.gmail.com[74.125.93.109]:587, delay=0.27, delays=0.05/0.01/0.21/0, dsn=4.7.0, status=deferred (SASL authentication failed; cannot authenticate to server smtp.gmail.com[74.125.93.109]: no mechanism available)

Similar problems out there

Searching for a similar scenario, I found Postfix “SASL authentication failure: No worthy mechs found”, but looking at the details of the chosen answer, it was slightly different and I think it means that the sending server doesn't trust Gmail's certificate:

untrusted issuer /C=US/O=Equifax/OU=Equifax Secure Certificate Authority

But alas...

So here I am, stuck at a mailing problem once again, and need your help.

Thanks in advance!

centos email smtp postfix gmail