mariadb-connector-odbc Last metadata expiration check: 0:08:55 ago on Wed 09 Jun 2021 02:41:29 PM EDT. Package mariadb-connector-odbc-3.1.13-1.fc35.x86_64 is already installed. Dependencies resolved. Nothing to do. Complete! test -x runtest.sh || chmod a+x runtest.sh ./runtest.sh :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: TEST PROTOCOL :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: Package : beakerlib RPM : beakerlib-1.26-1.fc35.noarch bl-redhat RPM : beakerlib-redhat-1-33.fc34eng.noarch Test name : mariadb_connection Test version : 1.0 Test started : 2021-06-09 14:50:25 EDT Test finished : Test duration : Distro : Fedora release 35 (Rawhide) Hostname : mschorm-1mt-fedora-rawhide-mls-34059-2021-06-09-18-24 Architecture : x86_64 CPUs : 1 x Intel Xeon Processor (Skylake, IBRS) RAM size : 1795 MB HDD size : 19.85 GB :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: Test description :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: PURPOSE of mariadb_connection Description: Tries to connect to MariaDB via unixODBC package Author: Michal Schorm :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: Setup :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: mariadb-connector-odbc-3.1.13-1.fc35.x86_64 :: [ 14:50:26 ] :: [ PASS ] :: Checking for the presence of mariadb-connector-odbc rpm :: [ 14:50:26 ] :: [ LOG ] :: Package versions: :: [ 14:50:26 ] :: [ LOG ] :: mariadb-connector-odbc-3.1.13-1.fc35.x86_64 unixODBC-2.3.9-2.fc34.x86_64 :: [ 14:50:26 ] :: [ PASS ] :: Checking for the presence of unixODBC rpm :: [ 14:50:26 ] :: [ LOG ] :: Package versions: :: [ 14:50:26 ] :: [ LOG ] :: unixODBC-2.3.9-2.fc34.x86_64 mariadb-10.5.10-2.fc35.x86_64 :: [ 14:50:26 ] :: [ PASS ] :: Checking for the presence of mariadb rpm :: [ 14:50:26 ] :: [ LOG ] :: Package versions: :: [ 14:50:26 ] :: [ LOG ] :: mariadb-10.5.10-2.fc35.x86_64 mariadb-server-10.5.10-2.fc35.x86_64 :: [ 14:50:26 ] :: [ PASS ] :: Checking for the presence of mariadb-server rpm :: [ 14:50:26 ] :: [ LOG ] :: Package versions: :: [ 14:50:26 ] :: [ LOG ] :: mariadb-server-10.5.10-2.fc35.x86_64 :: [ 14:50:26 ] :: [ PASS ] :: File /etc/odbcinst.ini should exist :: [ 14:50:26 ] :: [ PASS ] :: File '/etc/odbcinst.ini' should contain 'MariaDB' :: [ 14:50:26 ] :: [ PASS ] :: Command 'cp -f odbc.ini /etc/' (Expected 0, got 0) :: [ 14:50:26 ] :: [ PASS ] :: File /etc/odbc.ini should exist :: [ 14:50:27 ] :: [ PASS ] :: File '/etc/odbc.ini' should contain 'MariaDB' :: [ 14:50:30 ] :: [ PASS ] :: Command 'systemctl start mariadb' (Expected 0, got 0) :: [ 14:50:30 ] :: [ PASS ] :: Command 'echo "CREATE USER 'odbc_connector_user'@'localhost' IDENTIFIED BY 'odbc_connector_password'" | mysql ' (Expected 0, got 0) :: [ 14:50:30 ] :: [ PASS ] :: Command 'CREDENTIALS="odbc_connector_user odbc_connector_password"' (Expected 0, got 0) :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: Duration: 5s :: Assertions: 12 good, 0 bad :: RESULT: PASS (Setup) :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: Test :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> SHOW DATABASES +-----------------------------------------------------------------+ | Database | +-----------------------------------------------------------------+ | information_schema | +-----------------------------------------------------------------+ SQLRowCount returns 1 1 rows fetched SQL> :: [ 14:50:30 ] :: [ PASS ] :: Command ' echo "SHOW DATABASES" | isql -v mariadb-connector-odbc odbc_connector_user odbc_connector_password ' (Expected 0, got 0) +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> SELECT USER(),CURRENT_USER() +----------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------+ | USER() | CURRENT_USER() | +----------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------+ | odbc_connector_user@localhost | odbc_connector_user@localhost | +----------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------+ SQLRowCount returns 1 1 rows fetched SQL> :: [ 14:50:30 ] :: [ PASS ] :: Command ' echo "SELECT USER(),CURRENT_USER()" | isql -v mariadb-connector-odbc odbc_connector_user odbc_connector_password ' (Expected 0, got 0) :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: Duration: 0s :: Assertions: 2 good, 0 bad :: RESULT: PASS (Test) :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: TEST PROTOCOL :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: Package : beakerlib RPM : beakerlib-1.26-1.fc35.noarch bl-redhat RPM : beakerlib-redhat-1-33.fc34eng.noarch Test name : mariadb_connection Test version : 1.0 Test started : 2021-06-09 14:50:25 EDT Test finished : 2021-06-09 14:50:31 EDT (still running) Test duration : 6 seconds Distro : Fedora release 35 (Rawhide) Hostname : mschorm-1mt-fedora-rawhide-mls-34059-2021-06-09-18-24 Architecture : x86_64 CPUs : 1 x Intel Xeon Processor (Skylake, IBRS) RAM size : 1795 MB HDD size : 19.85 GB :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: Test description :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: PURPOSE of mariadb_connection Description: Tries to connect to MariaDB via unixODBC package Author: Michal Schorm :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: Setup :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: [ 14:50:26 ] :: [ PASS ] :: Checking for the presence of mariadb-connector-odbc rpm :: [ 14:50:26 ] :: [ LOG ] :: Package versions: :: [ 14:50:26 ] :: [ LOG ] :: mariadb-connector-odbc-3.1.13-1.fc35.x86_64 :: [ 14:50:26 ] :: [ PASS ] :: Checking for the presence of unixODBC rpm :: [ 14:50:26 ] :: [ LOG ] :: Package versions: :: [ 14:50:26 ] :: [ LOG ] :: unixODBC-2.3.9-2.fc34.x86_64 :: [ 14:50:26 ] :: [ PASS ] :: Checking for the presence of mariadb rpm :: [ 14:50:26 ] :: [ LOG ] :: Package versions: :: [ 14:50:26 ] :: [ LOG ] :: mariadb-10.5.10-2.fc35.x86_64 :: [ 14:50:26 ] :: [ PASS ] :: Checking for the presence of mariadb-server rpm :: [ 14:50:26 ] :: [ LOG ] :: Package versions: :: [ 14:50:26 ] :: [ LOG ] :: mariadb-server-10.5.10-2.fc35.x86_64 :: [ 14:50:26 ] :: [ PASS ] :: File /etc/odbcinst.ini should exist :: [ 14:50:26 ] :: [ PASS ] :: File '/etc/odbcinst.ini' should contain 'MariaDB' :: [ 14:50:26 ] :: [ PASS ] :: Command 'cp -f odbc.ini /etc/' (Expected 0, got 0) :: [ 14:50:26 ] :: [ PASS ] :: File /etc/odbc.ini should exist :: [ 14:50:27 ] :: [ PASS ] :: File '/etc/odbc.ini' should contain 'MariaDB' :: [ 14:50:30 ] :: [ PASS ] :: Command 'systemctl start mariadb' (Expected 0, got 0) :: [ 14:50:30 ] :: [ PASS ] :: Command 'echo "CREATE USER 'odbc_connector_user'@'localhost' IDENTIFIED BY 'odbc_connector_password'" | mysql ' (Expected 0, got 0) :: [ 14:50:30 ] :: [ PASS ] :: Command 'CREDENTIALS="odbc_connector_user odbc_connector_password"' (Expected 0, got 0) :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: Duration: 5s :: Assertions: 12 good, 0 bad :: RESULT: PASS (Setup) :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: Test :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: [ 14:50:30 ] :: [ PASS ] :: Command ' echo "SHOW DATABASES" | isql -v mariadb-connector-odbc odbc_connector_user odbc_connector_password ' (Expected 0, got 0) :: [ 14:50:30 ] :: [ PASS ] :: Command ' echo "SELECT USER(),CURRENT_USER()" | isql -v mariadb-connector-odbc odbc_connector_user odbc_connector_password ' (Expected 0, got 0) :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: Duration: 0s :: Assertions: 2 good, 0 bad :: RESULT: PASS (Test) :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: mariadb_connection :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: mariadb_connection :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: [ 14:50:31 ] :: [ LOG ] :: JOURNAL XML: /var/tmp/beakerlib-LJhB7CY/journal.xml :: [ 14:50:31 ] :: [ LOG ] :: JOURNAL TXT: /var/tmp/beakerlib-LJhB7CY/journal.txt :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: Duration: 6s :: Phases: 2 good, 0 bad :: OVERALL RESULT: PASS (mariadb_connection)