Jump to content

File acess denied (PLEASE IS SO URGENT)


Recommended Posts

Hello to all !!! 
 
I'm using Delphi + UniGUI fmsoft_unigui_beta_0.94.0.1020_setup XE4 (TSQLConnection) + MySQL / Linux + IIS7 and (try to also use in IIS8 + MySQL / Windows). 
 
The application (DLL) is executed and it shows the login screen with the error message "Access Denied" file and do not connect to MySQL. 
 
The DLL created folders: asnet_client, cache, ext-4.2.1.883, files, js, log, temp, uni. I think the DLL should be needing to create other folders trying to record something else and it is not getting success. 
 
We did all the tests and other applications like phpAdmin, Navicat MySQL and comands lines show direct to us the tables and data are listed by select. 
 
I would like some help, because I'm trying to solve this problem for 3 weeks without a way to go and my project can be lost if I did not give a solution to that as soon as possible. 
 
Greetings and thanks, 
 
Fernando Mattos.

 

 

Link to post
Share on other sites

PMembers, We logged like administrator of CPU and run the DLL, but it can not connect with MySQL and show this error message only. I am going to receive the log file to send you. Please wait they send me this file.

Link to post
Share on other sites

It did not connect because I tried to save a text files so show me the erro points and they are not created in the DataModule file where I try to connect to MySQL.

The error messsage "File acess denied" shows before to do this...

 

 

procedure TdmRDA.DataModuleCreate(Sender: TObject);
var sParam: String;
begin
AssignFile(F1, 'Lixo00.Tmp');
ReWrite(F1);
WriteLn(F1, 'OK');
CloseFile(F1);
 
if SQLConnection.Connected=False then
  SQLConnection.Connected := True;
 
AssignFile(F1, 'Lixo01.Tmp');
ReWrite(F1);
WriteLn(F1, 'OK');
CloseFile(F1);
 
if sdsRDAopms.Active=False then
  sdsRDAopms.Active := True;
 
AssignFile(F1, 'Lixo02.Tmp');
ReWrite(F1);
WriteLn(F1, 'OK');
CloseFile(F1);
 
  if sdsRDAproxseq.Active=False then
  sdsRDAproxseq.Active := True;
 
AssignFile(F1, 'Lixo02.Tmp');
ReWrite(F1);
WriteLn(F1, 'OK');
CloseFile(F1);
 
  if sdsRDAauditoria.Active=False then
  sdsRDAauditoria.Active := True;
 
AssignFile(F1, 'Lixo03.Tmp');
ReWrite(F1);
WriteLn(F1, 'OK');
CloseFile(F1);
 
  if sdsRDAtextos.Active=False then
  sdsRDAtextos.Active := True;
 
AssignFile(F1, 'Lixo04.Tmp');
ReWrite(F1);
WriteLn(F1, 'OK');
CloseFile(F1);
 
  if sdsRDAgeral.Active=False then
  sdsRDAgeral.Active := True;
 
AssignFile(F1, 'Lixo05.Tmp');
ReWrite(F1);
WriteLn(F1, 'OK');
CloseFile(F1);
 
  if sdsRDAgeral2.Active=False then
  sdsRDAgeral2.Active := True;
 
AssignFile(F1, 'Lixo06.Tmp');
ReWrite(F1);
WriteLn(F1, 'OK');
CloseFile(F1);
 
  if sdsRDAgeral3.Active=False then
  sdsRDAgeral3.Active := True;
 
AssignFile(F1, 'Lixo07.Tmp');
ReWrite(F1);
WriteLn(F1, 'OK');
CloseFile(F1);
 
end;
Link to post
Share on other sites

OK...could you show me how I must do it ? I am not a specialist in MySQL. I can show the data in lines commands in MySQL, PHPAdmin and Navicat. Others DBA of MySQL did all tests about it and I did not see problems.

Link to post
Share on other sites
in the first case (IIS7 + MySQL / Linux) I had a connection and I had erros with the name where Linux did not find RDAgeral and a change all table names to lowercase like rdageral. After I had this last error.

 

In the second case (IIS8 + MySQL/Windows) it always showed the last error.

Link to post
Share on other sites
  • 1 month later...

If you run UniGui on Windows and mySQL on some linux machine then :

 

1. See that MySQL has the habit of rejecting connections other than localhost.

    It's a setting on mySQL that allows outside access to it . It's a security feature that you have to overcome.

2. Open the 3300 ( I don't remember it exactly ) port in then firewall on the linux box

3. Install the mySQL client on the Windows machine. There are some dll's.

4. Configure access to IUSER and IIS_USER on the Windows box.

    They must have full access espetially on the temp directory.

 

Sorry for being so vage but I stopped working with mySQL some time ago !

Link to post
Share on other sites
×
×
  • Create New...