[Emerald] HELP! EMERAUTH broke after applying recent MDAC security patch KB832483

• Next message: Nada: "[Emerald] Radius hanging"
• Previous message: Ali Resting: "[Emerald] Error after upgrade"

Subject: [Emerald] HELP! EMERAUTH broke after applying recent MDAC security patch KB832483
Date: Mon, 26 Jan 2004 18:28:48 +0100
Message-ID: <AC61CE9C574DAE4C9A5EBC4EBDA5590E237E51@sangde0.sang.de>
From: "[SANG] Peter A. Sang" <PS@sang.de>

We're using Emerald 2.5 + Emerauth.dll 2.7.24.0 + ServU FTP for some years now without problems.

Last saturday we applied MS-MDAC patch (KB832483) to the FTP server and restarted, after that ServU hang on starting. Troubleshooting found that ServU still works fine *without* the external authentication DLL, with the DLL included ServU hangs on initialisation and doesn't process requests at all (even for internal users). This is a serious problem since we're handling lots of customer FTP accounts with this system, based on their information in Emerald.

What I've tried so far: Installed most recent ServU 5 -> same problem Installed newest MDAC 2.8RTM (2.7SP1 was on the system before) ->same problem.

Checked DSN manually and with Eaadmin, looks fine. All other DB applications on this server (including RADIUS) work fine.

Please find the logs from two ServU starts below.

Any ideas or suggestions how to debug this problem? Is there a workaround or a newer version of the DLL?

Mit freundlichen Grüßen,

Peter A. Sang Geschäftsführer CCNP, CCNA SANG Computersysteme GmbH * Kruppstr. 82-100 * 45145 Essen * Germany T: +49-201-82020-0 * F:-40 * http://sang.de * mailto:ps@sang.de
* Microsoft Certified Partner
* HP/Compaq ASE Partner
* Veritas Vplus Select Partner

Emerauth.log:
[...] Jan 26 12:56:56 2004 EmerSupp::ReOpen
----------------------------------- Jan 26 12:56:56 2004 EmerSupp::ReOpen Entering function Jan 26 12:56:56 2004 EmerSupp::ReOpen Registry ODBCDataSource read Jan 26 12:56:56 2004 EmerSupp::ReOpen Registry UserName read Jan 26 12:56:56 2004 EmerSupp::ReOpen Registry Password read Jan 26 12:56:56 2004 EmerSupp::ReOpen Initalizing Database Connections Jan 26 13:57:53 2004 EmerSupp::ReOpen
----------------------------------- Jan 26 13:57:53 2004 EmerSupp::ReOpen Entering function Jan 26 13:57:53 2004 EmerSupp::ReOpen Registry ODBCDataSource read Jan 26 13:57:53 2004 EmerSupp::ReOpen Registry UserName read Jan 26 13:57:53 2004 EmerSupp::ReOpen Registry Password read Jan 26 13:57:53 2004 EmerSupp::ReOpen Initalizing Database Connections
[...]

ODBC-Logging:
****************************

ServUDaemon f54-f24 ENTER SQLAllocEnv
                HENV * 02459CD4

ServUDaemon f54-f24 EXIT SQLAllocEnv with return code 0
(SQL_SUCCESS)
                HENV * 0x02459CD4 ( 0x02461788)

ServUDaemon f54-f24 ENTER SQLAllocConnect
                HENV 02461788
                HDBC * 02459CD0

ServUDaemon f54-f24 EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
                HENV 02461788
                HDBC * 0x02459CD0 ( 0x02461830)

ServUDaemon f54-f24 ENTER SQLAllocEnv
                HENV * 025A20C0

ServUDaemon f54-f24 EXIT SQLAllocEnv with return code 0
(SQL_SUCCESS)
                HENV * 0x025A20C0 ( 0x02461938)

ServUDaemon f54-f24 ENTER SQLAllocConnect
                HENV 02461938
                HDBC * 025A20BC

ServUDaemon f54-f24 EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
                HENV 02461938
                HDBC * 0x025A20BC ( 0x024619e0)

ServUDaemon f54-f24 ENTER SQLAllocEnv
                HENV * 025A2188

ServUDaemon f54-f24 EXIT SQLAllocEnv with return code 0
(SQL_SUCCESS)
                HENV * 0x025A2188 ( 0x02461ae8)

ServUDaemon f54-f24 ENTER SQLAllocConnect
                HENV 02461AE8
                HDBC * 025A2184

ServUDaemon f54-f24 EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
                HENV 02461AE8
                HDBC * 0x025A2184 ( 0x02461b90)

ServUDaemon f54-f24 ENTER SQLDriverConnectW
                HDBC 02461830
                HWND 00000000
                WCHAR * 0x1F7A9D2C [ -3] "******\ 0"
                SWORD -3
                WCHAR * 0x1F7A9D2C
                SWORD 2
                SWORD * 0x00000000
                UWORD 0 <SQL_DRIVER_NOPROMPT>

ServUDaemon fd4-1040 ENTER SQLAllocEnv
                HENV * 01B60068

ServUDaemon fd4-1040 EXIT SQLAllocEnv with return code 0
(SQL_SUCCESS)
                HENV * 0x01B60068 ( 0x01a11788)

ServUDaemon fd4-1040 ENTER SQLAllocConnect
                HENV 01A11788
                HDBC * 01B60064

ServUDaemon fd4-1040 EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
                HENV 01A11788
                HDBC * 0x01B60064 ( 0x01a11830)

ServUDaemon fd4-1040 ENTER SQLAllocEnv
                HENV * 01B61F88

ServUDaemon fd4-1040 EXIT SQLAllocEnv with return code 0
(SQL_SUCCESS)
                HENV * 0x01B61F88 ( 0x01a11938)

ServUDaemon fd4-1040 ENTER SQLAllocConnect
                HENV 01A11938
                HDBC * 01B61F84

ServUDaemon fd4-1040 EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
                HENV 01A11938
                HDBC * 0x01B61F84 ( 0x01a119e0)

ServUDaemon fd4-1040 ENTER SQLDriverConnectW
                HDBC 01A11830
                HWND 00000000
                WCHAR * 0x1F7A9D2C [ -3] "******\ 0"
                SWORD -3
                WCHAR * 0x1F7A9D2C
                SWORD 2
                SWORD * 0x00000000
                UWORD 0 <SQL_DRIVER_NOPROMPT>

• Next message: Nada: "[Emerald] Radius hanging"
• Previous message: Ali Resting: "[Emerald] Error after upgrade"