2. PHPRunner General questions
  3. [SOLVED]  Possible bug: Access Denied for user only when published
This topic is locked
[SOLVED]

 Possible bug: Access Denied for user only when published

 		7/9/2015 8:29:01 PM
PHPRunner General questions
B
 bioman author

Hi,

I am receiving an access denied fatal error but only after publishing to my server. Testing locally has been good but when I uploaded the files via FTP and then attempted to access the landing page using it's URL I get this error:

Fatal error: Access denied for user 'quizninj_admin'@'a2ss16.a2hosting.com' (using password: YES) in /home/quizninj/public_html/phprunnerquizninja/connections/MySQLiConnection.php on line 84

Here is the URL:

http://quizninja.net/phprunnerquizninja/login.php
I am wondering if this is a bug. Why is this occuring? I do not recall experiencing this with my earlier project (I believe it used an earlier build of PHPRunner 8 or it might have used PHPRunner 7. Any ideas would be great. Thanks,

Brett
Admin 7/10/2015

You need to check with your hosting company what is correct combination of server address/username/password. Probably you need to use localhost instead of a2ss16.a2hosting.com as server address etc.
B
 		bioman author 7/10/2015

Hi Sergey,

When I tried 'localhost' I was unable to connect to the database from PHPRunner, so my hosting company told me to use their server name. Can I just change the server to 'localhost' in PHPRunner when publishing and then back to the server name when working on the project?



You need to check with your hosting company what is correct combination of server address/username/password. Probably you need to use localhost instead of a2ss16.a2hosting.com as server address etc.
B
 		bioman author 7/10/2015

I tried the above, but I cannot change the server to 'localhost' in PHPRunner because it is not possible to publish without connecting to the database. Do I need to modify the connection in the output folder after building the project? If so, how?



Hi Sergey,

When I tried 'localhost' I was unable to connect to the database from PHPRunner, so my hosting company told me to use their server name. Can I just change the server to 'localhost' in PHPRunner when publishing and then back to the server name when working on the project?
B
 		bioman author 7/10/2015

I found the solution! Here are the steps in PHPRunner:

  1. At the end of creating your project, go to "Output"
  2. Here you can specify a different database connection to use and replace the remote connection server name with 'localhost'. (To do this, make a new connection)
  3. Upload using this new connection.
    This worked for me! The page for detailed instructions on this is in the manual here: https://asprunner.com/phprunner/docs/output_directory_settings.htm

    Thanks,

    Brett


    I tried the above, but I cannot change the server to 'localhost' in PHPRunner because it is not possible to publish without connecting to the database. Do I need to modify the connection in the output folder after building the project? If so, how?