similar to: Connecting to a Remote MySQL Server

Hi All. I have a mysql statement that I would really really like to call from my Ruby program which goes like this: SELECT a, b, DAYOFWEEK(date_time) as DOW, HOUR(date_time) at hr, AVG(x/y) FROM records; This is possible by creating a 3-dimentional array of a, b, date_time containing x/y, and then finding averages and putting it into a 4-dimensional array of a, b, dow,

I don''t understand why my program does not get the file that I try to upload. It returns the following error when I try to upload a small file: NoMethodError in LogfileController#create You have a nil object when you didn''t expect it! The error occured while evaluating nil.original_filename #{RAILS_ROOT}/app/models/logfile.rb:9:in `file=''

Hi, I am having a problem connecting to a remote mysql db and I can''t figure out what the problem is. When I try to connect I get the error: getaddrinfo: no address associated with hostname. I have looked all over for clues as to what that means but I haven''t been able to find anything that helps. I have no problems connecting to the database with php and with the mysql query

Hello All, I don''t seem to be able to get reports to display on the foreman interface. I copied extras/puppet/foreman/files/foreman-report.rb to / usr/lib/ruby/site_ruby/1.8/puppet/reportsforeman.rb, instead of /usr/ lib/ruby/1.8/puppet/reports/foreman.rb. Config: Centos5.4, Apache/ Passenger, Puppet 0.25.4. The reports are coming from the clients, because I can see them in

Hey everyone, I'm trying version 1.0rc2, via the rpm at ATrpms. I'm running on CentOS 4.3 on an Opteron system. I have this running stably on a 32 bit system, but I'm crashing constantly on a 64 bit system. Here's what I'm getting in my mail logs when I try to log in via IMAP: Aug 3 15:01:21 lisa dovecot: imap-login: Login: user=<scottz>, method=PLAIN,

Hello All, So I finally got around to start to cut over node definitions from standard flat files to external nodes (foreman), and getting error message: "Error 400 on SERVER: Could not find node ''nodename''; cannot compile" - So basically it can''t pick up the node from the external node config. When I test the fetching of the yaml file it seems to work

Hello all: I am trying to use the mysql command to retrieve information from a mysql database. my example here was formed from using the wiki reference to using the mysql command. The problem is with the fetch command. Here is the macro code: Mysql(QueryString=SELECT\ ivr-password\ from\ users\ where\ ivr-id=${userid}) Mysql(Query r ${connid} ${QueryString}) Mysql(Fetch fetchid ${r} dbuserpass)

Hi, We have experienced some problems with ActiveRecord::Base class of Ruby-Rails. We are building a web-application based on the Ruby-rails framework and the web-application needs to access to difference databases, so we do not pre-define our database accesses in the database.yml file. In fact, we are using the ActiveRecord::Base.establish_connection() to connect to our database, the function

I want to use LISA finite element program (http://www.lisa-fet.com/) under my Ubuntu machine. I did install Wine and it runs ok, then I install LISA and it installed without any error. However whrn I run LISA, it did not appear on the screen without any error? Anyone can assist how to me LISA running?

On Thu, August 3, 2006 15:28, David Jonas wrote: > On Thu, 2006-08-03 at 15:07 -0400, Scott Zahn wrote: >> Hey everyone, I'm trying version 1.0rc2, via the rpm at ATrpms. I'm running on CentOS >> 4.3 on an Opteron system. I have this running stably on a 32 bit system, but I'm >> crashing constantly on a 64 bit system. >> >> Here's what I'm

Need some assistance on the below information - please let me know if this is not the right group for this to go to. Thanks, Lisa Gates Systems Administration Engineer ----- Forwarded by Lisa G Gates/Harland Clarke/Email on 12/11/2014 09:53 AM ----- From: Simo Sorce <idra at samba.org> To: <Lisa.Gates at harlandclarke.com>, Cc: <cifs-protocol at

Dear R-help listers, Is anyone aware of a function that outputs dendrogram ultrametrics? Cheers, Lisa. PS please reply to me personally as well as to the list because the website wasn't letting me subscribe for some reason. thanks... Lisa Holman Research Officer, Vegetation Dynamics Policy & Science Division NSW Department of Environment & Conservation PO Box 1967, Hurstville 2220.

Hello, I believe I''ve found a bug in the installation process of OpenLinux 2.2 when using the LISA boot disk. During the installation a temporary passwd file is put on the new file system containing the user "help" set uid=0 gid=0 and no password. Once you are prompted to set the root password and default user password a new passwd and shadow file is created yet the help user

Hello there, My name is Lisa and I'm doing analysis using genelized linear model-GEE model because I have some repeated measurements on the same patients (in a bilateral eye disease case). It would be very appreciated if you could shed some light on what function to use in R. Thank you very much Lisa Wang Msc. Toronto,Ca

I''ve searched everywher for an answer to my problem, and the only thing I''ve found is people with the same problem. I''m hoping someone has an answer here: I''m working through the agile web developement with rails book and when I goto scaffold the products table I get the following message. exists app/controllers/ exists app/helpers/ exists

Hello, all. I''ve been trying to get shorewall to get LISa working on my Gentoo box. It works as long as I have shorewall turned off, but whenever I turn it on, it seems to block all LISa activity. I have TCP port 7741 opened (as per lisa-home.sourceforge.net), and nmap says it''s open. Ethereal indicates that LISa is communicating via TCP port 7741, from 127.0.0.1 to

Dear R-Users, I want to ask a question for a colleague of mine. He wants to put a character vector and a numeric vector into one matrix and still have the old character and numeric type for the respective columns. Unfortunately, I am just starting using R and I could not help him. Is there an easy and straightforward way to do this in R? Maybe a little example facilitates understanding our

hi. i''ve an application which is using a local mysql server (on localhost). i then moved the mysql server to another machine (remote host) and changed accordingly the "database.yml" file. when i launch webrick from the "localhost", it can connect to the database but as soon as i call a controller of the application (for example

Is this command the best way to access a MySQL database - MYSQL(Connect connid dhhost dbuser dbpass dbname) ? I thought I heard that using ODBC was a bit more stable. Anyone have any experience? Thanks, Matt

Hi, I''ve installed Dashboard on my server and I aim to remotely request the MySQL Database. All documentations read explain the way to roll out using Dashboard and MySQL Database on the same server. I am looking for any information to achieve that because I haven''t found any from the time being and I wonder if it''s just possible. Thanks you, David -- You received