similar to: Creating databases on the fly

hi,guys- I have a mysql database which stores host informations,so I wrote a function to get some values. - Here is the function rb(this function should return the type I defined in the database): #hosttype.rb require "mysql" module Puppet::Parser::Functions newfunction(:hosttype, :type => :rvalue, :doc => "Gets host type from db.") do |args|

Following code, should kill the worker thread, if there is a error in connecting to the database, right? but in my case it doesn''t and goes on doing other stuff. Of course...there are lots of work arounds for this, but how do i make sure that, the thread is killed at that point of time. begin @dbh = Mysql.real_connect

Hello, I decided to embrace getting a new Rails application to see an existing MSSQL database and trying to get unixODBC, freeTDS, and ActiveRecord able to query my MSSQL database. I''m following the procedure outlined at http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux but my system (Ubuntu 8.10 - Intrepid Ibex, Rails 2.3, Ruby 1.8.7)

Hi, I?m working on a rails application that uses data from an existing ms sqlserver 2000 database. Unfortunately I can?t get the connection to work properly. I used http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer to make the connection. - Inserted the ado.rb - Changed my database.yml to development: adapter: sqlserver database: database_name host:

Here''s some happy-fun Perl to make your storeconfig/virtual resources day better. I probably should have written this in Ruby, but perl comes naturally :) #!/usr/bin/perl # # Perl DBI to remove all related entries from Puppet''s storeconfigs database. # Use when a host is removed from the Puppet network forcibly # Alternatives: run puppet on host to be removed with a blank

Hi, I have a legacy database ''old'' and a new database ''new'' which rails uses. I set up models using old with establish_connection(old), and this works well, except for include: class OldModel < ActiveRecord::Base establish_connection(old) end class NewModel < ActiveRecord::Base has_one :old_model end a = OldModel.find :first NewModel.find(:all,

Hi, I''ve been playing around with using DBI instead of ActiveRecord ''cause I just love to beat myself up! ;) Is this an okay way to do this, or is there any other more creative ways? require ''dbi'' module MyApp:Models class DB def self.dbh DBI.connect(''DBI:Mysql:dbname'', ''username'',

I ran into a problem with "subset" while working at home that I am not sure is a bug or not. I defined a custom function to take a data frame of tree positions, sizes, and types (containing the columns TRT, COMP, PLOT, X, Y, DBH and CON) and wanted to make a stem map of the plot using different symbols and colors to represent the different types of tree stems. I copied a bit of the

Hi. Something happened with my Kerberos database*. I don't know what. I don't care much (right now). What I need to do now is to recover. I am running a small home network: 3 win7 boxes, 2 xps, 2 Mint Linux and one Puppy. I tried deleting /usr/local/samba/private/* and /usr/local/samba/etc/smb.conf as the how-to suggests, then doing a samba-tool domain provision. All my Windoze

I have been creating conf files and similar with the following method that I picked up (I think from psotfix docs): cat <<EOF>>/etc/aliases || exit 1 root: youremail EOF See: http://medon.htt-consult.com/Centos7-armv7.html But with postfixadmin I stumbled onto a problem. The following: cat <<EOF>/usr/share/postfixadmin/config.local.php || exit 1 <?php

I keep getting an error when I try to run a redmine installation. This is what comes up. .gems/gems/activerecord-2.3.5/lib/active_record/connection_adapters/ mysql_adapter.rb:589:in `real_connect'': Can''t connect to local MySQL server through socket ''/var/run/mysqld/mysqld.sock'' (2) (Mysql::Error) The database server is a remote server, and I can''t

Hi, I'm trying to plot an equation in two variables to get a feel for sensitivity to its parameters. I've run expand.grid to get made-up vectors of the combinations of the two independent variables, and am trying to plot the output of the dependent, M, against both the dependent in a 3d space. t <- 0:100 DBH <- 10:100 TxDBH<-expand.grid(t,DBH) time<-TxDBH[,1]

Hey, So I have a scatter plot and I am trying to plot a curve to fit the data based on a Holling Type III functional response. My function is this: nll2<-function(a,b) { conefun<-(a*DBH^2)/(b^2+DBH^2) nlls2<-dnbinom(x=cones ,size=DBH, mu=conefun,log=TRUE) -sum(nlls) } and my plot is this: plot (DBH,cones) DBH is on the x-axis and cones is on the y-axis. How do I get the curve

Now I have the forest plot data with x, y locations, and I measured the DBH for every indivicuals. The data looks like that: x=runif(100,0,100) y=runif(100,0,100) dbh=runif(100,1,100) rdata=data.frame(x,y,dbh) > rdata[1:5,] x y dbh 1 99.5354145 1.412844 34.10112 2 0.8259361 87.737036 39.12914 3 6.5678613 65.699032 22.55990 4 67.2987881 72.053877 45.83978 5 2.2491372

I've been trying to figure out how to prevent a column that is the result of an aggregate function call so that I can use it in further calculations. For example, I would like to aggregate the expf for the data.frame by sp (character) and dbh (double d=rounded to integer) using the command: > st2 <- aggregate( ntrs$expf, by=list(sp=ntrs$sp,dbh=ntrs$dbh), sum ) > st2$expf <- st2$x

Dear R-help, Here's a simple example of nonlinear curve fitting where nls seems to get the answer wrong on a very simple exponential fit (my R version 2.7.2). Look at this code below for a very basic curve fit using nls to fit to (a) a logarithmic and (b) an exponential curve. I did the fits using self-start functions and I compared the results with a more simple fit using a straight lm()

See my screenshot of the command here. http://a.imagehost.org/0843/mysqladmin.png When I type the following: mysqladmin create <database_name> --user=root --password=xxxxxxxx Is my command executed simply by pressing "Enter" after the command? Am I missing some syntax? If the command has been executed , what directory can I find this database? How does this relate to MySQL

Dear people of the help list I am drying to analyze my data using the 'lmer' function and I keep having problems. This is the model: > fm1<-lmer(dbh~spec+scheme+(1|Plot),data=d, REML=FALSE). I analyse tree size (dbh) of 3 different species (spec) and 3 planting schemes (scheme). I have 5 plots, which I hope to model as a random factor. (However, the subsequent output is based on

Hello, I have a problem with my script. I don'y know how to apply subtitles. I have 9 charts per page (for combination of 3 blocks and 3 treatments). I want to have subtitles for this interaction (e.g. Block A Trt 1, Block A Trt 2, ...) MBE$bt<- interaction(MBE$Block,MBE$trt) par(mfrow=c(3,3)) for(i in unique(MBE$bt)){ ss <- MBE$bt==i plot(MBE$Year[ss], MBE$DBH[ss])

R gurus, I'm working on data analysis for a small project. My response variable is total vines per tree (median = 0, mean = 1.65, min = 0, max = 24). My predictors are two categorical variables (four sites and four species) and one continuous (tree diameter at breast height (DBH)). The main question I'm attempting to answer is whether or not the species identity of a tree has