|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, March 17, 2010 4:35 PM
Points: 1,133,
Visits: 703
|
|
jsleichty (7/25/2008)
Has anyone used the xp_blowfish dll on SQL 2005? We just moved to a new server and we're getting error messages to the effect.
Could not load the DLL C:\Program Files\Microsoft SQL Server\90\Tools\binn\Encryption DLL\xp_blowfishdecrypt.dll, or one of the DLLs it references. Reason: 193(C:\Program Files\Microsoft SQL Server\90\Tools\binn\Encryption DLL\xp_blowfishdecrypt.dll is not a valid Win32 application.).
Hi js,
You don't happen to be running it on a 64-bit server do you? The DLL was only compiled for 32 bit. The source code is available somewhere on SSC (sorry I don't have a current link), but you could d/l and compile for 64 bit if necessary. I usually recommend avoiding XPs on SQL 2005, since they are deprecated. In this instance SQL 2005 provides native T-SQL encryption functionality.
Thanks
Mike C
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Thursday, March 11, 2010 2:55 PM
Points: 5,
Visits: 40
|
|
I am trying to decrypt data that was encrypted via PHP/mcrypt and stored in a MySQL database originally. We have a SQL Server that needs to process some of the data, and I am unable to decrypt any of the data using the blowfish decrypt xp.
I can encrypt and decrypt fine on SQL Server, but am having difficulty with the data originating on the other system.
Thanks
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, March 17, 2010 4:35 PM
Points: 1,133,
Visits: 703
|
|
Ed Mays (10/6/2008)
I am trying to decrypt data that was encrypted via PHP/mcrypt and stored in a MySQL database originally. We have a SQL Server that needs to process some of the data, and I am unable to decrypt any of the data using the blowfish decrypt xp.
I can encrypt and decrypt fine on SQL Server, but am having difficulty with the data originating on the other system.
Thanks
Hi Ed,
The data encrypted in PHP/mcrypt could have been encrypted with any number of options, and was probably encrypted with a different key. The options that affect the encryption/decryption process include:
* Algorithm used
* Key length (bits), content
* Block mode
* Initialization Vector (IV)/Salt length, content
* Padding options
If any one of these factors is different you can't decrypt the data. This particular tool wasn't really designed to decrypt data from external sources, but rather to demonstrate SQL 2000-specific encryption. You'll find the same issues on other platforms, like SQL 2005 or 2008 with built-in encryption. I would decrypt the data using PHP/mcrypt, and reencrypt on SQL Server rather than trying to directly decrypt the already PHP/mcrypt-encrypted data on SQL Server.
Thanks
Mike C
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Thursday, March 11, 2010 2:55 PM
Points: 5,
Visits: 40
|
|
Hi Ed,
The data encrypted in PHP/mcrypt could have been encrypted with any number of options, and was probably encrypted with a different key. The options that affect the encryption/decryption process include:
* Algorithm used
* Key length (bits), content
* Block mode
* Initialization Vector (IV)/Salt length, content
* Padding options
Mike C
Am I correct that there's no way some of these options (i.e. initialization vector) are not configurable in this tool?
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, March 17, 2010 4:35 PM
Points: 1,133,
Visits: 703
|
|
Ed Mays (10/6/2008)
Hi Ed,
The data encrypted in PHP/mcrypt could have been encrypted with any number of options, and was probably encrypted with a different key. The options that affect the encryption/decryption process include:
* Algorithm used
* Key length (bits), content
* Block mode
* Initialization Vector (IV)/Salt length, content
* Padding options
Mike C
Am I correct that there's no way some of these options (i.e. initialization vector) are not configurable in this tool?
With these sample XP's the only way to change most of these options is by modifying the C++ source code and recompiling. SQL 2005/2008 encryption won't be much help to you either since they choose random IVs and use preset block mode and padding options. Again, this sample code wasn't designed to decrypt data that was previously encrypted using other tools. You could probably force the issue by modifying the C++ source code to match the configuration you want, but it might be more trouble than it's worth.
Mike C
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Wednesday, February 24, 2010 11:26 PM
Points: 22,
Visits: 204
|
|
HI All,
I have same problem found in SQL Error Log in SQL 2005, last time is running daily successfully but only this few days I received error. Anyone can help me to find out what is the issue? Below is the error I found in error logs.
2009-10-26 13:43:06.34 spid59 Error: 18002, Severity: 20, State: 1.
2009-10-26 13:43:06.34 spid59 Exception happened when running extended stored procedure 'xp_makewebtask' in the library 'xpweb90.dll'. SQL Server is terminating process 59. Exception type: Win32 exception; Exception code: 0xc0000005.
2009-10-26 13:44:00.22 spid141 Using 'dbghelp.dll' version '4.0.5'
2009-10-26 13:44:00.23 spid141 ***Stack Dump being sent to V:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0340.txt
2009-10-26 13:44:00.23 spid141 SqlDumpExceptionHandler: Process 141 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2009-10-26 13:44:00.23 spid141 * *******************************************************************************
2009-10-26 13:44:00.23 spid141 *
2009-10-26 13:44:00.23 spid141 * BEGIN STACK DUMP:
2009-10-26 13:44:00.23 spid141 * 10/26/09 13:44:00 spid 141
2009-10-26 13:44:00.23 spid141 *
2009-10-26 13:44:00.23 spid141 *
2009-10-26 13:44:00.23 spid141 * Exception Address = 000007FF7FC51D71 Module(msvcrt+0000000000051D71)
2009-10-26 13:44:00.23 spid141 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2009-10-26 13:44:00.23 spid141 * Access Violation occurred reading address 0000000000000000
2009-10-26 13:44:00.23 spid141 * Input Buffer 86 bytes -
2009-10-26 13:44:00.23 spid141 * EXEC dbo.prc_sendMailKillQueries
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, March 17, 2010 4:35 PM
Points: 1,133,
Visits: 703
|
|
| Ayie, that's a completely different set of stored procedures. I haven't seen the xp_makewebtask proc in a long time to be honest. Check your server settings and make sure it's installed. It looks like this thing is trying to send an email, you might want to check into the databasemail functionality in SQL 2005 instead.
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Wednesday, February 24, 2010 11:26 PM
Points: 22,
Visits: 204
|
|
HI Mike,
Thanks for your reply,
Last time is working fine, we are using blatmail external application to send a mail. but only this few days is having an error. everytime they sending mail with attach htm file is creating a dump file. can anyone help me for this error.
Thanks
|
|
|
|
