Hi,

We have adserver ultimate.

I have a setup where the mysql db is on a separate server, not localhost. The admin/config.inc.php is configured to use this separate server:

$mysql_server="otherhost.com";

And the admin page uses it perfectly.

...but show-ads.php is not using it. It displays this error:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'... in show-ads.php on line 3391

Any pointers would be appreciated.
Thanks

a your other mysql account dont allow outside connects.. or login from account from outside.. etc.... check your schema..

or b) your my.ini is setup wrong on your server.

The mysql server allows incoming connections just fine.

The error I provided clearly shows that the show-ads.php is trying to connect to the LOCAL mysql server, not to the external mysql server, so it's got nothing to do with the external mysql server.

To get this to work correctly, I had to add the following to show-ads.php:

include($GLOBALS['admin_folder']."/config.inc.php");
require_once('script.inc.php');

ie, show-ads.php was not using the correct db settings from admin/config.inc.php.