File acess denied (PLEASE IS SO URGENT)

[Mattos]

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.

 

 

[erdal]

pls see to log files and

run application with Administrator

[Mattos]

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.

[Farshad Mohajeri]

I did not understand. Does your MySQL server return an error?

[Mattos]

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;

[Mattos]

I am reading https://community.dynamics.com/ax/b/faisalfareedaxlibrary/archive/2014/05/17/access-denied-while-copying-dll-into-windows-server-2012.aspx

 

Could It be something permission in Windows? Or with IUSR user ?

[Farshad Mohajeri]

Give required permissions to IUSR and IIS_IUSRS

[Mattos]

Yes, we used the instructions found in links:

 

http://www.unigui.com/doc/online_help/index.html?apache_2_2.htm

http://delphi.cz/img/vykriky20/unigui_guide_eng.pdf

http://chee-yang.blogspot.com.br/2009/10/configure-windows-7-iis7-for-isapi-dll.html

[Farshad Mohajeri]

...and?

[Mattos]

As I told we used step by step these links and when the DLL runs it shows this erros message and I think It did not connect with MySQL+Linux or MySQL Windows.

[Farshad Mohajeri]

You need to check your MySQL login credentials then.

[Mattos]

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.

[Farshad Mohajeri]

simply configure your MySQL connection components in Delphi and assign them correct uname and password.

[Mattos]

I did it in localhost, it´s OK, but when I do with DLL I have this error message.

[Farshad Mohajeri]

where your linux mysql server is located, in localhost?!

[Mattos]

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.

[Mattos]

Could I send you the DLL file and scripts of MySQL to you test in your server ?

[Farshad Mohajeri]

Please check your configuration.

Sorry we can not test your dll in our server.

[Mattos]

OK...I am going to check all configurations again step by step.

Could It be a problem with firewall or a closed port ? It is my last question, OK?

[Farshad Mohajeri]

Well, I don't have enough info to make any comment on this.

 

Where your mysql server is located?

What Delphi components are used to connect?

Where you web app is running?

Is it ISAPI or standalone?

[Mattos]

in a server of military police

SQLconnection

Intranet of military police

ISAPI

MySQL x Linux x IIS7 x Delphi X4 + UniGUI fmsoft_unigui_beta_0.94.0.1020_setup

[Farshad Mohajeri]

Try standalond mode in same server and see if anything changes.

[adragan]

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 !