Error in test load() at (17155)osdb-my.c:3707:
... load updates
mysql reports: 29: File '/home/abazoskib/osdb/bin/data/asap.updates' not found (Errcode: 13)
The file is definitely there.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
To load the data, MySQL has to be able to read the data files, so check the permissions on the files in /home/abazoskib/osdb/bin/data, and also each of the directories above it, to ensure that the "mysql" user has read access to those files.
hth!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Well, this is an amusing one. The problem is the introduction of apparmor, which prevents the MySQL server from reading the user's data files with the "load data infile..." command. The problem disappears if you use "load data LOCCAL infile."
After issuing the following commands, you should find that everything works as intended:
Alternatively, you can download the latest version of OSDB from CVS, which now uses "load data LOCAL infile." I expect to put together a new kit in the next couple of weeks, but the CVS version seems to be solid.
Good luck!
Andy
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I finally got osdb to work with just MySQL, and here is the message I get when I try to:
./osdb-my --mysql=innodb
abazoskib@abazoskib:~/osdb/bin$ ./osdb-my --mysql=innodb
OSDB 0.21
Invoked: ./osdb-my --mysql=innodb
Compile-time options: none
Restrictions: none
Error in test Test Initialization at (10489)osdb.c:934:
... /home/abazoskib/osdb/bin/data
perror() reports: No such file or directory
someone sighup'd the parent
What should I do?
Got it to install for MySQL, but when I try to run:
./osdb-my --datadir $HOME/osdb/bin/data --dbuser root --dbpassword 728YLMKD42 --logfile log2.txt --noindexes --nomulti
I get:
OSDB 0.21
Invoked: ./osdb-my --datadir /home/abazoskib/osdb/bin/data --dbuser root --dbpassword 728YLMKD42 --logfile log2.txt --noindexes --nomulti
Error in test load() at (17155)osdb-my.c:3707:
... load updates
mysql reports: 29: File '/home/abazoskib/osdb/bin/data/asap.updates' not found (Errcode: 13)
The file is definitely there.
To load the data, MySQL has to be able to read the data files, so check the permissions on the files in /home/abazoskib/osdb/bin/data, and also each of the directories above it, to ensure that the "mysql" user has read access to those files.
hth!
i used chown to give mysql full rights to the data file. still the same error
Well, this is an amusing one. The problem is the introduction of apparmor, which prevents the MySQL server from reading the user's data files with the "load data infile..." command. The problem disappears if you use "load data LOCCAL infile."
After issuing the following commands, you should find that everything works as intended:
$ sudo touch /etc/apparmor.d/disable/usr.sbin.mysqld
$ sudo /etc/init.d/apparmor reload
Alternatively, you can download the latest version of OSDB from CVS, which now uses "load data LOCAL infile." I expect to put together a new kit in the next couple of weeks, but the CVS version seems to be solid.
Good luck!
Andy