Re: Build issue on AIX (invalid connection)

Sebastien FLAESCH <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Organization Four Js Development Tools
Message-ID <[email protected]>
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
>> [email protected]
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>

_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds
tdsdump.log (text/x-log, 3.4 KB)
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"
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.