Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Winrar file with password in xp_cmdshell

Author  Topic 

umertahir
Posting Yak Master

154 Posts

Posted - 2010-11-25 : 11:51:05
How do I extract file which is password protected?

I'm using the following line in the xp_cmdshell and also tried it in DOS but it doesn't work:


"C:\Program Files (x86)\WinRAR\WinRar.exe" e -o+ -p[passwordhere] E:\EvaluationsUnit\InterBullFiles\pedigree.bsw.zip E:\EvaluationsUnit\InterBullFiles

umertahir
Posting Yak Master

154 Posts

Posted - 2010-11-25 : 11:53:03
The winrar command options are:


Usage: rar <command> -<switch 1> -<switch N> <archive> <files...>
<@listfiles...> <path_to_extract\>

<Commands>
a Add files to archive
c Add archive comment
cf Add files comment
ch Change archive parameters
cw Write archive comment to file
d Delete files from archive
e Extract files to current directory
f Freshen files in archive
i[par]=<str> Find string in archives
k Lock archive
l[t,b] List archive [technical, bare]
m[f] Move to archive [files only]
p Print file to stdout
r Repair archive
rc Reconstruct missing volumes
rn Rename archived files
rr[N] Add data recovery record
rv[N] Create recovery volumes
s[name|-] Convert archive to or from SFX
t Test archive files
u Update files in archive
v[t,b] Verbosely list archive [technical,bare]
x Extract files with full path

<Switches>
- Stop switches scanning
ac Clear Archive attribute after compression or extraction
ad Append archive name to destination path
ag[format] Generate archive name using the current date
ai Ignore file attributes
ao Add files with Archive attribute set
ap<path> Set path inside archive
as Synchronize archive contents
av Put authenticity verification (registered versions only)
av- Disable authenticity verification check
c- Disable comments show
cfg- Disable read configuration
cl Convert names to lower case
cu Convert names to upper case
df Delete files after archiving
dh Open shared files
dr Delete files to Recycle Bin
ds Disable name sort for solid archive
dw Wipe files after archiving
e[+]<attr> Set file exclude and include attributes
ed Do not add empty directories
en Do not put 'end of archive' block
ep Exclude paths from names
ep1 Exclude base directory from names
ep2 Expand paths to full
ep3 Expand paths to full including the drive letter
f Freshen files
hp[password] Encrypt both file data and headers
id[c,d,p,q] Disable messages
ieml[addr] Send archive by email
ierr Send all messages to stderr
ilog[name] Log errors to file (registered versions only)
inul Disable all messages
ioff Turn PC off after completing an operation
isnd Enable sound
k Lock archive
kb Keep broken extracted files
m<0..5> Set compression level (0-store...3-default...5-maximal)
mc<par> Set advanced compression parameters
md<size> Dictionary size in KB (64,128,256,512,1024,2048,4096 or A-G)
ms[ext;ext] Specify file types to store
mt<threads> Set the number of threads
n<file> Include only specified file
n@ Read file names to include from stdin
n@<list> Include files listed in specified list file
o[+|-] Set the overwrite mode
oc Set NTFS Compressed attribute
or Rename files automatically
os Save NTFS streams
ow Save or restore file owner and group
p[password] Set password
p- Do not query password
r Recurse subdirectories
r- Disable recursion
r0 Recurse subdirectories for wildcard names only
ri<P>[:<S>] Set priority (0-default,1-min..15-max) and sleep time in ms
rr[N] Add data recovery record
rv[N] Create recovery volumes
s[<N>,v[-],e] Create solid archive
s- Disable solid archiving
sc<chr>[obj] Specify the character set
sfx[name] Create SFX archive
si[name] Read data from standard input (stdin)
sl<size> Process files with size less than specified
sm<size> Process files with size more than specified
t Test files after archiving
ta<date> Process files modified after <date> in YYYYMMDDHHMMSS format
tb<date> Process files modified before <date> in YYYYMMDDHHMMSS format
tk Keep original archive time
tl Set archive time to latest file
tn<time> Process files newer than <time>
to<time> Process files older than <time>
ts<m,c,a>[N] Save or restore file time (modification, creation, access)
u Update files
v Create volumes with size autodetection or list all volumes
v<size>[k,b] Create volumes with size=<size>*1000 [*1024, *1]
vd Erase disk contents before creating volume
ver[n] File version control
vn Use the old style volume naming scheme
vp Pause before each volume
w<path> Assign work directory
x<file> Exclude specified file
x@ Read file names to exclude from stdin
x@<list> Exclude files listed in specified list file
y Assume Yes on all queries
z[file] Read archive comment from file
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-11-25 : 19:55:36
Can you elaborate on "doesn't work"? Do you get an error message? Does nothing happen?

If you're extracting plain Zip files, have you tried another (command line) unzip utility? There are several free ones available.
Go to Top of Page

umertahir
Posting Yak Master

154 Posts

Posted - 2010-11-26 : 04:39:26
I get the following message although the same password works when I do it manually:


c:\My Data\pedigree.bsw.zip: Wrong password for pedigree.bsw
c:\My Data\pedigree.bsw.zip: No files to extract




quote:
Originally posted by robvolk

Can you elaborate on "doesn't work"? Do you get an error message? Does nothing happen?

If you're extracting plain Zip files, have you tried another (command line) unzip utility? There are several free ones available.



Go to Top of Page

umertahir
Posting Yak Master

154 Posts

Posted - 2010-11-26 : 05:32:17
I figured out that the following command will work on password protected Rar files:


C:\Program Files\WinRAR>"WinRar.exe" e -o+ -pPasswordHere "E:\EvaluationsUnit\InterBullFiles\pedigree.bsw.zip" "E:\EvaluationsUnit\InterBullFiles\"



Reference: [url]http://teamnirvana.com/blog/extract-multiple-password-protected-rar-files-crack-them-open.html[/url]
Go to Top of Page
   

- Advertisement -