在Linux上使用MySQL的Mobilink

Question

我试图将MobiLink配置为在本地主机上使用我的MySQL数据库。

我使用的是：-mysql-连接器-odbc-5.1.10- SQL 12.0.1 Developer Edition

我遵循本教程http://www.sybase.com/detail?id=1056497，但工作在Linux 11 x64上。

我已经安装了Mobilink，为我的MySQL数据库配置了ODBC连接器，现在我尝试使用以下命令启动MobiLink同步服务器：

/bin64s/mlsrv12 -v+ -o mlsrv.out -zs ml_mysql -c "DSN=sa11_ML-connector;uid=root;pwd=my_pass" -dl -zu+ -x tcpip{port=2639}

我收到这个错误：

(...)
I. 2012-03-28 01:25:50. <Main> Timeout for inactive database connections: 60 minutes
I. 2012-03-28 01:25:50. <Main> Maximum delay between retries after deadlock: 30 seconds
I. 2012-03-28 01:25:50. <Main> Rowset size: 10
I. 2012-03-28 01:25:50. <Main> Number of database worker threads: 5
W. 2012-03-28 01:25:50. <Main> [10064] Unknown users will be added automatically (when there is no authenticate_user script)
Unable to load 'MySQL ODBC 5.1 Driver' errno=2
I. 2012-03-28 01:25:50. <Main> Shared administrative connection connected
I. 2012-03-28 01:25:50. <Main> System event on shared administrative connection:
                    SELECT count(*) FROM ml_scripts_modified
I. 2012-03-28 01:25:50. <Main> Translated SQL:
                    SELECT count(*) FROM ml_scripts_modified
E. 2012-03-28 01:25:50. <Main> [-10379] The ODBC connection string specifies a driver that is not compatible with 64-bit MobiLink
I. 2012-03-28 01:25:50. <Main> Shared administrative connection disconnected
E. 2012-03-28 01:25:50. <Main> [-10382] The MobiLink Server has failed to start

我已经从这里下载了最新的ODBC连接器：http://dev.mysql.com/downloads/connector/odbc/5.1.html，并尝试了

• 通用Linux (x86，32位)，RPM包
• Linux ..3.glibc2 (x86，64位)，压缩焦油档案

它们都返回该错误，并且应该与MobiLink x64完全兼容(我认为如此.)。

有什么想法吗？

干杯。

我已经将odbc配置文件复制到另一个位置(在strace中可以找到MobiLink扫描的配置文件)，但是现在我又收到了另一个错误.

