You are not logged in.
I installed mariadb + patched version of myodbc (only patched this bug http://bugs.mysql.com/bug.php?id=75196). As you probably have guessed i need to use database via odbc.
However when i try to test connection i get these:
/mnt/bkp/webserver/db % isql MySQL-test
2015-06-06 15:29:45 7f5a9affe700 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
or
/mnt/bkp/webserver/db % sudo isql MySQL-test
[sudo] password for novist:
2015-06-06 15:33:30 7f25feca5700 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/ … codes.html
last one takes really long to complete. i get same errors when i use odbs from my python script, running script as root also makes it throw error 11 after a very long pause.
I set up ODBC as per wiki instructions (and its not the first time i do it).
/var/lib/mysql owned as mysql:root, anything inside as mysql:mysql. permissions on this folder and subdirs are ug+rwX
i uncommented all innodb settings in my.cnf and linked it to /etc/my.cnf
systemctl status mysqld doesnt show any errors,
Funny thing is - everything wors fine if i connect through dedicated application (navicat in my case). can browse tables, edit records etc. Out of desperation i tried converting my db to MyISAM - no luck.
Does anyone have any clue where to even start looking for a problem?
Offline