Can’t open lib ‘/usr/lib64/libmyodbc5.so’ : file not found

Archives Ansible Project
1

command:

$ echo “select 1” | isql -v asterisk asterisk password

Error:

[01000][unixODBC][Driver Manager]Can’t open lib ‘/usr/lib64/libmyodbc5.so’ : file not found [ISQL]ERROR: Could not SQLConnect

odbcinst.ini:

[PostgreSQL] Description=ODBC for PostgreSQL Driver=/usr/lib/psqlodbcw.so Setup=/usr/lib/libodbcpsqlS.so Driver64=/usr/lib64/psqlodbcw.so Setup64=/usr/lib64/libodbcpsqlS.so FileUsage=1 [MySQL] Description=ODBC for MySQL Driver=/usr/lib/libmyodbc5.so Setup=/usr/lib/libodbcmyS.so Driver64=/usr/lib64/libmyodbc5.so Setup64=/usr/lib64/libodbcmyS.so FileUsage=1 [FreeTDS] Description=Free Sybase & MS SQL Driver Driver=/usr/lib/libtdsodbc.so Setup=/usr/lib/libtdsS.so Driver64=/usr/lib64/libtdsodbc.so Setup64 = /usr/lib64/libodbcmyS.so Port=1433 [MariaDB] Description=ODBC for MariaDB Driver=/usr/lib/libmaodbc.so Driver64 = /usr/lib64/libmyodbc5a.so FileUsage=1 [MySQL ODBC 5.3 Unicode Driver] Driver=/usr/lib64/libmyodbc5w.so UsageCount=1 [MySQL ODBC 5.3 ANSI Driver] Driver=/usr/lib64/libmyodbc5a.so UsageCount=1

odbc.ini

BEGIN ANSIBLE MANAGED BLOCK [asterisk] Driver = MySQL Description = MySQL connection to ‘asterisk’ database Server = localhost Port = 3306 Database = asterisk UserName = asterisk Password = passchanged #Socket = /var/run/mysqld/mysqld.sock Socket = /var/lib/mysql/mysql.sock # END ANSIBLE MANAGED BLOCK

2

Expected Output:

+---------------------------------------+
> Connected! |
> sql-statement |
> help [tablename] |
> quit |
+---------------------------------------+
3

Expected Output:

>+---------------------------------------+ | Connected! | | sql-statement | | help [tablename] | | quit |
+---------------------------------------+|

Your problem is not related to Ansible at all, please contact a mailing list related to the problem.

Regards
       Racke