Hi,

I was testing the UC Linkpoint API and when it ran, I got the "My SQL server has gone away" message. As far as I know, I installed it correctly (PEM, store number, etc...). When I try with the test gateway, it works.

Any info?

Thanks

Comments

flying6s’s picture

flying6s commented
Priority: Critical » Minor
jrust’s picture

jrust commented
Status: Active » Fixed

I'm going to say this almost certainly isn't related to the linkpoint module since it doesn't interface with the database at all.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

espirates’s picture

espirates commented

Same thing keeps happen to me

Poieo’s picture

Poieo commented

I'm having the same issue. Any of you guys work this out?

mrconnerton’s picture

mrconnerton commented
Status: Closed (fixed) » Needs work

The module uses watchdog so it is using the database.

I had to fix two things to make this work on my setup:

1) I didn't have the pem file in the correct place or the location to it correct. This is an absolute path on the server.

2) I changed my watchdog table from myisam to innodb using this command.

ALTER TABLE `watchdog` ENGINE = INNODB

This made the 30 second wait/timeout disappear and the transactions started to go through.

rszrama’s picture

rszrama commented
Status: Needs work » Closed (cannot reproduce)

I really don't think there's a bug here in the UC Linkpoint API module. Both uses of watchdog() are innocuous and would not cause a DB connection to drop on their own. The watchdog() is a fairly common tool in Drupal, though, so there's a good chance your table was just having other issues that you encountered when this module touched the table. On my test site I've reproduced both watchdog messages successfully.