[MonetDB-users] COPY INTO: insufficient privileges: binary COPY INTO requires administrator rights
Hi guys,
i got the following error when COPY INTO TABLE test:
sql>COPY INTO test from ('/home/svom/log3'); COPY INTO: insufficient privileges: binary COPY INTO requires administrator rights
the file "log3" is in mode 777, so i dont know why this happend, thanks for help!
Wan meng
SVOM, NAOC
On Thu, 28 Jun 2012, 万萌 wrote:
sql>COPY INTO test from ('/home/svom/log3');COPY INTO: insufficient privileges: binary COPY INTO requires administrator rights
the file "log3" is in mode 777, so i dont know why this happend, thanks for help!
The problem is that MonetDB was sured so only the 'superuser' on the database has access to the local filesystem.
Stefan
------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
!DSPAM:1,4fec3819296921283719833!
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
!DSPAM:1,4fec3819296921283719833!
On 2012-06-28 13:51, Stefan de Konink wrote:
On Thu, 28 Jun 2012, 万萌 wrote:
sql>COPY INTO test from ('/home/svom/log3');COPY INTO: insufficient privileges: binary COPY INTO requires administrator rights
the file "log3" is in mode 777, so i dont know why this happend, thanks for help!
The problem is that MonetDB was sured so only the 'superuser' on the database has access to the local filesystem.
Nonsense.
The problem is the parentheses. By using parentheses you indicate that the file is a binary file with the data in exactly the right format for MonetDB to use the data without needing to do any parsing. This is only allowed for the database administrator. If your file is actually a CSV file, use the COPY INTO without using parentheses.
On 28-06-2012 14:37:52 +0200, Stefan de Konink wrote:
Nonsense.
Oh dear, is it?
As ordinary user; sql>COPY INTO test from '/tmp/bla'; COPY INTO: insufficient privileges: COPY INTO from file(s) requires administrator rights, use 'COPY INTO "test" FROM STDIN' instead
As you can see, the error message is different here, and it gives a hint as how to perform the operation instead.
On 28-06-2012 17:24:35 +0800, 万萌 wrote:
Hi guys,
i got the following error when COPY INTO TABLE test:
sql>COPY INTO test from ('/home/svom/log3'); COPY INTO: insufficient privileges: binary COPY INTO requires administrator rights
the file "log3" is in mode 777, so i dont know why this happend, thanks for help!
Sjoerd already explained what's going on here. We agree this is confusing, so I changed this behaviour for the upcoming Jul2012 release. Usage of parenthesis will be allowed there, and not trigger special binary mode any more, which you surely didn't intend to use.
Fabian
I have find the solution
you must do COPY INTO from PROMPT OF DOS like this:
C:\Program Files\MonetDB\MonetDB5> mclient -d demo -s " COPY INTO LINEORDER FROM STDIN USING DELIMITERS '|','\n'" - < G:\BDC\DATA\LINEORDER.tbl
LINEORDER IS the table in database and LINEORER.tbl is the text file that contain data to load, and demo is the name of database
万萌 wrote:
Hi guys,
i got the following error when COPY INTO TABLE test:
sql>COPY INTO test from ('/home/svom/log3'); COPY INTO: insufficient privileges: binary COPY INTO requires administrator rights
the file "log3" is in mode 777, so i dont know why this happend, thanks for help!
Wan meng
SVOM, NAOC
Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (5)
-
DADOU -
Fabian Groffen -
Sjoerd Mullender -
Stefan de Konink -
万萌