I. 2012-03-28 15:45:21. SQL Anywhere MobiLink Server Version 12.0.1.3457
I. 2012-03-28 15:45:21. 
I. 2012-03-28 15:45:21. Copyright (c) 2001-2011, iAnywhere Solutions, Inc.
I. 2012-03-28 15:45:21. Portions copyright (c) 1988-2011, Sybase, Inc. All rights reserved.
I. 2012-03-28 15:45:21. Use of this software is governed by the Sybase License Agreement.
I. 2012-03-28 15:45:21. Refer to http://www.sybase.com/softwarelicenses.
I. 2012-03-28 15:45:21. 
I. 2012-03-28 15:45:21. This server is licensed to:
I. 2012-03-28 15:45:21.     Developer Edition
I. 2012-03-28 15:45:21.     Restricted Use
I. 2012-03-28 15:45:21. Running Linux 2.6.38-13-generic #57-Ubuntu SMP Mon Mar 5 18:29:54 UTC 2012 on X86_64
I. 2012-03-28 15:45:21. Server built for X86_64 processor architecture
I. 2012-03-28 15:45:21. <Main> Option 1: -v+
I. 2012-03-28 15:45:21. <Main> Option 2: -o
I. 2012-03-28 15:45:21. <Main> Option 3: mlsrv.out
I. 2012-03-28 15:45:21. <Main> Option 4: -zs
I. 2012-03-28 15:45:21. <Main> Option 5: ml_mysql
I. 2012-03-28 15:45:21. <Main> Option 6: -c
I. 2012-03-28 15:45:21. <Main> Option 7: DSN=sa11_ML-connector;uid=root;pwd=********
I. 2012-03-28 15:45:21. <Main> Option 8: -dl
I. 2012-03-28 15:45:21. <Main> Option 9: -zu+
I. 2012-03-28 15:45:21. <Main> Option 10: -x
I. 2012-03-28 15:45:21. <Main> Option 11: tcpip{port=2639}
I. 2012-03-28 15:45:21. <Main> Verbose logging: show upload row values
I. 2012-03-28 15:45:21. <Main> Verbose logging: show download row values
I. 2012-03-28 15:45:21. <Main> Verbose logging: show script names when invoked
I. 2012-03-28 15:45:21. <Main> Verbose logging: show script contents when invoked
I. 2012-03-28 15:45:21. <Main> Verbose logging: show schema for each table
I. 2012-03-28 15:45:21. <Main> Verbose logging: show an error when the first read of a synchronization fails
I. 2012-03-28 15:45:21. <Main> Verbose logging: show translated SQL for prepared statements
I. 2012-03-28 15:45:21. <Main> Verbose logging: show rowcount values
I. 2012-03-28 15:45:21. <Main> Cache size: 52428800 bytes
I. 2012-03-28 15:45:21. <Main> Download cache directory size: 10485760 bytes
I. 2012-03-28 15:45:21. <Main> Local file for remote synchronization logs: 'mlsrv.mle'
I. 2012-03-28 15:45:21. <Main> Starting cache sizes: min of 52428800 bytes; max of 2906351616 bytes; initial size of 52064256 bytes
I. 2012-03-28 15:45:21. <Main> Individual database connections will be closed after synchronization errors
I. 2012-03-28 15:45:21. <Main> Maximum number of BLOB bytes to compare: 4294967295
I. 2012-03-28 15:45:21. <Main> Maximum number of database connections: 5
I. 2012-03-28 15:45:21. <Main> Maximum number of deadlock retries: 10
I. 2012-03-28 15:45:21. <Main> Timeout for inactive database connections: 60 minutes
I. 2012-03-28 15:45:21. <Main> Maximum delay between retries after deadlock: 30 seconds
I. 2012-03-28 15:45:21. <Main> Rowset size: 10
I. 2012-03-28 15:45:21. <Main> Number of database worker threads: 5
W. 2012-03-28 15:45:21. <Main> [10064] Unknown users will be added automatically (when there is no authenticate_user script)
Unable to load '/usr/lib64/libmyodbc5.so' errno=0
I. 2012-03-28 15:45:21. <Main> Shared administrative connection connected
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        SELECT count(*) FROM ml_scripts_modified
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        SELECT count(*) FROM ml_scripts_modified
I. 2012-03-28 15:45:21. <Main> ODBC DBMS Name: MySQL
I. 2012-03-28 15:45:21. <Main> ODBC DBMS Version: 5.1.61-0ubuntu0.11.04.1
I. 2012-03-28 15:45:21. <Main> ODBC DBMS Driver Version: 05.01.0010
I. 2012-03-28 15:45:21. <Main> ODBC Version supported by the driver: 3.51
I. 2012-03-28 15:45:21. <Main> Collation sequence of the consolidated database is 'utf8_general_ci'
I. 2012-03-28 15:45:21. <Main> ODBC DBMS Type: MySQL
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        set innodb_table_locks = 0
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        set innodb_table_locks = 0
I. 2012-03-28 15:45:21. <Main> ODBC isolation set to: Read Committed
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        SELECT user_id, name, hashed_password FROM ml_user WHERE 1=2
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        SELECT user_id, name, hashed_password FROM ml_user WHERE 1=2
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        SELECT rid, remote_id, script_ldt, description FROM ml_database WHERE 1=2
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        SELECT rid, remote_id, script_ldt, description FROM ml_database WHERE 1=2
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        SELECT rid, subscription_id, user_id, progress, publication_name, last_upload_time, last_download_time FROM ml_subscription WHERE 1=2
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        SELECT rid, subscription_id, user_id, progress, publication_name, last_upload_time, last_download_time FROM ml_subscription WHERE 1=2
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        SELECT table_id, name FROM ml_table WHERE 1=2
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        SELECT table_id, name FROM ml_table WHERE 1=2
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        SELECT component_name, property_set_name, property_name, property_value FROM ml_property WHERE 1=2
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        SELECT component_name, property_set_name, property_name, property_value FROM ml_property WHERE 1=2
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        SELECT script_id, script, script_language FROM ml_script WHERE 1=2
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        SELECT script_id, script, script_language FROM ml_script WHERE 1=2
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        SELECT version_id, name, description FROM ml_script_version WHERE 1=2
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        SELECT version_id, name, description FROM ml_script_version WHERE 1=2
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        SELECT version_id, event, script_id FROM ml_connection_script WHERE 1=2
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        SELECT version_id, event, script_id FROM ml_connection_script WHERE 1=2
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        SELECT version_id, table_id, event, script_id FROM ml_table_script WHERE 1=2
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        SELECT version_id, table_id, event, script_id FROM ml_table_script WHERE 1=2
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        SELECT last_modified FROM ml_scripts_modified WHERE 1=2
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        SELECT last_modified FROM ml_scripts_modified WHERE 1=2
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        SELECT version_id, table_id, idx, name, type FROM ml_column WHERE 1=2
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        SELECT version_id, table_id, idx, name, type FROM ml_column WHERE 1=2
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        SELECT server_id, name, connection_info, instance_key, start_time FROM ml_primary_server WHERE 1=2
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        SELECT server_id, name, connection_info, instance_key, start_time FROM ml_primary_server WHERE 1=2
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        SELECT script_id, script_name, flags, affected_pubs, script, description FROM ml_passthrough_script WHERE 1=2
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        SELECT script_id, script_name, flags, affected_pubs, script, description FROM ml_passthrough_script WHERE 1=2
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        SELECT remote_id, run_order, script_id, last_modified FROM ml_passthrough WHERE 1=2
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        SELECT remote_id, run_order, script_id, last_modified FROM ml_passthrough WHERE 1=2
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        SELECT status_id, remote_id, run_order, script_id, script_status, error_code, error_text, remote_run_time FROM ml_passthrough_status WHERE 1=2
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        SELECT status_id, remote_id, run_order, script_id, script_status, error_code, error_text, remote_run_time FROM ml_passthrough_status WHERE 1=2
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        SELECT failed_script_id, error_code, new_script_id, action FROM ml_passthrough_repair WHERE 1=2
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        SELECT failed_script_id, error_code, new_script_id, action FROM ml_passthrough_repair WHERE 1=2
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        SELECT count(*) FROM ml_scripts_modified
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        SELECT count(*) FROM ml_scripts_modified
I. 2012-03-28 15:45:21. <Main> This software is using security technology from Certicom Corp.
I. 2012-03-28 15:45:21. <Main> System event on shared administrative connection:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        SELECT property_set_name, property_name, property_value FROM ml_property WHERE component_name = ? ORDER BY property_set_name 
I. 2012-03-28 15:45:21. <Main> Notifier stage connection connected
I. 2012-03-28 15:45:21. <Main> System event on the notifier stage connection:
                        set innodb_table_locks = 0
I. 2012-03-28 15:45:21. <Main> Translated SQL:
                        set innodb_table_locks = 0
I. 2012-03-28 15:45:21. <Main> MobiLink server started
Press 'q' to quit MobiLink server
Interrupted

它现在似乎正在使用我的数据库，但仍然存在：

W. 2012-03-28 15:45:21. <Main> [10064] Unknown users will be added automatically (when there is no authenticate_user script)
    Unable to load '/usr/lib64/libmyodbc5.so' errno=0

在/usr/lib64 64/libmyodbc5下，也是我的ODBC驱动程序。

Answer 1

确保您使用的是推荐的MySQL ODBC驱动程序，并遵循MobiLink使用该驱动程序的说明。

获得和MobiLink帮助的其他方法。