2. PHPRunner General questions
  3. [SOLVED]  running phprunner projects on remote web server
This topic is locked
[SOLVED]

 running phprunner projects on remote web server

 		6/9/2015 10:57:20 AM
PHPRunner General questions
G
 gudon author

Before PHPrunner 8.0, the way I ran my phprunner projects on remote web sever

was:

  1. build everything at local windows machine using local database.
  2. upload project files (output folder) to the server site.
  3. edit the dbcommon.php file in the "include" folder for database connection.
    Now since PHPrunner 8.0, the above approach does not seem to work any more.

    I am trying to follow the manual and get the connection done through phprunner.php.

    But when I open http://www.mydomain.com/phprunner.php and click the "connect" button,

    it returns only one button " Show schema". The "Database" row does not show up.

    Similarly, for the "Connect to MySQL" page of PHPrunner project, I check

    "Connect using phprunne.php" and enter the URL of it, and click the "Connect"

    button, then I get a popup window:

    HTTP code 302

    HTTP Status: "Found"

    Unable to connect to the database
    Can anyone help? Thanks.
A
 		aptivus 6/9/2015



Before PHPrunner 8.0, the way I ran my phprunner projects on remote web sever

was:

  1. build everything at local windows machine using local database.
  2. upload project files (output folder) to the server site.
  3. edit the dbcommon.php file in the "include" folder for database connection.
    Can anyone help? Thanks.


Now you must edit the connections/ConnectionManager.php file.

Bye
Sergey Kornilov admin 6/9/2015

It looks something is not right with database connection. As a first step I would contact your web hosting support team to figure out what are correct database connection parameters.
Once you are able to connect via phprunner.php you should be able to use the same connection settings in generated application.
G
 		gudon author 6/10/2015



It looks something is not right with database connection. As a first step I would contact your web hosting support team to figure out what are correct database connection parameters.
Once you are able to connect via phprunner.php you should be able to use the same connection settings in generated application.


I believe the problem is caused by an additional authentication.
www.mydomain.com'>www.mydomain.com is protected by a central authentication service (cas). When I run http://www.mydomain.com'>www.mydomain.com/phprunner.php, I have to first login to www.mydomain.com'>www.mydomain.com with cas user account info. The first login page is something like
https: //cas.mydomain.com/cas/login?service=http//www.mydomain.com'>www.mydomain.com/phprunner.php
After that, it redirects to the http://www.mydomain.com'>www.mydomain.com/phprunner.php page. From there on, I will be able to connect to my database.
How could I solve this cas problem?
Sergey Kornilov admin 6/10/2015

Turn off whatever that authentication service is or ask your hosting company to enable direct connection to MySQL so you do not need to use phprunner.php connection.
G
 		gudon author 6/11/2015

Aptivus' approach seems to be the easiest and working one for me.
Thank you Aptivus.