Donations module (IPN check)

Posted: Sun Dec 09, 2007 2:35 am

I only get this error on the IPN check on the config
I was able to delete the sample records via the same module.
I set up a different database and I also used the nuke database. The same error comes up on both, even though I could manually add or delete records.

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'ODBC'@'localhost' (using password: NO) in G:\xampp\htdocs\modules\Donations\ipn\ipnppd.php on line 46
Access denied for user 'ODBC'@'localhost' (using password: NO)

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

It says you are not using a password. Does the database require a password?

Posted: Sun Dec 09, 2007 3:17 am

Database requires a password. I do not think the error is correct. I have had this type of error before during other installations but I don't recall what the actual problem was.

Posted: Sun Dec 09, 2007 3:26 am

The error is correct since it's coming from the odbc driver and not the IPN application. Something is not set up correctly with your database connection.

Posted: Sun Dec 09, 2007 4:43 am

I loaded the sql to the nuke database. Used the same setting as in config.php
and could delete the 3 sample records. Can add entries to database via admin. but get that same error as I printed before.

I added a new db to mysql and set up a user with password. Loaded the sql and was again able to delete and update via admin but still get the same error mentioned above when doing the ipn check here.

Posted: Sun Dec 09, 2007 7:32 am

I'm not arguing with you nor challenging you Wink

What I was trying to say is that the error is because of the lack of the password. Now as to the cause of the error, well, that's the unknown.

Is your user name really ODBC? Have you turned debug on, in the IPN script to see what it says. Have you tried copying config.inc.php file and calling it config.php?

Posted: Sun Dec 09, 2007 2:43 pm

ODBC is not the username. Question -- I do not have odbc defaults set in php.ini,
could that be the problem.

Posted: Sun Dec 09, 2007 3:16 pm

You are receiving a MySQL error that is pointing to a user named ODBC. Your database configuration seems to not be correct in your config.php. Have you renamed it as I suggested?

Posted: Sun Dec 09, 2007 3:47 pm

If I copy config.inc and replace the config it stops the whole system.

config.php

$dbhost = "localhost";
$dbuname = "baseuser";
$dbpass = "basepass";
$dbname = "basename";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = 'MySQL';
$sitekey = 'site key';
$gfx_chk = 7;
$subscription_url = '';
$admin_file = 'adminis';
$tipath = 'images/topics/';
$display_errors = true; //This should only be used (set to TRUE) when testing locally and not in a production environment

conf.inc.php
/* Database configuration */
$hostname_ipnppd = "localhost";
$database_ipnppd = "basename";
$username_ipnppd = "baseuser";
$password_ipnppd = "basepass";

$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: Sun Dec 09, 2007 4:11 pm

Unable to connect to SQL database

I know this is frustrating but as you can see it is unable to connect to your MySQL database. You have a configuration error in your IPN config.php or config.inc.php file. The message says modules/Donations/config.php so you need to be sure what you have named the IPN configuration file. But that is your problem.

Posted: Sun Dec 09, 2007 8:53 pm

Okay I got it fixed. Here is what I did.

Copied config.inc.php to /donations/ipn/ and renamed config.php

While access was okay I still got the message error for line 45 ----- so I
//$ipnppd = mysql_pconnect($hostname_ipnppd, $username_ipnppd, $password_ipnppd) or die(mysql_error());

// out that line in ipnppd.php and now everything works fine.

Posted: Sun Dec 09, 2007 9:03 pm

The documentation is lacking the statement "Make a copy of config.inc.php and put it in the IPN folder and rename it to config.php".

If one puts www/xxx/xxx/ with the trailing / in the preferences some of the code will result in // ---- if you leave the trailing / off in the preferences -- then you have the opposite problem in some of the code. I find less errors though by having the / trailing in the preferences.

Posted: Sun Dec 09, 2007 9:57 pm

Quote:

The documentation is lacking the statement "Make a copy of config.inc.php and put it in the IPN folder and rename it to config.php".

