[freetds] Unable to connect to MySQL database

Bill Endter bill_e at mail.arc.nasa.gov
Thu Jul 22 16:17:20 EDT 2004


    We have a MySQL database server running on a MAC.  I cannot get a connection using FreeTDS tsql.  We are
using FreeTDS version 0.63.dev.20040507 (also tried 0.62.4) on a Solaris 8 server.  The error received is
"Unknown marker".  We can connect successfully using the mysql test program from mysql.com.  We have tried TDS
Version 7.0 and 8.0.  Can anyone explain what is happening and how to fix the problem?

            Thanks,

            Bill

>From freetds.conf:

# SQL Testing
[SQLTEST]
        host = xxxxxx.arc.nasa.gov
        port = 3306
        tds version = 7.0


Here is the log:

Starting log file for FreeTDS 0.63.dev.20040507
        on 2004-07-21 11:06:20 with debug level 99.
names for ISO-8859-1: ISO8859-1
names for UTF-8: UTF-8
names for UCS-2LE: UCS-2LE
names for UCS-2BE: UCS-2BE
iconv to convert client-side data to the "646" character set
11:06:20.311516 tds_iconv_info_init: converting "US-ASCII"->"UCS-2LE"
11:06:20.312603 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
11:06:20.312704 Connecting to 128.102.0.1 port 3306, TDS 7.0.
11:06:20.316094 tds_put_string converting 22 bytes of "xxxxxxxxx.arc.nasa.gov"
11:06:20.316201 tds_put_string wrote 44 bytes
11:06:20.316254 tds_put_string converting 5 bytes of "xxxxx"
11:06:20.316307 tds_put_string wrote 10 bytes
11:06:20.316368 tds_put_string converting 4 bytes of "TSQL"
11:06:20.316423 tds_put_string wrote 8 bytes
11:06:20.316472 tds_put_string converting 7 bytes of "SQLTEST"
11:06:20.316525 tds_put_string wrote 14 bytes
11:06:20.316575 tds_put_string converting 11 bytes of "TDS-Library"
11:06:20.316629 tds_put_string wrote 22 bytes
11:06:20.316715 tds_put_string converting 10 bytes of "us_english"
11:06:20.316771 tds_put_string wrote 20 bytes
11:06:20.316820 tds_put_string wrote 0 bytes
11:06:20.317063 tds_process_login_tokens()
Received header @ 11:06:20.317240
0000 2b 00 00 00 0a 34 2e 30-                        |+....4.0|


11:06:20.317341 looking for login token, got  0()
11:06:20.317394 tds_process_default_tokens() marker is 0()
11:06:20.318873 tds_client_msg: #20020: "Unknown marker".  Connection state is now 0.
Unknown marker: 0(0)!!
11:06:20.319352 tds_client_msg: #20014: "Login incorrect.".  Connection state is now 0.
11:06:20.319435 tds_free_all_results()





More information about the FreeTDS mailing list