FreeTDS Development Group

[eodonnell AT lineone.net]

Ok, clearly not being able to telnet to the MSSQL server on 1433 was a 
problem.
I just don't understand why I can't connect via telnet on 1433, but can via
server ent mgr on the same port - could our company firewalls possibly be
differentiating between telnet / client app on the same port??? Bizarre and
also a question for a different list !

I had the DBA's give me access to a test MYSQL server. I can telnet to this
one on 1433 and 'make check' was able to login and run its tests.

Unfortunately it fails further down the line. Looks like it's having problems
creating/dropping tables in the tempdb. The 'make check' output is shown
below in the hope someone may be able to spot what's wrong!

The MYSQL user account is not a sysadmin account, just a bog standard user.

Thanks for your time,

Edward


--------------------make check output---------------------
PASS: t0004
t0005.c: Testing login, logout
PASS: t0005
t0006.c: Testing conversion
Test succeded
PASS: t0006
t0007.c: Retrieve CS_CHAR_TYPE using ct_bind()
PASS: t0007
t0008.c: Testing context callbacks
Trying clientmsg_cb with context
Trying cslibmsg_cb

CS-Library Message:
number 33620240 layer 2 origin 1 severity 1 number 16
msgstring: cs_convert: cslib user api layer: external error: Conversion 
between
56 and 61 datatypes is not supported.
osstring: (null)
Trying login
Trying clientmsg_cb with connection
ct_results() result_type CS_CMD_FAIL.
Trying servermsg_cb with connection

Server Message:
number 0 severity 0 state 1 line 1
server: WS164
proc: (null)
text: This is a test
Trying logout
PASS: t0008
t0009.c: Retrieve compute results processing
ct_results() result_type CS_CMD_FAIL.
col1 = 1 col2= 'A', col3 = 'Jan  1 2002 10:00AM'
col1 = 2 col2= 'A', col3 = 'Jan  2 2002 10:00AM'
col1 = 3 col2= 'A', col3 = 'Jan  3 2002 10:00AM'
testing compute_result
compute_col1 = 6
col1 = 8 col2= 'B', col3 = 'Jan  4 2002 10:00AM'
col1 = 9 col2= 'B', col3 = 'Jan  5 2002 10:00AM'
testing compute_result
compute_col1 = 17
testing compute_result
compute_col3 = 'Jan  5 2002 10:00AM'
PASS: t0009
Test succeeded
PASS: connect_fail
ct_options.c: ct_options implemented only in TDS 5.0.
PASS: ct_options
lang_ct_param.c: submit language query with variables using ct_param

Server message:
Message number: 3701, Severity 11, State 5, Line 1
Server 'WS164'
Message String: Cannot drop the table '#ctparam_lang', because it does not
exist in the system catalog.
ct_results() result_type CS_CMD_FAIL.

Server message:
Message number: 137, Severity 15, State 2, Line 1
Server 'WS164'
Message String: Must declare the variable '@in1'.

Server message:
Message number: 137, Severity 15, State 2, Line 1
Server 'WS164'
Message String: Must declare the variable '@in1'.
PASS: lang_ct_param
array_bind.c: Retrieve data using array binding
ct_results() result_type CS_CMD_FAIL.
ct_fetch returned 2 rows
col1 = 1 col2= 'AAAA', col3 = 'Jan  1 2002 10:00AM'
col1 = 2 col2= 'BBBB', col3 = 'Jan  2 2002 10:00AM'
ct_fetch returned 2 rows
col1 = 3 col2= 'CCCC', col3 = 'Jan  3 2002 10:00AM'
col1 = 8 col2= 'DDDD', col3 = 'Jan  4 2002 10:00AM'
ct_fetch returned 1 rows
col1 = 9 col2= 'EEEE', col3 = 'Jan  5 2002 10:00AM'
PASS: array_bind
cs_diag.c: Testing context callbacks
Trying clientmsg_cb with context

CS-Library Message:
number 33816852 layer 2 origin 4 severity 1 number 20
msgstring: cs_convert: cslib user api layer: common library error: The 
conversion/operation
resulted in overflow.
osstring: (null)

CS-Library Message:
number 33620240 layer 2 origin 1 severity 1 number 16
msgstring: cs_convert: cslib user api layer: external error: Conversion 
between
56 and 61 datatypes is not supported.
osstring: (null)
PASS: cs_diag
get_send_data.c: Retrieve CS_TEXT_TYPE using ct_bind()
ct_results() result_type CS_CMD_FAIL.
get_send_data.c: Trying ct_data_info on text column
datatype = 35
usertype = 0
text len = 600
name     = #test_table.name
PASS: get_send_data
rpc_ct_param.c: submit a stored procedure using ct_param

Server message:
Message number: 3701, Severity 11, State 5, Line 1
Server 'WS164'
Message String: Cannot drop the procedure 'sample_rpc', because it does not
exist in the system catalog.
ct_results() result_type CS_CMD_FAIL.

Server message:
Message number: 262, Severity 14, State 1, Line 1
Server 'WS164'
 Procedure 'sample_rpc'
Message String: CREATE PROCEDURE permission denied in database 'tempdb'.
ct_results() result_type CS_CMD_FAIL.

Server message:
Message number: 2812, Severity 16, State 62, Line 1
Server 'WS164'
Message String: Could not find stored procedure 'sample_rpc'.

PARAMETER RESULTS

@sintparam  @floatparam          @moneyparam              @dateparam
                @charparam
    @binaryparam







----------- -------------------- ------------------------ 
------------------------------
------------------------------------------------------------ 
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------
234         0.12                 300.90

     
ff00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000
All done processing rows.
PASS: rpc_ct_param
rpc_ct_setparam.c: submit a stored procedure using ct_setparam

Server message:
Message number: 3701, Severity 11, State 5, Line 1
Server 'WS164'
Message String: Cannot drop the procedure 'sample_rpc', because it does not
exist in the system catalog.
ct_results() result_type CS_CMD_FAIL.

Server message:
Message number: 262, Severity 14, State 1, Line 1
Server 'WS164'
 Procedure 'sample_rpc'
Message String: CREATE PROCEDURE permission denied in database 'tempdb'.
ct_results() result_type CS_CMD_FAIL.

Server message:
Message number: 2812, Severity 16, State 62, Line 1
Server 'WS164'
Message String: Could not find stored procedure 'sample_rpc'.

PARAMETER RESULTS

@sintparam  @floatparam          @moneyparam              @dateparam
                @charparam
    @binaryparam







----------- -------------------- ------------------------ 
------------------------------
------------------------------------------------------------ 
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------


        
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000
All done processing rows.

Server message:
Message number: 2812, Severity 16, State 62, Line 1
Server 'WS164'
Message String: Could not find stored procedure 'sample_rpc'.

PARAMETER RESULTS

@sintparam  @floatparam          @moneyparam              @dateparam
                @charparam
    @binaryparam







----------- -------------------- ------------------------ 
------------------------------
------------------------------------------------------------ 
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------


        
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000
All done processing rows.
PASS: rpc_ct_setparam
ct_diagclient.c: Retrieve data using array binding
Maximum message limit is set to: 1
ct_results() result_type CS_CMD_FAIL.
Number of client messages returned: 1

Open Client Message:
number 16843145 layer 1 origin 1 severity 1 number 137
msgstring: ct_bind: user api layer: external error: A bind count of 4 is
not consistent with the count supplied for existing binds. The current bind
count is 2.
osstring: (null)
ct_fetch returned 2 rows
col1 = 1 col2= 'AAAA'
col1 = 2 col2= 'BBBB'
PASS: ct_diagclient
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
Maximum message limit is set to 4.
Number of messages returned: 4

Server Message:
number 3701 severity 11 state 5 line 1
server: WS164
proc: (null)
text: Cannot drop the table '#ctlibarray1', because it does not exist in
the system catalog.

Server Message:
number 3701 severity 11 state 5 line 1
server: WS164
proc: (null)
text: Cannot drop the table '#ctlibarray2', because it does not exist in
the system catalog.

Server Message:
number 3701 severity 11 state 5 line 1
server: WS164
proc: (null)
text: Cannot drop the table '#ctlibarray3', because it does not exist in
the system catalog.

Server Message:
number 3701 severity 11 state 5 line 1
server: WS164
proc: (null)
text: Cannot drop the table '#ctlibarray4', because it does not exist in
the system catalog.
PASS: ct_diagserver
ct_diagall.c: Retrieve data using array binding
Maximum message limit is set to: 5
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
ct_fetch returned 2 rows
col1 = 1 col2= 'AAAA'
col1 = 2 col2= 'BBBB'
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
Total number of client/server messages = 5
Number of client messages returned: 1

Open Client Message:
number 16843145 layer 1 origin 1 severity 1 number 137
msgstring: ct_bind: user api layer: external error: A bind count of 4 is
not consistent with the count supplied for existing binds. The current bind
count is 2.
osstring: (null)
Number of server messages returned: 4

Server Message:
number 3701 severity 11 state 5 line 1
server: WS164
proc: (null)
text: Cannot drop the table '#ctlibarray1', because it does not exist in
the system catalog.

