当前位置： 文江博客话题详情

“参数：字符串包含null字节”从Ruby连接到雪花的ODBC时

发布于 2025-02-11 20:20:02 字数 8747 浏览 1 评论 0原文

我在Mac M1（版本11.6（20G165））上工作，其中安装了下一个软件：

文件：

[Driver]
DriverManagerEncoding=UTF-16
DriverLocale=en-US
ErrorMessagesPath=/opt/snowflake/snowflakeodbc/ErrorMessages
LogLevel=0
LogPath=/tmp
CURLVerboseMode=true
ODBCInstLib=/usr/local/Cellar/unixodbc/2.3.11/lib/libodbcinst.dylib
CABundleFile=/opt/snowflake/snowflakeodbc/lib/universal/cacert.pem
ODBCInstLib=libodbcinst.dylib

ruby​​ for

[ODBC]
Trace=yes
TraceFile=odbc.log

[ODBC Drivers]
Snowflake                       = Installed

[Snowflake]
Driver=/opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib

/opt/snowflake/snowflakeodbc/lib/universal/simba.snowflake.ini odbc.ini

[ODBC Data Sources]
Snowflake=Snowflake
Snowflake1=Snowflake

[Snowflake]
Description=SnowflakeUserDB
Driver=Snowflake
Locale=en-US
SERVER=xxxxx.snowflakecomputing.com
WAREHOUSE=DEV_COMPUTE
PORT=443
SSL=on
Database=W_DEV_DB
UID = XXX_DEV
ACCOUNT=xxxxx
TRACING=6
Schema = PUBLIC

ruby​​ -v的结果： ruby 2.4.10p364 (2020-03-31 revision 67879) [x86_64-darwin20]

The next files has architecture x86_64 (tested with lipo -info):

  • /opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib
  • /usr/local /cellar/unixodbc/2.3.11/bin/isql/iusr/local/cellar/cellar/unixodbc/2.3.11/lib/lib/lib/libodbcinst.dylib/usr/local/local/cellar/cellar/cellar/unixodbc/2.3.11/bin/bin/odbcinst
  • 一下
  • ​

​代码>/usr/local/cellar/unixodbc/2.3.11/bin/odbcinst -q -q -s

[Snowflake]

-j'

unixODBC 2.3.11
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
USER DATA SOURCES..: /Users/krocodl/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

