Skip to content

errors when install RSQLite

3 messages · Dongyan Song, ronggui

Dongyan Song
# 
Dear all,

I am trying to install RSQLite package since I want to install "sqldf", and
I used
make: *** [RS-DBI.o] Error 1
chmod: cannot access `/usr/lib/R/library/RSQLite/libs/*': No such file or
directory
ERROR: compilation failed for package 'RSQLite'
** Removing '/usr/lib/R/library/RSQLite'
** Restoring previous '/usr/lib/R/library/RSQLite'

The downloaded packages are in
	/tmp/RtmpZwBFdo/downloaded_packages
Updating HTML index of packages in '.Library'
Warning message:
In install.packages("RSQLite") :
  installation of package 'RSQLite' had non-zero exit status

And then I tried   
# R CMD INSTALL RSQLite_0.7-1.tar.gz
# R CMD INSTALL
--configure-args=--with-sqlite3-dir=/usr/lib/sqlite-3.6.11/bld/
RSQLite_0.7-1.tar.gz 
# R CMD INSTALL --configure-args=--with-sqlite-dir=/usr/bin
RSQLite_0.7-1.tar.gz
and all of them gave similar error messages.

I have sqlite installed in my computer, in the directory /usr/bin, and I do
not have a clue how to install it then. Thank you for help!

Best,
Dongyan Song
ronggui
# 
It seems you use Unix-like OS. Does it happen that you did not use
root to install the package? BTW, RSQLite does not require sqlite
installed separately, it is embedded in the package.

Best

2009/3/17 Dongyan Song <yzhskdls at hotmail.com>:

  
    

      
      
    

  


  


      

    

    

      
      

        


  

        

      Dongyan Song
    

    

      
      #
    

  


  

      
Hello,

I do loggin as root, and I tried three methods listed in INSTALL file in
RSQLite, but still did not work. The whole error list is:
** libs
WARNING: R include directory is empty -- perhaps need to install R-devel.rpm
or similar
gcc -std=gnu99 -I/usr/lib/R/include -DRSQLITE_USE_BUNDLED_SQLITE
-DSQLITE_MAX_SQL_LENGTH=2000000 -DSQLITE_ENABLE_RTREE=1 -DTHREADSAFE=0
-I/usr/local/include    -fpic  -march=i586 -mtune=i686 -fmessage-length=0
-O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables
-fasynchronous-unwind-tables -c RS-DBI.c -o RS-DBI.o
In file included from RS-DBI.h:32,
                 from RS-DBI.c:19:
Rhelpers.h:16:24: error: Rversion.h: No such file or directory
Rhelpers.h:18:24: error: Rdefines.h: No such file or directory
Rhelpers.h:19:17: error: S.h: No such file or directory
Rhelpers.h:75:49: error: missing binary operator before token "("
Rhelpers.h:93:49: error: missing binary operator before token "("
In file included from RS-DBI.c:19:
RS-DBI.h:102: error: expected specifier-qualifier-list before ?SEXPTYPE?
RS-DBI.h:172: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_allocManager?
RS-DBI.h:175: error: expected ?)? before ?mgrHandle?
RS-DBI.h:176: error: expected ?)? before ?handle?
RS-DBI.h:177: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_asMgrHandle?
RS-DBI.h:178: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_managerInfo?
RS-DBI.h:181: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_allocConnection?
RS-DBI.h:183: error: expected ?)? before ?conHandle?
RS-DBI.h:184: error: expected ?)? before ?handle?
RS-DBI.h:185: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_asConHandle?
RS-DBI.h:186: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_connectionInfo?
RS-DBI.h:189: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_allocResultSet?
RS-DBI.h:190: error: expected ?)? before ?rsHandle?
RS-DBI.h:191: error: expected ?)? before ?rsHandle?
RS-DBI.h:192: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_asResHandle?
RS-DBI.h:193: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_resultSetInfo?
RS-DBI.h:196: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_validHandle?
RS-DBI.h:197: error: expected ?)? before ?handle?
RS-DBI.h:215: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_getFieldDescriptions?
RS-DBI.h:222: error: expected ?)? before ?output?
RS-DBI.h:226: error: expected ?)? before ?data?
RS-DBI.h:233: error: expected ?)? before ?handle?
RS-DBI.h:255: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_SclassNames?
RS-DBI.h:257: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_createNamedList?
RS-DBI.h:261: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_copyFields?
RS-DBI.h:263: error: expected declaration specifiers or ?...? before
?SEXPTYPE?
RS-DBI.h:264: error: expected declaration specifiers or ?...? before
?SEXPTYPE?
RS-DBI.c:21:22: error: R_ext/RS.h: No such file or directory
RS-DBI.c:35: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_allocManager?
RS-DBI.c:107: error: expected ?)? before ?mgrHandle?
RS-DBI.c:136: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_allocConnection?
RS-DBI.c:205: error: expected ?)? before ?conHandle?
RS-DBI.c:260: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_allocResultSet?
RS-DBI.c:307: error: expected ?)? before ?rsHandle?
RS-DBI.c: In function ?RS_DBI_allocFields?:
RS-DBI.c:348: warning: implicit declaration of function ?malloc?
RS-DBI.c:348: warning: incompatible implicit declaration of built-in
function ?malloc?
RS-DBI.c:355: warning: implicit declaration of function ?calloc?
RS-DBI.c:355: warning: incompatible implicit declaration of built-in
function ?calloc?
RS-DBI.c:362: error: ?RS_DBI_fields? has no member named ?Sclass?
RS-DBI.c:362: error: ?SEXPTYPE? undeclared (first use in this function)
RS-DBI.c:362: error: (Each undeclared identifier is reported only once
RS-DBI.c:362: error: for each function it appears in.)
RS-DBI.c:362: error: expected expression before ?)? token
RS-DBI.c: In function ?RS_DBI_freeFields?:
RS-DBI.c:370: warning: implicit declaration of function ?free?
RS-DBI.c:370: warning: incompatible implicit declaration of built-in
function ?free?
RS-DBI.c:371: warning: incompatible implicit declaration of built-in
function ?free?
RS-DBI.c:372: warning: incompatible implicit declaration of built-in
function ?free?
RS-DBI.c:373: warning: incompatible implicit declaration of built-in
function ?free?
RS-DBI.c:374: warning: incompatible implicit declaration of built-in
function ?free?
RS-DBI.c:375: warning: incompatible implicit declaration of built-in
function ?free?
RS-DBI.c:376: warning: incompatible implicit declaration of built-in
function ?free?
RS-DBI.c:377: error: ?RS_DBI_fields? has no member named ?Sclass?
RS-DBI.c:377: warning: incompatible implicit declaration of built-in
function ?free?
RS-DBI.c:377: error: ?RS_DBI_fields? has no member named ?Sclass?
RS-DBI.c:378: warning: incompatible implicit declaration of built-in
function ?free?
RS-DBI.c: At top level:
RS-DBI.c:388: error: expected ?)? before ?data?
RS-DBI.c:412: error: expected ?)? before ?output?
RS-DBI.c:468: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_validHandle?
RS-DBI.c:491: error: expected ?)? before ?handle?
RS-DBI.c: In function ?RS_DBI_errorMessage?:
RS-DBI.c:526: error: ?PROBLEM? undeclared (first use in this function)
RS-DBI.c:526: error: expected ?;? before string constant
RS-DBI.c:529: error: expected ?;? before string constant
RS-DBI.c:532: error: expected ?;? before string constant
RS-DBI.c:535: error: expected ?;? before string constant
RS-DBI.c:522: warning: unused variable ?driver?
RS-DBI.c: In function ?DBI_MSG?:
RS-DBI.c:545: error: ?PROBLEM? undeclared (first use in this function)
RS-DBI.c:545: error: expected ?;? before string constant
RS-DBI.c:548: error: expected ?;? before string constant
RS-DBI.c:551: error: expected ?;? before string constant
RS-DBI.c:554: error: expected ?;? before string constant
RS-DBI.c: In function ?RS_DBI_copyString?:
RS-DBI.c:566: warning: incompatible implicit declaration of built-in
function ?malloc?
RS-DBI.c:566: warning: implicit declaration of function ?strlen?
RS-DBI.c:566: warning: incompatible implicit declaration of built-in
function ?strlen?
RS-DBI.c:571: warning: implicit declaration of function ?strcpy?
RS-DBI.c:571: warning: incompatible implicit declaration of built-in
function ?strcpy?
RS-DBI.c: In function ?RS_DBI_nCopyString?:
RS-DBI.c:580: warning: incompatible implicit declaration of built-in
function ?malloc?
RS-DBI.c:583: warning: implicit declaration of function ?sprintf?
RS-DBI.c:583: warning: incompatible implicit declaration of built-in
function ?sprintf?
RS-DBI.c:593: warning: implicit declaration of function ?strncpy?
RS-DBI.c:593: warning: incompatible implicit declaration of built-in
function ?strncpy?
RS-DBI.c: At top level:
RS-DBI.c:609: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_copyfields?
RS-DBI.c:641: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_createNamedList?
RS-DBI.c:679: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_SclassNames?
RS-DBI.c:711: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_asMgrHandle?
RS-DBI.c:722: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_asConHandle?
RS-DBI.c:734: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_asResHandle?
RS-DBI.c:747: error: expected ?)? before ?handle?
RS-DBI.c:762: error: expected ?)? before ?conHandle?
RS-DBI.c:781: error: expected ?)? before ?rsHandle?
RS-DBI.c:856: error: expected ?)? before ?handle?
RS-DBI.c:907: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_managerInfo?
RS-DBI.c:943: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_connectionInfo?
RS-DBI.c:978: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__? before
?RS_DBI_resultSetInfo?
RS-DBI.c:1007: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__?
before ?RS_DBI_getFieldDescriptions?
RS-DBI.c: In function ?RS_DBI_getTypeName?:
RS-DBI.c:1050: warning: incompatible implicit declaration of built-in
function ?sprintf?
RS-DBI.c: At top level:
RS-DBI.c:1073: error: expected ?=?, ?,?, ?;?, ?asm? or ?__attribute__?
before ?RS_DBI_makeSQLNames?
RS-DBI.c:1120: error: expected declaration specifiers or ?...? before
?SEXPTYPE?
RS-DBI.c: In function ?RS_na_set?:
RS-DBI.c:1125: error: ?type? undeclared (first use in this function)
RS-DBI.c:1126: error: ?INTSXP? undeclared (first use in this function)
RS-DBI.c:1128: error: ?NA_INTEGER? undeclared (first use in this function)
RS-DBI.c:1130: error: ?LGLSXP? undeclared (first use in this function)
RS-DBI.c:1132: error: ?NA_LOGICAL? undeclared (first use in this function)
RS-DBI.c:1134: error: ?REALSXP? undeclared (first use in this function)
RS-DBI.c:1136: error: ?NA_REAL? undeclared (first use in this function)
RS-DBI.c:1138: error: ?CHARSXP? undeclared (first use in this function)
RS-DBI.c:1140: warning: implicit declaration of function ?CHAR?
RS-DBI.c:1140: error: ?NA_STRING? undeclared (first use in this function)
RS-DBI.c:1140: warning: assignment makes pointer from integer without a cast
RS-DBI.c: At top level:
RS-DBI.c:1145: error: expected declaration specifiers or ?...? before
?SEXPTYPE?
RS-DBI.c: In function ?RS_is_na?:
RS-DBI.c:1151: error: ?type? undeclared (first use in this function)
RS-DBI.c:1152: error: ?INTSXP? undeclared (first use in this function)
RS-DBI.c:1153: error: ?LGLSXP? undeclared (first use in this function)
RS-DBI.c:1155: error: ?NA_INTEGER? undeclared (first use in this function)
RS-DBI.c:1157: error: ?REALSXP? undeclared (first use in this function)
RS-DBI.c:1159: warning: implicit declaration of function ?ISNA?
RS-DBI.c:1161: error: ?CHARSXP? undeclared (first use in this function)
RS-DBI.c:1163: warning: implicit declaration of function ?strcmp?
RS-DBI.c:1163: error: ?NA_STRING? undeclared (first use in this function)
RS-DBI.c: At top level:
RS-DBI.c:1171: error: ?NILSXP? undeclared here (not in a function)
RS-DBI.c:1172: error: ?SYMSXP? undeclared here (not in a function)
RS-DBI.c:1173: error: ?LISTSXP? undeclared here (not in a function)
RS-DBI.c:1174: error: ?CLOSXP? undeclared here (not in a function)
RS-DBI.c:1175: error: ?ENVSXP? undeclared here (not in a function)
RS-DBI.c:1176: error: ?PROMSXP? undeclared here (not in a function)
RS-DBI.c:1177: error: ?LANGSXP? undeclared here (not in a function)
RS-DBI.c:1178: error: ?SPECIALSXP? undeclared here (not in a function)
RS-DBI.c:1179: error: ?BUILTINSXP? undeclared here (not in a function)
RS-DBI.c:1180: error: ?CHARSXP? undeclared here (not in a function)
RS-DBI.c:1181: error: ?LGLSXP? undeclared here (not in a function)
RS-DBI.c:1182: error: ?INTSXP? undeclared here (not in a function)
RS-DBI.c:1183: error: ?REALSXP? undeclared here (not in a function)
RS-DBI.c:1184: error: ?CPLXSXP? undeclared here (not in a function)
RS-DBI.c:1185: error: ?STRSXP? undeclared here (not in a function)
RS-DBI.c:1186: error: ?DOTSXP? undeclared here (not in a function)
RS-DBI.c:1187: error: ?ANYSXP? undeclared here (not in a function)
RS-DBI.c:1188: error: ?EXPRSXP? undeclared here (not in a function)
RS-DBI.c:1189: error: ?VECSXP? undeclared here (not in a function)
make: *** [RS-DBI.o] Error 1
chmod: cannot access `/usr/lib/R/library/RSQLite/libs/*': No such file or
directory
ERROR: compilation failed for package 'RSQLite'
** Removing '/usr/lib/R/library/RSQLite'
** Restoring previous '/usr/lib/R/library/RSQLite'

Thanks again!
Best,
Dongyan

        
ronggui-2 wrote: