Re: [R] Install RMySQL with R 2.4.0
This is a test to get my new subscription upgraded. forgive me. thank you Joe Joe Byers wrote: > All, > > I am glad all of you have benefited from the posting of the RMySQL 5-10 > zip file on my university website. I am asking for some help from the > group, I am leaving the university at the end of the semester and I need > a place to post this file until I get settled in my new position. > Anyone that can help me or us out with this. It would be greatly > appreciated. > > Thank you > Joe > > > > Frank McCown wrote: >> Joe Byers wrote: >>> All, >>> >>> After staring at this error message for an hour or so yesterday and this >>> morning. I decided to try something else. Low and behold trying to >>> build the package in cygwin causes R to try and build under linux/unix >>> not windows. I went to the command prompt and was able to build the >>> package. >>> >>> Download the RMySQL...tar.gz file and unzip somewhere like drive:/projects >>> >>> Several notes >>> 1. make sure you have mysql directories on your computer somewhere with >>> the subdirs of include, bin, and lib. You can just copy these from >>> you actual server unless you want to install them. I used d:/mysql/... >>> 2. Modify configure.win in RMySQL and Makevars.win ins RMySQL/src to >>> have the mysql directories from (1) >>> 3. Copy and paste this script to a batch file and execute >>> ** >>> Rem build without --docs=normal tries to build chm help on windows this >>> bombs >>> Rem if a zip program not installed the zip file will not be built >>> Rem go find the temp directory where R built the package and copy to >>> ../R/library >>> Rem temp directory will look something like C:\Temp\Rinst32098657\RMySQL >>> >>> Rem if R bin directory in the path this will run otherwise add the >>> drive:\Dir1\R\bin to the command >>> Rcmd build --binary \projects\RMySQL --docs=normal >>> *** >>> 4. Note that I have --docs=normal in the command line. This is needed to >>> get the package built. Windows packages now default to chm files and >>> RMySQL does not have any windows chm help files. All txt, html, and >>> latex help are built with this option. >>> 5. I am not sure where the RMySQL...zip file is stored, I think in >>> ...R\Bin. I just copied the files from the temp\RinstXX\to the >>> ...\R\library to install. >>> >>> This may or may not work for you, it did for me. >>> >>> I will try and update my website www.cba.utulsa.edu/byersj Research and >>> Analytics section to include a link to the RMySQL zip file for others to >>> download. >>> >>> Good Luck >>> Joe >> >> Joe, >> >> Thanks for telling us how you got RMySQL installed. Would you mind >> posting the dll files so the rest of us wouldn't have to recompile anything? >> >> Thanks, >> Frank >> >> __ >> R-help@stat.math.ethz.ch mailing list >> https://stat.ethz.ch/mailman/listinfo/r-help >> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html >> and provide commented, minimal, self-contained, reproducible code. >> > > __ > R-help@stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] Install RMySQL with R 2.4.0
All, I am glad all of you have benefited from the posting of the RMySQL 5-10 zip file on my university website. I am asking for some help from the group, I am leaving the university at the end of the semester and I need a place to post this file until I get settled in my new position. Anyone that can help me or us out with this. It would be greatly appreciated. Thank you Joe Frank McCown wrote: > Joe Byers wrote: >> All, >> >> After staring at this error message for an hour or so yesterday and this >> morning. I decided to try something else. Low and behold trying to >> build the package in cygwin causes R to try and build under linux/unix >> not windows. I went to the command prompt and was able to build the >> package. >> >> Download the RMySQL...tar.gz file and unzip somewhere like drive:/projects >> >> Several notes >> 1. make sure you have mysql directories on your computer somewhere with >> the subdirs of include, bin, and lib. You can just copy these from >> you actual server unless you want to install them. I used d:/mysql/... >> 2. Modify configure.win in RMySQL and Makevars.win ins RMySQL/src to >> have the mysql directories from (1) >> 3. Copy and paste this script to a batch file and execute >> ** >> Rem build without --docs=normal tries to build chm help on windows this >> bombs >> Rem if a zip program not installed the zip file will not be built >> Rem go find the temp directory where R built the package and copy to >> ../R/library >> Rem temp directory will look something like C:\Temp\Rinst32098657\RMySQL >> >> Rem if R bin directory in the path this will run otherwise add the >> drive:\Dir1\R\bin to the command >> Rcmd build --binary \projects\RMySQL --docs=normal >> *** >> 4. Note that I have --docs=normal in the command line. This is needed to >> get the package built. Windows packages now default to chm files and >> RMySQL does not have any windows chm help files. All txt, html, and >> latex help are built with this option. >> 5. I am not sure where the RMySQL...zip file is stored, I think in >> ...R\Bin. I just copied the files from the temp\RinstXX\to the >> ...\R\library to install. >> >> This may or may not work for you, it did for me. >> >> I will try and update my website www.cba.utulsa.edu/byersj Research and >> Analytics section to include a link to the RMySQL zip file for others to >> download. >> >> Good Luck >> Joe > > > Joe, > > Thanks for telling us how you got RMySQL installed. Would you mind > posting the dll files so the rest of us wouldn't have to recompile anything? > > Thanks, > Frank > > __ > R-help@stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] Install RMySQL with R 2.4.0
Frank, While I was replying to you our IT guys sent me a message as said I could connect. I have posted the RMySQL zip file at http://bus.cba.utulsa.edu/byersj/Research.asp Good luck to all Joe Frank McCown wrote: > Joe Byers wrote: >> All, >> >> After staring at this error message for an hour or so yesterday and this >> morning. I decided to try something else. Low and behold trying to >> build the package in cygwin causes R to try and build under linux/unix >> not windows. I went to the command prompt and was able to build the >> package. >> >> Download the RMySQL...tar.gz file and unzip somewhere like drive:/projects >> >> Several notes >> 1. make sure you have mysql directories on your computer somewhere with >> the subdirs of include, bin, and lib. You can just copy these from >> you actual server unless you want to install them. I used d:/mysql/... >> 2. Modify configure.win in RMySQL and Makevars.win ins RMySQL/src to >> have the mysql directories from (1) >> 3. Copy and paste this script to a batch file and execute >> ** >> Rem build without --docs=normal tries to build chm help on windows this >> bombs >> Rem if a zip program not installed the zip file will not be built >> Rem go find the temp directory where R built the package and copy to >> ../R/library >> Rem temp directory will look something like C:\Temp\Rinst32098657\RMySQL >> >> Rem if R bin directory in the path this will run otherwise add the >> drive:\Dir1\R\bin to the command >> Rcmd build --binary \projects\RMySQL --docs=normal >> *** >> 4. Note that I have --docs=normal in the command line. This is needed to >> get the package built. Windows packages now default to chm files and >> RMySQL does not have any windows chm help files. All txt, html, and >> latex help are built with this option. >> 5. I am not sure where the RMySQL...zip file is stored, I think in >> ...R\Bin. I just copied the files from the temp\RinstXX\to the >> ...\R\library to install. >> >> This may or may not work for you, it did for me. >> >> I will try and update my website www.cba.utulsa.edu/byersj Research and >> Analytics section to include a link to the RMySQL zip file for others to >> download. >> >> Good Luck >> Joe > > > Joe, > > Thanks for telling us how you got RMySQL installed. Would you mind > posting the dll files so the rest of us wouldn't have to recompile anything? > > Thanks, > Frank > > __ > R-help@stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] Install RMySQL with R 2.4.0
Frank, While I was replying to you our IT guys sent me a message as said I could connect. I have posted the RMySQL zip file at http://bus.cba.utulsa.edu/byersj/Research.asp Good luck to all Joe Frank McCown wrote: > Joe Byers wrote: >> All, >> >> After staring at this error message for an hour or so yesterday and this >> morning. I decided to try something else. Low and behold trying to >> build the package in cygwin causes R to try and build under linux/unix >> not windows. I went to the command prompt and was able to build the >> package. >> >> Download the RMySQL...tar.gz file and unzip somewhere like drive:/projects >> >> Several notes >> 1. make sure you have mysql directories on your computer somewhere with >> the subdirs of include, bin, and lib. You can just copy these from >> you actual server unless you want to install them. I used d:/mysql/... >> 2. Modify configure.win in RMySQL and Makevars.win ins RMySQL/src to >> have the mysql directories from (1) >> 3. Copy and paste this script to a batch file and execute >> ** >> Rem build without --docs=normal tries to build chm help on windows this >> bombs >> Rem if a zip program not installed the zip file will not be built >> Rem go find the temp directory where R built the package and copy to >> ../R/library >> Rem temp directory will look something like C:\Temp\Rinst32098657\RMySQL >> >> Rem if R bin directory in the path this will run otherwise add the >> drive:\Dir1\R\bin to the command >> Rcmd build --binary \projects\RMySQL --docs=normal >> *** >> 4. Note that I have --docs=normal in the command line. This is needed to >> get the package built. Windows packages now default to chm files and >> RMySQL does not have any windows chm help files. All txt, html, and >> latex help are built with this option. >> 5. I am not sure where the RMySQL...zip file is stored, I think in >> ...R\Bin. I just copied the files from the temp\RinstXX\to the >> ...\R\library to install. >> >> This may or may not work for you, it did for me. >> >> I will try and update my website www.cba.utulsa.edu/byersj Research and >> Analytics section to include a link to the RMySQL zip file for others to >> download. >> >> Good Luck >> Joe > > > Joe, > > Thanks for telling us how you got RMySQL installed. Would you mind > posting the dll files so the rest of us wouldn't have to recompile anything? > > Thanks, > Frank > > __ > R-help@stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] Install RMySQL with R 2.4.0
Frank, I will post a zip file of the RMySQL 5.10 on my university web site www.cba.utulsa.edu/byersj under the Research and Analytics link in the next day or two. Here at the University we had a major technology problem in the college of business causing IT to move up a migration time table by 3 months. I am waiting on them to reset the security setting on our webserver. As soon at that is done, I will post the file and notify the mailing as well. Good Luck and give me a day or two. Joe Frank McCown wrote: > Joe Byers wrote: >> All, >> >> After staring at this error message for an hour or so yesterday and this >> morning. I decided to try something else. Low and behold trying to >> build the package in cygwin causes R to try and build under linux/unix >> not windows. I went to the command prompt and was able to build the >> package. >> >> Download the RMySQL...tar.gz file and unzip somewhere like drive:/projects >> >> Several notes >> 1. make sure you have mysql directories on your computer somewhere with >> the subdirs of include, bin, and lib. You can just copy these from >> you actual server unless you want to install them. I used d:/mysql/... >> 2. Modify configure.win in RMySQL and Makevars.win ins RMySQL/src to >> have the mysql directories from (1) >> 3. Copy and paste this script to a batch file and execute >> ** >> Rem build without --docs=normal tries to build chm help on windows this >> bombs >> Rem if a zip program not installed the zip file will not be built >> Rem go find the temp directory where R built the package and copy to >> ../R/library >> Rem temp directory will look something like C:\Temp\Rinst32098657\RMySQL >> >> Rem if R bin directory in the path this will run otherwise add the >> drive:\Dir1\R\bin to the command >> Rcmd build --binary \projects\RMySQL --docs=normal >> *** >> 4. Note that I have --docs=normal in the command line. This is needed to >> get the package built. Windows packages now default to chm files and >> RMySQL does not have any windows chm help files. All txt, html, and >> latex help are built with this option. >> 5. I am not sure where the RMySQL...zip file is stored, I think in >> ...R\Bin. I just copied the files from the temp\RinstXX\to the >> ...\R\library to install. >> >> This may or may not work for you, it did for me. >> >> I will try and update my website www.cba.utulsa.edu/byersj Research and >> Analytics section to include a link to the RMySQL zip file for others to >> download. >> >> Good Luck >> Joe > > > Joe, > > Thanks for telling us how you got RMySQL installed. Would you mind > posting the dll files so the rest of us wouldn't have to recompile anything? > > Thanks, > Frank > > __ > R-help@stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] Install RMySQL with R 2.4.0
Joe Byers wrote: > All, > > After staring at this error message for an hour or so yesterday and this > morning. I decided to try something else. Low and behold trying to > build the package in cygwin causes R to try and build under linux/unix > not windows. I went to the command prompt and was able to build the > package. > > Download the RMySQL...tar.gz file and unzip somewhere like drive:/projects > > Several notes > 1. make sure you have mysql directories on your computer somewhere with > the subdirs of include, bin, and lib. You can just copy these from > you actual server unless you want to install them. I used d:/mysql/... > 2. Modify configure.win in RMySQL and Makevars.win ins RMySQL/src to > have the mysql directories from (1) > 3. Copy and paste this script to a batch file and execute > ** > Rem build without --docs=normal tries to build chm help on windows this > bombs > Rem if a zip program not installed the zip file will not be built > Rem go find the temp directory where R built the package and copy to > ../R/library > Rem temp directory will look something like C:\Temp\Rinst32098657\RMySQL > > Rem if R bin directory in the path this will run otherwise add the > drive:\Dir1\R\bin to the command > Rcmd build --binary \projects\RMySQL --docs=normal > *** > 4. Note that I have --docs=normal in the command line. This is needed to > get the package built. Windows packages now default to chm files and > RMySQL does not have any windows chm help files. All txt, html, and > latex help are built with this option. > 5. I am not sure where the RMySQL...zip file is stored, I think in > ...R\Bin. I just copied the files from the temp\RinstXX\to the > ...\R\library to install. > > This may or may not work for you, it did for me. > > I will try and update my website www.cba.utulsa.edu/byersj Research and > Analytics section to include a link to the RMySQL zip file for others to > download. > > Good Luck > Joe Joe, Thanks for telling us how you got RMySQL installed. Would you mind posting the dll files so the rest of us wouldn't have to recompile anything? Thanks, Frank __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] Install RMySQL with R 2.4.0
l] Error 1 > make[2]: *** [srcDynlib] Error 2 > make[1]: *** [all] Error 2 > make: *** [pkg-RMySQL] Error 2 > *** Installation of RMySQL failed *** > > Removing 'c:/TEMP/Rinst250866757/RMySQL' > ERROR > * installation failed > > > [EMAIL PROTECTED] /cygdrive/d/Program Files/R/bin > $ > ** end if cygwin window *** > > Any help would be greatly appreciated. > > Thank you > Joe > > Dan Rie wrote: > > I have not replied to the list with this response, because, it's kind > of vacuous. But here are my thoughts: > > > > When I was working on getting RMySQL installed, I decided to do the > install on a machine on my LAN that did not have MySQL installed. I > retrieved all the tools to do R builds with Windows (the biggest hurdle > I faced in the whole process of trying to install RMySQL was getting > prepared to build R packages under Windows). So far I have not > succeeded on that machine. However, I did succeed on another machine > that had MySQL installed. > > > > So, I suggest that there are two possible approaches: Copy the MySQL > files that you will need onto the machine that does not have MySQL > installed. That may sound weird, but it is actually not all that > demanding. On Windows, these are the folders like "C:\Program > Files\MySQL\MYSQLS~1.0\lib", "C:\Program > Files\MySQL\MYSQLS~1.0\include", and "C:\Program > Files\MySQL\MYSQLS~1.0\bin" (there may be a few others as well). You > will need to have the various header files (for C) and the library files > and definitions. I was working with Windows and I think that you are > working with Linux, but the principle is the same - you need to have the > MySQL resource files available in order to build the RMySQL package. > There are lots of clues in the RMySQL readme and help files. > > > > It's probably easier to just install MySQL on your machine and then > you will have the files appropriate to building RMySQL available. I > don't think that you actually need to have the same version of MySQL > installed as you may be accessing on a server. However, you do have to > have some version of the libmysql library to link with the RMySQL > package in order to generate the appropriate messages to send to the server. > > > > It's not really very hard to install MySQL on your machine, even if > you don't plan to use it. I believe that when you install it it will > default to running the MySQL server on boot, but you can fix that easily > if you don't want it running (a possible security and configuration issue). > > > > If you don't have MySQL installed on your machine at all, then you > have fewer issues of incompatibility to worry about than I did. Perhaps > a fresh update of the RMySQL package will deliver a working install. I > know that the package was recently rebuilt for distribution, and the > latest version may resolve the problem if it is different from the one > that you are using. > > > > If you are still having a problem, send more specific info, and I'll > try to comment, but I am certainly no expert in R package installation > (although I do have this one success to my credit). > > > > Dan Rie > > Scituate, MA > > > > > > - Original Message - From: "Joe Byers" <[EMAIL PROTECTED]> > > To: "Dan Rie" <[EMAIL PROTECTED]> > > Cc: > > Sent: Monday, November 06, 2006 6:25 PM > > Subject: Re: [R] Install RMySQL with R 2.4.0 > > > > > >> > >> Dan Rie wrote: > >>> I had a very similar problem installing RMySQL with R 2.4.0 on > Windows XP. > >>> I beleive that the cause may have been that the RMySQL build used a > slightly older version of the MySQL compiled library functions than was > installed on my machine (I updated both MySQL, DBI, and RMySQL to latest > versions prior to attempting the install). Since RMySQL links to the > compiled MySQL library, slight differences could affect the linked > references. I do not know that this is the source of the problem, but > it was one obvious point of fraility. > >>> > >>> The solution, suggested by Prof. Brian Ripley on the r-sig-db list, > was to rebuild the RMySQL library from source prior to doing the > install. After completing the recompilation of the RMySQL package, the > install worked as it should. I believe that the binaries for RMySQL may > have been updated since I had those problems, so you might also want to > make sure tha
Re: [R] Install RMySQL with R 2.4.0
r a working install. I
know that the package was recently rebuilt for distribution, and the
latest version may resolve the problem if it is different from the one
that you are using.
>
> If you are still having a problem, send more specific info, and I'll
try to comment, but I am certainly no expert in R package installation
(although I do have this one success to my credit).
>
> Dan Rie
> Scituate, MA
>
>
> - Original Message - From: "Joe Byers" <[EMAIL PROTECTED]>
> To: "Dan Rie" <[EMAIL PROTECTED]>
> Cc:
> Sent: Monday, November 06, 2006 6:25 PM
> Subject: Re: [R] Install RMySQL with R 2.4.0
>
>
>>
>> Dan Rie wrote:
>>> I had a very similar problem installing RMySQL with R 2.4.0 on
Windows XP.
>>> I beleive that the cause may have been that the RMySQL build used a
slightly older version of the MySQL compiled library functions than was
installed on my machine (I updated both MySQL, DBI, and RMySQL to latest
versions prior to attempting the install). Since RMySQL links to the
compiled MySQL library, slight differences could affect the linked
references. I do not know that this is the source of the problem, but
it was one obvious point of fraility.
>>>
>>> The solution, suggested by Prof. Brian Ripley on the r-sig-db list,
was to rebuild the RMySQL library from source prior to doing the
install. After completing the recompilation of the RMySQL package, the
install worked as it should. I believe that the binaries for RMySQL may
have been updated since I had those problems, so you might also want to
make sure that you have the latest version of all the packages.
>>>
>> What do you do if you are accessing the Mysql server remotely from
the machine that R is install upon. No MYsql libraries or other files
are stored on either of my computers.
>>
>> Thank you
>>
>>>
>>> Date: Sat, 04 Nov 2006 23:53:11 -0600
>>> From: "Joe W. Byers" <[EMAIL PROTECTED]>
>>> Subject: Re: [R] Install RMySQL with R 2.4.0
>>> To: r-help@stat.math.ethz.ch
>>> Message-ID: <[EMAIL PROTECTED]>
>>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>>>
>>> Seth Falcon wrote:
>>>> "Joe W. Byers" <[EMAIL PROTECTED]> writes:
>>>>
>>>>> I am having trouble as well with the new version of R 2.4. I
downloaded
>>>>> the gz file from the cran website, followed the instructions in the
>>>>> README.win file and installed RMySQL. I have mysql installed under
>>>>> c:\mysql not the program files directory which is the only
difference.
>>>>>
>>>>> I get the following error when I attempt to connect to the MySQL Db
>>>>> > ## open a connection to a MySQL database
>>>>> > con <- dbConnect(dbDriver("MySQL"),host='localhost',
>>>>> + username='',dbname = 'StorageSims');
>>>>> Error in function (classes, fdef, mtable) :
>>>>> unable to find an inherited method for function "dbConnect",
>>>>> for signature "MySQLDriver"
>>>>> >
>>>>>
>>>>> Any help will be appreciated. I would like to note that there are no
>>>>> problems with RMySQL on my linux system, only on XP's.
>>>>
>>>> Just to make sure:
>>>>
>>>> Before trying the code you posted, you did library("RMySQL"), right?
>>> YES
>>>>
>>>> Also, what versions of DBI and RMySQL are you using?
>>> RMySQL from
http://cran.r-project.org/src/contrib/Descriptions/RMySQL.html
>>> DBI Version 0.1-10 according to the NEWS file in ../R/library
>>>>
>>>> __
>>>> R-help@stat.math.ethz.ch mailing list
>>>> https://stat.ethz.ch/mailman/listinfo/r-help
>>>> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
>>>> and provide commented, minimal, self-contained, reproducible code.
>>>>
>>>
>>>
>>>
>>
>>
>>
>
>
Dan Rie wrote:
> I had a very similar problem installing RMySQL with R 2.4.0 on Windows XP.
> I beleive that the cause may have been that the RMySQL build used a slightly
> older version of the MySQL compiled library functions than was installed on
> my machine (I updated both MySQL, DBI, and RMySQL to latest versions prior
> to attempt
Re: [R] Install RMySQL with R 2.4.0
Dan Rie wrote:
> I had a very similar problem installing RMySQL with R 2.4.0 on
> Windows XP.
> I beleive that the cause may have been that the RMySQL build used a
> slightly older version of the MySQL compiled library functions than
> was installed on my machine (I updated both MySQL, DBI, and RMySQL to
> latest versions prior to attempting the install). Since RMySQL links
> to the compiled MySQL library, slight differences could affect the
> linked references. I do not know that this is the source of the
> problem, but it was one obvious point of fraility.
>
> The solution, suggested by Prof. Brian Ripley on the r-sig-db list,
> was to rebuild the RMySQL library from source prior to doing the
> install. After completing the recompilation of the RMySQL package,
> the install worked as it should. I believe that the binaries for
> RMySQL may have been updated since I had those problems, so you might
> also want to make sure that you have the latest version of all the
> packages.
>
What do you do if you are accessing the Mysql server remotely from the
machine that R is install upon. No MYsql libraries or other files are
stored on either of my computers.
Thank you
>
> Date: Sat, 04 Nov 2006 23:53:11 -0600
> From: "Joe W. Byers" <[EMAIL PROTECTED]>
> Subject: Re: [R] Install RMySQL with R 2.4.0
> To: r-help@stat.math.ethz.ch
> Message-ID: <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Seth Falcon wrote:
>> "Joe W. Byers" <[EMAIL PROTECTED]> writes:
>>
>>> I am having trouble as well with the new version of R 2.4. I
>>> downloaded
>>> the gz file from the cran website, followed the instructions in the
>>> README.win file and installed RMySQL. I have mysql installed under
>>> c:\mysql not the program files directory which is the only difference.
>>>
>>> I get the following error when I attempt to connect to the MySQL Db
>>> > ## open a connection to a MySQL database
>>> > con <- dbConnect(dbDriver("MySQL"),host='localhost',
>>> + username='',dbname = 'StorageSims');
>>> Error in function (classes, fdef, mtable) :
>>> unable to find an inherited method for function "dbConnect",
>>> for signature "MySQLDriver"
>>> >
>>>
>>> Any help will be appreciated. I would like to note that there are no
>>> problems with RMySQL on my linux system, only on XP's.
>>
>> Just to make sure:
>>
>> Before trying the code you posted, you did library("RMySQL"), right?
> YES
>>
>> Also, what versions of DBI and RMySQL are you using?
> RMySQL from
> http://cran.r-project.org/src/contrib/Descriptions/RMySQL.html
> DBI Version 0.1-10 according to the NEWS file in ../R/library
>>
>> __
>> R-help@stat.math.ethz.ch mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-help
>> PLEASE do read the posting guide
>> http://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>>
>
>
>
__
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Re: [R] Install RMySQL with R 2.4.0
I noticed that RMySQL is now at version 0.5-10, but the libMySQL.dll and RMySQL.dll files that are required for Windows are missing from the distribution. These files were present in previous versions of RMySQL, and the installation instructions still state they are needed. I have an older version of RMySQL working with R-2.3.0 on Windows XP, but when I try to run RMySQL_0.5-10 with R-2.4.0 I get the following error message: > library (RMySQL); Error in library(RMySQL) : 'RMySQL' is not a valid package -- installed < 2.0.0? This is after updating the DBI package and installing RMySQL on R-2.4.0. Of course I wouldn't expect RMySQL_0.5-10 to work since the DLLs have not been included in the distribution. Does anyone have an updated email address for David A. James, the maintainer for RMySQL? The address included in the distribution appears to be no longer valid. Thanks, Frank -- Frank McCown Old Dominion University http://www.cs.odu.edu/~fmccown/ __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] Install RMySQL with R 2.4.0
"Joe W. Byers" <[EMAIL PROTECTED]> writes:
> Seth Falcon wrote:
>> "Joe W. Byers" <[EMAIL PROTECTED]> writes:
>>
>>> I am having trouble as well with the new version of R 2.4. I downloaded
>>> the gz file from the cran website, followed the instructions in the
>>> README.win file and installed RMySQL. I have mysql installed under
>>> c:\mysql not the program files directory which is the only difference.
>>>
>>> I get the following error when I attempt to connect to the MySQL Db
>>> > ## open a connection to a MySQL database
>>> > con <- dbConnect(dbDriver("MySQL"),host='localhost',
>>> + username='',dbname = 'StorageSims');
>>> Error in function (classes, fdef, mtable) :
>>> unable to find an inherited method for function "dbConnect",
>>> for signature "MySQLDriver"
>>> >
>>>
>>> Any help will be appreciated. I would like to note that there are no
>>> problems with RMySQL on my linux system, only on XP's.
>>
>> Just to make sure:
>>
>> Before trying the code you posted, you did library("RMySQL"), right?
> YES
>>
>> Also, what versions of DBI and RMySQL are you using?
> RMySQL from http://cran.r-project.org/src/contrib/Descriptions/RMySQL.html
> DBI Version 0.1-10 according to the NEWS file in ../R/library
Try updating DBI, the RMySQL on CRAN has:
Depends:R (>= 2.3.0), methods, DBI (>= 0.1-11)
__
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Re: [R] Install RMySQL with R 2.4.0
I had a very similar problem installing RMySQL with R 2.4.0 on Windows XP.
I beleive that the cause may have been that the RMySQL build used a slightly
older version of the MySQL compiled library functions than was installed on
my machine (I updated both MySQL, DBI, and RMySQL to latest versions prior
to attempting the install). Since RMySQL links to the compiled MySQL
library, slight differences could affect the linked references. I do not
know that this is the source of the problem, but it was one obvious point of
fraility.
The solution, suggested by Prof. Brian Ripley on the r-sig-db list, was to
rebuild the RMySQL library from source prior to doing the install. After
completing the recompilation of the RMySQL package, the install worked as it
should. I believe that the binaries for RMySQL may have been updated since
I had those problems, so you might also want to make sure that you have the
latest version of all the packages.
Date: Sat, 04 Nov 2006 23:53:11 -0600
From: "Joe W. Byers" <[EMAIL PROTECTED]>
Subject: Re: [R] Install RMySQL with R 2.4.0
To: r-help@stat.math.ethz.ch
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Seth Falcon wrote:
> "Joe W. Byers" <[EMAIL PROTECTED]> writes:
>
>> I am having trouble as well with the new version of R 2.4. I downloaded
>> the gz file from the cran website, followed the instructions in the
>> README.win file and installed RMySQL. I have mysql installed under
>> c:\mysql not the program files directory which is the only difference.
>>
>> I get the following error when I attempt to connect to the MySQL Db
>> > ## open a connection to a MySQL database
>> > con <- dbConnect(dbDriver("MySQL"),host='localhost',
>> + username='',dbname = 'StorageSims');
>> Error in function (classes, fdef, mtable) :
>> unable to find an inherited method for function "dbConnect",
>> for signature "MySQLDriver"
>> >
>>
>> Any help will be appreciated. I would like to note that there are no
>> problems with RMySQL on my linux system, only on XP's.
>
> Just to make sure:
>
> Before trying the code you posted, you did library("RMySQL"), right?
YES
>
> Also, what versions of DBI and RMySQL are you using?
RMySQL from http://cran.r-project.org/src/contrib/Descriptions/RMySQL.html
DBI Version 0.1-10 according to the NEWS file in ../R/library
>
> __
> R-help@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
__
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Re: [R] Install RMySQL with R 2.4.0
Seth Falcon wrote:
> "Joe W. Byers" <[EMAIL PROTECTED]> writes:
>
>> I am having trouble as well with the new version of R 2.4. I downloaded
>> the gz file from the cran website, followed the instructions in the
>> README.win file and installed RMySQL. I have mysql installed under
>> c:\mysql not the program files directory which is the only difference.
>>
>> I get the following error when I attempt to connect to the MySQL Db
>> > ## open a connection to a MySQL database
>> > con <- dbConnect(dbDriver("MySQL"),host='localhost',
>> + username='',dbname = 'StorageSims');
>> Error in function (classes, fdef, mtable) :
>> unable to find an inherited method for function "dbConnect",
>> for signature "MySQLDriver"
>> >
>>
>> Any help will be appreciated. I would like to note that there are no
>> problems with RMySQL on my linux system, only on XP's.
>
> Just to make sure:
>
> Before trying the code you posted, you did library("RMySQL"), right?
YES
>
> Also, what versions of DBI and RMySQL are you using?
RMySQL from http://cran.r-project.org/src/contrib/Descriptions/RMySQL.html
DBI Version 0.1-10 according to the NEWS file in ../R/library
>
> __
> R-help@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
__
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Re: [R] Install RMySQL with R 2.4.0
"Joe W. Byers" <[EMAIL PROTECTED]> writes:
> I am having trouble as well with the new version of R 2.4. I downloaded
> the gz file from the cran website, followed the instructions in the
> README.win file and installed RMySQL. I have mysql installed under
> c:\mysql not the program files directory which is the only difference.
>
> I get the following error when I attempt to connect to the MySQL Db
> > ## open a connection to a MySQL database
> > con <- dbConnect(dbDriver("MySQL"),host='localhost',
> + username='',dbname = 'StorageSims');
> Error in function (classes, fdef, mtable) :
> unable to find an inherited method for function "dbConnect",
> for signature "MySQLDriver"
> >
>
> Any help will be appreciated. I would like to note that there are no
> problems with RMySQL on my linux system, only on XP's.
Just to make sure:
Before trying the code you posted, you did library("RMySQL"), right?
Also, what versions of DBI and RMySQL are you using?
__
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Re: [R] Install RMySQL with R 2.4.0
I am having trouble as well with the new version of R 2.4. I downloaded
the gz file from the cran website, followed the instructions in the
README.win file and installed RMySQL. I have mysql installed under
c:\mysql not the program files directory which is the only difference.
I get the following error when I attempt to connect to the MySQL Db
> ## open a connection to a MySQL database
> con <- dbConnect(dbDriver("MySQL"),host='localhost',
+ username='',dbname = 'StorageSims');
Error in function (classes, fdef, mtable) :
unable to find an inherited method for function "dbConnect",
for signature "MySQLDriver"
>
Any help will be appreciated. I would like to note that there are no
problems with RMySQL on my linux system, only on XP's.
Thank you
Joe
Frank McCown wrote:
> I just installed RMySQL 0.5-9 with R 2.4.0 on Windows XP and got the
> following error message when trying to run a script with RMySQL:
>
> Error in library(RMySQL) : 'RMySQL' is not a valid package -- installed
> < 2.0.0?
>
> Any ideas?
>
> Thanks,
> Frank
>
> __
> R-help@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
__
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
[R] Install RMySQL with R 2.4.0
I just installed RMySQL 0.5-9 with R 2.4.0 on Windows XP and got the following error message when trying to run a script with RMySQL: Error in library(RMySQL) : 'RMySQL' is not a valid package -- installed < 2.0.0? Any ideas? Thanks, Frank __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
