Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-338

odbc_connstring testcase failure for rhel 7.x

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 3.1.13
    • None
    • General
    • OS: RHEL 7.9 / 7.8
      arch: intel
      MariaDB version: 10.5

    Description

      I am getting obdc_connstring test case failure when building from the source. I used ctest to run the test cases, all the test cases are successful except odbc_connstring.

      On further debugging odbc_connstring, the test case has many sub-tests and out of which only all_other_fields_test sub-test is failing at around line 292.
      https://github.com/mariadb-corporation/mariadb-connector-odbc/blob/master/test/connstring.c#L291

      Furthermore, if I comment lines 287 and 288, test case does not fail and passes successfully. But I am not sure if that is appropriate to do or not.

      Steps followed to build mariadb odbc connector from source:

      yum install -y mariadb mariadb-server unixODBC unixODBC-devel git cmake gcc libarchive openssl-devel openssl tar curl libcurl-devel krb5-devel make
      		 
      git clone https://github.com/MariaDB/mariadb-connector-odbc.git
      		 
      cd mariadb-connector-odbc
      		 
      git checkout 3.1.13
      		 
      git submodule init
      		 
      git submodule update
      		 
       
      		 
      cmake -G "Unix Makefiles" -DCMAKE_BUILD_TYPE=RelWithDebInfo -DCONC_WITH_UNIT_TESTS=Off  -DWITH_SSL=OPENSSL -DCMAKE_INSTALL_PREFIX=/usr/local
      		 
      make
      		 
      make install

      Steps followed to run tests:

      sudo mysql_install_db --user=mysql
      		 
      sudo mysqld_safe --user=mysql &
      		 
      sudo ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
      		 
      sudo mysql -u root -e "SET PASSWORD FOR 'root'@'localhost' = PASSWORD('rootpass');"
      		 
      export TEST_DRIVER=maodbc_test
      		 
      export TEST_SCHEMA=test
      		 
      export TEST_DSN=maodbc_test
      		 
      export TEST_UID=root
      		 
      export TEST_PASSWORD=rootpass
      		 
      edit /etc/odbc.ini and /etc/odbcinst.ini with appropriate values.
      		 
      ctest

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          vivkong Vivian Kong added a comment -

          The failure is still seen on version 3.1.16.

          vivkong Vivian Kong added a comment - The failure is still seen on version 3.1.16.
          Lawrin Lawrin Novitsky added a comment -

          Thank you for your report.
          I am actually inclined to blame UnixODBC here, and this testsuite had many problems with this DM. Or another possible reason - something in your odbc.ini interfere.
          Unlike other testsuites, connstring isn't testing the driver using public ODBC API only, but is testing directly the code around connection string parsing and DSN reading and storing. Honestly, I think that it's quite enough if it runs well with Windows DM. but we do run it with UnixODBC and iOdbc on various platforms, and all is well.

          There are odbc.ini and odbcinst.ini generated in the test folder during the build. Could you please try
          1) export ODBCINI=(YourBuildDir)/test/odbc.ini
          export ODBCSYSINI=(YourBuildDir)/test
          2) Edit those files accordingly - since you install drivers on your system. If you do all export TEST_* before building, ini files should have that info correct, otherwise connection credentials need to be fixed as well
          3) run
          ctest --output-on-failure
          and give here the output if odbc_connstring is still failing

          Lawrin Lawrin Novitsky added a comment - Thank you for your report. I am actually inclined to blame UnixODBC here, and this testsuite had many problems with this DM. Or another possible reason - something in your odbc.ini interfere. Unlike other testsuites, connstring isn't testing the driver using public ODBC API only, but is testing directly the code around connection string parsing and DSN reading and storing. Honestly, I think that it's quite enough if it runs well with Windows DM. but we do run it with UnixODBC and iOdbc on various platforms, and all is well. There are odbc.ini and odbcinst.ini generated in the test folder during the build. Could you please try 1) export ODBCINI=(YourBuildDir)/test/odbc.ini export ODBCSYSINI=(YourBuildDir)/test 2) Edit those files accordingly - since you install drivers on your system. If you do all export TEST_* before building, ini files should have that info correct, otherwise connection credentials need to be fixed as well 3) run ctest --output-on-failure and give here the output if odbc_connstring is still failing
          vivkong Vivian Kong added a comment - - edited

          Thanks @Lawrin.

          I tried to rebuild the driver by export the TEST_* variables first and rerun the test but I'm still seeing the failure:

          25/25 Test #25: odbc_connstring ..................***Failed    8.34 sec
          		 
          # DSN=maodbc_test;UID=root;PWD={********};PORT=3306;DATABASE=test;OPTION=67108866;SERVER=localhost;
          		 
          1..13
          		 
          # MariaDB C/ODBC test DSN for automatic testing MariaDB C/ODBC test DSN for automatic testing
          		 
          # MariaDB C/ODBC test DSN for automatic testing MariaDB C/ODBC test DSN for automatic testing
          		 
          # maodbc_test maodbc_test
          		 
          # localhost localhost
          		 
          # Changed description Changed description
          		 
          # MariaDB C/ODBC test DSN for automatic testing MariaDB C/ODBC test DSN for automatic testing
          		 
          ok 1 - connstring_parsing_test
          		 
          # DSN=madb_connstr_options_test1:::DSN=madb_connstr_options_test1;DRIVER=maodbc_test;OPTIONS=0
          		 
          # DSN=madb_connstr_options_test2:::DSN=madb_connstr_options_test2;DRIVER=maodbc_test;OPTIONS=1
          		 
          # DSN=madb_connstr_options_test3:::DSN=madb_connstr_options_test3;DRIVER=maodbc_test;OPTIONS=2
          		 
          # DSN=madb_connstr_options_test4:::DSN=madb_connstr_options_test4;DRIVER=maodbc_test;OPTIONS=4
          		 
          # DSN=madb_connstr_options_test5:::DSN=madb_connstr_options_test5;DRIVER=maodbc_test;OPTIONS=8
          		 
          # DSN=madb_connstr_options_test6:::DSN=madb_connstr_options_test6;DRIVER=maodbc_test;OPTIONS=16
          		 
          # DSN=madb_connstr_options_test7:::DSN=madb_connstr_options_test7;DRIVER=maodbc_test;OPTIONS=32
          		 
          # DSN=madb_connstr_options_test8:::DSN=madb_connstr_options_test8;DRIVER=maodbc_test;OPTIONS=64
          		 
          # DSN=madb_connstr_options_test9:::DSN=madb_connstr_options_test9;DRIVER=maodbc_test;OPTIONS=128
          		 
          # DSN=madb_connstr_options_test10:::DSN=madb_connstr_options_test10;DRIVER=maodbc_test;OPTIONS=256
          		 
          # DSN=madb_connstr_options_test11:::DSN=madb_connstr_options_test11;DRIVER=maodbc_test;OPTIONS=512
          		 
          # DSN=madb_connstr_options_test12:::DSN=madb_connstr_options_test12;DRIVER=maodbc_test;OPTIONS=1024
          		 
          # DSN=madb_connstr_options_test13:::DSN=madb_connstr_options_test13;DRIVER=maodbc_test;OPTIONS=2048
          		 
          # DSN=madb_connstr_options_test14:::DSN=madb_connstr_options_test14;DRIVER=maodbc_test;OPTIONS=4096
          		 
          # DSN=madb_connstr_options_test15:::DSN=madb_connstr_options_test15;DRIVER=maodbc_test;OPTIONS=8192
          		 
          # DSN=madb_connstr_options_test16:::DSN=madb_connstr_options_test16;DRIVER=maodbc_test;OPTIONS=16384
          		 
          # DSN=madb_connstr_options_test17:::DSN=madb_connstr_options_test17;DRIVER=maodbc_test;OPTIONS=32768
          		 
          # DSN=madb_connstr_options_test18:::DSN=madb_connstr_options_test18;DRIVER=maodbc_test;OPTIONS=65536
          		 
          # DSN=madb_connstr_options_test19:::DSN=madb_connstr_options_test19;DRIVER=maodbc_test;OPTIONS=131072
          		 
          # DSN=madb_connstr_options_test20:::DSN=madb_connstr_options_test20;DRIVER=maodbc_test;OPTIONS=262144
          		 
          # DSN=madb_connstr_options_test21:::DSN=madb_connstr_options_test21;DRIVER=maodbc_test;OPTIONS=524288
          		 
          # DSN=madb_connstr_options_test22:::DSN=madb_connstr_options_test22;DRIVER=maodbc_test;OPTIONS=1048576
          		 
          # DSN=madb_connstr_options_test23:::DSN=madb_connstr_options_test23;DRIVER=maodbc_test;OPTIONS=2097152
          		 
          # DSN=madb_connstr_options_test24:::DSN=madb_connstr_options_test24;DRIVER=maodbc_test;OPTIONS=4194304
          		 
          # DSN=madb_connstr_options_test25:::DSN=madb_connstr_options_test25;DRIVER=maodbc_test;OPTIONS=8388608
          		 
          # DSN=madb_connstr_options_test26:::DSN=madb_connstr_options_test26;DRIVER=maodbc_test;OPTIONS=16777216
          		 
          # DSN=madb_connstr_options_test27:::DSN=madb_connstr_options_test27;DRIVER=maodbc_test;OPTIONS=33554432
          		 
          # DSN=madb_connstr_options_test28:::DSN=madb_connstr_options_test28;DRIVER=maodbc_test;OPTIONS=67108864
          		 
          # DSN=madb_connstr_options_test29:::DSN=madb_connstr_options_test29;DRIVER=maodbc_test;OPTIONS=134217728
          		 
          # DSN=madb_connstr_options_test30:::DSN=madb_connstr_options_test30;DRIVER=maodbc_test;OPTIONS=268435456
          		 
          # DSN=madb_connstr_options_test31:::DSN=madb_connstr_options_test31;DRIVER=maodbc_test;OPTIONS=536870912
          		 
          # DSN=madb_connstr_options_test32:::DSN=madb_connstr_options_test32;DRIVER=maodbc_test;OPTIONS=1073741824
          		 
          # DSN=madb_connstr_options_test33:::DSN=madb_connstr_options_test33;DRIVER=maodbc_test;OPTIONS=2147483648
          		 
          ok 2 - options_test
          		 
          # maodbc_test maodbc_test
          		 
          # MariaDB C/ODBC test DSN for automatic testing DESCRIPTION
          		 
          Strings do not match (File: /home/tester/mariadb-connector-odbc/test/connstring.c Line: 291)
          		 
          not ok 3 - all_other_fields_test
          		 
          # localhost localhost
          		 
          # test test
          		 
          # user user
          		 
          # password password
          		 
          # servername servername
          		 
          # randomdbname randomdbname
          		 
          ok 4 - aliases_tests
          		 
          ok 5 - dependent_fields_tests
          		 
          # some.other.host some.other.host
          		 
          ok 6 - driver_vs_dsn
          		 
          # MariaDB C/ODBC test DSN for automatic testing MariaDB C/ODBC test DSN for automatic testing
          		 
          # MariaDB C/ODBC test DSN for automatic testing MariaDB C/ODBC test DSN for automatic testing
          		 
          # maodbc_test maodbc_test
          		 
          # localhost localhost
          		 
          # Changed description Changed description
          		 
          # MariaDB C/ODBC test DSN for automatic testing MariaDB C/ODBC test DSN for automatic testing
          		 
          ok 7 - odbc188_nt_pairs
          		 
          # USE_MYCNF: 1 7405570 65536
          		 
          ok 8 - odbc229_usecnf
          		 
          # TlsVerion: 5, Port: 3307
          		 
          ok 9 - odbc228_tlsversion
          		 
          # pwd}sec}}ure} pwd}sec}}ure}
          		 
          # user_with_brace_in_pwd user_with_brace_in_pwd
          		 
          # Test dsn Test dsn
          		 
          # testhost.mariadb.com testhost.mariadb.com
          		 
          # pwd}sec}}ure} pwd}sec}}ure}
          		 
          # user_with_brace_in_pwd user_with_brace_in_pwd
          		 
          # Test dsn Test dsn
          		 
          # testhost.mariadb.com testhost.mariadb.com
          		 
          ok 10 - odbc284_escapebrace
          		 
          # DSN=maodbc_test;UID=root;PWD={********};PORT=3306;DATABASE=test;OPTION=67108866;SERVER=localhost;INTERACTIVE=1
          		 
          ok 11 - odbc288_interactive
          		 
          # DSN=maodbc_test;UID=root;PWD={********};PORT=3306;DATABASE=test;OPTION=67108866;SERVER=localhost;FORWARDONLY=1
          		 
          ok 12 - odbc290_forwardonly
          		 
          # DSN=maodbc_test;UID=root;PWD={********};PORT=3306;DATABASE=test;OPTION=67108866;SERVER=240.0.0.1:3307,localhost:3306;CONN_TIMEOUT=5
          		 
          # DSN=maodbc_test;UID=root;PWD={********};PORT=3306;DATABASE=test;OPTION=67108866;SERVER=localhost:3306,240.0.0.1:3307;CONN_TIMEOUT=5
          		 
          ok 13 - odbc366_failover
          		 
           
          		 
           
          		 
          96% tests passed, 1 tests failed out of 25
          		 
           
          		 
          Total Test time (real) =  40.52 sec
          		 
           
          		 
          The following tests FAILED:
          		 
                   25 - odbc_connstring (Failed)

          Here is my setup:

          $ echo $ODBCINI
          		 
          /home/tester/mariadb-connector-odbc/test/odbc.ini
          		 
          $ echo $ODBCSYSINI
          		 
          /home/tester/mariadb-connector-odbc/test
          		 
          $ cat /home/tester/mariadb-connector-odbc/test/odbc.ini
          		 
          [ODBC Data Sources]
          		 
          maodbc_test=MariaDB ODBC Connector Test
          		 
           
          		 
          [maodbc_test]
          		 
          Driver=/home/tester/mariadb-connector-odbc/libmaodbc.so
          		 
          DESCRIPTION=MariaDB ODBC Connector Test
          		 
          SERVER=localhost
          		 
          PORT=3306
          		 
          DATABASE=test
          		 
          UID=root
          		 
          PASSWORD=rootpass
          		 
          FORCETLS=0
          		 
          TCPIP=1

          vivkong Vivian Kong added a comment - - edited Thanks @Lawrin. I tried to rebuild the driver by export the TEST_* variables first and rerun the test but I'm still seeing the failure: 25/25 Test #25: odbc_connstring ..................***Failed 8.34 sec # DSN=maodbc_test;UID=root;PWD={********};PORT=3306;DATABASE=test;OPTION=67108866;SERVER=localhost; 1..13 # MariaDB C/ODBC test DSN for automatic testing MariaDB C/ODBC test DSN for automatic testing # MariaDB C/ODBC test DSN for automatic testing MariaDB C/ODBC test DSN for automatic testing # maodbc_test maodbc_test # localhost localhost # Changed description Changed description # MariaDB C/ODBC test DSN for automatic testing MariaDB C/ODBC test DSN for automatic testing ok 1 - connstring_parsing_test # DSN=madb_connstr_options_test1:::DSN=madb_connstr_options_test1;DRIVER=maodbc_test;OPTIONS=0 # DSN=madb_connstr_options_test2:::DSN=madb_connstr_options_test2;DRIVER=maodbc_test;OPTIONS=1 # DSN=madb_connstr_options_test3:::DSN=madb_connstr_options_test3;DRIVER=maodbc_test;OPTIONS=2 # DSN=madb_connstr_options_test4:::DSN=madb_connstr_options_test4;DRIVER=maodbc_test;OPTIONS=4 # DSN=madb_connstr_options_test5:::DSN=madb_connstr_options_test5;DRIVER=maodbc_test;OPTIONS=8 # DSN=madb_connstr_options_test6:::DSN=madb_connstr_options_test6;DRIVER=maodbc_test;OPTIONS=16 # DSN=madb_connstr_options_test7:::DSN=madb_connstr_options_test7;DRIVER=maodbc_test;OPTIONS=32 # DSN=madb_connstr_options_test8:::DSN=madb_connstr_options_test8;DRIVER=maodbc_test;OPTIONS=64 # DSN=madb_connstr_options_test9:::DSN=madb_connstr_options_test9;DRIVER=maodbc_test;OPTIONS=128 # DSN=madb_connstr_options_test10:::DSN=madb_connstr_options_test10;DRIVER=maodbc_test;OPTIONS=256 # DSN=madb_connstr_options_test11:::DSN=madb_connstr_options_test11;DRIVER=maodbc_test;OPTIONS=512 # DSN=madb_connstr_options_test12:::DSN=madb_connstr_options_test12;DRIVER=maodbc_test;OPTIONS=1024 # DSN=madb_connstr_options_test13:::DSN=madb_connstr_options_test13;DRIVER=maodbc_test;OPTIONS=2048 # DSN=madb_connstr_options_test14:::DSN=madb_connstr_options_test14;DRIVER=maodbc_test;OPTIONS=4096 # DSN=madb_connstr_options_test15:::DSN=madb_connstr_options_test15;DRIVER=maodbc_test;OPTIONS=8192 # DSN=madb_connstr_options_test16:::DSN=madb_connstr_options_test16;DRIVER=maodbc_test;OPTIONS=16384 # DSN=madb_connstr_options_test17:::DSN=madb_connstr_options_test17;DRIVER=maodbc_test;OPTIONS=32768 # DSN=madb_connstr_options_test18:::DSN=madb_connstr_options_test18;DRIVER=maodbc_test;OPTIONS=65536 # DSN=madb_connstr_options_test19:::DSN=madb_connstr_options_test19;DRIVER=maodbc_test;OPTIONS=131072 # DSN=madb_connstr_options_test20:::DSN=madb_connstr_options_test20;DRIVER=maodbc_test;OPTIONS=262144 # DSN=madb_connstr_options_test21:::DSN=madb_connstr_options_test21;DRIVER=maodbc_test;OPTIONS=524288 # DSN=madb_connstr_options_test22:::DSN=madb_connstr_options_test22;DRIVER=maodbc_test;OPTIONS=1048576 # DSN=madb_connstr_options_test23:::DSN=madb_connstr_options_test23;DRIVER=maodbc_test;OPTIONS=2097152 # DSN=madb_connstr_options_test24:::DSN=madb_connstr_options_test24;DRIVER=maodbc_test;OPTIONS=4194304 # DSN=madb_connstr_options_test25:::DSN=madb_connstr_options_test25;DRIVER=maodbc_test;OPTIONS=8388608 # DSN=madb_connstr_options_test26:::DSN=madb_connstr_options_test26;DRIVER=maodbc_test;OPTIONS=16777216 # DSN=madb_connstr_options_test27:::DSN=madb_connstr_options_test27;DRIVER=maodbc_test;OPTIONS=33554432 # DSN=madb_connstr_options_test28:::DSN=madb_connstr_options_test28;DRIVER=maodbc_test;OPTIONS=67108864 # DSN=madb_connstr_options_test29:::DSN=madb_connstr_options_test29;DRIVER=maodbc_test;OPTIONS=134217728 # DSN=madb_connstr_options_test30:::DSN=madb_connstr_options_test30;DRIVER=maodbc_test;OPTIONS=268435456 # DSN=madb_connstr_options_test31:::DSN=madb_connstr_options_test31;DRIVER=maodbc_test;OPTIONS=536870912 # DSN=madb_connstr_options_test32:::DSN=madb_connstr_options_test32;DRIVER=maodbc_test;OPTIONS=1073741824 # DSN=madb_connstr_options_test33:::DSN=madb_connstr_options_test33;DRIVER=maodbc_test;OPTIONS=2147483648 ok 2 - options_test # maodbc_test maodbc_test # MariaDB C/ODBC test DSN for automatic testing DESCRIPTION Strings do not match (File: /home/tester/mariadb-connector-odbc/test/connstring.c Line: 291) not ok 3 - all_other_fields_test # localhost localhost # test test # user user # password password # servername servername # randomdbname randomdbname ok 4 - aliases_tests ok 5 - dependent_fields_tests # some.other.host some.other.host ok 6 - driver_vs_dsn # MariaDB C/ODBC test DSN for automatic testing MariaDB C/ODBC test DSN for automatic testing # MariaDB C/ODBC test DSN for automatic testing MariaDB C/ODBC test DSN for automatic testing # maodbc_test maodbc_test # localhost localhost # Changed description Changed description # MariaDB C/ODBC test DSN for automatic testing MariaDB C/ODBC test DSN for automatic testing ok 7 - odbc188_nt_pairs # USE_MYCNF: 1 7405570 65536 ok 8 - odbc229_usecnf # TlsVerion: 5, Port: 3307 ok 9 - odbc228_tlsversion # pwd}sec}}ure} pwd}sec}}ure} # user_with_brace_in_pwd user_with_brace_in_pwd # Test dsn Test dsn # testhost.mariadb.com testhost.mariadb.com # pwd}sec}}ure} pwd}sec}}ure} # user_with_brace_in_pwd user_with_brace_in_pwd # Test dsn Test dsn # testhost.mariadb.com testhost.mariadb.com ok 10 - odbc284_escapebrace # DSN=maodbc_test;UID=root;PWD={********};PORT=3306;DATABASE=test;OPTION=67108866;SERVER=localhost;INTERACTIVE=1 ok 11 - odbc288_interactive # DSN=maodbc_test;UID=root;PWD={********};PORT=3306;DATABASE=test;OPTION=67108866;SERVER=localhost;FORWARDONLY=1 ok 12 - odbc290_forwardonly # DSN=maodbc_test;UID=root;PWD={********};PORT=3306;DATABASE=test;OPTION=67108866;SERVER=240.0.0.1:3307,localhost:3306;CONN_TIMEOUT=5 # DSN=maodbc_test;UID=root;PWD={********};PORT=3306;DATABASE=test;OPTION=67108866;SERVER=localhost:3306,240.0.0.1:3307;CONN_TIMEOUT=5 ok 13 - odbc366_failover     96% tests passed, 1 tests failed out of 25   Total Test time (real) = 40.52 sec   The following tests FAILED: 25 - odbc_connstring (Failed) Here is my setup: $ echo $ODBCINI /home/tester/mariadb-connector-odbc/test/odbc.ini $ echo $ODBCSYSINI /home/tester/mariadb-connector-odbc/test $ cat /home/tester/mariadb-connector-odbc/test/odbc.ini [ODBC Data Sources] maodbc_test=MariaDB ODBC Connector Test   [maodbc_test] Driver=/home/tester/mariadb-connector-odbc/libmaodbc.so DESCRIPTION=MariaDB ODBC Connector Test SERVER=localhost PORT=3306 DATABASE=test UID=root PASSWORD=rootpass FORCETLS=0 TCPIP=1

          People

            Lawrin Lawrin Novitsky
            shivaburade Shiva Burade
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.