[R] RODBC connections w/o specific database

Folks, I'm writing a gui wrapper around RODBC (having abandoned RMySQL) and some custom analysis scripts. I'm hoping that I could get some advice. All of my users will have access to a database server. I am going to limit their access to certain databases--a sizeable warehouse in a SAN, and t

[R] Reading config data from text files

R List, I'm writing a tcl/tk gui tool to wrap around RMySQL for some co-workers. One function is to be able to add, modify, and remove entries to my.cnf, which is where RMySQL stores database connection information in the following format: [connection_name] # comment user = $username password =

Re: [R] RMySQL *was* working...

List, Please disregard. I merely forgot the quotes: > dbDriver("MySQL") Thanks, Pete Pete Cap <[EMAIL PROTECTED]> wrote: List, Last week with the help of Uwe and some other folks I was able to get RMySQL 0.5-7 compiled against R 2.4.1 and MySQL 5.0.27. It was working f

[R] RMySQL *was* working...

List, Last week with the help of Uwe and some other folks I was able to get RMySQL 0.5-7 compiled against R 2.4.1 and MySQL 5.0.27. It was working fine--I was able to send select queries to the db, put the results in a data frame, and so forth. Today, dbDriver() threw an error: > dbDriver(My

Re: [R] RMySQL on win32

Uwe Ligges <[EMAIL PROTECTED]> wrote: If you have gcc installed, yes, still a path issue: You have tp put MinGW's ./bin directory into your PATH. Best, uwe Uwe, Got it. I had placed ..\mingw\mingw32\bin in the path instead. I also had to place the directory for the HTML Help Workshop in the

Re: [R] RMySQL on win32

Uwe Ligges <[EMAIL PROTECTED]> wrote: Please follow the Instructions to set up your build environment as mentioned in the R Installation and Administration manual. That includes installing the tools from Duncan Murdochs Webpage and putting it into your path. You either forgot to install those t

Re: [R] RMySQL on win32

List, I am still unable to compile RMySQL on XP and would appreciate any assistance anyone could provide. I know that setting up RMySQL on win32 is not easy. The installation instructions are supposedly contained in ../src/README.win. They give instructions on creating a file, libmysql.a, wh

[R] RMySQL on win32

List, I just left an environment where I was running R and mysql on CENTOS. At the time of install, RMySQL was available on CRAN. Later installs on Ubuntu were possible because it was available as a package in the base repos. Now I'm in a new environment where I have no choice but to use Wind

[R] Random Sampling pointers?

Hello all, I have a population of 112 servers that are experiencing different levels of packet loss. I don't want to poll all 112 of them (the analytical tools must be manually run on each individually) so it seems best to sample among them; then I plan on using R to run comparisons of the dat

[R] Faster way to zero-pad a data frame...?

a1, reads the timestamp, and writes the "events" to the corresponding row in data2. The result is: time,events 0,1 1,30 2,0 3,0 4,0 5,14 6,0 7,0 9,0 9,0 10,4 For a 24-hour log (86,400 seconds) this can take a while...Any advice on how to speed it up woul

[R] Fourier / Bandpass filter help?

List, I am trying to apply some digital signal analysis methods to IPv4 networks. Specifically, I have had some success using the Fast Fourier Transform in R to find periodic events in IPv4 network traffic by producing periodograms. I store network traffic in a mysql database so I have been

[R] Cannot install RMySQL under Kubuntu

List, I am attempting to install RMySQL on a Kubuntu box. mysql and R were installed using the adept package manager: "apt-get install mysql-server" "apt-get install r-base" I can access mysql via the terminal and I can open R and perform various basic tasks. However, I cannot instal

[R] Selecting significant peaks in periodograms

Greetings all, I am using Fourier analysis to search for periodicities in IP network traffic by generating periodograms and then visually examining them for large, distinct peaks. However, in many cases it is not readily apparent where there are periodicities. I have no experience with di

[R] Quickest way to match two vectors besides %in%?

Hello list, I have two data frames, X (48469,2) and Y (79771,5). X[,1] contains distinct values of Y[,2]. I want to match values in X[,1] and Y[,2], then take the corresponding value in [X,2] and place it in Y[,4]. So far I have been doing it like so: for(i in 1:48469) { y[which(x[i,1]==y[,3]),4

[R] Altering domain & range in an interactive plot using tcl/tk

List, I am trying to create a simulated spectrum analyzer in R. The user gets as output a power spectrum (plot of power vs. time). I want the user to be able to change the center frequency (midpoint between xMin and xMax) and window size (distance from xMin to xMax) using sliders in tkrplot. Th

[R] FFT post-processing

List, Can anyone point me at a user guide for doing signals processing after applying the FFT? I'm looking for some info on postprocessing steps, trying to see if there are any packages already written, etc. TIA, Pete __ [[alterna

[R] Newbie guide for plot & graphics functions?

Hello all, Can anyone point me to a decent introduction to using the plotting and assorted graphics functions in R? I keep getting simple errrors and I can't figure out why, for example: > image(x,y,z) Error in image.default(x, y, z) : dimensions of z are not length(x)(+1) times length(y)(+1

[R] Preparing timestamped data for fourier analysis

Greetings all, I'm working on a project trying to apply fourier analysis to timestamped router logs, using R to perform the analysis. The idea is to determine if any type of traffic (say, outgoing ICMP requests) has strong periodic features because it may indicate a compromise somewhere on th