S
Simon Jones
Hello all,
I'm a new Ruby user, so pardon me if this is a silly question, but I've done
some googling and not found any answers so far. Apologies in advance if this
post is a little long, but I thought it might help to list what I've done so
far.
I've downloaded Ruby 1.8.6 One-Click Installer, and got Ruby up and running
on my Win XP box. Then I used RubyGems to obtain v 2.7.3 of the MySQL API.
The idea is to connect to MySQL running on Ubuntu Server on another box on
my LAN - that part of the equation seems to work ok, in that I can connect
to MySQL from the Windows box using MySQL Administrator etc. The data to be
retrieved is login details (server, username, password) for several POP3
mail boxes - I eventually want Ruby to get details for each box from the
database, connect to the mailbox, download mail and process it etc..
However, when I tried to query the database via Ruby I got a Segmentation
Fault. After much googling I found I needed libmySQL.dll in my path, and
tried various versions of the file (including the one that came with MySQL
Administrator, and the one in MySQL 5.1.22), before getting things to work
with the version from MySQL 5.0.45.
Great, Ruby can now retrieve a result set from the database containing login
details for the two POP3 boxes currently stored there. Also, by using the
demo code in the docs for net/pop and hard coding the login details for any
given mailbox, I can connect to the mail server.
But, when I merge the code together, things go slightly wrong. Ruby
retrieves the details from the database and connects to the mail servers
correctly, but, when the program ends, I get:
Error in my_thread_global_end(): 1 threads didn't exit
The code I'm using is below. It's messy and long winded, but it IS my first
attempt ever at writing Ruby code - I like what I see so far, and I WILL get
better at it
To keep things shorter than they woud otherwise be, I've removed the code
between pop.start and pop.finish, since the error happens whether it's
present or not.
Any suggetions would be very much appreciated!
TIA
Simon.
#!/usr/bin/ruby -w
require 'net/pop'
require "mysql"
begin
# connect to the MySQL server
dbh = Mysql.real_connect("xxx.xxx.xxx.xxx", "username", "password",
"database")
# get get email account details
res = dbh.query("SELECT name, server, user_name, password FROM
pop_boxes")
if res.nil? then
puts "Statement has no result set"
else
puts "Statement has a result set"
while row = res.fetch_hash do
printf "%s\n", row["name"]
pop = Net:OP3.new(row["server"])
pop.start(row["user_name"], row["password"])
pop.finish
printf "%s, %s,%s, %s\n", row["name"], row["server"],
row["user_name"], row["password"]
end
end
puts "Number of rows returned: #{res.num_rows}"
res.free
rescue Mysql::Error => e
puts "Error code: #{e.errno}"
puts "Error message: #{e.error}"
puts "Error SQLSTATE: #{e.sqlstate}" if e.respond_to?("sqlstate")
ensure
# disconnect from server
dbh.close if dbh
end
I'm a new Ruby user, so pardon me if this is a silly question, but I've done
some googling and not found any answers so far. Apologies in advance if this
post is a little long, but I thought it might help to list what I've done so
far.
I've downloaded Ruby 1.8.6 One-Click Installer, and got Ruby up and running
on my Win XP box. Then I used RubyGems to obtain v 2.7.3 of the MySQL API.
The idea is to connect to MySQL running on Ubuntu Server on another box on
my LAN - that part of the equation seems to work ok, in that I can connect
to MySQL from the Windows box using MySQL Administrator etc. The data to be
retrieved is login details (server, username, password) for several POP3
mail boxes - I eventually want Ruby to get details for each box from the
database, connect to the mailbox, download mail and process it etc..
However, when I tried to query the database via Ruby I got a Segmentation
Fault. After much googling I found I needed libmySQL.dll in my path, and
tried various versions of the file (including the one that came with MySQL
Administrator, and the one in MySQL 5.1.22), before getting things to work
with the version from MySQL 5.0.45.
Great, Ruby can now retrieve a result set from the database containing login
details for the two POP3 boxes currently stored there. Also, by using the
demo code in the docs for net/pop and hard coding the login details for any
given mailbox, I can connect to the mail server.
But, when I merge the code together, things go slightly wrong. Ruby
retrieves the details from the database and connects to the mail servers
correctly, but, when the program ends, I get:
Error in my_thread_global_end(): 1 threads didn't exit
The code I'm using is below. It's messy and long winded, but it IS my first
attempt ever at writing Ruby code - I like what I see so far, and I WILL get
better at it
To keep things shorter than they woud otherwise be, I've removed the code
between pop.start and pop.finish, since the error happens whether it's
present or not.
Any suggetions would be very much appreciated!
TIA
Simon.
#!/usr/bin/ruby -w
require 'net/pop'
require "mysql"
begin
# connect to the MySQL server
dbh = Mysql.real_connect("xxx.xxx.xxx.xxx", "username", "password",
"database")
# get get email account details
res = dbh.query("SELECT name, server, user_name, password FROM
pop_boxes")
if res.nil? then
puts "Statement has no result set"
else
puts "Statement has a result set"
while row = res.fetch_hash do
printf "%s\n", row["name"]
pop = Net:
OP3.new(row["server"])pop.start(row["user_name"], row["password"])
pop.finish
printf "%s, %s,%s, %s\n", row["name"], row["server"],
row["user_name"], row["password"]
end
end
puts "Number of rows returned: #{res.num_rows}"
res.free
rescue Mysql::Error => e
puts "Error code: #{e.errno}"
puts "Error message: #{e.error}"
puts "Error SQLSTATE: #{e.sqlstate}" if e.respond_to?("sqlstate")
ensure
# disconnect from server
dbh.close if dbh
end