On Sat, 12 May 2018, Larry Dalton via Lazarus wrote:
> I need to correct my original statement: the column name is 'checking', not
> On Sat, May 12, 2018 at 1:28 PM, Larry Dalton <[hidden email]>
>> It am running lazarus 1.8.2 on linux 17.2, and trying to connect to mysql
>> I have a database named 'boa', with 5 columns, the first named 'mycheck';
>> I am using a TMySql57Connection, named boaconnection with the following
>> A TSqlTransaction named boatransaction
>> Database named boaconnection
>> A TDatasource with DataSet set to BoaQuery
>> A TSqlQuery named boaquery with the following settings
>> SQL='Select * from Checking
>> When I try to set boaquery.active to 'true' I get the following error code:
>> BoaConnection: Error executing query: Can't find file:
>> './boa/checking.frm' (errno: 13-Permission denied).
>> When I leave boaquery.active set to 'false', and run the program, when I
>> try to open the table, I get:
>> Project MoneProject raised exception class 'ESQLDatabaseError' with
>> BoaConnection:Error executing query: Can't read dir of './boa/'
>> (errno:13-Permission denied)
>> How can I correct these errors?
These are errors in your MySQL server. They have nothing to do with FPC.
The file permissions on the server are wrong; the server process does not
have sufficient rights to read/write the database files.
Assuming the server is on Linux or BSD, you should find the MySQL
databases directory and execute as root
chown -R mysqld:mysqld boa
(mysqld must be replaced with the username that the mysql server is running