Displaying 20 results from an estimated 2000 matches similar to: "error when create database mysql with puppetlabs-mysql (v1.0.0)"
2010 Mar 07
1
Rsync - timeout or similar
Is there any parameter in the rsync binary that I can finish the time the
binary should wait to start a file transfer, otherwise close the rsync
binary. As I read the timeout is a parameter used when the connection has
already been established, and when it is not, which parameter I can use?
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
2004 May 10
1
RODBC in RAqua
I've been trying to get RODBC working in RAqua. For my database,
let's call it "mydb", when I enter
odbcConnect("mydb")
or
odbcConnect("mydb", uid="postgres", pwd="secret"),
RAqua thinks for about 10 seconds, then crashes.
mydb is a PostgreSQL 7.4.2 database running on my machine (Mac OS X
10.3.3). I am using the pgsqlodbc 7.2.5 driver
2009 Jan 20
1
Problem with FAME
Dear All,
I wonder whether anyone has an experience with FAME package written by Jeff Hallman. All my attempts to send him the following problem report did not succeed (the mail system says that my e-mail could not be delivered), so I turn for help to this list.
I tried to use your FAME package written for R, but somehow I cannot get it working. I am using Windows XP and the newest R
2009 Feb 20
2
importing data to SQLite database with sqldf
Hi all,
I am attempting to learn SQL through sqldf...
One task I am particularly interested in is merging separate
(presumably large) files into a single table without loading these
files into R as an intermediate step (by loading them into SQLite and
merging them there).
Taking a step back, I've considered these alternatives:
1) I know if I use straight SQLite commands I might use the
2013 Sep 09
1
Error on tried to used this module in development environment.
Good morning ,
I could audar to debug this problem ?
"puppet agent - test"
Debug: catalog supports formats: b64_zlib_yaml dot pson raw yaml; using pson
Error: Could not retrieve catalog from remote server: Error 400 on SERVER:
Could not find class pentaho for srvdev206.cia.stefanini.com on node
srvdev206.cia.stefanini.com
/usr/lib/ruby/vendor_ruby/puppet/indirector/rest.rb:185:in
2009 May 09
1
sqlSave()
Hi all: I have created a MS Access table named 'PredictedValues' through the statement below:
myDB <- odbcConnectAccess("C:/Documents and Settings/Owner/Desktop/Rpond Farming.mdb",uid="admin",pwd="")
sqlSave(myDB,PredictedValues,rownames=FALSE)
close(myDB)
But if I run the code again with new values I get the message below:
Error in sqlSave(myDB,
2010 Jan 12
1
FW: Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux
I think I figured this out. I should not have put the Driver name in
braces. Changing it from {MySQL} to MySQL seems to work.
-----Original Message-----
From: Marcus, Jeffrey
Sent: Tuesday, January 12, 2010 6:09 PM
To: 'r-help at r-project.org'
Subject: Problems connecting with MySQL using odbcDriverConnect (RODBC
package) on Linux
I am sure I'm doing something wrong here but not
2010 Jul 16
1
sqldf modify table
Hi - I am something of a newbie and am a little perplexed. When (trying to)
modify a table I issue the following commands with subsequent errors
sqldf("alter table Korea drop column code", dbname = "mydb")
error in statement: near "drop": syntax error
or
sqldf("alter table Korea rename column hyr to hyrI", dbname = "mydb")
error in statement:
2007 Aug 31
2
Bugreport on integration of Sweave and latex beamer
I think I have isolated a problem with integration between Sweave and beamer.
Could you please see the file:
http://www.mayin.org/ajayshah/tmp/bugdemo.Rnw
Unfortunately, it uses some of my internal libraries, so you can't run
it. When I put it through Sweave, I get:
http://www.mayin.org/ajayshah/tmp/bugdemo.tex
which is, of course, a generic latex file which you can read and
2006 Jun 13
1
Partial transferred files useless at resume, compare-dir can help ?
So, my use case is :
1. lot of connections over dial-up lines
2. need to transfer safely A SINGLE BZIPPED FILE to the server
3. if dial-up line fails, it's automatically restarted after 5 minutes
and transfer start again
I heard about the --partial option in order to keep the partial
transferred file. I thought that rsync will apply his incremental check
and update alghoritm on that
2018 Oct 04
3
Spontaneous reboot due to MySQL lookups ?
Hello
using Asterisk 1.8.32.
I notice that there is a spontaneous reboot of the Asterisk system from
time to time.
When I look in the logs (verbose file) I noticed that every time this
occurs it's at a moment that there is a MySQL action, be it a lookup or
an insert/update/delete.
I must say I do have some MySQL queries that occur in my dialplan when a
call comes in, to look up
2007 Dec 14
2
connecting RMySQL to and external server
Dear list,
I learned how to connect R to a local MySQL server, using:
drv <- dbDriver("MySQL")
con <- dbConnect(drv, user="root", password="mypass", dbname="mydb")
Is it possible to connect R in this way to an external server (on a different
machine, with a different IP)?
I read the documentation on ?dbConnect (and everything I could find on the
2005 Aug 25
5
ROracle and select query empty
Hi,
I just installed ROracle and RDBI. The connection to the database seems
to work also. My problem is when I am selection rows that really exist
in the database, it is returning nothing. Where should I look to see
what could be my problem?
Thank you very much,
Mathieu
> drv <- dbDriver("Oracle")
> summary(drv, verbose=TRUE)
<OraDriver:(6721)>
Driver name:
2018 Oct 04
4
Spontaneous reboot due to MySQL lookups ?
Hello
thank you for your answer.
If I read your (and others) reaction correctly I can conclude that this
is an Asterisk problem and not a problem of MySQL or dialplan logic ?
You should know that the MySQL database is heavily questioned :
mysql> show status like '%onn%';
+--------------------------+--------+
| Variable_name | Value |
2009 Apr 30
1
odbcConnectAccess function
HI:
Is it possible to use the RODBC package within MS Access. I have been using from R but was just wondering if it could be used along with R(D)COM. Something like this:
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Dim myApp As StatConnector
Set myApp = New StatConnector
myApp.GetErrorText
myApp.Init "R"
myApp.EvaluateNoReturn "library(RODBC)"
myApp.EvaluateNoReturn
2009 Aug 04
2
php-pdo
I wish to use PostgreSQL with PHP+PDO. I haven't use PDO before.
I have the php-pdo package installed on my CentOS 4.7 server:
# rpm -qa |grep pdo
php-pdo-5.1.6-3.el4s1.10
Now when I try connect to the PostgeSQL db with this code:
<?php
print "PDO test<br />";
try {
$db = new
PDO("pgsql:host=192.168.0.180;port=5432;dbname=mydb;user=test;password=test");
2005 Jul 21
3
Rprof fails in combination with RMySQL
Dear R community,
I tried to optimized my R code by using Rprof. In my R code I'm using MySQL
database connections intensively. After a bunch of queries R fails with the
following error message:
Error in .Call("RS_MySQL_newConnection", drvId, con.params, groups, PACKAGE = .MySQLPkgName) :
RS-DBI driver: (could not connect mylogin@mydatabase on dbname "myDB"
2008 May 05
2
RODBC and schemas
I have found that the "schema.table" syntax used in Postgresql (and
Oracle) does not work directly with RODBC.
This works
library(RODBC)
con<-odbcConnect("mydb")
d<-sqlQuery(con,"select * from meso.trees")
However this does not.
d<-sqlFetch(con,"meso.trees")
Error in odbcTableExists(channel, sqtable) :
?meso.trees?: table not found on channel
2006 Oct 04
1
RODBC: longest string is truncated
Hello R community:
I'm encountering unexpected behaviour as I download string data from
MySQL using the RODBC package. The unexpected behaviour is that the last
character of the string is truncated. As far as I can see, this happens
when some strings are of length 501 or more.
Here's how to reproduce this behaviour.
## In MySQL, pick a database and run this:
CREATE TABLE test (
v1
2008 Jul 21
1
RODBC - problems using odbcDriverConnect without DSN
Hi,
I'm trying to use RODBC without having to set up a DSN, using hte
direct connection string in odbcDriverConnect. My connection attempt
looks something like:
> odbcDriverConnect(connection = "SERVER=localhost;DRIVER={/usr/lib/odbc/libmyodbc.so};DATABASE=myDB;UID=reader;PASSWORD=insecure;")
And this returns the message:
Warning messages:
1: In odbcDriverConnect(connection =