Skip to Content.
Sympa Menu

freetds - Re: [freetds] Build issue on AIX (invalid connection)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Sebastien FLAESCH <sf AT 4js.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] Build issue on AIX (invalid connection)
  • Date: Tue, 22 Sep 2015 17:17:00 +0200

And here is the TDSDUMP (0.95-rc3)...
Seb

On 09/22/2015 05:08 PM, Sebastien FLAESCH wrote:
Also tested with 0.95-rc3 by the way.
Seb

On 09/22/2015 05:07 PM, Sebastien FLAESCH wrote:
Trying to build 0.95.5 on AIX 6.1 in 64bit mode...

$ export OBJECT_MODE=64

$ CC="gcc -maix64" CXX="g++ -maix64" LDFLAGS="-maix64" ./configure
--prefix=$FTMDIR --with-odbc-nodm=/dbs/64bits/uxo/2.3.1

Note that we are using unixODBC 2.3.1, and we don't want to use unixODBC
as we link directly with libtdsodbc.a/.so ...

A simple connection fails and SQLGetDiagRec() returns a strange error message:

SQL State: 42000
SQL code : 18456
Message : [FreeTDS][SQL Server]L

SQL SERVER error 18456 is an invalid user/login issue, but when I switch to an
older version of FreeTDS (0.92), same data source + username + login connects
without problem...

Any ideas?

I suspect some unixODBC defines problem...

Any way to check that the unixODBC defines (32b/64b SQLLEN) match?

sizeof(SQLLEN) = 8

Seb
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


log.c:167:Starting log file for FreeTDS 0.95rc3
	on 2015-09-22 17:15:07 with debug flags 0x4fff.
iconv.c:328:tds_iconv_open(11002eff0, UTF-8)
iconv.c:187:local name for ISO-8859-1 is ISO-8859-1
iconv.c:187:local name for UTF-8 is UTF-8
iconv.c:187:local name for UCS-2LE is (null)
iconv.c:187:local name for UCS-2BE is UCS-2
iconv.c:346:setting up conversions for client charset "UTF-8"
iconv.c:348:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
iconv.c:455:Charset 2 not supported by iconv, using "ISO-8859-1" instead
iconv.c:395:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion
iconv.c:400:tds_iconv_open: done
net.c:202:Connecting to 10.0.50.50 port 1433 (TDS version 7.3)
net.c:274:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:313:tds_open_socket() succeeded
util.c:165:Changed query state from DEAD to IDLE
packet.c:740:Sending packet
0000 12 01 00 3a 00 00 00 00-00 00 1a 00 06 01 00 20 |...:.... ....... |
0010 00 01 02 00 21 00 0c 03-00 2d 00 04 04 00 31 00 |....!... .-....1.|
0020 01 ff 09 00 00 00 00 00-02 4d 53 53 51 4c 53 65 |........ .MSSQLSe|
0030 72 76 65 72 00 70 00 58-00 00                   |rver.p.X ..|

packet.c:639:Received packet
0000 04 01 00 2b 00 00 01 00-00 00 1a 00 06 01 00 20 |...+.... ....... |
0010 00 01 02 00 21 00 01 03-00 22 00 00 04 00 22 00 |....!... ."....".|
0020 01 ff 0c 00 08 dd 00 00-02 00 00                |........ ...|

login.c:1106:detected flag 2
login.c:852:quietly sending TDS 7+ login packet
token.c:326:tds_process_login_tokens()
packet.c:639:Received packet
0000 04 01 00 86 00 38 01 00-aa 6e 00 18 48 00 00 01 |.....8.. .n..H...|
0010 0e 1b 00 4c 00 6f 00 67-00 69 00 6e 00 20 00 66 |...L.o.g .i.n. .f|
0020 00 61 00 69 00 6c 00 65-00 64 00 20 00 66 00 6f |.a.i.l.e .d. .f.o|
0030 00 72 00 20 00 75 00 73-00 65 00 72 00 20 00 27 |.r. .u.s .e.r. .'|
0040 00 66 34 67 6c 27 00 2e-00 15 49 00 43 00 41 00 |.f4gl'.. ..I.C.A.|
0050 52 00 45 00 5c 00 4d 00-53 00 53 00 51 00 4c 00 |R.E.\.M. S.S.Q.L.|
0060 53 00 45 00 52 00 56 00-45 00 52 00 32 00 30 00 |S.E.R.V. E.R.2.0.|
0070 31 00 34 00 00 01 00 00-00 fd 02 00 00 00 00 00 |1.4..... ........|
0080 00 00 00 00 00 00      -                        |......|

token.c:335:looking for login token, got  aa(ERROR)
token.c:115:tds_process_default_tokens() marker is aa(ERROR)
token.c:2339:tds_process_msg() reading message 18456 from server
token.c:2411:tds_process_msg() calling client msg handler
odbc.c:2349:msgno 18456 20003
token.c:2424:tds_process_msg() returning TDS_SUCCESS
token.c:335:looking for login token, got  fd(DONE)
token.c:115:tds_process_default_tokens() marker is fd(DONE)
token.c:2075:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 1
		done_count_valid = 0
token.c:2092:                rows_affected = 0
token.c:2095:tds_process_end() state set to TDS_IDLE
token.c:439:tds_process_login_tokens() returning TDS_FAIL
login.c:472:login packet accepted
query.c:3769:tds_disconnect() 
util.c:165:Changed query state from IDLE to DEAD
util.c:322:tdserror(11000cc10, 11002eff0, 20002, 0)
odbc.c:2349:msgno 20002 20003
util.c:352:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:375:tdserror: returning TDS_INT_CANCEL(2)
mem.c:644:tds_free_all_results()
error.c:414:odbc_errs_add: "Unable to connect to data source"
error_export.h:6:SQLGetDiagRec(2, 11000cc90, 1, ffffffffffff3b6, ffffffffffff3bc, ffffffffffff3c0, 513, ffffffffffff5c2)
error.c:565:SQLGetDiagRec: "[FreeTDS][SQL Server]L"



Archive powered by MHonArc 2.6.24.

Top of Page