That's why I told you to do that up above Smile

Posted: Sun Dec 09, 2007 10:36 pm

I know, but I was in a fog from lack of sleep and I was associating that statement with the nuke config.php file. It wasn't until I had taken a long break and came back to it that I finally realized that the include was looking in the InP folder for the config.php.

But once that is correct then the "$ipnppd = mysql_pconnect" statement in inppd.php is not required because it is in the config.php and will show errors unless you remove the debug flag.

Posted: Mon Dec 10, 2007 1:27 am

Posted: Fri May 02, 2008 10:48 am

Donations module just stopped working. Apr 21 was the last donation made via paypal that showed up in our nuke_treasury database. 2 donations were made May 1, but neither shows up. Both were completed, but IPN not working.

I went into the Treasury admin/config and clicked on the "Click here to test IPN" and am now getting this error:

Quote:

Internal Server Error

Referred From : ...
Your IP : xx.xx.xxx.xxx
The Page Requested: /modules/Treasury/ipn/ipnppd.php?dbg=1
Agent : Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14
Redirect Status : 500

I checked the IPN settings both locally, and at Paypal. All is as it should be. Considering this was working less than 2 weeks ago, and no changes have been made to our site, is this s problem with our server, or PayPal?????

Posted: Fri May 02, 2008 11:26 am

I doubt it's Paypal as I just posted 2 donations. A status 500 almost always indicates an error in your .htaccess file. Try a quick test and rename your .htaccess file and test your IPN. If it works then something in your .htaccess file is causing it (syntax error usually). If it still fails then contact your host as they may have made a change to their main server configuration file httpd.conf.

Posted: Fri May 02, 2008 2:34 pm

Last blog from the paypal developer group was for a recurring API change, Feb 2008. Haven't seen anything since then.

I did read several issues yesterday that related to the .htaccess causing issues with the IPN.

-sting

Posted: Fri May 02, 2008 2:53 pm

Actually - it looks like it may have been Paypal.

There is a link at the following URL to a developer blog which describes the issue - it should be resolved now (or very soon). .
Check

http://www.paypaldeveloper.com/pdn/board/message?board.id=ipn&thread.id=10513

-sting

Posted: Fri May 02, 2008 5:07 pm

Actually, I saw that donations were posted to this sites Donations block so I checked my IPN link again and I got the same 500 error.

After reading the replies to my post, I checked again and .... 500 error. Then tried renaming .htaccess and still am getting the 500 error.

Thanks for you responses.

I just found out that the when I click on the Forums admin button I also get a 500 error. These are the only two area in admin where I am currently getting this error.

Posted: Fri May 02, 2008 5:53 pm

Do you have more than 1 .htaccess? If so, check the others if they are in a folder that is in the path(s) that the module uses. Also, check your Apache error log. A 500 error is a web server configuration error.

Posted: Fri May 02, 2008 6:16 pm

No, only one .htaccess file. Checking apache error log now.

Posted: Fri May 02, 2008 6:23 pm

Here are my errors:

Quote:

[Fri May 2 18:38:05 2008] [error] [client xx.xx.xxx.xxx Premature end of script headers: /homedirectory/modules/Donations/ipn/ipnppd.php
SoftException in Application.cpp:553: Directory "/homedirectory/modules" is writeable by others

Quote:

[Fri May 2 18:41:12 2008] [error] [client xx.xx.xxx.xxx] Premature end of script headers: /homedirectory/modules/Forums/admin/index.php
SoftException in Application.cpp:553: Directory "/homedirectory/modules" is writeable by others

Posted: Fri May 02, 2008 6:30 pm

http://www.google.com/search?q=Premature+end+of+script+headers%3A&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

Posted: Sat May 03, 2008 3:10 pm

This issue is fixed. It was related to folder pemissions. The server owner (who is hosting that particular website for free) implemented a new security script which changed the permissions on several folders.