` /usr/local/cellar/cellar/cellar/unixodbc/2.11/bin/bin/odbcinst /usr/local/cellar/unixodbc/2.3.11/bin/isql -isql -V snowflake用户名密码的结果，

+---------------------------------------+
| Connected!

但不幸的是，最小测试程序从 https://community.snowflake.com/s/s/s/文章/连接到snowflake-using-the-obdc-driver-ruby-on-on-rails-5 ，不适用于下一个错误：

An error occurred
Error code: #<Sequel::DatabaseConnectionError: ArgumentError: string contains null byte>

基于dbi.connect的类似示例（“ dbi：” dbi： ODBC：Snowflake”，“用户名”，“密码”）没有同样的错误工作。

在〜/sql.log文件中，有下一个错误：

[000000.000202]
ruby            20058EE00 ENTER SQLConnect
        SQLHDBC           0x7f7fc05c95d0
        SQLCHAR         * 0x7f7fc117dcb0
                  | Snowflake                                |
        SQLSMALLINT       -3 (SQL_NTS)
        SQLCHAR         * 0x7f7fc117dc88
                  | username                             |
        SQLSMALLINT       -3 (SQL_NTS)
        SQLCHAR         * 0x7fff78089d44
                  | ****                                     |
        SQLSMALLINT       -3 (SQL_NTS)

[000000.122933]
ruby            20058EE00 EXIT  SQLConnect with return code -1 (SQL_ERROR)
        SQLHDBC           0x7f7fc05c95d0
        SQLCHAR         * 0x7f7fc117dcb0
        SQLSMALLINT       -3 (SQL_NTS)
        SQLCHAR         * 0x7f7fc117dc88
        SQLSMALLINT       -3 (SQL_NTS)
        SQLCHAR         * 0x7fff78089d44
        SQLSMALLINT       -3 (SQL_NTS)

[000000.123422]
ruby            20058EE00 ENTER SQLError
        SQLHENV           0x0 (SQL_NULL_HANDLE)
        SQLHDBC           0x7f7fc05c95d0
        SQLHSTMT          0x0 (SQL_NULL_HANDLE)
        SQLCHAR         * 0x304a56d85
        SQLINTEGER      * 0x304a56d7c
        SQLCHAR         * 0x304a56fd0
        SQLINTEGER        511
        SQLSMALLINT     * 0x304a56d7a

[000000.124001]
ruby            20058EE00 EXIT  SQLError with return code 0 (SQL_SUCCESS)
        SQLHENV           0x0 (SQL_NULL_HANDLE)
        SQLHDBC           0x7f7fc05c95d0
        SQLHSTMT          0x0 (SQL_NULL_HANDLE)
        SQLCHAR         * 0x304a56d85
                  | (empty string)                           |
        SQLINTEGER      * 0x304a56d7c (10380)
        SQLCHAR         * 0x304a56fd0
                  | o
        SQLINTEGER        511
        SQLSMALLINT     * 0x304a56d7a (103)

[000000.124058]
ruby            20058EE00 ENTER SQLError
        SQLHENV           0x0 (SQL_NULL_HANDLE)
        SQLHDBC           0x7f7fc05c95d0
        SQLHSTMT          0x0 (SQL_NULL_HANDLE)
        SQLCHAR         * 0x304a56d85
        SQLINTEGER      * 0x304a56d7c
        SQLCHAR         * 0x304a56fd0
        SQLINTEGER        511
        SQLSMALLINT     * 0x304a56d7a

[000000.124251]
ruby            20058EE00 EXIT  SQLError with return code 100 (SQL_NO_DATA_FOUND)
        SQLHENV           0x0 (SQL_NULL_HANDLE)
        SQLHDBC           0x7f7fc05c95d0
        SQLHSTMT          0x0 (SQL_NULL_HANDLE)
        SQLCHAR         * 0x304a56d85
        SQLINTEGER      * 0x304a56d7c
        SQLCHAR         * 0x304a56fd0
        SQLINTEGER        511
        SQLSMALLINT     * 0x304a56d7a

[000000.126147]
ruby            20058EE00 ENTER SQLFreeEnv
        SQLHENV           0x7f7fc07bd000

[000000.126166]
ruby            20058EE00 EXIT  SQLFreeEnv with return code -1 (SQL_ERROR)
        SQLHENV           0x7f7fc07bd000

异常回溯：

[0] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/adapters/odbc.rb:29:in `initialize'"
[1] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/adapters/odbc.rb:29:in `connect'"
[2] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/adapters/odbc.rb:29:in `connect'"
[3] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/connection_pool.rb:122:in `make_new'"
[4] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/connection_pool/threaded.rb:209:in `assign_connection'"
[5] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/connection_pool/threaded.rb:139:in `acquire'"
[6] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/connection_pool/threaded.rb:91:in `hold'"
[7] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/database/connecting.rb:252:in `synchronize'"
[8] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/database/connecting.rb:278:in `test_connection'"
[9] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/database/misc.rb:175:in `initialize'"
[10] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/database/connecting.rb:57:in `new'"
[11] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/database/connecting.rb:57:in `connect'"
[12] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/core.rb:124:in `connect'"
[13] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/core.rb:412:in `adapter_method'"
[14] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/core.rb:419:in `block (2 levels) in def_adapter_method'"
[15] = "/Users/krocodl/Projects/samples/test.rb:42:in `<top (required)>'"
[16] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/ruby-debug-ide-2.3.3/lib/ruby-debug-ide.rb:95:in `debug_load'"
[17] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/ruby-debug-ide-2.3.3/lib/ruby-debug-ide.rb:95:in `debug_program'"
[18] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/ruby-debug-ide-2.3.3/bin/rdebug-ide:190:in `<main>'"

其他人是否对如何使测试示例工作有任何想法？

PS报道为 https：//github.com/jeremyevans/jeremyevans/sequel/seceel/seceel/seceel/sissues/1888

原文

I work on Mac M1 (Version 11.6 (20G165)), where installed the next software:

The content of /opt/snowflake/snowflakeodbc/lib/universal/simba.snowflake.ini file:

[Driver]
DriverManagerEncoding=UTF-16
DriverLocale=en-US
ErrorMessagesPath=/opt/snowflake/snowflakeodbc/ErrorMessages
LogLevel=0
LogPath=/tmp
CURLVerboseMode=true
ODBCInstLib=/usr/local/Cellar/unixodbc/2.3.11/lib/libodbcinst.dylib
CABundleFile=/opt/snowflake/snowflakeodbc/lib/universal/cacert.pem
ODBCInstLib=libodbcinst.dylib

The content of ~/./.odbcinst.ini

[ODBC]
Trace=yes
TraceFile=odbc.log

[ODBC Drivers]
Snowflake                       = Installed

[Snowflake]
Driver=/opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib

The content of ~/.odbc.ini

[ODBC Data Sources]
Snowflake=Snowflake
Snowflake1=Snowflake

[Snowflake]
Description=SnowflakeUserDB
Driver=Snowflake
Locale=en-US
SERVER=xxxxx.snowflakecomputing.com
WAREHOUSE=DEV_COMPUTE
PORT=443
SSL=on
Database=W_DEV_DB
UID = XXX_DEV
ACCOUNT=xxxxx
TRACING=6
Schema = PUBLIC

The result of ruby -v:
ruby 2.4.10p364 (2020-03-31 revision 67879) [x86_64-darwin20]

The next files has architecture x86_64 (tested with lipo -info):

  • /opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib
  • /usr/local/Cellar/unixodbc/2.3.11/bin/isql
  • /usr/local/Cellar/unixodbc/2.3.11/lib/libodbcinst.dylib
  • /usr/local/Cellar/unixodbc/2.3.11/bin/odbcinst

The result of /usr/local/Cellar/unixodbc/2.3.11/bin/odbcinst -q -s

[Snowflake]

The result of `/usr/local/Cellar/unixodbc/2.3.11/bin/odbcinst -j'