Server Message:
number 3701 severity 11 state 5 line 1
server: WS164
proc: (null)
text: Cannot drop the table '#ctlibarray2', because it does not exist in
the system catalog.

Server Message:
number 3701 severity 11 state 5 line 1
server: WS164
proc: (null)
text: Cannot drop the table '#ctlibarray3', because it does not exist in
the system catalog.

Server Message:
number 3701 severity 11 state 5 line 1
server: WS164
proc: (null)
text: Cannot drop the table '#ctlibarray4', because it does not exist in
the system catalog.
PASS: ct_diagall
Trying cs_config with CS_USERDATA

Testing CS_SET/GET USERDATA with char array
Testing CS_SET/GET USERDATA with char array
Testing CS_SET/GET USERDATA with int
PASS: cs_config
PASS: cancel
blk_in.c: Retrieve data using array binding
ct_results() result_type CS_CMD_FAIL.
blk_init() failed
FAIL: blk_in
blk_out.c: Retrieve data using array binding
ct_results() result_type CS_CMD_FAIL.
retrieved 1 (4,0) AAAA (5,0) Jan  1 2002 10:00AM (20,0)
retrieved 2 (4,0) BBBB (5,0) Jan  2 2002 10:00AM (20,0)
retrieved 3 (4,0) CCCC (5,0) Jan  3 2002 10:00AM (20,0)
retrieved 8 (4,0) DDDD (5,0) Jan  4 2002 10:00AM (20,0)
retrieved 3 (0,-1) EEEE (5,0) Jan  5 2002 10:00AM (20,0)
PASS: blk_out
ct_cursor.c: Testing ct_cursor()
Trying login
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
Trying declare, rows , open in one SEND

col1
------

AAA

BBB

CCC

Trying declare, rows, open one at a time

col1
------

AAA

BBB

CCC

Running normal select command after cursor operations
Trying logout
Test suceeded
PASS: ct_cursor
ct_cursors.c: use multiple cursors on the same connection
Trying login
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
opening first cursor on connection
opening second cursor on connection
AAA                     XXX
BBB                     YYY
CCC                     ZZZ
closing first cursor on connection
closing second cursor on connection
Trying logout
Test succeded
PASS: ct_cursors
====================
1 of 26 tests failed
====================
*** Error code 1
make: Fatal error: Command failed for target `check-TESTS'
Current working directory /usr/local/src/freetds-0.63/src/ctlib/unittests
*** Error code 1
make: Fatal error: Command failed for target `check-am'
Current working directory /usr/local/src/freetds-0.63/src/ctlib/unittests
*** Error code 1
make: Fatal error: Command failed for target `check-recursive'
Current working directory /usr/local/src/freetds-0.63/src/ctlib
*** Error code 1
make: Fatal error: Command failed for target `check-recursive'
Current working directory /usr/local/src/freetds-0.63/src
*** Error code 1
make: Fatal error: Command failed for target `check-recursive'

--------------------end mack check output---------------------------------


>> Hi list,
>>
>> I'm attempting to install freetds 0.63 onto a Solaris sparc
>> box. I'm unable
>> to get past the 'make check' stage.
>>
>> ...10 of 13 tests failed...
>>
>> It gets as far as
>>  t0001.c: Testing login, logout
>> here it hangs for a minute or so, before quickly scrolling a
>> list of failures.
>> Presumably, the failed login is responsible for all failures
>> as the post-login
>> tests will fail.
>>
>> I have configured PWD with:
>> UID=username
>> PWD=password
>> SRV=mydatabase
>> DB=tempdb
>>
>> and freetds.conf with:
>> [mydatabase]
>>         host = mysql.domain.com
>>         port = 1433
>>         tds version = 7.0
>>
>
> Use 8.0 (just a suggestion it do not help for your problem).
>
>> The remote mssql server is SQL2000 patch8.00.760 SP3
>> I configured the freetds makefile with:
>> ./configure --with-tdsver=7.0 --with-prefix=/usr/local/freetds
>>
>>
>> I can't telnet from the solaris box to the mysql server on
>> port 1433. I also
>> can't telnet from my desktop machine, but form here I am able
>> to connect
>> via server enterprise mgr. Is this a problem?
>>
>> Your assistance is appreciated
>>
>> Thanks,
>>
>> Edward
>>
>
> Are you sure that 1433 is the right port? Telnet must work. Does ping
> work?
>
> freddy77

___________________________________________________________

Book yourself something to look forward to in 2005.
Cheap flights - http://www.tiscali.co.uk/travel/flights/
Bargain holidays - http://www.tiscali.co.uk/travel/holidays/