t_bergman Posted November 10, 2011 Report Posted November 10, 2011 After an upgrade to my development server, I have a test version on phpVMS up and running. After downloading and updating the Kacars module and connecting via the program nothing is being transmitted to the mySQL database. Not sure if a port is closed or what? Windows Server 2008 R2 Website is hosted on IIS 7.5 www.hphvirtual.com/site/ Thanks for the help, Tom Quote
Guest lorathon Posted November 10, 2011 Report Posted November 10, 2011 What version of phpVMS? Quote
Guest lorathon Posted November 10, 2011 Report Posted November 10, 2011 So nothing is logged in the acarsdata table? Quote
t_bergman Posted November 10, 2011 Author Report Posted November 10, 2011 correct, or being sent when I file a PIREP. Quote
Guest lorathon Posted November 10, 2011 Report Posted November 10, 2011 After sending a pirep what does kacars_free report? PIREP FILED? or something else? Quote
t_bergman Posted November 10, 2011 Author Report Posted November 10, 2011 Yes it is reporting that PIREP has been filed but there is nothing showing in the database. I am not using standard table prefixes for security, could that be it? my database user which phpVMS is using has 777 permissions for the phpVMS database. Quote
Guest lorathon Posted November 10, 2011 Report Posted November 10, 2011 Not sure. I would check the error logs. If kACARS_Free is reporting that the PIREP has been filed then phpVMS is returning that the PIREP was inserted. Quote
t_bergman Posted November 11, 2011 Author Report Posted November 11, 2011 Just for experiment, how does k-acars pass data to the server so I can make sure those methods are open. Quote
Guest lorathon Posted November 11, 2011 Report Posted November 11, 2011 XML. Put if you are able to login then the I would think that XML parsing should be working. Quote
t_bergman Posted November 11, 2011 Author Report Posted November 11, 2011 Yes, then it should be able to send and receive data. It has got to be a server issue, I need to investigate privileges in IIS then to see if the anonymous user is being blocked from sending and receiving portions of information. Quote
drgullen Posted October 9, 2012 Report Posted October 9, 2012 Sorry to bump this old post, but this exact problem is happening to me as well. PIREP says it was filed, receive.xml says: <sitedata><info><pirepStatus>1</pirepStatus></info></sitedata> which I believe means a success PIREP filing, but my phpVMS system shows no PIREPs pending and the database table for phpvms_pireps is empty. You mentioned to check the error logs. Where are they? Which logs? Anyone have a solution for this? Cheers Quote
MsWIZZ Posted October 11, 2012 Report Posted October 11, 2012 I had the same problem - the windows 7 or Vista solution is to run kAcars with administrator privileges. Regards Quote
drgullen Posted October 18, 2012 Report Posted October 18, 2012 Actually, the problem in my case is that I had MySql set to strict mode. Actually, I should say that by default, I believe it is installed in that mode. I guess kACARS (or any program for that matter because XAcars didn't work either) cannot access the necessary tables in the database when MySql is in strict mode. The change described in the following link fixed this for me: http://forum.mambo-foundation.org/showthread.php?t=5254 Quote
Guest lorathon Posted October 22, 2012 Report Posted October 22, 2012 FYI - kACARS does NOT connect to MySQL. phpVMS handles all DB calls. Quote
drgullen Posted October 24, 2012 Report Posted October 24, 2012 Jeff, That may be true, but it's also true that with MySQL in strict mode, kACARS will report a successful PIREP, but nothing will make it to the database. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.