Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

2 db users?


gags_78

Recommended Posts

hey folks,

 

I'm a db call away from getting IPN working but I've come a cropped with MYSQL

and a 'Lost connection to MySQL server during query' error being thrown my way.

 

I think it's something to do with my db user.

 

In the installation it prompts ye for two users doesn't it? It did in the older version.

 

Could anyone explain what the two users are for and in which of the two config

files I'd need to change the values?

 

Thanks,

Mark.

Link to comment
Share on other sites

I'm a db call away from getting IPN working but I've come a cropped with MYSQL

and a 'Lost connection to MySQL server during query' error being thrown my way.

 

For Search purposes ..

 

Lost connection to MySQL server during query

Godaddy

Linux economy

MySql

 

the solution is described below ..

 

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

Found out what was causing the

 

lost connection to mysql server during query

 

The cause was to do with the following lines in the ipn.php file.

 

if ( (PHP_VERSION >= 4.3) && ($fp = @fsockopen('ssl://' . $server, 443, $errno, $errstr, 30)) ) {

$fsocket = true;

} elseif (function_exists('curl_exec')) {

$curl = true;

} elseif ($fp = @fsockopen($server, 80, $errno, $errstr, 30)) {

$fsocket = true;

}

 

A week ago it became apparent tha the cURL option wasn't working so I removed the option from the if statement.

Alas whatever is going on under the hood of the line @fsockopen('ssl://' . $server, 443, $errno, $errstr, 30)

was preventing any mysql queries from executing resulting in the above line.

 

I commented it out too and now only have

 

if ($fp = @fsockopen($server, 80, $errno, $errstr, 30)) {

$fsocket = true;

}

 

and it zips through, updates the order to pending and emails me the order too!!!! So I'm happy as a pig in the perverbial thumbsup.gif

 

Thanks a million for the great contrib Terra. If there's any chance you could glance over the @fsockopen('ssl://' . $server, 443, $errno, $errstr, 30)

and let me know if you can see how it might be knockin' out the mysql query ability that would be great.

 

Right now my orders are updating to pending. What's the difference between pending and processing? From this point do I have to update the orders manually?

 

I'm going to go about getting encrypted web payments going now. I presume I'll have to uncomment out the first option with the ssl once it's in place??

Any heads up on any problems I'm likely to encounter would be great.

 

Thanks again,

 

Mark.

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

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...