Install Ajax Errors and database connection error

This site is best viewed in a modern browser with JavaScript enabled.

Lutolfr

My configuration is reportico-6.0.16, Apache 2.4.41 running under Wampserver, php 7.4.0. I use http://reportico/index.php to call reportico. The Administration Page displays fine. However when I try to go to Design Mode, I get the Ajax Error: TextStatus:error Error Thrown Message I changed the start.php as you suggested to another user.
$reportico->reportico_ajax_script_url = "http://127.0.0.1:80/reportico/run.php"; Still get the error. When I use this url in a browser tab I get the Create a New Project page. When I "Go" the project information, I get Error: Error in Connection to pdo_mysql database :Connection attempt failed: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it.

peterdeed

Hi there

This sounds like the session isn't being started properly or the ajax scripts are not being loaded

Are you able to go into the browser inspect facility eg in (Chrome CTRL+SHIFT+I) and check the Network tab and check that all the links are being found ?

Are you also able to check the Console tab to see if there are any red errors?

If everything looks ok then i think we should debug what happens when you click the link.. are you happy to try that if i tell you how to do this and where to put the debug breakpoint?

Sorry its a bit complex debugging this issue.

Peter

Lutolfr

A little different behavior today. After entering the password on the Admin page and try to go to Design mode nothing happens. The Chrome console shows

The network tab shows

I can follow your instructions to debug. The url in the browser stiil gets me to the Create Project Page

peterdeed

Hi there

Is the CORS error possibly the problem?

Im not an expert but if you call a web page in one way as you have as http://reportico/index.php then ajax calls made to the same site expressed in a different way may be blocked.

I would have thought you might avoid the CORS issue by calling reportico in the same way as your ajax script url is specified ...

so what happens if you either:-

call reportico as http://127.0.0.1/reportico/index.php

change you ajax_script_url to http://reportico/run.php

I didnt know you could avoid specifiying the 127.0.0.1 and default to local host

I hope that helps, but i suspect that its more complicated than this

Peter

Lutolfr

calling Reportico as http://127.0.0.1/reportico/index.php works. Changing the ajax script to http://reportico/run.php and calling reportico the same way causes the ajax error.

Calling http://127.0.0.1/reportico/run.php with the start file set at http://reportico/run.php also works.

So the answer is I just need to call it as http://127.0.0.1/reportico/index.php or http://127.0.0.1/reportico/run.php ??
How do I get past the database connection refused error? Do I need to set the port somewhere in a config file?

peterdeed

Hi there

Good news!

Re the database.. are you running a non stadard port if so when you create the project you can enter the database name followed by ":portnumber" or when you specify the host you might put ":portnumber" after it..

Not sure if this answers the question, but i might need to double check if neither of these options work

Peter

Lutolfr

non std port was the problem. Wampserver was using 3308. In Create project Hostname I added the port.
127.0.01:3308 and it connected.
Thanks for all your help

peterdeed

Glad that worked!!