Can someone please help

New Member Joined: Sep 12, 2009 Posts: 2

I have installen nuke treasury on my site recently, but i'm having a few issues. Currently the links work ok and people can donate ok. It is the IPN bit that is an issue. When i click on the IPN test in the configuration i get the following in the popup window.

Debug mode activated

PHP-Nuke Treasury mod

PayPal Instant Payment Notification script

See below for status:
----------------------------------------------------------------
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

So no donations get updated on my site. I entered a manual payment in to the Treasury Financial Register but that did not show in the home page module either, but it was evident in the database table.

Can someone help me please,

registered · Posted: Sat Sep 12, 2009 3:25 am

In the Nuke Treasury you have a config file that you need to put your database connection information into.

Posted: Sat Sep 12, 2009 3:35 am

nuken wrote:

In the Nuke Treasury you have a config file that you need to put your database connection information into.

i have entered all the information required, see below.

* Database configuration */
$hostname_ipnppd = "db1453.oneandone.co.uk";
$database_ipnppd = "db245362583";
$username_ipnppd = "dbo245362583";
$password_ipnppd = "********"; (i purposly did this for this post)

$board_config = array();
global $ipnppd;

$ipnppd = mysql_pconnect($hostname_ipnppd, $username_ipnppd, $password_ipnppd);
if( $ipnppd )
{
mysql_select_db($database_ipnppd, $ipnppd);
$query_cfg = "SELECT * FROM config WHERE subtype = ''";
$cfgset = mysql_query($query_cfg, $ipnppd);

while ( $cfgset && $row = mysql_fetch_assoc($cfgset))
{
$tr_config[$row['name']] = $row['value'];
}
} else
{
echo "<br><br>NukeTreasury FATAL ERROR: Unable to connect to SQL database. Please check your settings in modules/Donations/config.php<br><br>";
}

Posted: Sat Sep 12, 2009 8:44 am

Not sure but, it may be a server configuration issue. I googled "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)" and saw that most people that had a similar error was due to server issue. You may try to contact you host and see if they may know why. I have no idea myself. Sorry