[ phpopencounter-Bugs-706110 ] the api call 'top' tries to connect to the wrong server

Bugs item #706110, was opened at 2003-03-19 09:20
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=101716&aid=706110&group_id=1716

Category: Analysis Module
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Frank Rennekamp (rennekamp)
Assigned to: Sebastian Bergmann (bergmann)
Summary: the api call 'top' tries to connect to the wrong server

Initial Comment:
Well, my configuration is like this:
server 1 is an apache webserver, with php-4.3 and 
phpOpenTracker-1.1.3 on a linux system.
On server 2 I've a mysql database (v 4.x).

I've no problems logging into the database and no 
problems getting the pageimressions statistic, but if I try 
to get statistics with the api call 'top', I'm getting the 
following error-message:

phpOpenTracker Error: Access denied for 
user: 'openTrackerUser@IP-ADDR_OF_SERVER_1 to 
database 'phpOpenTracker' 

Seems to me that the top-plugin is loosing the 
configuration  for the database-server and tries to 
connect to the localhost instead.



----------------------------------------------------------------------

>Comment By: Sebastian Bergmann (bergmann)
Date: 2003-03-19 10:07

Message:
Logged In: YES 
user_id=7993

Does the openTrackerUser have the "CREATE TEMPORARY TABLES"
privilege? If not, this could be the cause for this. It just
occured to me that I did not document this, yet.


----------------------------------------------------------------------

Comment By: Sebastian Bergmann (bergmann)
Date: 2003-03-19 09:57

Message:
Logged In: YES 
user_id=7993

supportsNestedQueries() is overridden in mysql.php, where it
returns either true or false, depending on the MySQL Server
version.


----------------------------------------------------------------------

Comment By: Frank Rennekamp (rennekamp)
Date: 2003-03-19 09:50

Message:
Logged In: YES 
user_id=737412

well, looking at the code, I can't understand it either. 
Debugging the code, I only find out that this error appears in 
the top.php, when executing the code:
if($this->db->supportsNestedQueries())
...

By the way,why are you calling this function, it only returns 
true and doesn't contain any other code?

----------------------------------------------------------------------

Comment By: Sebastian Bergmann (bergmann)
Date: 2003-03-19 09:37

Message:
Logged In: YES 
user_id=7993

I don't see how this could happen.


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=101716&aid=706110&group_id=1716


-------------------------------------------------------
This SF.net email is sponsored by: Does your code think in ink? 
You could win a Tablet PC. Get a free Tablet PC hat just for playing. 
What are you waiting for?
http://ads.sourceforge.net/cgi-bin/redirect.pl?micr5043en