This topic is locked

Build Pages - Uploaded - Can't get past Login

12/4/2005 18:46:32
PHPRunner General questions
T
tradewise author

I've been on this for three days now, I've built some pages, uploaded but I can't get past the login screen.
In Admin I can connect direct to database but it seems on generated pages only localhost almost works.
At first I tried Database connect via URL & got this after trying to login:
Warning: mysql_connect(): Access denied for user 'myusername'@'myserver.net' (using password: YES) in /home/mydir/public_html/phprunner/edit_tags/include/dbconnection.php on line 9
Fatal error: Access denied for user 'myusername'@'myserver.net' (using password: YES) in /home/mydir/public_html/phprunner/edit_tags/include/dbconnection.php on line 12
Then I tried changing dbcommon.php settings to "localhost" I didn't get the warning but user & password recieves massage as Invalid Login and can't go any further. I have tried over 20 different combinations with different settings to do with Security but nothing works. I've also tried using the phprunner.php script as per instructions but regardless of what I do I get the same results - nothing useful.
In evaluation, the program seems to do what I want on the creation side but if I or my users can't get past login what's the point. At least with other programs I've tried I can get past Login but not so with PHPRunner, at this stage all I can say is "very nice admin for creation, nice login screen - shame about the rest".
I'd love to get this to work any suggestions?

Sergey Kornilov admin 12/5/2005

Hi,
it seems that your MySQL server denies access from your webserver IP address.

So you should use "localhost" to connect it.

Changing the hostname to localhost manually or using PHP to connect your MySQL is the recommended action.
Please note, that you don't need to enter your MySQL username and password on Login page.
If you selected Hardcoded username and passwordon Securitytab in PHPRunner, then you should enter username and password on Login page the same as you entered on Security tab.
If you selected Username and password from database, then you should enter username and password that are stored in your database table.

T
tradewise author 12/5/2005

Hi,

it seems that your MySQL server denies access from your webserver IP address.

So you should use "localhost" to connect it.

Changing the hostname to localhost manually or using PHP to connect your MySQL is the recommended action.
Please note, that you don't need to enter your MySQL username and password on Login page.
If you selected Hardcoded username and passwordon Securitytab in PHPRunner, then you should enter username and password on Login page the same as you entered on Security tab.
If you selected Username and password from database, then you should enter username and password that are stored in your database table.


I have tried all of this and more, I'm not new to connecting to a webserver or database I presently manage/host over 30 sites. I'm just new to indepth PHP/Mysql coding hence looking at your program to assist, my aim is to create a few pages that I need to enhance the flow of information on one particular site. What i can not understand is that I know I'm entering the right info in the right places but just can't get the generated pages to play the game!.
If I'm doing something stupid I'll be the first to admit it, however at the moment I feel like I'm bashing my head against a brick wall by repeating and doing the same things over and over and getting nowhere.

Sergey Kornilov admin 12/5/2005

Hi,
please answer the following questions.

  1. What info do you enter on Security tab in PHPRunner ?
  2. What username and password do you enter on Login page ? Are they your MySQL username and password or something other ?
  3. Could you give me a URL to your Login page ?
    Please send the answers to support@xlinesoft.com or post them here.