MySQL server has gone away?

Moderator: Site Moderators

Post Reply
bilde2910
Posts: 21
Joined: Sun Jan 22, 2012 1:28 pm
Hardware configuration: Manufacturer: Komplett A/S
Model: Komplett Gamer i05 - GTX 750Ti Edition (with changed parts)
OS: Windows 8.1 64-bit
CPU: Intel Core i3-4160 @ 3.60 GHz (not used for folding)
GPU: Sapphire Radeon R9 270 2GB GDDR5 (used for folding)
RAM: Crucial DDR3 BallistiX Sport 1600MHz 8GB
PSU: Cooler Master B600 VER.2, 600W PSU
DVD: ASUS DVD Writer, DRW-24F1ST
SSD: Kingston SSDNow V300 240GB 2.5" OEM
Motherboard: ASUS B85M-G, Socket-1150
Display: Samsung U28D590 @ 3840x2160p 60Hz
Location: Norway
Contact:

MySQL server has gone away?

Post by bilde2910 »

I was going to set my forum signature to this:

Code: Select all

[url=http://folding.extremeoverclocking.com/user_summary.php?s=&u=502709][img]http://mol.b2910.ftp.sh:8080/24396Hidden/bilde2910/foldResultsSmall.php[/img][/url]
Which would show as this:
Image

I get this error message:
Image

What do I do? I'd like to use the signature...
Any help appreciated.

- bilde2910
Image
P5-133XL
Posts: 2948
Joined: Sun Dec 02, 2007 4:36 am
Hardware configuration: Machine #1:

Intel Q9450; 2x2GB=8GB Ram; Gigabyte GA-X48-DS4 Motherboard; PC Power and Cooling Q750 PS; 2x GTX 460; Windows Server 2008 X64 (SP1).

Machine #2:

Intel Q6600; 2x2GB=4GB Ram; Gigabyte GA-X48-DS4 Motherboard; PC Power and Cooling Q750 PS; 2x GTX 460 video card; Windows 7 X64.

Machine 3:

Dell Dimension 8400, 3.2GHz P4 4x512GB Ram, Video card GTX 460, Windows 7 X32

I am currently folding just on the 5x GTX 460's for aprox. 70K PPD
Location: Salem. OR USA

Re: MySQL server has gone away?

Post by P5-133XL »

Perhaps this would be better addressed at the Extreme Overclocking forums where those folding signatures were created.
Image
k1wi
Posts: 909
Joined: Tue Sep 22, 2009 10:48 pm

Re: MySQL server has gone away?

Post by k1wi »

P5-133XL wrote:Perhaps this would be better addressed at the Extreme Overclocking forums where those folding signatures were created.
It looks like a forum generated error though?
P5-133XL
Posts: 2948
Joined: Sun Dec 02, 2007 4:36 am
Hardware configuration: Machine #1:

Intel Q9450; 2x2GB=8GB Ram; Gigabyte GA-X48-DS4 Motherboard; PC Power and Cooling Q750 PS; 2x GTX 460; Windows Server 2008 X64 (SP1).

Machine #2:

Intel Q6600; 2x2GB=4GB Ram; Gigabyte GA-X48-DS4 Motherboard; PC Power and Cooling Q750 PS; 2x GTX 460 video card; Windows 7 X64.

Machine 3:

Dell Dimension 8400, 3.2GHz P4 4x512GB Ram, Video card GTX 460, Windows 7 X32

I am currently folding just on the 5x GTX 460's for aprox. 70K PPD
Location: Salem. OR USA

Re: MySQL server has gone away?

Post by P5-133XL »

Possibly, but look at my EOC folding signature -- It's not getting the same error.
Image
k1wi
Posts: 909
Joined: Tue Sep 22, 2009 10:48 pm

Re: MySQL server has gone away?

Post by k1wi »

P5-133XL wrote:Possibly, but look at my EOC folding signature -- It's not getting the same error.
Trying to use his link causes the same database error to occur on my computer. It's not an EOC problem though because while he is creating a click-thru link to his EOC stats, he not using an EOC generated signature. The issue is the [ img ] link: http://mol.b2910.ftp.sh:8080/24396Hidde ... sSmall.php, which does resolve, but is not on a standard 80 port and, being a php file, is not an image file.

I can replicate the database error using any :8080 link (for example facebook.com:8080/index.php).

Moral of the story - use an image link with a standard :80 port and use an image file rather than a php page..?
Napoleon
Posts: 887
Joined: Wed May 26, 2010 2:31 pm
Hardware configuration: Atom330 (overclocked):
Windows 7 Ultimate 64bit
Intel Atom330 dualcore (4 HyperThreads)
NVidia GT430, core_15 work
2x2GB Kingston KVR1333D3N9K2/4G 1333MHz memory kit
Asus AT3IONT-I Deluxe motherboard
Location: Finland

Re: MySQL server has gone away?

Post by Napoleon »

The http://mol.b2910.ftp.sh:8080/24396Hidde ... sSmall.php link works for me. I'm browsing with Opera v12.02, no proxy configured.
Win7 64bit, FAH v7, OC'd
2C/4T Atom330 3x667MHz - GT430 2x832.5MHz - ION iGPU 3x466.7MHz
NaCl - Core_15 - display
bruce
Posts: 20824
Joined: Thu Nov 29, 2007 10:13 pm
Location: So. Cal.

Re: MySQL server has gone away?

Post by bruce »

k1wi wrote:
P5-133XL wrote:Perhaps this would be better addressed at the Extreme Overclocking forums where those folding signatures were created.
It looks like a forum generated error though?
It's A forum that's generating the message, but not an official FAH forum (Stanford). The URL you posted links to http://folding.extremeoverclocking.com and to http://mol.b2910.ftp.sh, neither of which belong to Stanford.
k1wi
Posts: 909
Joined: Tue Sep 22, 2009 10:48 pm

Re: MySQL server has gone away?

Post by k1wi »

bruce,

The error is being generated by foldingforum.org - I suspect because the forum's mysql server is unable to connect to a remote 8080 port, resulting in the time out error being returned to the forum software (phpBB).

Encapsulating any link that directs to an page/image/element served from the 8080 port within img tags in the user signature field in the ucp results in the error being generated by the foldingforum.org mysql server. Regardless of whether you wrap that in a URL link or not.

For example, you can try it yourself: if we were to substitute a F@H server in place of the one in the OP, the same result occurs. You can do this by encapsulating http://171.64.65.58 within img tags in the signature field. The return by the forum software is that "It was not possible to determine the dimensions of the image." That is fine, because that particular link is not a picture, it's just a page saying "OK". However, if we encapsulate http://171.64.65.58:8080 within img tags, it results in the error cited in the OP.

Furthermore, we can replicate the same result using an image file hosted on a websever that is using the 8080 port: http://torrents.freebsd.org:8080/files/ ... wnload.png (which is this image: Image) resolves in the browser if your firewall allows access to remote 8080 ports, (as does the OP's original image). However, encapsulating that image link within img tags in the signature field of the ucp results in the same mysql error as cited in the OP.

I haven't found one server using :8080 that the forum properly parses in this specific situation, using more than one internet gateway/ISP. So if it's not a foldingforum.org error then it's an error with the rest of the internet. It's certainly not an EOC error, so using their forums is not the right advice, and the only 'error' being made by the other link cited by the OP (http://mol.b2910.ftp.sh) is that it is only accessible using the 8080 port. I don't believe it is a fatal error being made by phpBB/mysql, because it's not to my knowledge bringing the foldingforum site down, it just means you can't add an image from a webserver that is using the 8080 port to your signature.

Therefore, when adding images to your signature, the following stands:
Moral of the story - use an image link with a standard :80 port
(I admit I was preemptive on the second half of the original quote, but it doesn't hurt to be overly cautious?).
bilde2910
Posts: 21
Joined: Sun Jan 22, 2012 1:28 pm
Hardware configuration: Manufacturer: Komplett A/S
Model: Komplett Gamer i05 - GTX 750Ti Edition (with changed parts)
OS: Windows 8.1 64-bit
CPU: Intel Core i3-4160 @ 3.60 GHz (not used for folding)
GPU: Sapphire Radeon R9 270 2GB GDDR5 (used for folding)
RAM: Crucial DDR3 BallistiX Sport 1600MHz 8GB
PSU: Cooler Master B600 VER.2, 600W PSU
DVD: ASUS DVD Writer, DRW-24F1ST
SSD: Kingston SSDNow V300 240GB 2.5" OEM
Motherboard: ASUS B85M-G, Socket-1150
Display: Samsung U28D590 @ 3840x2160p 60Hz
Location: Norway
Contact:

Re: MySQL server has gone away?

Post by bilde2910 »

Well, I don't see why phpBB wouldn't like an image embedded in IMG tags in a signature, there is no visible limits on the size one can use, so why would phpBB even check?
Also, if the forum software does not support non-:80-sites at all, wouldn't that be a serious flaw in the software? All major software packs are able to connect to :8080 ports. If I understood you correctly though, the forum has not been forwarded to be able to use :8080 ports. Would it be possible to upload a PHP somewhere that initially points to an image, and set that as the signature, and once that's done, rewrite the PHP to set the header to "Location: ...", making a redirect? I suppose that would work since the software checks the image dimensions on an image on a :80 server that is soon-to-be a redirect to a :8080 server?

I would hope it works with :8080 since on the web server I host the script, :80 was already taken.

Did I understand you correctly?

Sincerely yours,
- bilde2910
Image
k1wi
Posts: 909
Joined: Tue Sep 22, 2009 10:48 pm

Re: MySQL server has gone away?

Post by k1wi »

bilde2910 wrote:Well, I don't see why phpBB wouldn't like an image embedded in IMG tags in a signature, there is no visible limits on the size one can use, so why would phpBB even check?
I believe the forum software checks whether the image is less than 82 pixels high...
Your images may only be up to 82 pixels high
bilde2910
Posts: 21
Joined: Sun Jan 22, 2012 1:28 pm
Hardware configuration: Manufacturer: Komplett A/S
Model: Komplett Gamer i05 - GTX 750Ti Edition (with changed parts)
OS: Windows 8.1 64-bit
CPU: Intel Core i3-4160 @ 3.60 GHz (not used for folding)
GPU: Sapphire Radeon R9 270 2GB GDDR5 (used for folding)
RAM: Crucial DDR3 BallistiX Sport 1600MHz 8GB
PSU: Cooler Master B600 VER.2, 600W PSU
DVD: ASUS DVD Writer, DRW-24F1ST
SSD: Kingston SSDNow V300 240GB 2.5" OEM
Motherboard: ASUS B85M-G, Socket-1150
Display: Samsung U28D590 @ 3840x2160p 60Hz
Location: Norway
Contact:

Re: MySQL server has gone away?

Post by bilde2910 »

k1wi wrote:
bilde2910 wrote:Well, I don't see why phpBB wouldn't like an image embedded in IMG tags in a signature, there is no visible limits on the size one can use, so why would phpBB even check?
I believe the forum software checks whether the image is less than 82 pixels high...
Your images may only be up to 82 pixels high
Where does it say that images have to be up to 82 pixels high? I've had a hard time getting it down to 85, just a mere 3 pixels...
I also have a 40px-something image.
Image
bollix47
Posts: 2957
Joined: Sun Dec 02, 2007 5:04 am
Location: Canada

Re: MySQL server has gone away?

Post by bollix47 »

See Signatures/Avatars: in Forum Policies.
bilde2910
Posts: 21
Joined: Sun Jan 22, 2012 1:28 pm
Hardware configuration: Manufacturer: Komplett A/S
Model: Komplett Gamer i05 - GTX 750Ti Edition (with changed parts)
OS: Windows 8.1 64-bit
CPU: Intel Core i3-4160 @ 3.60 GHz (not used for folding)
GPU: Sapphire Radeon R9 270 2GB GDDR5 (used for folding)
RAM: Crucial DDR3 BallistiX Sport 1600MHz 8GB
PSU: Cooler Master B600 VER.2, 600W PSU
DVD: ASUS DVD Writer, DRW-24F1ST
SSD: Kingston SSDNow V300 240GB 2.5" OEM
Motherboard: ASUS B85M-G, Socket-1150
Display: Samsung U28D590 @ 3840x2160p 60Hz
Location: Norway
Contact:

Re: MySQL server has gone away?

Post by bilde2910 »

Ok, thanks, I found it.

By the way, I set up a forum on my own using phpBB 3.0.11 and was successfully able to use as a signature any image on a port-8080-site.
Is this forum using a different software (version) so this feature is not supported?

- bilde2910
Image
7im
Posts: 10179
Joined: Thu Nov 29, 2007 4:30 pm
Hardware configuration: Intel i7-4770K @ 4.5 GHz, 16 GB DDR3-2133 Corsair Vengence (black/red), EVGA GTX 760 @ 1200 MHz, on an Asus Maximus VI Hero MB (black/red), in a blacked out Antec P280 Tower, with a Xigmatek Night Hawk (black) HSF, Seasonic 760w Platinum (black case, sleeves, wires), 4 SilenX 120mm Case fans with silicon fan gaskets and silicon mounts (all black), a 512GB Samsung SSD (black), and a 2TB Black Western Digital HD (silver/black).
Location: Arizona
Contact:

Re: MySQL server has gone away?

Post by 7im »

It's likely this forum has many more security features enabled than the default phpBB settings to minimize spam, bots, etc. You'll need to work within the given contraints as they are not going to change.
How to provide enough information to get helpful support
Tell me and I forget. Teach me and I remember. Involve me and I learn.
bilde2910
Posts: 21
Joined: Sun Jan 22, 2012 1:28 pm
Hardware configuration: Manufacturer: Komplett A/S
Model: Komplett Gamer i05 - GTX 750Ti Edition (with changed parts)
OS: Windows 8.1 64-bit
CPU: Intel Core i3-4160 @ 3.60 GHz (not used for folding)
GPU: Sapphire Radeon R9 270 2GB GDDR5 (used for folding)
RAM: Crucial DDR3 BallistiX Sport 1600MHz 8GB
PSU: Cooler Master B600 VER.2, 600W PSU
DVD: ASUS DVD Writer, DRW-24F1ST
SSD: Kingston SSDNow V300 240GB 2.5" OEM
Motherboard: ASUS B85M-G, Socket-1150
Display: Samsung U28D590 @ 3840x2160p 60Hz
Location: Norway
Contact:

Re: MySQL server has gone away?

Post by bilde2910 »

7im wrote:It's likely this forum has many more security features enabled than the default phpBB settings to minimize spam, bots, etc. You'll need to work within the given contraints as they are not going to change.
I think I found a way; if I went to do as I did in my signature (create a little tweaked redirect hosted on a :80-server) would that be against the rules in any way? Should I delete it? (You can see the signature on my profile)
(It took me until now to actually find this solution)

- bilde2910?
Image
Post Reply