20130618-debug-dir-glob-method-error-on-xmlconv

<< | Index | >>

Summary

• Incomming Orders (same error)
  • globopharm.xmlconv.bbmb.ch
  • sandoz.xmlconv.bbmb.ch

Index / Status

• Debug Orders in globopharm.xmlconv.bbmb.ch
• Debug Orders in sandoz.xmlconv.bbmb.ch
• SSL Connection on pop.gmail.com

Debug Orders in globopharm.xmlconv.bbmb.ch

xmlconv can not read files with Dir.glob.
rubygems of ruby-1.8.6 blocks under $SAFE=1 this Dir.glob method.

This make another exception of smtp in polling_manager.rb in xmlconv.

Setup globpharm.xmlconv.bbmb.ch locally

I setuped same middlewares for production server in VM.

• virtual machine
• glibc 2
• apache2
• postgresql 8.4
• ruby 1.8.6-p369 + oniguruma patch
• rubygems 1.4.1

for pass_hash

% ruby -rmd5 -e "p Digest::MD5::hexdigest('passwd')"

gems

• pg 0.8.0 first
• dbd-pg 0.3.9
• dbi 0.4.5
• rmail 1.0.0
• tmail 1.2.7.1
• smtp_tls 1.0.3
• needle 1.3.0
• rclconf 1.0.0
• htmlgrid 1.0.6
• odba 1.1.0
• sbsm 1.2.3
• yus 1.0.0
• ydim 1.0.0
• hpricot 0.8.6
• rockit (put source from trac.ywesee.com into site_ruby)

 Attach:Rockit.tar.gz

(required ?)

• character-encodings (0.3.0)
• transaction-simple (1.4.0.2)

Links

• http://dev.ywesee.com/Masa/20110615-setup-globoXmlconvBbmbCh

Note

rename role

postgres=# alter role OLD_NAME rename to NEW_NAME;

Then In my local machine, there is no error.
Debug configuration and load_path on production server.

SSL Connection on pop.gmail.com

google needs SSL on pop.
It seems that Ruby 1.8.6 does not use ssl without other libraries.

• tlsmail #=> pop
• smtp_tls #=> smtp
• stunnel #=> http://www.stunnel.org/index.html

I tried SSL Connection with ruby 1.8.6 via stunnel.
localhost:10000 is tunneling port.

#!/usr/bin/env ruby
require "net/pop"

# ruby-1.8.6 could not use this without tlsmail.
#Net::POP3.enable_ssl(OpenSSL::SSL::VERIFY_NONE)

Net::POP3.start("localhost", 10000, "yasaka@ywesee.com", "xxxxx") { |pop|
  pop.each_mail { |mail|
    source = mail.pop
    begin
      p source #= displays mail content
    ensure
      #mail.delete
    end
  }
}

Connection over ssl.

2013.06.18 16:48:35 LOG5[28954:140693051324160]: Service [gmail] accepted connection from 127.0.0.1:49913
2013.06.18 16:48:35 LOG5[28954:140693051324160]: connect_blocking: connected 173.194.79.109:995
2013.06.18 16:48:35 LOG5[28954:140693051324160]: Service [gmail] connected remote server from 10.0.1.41:60277
2013.06.18 16:48:36 LOG5[28954:140693051324160]: Connection closed: 45 byte(s) sent to SSL, 147 byte(s) sent to socket
2013.06.18 16:48:36 LOG5[28954:140693051324160]: Service [gmail] accepted connection from 127.0.0.1:49916
2013.06.18 16:48:37 LOG5[28954:140693051324160]: connect_blocking: connected 173.194.79.109:995
2013.06.18 16:48:37 LOG5[28954:140693051324160]: Service [gmail] connected remote server from 10.0.1.41:60280
2013.06.18 16:48:38 LOG5[28954:140693051324160]: Connection closed: 45 byte(s) sent to SSL, 146 byte(s) sent to socket

FIPS

libcrypto on production server, needs fips = no.

• http://www.stunnel.org/static/stunnel.html

polling.yml

Specyfied host and port into polling.yml

host: localhost
port: 10000
user: xxxxx.xxxx@bbmb.ch
pass: xxx
content_type: 'text/xml'
...

Incoming Mail and Rubygems Problems are resolved.

• globopharm.xmlconv.bbmb.ch
• sandoz.xmlconv.bbmb.ch