On Sat, 12 May 2018, Larry Dalton via Lazarus wrote:
I need to correct my original statement: the column name is 'checking', not
'mycheck'
On Sat, May 12, 2018 at 1:28 PM, Larry Dalton <larrydalto...@gmail.com>
wrote:
It am running lazarus 1.8.2 on linux 17.2, and trying to connect to mysql
5.7.
I have a database named 'boa', with 5 columns, the first named 'mycheck';
I am using a TMySql57Connection, named boaconnection with the following
settings:
Databasename=boa;
HostName=localhost
KeepConnection=false
LoginPrompt=false
Transaction=boatransaction
UserName=root,
A TSqlTransaction named boatransaction
Database named boaconnection
A TDatasource with DataSet set to BoaQuery
A TSqlQuery named boaquery with the following settings
Database=boaconnection
Transaction=boatransaction
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
message:
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
as)
Michael.
Michael.
--
_______________________________________________
Lazarus mailing list
Lazarus@lists.lazarus-ide.org
https://lists.lazarus-ide.org/listinfo/lazarus
