Wine and MSSQL 2008: SSL Security Error

Romulo Carlos · Post by **Romulo Carlos** » Mon Aug 01, 2011 2:00 pm

Hi everyone.

I'm trying to use a windows third part software, and it uses a MSSQL database stored in a Windows 2008 Server. For this, I have Ubuntu 11, Wine 1.2 and WineTricks.

Following the instructions on "How to configure Wine", the chapter 3.6 tell me to install MDAC_TYP.EXE, and then run CLICONFG.EXE and ODBCAD32.EXE. I did this.

I run ODBCAD32 to configure my System DNS, but I was unable to connect, with ODBC returning an error about secur32 (don't remember). So, I go to Winetricks and install secur32.

Again on ODBCAD32 to configure SystemDSN, but now the error is "SSL Conection Error".

So, I go back to CLICONFIG.EXE, and tried some different settings, but I stuck on this message. I can't connect.

Running ODBCAD32 from terminal (wine odbcad32), the only message returned is "fixme:netbios:NetServerEnum Stub ((null) 100 0x32bad0 -1 0x32bac8 0x32bacc 4 (null) (nil))" when I select my server on the field "Wich SQL Server you want to connect to?"

Another message I'm suspecting is when I select my server: "fixme:ntdll:find_reg_tz_info Can't find matching timezone information in the registry for bias 180". Maybe this error is affecting my SQL setup, but I don't know well about this.

Any suggestion about this? Thanks in advice.

Romulo Carlos · Post by **Romulo Carlos** » Wed Aug 03, 2011 4:46 pm

I copied a fresh new windows installation to wine virtual drive, and still don't connecting...

Any suggestions?

DaVince · Post by **DaVince** » Wed Aug 03, 2011 6:15 pm

Romulo Carlos wrote:I copied a fresh new windows installation to wine virtual drive, and still don't connecting...

Any suggestions?

Don't ever copy a Windows installation to Wine. It'll break everything. Clean up your wineprefix before trying anything else.

Romulo Carlos · Post by **Romulo Carlos** » Thu Aug 04, 2011 8:26 am

DaVince wrote:
Romulo Carlos wrote:I copied a fresh new windows installation to wine virtual drive, and still don't connecting...

Any suggestions?
Don't ever copy a Windows installation to Wine. It'll break everything. Clean up your wineprefix before trying anything else.

Thanks for advice, was just for testing, I'm making tests on a Oracle Virtual Machine, BTW. If something goes wrong, I just use a clean copy of VHD.

I make 2 copies of the windows installation: one replacing all files, and another keeping wine's .exe and .dll files. On first nothing worked, and on second the error persists.

Tried also export my computer certificates and the server certificates, and then importing these certificates to Wine (on Internet Options icon), but again no success.

I tried "SQL Native Client 10.0", too. When I select it to make the System DSN, nothing happens. On my Windows it returns an error, but don't remember it.

I can't understand, everything else works fine, but with this connection error we can't migrate from windows to linux.

Suggestions?

vitamin · Post by **vitamin** » Fri Aug 05, 2011 9:53 am

Romulo Carlos wrote:Wine and MSSQL 2008: SSL Security Error

Few things to try:
1. Upgrade to newest Wine development version (wine-1.3.25)
2. Install FreeTDS, configure UnixODBC, verify it's working, and try Wine without any native dlls. See Wine's user manual for some hints about working with UnixODBC.
3. Try all native odbc* dlls (make sure to override then in winecfg to native).

PS. Migration from one platform to another platform means you have to use software available on the new platform. For you that means scrapping mssql, and whatever talks to it. And replacing them with native Linux equivalents. Such as MySQL, PostrgreSQL, etc and any programming language of your choice.

Romulo Carlos · Post by **Romulo Carlos** » Fri Aug 05, 2011 2:52 pm

Thanks for your suggestions.

I removed the prefix used, uninstall Wine, and install the new version, the erorr is the same.

Then, try to install FreeTDS and unixODBC, but I don't know why, FreeTDS returns a lot of errors during install. The "tsql" command don't work, a counter appears on the terminal counting until I stop with CTRL+C.

unixODBC was already installed with LibreOffice 3.2 (office suite), but I don't know how to configure LibreOffice yet.

Our system is, for now, windows based. We are porting it to a web interface, but it will take some time. So, until this port is not finished, we want to test Linux and see if it meets our needs. For all others applications (internet, office, email, etc) there are no problem, only this third part application is the problem.

Again, thanks for your effort and help.

jjmckenzie · Post by **jjmckenzie** » Sat Aug 06, 2011 8:58 pm

On 8/5/11 12:52 PM, Romulo Carlos wrote:

Thanks for your suggestions.

I removed the prefix used, uninstall Wine, and install the new version, the erorr is the same.

Then, try to install FreeTDS and unixODBC, but I don't know why, FreeTDS returns a lot of errors during install. The "tsql" command don't work, a counter appears on the terminal counting until I stop with CTRL+C.

unixODBC was already installed with LibreOffice 3.2 (office suite), but I don't know how to configure LibreOffice yet.

The difficulty is not configuring LibreOffice, but rather configuring
unixODBC and insuring that it is available to FreeTDS. This may require
contacting the FreeTDS folks and asking them how to configure it for
your particular application and purpose.

People using Wine have experienced difficulties configuring it to
connect with MS SQL regardless of the 'flavor'. You might also want to
search the forum for other topics regarding connecting Windows programs
in Wine thorugh unixODBC or even the Windows ODBC.

James

vitamin · Post by **vitamin** » Mon Aug 08, 2011 8:36 pm

Romulo Carlos wrote:Then, try to install FreeTDS and unixODBC, but I don't know why, FreeTDS returns a lot of errors during install. The "tsql" command don't work, a counter appears on the terminal counting until I stop with CTRL+C.

Make sure you using the latest FreeTDS. And that you properly added your server instance to /etc/freetds.conf.

Until you get tsql program working don't bother with anything else.

PS. Make sure your MSSQL server configured with TCP/IP access not just named pipes. NPs won't work on anything but windows.

Romulo Carlos · Post by **Romulo Carlos** » Mon May 21, 2012 3:31 pm

Wow... A lot of time since last visit, don't?? Sorry.

Well, I was unable to proceed with this, but now I like to go ahead... So, the point is:

I have Ubuntu 12.04, Wine 1.4.1.4 and FreeTDS 0.91. I have edited the freetds.conf, and I can get a 1> prompt when I use the command TDSVER=8.0 tsql -S 2k8 -U username

The '2k8' is my server definition in freetds.conf.

So, I'm connected with my server, right? And now, how I can configure ODBCAD32 to connect with the server?

Thanks a lot for your replies.