unixODBC 2.3.11
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
USER DATA SOURCES..: /Users/krocodl/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

The result of /usr/local/Cellar/unixodbc/2.3.11/bin/isql -v Snowflake username password

+---------------------------------------+
| Connected!

But unfortunately the minimal test program, got from https://community.snowflake.com/s/article/connecting-to-snowflake-using-the-obdc-driver--ruby-on-rails-5, does not work with the next error:

An error occurred
Error code: #<Sequel::DatabaseConnectionError: ArgumentError: string contains null byte>

The similar sample, based on DBI.connect("DBI:ODBC:Snowflake","username","password") does not work with the same error.

In the ~/sql.log file there are the next errors:

[000000.000202]
ruby            20058EE00 ENTER SQLConnect
        SQLHDBC           0x7f7fc05c95d0
        SQLCHAR         * 0x7f7fc117dcb0
                  | Snowflake                                |
        SQLSMALLINT       -3 (SQL_NTS)
        SQLCHAR         * 0x7f7fc117dc88
                  | username                             |
        SQLSMALLINT       -3 (SQL_NTS)
        SQLCHAR         * 0x7fff78089d44
                  | ****                                     |
        SQLSMALLINT       -3 (SQL_NTS)

[000000.122933]
ruby            20058EE00 EXIT  SQLConnect with return code -1 (SQL_ERROR)
        SQLHDBC           0x7f7fc05c95d0
        SQLCHAR         * 0x7f7fc117dcb0
        SQLSMALLINT       -3 (SQL_NTS)
        SQLCHAR         * 0x7f7fc117dc88
        SQLSMALLINT       -3 (SQL_NTS)
        SQLCHAR         * 0x7fff78089d44
        SQLSMALLINT       -3 (SQL_NTS)

[000000.123422]
ruby            20058EE00 ENTER SQLError
        SQLHENV           0x0 (SQL_NULL_HANDLE)
        SQLHDBC           0x7f7fc05c95d0
        SQLHSTMT          0x0 (SQL_NULL_HANDLE)
        SQLCHAR         * 0x304a56d85
        SQLINTEGER      * 0x304a56d7c
        SQLCHAR         * 0x304a56fd0
        SQLINTEGER        511
        SQLSMALLINT     * 0x304a56d7a

[000000.124001]
ruby            20058EE00 EXIT  SQLError with return code 0 (SQL_SUCCESS)
        SQLHENV           0x0 (SQL_NULL_HANDLE)
        SQLHDBC           0x7f7fc05c95d0
        SQLHSTMT          0x0 (SQL_NULL_HANDLE)
        SQLCHAR         * 0x304a56d85
                  | (empty string)                           |
        SQLINTEGER      * 0x304a56d7c (10380)
        SQLCHAR         * 0x304a56fd0
                  | o
        SQLINTEGER        511
        SQLSMALLINT     * 0x304a56d7a (103)

