Ruby Soap Client
Now I'm playing with soap calls (to the webservices of Akamai and Limelight) from a ruby program. Here are some note on using SOAP Webservices with RUBY (as a client):
- install soap4r (link) - or simply type 'sudo gem install soap4r'
- install http-access2 (link) - I've noted that the gem install of soap4r also installs the httpclient
- example: a good article can be found on Brendon Wilson's blog (link)
more to come
ruby and mysql on OSX 10.6
here are some note on installing ruby on OSX ... as usual this probably will not work for anyone and these are just some notes on mistakes I made:
- I used the installed version of ruby on OSX 10.6 - Snow Leopard
- Install the 64 bit version of MySQL from the mysql site (link - and selec the x_86_64, I've used the 5.1.40 installation)
- install ruby dbi module (dbi-0.4.3) : sudo gem install dbi
- install ruby dbd module (dbd-mysql-0.4.3): sudo gem install dbd-mysql
I've also installed mysql (mysql-2.8.1) (though I don't think you need it with DBI/DBO described above). this is the command line I used to install it:
sudo env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config
note: the mistake I made earlier was to not use the "x86_64" parameter and I (I think) as a result for the following error message :`load_driver': Could not load driver (uninitialized constant MysqlError) (DBI::InterfaceError)
So after this I was able to execute the simple DB queries via the ruby dbi interface:
begin
# connect to the MySQL server
dbh = DBI.connect("DBI:Mysql:#{$DB}:#{$DB_SERVER}", $DB_USER, $DB_PW)
# get server version string and display it
row = dbh.select_one("SELECT VERSION()")
puts "Server version: " + row[0]
rescue DBI::DatabaseError => e
puts "An error occurred"
puts "Error code: #{e.err}"
puts "Error message: #{e.errstr}"
ensure
# disconnect from server
dbh.disconnect if dbh
end
