Mattos Posted August 22, 2014 Share Posted August 22, 2014 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 comment Share on other sites More sharing options...
erdal Posted August 22, 2014 Share Posted August 22, 2014 pls see to log files and run application with Administrator Link to comment Share on other sites More sharing options...
Mattos Posted August 22, 2014 Author Share Posted August 22, 2014 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 comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted August 22, 2014 Administrators Share Posted August 22, 2014 I did not understand. Does your MySQL server return an error? Link to comment Share on other sites More sharing options...
Mattos Posted August 22, 2014 Author Share Posted August 22, 2014 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 comment Share on other sites More sharing options...
Mattos Posted August 22, 2014 Author Share Posted August 22, 2014 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 ? Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted August 22, 2014 Administrators Share Posted August 22, 2014 Give required permissions to IUSR and IIS_IUSRS Link to comment Share on other sites More sharing options...
Mattos Posted August 22, 2014 Author Share Posted August 22, 2014 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 Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted August 22, 2014 Administrators Share Posted August 22, 2014 ...and? Link to comment Share on other sites More sharing options...
Mattos Posted August 22, 2014 Author Share Posted August 22, 2014 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. Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted August 22, 2014 Administrators Share Posted August 22, 2014 You need to check your MySQL login credentials then. Link to comment Share on other sites More sharing options...
Mattos Posted August 22, 2014 Author Share Posted August 22, 2014 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 comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted August 22, 2014 Administrators Share Posted August 22, 2014 simply configure your MySQL connection components in Delphi and assign them correct uname and password. Link to comment Share on other sites More sharing options...
Mattos Posted August 22, 2014 Author Share Posted August 22, 2014 I did it in localhost, it´s OK, but when I do with DLL I have this error message. Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted August 22, 2014 Administrators Share Posted August 22, 2014 where your linux mysql server is located, in localhost?! Link to comment Share on other sites More sharing options...
Mattos Posted August 22, 2014 Author Share Posted August 22, 2014 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 comment Share on other sites More sharing options...
Mattos Posted August 22, 2014 Author Share Posted August 22, 2014 Could I send you the DLL file and scripts of MySQL to you test in your server ? Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted August 22, 2014 Administrators Share Posted August 22, 2014 Please check your configuration. Sorry we can not test your dll in our server. Link to comment Share on other sites More sharing options...
Mattos Posted August 23, 2014 Author Share Posted August 23, 2014 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? Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted August 23, 2014 Administrators Share Posted August 23, 2014 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? Link to comment Share on other sites More sharing options...
Mattos Posted August 23, 2014 Author Share Posted August 23, 2014 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 Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted August 23, 2014 Administrators Share Posted August 23, 2014 Try standalond mode in same server and see if anything changes. Link to comment Share on other sites More sharing options...
adragan Posted September 26, 2014 Share Posted September 26, 2014 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 comment Share on other sites More sharing options...
Recommended Posts