[000000.124058]
ruby            20058EE00 ENTER SQLError
        SQLHENV           0x0 (SQL_NULL_HANDLE)
        SQLHDBC           0x7f7fc05c95d0
        SQLHSTMT          0x0 (SQL_NULL_HANDLE)
        SQLCHAR         * 0x304a56d85
        SQLINTEGER      * 0x304a56d7c
        SQLCHAR         * 0x304a56fd0
        SQLINTEGER        511
        SQLSMALLINT     * 0x304a56d7a

[000000.124251]
ruby            20058EE00 EXIT  SQLError with return code 100 (SQL_NO_DATA_FOUND)
        SQLHENV           0x0 (SQL_NULL_HANDLE)
        SQLHDBC           0x7f7fc05c95d0
        SQLHSTMT          0x0 (SQL_NULL_HANDLE)
        SQLCHAR         * 0x304a56d85
        SQLINTEGER      * 0x304a56d7c
        SQLCHAR         * 0x304a56fd0
        SQLINTEGER        511
        SQLSMALLINT     * 0x304a56d7a

[000000.126147]
ruby            20058EE00 ENTER SQLFreeEnv
        SQLHENV           0x7f7fc07bd000

[000000.126166]
ruby            20058EE00 EXIT  SQLFreeEnv with return code -1 (SQL_ERROR)
        SQLHENV           0x7f7fc07bd000

The exception backtrace:

[0] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/adapters/odbc.rb:29:in `initialize'"
[1] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/adapters/odbc.rb:29:in `connect'"
[2] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/adapters/odbc.rb:29:in `connect'"
[3] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/connection_pool.rb:122:in `make_new'"
[4] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/connection_pool/threaded.rb:209:in `assign_connection'"
[5] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/connection_pool/threaded.rb:139:in `acquire'"
[6] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/connection_pool/threaded.rb:91:in `hold'"
[7] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/database/connecting.rb:252:in `synchronize'"
[8] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/database/connecting.rb:278:in `test_connection'"
[9] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/database/misc.rb:175:in `initialize'"
[10] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/database/connecting.rb:57:in `new'"
[11] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/database/connecting.rb:57:in `connect'"
[12] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/core.rb:124:in `connect'"
[13] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/core.rb:412:in `adapter_method'"
[14] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/sequel-5.57.0/lib/sequel/core.rb:419:in `block (2 levels) in def_adapter_method'"
[15] = "/Users/krocodl/Projects/samples/test.rb:42:in `<top (required)>'"
[16] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/ruby-debug-ide-2.3.3/lib/ruby-debug-ide.rb:95:in `debug_load'"
[17] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/ruby-debug-ide-2.3.3/lib/ruby-debug-ide.rb:95:in `debug_program'"
[18] = "/Users/krocodl/.asdf/installs/ruby/2.4.10/lib/ruby/gems/2.4.0/gems/ruby-debug-ide-2.3.3/bin/rdebug-ide:190:in `<main>'"

Does anyone else have any ideas on how to make the test example work????

P.S. Reported as https://github.com/jeremyevans/sequel/issues/1888

如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论， 你可以免费 注册 一个本站的账号。

评论（1）

油饼 2025-02-18 20:20:02

当我们安装Ruby-ODBC GEM时，我们需要通过执行下一个操作来用先前安装的IODBC-SDK进行配置：

gem install ruby-odbc -- --with-odbc-dir=/usr/local/Cellar/unixodbc/2.3.11

When we install ruby-odbc gem, we need to configure it with the reference to the previously installed iODBC-SDK by performing the next operation:

gem install ruby-odbc -- --with-odbc-dir=/usr/local/Cellar/unixodbc/2.3.11
回复 原文
~没有更多了~

关于作者

三五鸿雁

暂无简介

文章
评论
26 人气
发私信

相关话题

更多

热门标签

操作系统 程序设计 IT运维 Linux系统管理 JavaScript 服务器应用 solaris C/C++ PHP Shell BSD Vue.js aix Oracle Python HTML 系统管理 HTML5 CSS 前端
更多

推荐作者

alipaysp_snBf0MSZIv

文章 0 评论 0

梦断已成空

文章 0 评论 0

瞎闹

文章 0 评论 0

凯凯我们等你回来

文章 0 评论 0

寄意

文章 0 评论 0

似梦非梦

文章 0 评论 0

更多

友情链接

文江博客
    我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站，即表示您同意使用 Cookies 和您的相关数据。
    原文