[Lazarus] errno 13 permission denied

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[Lazarus] errno 13 permission denied

Free Pascal - Lazarus mailing list
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? 




--
_______________________________________________
Lazarus mailing list
[hidden email]
https://lists.lazarus-ide.org/listinfo/lazarus
Reply | Threaded
Open this post in threaded view
|

Re: [Lazarus] errno 13 permission denied

Free Pascal - Lazarus mailing list
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 <[hidden email]> 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? 





--
_______________________________________________
Lazarus mailing list
[hidden email]
https://lists.lazarus-ide.org/listinfo/lazarus
Reply | Threaded
Open this post in threaded view
|

Re: [Lazarus] errno 13 permission denied

Free Pascal - Lazarus mailing list


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 <[hidden email]>
> 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
[hidden email]
https://lists.lazarus-ide.org/listinfo/lazarus